错误SQL 查询: MySQL 返回：#1064 - You have an error in your SQL syntax;
`id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
`user` VARCHAR( 255 ) DEFAULT NULL COMMENT '帐号',
`password` VARCHAR( 255 ) DEFAULT NULL COMMENT '密码',
`mode` VARCHAR( 10 ) DEFAULT NULL COMMENT '认证模式 根据认证表ID 注册认证，手机认证，qq认证，微博认证等',
`shopid` INT( 11 ) DEFAULT NULL COMMENT '帐号ID',
`routeid` INT( 11 ) DEFAULT NULL COMMENT '路由ID',
`token` VARCHAR( 100 ) DEFAULT NULL COMMENT '使用口令',
`phone` VARCHAR( 255 ) DEFAULT NULL ,
`qq` VARCHAR( 255 ) DEFAULT NULL ,
`mac` VARCHAR( 255 ) DEFAULT NULL COMMENT 'mac地址',
`login_time` VARCHAR( 30 ) DEFAULT NULL COMMENT '路由登录时间',
`login_count` INT( 11 ) DEFAULT '0' COMMENT '路由登录次数',
`login_ip` VARCHAR( 50 ) DEFAULT NULL ,
`add_time` VARCHAR( 255 ) DEFAULT NULL ,
`update_time` VARCHAR( 255 ) DEFAULT NULL ,
`browser` VARCHAR( 255 ) DEFAULT NULL ,
`online_time` VARCHAR( 255 ) DEFAULT NULL COMMENT '在线有效期',
`add_date` VARCHAR( 50 ) DEFAULT NULL ,
PRIMARY KEY ( `id` ) ,
KEY `index_token` ( `token` ) USING BTREE,
KEY `index_shop` ( `shopid` ) USING BTREE,
) ENGINE = MYISAM DEFAULT CHARSET = utf8 AUTO_INCREMENT =1
MySQL 返回：#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 'USING BTREE,
KEY `index_shop` ( `shopid` ) USING BTREE,
) ENGINE = MYISAM DE' at line 22
最新回答
避而不谈
2025-06-26 09:01:14
改成 key `index_token` USING BTREE ( `token` )
KEY `index_shop` ( `shopid` ) USING BTREE,
改成 KEY `index_shop` USING BTREE ( `shopid` ) ,
热门标签
