Tag: SQL - Newest Original Tutorial Lib

2019-11-22 15:01:33 0 Comments 2 Likes 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.

2012-02-28 01:32:16 0 Comments 100 Likes Yii 1.0 Boy.Lee

use bindValue() build like statement in Yii 1.0 DAO

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

2011-04-29 14:28:42 0 Comments 110 Likes MySQL Boy.Lee

get a rand record from DB.Table

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

2011-04-07 15:16:36 0 Comments 65 Likes Yii 1.0 Boy.Lee

Yii 1.0 Show SQL Statement in footer

in Yii 1.0 Framework Show SQL Statement in footer

2011-04-07 14:08:07 0 Comments 128 Likes Yii 1.0 Boy.Lee

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 87 Likes MySQL Boy.Lee

Show table's columns in MySQL

SQL command for display MySQL table's columns

2011-04-07 14:20:08 0 Comments 190 Likes Yii 1.0 Boy.Lee

Yii 1.0 DAO Code Demo

Yii 1.0 Framework DAO Code Demo

2011-04-03 17:59:09 0 Comments 101 Likes Yii 1.0 Boy.Lee

Yii PHP framework 1.1.7 is released

2011-03-28 20:34:24 1 Comments 155 Likes MySQL Boy.Lee

MySQL Table and Row level lock status check

SQL Command for MySQL Table and Row level lock status check

2011-03-19 09:46:18 0 Comments 141 Likes MySQL Boy.Lee

MySQL left or right or inner or cross join Statements Example

Code for different Type MySQL Join