--- [EMAIL PROTECTED] wrote:
> hi,
>
> in the script you have
> " CONSTRAINT `0_132` FOREIGN KEY ( `SCode` )
> REFERENCES
> `statesarticles` ( `SCode` ) ON UPDATE CASCADE "
> and this code it's a definition of the foreign key.
> run the script without this part of the code.
* * * * * * * * * *
Thank you. So I can just create a table online by
pasting the code into a query window, right?
I've never done this before, and I'm not sure what the
first step is. Should I choose "Query," or the small
pop-up "Query Window"?
I've been playing with both. Sometimes my experiment
goes nowhere, and other times I get an error message
related to the last line.
Below is a copy of what I pasted in.
Thanks.
CREATE TABLE `counties` (
`SCode` varchar( 6 ) NOT NULL default '',
`NameC` varchar( 255 ) default NULL ,
`TypeC` varchar( 255 ) default NULL ,
`Seat` varchar( 255 ) default NULL ,
`Area_MI` decimal( 10, 1 ) default NULL ,
`Area_KM` decimal( 10, 1 ) default NULL ,
`Pop_2000` int( 10 ) default NULL ,
`Pop_1990` int( 10 ) default NULL ,
`Pop_MI` decimal( 10, 1 ) default NULL ,
`Pop_KM` decimal( 10, 1 ) default NULL ,
`Race1` int( 10 ) default NULL ,
`Race2` int( 10 ) default NULL ,
`Amerindian` int( 10 ) default NULL ,
`White` int( 10 ) default NULL ,
`Black` int( 10 ) default NULL ,
`Asian` int( 10 ) default NULL ,
`Pacific_Island` int( 6 ) default NULL ,
`Some_Other_Race` int( 10 ) default NULL ,
`Hispanic` int( 10 ) default NULL ,
`id` int( 6 ) NOT NULL AUTO_INCREMENT ,
PRIMARY KEY ( `id` ) ,
KEY `SCode` ( `SCode` ) ,
) TYPE = InnoDB PACK_KEYS =0 AUTO_INCREMENT =3143
__________________________________
Do you Yahoo!?
The all-new My Yahoo! - What will yours do?
http://my.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
