子查询及利用结果创建新表

发布时间：2020-12-15 00:42:13 所属栏目：C语言来源：网络整理

导读：子查询及利用结果创建新表 set @id = 0;create table schools (select @id := @id+1 as id,`学校名称` as school,website,`所在地` as province,2 as db from all where website not in (select website from already))

子查询及利用结果创建新表

set @id = 0;
create table schools (select @id := @id+1 as id,`学校名称` as school,website,`所在地` as province,2 as db from all where website not in (select website from already))

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!