MYSQL- foo表复制表Track内容 

--insert into t9 (id,income_date,amount,target_amount,create_time) values (1,103,03,3232,2019-01-01),(2,71,62,84,2019-01-01);--插入数据

------------------------------------------------------------------------------------------------

--insert into foo (bar,baz,byd) select Name,AlbumId,MediaTypeId from Track; --复制表Track内容
posted @ 2024-01-20 17:23  bydljp  阅读(14)  评论(0)    收藏  举报