|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
|
error 1064 syntax error
can some tell me why i can not join this table, this has been driving me crazy.
CREATE TABLE `state` ( `id` int(11) NOT NULL auto_increment, `state` varchar(4) NOT NULL default '', `state_name` varchar(12) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=InnoDB; =========== CREATE TABLE `company` ( `id` int(11) NOT NULL auto_increment, `company_name` varchar(40) NOT NULL default '', `comp_add1` varchar(40) NOT NULL default '', `comp_add2` varchar(40) default NULL, `comp_city` varchar(20) NOT NULL default '', `comp_zip` tinyint(4) NOT NULL default '0', `comp_balance` decimal(2,0) default NULL, `state_id` int(11) NOT NULL default '0', PRIMARY KEY (`id`), KEY `state_id` (`state_id`), CONSTRAINT `company_ibfk_1` FOREIGN KEY (`state_id`) REFERENCES `state` (`id`) ON UPDATE CASCADE ) TYPE=InnoDB; ========= CREATE TABLE `customer` ( `Id` int(11) NOT NULL auto_increment, `cust_fname` varchar(100) NOT NULL default '', `cust_lname` varchar(100) NOT NULL default '', `state_id` int(11) NOT NULL default '0', PRIMARY KEY (`Id`), KEY `state_id` (`state_id`) CONSTRAINT `company_ibfk_2` FOREIGN KEY (`state_id`) REFERENCES `state` (`id`) ON UPDATE CASCADE ) TYPE=InnoDB; I can can not get the customer table to connect to the states table. |
![]() |
| Viewing: Dev Articles Community Forums > Databases > MySQL Development > error 1064 syntax error |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|