|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
|
|||
|
|||
|
Table trouble
I'm setting up a table in MYSQL and I get an error at the closing bracket. I followed the text book and I don't understand why or how to fix it. I'll include my code. Thanks in advance for your help.
mysql> CREATE TABLE joke ( -> joke_id MEDIUMINT(5) DEFAULT '0' NOT NULL AUTO_INCREMENT, -> joke_question MEDIUMTEXT NOT NULL, -> joke_answer MEDIUMTEXT NOT NULL, -> joke_date DATE, -> PRIMARY KEY (joke_id), -> ); ERROR 1064: You have an error in your SQL syntax near ')' at line 7 mysql> |
|
#2
|
|||
|
|||
|
RE: Table trouble
Remove the comma after "PRIMARY KEY (joke_id)"
|
![]() |
| Viewing: Codewalkers Forums > Other Technologies > Database Help > Table trouble |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|
|
|