2019-11-25 15:23:26 0 Comments MySQL Boy.Lee

MySQL import tsv data file

How to import tsv data file to MySQL database, and the error will show
2019-11-22 15:01:33 0 Comments MySQL Boy.Lee

MySQLError:ASCII '\0' appeared in the statement, but this is not allowed unless option --binary-mode

Just got MySQL Error: "ASCII '\0' appeared in the statement, but this is not allowed unless option --binary-mode", this topic is about how to solve it.
2019-06-14 18:41:21 0 Comments MySQL Boy.Lee

MySQL Reverse PK value

Say in MySQL Database, we have movie table with 1000 rows, id from 1 to 1000, now we want reverse the PK order set 1000 to 1, 1 to 1000, we can do it like this.
2019-05-14 09:26:57 0 Comments MySQL Boy.Lee

MySQL 5.7.26 Reset Root Password on Centos 6

MySQL 5.7.26 Reset Root Password on Centos 6, I lost my root password with a mysql error, so I have to reset it, the server is Centos 6 and mysql 5.7.26, follow are the steps
2016-04-19 15:15:00 0 Comments MySQL Boy.Lee

Format date field in MySQL statement

Use MySQL's date format function to format date in SQL statement
2011-11-04 15:19:24 0 Comments MySQL Boy.Lee

MySQL Error : system error: 61

the solution for fix MySQL Error system error: 61

get a rand record from DB.Table

a very cool way to get a rand record from MySQL Table
2011-04-06 14:37:09 0 Comments MySQL Boy.Lee

MySQL Schema optimize

MySQL Schema optimize suggestion

MySQL Sort Type Control

MySQL Sort Type Control

Show table DDL in MySQL

Show table DDL in MySQL
2011-04-06 11:18:07 0 Comments MySQL Boy.Lee

Show table's columns in MySQL

SQL command for display MySQL table's columns

MySQL Table and Row level lock status check

SQL Command for MySQL Table and Row level lock status check

MySQL left or right or inner or cross join Statements Example

Code for different Type MySQL Join