By default, select into does not carry over a base table’s max_rows_per_page value, but creates the new table with a max_rows_per_page value of 0. However, you can add the with max_rows_per_page option to select into to specify a value other than 0.
