Posted by Frankly on 10/05/86 11:48

"Frankly" <NotReal@yahoo.com> wrote in message news:...
I have now created 4 almost 5 tables.

the ManagementBuildings table shows as 2 tables - I think that is because
of
2 primary keys?

I am now on the apartments table and for some reason I can not complete it.
I know the structure of the this and the other tables still needs to be
tuned - but why
this.. it didnt happen on any of my other tables :(

SQL query:

CREATE TABLE `Apartments` (

`ApartmentID` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`Rent` INT NOT NULL ,
`Bedrooms` INT NOT NULL ,
`ApartmentNumber` VARCHAR( 10 ) NOT NULL ,
`MoveInDate` DATE NOT NULL ,
`StillAvailable` ENUM NOT NULL ,
`ApartmentContact` CHAR( 20 ) NOT NULL ,<----- this is where the problem
is?.
`ApartmentPhone` VARCHAR( 12 ) NOT NULL ,
`Picture1` VARCHAR( 50 ) NOT NULL ,
`Picture2` VARCHAR( 50 ) NOT NULL ,
`Picture3` VARCHAR( 50 ) NOT NULL ,
INDEX ( `Rent` )
) TYPE = MYISAM

MySQL said:

#1064 - You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use near
'NOT NULL, `ApartmentContact` CHAR(20) NOT NULL, `ApartmentPhone

I have went to the web site and went over my tuturials. I have created and
recreated this table a few times and can not find out what is wrong.

[Back to original message]