hi
just to say thanks for your help.
it appears my problems were caused by different versions of myql. apparently
UNIQUE command was introduced in MYSQL3.23 and my server is running
MYSQL3.22.25
the code that worked in the end was:
mysql> create table saveMovie (
-> id int not null auto_incr
thanks for that
i tried doing that (\u mydatabasename;) but same results:
ERROR 2006: MySQL server has gone away
No connection. Trying to reconnect...
Connection id:937749
Current database: databasename
ERROR 2000: You have an error in your SQL syntax near 'unique,
Object1 varchar(60),
Obje
hi
i'm totally new to this so you'll have to forgive these questions if they
are really basic.
the situation with my server is that i have a user name that is associated
with a mysql database
i logged in (after telnetting in) as the user using:
mysql -u username -p
i then entered my password
