hello everyone,
Please can someone help me fix this problem:
#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 'INSERT DELAYED INTO `jos_country` (`id`, `cty_name_20`, `cty_name_25`, `cty_name' at line 25
here is my sql:
Please can someone help me fix this problem:
#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 'INSERT DELAYED INTO `jos_country` (`id`, `cty_name_20`, `cty_name_25`, `cty_name' at line 25
here is my sql:
Code:
CREATE TABLE IF NOT EXISTS `jos_country`( `id` INTEGER unsigned NOT NULL auto_increment, `cty_name_20` varchar(20) NOT NULL, `cty_name_25` varchar(25) NOT NULL, `cty_name_30` varchar(30) NOT NULL, `cty_name_100` varchar(100) NOT NULL, `cty_common_name_20` varchar(20) NOT NULL, `cty_iso_3166_2` varchar(2) NOT NULL, `cty_iso_3166_3` varchar(3) NOT NULL, `cty_continent` varchar(15) NOT NULL default '', `cty_has_states` varchar(10) NOT NULL default '', `cty_has_postal_codes` varchar(7) NOT NULL default 'Unknown', `cty_postal_code_format_javascript` text NOT NULL default '', `cty_phone_number_format_javascript` text NOT NULL default '', `cty_SSN_format_javascript` text NOT NULL default '', PRIMARY KEY(`id`), UNIQUE KEY `cty_iso_3166_2` (`cty_iso_3166_2`), UNIQUE KEY `cty_iso_3166_3` (`cty_iso_3166_3`), KEY `cty_name_20` (`cty_name_20`), KEY `cty_name_25` (`cty_name_25`), KEY `cty_name_30` (`cty_name_30`), KEY `cty_name_100` (`cty_name_100`) ) INSERT DELAYED INTO `jos_country` (`id`, `cty_name_20`, `cty_name_25`, `cty_name_30`, `cty_name_100`, `cty_common_name_20`, `cty_iso_3166_2`, `cty_iso_3166_3`, `cty_continent`, `cty_has_states`, `cty_has_postal_codes`, `cty_postal_code_format_javascript`, `cty_phone_number_format_javascript`, `cty_SSN_format_javascript`) VALUES (1, 'Aruba', 'Aruba', 'Aruba', 'Aruba', 'Aruba', 'AW', 'ABW', 'North America', '', 'Unknown', '', '', ''), (2, 'Afghanistan', 'Afghanistan', 'Afghanistan', 'Afghanistan', 'Afghanistan', 'AF', 'AFG', 'Asia', '', 'Unknown', '', '', ''), (3, 'Angola', 'Angola', 'Angola', 'Angola', 'Angola', 'AO', 'AGO', 'Africa', '', 'Unknown', '', '', ''), (4, 'Anguilla', 'Anguilla', 'Anguilla', 'Anguilla', 'Anguilla', 'AI', 'AIA', 'North America', '', 'Unknown', '', '', ''), (5, 'Åland Islands', 'Åland Islands', 'Åland Islands', 'Åland Islands', 'Åland Islands', 'AX', 'ALA', 'Europe', '', 'Unknown', '', '', ''), (6, 'Albania', 'Albania', 'Albania', 'Albania', 'Albania', 'AL', 'ALB', 'Europe', '', 'Unknown', '', '', ''), (7, 'Andorra', 'Andorra', 'Andorra', 'Andorra', 'Andorra', 'AD', 'AND', 'Europe', '', 'Unknown', '', '', '') ........
Comment