More than 5 years have passed since last update.

MySQL 行数固定のデータを生成

MySQL

Posted at 2014-07-28

メモ

SELECT 
	w.*
FROM 
	(SELECT @row_id := @row_id +1 as row_id, w.* FROM works w ) w
RIGHT JOIN (
	SELECT 1 row_id 
UNION ALL
	SELECT 2 row_id 
UNION ALL
	SELECT 3 row_id 
UNION ALL
	SELECT 4 row_id 
UNION ALL
	SELECT 5 row_id 
) x ON w.row_id = x.row_id;

もっといい方法があるかもしれない

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up