fallacy 发表于 2013-4-21 12:09:17

使用CI怎么样简单完成这样的SQL语句呢?

UPDATE `cms`.`demo` SET `value` = '管理系统' WHERE `demo`.`id` =1 LIMIT 1 ;
UPDATE `cms`.`demo` SET `value` = 'xxx@sina.com' WHERE `demo`.`id` =2 LIMIT 1 ;
UPDATE `cms`.`demo` SET `value` = '啊啊啊' WHERE `demo`.`id` =3 LIMIT 1 ;
UPDATE `cms`.`demo` SET `value` = 'uploads' WHERE `demo`.`id` =4 LIMIT 1 ;
UPDATE `cms`.`demo` SET `value` = 'backupdata' WHERE `demo`.`id` =5 LIMIT 1 ;
UPDATE `cms`.`demo` SET `value` = '1' WHERE `demo`.`id` =6 LIMIT 1 ;
UPDATE `cms`.`demo` SET `value` = '1' WHERE `demo`.`id` =7 LIMIT 1 ;
UPDATE `cms`.`demo` SET `value` = '1' WHERE `demo`.`id` =8 LIMIT 1 ;


简单来说,效果就是dedecms的那个系统基本参数的设置,点一次修改,这些信息全改了....

曜日晨阳 发表于 2013-4-21 13:17:43


页: [1]
查看完整版本: 使用CI怎么样简单完成这样的SQL语句呢?