|
Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com |
ALTER table syntax
From: Andris Spruds (litrema
apollo.lv)
Date: Sun Feb 29 2004 - 13:36:56 CST
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Hello,
I have a created a NOT NULL column with datatype DATE. Now, I have changed
my mind and I would like to store NULLs in it. It tried executing 'ALTER
TABLE mytable MODIFY COLUMN mycolumn DATE NULL', but MaxDB still refuses to
accept null as a value for the column. I can of course create a new column
without NOT NULL, and then copy the contents, but that seems not the right
way. What's the correct syntax? Any hints would be welcome / appreciated!
Best regards,
Andris Spruds
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]