John
ALTER TABLE ADD [column] col_declaration
is what you are after I think - no need to go making another table
For example:-
ALTER TABLE example_table ADD example_column INT UNSIGNED NOT NULL
AUTO_INCREMENT
With the greatest regards to Paul DuBois whose marvellous book MySQL this is
unashemedly ripped off from and to whom I owe everything I know about this
app! :-)
Andy
----- Original Message -----
From: "John Vaughan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 28, 2001 9:11 PM
Subject: Table reorg question
> Hello
>
> I am using MYSQL Server version 3.22.27 on a Redhat Linux System. The
> question I have is I have created a database with three tables in it. One
> of the tables has been populated by data. I later decided I wanted to add
a
> new column to the already populated table. Can anyone explain or point me
> to relevant information about how I can create another table with the new
> column and then import the data from the old table. I used mysqldump to
> export the data but when I try to use mysqlimport to import the dump file
to
> the newly created table structure I get the following error:
>
> Can't get stat of '/path/filename'
> (Errcode: 2), when using table: tablename
>
> Anyone have any suggestions about reorganizing a table??
>
> John Vaughan
> Micro Analysis & Design, Inc.
> 4900 Pearl East Circle, Suite 201 E
> Boulder, CO 80301
> 303 442-6947
> 303 442-8274 fax
> mailto:[EMAIL PROTECTED]
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
