MySql Question.....
Here is a sample table in a mysql database (this is not actuall data)
First Name Last Name
1 Tim Belling
2 Roger Ngo
3 James Babb
OK what i want to do is insert a record BEFORE John Doe so every record will be bumped down 1 and a person called Brian Shell will be put into row 1
whats the SQL syntax to do this?
First Name Last Name
1 Tim Belling
2 Roger Ngo
3 James Babb
OK what i want to do is insert a record BEFORE John Doe so every record will be bumped down 1 and a person called Brian Shell will be put into row 1
whats the SQL syntax to do this?
Comments
Hope you figuer it out.
And yes im relitavitly new to mysql.