thinkphp database operation How to use alias?
parameter types supported by coherent operation
Alias is used to define the aliases string for the current data table
Help thinkphp Operation Way alias How to use, not the original ecological SQL notation
Thinkphp in the development of the document is not missing the introduction of alias? Mine is thinkPHP3.1.2 's development document.
------Solution--------------------
Please abide by CSDN user Code of conduct, must not violate national laws and regulations.
------Solution--------------------
Http://www.thinkphp.cn/simple/quickstart_4.html
------Solution--------------------
Alias is used to set the alias of the current data table, making it easy to use other coherent operations such as the Join method.
Example:
$Model = M (' User ');
$Model->alias (' a ')->join (' __dept__ b on b.user_id= a.id ')->select ();
The resulting SQL statement is similar to the following:
SELECT * from Think_user a INNER joins think_dept B on b.user_id= a.id
Http://document.thinkphp.cn/manual_3_2.html#alias