2017-05-31T07:12:17.798068Z mysqld_safe mysqld from pid file /opt/mysql5718/data/izwz9gxsbwybwg9n5xdi47z.pid ended2017-05-31T07:13:41.155879Z mysqld_safe Logging to '/opt/mysql5718/mysqllog/logfile/mysql-err.log'.2017-05-31T07:13:41.180126Z mysqld_safe Starting mysqld daemon with databases from /o...【阅读全文】
重要字段:Id: 连接标识符 可以进行连接查询 information_schema.processlist.ID performance_schema.threads.processlist_idcommand: Binlog DumpThis is a thread on a master server for sending binary log contents to a slave server.Chan...【阅读全文】
查找数据库中的重复记录(多个字段):SELECT * FROM wcs_best_fitness_individual WHERE (spokeCounts,isSpokeClosure,deflectionAngleOne,deflectionAngleTwo) IN (SELECT spokeCounts,isSpokeClosure,deflectionAngleOne,deflectionAngleTwo FROM wcs_best_fitness_individual GROUP BY spokeCounts,isSpok...【阅读全文】
1.将选中的数据快儿拷贝到一个TXT文本文件中或保存为csv文件(记得把后面的空格消掉。。)2.建立MySql数据库和表,然后进入命令提示符里使用命令load data local infile '~/data.txt' into table exceltomysql fields terminated by '\t';(如果要设置编码的话需要在fields前面加 character set utf8)...【阅读全文】