1.metter_object_temp 
INSERT INTO metter_object_temp (old_name)
SELECT DISTINCT TRIM(name) AS old_name
FROM skaititaji_zakrepskis_copy;
2.metter_data 
INSERT INTO metter_data (number, obis, date, value)
SELECT 
  CAST(REPLACE(TRIM(number), ' ', '') AS UNSIGNED),
  CAST(obis AS UNSIGNED),
  date_from,
  CAST(REPLACE(TRIM(value_from), ' ', '') AS DECIMAL(12,0))
FROM skaititaji_zakrepskis_copy;
INSERT INTO metter_data (number, obis, date, value)
SELECT 
  CAST(REPLACE(TRIM(number), ' ', '') AS UNSIGNED),
  CAST(obis AS UNSIGNED),
  date_to,
  CAST(REPLACE(TRIM(value_to), ' ', '') AS DECIMAL(12,0))
FROM skaititaji_zakrepskis_copy;
3.metter_meter
INSERT INTO metter_meter (number, ch, len, length)
SELECT DISTINCT 
  CAST(REPLACE(TRIM(number), ' ', '') AS UNSIGNED),
  '',           
  12,           
  CHAR_LENGTH(TRIM(number)) 
FROM skaititaji_zakrepskis_copy;