목록더미 (1)

뽁

MySQL.더미 데이터 생성 쿼리문

/************************************************** 테이블명 : T_Table **************************************************/ -- DELETE FROM T_Table; START TRANSACTION; INSERT INTO T_Table( column1, column2....columnN ) SELECT T.RNUM ,value1 ,value2 FROM ( SELECT it.* ,@ROWNUM:=@ROWNUM+1 as RNUM FROM table_name it /*데이터가 많은 테이블*/ ,(select @ROWNUM:=0)as R LIMIT 100 /*생성하고 싶은 개수 작성*/ ) T ; COMMIT;
IT Cafe+/MySQL 2019. 9. 20. 16:21
Prev 1 Next