Re: Junction entities VS. JOIN

2001-01-24 Thread Dylan Shea
Benjamin, beautifully put. Thank you both so much. --Dylan Shea Benjamin Pflugmann wrote: > Hi. > > It's simply that you can look at (a_id,b_id) as a PRIMARY KEY. You > don't need an additional, aritificial sequence number ab_id. > > CREATE TABLE table_ab ( >

Back up procedure for Mysql

2001-01-24 Thread Dylan Shea
http://tips.pair.com/index.php3?page=php3mysql_backupmysqldatabase When use of the following examples replace $host with hostname/IP of your MySQL server. $user with your username $pass with your password $database with your databasename $table with your table

Re: ArabiaSoft and NuSphere

2001-01-24 Thread Dylan Shea
ckage. b.t.w. I was using the the RH7 Linux version. Installing Abriasoft SQL on top of a fresh RH7 install will solve you a lot of hassle due to bugs in key RH7 packages. --Dylan Shea "Frank J. Schmuck" wrote: > Any comments on the packages from ArabiaSoft

Re: Junction entities VS. JOIN

2001-01-24 Thread Dylan Shea
n record ids? Technically, it shouldn't, but does good db form require it? or is a junction entity normalization table exempt from that? thanks again --Dylan Shea "Carsten H. Pedersen" wrote: > > I'm afraid this borders on sql/db question material vs. specific mysql &g

Junction entities VS. JOIN

2001-01-24 Thread Dylan Shea
arches for b_id based on a a_id value are fast, and vice-versa? thanks --Dylan Shea - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To requ