ako mam zapisat v PhpMyAdmin aby mi vymazalo v tabulke vsetky zaznamy, kde uzivatel = peter
stale mi to vypisuje chybu
takze ja to skusam takto:
Kód:
DELETE * FROM `tablename` WHERE `meno` = 'peter'
alebo takto DELETE * FROM `tablename` WHERE `tablename`.`meno` = 'peter' / tento zapis som dal preto, lebo ked som klikol na X pri jednom zazname, tak mi hodilo taky zapis : DELETE FROM `tablename` WHERE `tablename`.`id` = 1976 LIMIT 1
skusam to s roznymi uvodzovkami a stale mi vypisuje chybu
Kód:
MySQL hlási: Dokumentácia
#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 `tablename` WHERE `tablename`.`meno` = 'peter'' at line 1
