sooxin的专栏

[code="java"]delete from 维修 where exists(select 1 from 维修 a where a.id>维修.id and 维修.电话=a.电话 and soso) [/code]

select * from A where checksum(*) not in (select checksum(*) from B) 表示是A表有,B表没有的数据.

在安装mysql的机器上运行： 　　1、d:\mysql\bin\>mysql -h localhost -u root 　　//这样应该可以进入MySQL服务器 　　2、mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'WITH GRANT OPTION 　　//赋予任何主机访问数据的权限 　　3、mysql>FL...

CentOS Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ 如果仅仅只yum 安装了mysql这个包，启动mysql时就会提示：ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/li...

说明： 按前一篇日记方法装了两台机器测试 master1:192.168.5.11 master2:192.168.5.12 开启两台服务器的binlog功能(vim /etc/my.cnf,在mysqld字段下加入下面内容) master1: user = mysql log-bin=mysql-bin server-id = 1 binlog-do-db=test binl...