修改MySQL Workbench支持json格式

版权声明:本文为博主原创文章,遵循 CC 4.0 BY-SA 版权协议,转载请附上原文出处链接和本声明。
本文链接:https://blog.csdn.net/u012163234/article/details/85159127

首先,MySQL 5.7.8及其以上才支持json。所以请先确认好MySQL版本。

修改MySQL Workbench支持json格式步骤:
1、菜单 -> Edit -> Preferences

菜单 -> Edit -> Preferences

2、Modeling -> MySQL
修改「Default Target MySQL Version」为对应的服务器版本即可。

Modeling -> MySQL

有关MySQL json格式的资料:

展开阅读全文

修改json格式

07-04

使用js对json进行操作,"AreaName":"江苏省","AreaCode":"320000","AreaName":"南京市","AreaCode":"320100","AreaName":"市辖区","AreaCode":"320101","AreaName":"玄武区","AreaCode":"320102","AreaName":"白下区","AreaCode":"320103","AreaName":"秦淮区","AreaCode":"320104","AreaName":"建邺区","AreaCode":"320105","AreaName":"鼓楼区","AreaCode":"320106","AreaName":"下关区","AreaCode":"320107","AreaName":"浦口区","AreaCode":"320111","AreaName":"栖霞区","AreaCode":"320113","AreaName":"雨花台区","AreaCode":"320114","AreaName":"江宁区","AreaCode":"320115","AreaName":"六合区","AreaCode":"320116","AreaName":"溧水县","AreaCode":"320124","AreaName":"高淳县","AreaCode":"320125"这种样式的数据转换成rnrn"AreaName":"江苏省","AreaCode":"320000","cityList":["AreaName":"南京市","AreaCode":"320100","areaList":["AreaName":"市辖区","AreaCode":"320101","AreaName":"玄武区","AreaCode":"320102","AreaName":"白下区","AreaCode":"320103","AreaName":"秦淮区","AreaCode":"320104","AreaName":"建邺区","AreaCode":"320105","AreaName":"鼓楼区","AreaCode":"320106","AreaName":"下关区","AreaCode":"320107","AreaName":"浦口区","AreaCode":"320111","AreaName":"栖霞区","AreaCode":"320113","AreaName":"雨花台区","AreaCode":"320114","AreaName":"江宁区","AreaCode":"320115","AreaName":"六合区","AreaCode":"320116","AreaName":"溧水县","AreaCode":"320124","AreaName":"高淳县","AreaCode":"320125"]]rn这种形式的,用js怎么实现??大神求帮助 论坛

没有更多推荐了,返回首页