Schema Challenge…
Posted: Mon Jun 09, 2003 4:37 am
In my schema folder, I have a file named realestate.sql
That file contains the following code:
At the prompt (bash-2.03$), I type source realestate.sql and get the following errors:
Any help on what I am doing wrong or where to find information regarding my mistake is appreciated. I am not certain what version of MYSQL I am running.
Thanks!
That file contains the following code:
Code: Select all
create table realestate (
ID int(11) not null auto_increment,
Created int(11),
Expires int(11),
AuthorID varchar(32),
Category int(11),
Category2 int(11),
Category3 int(11),
object MEDIUMBLOB,
primary key (ID)
);
create table realservices (
ID int(11) not null auto_increment,
Created int(11),
Expires int(11),
AuthorID varchar(32),
Category int(11),
Category2 int(11),
Category3 int(11),
object MEDIUMBLOB,
primary key (ID)
);Code: Select all
bash: realestate.sql: line 1: syntax error near unexpected token `(‘
bash: realestate.sql: line 1: `create table realestate (‘Thanks!