Shulou(Shulou.com)06/01 Report--

# spell key- > value (json string) into sql statement

DELIMITER / /

DROP FUNCTION kvJsonData//

CREATE FUNCTION kvJsonData (tableName char (20), medKeys text,medValues text,orderId int (11))

Returns text

BEGIN

Declare num int (11)

Declare count int (2) default 1

Declare strValues text default ""

Declare strKeys text

Declare ret text default ""

Set strKeys=concat (medKeys,', `order_ id`)

Set ret=concat ("insert into", tableName, "(" strKeys, ") values")

Set num= LENGTH (medValues)-LENGTH (REPLACE (medValues,'#,')) + 1

While count

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.