简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Database > Mysql Tutorial > body text

Delete duplicate records in a SQL table

大家讲道理
Release： 2016-11-12 10:31:34
Original
1052 people have browsed it

假如表为Mytable
SELECT distinct * FROM into 临时表 from MyTable
DELETE from MyTable insert into MyTable
SELECT * FROM 临时表 
drop table 临时表
Copy after login

Related labels：
代码片段，代码分享，PHP代码分享，Java代码分享 Ruby代码分享，Python代码分享，HTML代码分享，CSS代
source：php.cn
Previous article：mysql cursor usage template Next article：SQL loop inserts 1000 pieces of data
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
Group MySQL results by ID for looping over I have a table with flight data in mysql. I'm writing a php code that will group and displ...
From 2024-04-06 17:27:56
0
1
406
Parent's padding ignored by sticky positioned child How to prevent sticky elements from going behind the header? The current code snippet uses...
From 2024-04-06 11:42:51
0
1
338
How to know when a Vue component is fully initialized? So, in my Vue component, I have an async created method and several variables with async w...
From 2024-04-05 14:20:24
0
1
1442
The restated title is: The English translation of Stripe Connect Subscription Split Fees is "Stripe Connect Subscription Split Fees" Hi, I'm building a platform for clients using StripePHPAPI that sells subscriptions on a m...
From 2024-04-02 20:15:22
0
1
418
How to align images using CSS grid? I'm trying to build part of a website using CSS grid. I'm trying to get the list and image...
From 2024-04-01 22:08:31
0
1
338
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！