delete accounts

[xLosT]

must command to delete all accountas on database except two accounts

 

[Jotran]

change 1 & 2 to the id's you don't want to delete, if you get an error use ~= instead of !=

DELETE * FROM `player` WHERE `id` != 1 OR `id` != 2;

 

[xLosT]

DELETE * FROM `accounts` WHERE `id` ~= 1 OR `id` ~= 8568137

dont work

 

[Jotran]

do you have a table called accounts?

 

[xLosT]

yes

#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 '* FROM `accounts` WHERE `id` ~= 1 OR `id` ~= 8568137' at line 1

 

[Jotran]

What sql server are you using?

You know you can get these commands on your own right?
Every time you make a change in the database it shows the query at the top of the window even if you did it manually without a query.
You can take that query and alter it so it does exactly what you want to do the next time you need to make a change.

Now stop being a girl with your database and leave the girly behavior to the pro's

 

[xLosT]

5.1.73

 

[HeberPcL]

Try it;

DELETE * FROM `accounts` WHERE `id` <> 'Heber Holanda';

 

[Evil Puncker]

Try it;

DELETE * FROM `accounts` WHERE `id` <> 'Heber Holanda';

`id` field only accept numbers, how would it check for 'Heber Holanda'? xD and I don't think that '<>' operators can be used like that

 

[imkingran]

DELETE * FROM `accounts` WHERE `id` ~= 1 OR `id` ~= 8568137

dont work

Change:

~=

to:

!=

DELETE * FROM `accounts` WHERE `id` != 1 OR `id` != 8568137

 

[HeberPcL]

`id` field only accept numbers, how would it check for 'Heber Holanda'? xD and I don't think that '<>' operators can be used like that

Field ID accept numbers and characters. (Not accept spaces) But is only example.

And Operator <> work perferct!

 

[Summ]

The WHERE clause actually needs to be
WHERE `id` != 1 AND `id` != 8568137