///
SELECT serverip FROM servers GROUP BY serverip HAVING COUNT(*) > 1;
///	  
	
///  
SELECT max(id) as id, serverip FROM servers WHERE serverip in 
( 
	SELECT serverip  FROM servers GROUP BY serverip HAVING COUNT(*) > 1 
) GROUP BY serverip;
///
   
///
DELETE servers FROM servers 
INNER JOIN ( 
				SELECT max(id) as id, serverip FROM servers WHERE serverip in 
				(
					SELECT serverip FROM servers GROUP BY serverip HAVING COUNT(*) > 1
				) GROUP BY serverip
			) duplic on duplic.serverip = servers.serverip
WHERE servers.id < duplic.id;
///
Categories: MySql language

74 Comments

Timewires · 22/01/2024 at 23:12

What i do not realize is in fact how you are no longer actually much more wellfavored than you might be right now Youre very intelligent You recognize thus considerably in relation to this topic made me in my view believe it from numerous numerous angles Its like men and women are not fascinated until it is one thing to do with Lady gaga Your own stuffs excellent All the time handle it up

قیمت دستگاه نورومانیتورینگ · 23/01/2024 at 15:44

Excellent blog here! Also your web site loads up fast!
What host are you using? Can I get your affiliate link
to your host? I wish my site loaded up as quickly as yours lol

criminal · 24/01/2024 at 18:28

wow, amazing

criminal · 24/01/2024 at 19:30

wow, amazing

lose money · 24/01/2024 at 20:19

nice content!nice history!! boba 😀

scam · 24/01/2024 at 21:21

nice content!nice history!! boba 😀

scam · 25/01/2024 at 07:31

nice content!nice history!! boba 😀

porn · 25/01/2024 at 11:19

wow, amazing

porn · 25/01/2024 at 13:20

nice content!nice history!! boba 😀

scam · 25/01/2024 at 23:49

Terrific, continue

айфон 15 про купить минск · 26/01/2024 at 03:29

I don’t know if it’s just me or if everyone else experiencing problems with your website. It appears as if some of the text within your posts are running off the screen. Can someone else please comment and let me know if this is happening to them too? This could be a problem with my browser because I’ve had this happen before. Appreciate it

https://mononews.gr · 26/01/2024 at 04:50

I just couldn’t depart your website before suggesting that
I really enjoyed the standard information a person provide to your visitors?

Is going to be back often to inspect new posts

www.numarkgallery.com · 26/01/2024 at 11:42

Fantastic blog! Do you have any recommendations for
aspiring writers? I’m hoping to start my own blog soon but I’m a little lost on everything.
Would you advise starting with a free platform like WordPress or go for
a paid option? There are so many choices out there that I’m
totally confused .. Any suggestions? Appreciate it!

scam · 26/01/2024 at 14:15

wow, amazing

criminal · 26/01/2024 at 16:24

nice content!nice history!! boba 😀

gabapentin and alcohol · 26/06/2024 at 12:18

gabapentin and alcohol

gabapentin and alcohol

modafinil adhd · 26/06/2024 at 15:53

modafinil adhd

modafinil adhd

valtrex for cold sores dosage · 26/06/2024 at 20:28

valtrex for cold sores dosage

valtrex for cold sores dosage

how much trazodone can you give a dog · 26/06/2024 at 23:28

how much trazodone can you give a dog

how much trazodone can you give a dog

side effects of ciprofloxacin 500 mg · 27/06/2024 at 02:26

side effects of ciprofloxacin 500 mg

side effects of ciprofloxacin 500 mg

tamoxifen and fatigue · 27/06/2024 at 05:30

tamoxifen and fatigue

tamoxifen and fatigue

ampicillin bacterial cultures · 27/06/2024 at 08:23

ampicillin bacterial cultures

ampicillin bacterial cultures

amoxicillin dosage for tooth infection how many days · 28/06/2024 at 14:00

amoxicillin dosage for tooth infection how many days

amoxicillin dosage for tooth infection how many days

lisinopril hctz 10 12.5 mg tab · 29/06/2024 at 08:28

lisinopril hctz 10 12.5 mg tab

lisinopril hctz 10 12.5 mg tab

Leave a Reply

Avatar placeholder