ITPub博客

执行该语句报错：update remoteorder t set  t.greetings = 'Hope's' where t.orderid = 1640000 and t.greetings is null;采用转义字符解决：update remoteorder t set  t.greetings = 'Hope\'s' where t.orderid = 1640000 and t.greetings is null;MySql字符转义 在字符串中，某些序...

mysql慢查询日志分割：MySQL本省提供了一个rotate的参考配置文件，在mysql安装目录下的support-files目录里，文件名为mysql-log-rotate把mysql-log-rotate从/opt/mysql3306/support-files拷贝至/etc/logrotate.d目录下，修改其内容为：[root@dbtest1 logrotate.d]# vi mysql-log-rotate # The log file name and...

Converting MySQL to PostgreSQLA Wikibookian suggests that this book or chapter be merged into SQL Dialects Reference.Please discuss whether or not this merge should happen on the discussion ...

实验：lower_case_table_names=0mysql> show variables like 'lower%';+------------------------+-------+| Variable_name          | Value |+------------------------+-------+| lower_case_file_system | OFF   || lower_case_table_names | 0     |+--------------...

PG-Mysql对象迁移：1.采用ODBC驱动来连接PG，正常可以看到sequence和database等，database、table,sequence要选中2.创建一个物理模型：File->New Model->Physical Date Model3.创建一个ODBC连接：驱动前面装过4.反转物理模式：File->Reverse enginees->database5.断开连接：Database-Disconnect6.修改数据库模型：Dat...

--------------------------anemometer安装：访问：http://mysql1/anemometer安装lnmp:http://lnmp.org/changelog.htmlwget --no-check-certificate https://api.sinas3.com/v1/SAE_lnmp/soft/lnmp1.2-full.tar.gztar zxf lnmp1.2-full.tar.gz && cd lnmp1.2-full && ./install.sh lnmp添加网站lnmp...

<h2 style="margin:10px 0px 0px;padding:0px 5px 3px;letter-spacing:-0.05em;font-family:Verdana, 'BitStream vera Sans';font-size:16px;border-bottom-width:1px;border-bottom-style:solid;border-bottom-color:#CCCCCC;color:#555555;line-height:normal;white-space:normal;background-color:#FFFFFF;">使用MySQL...

<div class="postTitle" style="margin:0px;padding:0px;color:#333333;font-family:verdana, Arial, Helvetica, sans-serif;font-size:13.3333330154419px;line-height:24px;white-space:normal;background-color:#FFFFFF;"><a href="http://doc.okbase.net/zhoujinyi/archive/40757.html" style="margin:0px;padding:0p...

<br />Centos6.5<br />mysql 5.1.73<br /><br />yum mysql 5.1.73升级到5.6.26<br /><br /><br />http://dev.mysql.com/doc/mysql-yum-repo-quick-guide/en/<br /><br /><br /><br /><br />MySQL yum库包括最新的软件包有：<br />MySQL 5.6 (GA)<br />MySQL 5.7 (Development Release)<br />MySQL 5.5 (GA -...

gtid不支持myisam，可能导致多个gtid分配给同一个事物不支持：create table .. selectcreate /drop temporary table必须使用enforce-gtid-consistencysql-slave-skip-counter不支持5.6.9之后，mysqldump制作的备份己包含gtid...

线程池技术：当线程数过多时，如果其中大部分线程都处于活动状态，将会导致频繁的上下文切换，从而造成巨大的系统开销。上下文切换：什么是线程上下文切换上下文切换的精确定义可以参考: http://www.linfo.org/c...

<header class="entry-header" style="color:#373737;font-family:Arial, sans-serif;font-size:15px;line-height:23.625px;white-space:normal;"><h1 class="entry-title" style="border:0px;font-family:inherit;font-size:26px;font-style:inherit;margin:0px;outline:0px;padding:1px 10px 0.1em 0px;vertical-align:b...

<header class="entry-header"><h1 class="entry-title" style="border:0px;font-family:inherit;font-size:26px;font-style:inherit;margin:0px;outline:0px;padding:1px 10px 0.1em 0px;vertical-align:baseline;clear:right;color:#222222;line-height:1.1em;">优化MySQL的21个建议</h1><div class="entry-meta" st...

<em><header class="entry-header" style="color:#373737;font-family:Arial, sans-serif;font-size:15px;line-height:23.625px;white-space:normal;"><h1 class="entry-title" style="border:0px;font-family:inherit;font-size:26px;font-style:inherit;margin:0px;outline:0px;padding:1px 10px 0.1em 0px;vertical-ali...

<h2 style="margin:10px 0px 0px;padding:0px 5px 3px;letter-spacing:-0.05em;font-family:Verdana, 'BitStream vera Sans';font-size:16px;border-bottom-width:1px;border-bottom-style:solid;border-bottom-color:#CCCCCC;color:#555555;line-height:normal;white-space:normal;background-color:#FFFFFF;">open/clos...

<table border="0" cellpadding="0" cellspacing="0" style="color:#000000;font-family:Arial, Helvetica, sans-serif;font-size:12px;width:722px;text-align:center;background-color:#FFFFFF;" class="ke-zeroborder"><tbody><tr><td><br /></td></tr><tr><td><table class="wenzhang...

flush_option 可以是下列任何东西：FLUSH HOSTS     &n...

<div class="Blog_tit4 Blog_tit5" style="border-bottom-width:0px;padding:0px 0px 11px;color:#565656;font-family:宋体, Arial;line-height:12px;white-space:normal;background-color:#FFFFFF;">&nbsp;<a href="http://blog.itpub.net/29254281/viewspace-1398273/" style="text-decoration:none;color:#9C2423;font...

<div class="Blog_tit4 Blog_tit5" style="border-bottom-width:0px;padding:0px 0px 11px;color:#565656;font-family:宋体, Arial;line-height:12px;white-space:normal;background-color:#FFFFFF;">&nbsp;<a href="http://blog.itpub.net/29254281/viewspace-1734271/" style="text-decoration:none;color:#9C2423;font...

<div class="Blog_tit4 Blog_tit5" style="border-bottom-width:0px;padding:0px 0px 11px;color:#565656;font-family:宋体, Arial;line-height:12px;white-space:normal;background-color:#FFFFFF;"><a href="http://blog.itpub.net/15480802/viewspace-757562/" style="text-decoration:none;color:#9C2423;font-family...