I think I really misunderstood the directions for alter table, an I'm
not sure how to fix this.  I was trying to allow certain columns to be
null in an existing table.
I used the following syntax:
  ALTER TABLE users ALTER COLUMN title SET DEFAULT NULL;
Now 'describe users;' shows extra columns with no titles.
A.  What did that syntax do?
B.  How do I undo it?
C.  What is the proper syntax?




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

Reply via email to