INSERT `tn_Settings` (`ClassType`, `Settings`) VALUES ('SiteSettings,BusinessComponents','{"SiteKey":"'+cast( UUID() as Char(200)) +'"}');
在执行这个语句时报错 Truncated incorrect DOUBLE value: '"}'
求大神解救MySQL数据库Truncated incorrect
在执行这个语句时报错 Truncated incorrect DOUBLE value: '"}'
求大神解救MySQL数据库Truncated incorrect
'{"SiteKey":"'+cast( UUID() as Char(200)) +'"}');->
concat('{"SiteKey":"',cast( UUID() as Char(200)),'"}')
Query OK, 1 row affected (0.00 sec)
INSERT `Settings` (`ClassType`, `Settings`) VALUES ('SiteSettings, BusinessComponents', '{"BeiAnScript":"","StatScript":"","Links":"","SiteKey":"'+cast( UUID() as Char(100)) +'"}');
这个该怎么连啊
concat('{"BeiAnScript":"","StatScript":"","Links":"","SiteKey":"',cast( UUID() as Char(100)) ,'"}'));
INSERT `Settings` (`ClassType`, `Settings`) VALUES ('SiteSettings, BusinessComponents', '{"BeiAnScript":"","StatScript":"","Links":"","SiteKey":"'+cast( UUID() as Char(100)) +'"}');
这个该怎么连啊
其实如果认真看一下回复就已经有答案了。concat