mysql笔记

ly4885806

1,用MySQL内置函数转换ip地址和数字，注意这里的存储类型选用无符号int或者bigint

1. select inet_aton('192.168.0.122');
   
2. select inet_ntoa(3232235642);

2,搜索数据表的 Auto_increment 值

1. $result = mysql_query("show table status like 'tablename'");
   
2. $id = mysql_result($result, 0, 'Auto_increment');

3,远程链接出错：错误信息为:ERROR 1129 (HY000): Host 'www.taoczt.com' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'

解决方法：在主服务器上面执行：'mysqladmin flush-hosts'