执行报错:DBD::mysql::st execute failed: Illegal mix of collations (gb2312_chinese_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation '=' at ./mysql_check.pl line 12.一看发现是编码问题解决办法:$dbh->do("set names utf8;"); #插入此行my $sth = $dbh->do(含有中文字符的sql命令...【阅读全文】
1. sql.txt中有多条sql语句,如下:点击(此处)折叠或打开SELECT * FROM TESTASELECT * FROM TESTBSELECT * FROM TESTCSELECT * FROM TESTDSELECT * FROM TESTESELECT * FROM TESTF2. perl脚本如下,执行的结...【阅读全文】
1. sql.txt中有多条sql语句,如下:点击(此处)折叠或打开SELECT * FROM TESTASELECT * FROM TESTBSELECT * FROM TESTCSELECT * FROM TESTDSELECT * FROM TESTESELECT * FROM TESTF2. perl脚本如下,执行的结...【阅读全文】