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 to move fields
around to make the structure make sense for sometime down the road when I
try to remember what I did. It's handy when first creating a table. I
haven't released it but if someone wants to take a look, let me know.
Eldon Ziegler
At 10:38 am 3/16/2004, you wrote:
>I downloaded MySQL and began playing with it. It is a very impressive
>program and many awards should go to everyone who has ever worked on this
>project. :-)
>
>Since I'm mainly just playing around with the server right now I could
>never be considered a real user until I've created a few databases and
>have gotten into the feel of MySQL. Still, after having played with it
>(and mysqlcc) for a while - there were a few things I wanted to ask
>about. Especially since these features might already exist and I just
>haven't gotten to them in the MySQL book. (I'm using the Paul DuBois book.)
>
>I used to use FoxBase+ quite a bit and eventually, where I work, I wrote
>several database applications using my own code. One of the things I
>found very useful was:
>
>1. LIST STRUCTURE. Which would dump an exact copy of the commands used to
>create a table in a database. Thus, in MySQL, this command would display
>the correctly coded CREATE TABLE command for each table. This command
>used to be in FoxBase+ and I have found it very useful several times. I
>know about the SHOW COLUMNS command - it is not the same although I could
>write some code to extract it and then create the CREATE TABLE command
>from it. (This is just one of those ease of use/convience things.)
>
>The second thing I can not figure out, is how to rearrange my entries in
>the table. In MySQLCC, I can not find any command which will allow me to
>move items up and down in the list. Granted that, if there is data in the
>database, this could cause problems - but if you are just trying to set up
>a database and you go "Oops! I forgot to put in X" - you can not put X
>anywhere except at the very bottom of the list. So my next thing is a
>question:
>
>2. Is there a way to reorganize your table's layout in MySQLCC? Or do I
>have to delete the entire table and start over?
>
>Again, I am pulling from my FoxBase+ background. In FoxBase+ you can
>insert new fields into the table and what it would do in the background is
>to change the name of the table to a temporary name, build the new field
>list, and then port the old table over to the new one and get rid of the
>temporary table. This is (again) an ease of use/convience thing. A
>script could be written to do this I suppose but then I'd still have to
>create the new table, get out of mysqlcc, run the script, and then get
>back in again. It would be nicer if mysqlcc had this built in. (I
>hope! :-) )
>
>TIA! To whomever answers this message. :-)
>
>Mark
>
>
>
>--
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe: http://lists.mysql.com/mysql?unsub=1
Eldon Ziegler
President
ProAtion Systems, Inc.
www.proation.com
