• Home
  • About
 

Nuage Blog

Nuage Directors and Employees blog

database

...now browsing by tag

 
1and1 1and1 Hosted Exchange Activesync autodiscover autoincrement business it services cloud cloud computing database Dates email Entourage Exchange 2007 Exchange settings file server hassle free hosted exchange IE 6 Installation Internet Explorer 6 kaspersky Linux Mac Microsoft Access Microsoft Exchange MySQL nuage Nuage Hosted Exchange ODBC offline online outlook 2007 Pictures Port prompting for old exchange password Render Issues sage security Sent items not syncing SQL support Using VoIP Windows Mobile Wordpress
 

Setting auto increment value in MySQL

Thursday, March 19th, 2009

Use:

ALTER TABLE tbl_name AUTO_INCREMENT = 1000;

Note that if you set the auto_increment value and delete rows, the auto_increment value starts from 1 again. Delete the rows first, then set the auto increment value.

Twitter It!

Posted in Uncategorized | No Responses »
Tags: autoincrement, database, MySQL

  •  
    September 2010
    M T W T F S S
    « Aug    
     12345
    6789101112
    13141516171819
    20212223242526
    27282930  
  • Meta
    • Log in
    • Entries RSS
    • Comments RSS
    • WordPress.org
  • Tags
    1and1 1and1 Hosted Exchange Activesync autodiscover autoincrement business it services cloud cloud computing database Dates email Entourage Exchange 2007 Exchange settings file server hassle free hosted exchange IE 6 Installation Internet Explorer 6 kaspersky Linux Mac Microsoft Access Microsoft Exchange MySQL nuage Nuage Hosted Exchange ODBC offline online outlook 2007 Pictures Port prompting for old exchange password Render Issues sage security Sent items not syncing SQL support Using VoIP Windows Mobile Wordpress

Powered by WordPress | © 2010 Nuage Blog | A WPHackr Experience