Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Brisanje duplih mailova iz više tablica u SQL-u
Author Message
Gogy Offline
____
*

Posts: 2,379
Joined: Feb 2006
Post: #2
RE: Brisanje duplih mailova iz više tablica u SQL-u
Vjerojatno ima elegantnijih načina ali ja bi to ovako napravio (iz glave, sorry ako ima grešaka):

PHP Code:
$query mysql_query"SELECT email from prvatablica");
while (
$row=mysql_fetch_array($query)) {
    
mysql_query("DELETE FROM drugatablica WHERE email = $row['email']");
    
mysql_query("DELETE FROM trecatablica WHERE email = $row['email']");


Pravila foruma | Twitter - Facebook - Google+ |
19-09-2013 09:48 PM
Visit this user's website Find all posts by this user Quote this message in a reply
Post Reply 


Messages In This Thread
RE: Brisanje duplih mailova iz više tablica u SQL-u - Gogy - 19-09-2013 09:48 PM

Forum Jump:


User(s) browsing this thread: 1 Guest(s)