INSERT INTO metter_object_temp (old_name)
SELECT DISTINCT NAME FROM skaititaji ORDER BY NAME

SELECT
number,
obis,
date_from AS date,
value_from AS value
FROM skaititaji

UNION ALL

SELECT
number,
obis,
date_to AS date,
value_to AS value
FROM skaititaji;


INSERT INTO metter_meter (ch, number, len, length)
SELECT
LEFT(number, 1) AS ch,
number,
LENGTH(number) AS len,
LENGTH(number) AS length
FROM skaititaji;