At 9:02 -0800 7/16/03, Tim Johnson wrote:
Hello:
I'm using version 3.23.41.
How may I change the default value of
an existing table?
(type will remain the same)


   Pointers to docs are welcome and invited.
   thanks
   tim
--
Tim Johnson <[EMAIL PROTECTED]>
      http://www.alaska-internet-solutions.com
      http://www.johnsons-web.com

ALTER TABLE t ALTER col_name SET DEFAULT value;


http://www.mysql.com/doc/en/ALTER_TABLE.html

--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com

Are you MySQL certified? http://www.mysql.com/certification/


-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to