一、创建数据库: create database database_name; php中创建数据库的两种方法:(mysql_create_db(),mysql_query()) $conn = mysql_connect(“localhost”,”username”,”password”) or die ( “could not connect to localhost”); 1. mysql_create_db(“database_name”) or&n...【阅读全文】
1.将选中的数据快儿拷贝到一个TXT文本文件中或保存为csv文件(记得把后面的空格消掉。。)2.建立MySql数据库和表,然后进入命令提示符里使用命令load data local infile '~/data.txt' into table exceltomysql fields terminated by '\t';(如果要设置编码的话需要在fields前面加 character set utf8)...【阅读全文】
1.查找表中多余的重复记录,重复记录是根据单个字段(ipaddr_to_long)来判断 SELECT * FROM ips WHERE ipaddr_to_long IN (SELECT ipaddr_to_long FROM ips GROUP BY ipaddr_to_long HAVING COUNT(ipaddr_to_long) > 1) 2.去重 留ID最小的数据DELETE FROM ips a WHERE (a.ipaddr_to_long) IN...【阅读全文】