MySQL Forums
Forum List  »  Newbie

Zero fill
Posted by: Marc Janzs
Date: December 28, 2016 12:06PM

Dear all, as im new to mysql im struggeling with the following. I have 3 tables. 1 table is project name, 2 is project addres and 3 is a project managers name. All tables have a primairy key. I would like to know how i can make sure that the autoincrement of all tables keep in line so that i can querie a WHERE statement: projectnameID and projecctaddressID and projectmanagersID is the same. As in my case i can occure that i have a projectname but not the address or the projectmanager name. I would like that if i have not all the data available the autoincrement of the empty tables still add up, so that i later kan go into the accordibg empty row and update the table with the data when available. Thanks for your help to a newbie.

Options: ReplyQuote


Subject
Written By
Posted
Zero fill
December 28, 2016 12:06PM
December 28, 2016 12:56PM
January 10, 2017 06:08AM


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.