re: MySQL insert issue related to a unique column

Jeff, Thursday, October 10, 2002, 5:44:28 PM, you wrote: JZ I have a MySQL 40 column table where I select an entire row then insert JZ it into another (different) 40 column table. For some reason the insert JZ fails and after much troubleshooting I've isolated the cause to a field JZ heading

MySQL insert issue related to a unique column

, 2002 7:56 AM To: '[EMAIL PROTECTED]' Subject: MySQL insert issue related to a unique column I have a MySQL 40 column table where I select an entire row then insert it into another (different) 40 column table. For some reason the insert fails and after much troubleshooting I've isolated the cause

Unique column ?

it.. (or set up an automated maintenance).. EG... Ive got Columns, Unique, Name, Surname, Figure, Date, Etc... And when I enter data into the table - EG, John, Smith, 09-678-1234, Paid.. The first (unique) column will automatically be set to '1' The next row I insert into the table, the unique column

Re: Unique column ?

maintaining it.. (or set up an automated maintenance).. EG... Ive got Columns, Unique, Name, Surname, Figure, Date, Etc... And when I enter data into the table - EG, John, Smith, 09-678-1234, Paid.. The first (unique) column will automatically be set to '1' The next row I insert

A join query does not produce unique column names in result

(mysqlbug died because it couldn't find rmail. So, I'm sending this manually.) Description: I have a join pulling two columns (both named 'id') from two different tables. When these results are returned, in the result set, they are both called 'id', with no way to refer to them