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

- 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: Hi I'm stuck with a sequence of sql commands to duplicate

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

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 want to join a table more than once

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