Are PROCEDUREs preferable to FUNCTIONs in MySQL?
62267
MySQL stored procedure vs function, which would I use when?
23909
In PostgreSQL, what is the difference between a "Stored Procedure" and other types of functions?
49412
What is the best method for getting a database connection/object into a function in PHP?
9385
How do you do multiple SQL statements in one mysql_query?
52039
Does adding 'LIMIT 1' to MySQL queries make them faster when you know there will only be 1 result?
23647
Why shouldn't I use mysql_* functions in PHP?
155730
Create a function with optional arguments in MySQL
4236
The equivalent of SQLServer function SCOPE_IDENTITY() in mySQL?
31597
In PostgreSQL is the row ordering preserved in functions and CTEs?
115927
Parameterized Query for MySQL with C#
147884
Table as an argument of a PostgreSQL function
74432
How do I Concatenate entire result sets in MySQL?
13188
Can I concatenate multiple MySQL rows into one field?
23108
Postgres declare table as a parameter for a function?
54760
MySQL INSERT INTO SELECT vs BULK INSERTs performance
17013
Difference between different types of SQL?
14404
Functions vs. patterns