|
|
Posted by Frankly on 10/13/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.
Navigation:
[Reply to this message]
|