Re: Regarding Error code : 1406 : Data Truncation : Data too long for column

[Vivek Kumar Sharma]

drop table if exists tbl;

CREATE TABLE `tbl` (
`id` int DEFAULT NULL,
`full_name` varchar(50) DEFAULT NULL,
`Charlen` int DEFAULT NULL
);
insert into tbl(id,full_name,Charlen)
select
us.id,
us.full_name as full_name,
char_length(us.full_name) as ln
from <fedrated table name> as us where id>=516 and id<520;