delete na marche pas [Résolu]

[fk04]

Hello,

je fais cette requette DELETE FROM urls WHERE name=http://216.239.59.103 dans PhpMyAdmin mais j ai cette erreur "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 '://216.239.59.103' at line 1"

bav,

[LeGilou]

Bonjour,

Il faut utiliser des guillemets

Code :

1
2
 
DELETE FROM urls WHERE name="http://216.239.59.103"

Gillou

[andry.aime]

Salut,
Un simple guillemet serait mieux.

Code SQL :

DELETE FROM urls WHERE name='http://216.239.59.103'

[fk04]

Thank you guys !