Re: [MySql] dumping table structure

[trammell]

In the interests of completeness:

% echo "show create table mytable" | mysql -r mydb

I prefer the "create table" syntax because table index information is complete, unlike the output of DESCRIBE table.

[thor]

I know nothing of MySQL, but do indicies have to be created at table create time? In other database engines, you can create them whenever. If that's the case in MySQL, will your command necessarily show the indicies? Just curious...

[lupey]

"I know nothing of MySQL, but do indicies have to be created at table create time?"

No, you can add them with the ALTER TABLE syntax. See the MYSQL docs at ALTER Table syntax

lupey