你是要干什么呢?
要把2个表关联起来查询?
select tbl1.mid,tbl1.tim,tbl2.mid,tb2.timfrom tbl1,tbl2where tbl1.mid = tbl2.mid and tbl1.mid = 9order by tbl1.tim 还是要把2个表的查询结果放到一起?
select mid,tim from tbl1 where mid = 9unionselect mid,tim from tbl2 where mid = 9order by tim
时间:2022-06-19 02:29:19
你是要干什么呢?
要把2个表关联起来查询?
select tbl1.mid,tbl1.tim,tbl2.mid,tb2.timfrom tbl1,tbl2where tbl1.mid = tbl2.mid and tbl1.mid = 9order by tbl1.tim 还是要把2个表的查询结果放到一起?
select mid,tim from tbl1 where mid = 9unionselect mid,tim from tbl2 where mid = 9order by tim
mysql怎样将一张表关联另一张表 – 数据库 – 前端 mysql中汉字无法查询表
2024-03-23