,SELECT * FROM 表1 WHERE 字段1 IN (SELECT 字段2 FROM 表2),
``,SELECT * FROM 表1 WHERE 字段1 IN (SELECT 字段2 FROM 表2),
``php,$result = mysqli_query($conn, "SELECT * FROM table");,$data = mysqli_fetch_all($result, MYSQLI_ASSOC);,echo json_encode($data);,
``sql,SELECT a.*, b.*,FROM table1 a,JOIN table2 b ON a.id = b.a_id;,
``,,这条语句将table1和table2通过a.id和b.a_id进行关联查询。Powered By Z-BlogPHP 1.7.3
Copyright Your WebSite.Some Rights Reserved.