MySQL 5.7

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table mytable (
pallet_id     INT,
quantity      INT,
message       TEXT,
created_date  DATETIME,
modified_date DATETIME);
create table sourcetable (
TFR     tinyint,
Cust    varchar(221),
Issue   decimal(6,1),
PalNo   varchar(15),
Date    varchar(19));
insert into sourcetable 
values (1,'23A',10,'2020-12-19','2020-12-20 17:55:06');
INSERT INTO mytable (pallet_id, quantity, message, created_date, modified_date)
SELECT s.TFR, s.Cust, 'a23', s.PalNo, Date(s.Date) FROM sourcetable s;

Data truncated for column 'quantity' at row 1


SELECT * FROM mytable;


pallet_id
quantity
message
created_date
modified_date


INSERT INTO mytable (pallet_id, quantity, message, created_date, modified_date)
values( 1, 10, 'a23', now(),now());
SELECT * FROM mytable;


pallet_id
quantity
message
created_date
modified_date


1
10
a23
2024-04-20 16:30:50
2024-04-20 16:30:50


INSERT IGNORE INTO mytable (pallet_id, quantity, message, created_date, modified_date)
SELECT s.TFR, s.Cust, s.Issue, s.PalNo, Date(s.Date) FROM sourcetable s;

Records: 1  Duplicates: 0  Warnings: 1


SELECT * FROM mytable;


pallet_id
quantity
message
created_date
modified_date


1
10
a23
2024-04-20 16:30:50
2024-04-20 16:30:50

1
23
10.0
2020-12-19 00:00:00
2020-12-20 00:00:00

pallet_id	quantity	message	created_date	modified_date
1	10	a23	2024-04-20 16:30:50	2024-04-20 16:30:50
1	23	10.0	2020-12-19 00:00:00	2020-12-20 00:00:00