• 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!

[database]cant delete character

kret

K R E T O W N A G E
Joined
Apr 4, 2008
Messages
949
Reaction score
6
Location
PяOLAND
Hello

when i try to delete character from PHPMYADMIN i have an error
Błąd

zapytanie SQL:

DELETE FROM `test`.`players` WHERE `players`.`id` =4548 LIMIT 1

MySQL zwrócił komunikat: Dokumentacja
#1054 - Unknown column 'value' in 'where clause'

How to fix it? I search answer in google but i dont find anything ;(
 
Try
Code:
DELETE FROM 'players` WHERE 'id` =4548 LIMIT 1
P.S. Make a backup before xD

EDIT: I didn read the post right, Try updating your phpmyadmin at phpmyadmin.net
 
The mix of ' and ` is never a good ideea... instead use the following:

Code:
DELETE FROM `players` WHERE `id` = 4548

It should work properly.

(LIMIT 1 is really only used for SELECT statements, its not used in DELETE statements since `id` is an unique key and thus there can only be one player with id 4548)
 
Back
Top