急!!!在线求解! MYSQL load data infile 失败!!!多谢!
应用MYSQL load data infile 工具,如何导入16进制数据呢?
insert into source_db_new values(1,0x06); 可以将16进制数据“0x06”成功插入数据库。但应用MYSQL工具load data infile 导入同样的数据失败!!
语句指令:
CREATE TABLE source_db_new (
Frame_number bigint,
SCCP_TYPE bigint
);
mysql> desc source_db_new;
+--------------+------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------+------------+------+-----+---------+-------+
| Frame_number | bigint(20) | YES | | NULL | |
| SCCP_TYPE | bigint(20) | YES | | NULL | |
+--------------+------------+------+-----+---------+-------+
2 rows in set (1.69 sec)
源数据文件(ABC.TXT)内容:
1;0x06
2;0x5c
3;0x22
4;0x31
load data infile 'D:\\my_program\\C++\\MySQL_C\\abc.txt'
into table source_db_new
FIELDS TERMINATED BY ';'
OPTIONALLY ENCLOSED BY ''
LINES TERMINATED BY '\n'
(
Frame_number,
SCCP_TYPE
);
报错如下:
ERROR 1265 (01000): Data truncated for column 'SCCP_TYPE' at row 1