How to split a table into two in MySQL? -
i have table in mysql has data looks this:
id date name gender age 1 2014/7/6 john m 33 2 2015/2/12 mike m 44 3 2001/2/9 emily f 57 . . . 500 2017/11/22 jasmine f 20
i want take bottom 200 rows , make them new table. how can that?
insert `newtable` select * `oldtable` id > 300;
assuming bottom 200 rows means when rows sorted id's
Comments
Post a Comment