使用execute方法执行删除时报错

浏览:1361 发布日期:2018/05/01 分类:求助交流 关键字: execute 报错 delete sql mysql
$a=M()->execute("DELETE FROM ding_finish WHERE jobid IN (SELECT id FROM ding_job WHERE talkid='".$_POST['id']."')");

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 1
错误位置
FILE: D:\xampp\htdocs\Ding_server\ThinkPHP\Library\Think\Db\Driver.class.php  LINE: 217

TRACE
#0 D:\xampp\htdocs\Ding_server\ThinkPHP\Library\Think\Db\Driver.class.php(217): PDOStatement->execute()
#1 D:\xampp\htdocs\Ding_server\ThinkPHP\Library\Think\Db\Driver.class.php(922): Think\Db\Driver->execute('DELETE FROM `di...', false)
#2 D:\xampp\htdocs\Ding_server\ThinkPHP\Library\Think\Model.class.php(518): Think\Db\Driver->delete(Array)
#3 D:\xampp\htdocs\Ding_server\Apps\Home\Controller\IndexController.class.php(260): Think\Model->delete()
#4 [internal function]: Home\Controller\IndexController->deletetalk()
#5 D:\xampp\htdocs\Ding_server\ThinkPHP\Library\Think\App.class.php(164): ReflectionMethod->invoke(object(Home\Controller\IndexController))
#6 D:\xampp\htdocs\Ding_server\ThinkPHP\Library\Think\App.class.php(202): Think\App::exec()
#7 D:\xampp\htdocs\Ding_server\ThinkPHP\Library\Think\Think.class.php(120): Think\App::run()
#8 D:\xampp\htdocs\Ding_server\ThinkPHP\ThinkPHP.php(97): Think\Think::start()
#9 D:\xampp\htdocs\Ding_server\index.php(29): require('D:\\xampp\\htdocs...')
#10 {main}




[ 2018-05-01T18:57:56+08:00 ] ::1 /Ding_server/index.php?m=Home&c=Index&a=deletetalk
INFO: [ app_init ] --START--
INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000006s ]
INFO: [ app_init ] --END-- [ RunTime:0.000213s ]
INFO: [ app_begin ] --START--
INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000374s ]
INFO: [ app_begin ] --END-- [ RunTime:0.000399s ]
NOTIC: [8] Undefined index: id D:\xampp\htdocs\Ding_server\Apps\Home\Controller\IndexController.class.php 第 259 行.
ERR: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 1

最佳答案
评论( 相关
后面还有条评论,点击查看>>