Hi There,
MySQL is not my strong point so any guidance or advice will be greatly appreciated. I want to know what's the best way of linking multiple MySQL tables together. I have +-10 tables that will interact with each other.
Example Tables : users, logins, communication, sightings etc.
When the user uploads a picture it should store data in multiple tables for the specific upload and when he want's to view his upload it should use all the tables to populate all the info etc.
Kind Regards
Jump to Postwhatever is the database, selection of primary keys and foreign keys play important role in database design.
whatever is the database, selection of primary keys and foreign keys play important role in database design.
Hi Urtrivedi,
Thanks for the quick reply, so the best way of linking multiple tables is with the use of PRIMARY KEY's and FOREIGN KEY's
Kind Regards
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.