我有这个表,我正在创建SQL查询
CREATE TABLE if not exists User (
id bigint AUTO_INCREMENT,
coins bigint not null,
level bigint not null,
country VARCHAR(128),
PRIMARY KEY (id)
);
我想插入300万个条目
硬币是0—99999之间的随机数
1—100之间的随机数
其中国家是列表中5个国家中的随机国家
INSERT INTO User (coins, level, country)
SELECT
FLOOR(RAND() * 100000) AS coins,
FLOOR(RAND() * 100 + 1) AS level,
countries.country AS country
FROM
(SELECT "SPAIN" AS country UNION SELECT "FRANCE" UNION SELECT "UK" UNION SELECT "USA" UNION SELECT "GERMANY") countries
ORDER BY RAND()
LIMIT 3000000;
但当我得到这个的时候,我只得到了5个字.每个国家增加1个.我该怎么解决这个问题?