MySQL describe table output as query

sttris · February 9, 2019, 6:24pm

Hi there.
I am working on a small Python script to automate MySQL DB migration on a PacsOne DICOM server.
I want to get the structure form one DB and append it to another DB.
I’m a little stuck on a problem with MySQL. When I run a ‘describe table’ query in Python, the output I get is like ‘path varchar(255) NO None’. The NO stands for NOT NULL.

Is there any way in MySQL to see the ‘describe table’ output as a query, e.g. “path varchar(255) not null;” ?
Thanks a lot in advance!

BGL · February 9, 2019, 7:03pm

I’ve never used it but this might be worth a look?

cburn11 · February 9, 2019, 7:07pm

The command:

show create table DB_NAME.TABLE_NAME;

generates the sql command needed to create the table.

sttris · February 9, 2019, 7:10pm

TNX a lot!!!

gnif · February 13, 2019, 10:22pm

If you’re looking to parse this, SHOW INDEX FROM db.table could also be useful to you. The information is included in the SHOW CREATE TABLE output also, but this might make things easier to handle.