mysql - 将输出数据插入新表
问题描述
我想插入查询的输出,但我无法插入输出我收到错误为 ER_TRUNCATED_WRONG_Name (1292) - 截断不正确的 DOUBLE 值:'Null'
insert into grid SELECT
(CASE
WHEN sample.Airtel = 'Null' THEN'0'
WHEN sample.Airtel <'1000' THEN '1'
WHEN sample.Airtel >'2933' THEN '3'
ELSE '2'
END) AS airtel1,
( CASE
WHEN sample.Jio = 'Null' THEN'0'
WHEN sample.Jio <'1000' THEN '1'
WHEN sample.Jio >'2933' THEN '3'
ELSE '2'
END )AS jio1,
( CASE
WHEN sample.Vodaidea = 'Null' THEN'0'
WHEN sample.Vodaidea <'1000' THEN '1'
WHEN sample.Vodaidea >'2933' THEN '3'
ELSE '2'
END )AS voda1,
( CASE
WHEN sample.Airtel_count = 'Null' THEN'0'
WHEN sample.Airtel_count >'32' THEN 'High'
WHEN sample.Airtel_count <='1' THEN 'Low'
ELSE 'Mid'
END) AS airtelgrid,
( CASE
WHEN sample.Jio_count = 'Null' THEN'0'
WHEN sample.Jio_count >'32' THEN 'High'
WHEN sample.Jio_count <='1' THEN 'Low'
ELSE 'Mid'
END) AS jiogrid,
( CASE
WHEN sample.VodaIdea_count = 'Null' THEN'0'
WHEN sample.VodaIdea_count >'32' THEN 'High'
WHEN sample.VodaIdea_count <='1' THEN 'Low'
ELSE 'Mid'
END) AS vodagrid,
sample.*
FROM
sample
表定义如下:
CREATE TABLE `grid` (
`Hex_id` int(50) DEFAULT NULL,
`Airtel` int(50) DEFAULT NULL,
`Airtel_count` int(50) DEFAULT NULL,
`Jio` int(50) DEFAULT NULL,
`Jio_count` int(50) DEFAULT NULL,
`Vodaidea` int(50) DEFAULT NULL,
`VodaIdea_count` int(50) DEFAULT NULL,
`airtel1` int(50) DEFAULT NULL,
`jio1` int(50) DEFAULT NULL,
`voda1` int(50) DEFAULT NULL,
`airtelgrid` varchar(50) DEFAULT NULL,
`jiogrid` varchar(50) DEFAULT NULL,
`vodagrid` varchar(50) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1
示例表定义如下:
创建表sample
(
Hex_id
int(50) NOT NULL,
Airtel
int(50) NOT NULL,
Airtel_count
int(50) NOT NULL,
Jio
int(50) NOT NULL,
Jio_count
int(50) NOT NULL,
Vodaidea
int(50) NOT NULL,
VodaIdea_count
int(50) NOT NULL ) 引擎=MyISAM 默认字符集=latin1
解决方案
推荐阅读
- javascript - 如何将 Javascript 类翻译成 ScalaJS
- list - Scheme eval 简单规避
- thymeleaf - 如何在 Thymeleaf 中应用 elvis 算子?
- mysql - 使用 docker-sync for MySQL / Databases 进行本地开发?
- javascript - JS,firebase.auth() 在全局上下文中不起作用,但在函数内部起作用?- firebase.Auth 不是函数
- ubuntu - 如何为 ext4 和 NTFS 分区上的相同文件获取相同的文件大小?
- python - 查找字符串中包含数字的列
- api - 这个 API 连接请求字符串缺少什么?
- java - 为 Kafka 自定义对象实现正确的序列化和反序列化
- wordpress - 通过 Polylang 插件更改语言时,有没有办法将所有查询参数保留在 URL 中?