How can I select just the 'Create Table' column of SHOW CREATE TABLE?
You can't use the result-set in MySQL directly, most connectors can give back a &quot;normal&quot; Result Set for SHOW, so you can use it in that language like a result from a select.
you must check out INFORMATION_SCHEMA Tables, there you find almost every information you need.