表明:user1
字段:
uid username
1 用户1
2 用户2表名:user2
uid username
3 用户3
4 用户4
用sql语句输出:
array(
0=>array(
uid=>1,
username=>用户1
),
1=>array(
uid=>2
username=>用户2
),
2=>array(
uid=>3
username=>用户3
),
3=>array(
uid=>4
username=>用户4
),
)
请高手们指条明路
字段:
uid username
1 用户1
2 用户2表名:user2
uid username
3 用户3
4 用户4
用sql语句输出:
array(
0=>array(
uid=>1,
username=>用户1
),
1=>array(
uid=>2
username=>用户2
),
2=>array(
uid=>3
username=>用户3
),
3=>array(
uid=>4
username=>用户4
),
)
请高手们指条明路
select * from table1 union select * from table2
注意:如果字段不想同要加+字段别名