Database reference material

[phppup]

Are there any guides/tutorials online that you would recommend to upgrade my skills?

I've found several but nothing that was spectacular.

One site started

Quote

Unless you have a good reason not to, a 1:1 relationship usually indicates that you’d be better off combining the two tables’ data into a single table.

Does this seem like an accurate statement?

[Barand]

It seems reasonable to me, given the initial caveat.

[requinix]

"Don't do a thing unless you have a good reason to do the thing" is all-around pretty reliable advice.

[phppup]

I would have thought that less columns translates to faster/more efficient searching.

If I have id, name, email, phone, birthday, favorite_color as fields then these are all 1:1.

But if I primarily refer to id, name, and email, I would think a 1:1 with a table of "personal_details" would seem appropriate.

[Barand]

17 minutes ago, phppup said:

I would have thought that less columns translates to faster/more efficient searching.

So just, for example, "SELECT id,name, email FROM ..." so you only retrieve what you need. That's why you shouldn't use "SELECT * " in queries as that retrieves every column, need it or not, and slow your queries.

[EDIT]

PS That's one of the reasons not to use SELECT *.

Edited May 11, 2022 by Barand

[phppup]

It's starting to make more sense.