MySQL synthax error
hi guys I 'm a beginner with MySQL, I want to create a map database using MySQL which can store and sent data (picture and coordinate) but when am writing my code;
mysql> use map info
Database changed
mysql> cretate table map_info (
-> country varachar (30),
-> regions varachar (30),
-> );
ERROR 1064 (42000): you have an error in your SQL syntax; check the manual that corresponds to your MySQL server, please can you help me ??
Greg K posted this at 22:23 — 27th May 2012.
He has: 2,145 posts
Joined: Nov 2003
Get rid of the comma at the end of the "Regions" line, that is telling mySQL that there is another field coming when there isn't one.
-Greg
RohanJaiswal posted this at 06:07 — 24th April 2013.
They have: 11 posts
Joined: Apr 2013
If you want to run your sgl command well in Mysql database always use semicolon at the end of statement for termination. and write the code in proper sequence
AVG free antivirus
features of the unix
Default operating system
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.