Stored procedures (or stored routines, to use the official MySQL terminology) are programs that are both stored and executed within the database server. Stored procedures have been features in ...

The stored procedure then runs a query to select records where the user is equal to the value passed as the parameter (as specified by where user=usr). At the mysql prompt you can call the stored ...