UC知道mysql 1064 大家帮忙，实在是看不出什么问题了
来源：百度知道 编辑：UC知道 时间：2024/05/17 22:40:11
SQL: SELECT * FROM photo WHERE mid IN ('18,29,30') AND mod=1
Error: 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 '=1' at line 1
Errno.: 1064
表结构
CREATE TABLE IF NOT EXISTS `yemo_photo` (
`picid` mediumint(8) NOT NULL auto_increment,
`mid` mediumint(8) unsigned NOT NULL default '0',
`mod` tinyint(1) unsigned NOT NULL,
`uid` mediumint(8) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
`postip` char(20) NOT NULL default '',
`filename` char(100) NOT NULL default '',
`title` char(150) NOT NULL default '',
`type` char(20) NOT NULL default '',
`size` int(10) unsigned NOT NULL default '0',
`filepath` char(60) NOT NULL default '',
`thumb` tinyint(1) NOT NULL default '0&#
Error: 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 '=1' at line 1
Errno.: 1064
表结构
CREATE TABLE IF NOT EXISTS `yemo_photo` (
`picid` mediumint(8) NOT NULL auto_increment,
`mid` mediumint(8) unsigned NOT NULL default '0',
`mod` tinyint(1) unsigned NOT NULL,
`uid` mediumint(8) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
`postip` char(20) NOT NULL default '',
`filename` char(100) NOT NULL default '',
`title` char(150) NOT NULL default '',
`type` char(20) NOT NULL default '',
`size` int(10) unsigned NOT NULL default '0',
`filepath` char(60) NOT NULL default '',
`thumb` tinyint(1) NOT NULL default '0&#
mid IN ('18,29,30')
这儿好像错了吧
改成mid IN ('18','29','30')
如果是int型则把引号去了
好像是逻辑错误吧
mid要么等于in中的值，要么就等于1，你在中间加一个and，那这个语句就永远不会成立了呀