close
1.
來自同資料庫不同表，如cities表的name
insert into t1 (name1) select name from cities
2.更新來自別的table
update cities set name=(select name from users limit 1) where id = 1
3.將表格資料匯出
select * into outfile 'D:\\city.txt' from cities
全站熱搜
留言列表
