Results 1 to 2 of 2
Jun 28, 2007, 12:21 #1
- Join Date
- May 2007
- 0 Post(s)
- 0 Thread(s)
CREATE TABLE ... REFERENCE problemCode:
CREATE TABLE meeting_primary ( meeting_id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY (meeting_id), meeting_title VARCHAR (150) NOT NULL, meeting_title_sub VARCHAR (150), #Sub-title for meeting location_venue VARCHAR (50), location_city VARCHAR (25), location_state VARCHAR (25), location_country VARCHAR (25), date_start DATE NOT NULL, #Event must have a DATE date_end DATE )ENGINE = InnoDB; CREATE TABLE meeting_info ( meeting_id INT NOT NULL, child_id INT NOT NULL, PRIMARY KEY (meeting_id, child_id), FOREIGN KEY meeting_id REFERENCES meeting_primary (meeting_id) ON DELETE CASCADE info_intro TEXT, info_focus TEXT, info_audience TEXT, info_structure TEXT, #Brief description of agenda info_topics TEXT, info_stcomm TEXT, #Steering committee info_sponsors TEXT, info_reg TEXT, info_contact TEXT ...
Anyway what i m trying to do is to create one table (meeting_primary) for the basic meeting info's. And then another table for the detailed descriptions (about 10 TEXT columns).
When people view these information on the webpage (under construction ), data's in the 2 tables will be combined together and displayed on one page.
So I assume a simple table reference might do the trick.
However when i run the code through my little phpmyadmin (hosted on a little VPS i own personally), it displays an error.
#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 'REFERENCES meeting_primary (meeting_id) ON DELETE CASCADE info_intro T' at line 6
Jun 28, 2007, 17:31 #2
- Join Date
- Jul 2002
- Toronto, Canada
- 63 Post(s)
- 3 Thread(s)
you've got the syntax slightly wrong
the correct syntax is[CONSTRAINT [symbol]] FOREIGN KEYyou're trying to designate the foreign key with
[index_name] (index_col_name,...) [reference_definition]
... FOREIGN KEY meeting_id REFERENCES ...
so meeting_id is the name of the key, and you've omitted the parenthesized list of columns that make up the key
try like this --
... FOREIGN KEY my_FK ( meeting_id ) REFERENCES ...