export json structure to mysql -


i have app uses json files store data. app support cms (currently don't know one) need database, mysql. questions is, possible automate creation of tables? creation mean structure of them, neither populating them nor importing data json files.

yes is. use script create tables code:

create [temporary] table [if not exists] tbl_name     (create_definition,...)     [table_options]     [partition_options] 

the documentation see here: http://dev.mysql.com/doc/refman/5.7/en/create-table.html


Comments