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.

use bindValue() build like statement in Yii 1.0 DAO

In Yii 1.0 DAO mode, use bindValue() build like statement

get a rand record from DB.Table

a very cool way to get a rand record from MySQL Table

Yii 1.0 Show SQL Statement in footer

in Yii 1.0 Framework Show SQL Statement in footer

Yii 1.0 Query Builder Code Demo

in Yii 1.0 Framework use Query Builder query database part I
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

Yii 1.0 DAO Code Demo

Yii 1.0 Framework DAO Code Demo

Yii PHP framework 1.1.7 is released

Yii PHP framework 1.1.7 is released

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