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),
Object2 varchar(60),
Object3 varchar(60),
Comment t' at line 3
is it me? or is there a problem with the mysql server on my server?
thanks very much
toby
-----Original Message-----
From: Jay Fesco [mailto:[EMAIL PROTECTED]]
Sent: 13 September 2001 15:06
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: errors 2006 and 2000
>
> create table saveMovie (
> -> id int not null auto_increment,
You attempted to create a table without telling MySQL which database to use
(or without creating a database in the first place). Either:
\u MyDatabaseName
-OR-
create database MyDatabaseName;
\u MyDatabaseName;
before trying to create a table.
Jay Fesco
Magical Mystery Words: database,sql,query,table
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php