-
116 votesanswersviews
MYSQL截断了不正确的DOUBLE值
执行以下SQL查询时: UPDATE shop_category SET name = 'Secolul XVI - XVIII' AND name_eng = '16th to 18th centuries' WHERE category_id = 4768 引发以下错误: 1292 - Truncated incorrect DOUBLE value: 'Secolul XVI... -
0 votesanswersviews
SQL:1292截断不正确的DOUBLE值:'https://twitter.com/'
我对MariaDB的查询非常简短,以修复到twitter的断开链接 . 表用户将link_twitter作为VARCHAR(255),以生成我们正在使用PHP Doctrine的DB模式,但我想手动运行此查询 . 服务器正在运行MariaDB 1.10 查询: UPDATE `user` AS u SET u.link_twitter = "https://twitter... -
0 votesanswersviews
错误代码:1292 . 截断不正确的DOUBLE值
我试图通过查询插入数据: insert into email (emailAddress, isPreferredEmail, customer_id, upload_id) select cast(Email as char(100)) a, TRUE, (select id from customer c where c.dbvehregno=ChassisNo),... -
0 votesanswersviews
Mysql在INSERT查询中截断了不正确的DOUBLE值
我知道这里有很多这样的错误,但这个查询似乎有所不同,因为它是一个插入查询 . 这是表card_info的架构: CREATE TABLE card_info ( card_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, card_name_orig varchar(150) NOT NULL, card_name_html varchar(... -
0 votesanswersviews
程序中MySQL错误“截断了错误的DOUBLE值”
我的手术有问题 . 我尝试从sales表中获取值并使用它们进行查询 . 过程如下所示: DROP PROCEDURE IF EXISTS turnover; DELIMITER $$ CREATE PROCEDURE turnover() BEGIN DECLARE col INT; DECLARE q TEXT; DECLARE i INT DEFAULT 0; ...