create table fengk(cno int auto_increment primary key ,
cname char(30),
cpno char(30))
auto_increment=1;
insert into fengk(cname,cpno)values('me','me');
insert into fengk(cname,cpno) select cname,cpno from fengk;这一句执行了n遍。
cname char(30),
cpno char(30))
auto_increment=1;
insert into fengk(cname,cpno)values('me','me');
insert into fengk(cname,cpno) select cname,cpno from fengk;这一句执行了n遍。
这个有错了。。
这是SQL Server的语法:
select top 6 * from fengk where cno not in (select top 99 cno from fengk);
MySQL的写法是:
select * from fengk where cno not in (select cno from fengk limit 99) limit 6;
1235 - This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'
left join (select cno from fengk limit 99) b
on a.cno=b.cno where b.cno is null limit 6;
+-----+-------+------+------+
| cno | cname | cpno | cno |
+-----+-------+------+------+
| 157 | me | me | NULL |
| 158 | me | me | NULL |
| 159 | me | me | NULL |
| 160 | me | me | NULL |
| 161 | me | me | NULL |
| 162 | me | me | NULL |
+-----+-------+------+------+
6 rows in set
贴建表及插入记录的SQL,及要求结果出来看看