mysql problem "access violation"
Posted 12 May 2003 - 02:01 PM
A sample command is:
alter table `test`.`list` change `col1` `col1` TEXT(50) NULL;
The response I get is:
Syntax error or access violation: You have an error in your SQL syntax near \'(50) NULL\' at line 1
I don\'t think it\'s a syntax problem but is an \"access violation.\" Can anyone tell me where to look for the source of this problem? I checked my userid record in the user table of mysql and the privileges are all set to \"Y\".
Does anyone have an idea what is blocking me from creating blob or text fields? This is really driving me nuts and stopping me in my tracks!
Thanks in advance,
Posted 12 May 2003 - 05:05 PM
You should try \"TEXT\"
alter table `test`.`list` change `col1` `col1` TEXT NULL;I\'m sure this will work.
Posted 12 May 2003 - 05:44 PM
Thanks very much. That worked. As you can see I\'m new at this.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users