大家看我sql语句这么写有什么问题吗？as后面要不要加个括号之类的ps:目的是把一张表里符合条件的东西取出来放到新的表里
0
[已关闭问题]
关闭于 2018-01-20 20:47
CREATE table docs_info_weibo as select id, userId as wb_id, createdAt as pubdate, content, url, author as bloger, location as address, reportsCount as forwarding, commentsCount as COMMENT from docs_info where mediatype ='weibo'
所有回答(2)
0
语法：create table 新表表名 as select * from 旧表表名;
as后面不加括号
0
看了你两个问题 —— 你解决问题的思路不太正确。不要为了问题而问题，合理选择工具，合理利用工具。
你这也太抽象了吧
