Pb: auto_increment - insert zero value

Pb: auto_increment - insert zero value

am 18.03.2010 11:49:41 von Vikram A

--0-1333068602-1268909381=:78536
Content-Type: multipart/alternative; boundary="0-1781688521-1268909381=:78536"

--0-1781688521-1268909381=:78536
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable

Hi,

I have problem in the insertion of 0 in auto_increment.=20

I have set in my.ini file as follows,

sql-mode=3D"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 inse=
rt zero, 1 is getting inserted.=20

I have attached my.ini file for your reference.

Please help me.

Thank you

VIKRAM

=0A Your Mail works best with the New Yahoo Optimized IE8. Get i=
t NOW! http://downloads.yahoo.com/in/internetexplorer/
--0-1781688521-1268909381=:78536
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: quoted-printable

top" style=3D"font: inherit;"> ,sans-serif;">Hi,
rif;">
=3D"font-family: verdana,helvetica,sans-serif;">I have problem in the inser=
tion of 0 in auto_increment.

tica,sans-serif;">
=
I have set in my=
..ini file as follows,

s-serif;">
yle=3D"font-family: verdana,helvetica,sans-serif;">sql-mode=3D"STRICT_TRANS=
_TABLES,NO_AUTO_CREATE_USER,

ica,sans-serif;"> verdana,helvetica,sans-serif;">NO_ENGINE_SUBSTITUTION,NO_AUT O_VALUE_ON_ZER=
O"


=3D"font-family: verdana,helvetica,sans-serif;"> verdana,helvetica,sans-serif;">Even now the auto increment filed is not al=
lows to insert a zero; If i insert zero, 1 is getting inserted.

style=3D"font-family: verdana,helvetica,sans-serif;">
ly: verdana,helvetica,sans-serif;"> etica,sans-serif;">I have attached my.ini file for your reference. r style=3D"font-family: verdana,helvetica,sans-serif;">
mily: verdana,helvetica,sans-serif;"> lvetica,sans-serif;">Please help me.
a,helvetica,sans-serif;">
erif;">Thank you=
style=3D"font-family: verdana,helvetica,sans-serif;">
ily: verdana,helvetica,sans-serif;"> vetica,sans-serif;">VIKRAM
a,sans-serif;">
d>


=0AThe INTE=
RNET now has a personality. YOURS! e_yyi_1/*http://in.yahoo.com/" target=3D"_blank">See your Yahoo! Homepage a>.
--0-1781688521-1268909381=:78536--

--0-1333068602-1268909381=:78536
Content-Type: text/plain; charset=us-ascii


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org
--0-1333068602-1268909381=:78536--