gpt4 book ai didi

mysql - #1064 - 你的 SQL 语法有错误

转载 作者:行者123 更新时间:2023-11-30 23:55:23 25 4
gpt4 key购买 nike

<分区>

我正在尝试根据软件中的说明设置表格。这是我输入的:

CREATE TABLE `swd_account` (
`pk_account` int(11) NOT NULL auto_increment,
`name` char(16) NOT NULL default '',
`isact` tinyint(4) NOT NULL default '1',
PRIMARY KEY (`pk_account`)
) TYPE=MyISAM;

CREATE TABLE `swd_user` (
`pk_user` int(11) NOT NULL auto_increment,
`fk_account` int(11) NOT NULL default '0',
`email` varchar(40) NOT NULL default '',
`name` varchar(40) default NULL,
`isact` tinyint(4) NOT NULL default '1',
`datereg` date default NULL,
`days` tinyint(4) default '0',
`datelastsend` date default NULL,
`messlastsend` int(11) default NULL,
`countsend` int(11) NOT NULL default '0',
`undelivered` tinyint(4) default NULL,
PRIMARY KEY (`pk_user`),
KEY `fk_account` (`fk_account`,`email`,`isact`),
KEY `email` (`email`)
) TYPE=MyISAM;

这是我收到的消息:

Error
SQL query:

CREATE TABLE `swd_account` (

`pk_account` INT( 11 ) NOT NULL AUTO_INCREMENT ,
`name` CHAR( 16 ) NOT NULL DEFAULT '',
`isact` TINYINT( 4 ) NOT NULL DEFAULT '1',
PRIMARY KEY ( `pk_account` )
) TYPE = MYISAM ;

MySQL said:

#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 6

如有任何可能出错的建议,我们将不胜感激。

25 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com