Komandas priekš DB:
	metter_object_temp tabula:
----------------------------------

	INSERT INTO metter_object_temp (old_name)
SELECT DISTINCT
	s.name
FROM skaititaji AS s

---------------------------------------------------
	
		metter_data tabula:
----------------------------------
		
	INSERT INTO metter_data (NUMBER, obis, DATE, VALUE)
SELECT 
	CAST(REGEXP_REPLACE(s.number, '[A-Z]', "") AS DECIMAL(12,0)),
	s.obis,
	s.date_from,
	s.value_from
	
FROM skaititaji AS s	
	union
SELECT 
	CAST(REGEXP_REPLACE(s.number, '[A-Z]', "") AS DECIMAL(12,0)),
	s.obis,
	s.date_to,
	s.value_to
	
FROM skaititaji AS s	

---------------------------------------------------

	meter_data tabula:
----------------------------------
	
	INSERT INTO metter_meter (ch, number, len, `length`)
SELECT 
	 REGEXP_REPLACE(s.number, '[0-9]', ""),
	 CAST(REGEXP_REPLACE(s.number, '[A-Z]', "") AS DECIMAL(12,0)),
	LENGTH(s.number),
	if (LENGTH(s.value_from) >  LENGTH(s.value_to), LENGTH(s.value_from), LENGTH(s.value_to))
FROM skaititaji AS s	

---------------------------------------------------