RE: Is "select ... insert" working with 3.23(58) ??

ginal Message- > From: Kristen G. Thorson [mailto:[EMAIL PROTECTED] > Sent: mercredi, 14. décembre 2005 22:14 > To: RAPPAZ Francois > Cc: mysql@lists.mysql.com > Subject: Re: Is "select ... insert" working with 3.23(58) ?? > > RAPPAZ Francois wrote: > > >H

Is "select ... insert" working with 3.23(58) ??

Hi I'm stuck with a sequence of sql commands to duplicate a record whithin the same table (server is 3.23.58): I have table t1 with data : char and id: auto_increment, int, unsigned, primary key. I would like to do the following SET @template = 104; DROP table IF EXISTS tmp; CREATE TABLE tm

RE: SQL to use left join and find missing values

some more). Greetings François > -Original Message- > From: Brent Baisley [mailto:[EMAIL PROTECTED] > Sent: mardi, 20. septembre 2005 21:29 > To: RAPPAZ Francois > Cc: mysql@lists.mysql.com > Subject: Re: SQL to use left join and find missing values > > If you w

SQL to use left join and find missing values

Hi all with Mysql 3.23 I would like to find missing values in the following situation: 1) table boxes: describes kind of boxes differing by how many items I can put in. Primary key is BoxID boxID + Places A + 1 B + 3 C + 5 2) table car describes how I can put some boxes on a