phpmyadmin quyery's

[Tropix]

Hihu, I wonder if someone know how i can delete all accounts in SQL query, but not account name 1

 

[Ninja]

You could select all accounts except one and just empty the table.

 

[Tropix]

But i found SQL query before remove all accounts but not account number 1

 

[Korrex]

Uh, maybe.

TRUNCATE accounts WHERE name NOT = '1';

 

[Tropix]

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE name NOT = '1'' at line 1

 

[Ninja]

DELETE FROM `accounts` WHERE NOT `name` = 1

 

[Tropix]

LooooooooooooooooL, my Phpmyadmin crashed :O, i got over 275 site with accoutns :O

- - - Updated - - -

504 Gateway Time-out