1. metter_object_temp


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


2. metter_data


INSERT INTO metter_data (NUMBER,obis,DATE,VALUE)
SELECT 
	s.NUMBER, 
	s.obis, 	
	s.date_from, 	
	convert (s.value_from, UNSIGNED) AS value
	FROM 
		skaititaji s
UNION
SELECT
 	s.NUMBER, 
	s.obis, 
	s.date_to, 
	convert (s.value_to, UNSIGNED) AS value
	FROM 
		skaititaji s


3. metter_meter


INSERT INTO metter_meter (ch,number,len,length)
SELECT 
"" AS ch,
    cast(NUMBER AS DECIMAL(12)) AS number,
    LENGTH(NUMBER) AS len,
     if ( LENGTH(value_from) > LENGTH(value_to), LENGTH(value_from), LENGTH(value_to)) AS length
FROM 
 skaititaji