Bug #13169 | Phpmyadmin bug on syntax analize | ||
---|---|---|---|
Submitted: | 14 Sep 2005 7:44 | Modified: | 14 Sep 2005 8:05 |
Reporter: | Patrick DOURET | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server | Severity: | S1 (Critical) |
Version: | OS: | Windows (Windows 2000 Professionnal) | |
Assigned to: | CPU Architecture: | Any |
[14 Sep 2005 7:44]
Patrick DOURET
[14 Sep 2005 8:05]
Valeriy Kravchuk
Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://www.mysql.com/documentation/ and the instructions on how to report a bug at http://bugs.mysql.com/how-to-report.php Additional info: It has nothing to do with phpmyadmin, by the way. The problem is: how to pass single quote character (') inside a single quoted string. The solution is well-known - just use two of them (''): mysql> CREATE TABLE `colonnes_excel` ( -> `ID_COLONNE` int(10) NOT NULL auto_increment, -> `ID_THEME` varchar(50) NOT NULL default '', -> `LIBELLE` varchar(100) NOT NULL default '', -> `CLASSE_OBJET_CIBLE` varchar(20) default NULL, -> `NOM_ATTRIBUT_CIBLE` varchar(20) default NULL, -> `NOM_METHODE_CIBLE` varchar(50) default NULL, -> `ORDRE` int(10) unsigned NOT NULL default '0', -> `FORMAT` varchar(20) default NULL, -> `HIDDEN` tinyint(1) NOT NULL default '0', -> `VALEUR` varchar(20) default NULL, -> `COMMENTAIRE` varchar(200) default NULL, -> `MULTIVALUE` char(1) NOT NULL default 'N', -> `SEPARATEUR` char(1) default NULL, -> `TYPE_INDICATEUR` varchar(50) default NULL, -> PRIMARY KEY (`ID_COLONNE`,`ID_THEME`) -> ) TYPE=MyISAM AUTO_INCREMENT=52 ; Query OK, 0 rows affected, 1 warning (0.06 sec) mysql> INSERT INTO `colonnes_excel` ( `ID_THEME` , `LIBELLE` , `CLASSE_OBJET_CIBLE` , -> `NOM_ATTRIBUT_CIBLE` , `NOM_METHODE_CIBLE` , `ORDRE` , `FORMAT` , `HIDDEN` , -> `VALEUR` , `COMMENTAIRE` , `MULTIVALUE` , `SEPARATEUR` , `TYPE_INDICATEUR` ) -> VALUES ('CARACT_SEC_APPLI', 'Direction responsable du cout d''une application', -> 'Indicateur', 'vlrIndValeur', 'getVlrInd', '0', NULL , '0', NULL , -> 'Direction responsable du cout d''une application', 'N', NULL , 'APP_ORG_ COUT'); Query OK, 1 row affected (0.02 sec) mysql> select * from colonnes_excel; +------------+------------------+----------------------------------------------- --+--------------------+--------------------+-------------------+-------+------- -+--------+--------+-------------------------------------------------+---------- --+------------+-----------------+ | ID_COLONNE | ID_THEME | LIBELLE | CLASSE_OBJET_CIBLE | NOM_ATTRIBUT_CIBLE | NOM_METHODE_CIBLE | ORDRE | FORMAT | HIDDEN | VALEUR | COMMENTAIRE | MULTIVALU E | SEPARATEUR | TYPE_INDICATEUR | +------------+------------------+----------------------------------------------- --+--------------------+--------------------+-------------------+-------+------- -+--------+--------+-------------------------------------------------+---------- --+------------+-----------------+ | 52 | CARACT_SEC_APPLI | Direction responsable du cout d'une application | Indicateur | vlrIndValeur | getVlrInd | 0 | NULL | 0 | NULL | Direction responsable du cout d'une application | N | NULL | APP_ORG_COUT | +------------+------------------+----------------------------------------------- --+--------------------+--------------------+-------------------+-------+------- -+--------+--------+-------------------------------------------------+---------- --+------------+-----------------+ 1 row in set (0.00 sec)