Generate data from sequence MySQL

MySql_gen_data_from_seq_example.sql

CREATE DATABASE IF NOT EXISTS `ifd_test`;

START TRANSACTION;
USE `ifd_test`;

TRUNCATE TABLE esb_out_a_report; # из ->
TRUNCATE TABLE esb_out_h_report; # ->  в

INSERT INTO esb_out_a_report (message_id, entity_id, maintenance_flg, message_dt, operation_code, receiver_id)
  SELECT
    seq,
    CONCAT('id #', seq),
    RAND(),
    SUBDATE(CURRENT_DATE, 1),
    RAND() * 666,
    seq + rand() * 13
  FROM seq_1_to_10;