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 over

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

RE: Convert dates for import into Mysql

Thanks to Peter's hint here's an example of how I'll be doing it using PHP: David > -Original 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

nal 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

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 - Be

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, please

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 l