关于query的一些问题.

fjctlzy

sql = "INSERT INTO event_term (EventID,Term,Count,Weight) VALUES('1','酒','7','1006');
INSERT INTO event_term (EventID,Term,Count,Weight)VALUES ('1','酒吧','11','1010');
INSERT INTO event_term(EventID,Term,Count,Weight) VALUES ('1','精彩','2','1001');"

这段string用$this->db->query($sql); 提示
                A Database Error Occurred                Error Number: 1064
Youhave an error in your SQL syntax; check the manual that corresponds toyour MySQL server version for the right syntax to use near 'INSERT INTOevent_term (EventID,Term,Count,Weight) VALUES ('1','酒吧','11','10' atline 1
INSERT INTO event_term (EventID,Term,Count,Weight) VALUES('1','酒','7','1006');INSERT INTO event_term (EventID,Term,Count,Weight)VALUES ('1','酒吧','11','1010');INSERT INTO event_term(EventID,Term,Count,Weight) VALUES ('1','精彩','2','1001');

fjctlzy

我用phpmyadmin插入没有问题.

Hex

CI 一次只能写一条 sql 吧。

fjctlzy

这个让人很郁闷....

Hex

一个循环和一次多条语句有本质区别吗？

liugehao

mysql区别应该不太大，支持事务的数据库就不一样了

neversaylate

sql只能是一个语句。下面附上源码中的注释。

PHP复制代码

 
/**
 |       * Execute the query
 |       *
 |       * Accepts an SQL string as input and returns a result object upon
 |       * successful execution of a "read" type query.  Returns boolean TRUE
 |       * upon successful execution of a "write" type query. Returns boolean
 |       * FALSE upon failure, and if the $db_debug variable is set to TRUE
 |       * will raise an error.
 |       *
 |       * @access  public
 |       * @param   string  An SQL query string
 |       * @param   array   An array of binding data
 |       * @return  mixed      
 |       */
function query($sql, $binds = FALSE, $return_object = TRUE)
{
//...
}

复制代码