|
Replies:
0
-
Pages:
1
|
Threads:
[
Previous
|
Next
]
|
|
Posts:
2
Registered:
10/31/11
|
|
|
|
automated script...
Posted:
Nov 15, 2011 4:37 PM
|
|
|
I have the following script:
SELECT DISTINCT C.TABLE_SCHEMA, C.TABLE_NAME, T.TABLE_COMMENT, C.COLUMN_NAME, C.COLUMN_TYPE, C.IS_NULLABLE, C.COLLATION_NAME, C.COLUMN_DEFAULT, C.COLUMN_COMMENT, T.TABLE_ROWS FROM information_schema.COLUMNS C, information_schema.`TABLES` T WHERE T.TABLE_SCHEMA = C.TABLE_SCHEMA AND T.TABLE_NAME = C.TABLE_NAME AND C.TABLE_NAME = 'INS_AK' AND C.TABLE_SCHEMA = 'CONSUMER_INSURANCE_PROD'
What I want to do is hav ethe script include all of the states and DC so that I can hit F5 once and have all 51 sheets in Excel automatically filled with the info. Is there anyone that can help achieve this? I would appreciate your help. Thanks for your time.
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
