Gossamer Forum
(Advanced Search)
for
Home : General : Databases and SQL :

ALTER TABLE

Sep 19, 2002, 1:27 AM
Andy
Veteran / Moderator (17364 posts)
Andy's avatar
Sep 19, 2002, 1:27 AM
Post #1 of 2
Views: 2028
Shortcut
Quote Reply
ALTER TABLE
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;

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 Unsure

Cheers

Andy (mod)
andy@ultranerds.co.uk

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates
Sep 19, 2002, 2:01 AM
Andy
Veteran / Moderator (17364 posts)
Andy's avatar
Sep 19, 2002, 2:01 AM
Post #2 of 2
Views: 2003
Shortcut
Quote Reply
Re: [Andy] ALTER TABLE In reply to
Never mind...I forgot that it was my unique field, so therefore I couldn't have it as a TEXT field Wink

Andy (mod)
andy@ultranerds.co.uk

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates