Re: syntax error on create

2004-04-12 Thread Victoria Reznichenko
"warwick mayson" <[EMAIL PROTECTED]> wrote: > > I am new to mysql and have a create script that when sourced throws a syntax error. > > The script : > > CREATE TABLE employee ( > id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, > name VARCHAR(255) NOT NULL, > PRIMARY KEY(id) > ) > TYPE=InnoDB; >

syntax error on create

2004-04-10 Thread warwick mayson
hi I am new to mysql and have a create script that when sourced throws a syntax error. The script : CREATE TABLE employee ( id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, name VARCHAR(255) NOT NULL, PRIMARY KEY(id) ) TYPE=InnoDB; CREATE TABLE position ( id INTEGER UNSIGNED NOT NULL AUTO