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
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?
-Original Message-
From: Michael Widenius [
Thank you for your bug report.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
-