Community /Pin to Profile Bookmark

Auto Increment

@oo7mlSep 16.2007

I have a ID field that auto increments ID’s when a user joins. I have 138 users at the moment. However i want to give users a 6 digit ID, so i was thinking of setting ID’s for any new users who join at 100001, instead of moving onto 139

How would i go about doing this…

to post a comment

1 Comments(s) _↴

@flannSep 16.2007 — #ALTER TABLE t2 AUTO_INCREMENT = value;

source: http://dev.mysql.com/doc/refman/5.0/en/alter-table.html

Also in #PHP _↴

sessions and folders?[RESOLVED] Checkbox Help Simple form question- checkboxes

×

Success!

Help @oo7ml spread the word by sharing this article on Twitter...

about: ({
version: 0.1.9 — BETA 5.19,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ
});

legal: ({
terms: of use,
privacy: policy
});

changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
)...

recent_tips: (
tipper: @AriseFacilitySolutions09,
tipped: article
amount: 1000 SATS,

tipper: @Yussuf4331,
tipped: article
amount: 1000 SATS,

tipper: @darkwebsites540,
tipped: article
amount: 10 SATS,
)...