I'm trying to re-order a bunch of rows based upon user preference. For example I have 10 row. There is a column called order_id that gives each row an id from 1-10. I want to be able to do things ...

A stored procedure is a set of SQL commands that can be compiled and stored in the server. Once this has been done, clients don't need to keep reissuing the entire query but can refer to the stored ...

You can use full, inline SQL statements in the prepared statement function or send the database a stored procedure function. A stored procedure is a program that is stored on the database server.