Insert into and select table

Hello everyone, I hope your help.

I need insert into _tbl_2 the values of _tbl_1 for Db MySql.

_tbl_1:


CTS	Events
DDDS	12345
EEES	123456
FFFS	78901

I need this output in _tbl2:


ID	_CTS	Events
1	DDDS	DDD 012345
2	EEES	EEE 123456
3	FFFS	FFF 078901

I need compose this string for the field Events:


DDD 012345
EEE 123456
FFF 078901

If the events value is a five numbers I need insert 0 value first number:


DDD 12345 ===> DDD 012345
EEE 123456 ===> EEE 123456
FFF 78901 ===> FFF 078901

I try this query:


insert into _tbl_2
(
 `ID`, 
 `_CTS`, 
 `Events`
)
(
select 
  0,
 `CTS`,
  LEFT(CTS,3) & "0"
  from _tbl_1
)

Buit in the field Events is inserted only 0 value…

Can someone help me?
Thanks in advance.

Chevy

INSERT 
  INTO _tbl_2
     ( ID
     , _CTS
     , Events )
SELECT 0
     , CTS
     , CONCAT(LEFT(CTS,3)
             ,' '
             ,RIGHT(CONCAT('0',Events),6))
  FROM _tbl_1

I’d appreciate your help so very much. :slight_smile: