按类别查询搜索结果
关于关键词 的检测结果,共 8
snowtty | 2016-12-28 22:34:36 | 阅读(420) | 评论(0)
http://wubx.net/21ways-optimize-mysql/comment-page-1/#comment-265【阅读全文】
snowtty | 2016-12-23 15:53:16 | 阅读(250) | 评论(0)
http://d.hatena.ne.jp/mk_1211/20121111/1352650864【阅读全文】
Barnett_3662 | 2016-02-03 12:01:49 | 阅读(340) | 评论(0)
执行报错: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命令...【阅读全文】
constantyy | 2014-06-03 14:09:18 | 阅读(370) | 评论(0)
ActivePerl DBI Pacage : "DBD-mysql" http://search.cpan.org/dist/DBD-mysql-4.022/#使用DBI 包use DBI;#连接databasemy $db = DBI->connect("DBI:mysql:$database:$hostname:$port",$user,$pw,{'RaiseError'=>1});#第三个参数指错误信息输出的\1#关闭连接$db->disconnect();...【阅读全文】
xi0ws | 2014-04-24 10:05:58 | 阅读(1120) | 评论(0)
MySql:点击(此处)折叠或打开# my $sth = $dbh->prepare("set character_set_results=utf8");# $sth->execute;SQL Server:1. 查询出SQL Server的编码格式点击(此处)折叠或打开SELECT COLLATIONPROPERTY('Chinese_PRC_Stroke_CI_AI_KS_WS',&n...【阅读全文】
Larpenteur | 2013-06-25 02:31:02 | 阅读(540) | 评论(0)
1. sql.txt中有多条sql语句,如下:点击(此处)折叠或打开SELECT * FROM TESTASELECT * FROM TESTBSELECT * FROM TESTCSELECT * FROM TESTDSELECT * FROM TESTESELECT * FROM TESTF2. perl脚本如下,执行的结...【阅读全文】
xi0ws | 2013-06-20 19:13:41 | 阅读(1270) | 评论(0)
1. sql.txt中有多条sql语句,如下:点击(此处)折叠或打开SELECT * FROM TESTASELECT * FROM TESTBSELECT * FROM TESTCSELECT * FROM TESTDSELECT * FROM TESTESELECT * FROM TESTF2. perl脚本如下,执行的结...【阅读全文】
bzcat | 2013-04-22 16:48:19 | 阅读(340) | 评论(0)
#!/usr/bin/perl -wuse Cache::Memcached;use DBI;use Digest::MD5 qw(md5 md5_hex);my $dbh = DBI->connect("DBI:mysql:database=test;host=localhost", "test", "test", {'RaiseError' => 1});    $dbh->do("set names utf8");    my $sth = $dbh->prepare($ARGV[0]);$memd =...【阅读全文】