2 votes
Accepted

mysql bulk insert with constraints

INSERT INTO Leaderboard (matchID, score, country, tournamentID) WITH RECURSIVE cte1 (num) AS ( SELECT 1 UNION ALL SELECT num + 1 FROM cte1 LIMIT 100 ), cte2 (country) AS (SELECT "SPAIN" ...
Akina's user avatar
  • 19.9k

Only top scored, non community-wiki answers of a minimum length are eligible