MySQL是一種常用的關系型數據庫管理系統，在實際開發中常常需要生成百萬數據以測試性能或填充數據。以下是使用MySQL生成百萬數據的方法：

-- 生成數字序列表
CREATE TABLE numbers (n INT PRIMARY KEY);
INSERT INTO numbers VALUES (0);
INSERT INTO numbers SELECT n+1 FROM numbers;
INSERT INTO numbers SELECT n+2 FROM numbers;
INSERT INTO numbers SELECT n+4 FROM numbers;
INSERT INTO numbers SELECT n+8 FROM numbers;
INSERT INTO numbers SELECT n+16 FROM numbers;
INSERT INTO numbers SELECT n+32 FROM numbers;
INSERT INTO numbers SELECT n+64 FROM numbers;
INSERT INTO numbers SELECT n+128 FROM numbers;
INSERT INTO numbers SELECT n+256 FROM numbers;
INSERT INTO numbers SELECT n+512 FROM numbers;
INSERT INTO numbers SELECT n+1024 FROM numbers;
INSERT INTO numbers SELECT n+2048 FROM numbers;
INSERT INTO numbers SELECT n+4096 FROM numbers;
INSERT INTO numbers SELECT n+8192 FROM numbers;
INSERT INTO numbers SELECT n+16384 FROM numbers;
INSERT INTO numbers SELECT n+32768 FROM numbers;
INSERT INTO numbers SELECT n+65536 FROM numbers;
INSERT INTO numbers SELECT n+131072 FROM numbers;
INSERT INTO numbers SELECT n+262144 FROM numbers;
INSERT INTO numbers SELECT n+524288 FROM numbers;
INSERT INTO numbers SELECT n+1048576 FROM numbers; 
-- 生成100萬行數據
INSERT INTO test_table (column_name) SELECT CONCAT('value_', n) FROM (SELECT @n:=@n+1 FROM numbers JOIN (SELECT @n:=0) init) sub WHERE n <= 1000000;

以上代碼使用了數字序列表的方式生成，首先創建一個數字序列表numbers，然后循環插入數據，最后使用numbers表生成百萬行數據插入到目標表中。

總結：

使用MySQL生成大量數據可以幫助我們快速測試性能或填充數據，而數字序列表是生成序列數的一種常見技術，在處理需要大量數字時非常有效。