I have a problem Importing Mysql issues.I import one value well and import the 2nd value by itself but when import more than one value it gives error.
I import this code(first value) well;
or second value well;Code:INSERT INTO `jos_ezrealty_country` (`id`, `name`, `published`, `checked_out`, `checked_out_time`, `editor`, `ordering`) VALUES ('5', 'AKSARAY', '1', '0', '0000-00-00 00:00:00', 'NULL', '77')
But when import two value it gives error;Code:INSERT INTO `jos_ezrealty_country` (`id`, `name`, `published`, `checked_out`, `checked_out_time`, `editor`, `ordering`) VALUES ('6', 'AMASYA', '1', '0', '0000-00-00 00:00:00', 'NULL', '76')
Error this;Code:INSERT INTO `jos_ezrealty_country` (`id`, `name`, `published`, `checked_out`, `checked_out_time`, `editor`, `ordering`) VALUES ('5', 'AKSARAY', '1', '0', '0000-00-00 00:00:00', 'NULL', '77') ('6', 'AMASYA', '1', '0', '0000-00-00 00:00:00', 'NULL', '76')
#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 '('6', 'AMASYA', '1', '0', '0000-00-00 00:00:00', 'NULL', '76')' at line 3
What is the solution please![]()



Reply With Quote
Bookmarks