Hello,
I am trying to migrate sql file from one computer to another computer. And while trying to import the sql file these error appears why is it? I am trying to migrate sql from Joomla.
Pencarian SQL:
nafqc_usergroups
CREATE TABLE IF NOT EXISTS nafqc_usergroups
(
id
int( 10 ) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key',parent_id
int( 10 ) unsigned NOT NULL DEFAULT '0' COMMENT 'Adjacency List Reference Id',lft
int( 11 ) NOT NULL DEFAULT '0' COMMENT 'Nested set lft.',rgt
int( 11 ) NOT NULL DEFAULT '0' COMMENT 'Nested set rgt.',title
varchar( 100 ) NOT NULL DEFAULT '',
PRIMARY KEY ( id
) ,
UNIQUE KEY idx_usergroup_parent_title_lookup
( parent_id
, title
) ,
KEY idx_usergroup_title_lookup
( title
) ,
KEY idx_usergroup_adjacency_lookup
( parent_id
) ,
KEY idx_usergroup_nested_set_lookup
( lft
, rgt
) USING BTREE) ENGINE = InnoDB DEFAULT CHARSET = utf8 AUTO_INCREMENT =13;
MySQL menyatakan:
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=13' at line 17