一瞬にして1億データ作っちゃいますよ

すごい・・・.sql

mysql> insert into uid_unq (select null, "a", "a", "a" from testdata, testdata t2, testdata t3, testdata t4, testdata t5, testdata t6, testdata t7);
Query OK, 10000000 rows affected (22.80 sec)
Records: 10000000  Duplicates: 0  Warnings: 0

mysql> insert into user_attribute(select 1001, account_id, "charge_ammount", FLOOR(1 + RAND() * 9000) from uid_unq );
mysql> insert into user_attribute(select 1001, account_id, "key2", FLOOR(1 + RAND() * 9000) from uid_unq );
mysql> insert into user_attribute(select 1001, account_id, "key3", FLOOR(1 + RAND() * 9000) from uid_unq );
mysql> insert into user_attribute(select 1001, account_id, "key4", FLOOR(1 + RAND() * 9000) from uid_unq );
mysql> insert into user_attribute(select 1001, account_id, "key5", FLOOR(1 + RAND() * 9000) from uid_unq );
mysql> insert into user_attribute(select 1001, account_id, "key6", FLOOR(1 + RAND() * 9000) from uid_unq );
mysql> insert into user_attribute(select 1001, account_id, "key7", FLOOR(1 + RAND() * 9000) from uid_unq );
mysql> insert into user_attribute(select 1001, account_id, "key8", FLOOR(1 + RAND() * 9000) from uid_unq );
mysql> insert into user_attribute(select 1001, account_id, "key9", FLOOR(1 + RAND() * 9000) from uid_unq );
mysql> insert into user_attribute(select 1001, account_id, "key10", FLOOR(1 + RAND() * 9000) from uid_unq );