# Mysql Auto\_icrement

**URL:** https://forum.kirupa.com/t/mysql-auto-icrement/217035
**Category:** programming
**Created:** [February 22, 2007, 2:11pm UTC](https://forum.kirupa.com/t/mysql-auto-icrement/217035 "2007-02-22T14:11:51Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![borrob](https://avatars.discourse-cdn.com/v4/letter/b/a87d85/32.png) [@borrob](https://forum.kirupa.com/u/borrob)
#### Post date: [February 22, 2007, 2:11pm UTC](https://forum.kirupa.com/t/mysql-auto-icrement/217035/1 "2007-02-22T14:11:51Z")

</div>

Ok this is not really a php question but maybe somebody can help me.

i have a mysql table with the field id that’s an auto\_increment column.

but now i want the auto\_increment to start at ‘somenumber’ and not at 1  
anybody know the correct syntax for this when creating the table?  
only for this table so no global setting  
:cons: