Minta mysql untuk mendapatkan semula rekod terkini

Question

Data adalah seperti berikut
id port domain e-mel jenis nilai nama ttl route def remark
2390 test.cn 80 123@qq.com 1 www 123.123.123.123 0 0 0
2523 test.cn 80 .com 123 123.123.123.123 1800 0 0

Terdapat 2 keping data yang sama dalam jadual (kecuali ttl dan id adalah berbeza Sekarang saya ingin menyimpan rekod terkini (seperti 2523).

Berikut adalah pernyataan ujian yang perlu digunakan; pangkalan data adalah mysql 5.7

use test;
CREATE TABLE test (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `domain` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `port` varchar(6) COLLATE utf8_unicode_ci DEFAULT '80',
  `email` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `type` tinyint(4) DEFAULT NULL,
  `name` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `value` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ttl` int(11) DEFAULT '0',
  `route` tinyint(4) DEFAULT '0',
  `def` tinyint(1) DEFAULT '0',
  `remark` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2721 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci


INSERT INTO test.test (`id`, `domain`, `port`, `email`, `type`, `name`, `value`, `ttl`, `route`, `def`, `remark`) VALUES ('2390', 'www.test.cn', '80', '123@qq.com', '1', 'www', '123.123.123.123', '0', '0', '0', NULL);
INSERT INTO test.test (`id`, `domain`, `port`, `email`, `type`, `name`, `value`, `ttl`, `route`, `def`, `remark`) VALUES ('2523', 'www.test.cn', '80', '123@qq.com', '1', 'www', '123.123.123.123', '1800', '0', '0', NULL);

Answer 1

踩我的出来指出错误呀，让我学习学习哪里有问题。
padam dari ujian
di mana (id,domain>, port, port kod>, jenis, nama, nilai,laluan, def, remark) bukan dalam (domain, port, email, type, name, value,route, def, remark) not in (
select * from (
select max(id) id,domain, port, email, type, name, value,route, def, remark
from test group by domain, port, email, type, name, value,route, def, remarkselect * from (

select max(id) id,domain, port, emel, type, name, value,route, def, remark🎜dari kumpulan ujian mengikut domain, port, emel, type, name kod>, nilai,laluan, def, remark) tmp)🎜

Answer 2

pilih maks(id),domain, port, e-mel, jenis, nama, nilai, laluan, def, remark daripada ujian KUMPULAN MENGIKUT domain, port, e-mel, jenis, nama, nilai, laluan, def, remark;

Answer 3

Berikan anda sql untuk menjana skrip pemadaman

select concat("delete from test where id=",min(id),";") 
into outfile '/tmp/delete_test.sql' lines terminated by '\n' 
from test group by domain, port, email, type, name, value,route, def, remark;