[Tekton]

PROBLEM SOLVED - Must use `21398` thingies around numbers.

<> <> <>
Invalid SQL: ALTER TABLE testtable
ADD test int(10) unsigned DEFAULT '0' NOT NULL

mysql error: 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 'test int(10) unsigned DEFAULT '0' NOT NULL' at line 2

mysql error number: 1064

( MySQL 4.0.20 )

__________

On smaller code:

Invalid SQL: ALTER TABLE testtable ADD test int(10)
mysql error: 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 'test int(10)' at line 1
_____________

UPDATE - Errors on normal SQL in phpmyadmin too... Can anyone just try it for the heck of it?

Error: 1064 SQLSTATE: 42000 (ER_PARSE_ERROR) Message: %s near '%s' at line %d

It works with 'test' as a name, but I guess you can't use numbers as a structure name?

_______________

MORE - If you put `these_things` around numbers it works in SQL