Pb: auto_increment - insert zero value

Hi, I have problem in the insertion of 0 in auto_increment. I have set in my.ini file as follows, sql-mode=STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION,NO_AUTO_VALUE_ON_ZERO Even now the auto increment filed is not allows to insert a zero; If i insert zero, 1 is getting

Pb with insert

Hello, I do the next request on a table with a column type varchar2 insert into XX ('test\annuaire\'); the request succeeds but in the table '\ have disapeared. testannuaire Could someone help me? thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Re: Pb with insert

Replace \ with \\ Ulterior = Global FTP Search - www.filesearch.lt - Original Message - From: Gantier [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, June 27, 2003 9:11 AM Subject: Pb with insert Hello, I do the next request on a table

Re: Pb with insert

Gantier [EMAIL PROTECTED] wrote: Hello, I do the next request on a table with a column type varchar2 insert into XX ('test\annuaire\'); the request succeeds but in the table '\ have disapeared. testannuaire You must escape this char: