How can I select just the 'Create Table' column of SHOW CREATE TABLE? MySQL SHOW CREATE TABLE tablename has two columns of output, 'Table' and 'Create Table'.  How can I select just the 'Create Table' data?
I've tried
mysql&gt; SELECT 'Create Table' FROM (SHOW CREATE TABLE tablename);

and
mysql&gt; SELECT `Create Table` FROM (SHOW CREATE TABLE tablename);

Both result in syntax errors.  I'm not sure what else to try.
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.