I can create tables and perform alterations just fine. However, if I try to specify a DEFAULT value in either CREATE TABLE or ALTER TABLE, it craps out on me. For example, this works....
ALTER TABLE phpbb_mytable ALTER COLUMN LastName TEXT(40) ...but this doesn't.... ALTER TABLE phpbb_mytable ALTER COLUMN LastName TEXT(40) DEFAULT Unknown ...even though I believe this is the correct syntax. Same thing happens for CREATE TABLE. Help!!! Thanks, -Nuttzy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php