MySql Question.....

edited October 2004 in Software
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?

Comments

  • The user and all related content has been deleted.
  • hmmmmmm. I know how to do this in MS Access, but not SQL.


    Hope you figuer it out. ;)
  • I am making a PHP script, and i want to make it so i have latest news on the front page and the old articles on the archive page. I want to make it so that the newest news is at the top and the oldest is at the bottom. I do have a primary key. There is no data in the db yet.

    And yes im relitavitly new to mysql.
  • The user and all related content has been deleted.
Sign In or Register to comment.