very simple INSERT

[Thiebo Cremers]

Hello,

I have this table :

mysql> DESC liens;
+-------+---------------------------------------------------------------------+------+-----+---------------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+---------------------------------------------------------------------+------+-----+---------------+-------+
| lien | varchar(100) | | PRI | | |
| cat | enum('bibliotheques','librairies','histoire','genealogie') | | | bibliotheques | |
| Lnom | varchar(20) | | | | |
| desc | varchar(150) | | | | |
| qui | varchar(20) | | | | |
| quand | varchar(12) | | | | |
+-------+---------------------------------------------------------------------+------+-----+---------------+-------+
6 rows in set (0.00 sec)


and when I try to execute this request, directly in a terminal :

INSERT INTO liens (lien, cat, Lnom, desc, qui, quand) VALUES ('http://www.breer.com','librairies','test','test test','bobo','2005-08-11');

I get an error message saying that I have an error in mysql syntax, I have tried with other values, tried to enter the word 'test' instead of the URL, nothing works.

Stange this is that when I execute this request with phpMyAdmin it does work !!! And this is the instruction phpMyAdmin executes :

INSERT INTO `liens` ( `lien` , `cat` , `Lnom` , `desc` , `qui` , `quand` )
VALUES (
'http://www.breer.com';, 'librairies', 'test', 'test test', 'bobo', '2005-08-11'
);

Does anybody have an idea why my instruction doesn'f function ???

Many thanks,

Thiebo