Can anyone see anything wrong with this query?
ALTER TABLE lsql_PPC_Trans CHANGE Transaction_ID Transaction_ID TEXT(40) not null
I'm getting the following error;
MySQL said: You have an error in your SQL syntax near '(40) not null ' at line 1.
Query: ALTER TABLE lsql_PPC_Trans CHANGE Transaction_ID Transaction_ID TEXT(40) not null
BTW: This is being done via MySQLMan
Cheers
Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
ALTER TABLE lsql_PPC_Trans CHANGE Transaction_ID Transaction_ID TEXT(40) not null
I'm getting the following error;
Quote:
Error MySQL said: You have an error in your SQL syntax near '(40) not null ' at line 1.
Query: ALTER TABLE lsql_PPC_Trans CHANGE Transaction_ID Transaction_ID TEXT(40) not null
BTW: This is being done via MySQLMan
Cheers
Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!