Copy table with column attributes

Hi all. What's the quickest way to copy a table so that all column attributes such as auto_increment and primary key along with all indexes get copied over? I like using: create table new_table select * from old_table But it doesn't copy any indexes or those special attributes I mentioned

How to see warning messages for load data infile

Hi all. I'm trying to load a file into mysql using load data infile and got a ton of warnings. Is there any way to see what the warnings are? Thanks. David - Before posting, please check: http://www.mysql.com/manual.php

Convert dates for import into Mysql

Hi all. Does any one know how to convert dates like 06-Sep-02 00:00:00 into the mysql datetime format? The main challenge here is probably converting the 3 letter abbreviations for the month. Thanks for any input. David -

RE: Convert dates for import into Mysql

Message- From: Peter Engström [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 10, 2002 12:18 PM To: David Yee Cc: [EMAIL PROTECTED] Subject: Re: Convert dates for import into Mysql Hi David! What language do you use to build your application? You can do this easily with PHP

RE: Convert dates for import into Mysql

12:18 PM To: David Yee Cc: [EMAIL PROTECTED] Subject: Re: Convert dates for import into Mysql Hi David! What language do you use to build your application? You can do this easily with PHP. Please have a look at the following functions http://se.php.net/manual/en/function.strtotime.php

Importing fixed-length records

Hi. How can I import a text file containing all fixed-length records into MySQL? Is there a way to do it with LOAD INFILE? The text file was originally designed for import into Oracle. Thanks. David - Before posting,

MySQLl performance on Linux versus XP/W2K

Is MySQL 3.23/4.01 faster on Linux (RH 7.2) or Windows XP/2000 with the same hardware? Thanks. David - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the