• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!
  • 2026 staff recruitment is open! Check it out and consider applying!

Windows Error on MySQL (phpmyadmin)

GOD TonyX

New Member
Joined
Jul 13, 2012
Messages
19
Reaction score
0
Location
Spain
I create a new character on my server and now i am trying to delete him from the web of my server and i click on the button and he dont desapear... I go to the SQL query to try to delete him manually.

I put this query:

LUA:
DELETE FROM `players` WHERE 'id' = 11;
DELETE FROM `players` WHERE 'id' = 12;

And the code is OK but sql says # MySQL returned an empty result set (i.e. zero rows). And the rows doesnt be deleted. Later i try to create a new one called "prueba" and i try delete it by the name.

LUA:
DELETE FROM `players` WHERE 'name' = "prueba"

The code it's ok but says 0 rows deleted. ( Query took 0.0011 sec ).

WHY? Help me please.
 
DELETE FROM players WHERE name = 'Name';
DELETE FROM players WHERE id = 'ID';

ps: i don't know if you can delete online players, so maybe it is online.
 
Last edited:
@Dukeeh
ps: i don't know if you can delete online players, so maybe it is online.
Rep+? <-- what say everypsot Rep+? ;)
If you want to win does not ask for it that pathetic in every post the same thing only for writing?
lol?

@GOD TonyX
Query is correct only need have character OFFLINE.. for works query
 
Back
Top