[gengar003]

05-27-03 at 02:46 AM filburt1 said this in Post #2
TINYINT is a datatype like long, int, String, etc.
NULL means literally "nothing."

[sql]
ALTER TABLE user ADD yourfield TINYINT(1) NOT NULL DEFAULT 0;
[/sql]

I'm trying to run that query, but I get this error:

Error

SQL-query :
[sql]

ALTER TABLE user ADD yourfield TINYINT( 1 ) NOT NULL DEFAULT0
[/sql]
MySQL said:


You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT0' at line 1