Duplicate Row Delete MySql
DELETE a FROM liaison_officers a INNER JOIN liaison_officers a2 WHERE a.id < a2.id AND a.`mobile1` = a2.`mobile1` (295*2)+(42*3)+(2*4) = 724295+42+2 = 339724-339
সকল প্রশংসা শুধুমাত্র আল্লাহ তাআলার
মো: মাসুদ পারভেজ পাটোয়ারী
DELETE a FROM liaison_officers a INNER JOIN liaison_officers a2 WHERE a.id < a2.id AND a.`mobile1` = a2.`mobile1` (295*2)+(42*3)+(2*4) = 724295+42+2 = 339724-339
PROTOCOL=’TCP’ PORT=’20’PROTOCOL=’TCP’ PORT=’21’PROTOCOL=’TCP’ PORT=’22’PROTOCOL=’TCP’ PORT=’25’PROTOCOL=’UDP’ PORT=’53’PROTOCOL=’TCP’ PORT=’80’PROTOCOL=’TCP’ PORT=’443′PROTOCOL=’TCP’ PORT=’110′PROTOCOL=’UDP’ PORT=’123′PROTOCOL=’TCP’ PORT=’143′PROTOCOL=’TCP’ PORT=’3306′PROTOCOL=’TCP’ PORT=’5432′PROTOCOL=’TCP’ PORT=’8080′PROTOCOL=’TCP’ PORT=’8433′PROTOCOL=’TCP’ PORT=’8083′PROTOCOL=’TCP’ PORT=’12000:12100′
If you are sure that there is no domain on the IP your about to delete, then go to :/usr/local/vesta/data/ips (that’s for debian based o/s, don’t know the exact for … Read More