Nikita,
Try somehting like this:
mysql -hHOST -uUSER -pPASS -s -e'show tables' DATABASE | \
tail +1 | \
while read TABLE
do
echo == $TABLE ==
mysql -s -pwmihp -e"describe $TABLE" articles | sort
Done
I used the "tail +1" to trim out the header row -- tho I think there is
an option to make output less verbose.
> -----Original Message-----
> From: Nikita Tovstoles [mailto:[EMAIL PROTECTED]
> Sent: Friday, September 08, 2006 2:00 PM
> To: [email protected]
> Subject: Re: make mysqldump to sort columns alphabetically
>
> Thanks, Douglas!
>
> That seems OK, but I'd prefer to avoid altering the schemas
> in any way.
> In particular altering order of constraints seems
> error-prone, given that one is essentially re-defining these,
> not simply rearranging the order. Am I asking for impossible? ;-
>
> -nikita
>
> Douglas Sims wrote:
> > One way you could solve this is to conform the column
> orders between
> > the two versions.
> >
> > For example, if one table, t6, has columns id, name, and
> address and
> > the same table in the second database is id, address, name,
> you could
> > just ALTER the second database t6 table to be id, name, address:
> >
> > mysql> describe t6;
> > +---------+-------------+------+-----+---------+-------+
> > | Field | Type | Null | Key | Default | Extra |
> > +---------+-------------+------+-----+---------+-------+
> > | id | int(9) | NO | PRI | 0 | |
> > | address | varchar(32) | YES | | | |
> > | name | varchar(32) | YES | MUL | | |
> > +---------+-------------+------+-----+---------+-------+
> > 3 rows in set (0.00 sec)
> >
> > mysql> alter table t6 change column address address
> varchar(32) after
> > name;
> > Query OK, 0 rows affected (0.02 sec)
> > Records: 0 Duplicates: 0 Warnings: 0
> >
> > mysql> describe t6;
> > +---------+-------------+------+-----+---------+-------+
> > | Field | Type | Null | Key | Default | Extra |
> > +---------+-------------+------+-----+---------+-------+
> > | id | int(9) | NO | PRI | 0 | |
> > | name | varchar(32) | YES | MUL | | |
> > | address | varchar(32) | YES | | | |
> > +---------+-------------+------+-----+---------+-------+
> > 3 rows in set (0.00 sec)
> >
> > Here is the mysql documentation on ALTER TABLE:
> > http://dev.mysql.com/doc/refman/5.0/en/alter-table.html
> >
> >
> >
> > Douglas Sims
> > [EMAIL PROTECTED]
> >
> >
> >
> > On Sep 8, 2006, at 12:27 PM, Nikita Tovstoles wrote:
> >
> >> Hi,
> >>
> >> I'm diffing two versions of a schema produced using mysqldump and
> >> would like to know if there's a way to make mysqldump sort entries
> >> inside CREATE statements (say alphabetically or in some other way)?
> >> Currently some of the column declarations are juxtaposed
> between the
> >> versions and thus produce "false" diffs.
> >>
> >> Mysql 5.0, InnoDB
> >>
> >> thanks a lot
> >> -nikita
> >>
> >>
> >> --MySQL General Mailing List
> >> For list archives: http://lists.mysql.com/mysql
> >> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
> >
> >
> > --MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> > http://lists.mysql.com/[EMAIL PROTECTED]
> >
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
