Lance Lovette writes:
> TYPE=PACKED does not seem to be documented in Chapter 7.7 in the online
> documentation. Where can I find a description of the PACKED option?
>
> Also, can it be noted in the documentation that CREATE ... SELECT * FROM ...
> does not create an exact copy of the table? Had
would not have noticed all the 320MB temporary tables I'd have been
creating.
-Original Message-
From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 17, 2001 6:40 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: ERROR 1060: Duplicate column name
Lance Lo
Lance Lovette writes:
> Thanks for the clarification. Is it a MySQL bug then that the CREATE query
> converts all the VARCHAR fields into CHAR fields so the query 'CREATE
> TEMPORARY TABLE User2 SELECT * FROM User' creates a temporary table much
> larger than the User table?
>
No, this is not a
l Widenius [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 16, 2001 9:32 AM
To: Lance Lovette
Cc: MySQL
Subject: ERROR 1060: Duplicate column name
Hi!
>>>>> "Lance" == Lance Lovette <[EMAIL PROTECTED]> writes:
Lance> The following CREATE TABLE statements seem st
column name" errors?
mysql> CREATE TEMPORARY TABLE User2 (UserID int(11)) SELECT UserID FROM
Lance> User;
Lance> ERROR 1060: Duplicate column name 'UserID'
The above is an correct error message.
What you are trying to do is the following:
CREATE TEMPORARY TABLE User2 (UserID
Thank you for your bug report.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
-
The following CREATE TABLE statements seem straight forward but they all
fail. Can someone explain why they fail and what I can do to get rid of the
"Duplicate column name" errors?
mysql> CREATE TEMPORARY TABLE User2 (UserID int(11)) SELECT UserID FROM
User;
ERROR 1060: Duplicat
