Articles:

• mysql: How can I rename a database (122415)
• How can I rename table names and column names in mysql (28666)
• How to compare strings in mysql case sensitive (18607)
• Compare 2 dates in mysql (17702)
• Lock an entire mysql database with all its tables (14549)
• How to reset the root password on mysql (12834)
• mysql message ERROR 1054 (42S22): Unknown column in 'on clause' (11530)
• Create UNIQUE Index yields a not unique index in mysql - why? (10718)
• concat () function to concatenate 2 strings in mysql does not exist (5464)
• How to change the next value of an auto_increment field (5160)
• How can I obtain the next auto_increment number (before inserting a record)? (4270)
• My timestamp field in mysql does not update (4081)
• Problems installing DBD::mysql on Solaris 8 (3914)
• Best operating system settings for mysql throughput (3735)
• How to install mysql 5 on Solaris 8 (3711)
• Kill a long running blocking sql statement (3623)
• Handling of dates in mysql (Date formats) (3550)
• How to pick a random record from a mysql table (3260)
• Creating a table with an autoincrement primary key (3239)
• Can I install MySQL without root access? (3159)
• How to limit the size of a MySQL database (3121)
• Restoring the mysql system user table (2614)
• Setting a user password in mysql (Why do I get 'Access denied') (2417)
• What is the MERGE statement good for? (2414)
• Implementing a full text search with mysql (2392)
• Modifying a field to be auto_increment (2387)
• Extracting a table definition from the command line (2257)
• Exporting and importing between 2 mysql databases (2242)
• How can I connect to mysql? I need to update the helpdesk backend (2233)
• count(*) syntax in mysql (2230)
• Stub to connect from a C program to mysql (1994)
• count(distinct fieldname) very slow in mysql (1890)
• JDBC error message Illegal hour value for java.sql.Time type in value (1273)
• What timezone is my mysql database server running in? (1022)
• How to log all mysql database modifications (969)
• Location of mysql startup script (912)
• Monitoring mysql status (496)

How to change the next value of an auto_increment field Question: I have a table where the primary key is an auto increment field. I just deleted the last 2 rows and when the next record will be created it will use the next higher number but I'd like to subtract 2 from the auto_increment value. How can I do this? Answer: Use the ALTER TABLE statement as shown below: /* this makes the next record have 911 in the auto increment field: */ alter table MYTABLE auto_increment=911;