MySQL Forums
Forum List  »  Newbie

Populating tables
Posted by: Louis Hadjiandreou
Date: March 22, 2013 05:03PM

I have created a table called Clients.

It consists of Client_id, First_Name, Last_Name, Address1, Address2, Address3, City, PostCode, Email_Address.

I've set the Client_id as the primary key, now when I want to populate the table I don't want to enter the client_id myself all the time, I want the client_id to be created automatically, so say I have CID001 for my first client_id, then I want it to then assign CID002 to the second client, and so on and so on, how can I go about doing that? Is that possible or would I need to always enter the client_id manually?

Options: ReplyQuote

Written By
Populating tables
March 22, 2013 05:03PM
March 22, 2013 09:00PM
March 23, 2013 01:10PM
March 23, 2013 08:50PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.