JOIN
语句结合 数据库名.表名
语法。,,``sql,SELECT db1.table1.column1, db2.table2.column2,FROM db1.table1,JOIN db2.table2 ON db1.table1.common_field = db2.table2.common_field;,
``mysql u 用户名 p e "SHOW VARIABLES LIKE 'hostname';"
。SELECT HOST;
语句查看当前连接主机。php,$db = new PDO('mysql:host=localhost;dbname=your_database', 'username', 'password');,$stmt = $db>query("SELECT * FROM your_table");,while ($row = $stmt>fetch()) {, echo $row['column_name'];,},
``Powered By Z-BlogPHP 1.7.3
Copyright Your WebSite.Some Rights Reserved.