场景
使用show columns 语句得到数据表的表结构,如下:
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | No | PRI | ||
address | varchar(255) | Yes | |||
brith_day | dateTime | Yes | |||
sex | varchar(255) | Yes | |||
user_name | varchar(255) | Yes |
将其封装成JSON对象,如下:
[
{
"Field":"id","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment"},
{
"Field":"table_name","Type":"varchar(40)","Null":"NO","Key":"","Default":null,"Extra":""},
{
"Field":"column_name","Type":"varchar(40)","Null":"NO","Key":"MUL","Default":null,"Extra":""},
{