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_increment,
-> Name varchar(30) not null ,
-> Object1 varchar(60),
-> Object2 varchar(60),
-> Object3 varchar(60),
-> Comment text,
-> primary key (id),
-> unique(Name));


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

Reply via email to