#1064 error when importing database

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • fakhreddine
    New Member
    • Apr 2012
    • 1

    #1064 error when importing database

    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:
    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', '', '', '')
    ........
    Last edited by Niheel; Apr 27 '12, 06:26 PM.
  • Luuk
    Recognized Expert Top Contributor
    • Mar 2012
    • 1043

    #2
    semi-colon ';' is missing at line 23

    Comment

    Working...