Re: QUICK: What is the optimal way to store opening times ?

[Mark Matthews]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Alliax wrote:

Thank you for this and for the previous answer about create temporary table,

your RestTimes is a nice way to do it, but it multiplies the number of rows
of the table.
So you say it's better to have more rows than have less row, when doing
simple select query?
I'll do it your way then, except if somebody has a better idea ?

In a very general way, what you describe is a layman's definition of 'normalization'.

You will want to learn more about it to create flexible/maintainable databases. A good SQL book would cover data modeling and database design in detail. For starters, you might want to take a look at:

http://www.farmingdale.edu/~porciem/bcs260/bcs260d10.html

for a quick overview (thanks to 'SPeacock' for the pointer to the website).

-Mark
- -- For technical support contracts, visit https://order.mysql.com/?ref=mmma

__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mark Matthews <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java
/_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA
<___/ www.mysql.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.1.90 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE98BZxtvXNTca6JD8RAtGaAJ43gb7Mvsp86s5fd+1vRYfcjxrFfACfUYFt
yv+BEBDLUfFsfnPCCcbnK9Y=
=uOeG
-----END PGP SIGNATURE-----


---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php