By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,154 Members | 1,031 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,154 IT Pros & Developers. It's quick & easy.

auto generate id on customer table like cus001.

P: 9
I want develop customer table. here i want create customer id like cus01 .i insert into more customer its automatically add id cus02 next automatically increase cus03 etc,in php mysql how to do this help me frnds.
Dec 27 '14 #1
Share this Question
Share on Google+
1 Reply


Expert 100+
P: 1,035
For the auto increment field: RTFM

",in php mysql how to do this help me frnds"
There's no such thing as php MySQL.
PHP is a programming language
and MySQL is a database.

When inserting a record in the table of the database that has an auto increment field, inserting NULL will give it the next value.
Expand|Select|Wrap|Line Numbers
  1. INSERT INTO customer (customerid, name)
  2. VALUES (NULL, 'webtechbharathi ');
  3.  
Dec 27 '14 #2

Post your reply

Sign in to post your reply or Sign up for a free account.