Mark,
I've had some of the same thoughts as yours. Others have mentioned SHOW
CREATE TABLE.
I created a Windows program to put a GUI interface on designing tables for
MySQL to ease the load on my memory while setting up a database. It
includes the ability to insert new fields at any place and
Dude.
http://www.phpmyadmin.net/
Daevid Vincent
http://daevid.com
> -Original Message-
> From: Mark Manning [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 16, 2004 7:38 AM
> To: [EMAIL PROTECTED]
> Subject: Wish List of Features
>
> I downloaded MySQL and began playing with it. I
Hi Mark,
1. See the mysqldump utility. (separate to the mysqlcc and mysql). You can dump the
whole server, a selected db, or table including or excluding the table data (ie
structure only).
eg. mysqldump -B -a -d -u -p > dumpfile.sql
will dump the structure of database to file dumpfile.sql.
You already can insert a column before or after another column.
ALTER TABLE blah_table ADD COLUMN column_new VARCHAR(25) AFTER
column_existing;
Don't count on my syntax being perfect, but it is pretty easy to do what
you are saying using the MySQL client
Daniel Gibby
David Griffiths wrote:
1)
1) Try, SHOW CREATE TABLE table_name from the mysql client utility. It will
give you a create-table command.
In MySQL Control Center, you can do the same thing, but for all tables at
once. Select the database with your tables, and open the tree. Right click
on the Tables item, and choose, Tools->S
