shell for osX

2002-01-26 Thread mike vogel
can anyone recommend a command line shell to admin mysql that will run under osX? thanks in advance! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the l

temporary table?

2002-01-24 Thread mike vogel
how can i select a join and then use the resulting table in another join? i did it with a temporary table, but is there a way to do it with a single compound statement? thanks in advance! - Before posting, please check: htt

Fwd: three-way join

2002-01-23 Thread mike vogel
2002 03:25:06 PM US/Pacific > To: mike vogel <[EMAIL PROTECTED]>, [EMAIL PROTECTED] > Subject: RE: three-way join > > > > create table magazine > (Mag_id int primary key, > Name char(30)); > > create table customer > (cust_id int primary key, > name char

three-way join

2002-01-23 Thread mike vogel
i understand that creating a M:N relationship in mysql involves 3 tables, one of which being a bridge, but how do i join the first and third tables by way of a bridge? example: a table of subscribers and a table of magazines with a bridge in the middle. how do i select just the magazines fr

selecting column names into rows of another table

2002-01-23 Thread mike vogel
i want to select the column names from one table into the rows of another. is this possible? thanks in advance! -kp - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/