帮我把以下JSON字符串转换成对应的sql语句,JSON语句:{ "extData": { "result": [ { "bas_medn_flag": "0", "med_chrgitm_type": "09", "det_item_fee_sumamt": 15, "hi_nego_drug_flag": "0", "fulamt_ownpay_amt": 0, "cnt": 1, "pric": 15, "memo": "", "feedetl_sn": "1091", "inscp_scp_amt": 15, "overlmt_amt": 0, "pric_uplmt_amt": 0, "selfpay_prop": 0, "chld_medc_flag": "0", "preselfpay_amt": 0, "lmt_used_flag": "0", "chrgitm_lv": "01" } ], "upload": [ { "basMednFlag": "0", "feedetlSn": "1091", "preselfpayAmt": 0, "selfpayProp": 0, "medChrgitmType": "09", "cnt": 1, "overlmtAmt": 0, "pric": 15, "memo": "", "pricUplmtAmt": 0, "chrgitmLv": "01", "inscpScpAmt": 15, "detItemFeeSumamt": 15, "lmtUsedFlag": "0", "fulamtOwnpayAmt": 0, "hiNegoDrugFlag": "0", "chldMedcFlag": "0" } ], "mdtrtId": "4401002305202305291758258", "register": { "iptOtpNo": "LP202305121737529978305IR9", "psnNo": "44010000003503430694", "mdtrtId": "4401002305202305291758258" } }, "payOrdId": "ORD440100202305291741030000642", "payToken": "TSN440100202305291741020008660" }
时间: 2023-07-03 10:21:51 浏览: 68
以下是将JSON字符串转换为SQL语句的示例代码:
```
-- 创建表
CREATE TABLE IF NOT EXISTS `table_name` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`bas_medn_flag` varchar(255) DEFAULT NULL,
`med_chrgitm_type` varchar(255) DEFAULT NULL,
`det_item_fee_sumamt` decimal(18,2) DEFAULT NULL,
`hi_nego_drug_flag` varchar(255) DEFAULT NULL,
`fulamt_ownpay_amt` decimal(18,2) DEFAULT NULL,
`cnt` int(11) DEFAULT NULL,
`pric` decimal(18,2) DEFAULT NULL,
`memo` varchar(255) DEFAULT NULL,
`feedetl_sn` varchar(255) DEFAULT NULL,
`inscp_scp_amt` decimal(18,2) DEFAULT NULL,
`overlmt_amt` decimal(18,2) DEFAULT NULL,
`pric_uplmt_amt` decimal(18,2) DEFAULT NULL,
`selfpay_prop` decimal(18,2) DEFAULT NULL,
`chld_medc_flag` varchar(255) DEFAULT NULL,
`preselfpay_amt` decimal(18,2) DEFAULT NULL,
`lmt_used_flag` varchar(255) DEFAULT NULL,
`chrgitm_lv` varchar(255) DEFAULT NULL,
`mdtrtId` varchar(255) DEFAULT NULL,
`iptOtpNo` varchar(255) DEFAULT NULL,
`psnNo` varchar(255) DEFAULT NULL,
`payOrdId` varchar(255) DEFAULT NULL,
`payToken` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- 插入数据
INSERT INTO `table_name` (
`bas_medn_flag`,
`med_chrgitm_type`,
`det_item_fee_sumamt`,
`hi_nego_drug_flag`,
`fulamt_ownpay_amt`,
`cnt`,
`pric`,
`memo`,
`feedetl_sn`,
`inscp_scp_amt`,
`overlmt_amt`,
`pric_uplmt_amt`,
`selfpay_prop`,
`chld_medc_flag`,
`preselfpay_amt`,
`lmt_used_flag`,
`chrgitm_lv`,
`mdtrtId`,
`iptOtpNo`,
`psnNo`,
`payOrdId`,
`payToken`
) VALUES (
'0',
'09',
15,
'0',
0,
1,
15,
'',
'1091',
15,
0,
0,
0,
'0',
0,
'0',
'01',
'4401002305202305291758258',
'LP202305121737529978305IR9',
'44010000003503430694',
'ORD440100202305291741030000642',
'TSN440100202305291741020008660'
);
```
请注意,上述SQL语句仅适用于您所提供的JSON字符串,如果JSON字符串的结构发生变化,可能需要根据新的结构进行修改。