Gossamer Forum: General: Databases and SQL: ALTER TABLE

Gossamer Threads

Home : General : Databases and SQL :

ALTER TABLE

Sep 19, 2002, 1:27 AM

Andy

Veteran / Moderator (18441 posts)

Sep 19, 2002, 1:27 AM

Post #1 of 2

Shortcut

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

Sep 19, 2002, 2:01 AM

Andy

Veteran / Moderator (18441 posts)

Sep 19, 2002, 2:01 AM

Post #2 of 2

Shortcut

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

Gossamer Threads is a Vancouver-based company with over 28 years experience in web technology. From development to hosting, we partner with leading organizations around the globe and help to build their web presences, strategies and infrastructures.

Let’s talk: 1-877-715-7676