insert into student(num,name,age,id)values(11,'three',6,6);
insert into student(num,name,age,id)values(21,'four',6,2);
insert into student(num,name,age,id)values(31,'five',6,1);
insert into student(num,name,age,id)values(41,'six',6,4);
insert into student(num,name,age,id)values(51,'three',7,3);
insert into student(num,name,age,id)values(61,'three',6,8);
insert into student(num,name,age,id)values(71,'five',6,7);
insert into student(num,name,age,id)values(81,'four',6,5);
uj5u.com熱心網友回復：
這樣可以，那樣不行
uj5u.com熱心網友回復：
沒人幫忙解答下這個問題么？？？？？？？uj5u.com熱心網友回復：
所說MySQL不支持在更新、洗掉表的子名中查詢本表可以考慮用臨時表/變數
uj5u.com熱心網友回復：
試試這樣DELETE
FROM
student
WHERE id NOT IN
(SELECT
Id
FROM
(SELECT
MAX(num) id
FROM
student
GROUP BY NAME,
age) t1)
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/117594.html
標籤：應用實例
上一篇：從后臺傳輸過來的資料，怎么把這些資料分開在表格里顯示呢
下一篇：MyEclipse打不開