MySQL Forums
Forum List  »  PHP

Re: Query Help - Duplicate Records
Posted by: Peter Brawley
Date: November 22, 2016 02:14PM

Joins are absolutely fundamental to relational databases. Designing databases isn't like using a word processor or spreadhseet. There's a crucial theory, a set of basic rules, you absolutely must know. Stop designing long enough to study up on relational dbs and sql.

...tblname as name... is an alias.

> we will be serving thousands of customers, each with their own table

Probably also a design error. ya think Visa keeps every ID and associated data in its own table!? Have you ever pulled up someone else's purchases when browsing your credit card statement?

Putting data in a separate table is no less error-prone than storing data from multiple customers in one table according to well-designed key, but it's vastly less efficient.

Options: ReplyQuote


Subject
Written By
Posted
Re: Query Help - Duplicate Records
November 22, 2016 02:14PM


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.