May 9th, 2005, 12:41 AM
|
|
Contributing User
|
|
Join Date: May 2005
Posts: 39
Time spent in forums: 7 h 14 m 30 sec
Reputation Power: 4
|
|
|
What's wrong with this
Code:
CREATE TABLE `hotspot` ( `IDNum` ENUM( 1000000 ) UNSIGNED ZEROFILL AUTO_INCREMENT ,
`HotSpotName` TEXT NOT NULL ,
`Address` TEXT NOT NULL ,
`AddressLine2` TEXT NOT NULL ,
`City` TEXT NOT NULL ,
`State` TEXT NOT NULL ,
`Postal` TEXT NOT NULL ,
`Country` TEXT NOT NULL ,
`Provider1` TEXT NOT NULL ,
`SSID` TEXT NOT NULL ,
`Provider2` TEXT NOT NULL ,
`Provider3` TEXT NOT NULL ,
`Provider4` TEXT NOT NULL ,
PRIMARY KEY ( `IDNum` ) ,
INDEX ( `Postal` )
) TYPE = MYISAM
I am trying to create a table that will autonumber and contain these text fields, that's it, nothing special
Nevermind I got it
Last edited by bulldog1256 : May 9th, 2005 at 08:59 AM.
Reason: I got it
|
ASP Free Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
