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