Galera sera que vcs podem me ajudar?
estou tentando executar o SQL file no Navicat 8
ele da esse erro:
sera q podem me ajudar?
estou tentando executar o SQL file no Navicat 8
ele da esse erro:
[Err] 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 'TYPE=MyISAM' at line 21
[Err] CREATE TABLE `account` (
`id` int(4) unsigned zerofill NOT NULL auto_increment,
`name` char(32) binary NOT NULL default '',
`sex` int(4) unsigned zerofill NOT NULL default '0000',
`age` int(4) unsigned zerofill NOT NULL default '0000',
`phone` char(16) binary NOT NULL default '',
`email` char(128) binary NOT NULL default '',
`address` char(128) binary NOT NULL default '',
`idnumber` char(32) binary NOT NULL default '',
`password` char(16) binary NOT NULL default '',
`type` int(4) unsigned zerofill NOT NULL default '0002',
`point` int(4) unsigned zerofill NOT NULL default '100000',
`pointtime` int(4) unsigned zerofill NOT NULL default '20021231',
`online` int(4) unsigned zerofill NOT NULL default '0000',
`licence` int(4) unsigned NOT NULL default '0',
`netbar_ip` char(15) default '127.0.0.1',
`ip_mask` char(15) default '255.255.255.255',
`VIP` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `ix_name` (`name`)
) TYPE=MyISAM;
[Msg] Finished - Unsuccessfully
--------------------------------------------------
sera q podem me ajudar?