This article covers the basic of writing a stored procedure. It's the first in a series on writing stored procedures.
Stored Procedures: An Overview
George Petrov
George Petrov is a renowned software writer and developer whose extensive skills brought numerous extensions, articles and knowledge to the DMXzone- the online community for professional Adobe Dreamweaver users. The most popular for its over high-quality Dreamweaver extensions and templates.
George is also the founder of Wappler.io - the most Advanced Web & App Builder
Comments
Stored Procedures
How about some tutorial stuff on using stored procedures on MySQL that has no native support for triggers or stored procedures, but is a common installation on LINUX servers.
Roo
RE: Stored Procedures
Making 'artificial' triggers for MySQL
There are a number of ways I can imagine doing it, none of which are very elegant...
1.Check every time using a NOW() date call and deleting all records that are <= interval -1 MONTH or whatever. (very slow and resource intensive)
2.Ideally you would have somewhere you could store the last time you checked., either in the application object (best) or in the database (second best), one field LAST_FLUSH...
If NOW() > variableContainingLastDateChecked Then
Execute code to remove older records.
End If
I dont like either of them really !
RE: Making 'artificial' triggers for MySQL
This is a cool info thank you! Could you please post it only in the FAQ section or if you have a tutorial about it - you can upload it in the tutorials section.
Thanks You!
You must me logged in to write a comment.