mySQL isn't really my area but a quick Google threw up a few options:
the following site has code for scraping the code from
information_schema_STATISTICS
http://rogerpadilla.wordpress.com/2008/12/02/mysql-export-indexes/
or you could probably use your own code to scrape the KEY (and maybe
CONSTRAINT) lines of SHOW TABLE CREATE ... then build ALTER TABLE
,'tbl'. ADD KEY <'key info'>.... commands.
On 20/10/2014 15:17, [email protected] wrote:
Anyone? Buehler? Buehler? Buehler?
On 2014-10-16 21:51, [email protected] wrote:
(with VFP9SP2 app)
I'm developing code where I'm creating client-specific tables based on
original model tables. I'm using SHOW CREATE TABLE
`<<dbc>>`.`<<table>>` to get the CREATE TABLE syntax. However, while
that will make a duplicate table (after I create a new name of
course), it does not create the indexes that go with it.
Does anyone know which meta-table the index expressions are kept? I
was so excited that it was so easy to get the CREATE TABLE syntax with
one command, but without the indexes, that kinda defeats what I was
trying to do.
Thanks,
--Mike
[excessive quoting removed by server]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
