SET @chSql = 'update table2 set c2=100 where c1=1';
PREPARE st FROM @chSql;
EXECUTE st;
DEALLOCATE PREPARE st;
SET @nRow = ROW_COUNT();
SELECT @nRow;
而这样肯定是没有问题的
update table2 set c2=100 where c1=1;
SET @nRow = ROW_COUNT();
SELECT @nRow;
求教该怎么整合适呢?
...全文
552打赏收藏
再问个关于mysql预处理prepare的问题
如以下,我在预处理中有 update,delete语句,我想知道预处理时的row_count,但是下面是错误的,@nRow=-1 SET @chSql = 'update table2 set c2=100 where c1=1'; PREPARE st FROM @chSql; EXECUTE st; DEALLOCATE PREPARE st; SET @nRow = ROW_COUNT(); SELECT @nRow; 而这样肯定是没有问题的 update table2 set c2=10