Basic query on Mysql Insert Statement -

i have n number of records in table ,i wanna move records 1 table other old table table1 , new table2 .i have query sub query select records table insertion . assuming 10000 records while inserting on 6000 record gets exception in , got end,but still table2 empty , here wanna know 5999 records have been inserted in databse ?

thanks in advance ,,

if unworthy answer or cause let me know reason down vote can improve

i have query sub query select records table insertion

i assume have inesrt table2(<column list>) select <column list> table1 ... running move records.

if so, insert statement run part of transaction , committed if statement executed successfully, i.e. if able insert records returned select query. otherwise, transaction gets rolled , no records inserted.

here wanna know 5999 records have been inserted in database?

these records have been inserted worktable in tmp location while executing insert statement. have been committed main table if had gone well.