MySQL Forums :: Newbie :: Populating tables

Advanced Search

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

Subject Written By Posted
Populating tables Louis Hadjiandreou 03/22/2013 05:03PM
Re: Populating tables Peter Brawley 03/22/2013 09:00PM
Re: Populating tables Rick James 03/23/2013 01:10PM
Re: Populating tables Barry Galbraith 03/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.