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

Yii 2.0 Left Join Search Code Demo

Yii 2.0 Framework Left Join Search Code Demo
2016-12-14 14:24:30 0 Comments Linux Boy.Lee

2017 Centos 6 Web Server iptables Classial Config Rules List

In LNMP(Centos 6+nginx+php-fpm+mysql) Web Server Produce Env, list and explain all useful iptables rules, you can direct pick need rule out and use it for your own iptables config,

Yii 2.0 use andWhere() Do and or query

In Yii 2.0 Framework, use andWhere() function run DB(MySQL) Query like A = 1 or B = 1
2019-08-27 11:38:03 4 Comments Linux Boy.Lee

Centos Regular Auto-backup MySQL Database and send to email address

Centos use Cron do Regular Auto-Backup for MySQL database, and auto send email by Mutt
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
New YiiLib.com online
2016-04-13 21:26:41 0 Comments News Boy.Lee

New YiiLib.com online

after about 1 month dev, the new Yiilib.com is online, just hope the new site can bring you some new feeliing

manage PK in Yii Framework's AR

The demo code for how to manage single or composite PK in Yii 1.0 Framework AR

use bindValue() build like statement in Yii 1.0 DAO

In Yii 1.0 DAO mode, use bindValue() build like statement
2012-01-02 16:54:13 0 Comments PHP Boy.Lee

phpMyAdmin #2002 Login Failure

After install phpMyAdmin, got #2002 error, it's because config wrong so MySQL server is not responding

Start,Restart,Stop Mysql Service in Mac Os X

Command for Start,Restart,Stop Mysql Service in Mac Os X
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

Dynamic change Database connection parameter in Yii

use dynamic change idea let Yii::app()->db service multi-models in Yii 1.0 Framework