If I was given 6enteries to a row and and if I need to add in middle of the table what query I must use?

Answer 1

The question should by why do you need to insert into the middle?

If you need to sort the data use ORDER BY

You should never have to rely on data being in the right order in a database.

Answer 2

you can put your data in the middle provided you give it a unique appearance

Answer 3

you mean how to add no value then a value an then again nothing?

Answer 4

You can do other way around... Put your data in another table... Put your current data... Again put that old data after last row