MySQL generate data

Mysql generate data

# Create Fixed row_format table (better indexes than for Dynamic)
mysql> CREATE TABLE test_tab (
  id int(11) unsigned NOT NULL AUTO_INCREMENT,
  id_2 int(11) unsigned NOT NULL,
  id_3 int(11) unsigned NOT NULL,
  name char(10) NOT NULL,
  c_date date NOT NULL,
  mtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (id)
) ENGINE=MyISAM

# procedure to populate 8_000_000 semi-random rows
mysql> delimiter //
mysql> CREATE PROCEDURE load_test_tab()
begin
    declare v int default 0;
    while v < 8000000
    do
        insert into 
            test_tab(id_2,id_3, name, c_date)
            values (ceil(mod(rand()*1000,1000)), ceil(mod(rand()*10000,10000)), 'testing', adddate('1995-01-01',(rand(v)*36520) mod 3652));
        set v = v + 1;
    end while;
end
//
mysql> delimiter ;
mysql> call load_test_tab();