priya171

i have table call test id name dob mobile 1 xyz 1989-01-11 9878785687 2 pqr 2012-01-11 9977889988 3 abc 2010-09-19 7766554433 id is auto increment. now i have to add a record between 1 and 2 like udp 1977-09-08 9898009800 So my data table should be like this: id name dob mobile 1 xyz 1989-01-11 9878785687 2 udp 1977-09-08 9898009800 3 pqr 2012-01-11 9977889988 4 abc 2010-09-19 7766554433 Help me....