--describe_tables
Switch
--describe_tables
Description
Describe MySQL tables. Will print the description of the tables specified by -t, -f and --outcome_table if any of those flags are present. Also takes optional positional arguments and prints the description of those tables as well.
Other Switches
Required Switches:
Optional Switches:
Example Commands
dlatkInterface.py -d dla_tutorial -t msgs --describe_tables
SQL QUERY: DESCRIBE msgs
Field Type Null Key Default Extra
message_id int(11) NO PRI auto_increment
user_id int(10) unsigned YES MUL
date varchar(64) YES
created_time datetime YES MUL
message text YES
dlatkInterface.py -d dla_tutorial -t msgs --describe_tables blog_outcomes
SQL QUERY: DESCRIBE msgs
Field Type Null Key Default Extra
message_id int(11) NO PRI auto_increment
user_id int(10) unsigned YES MUL
date varchar(64) YES
created_time datetime YES MUL
message text YES
SQL QUERY: DESCRIBE blog_outcomes
Field Type Null Key Default Extra
user_id int(11) NO PRI
gender int(2) YES
age int(3) unsigned YES
occu varchar(32) YES
sign varchar(16) YES
is_indunk int(1) YES
is_student int(1) YES
is_education int(1) YES
is_technology int(1) YES