寅月星回的博客

https://www.w3school.com.cn/sql/sql_select_into.asp练习sql，执行select into报错百度下，发现mysql不支持select intohttps://blog.youkuaiyun.com/qq_28379809/article/details/77936026参考上面这个链接将select into语句改为create table table_name(select * from table_name)的形式create table persons

https://www.w3school.com.cn/sql/sql_join_full.aspfull join 出现图中错误参考https://blog.youkuaiyun.com/lukabruce/article/details/80568796Oracle 支持full joinmysql不支持full join,但可通过左外连接(left join)+union+右外连接(right join)来实现。full join语句可改为select persons.last_name, pers