Elias,
ALTER TABLE will do the biz: http://www.mysql.com/doc/en/ALTER_TABLE.html
Regards,
=dn
> I would like to know if it is possible to configure mysql auo increment
> feild to start from a specific number or configure it to have a specific
> character such as a letter inserted infront of it
According to the book I'm working from right now, you can't do this directly. What it
suggests is that you insert the first row in your table manually and insert the
integer that you want to start at. AUTO_INCREMENT will then use this number as its
starting point and continue upwards.
I haven'
I solved the problem, it was application problem.
but, Joseph, your method doesn't work
becos application is not continually logged in to the DB.
if the process is newly login, last_insert_id is 0
then the update will update the auto increment field to 0
becos select last_insert_id() returns 0.
ÅÇ´f¼Ù(Borus.Kung) a écrit :
>
> Hi all,
>
> I have a serious problem.
> I have a production system just launch using MySQL.
> auto increment field is used in the system by ASP, Visual Basic and C.
> System is using AIX 4.3.3, MySQL 3.23.49
> gcc 2.9 source code compiled MySQL
>
> There are so
