MySQL Tree Traversal practical examples

Using trigger based stored procedure to create audit table. It follows the wordpress meta data approach to store the changes, so all the data is store in just two centalized tables.

This is an example of how to calculate the distance between two GPS coordinates as a function in MySQL.

SoftUni - MySQL Module

The following will create a simple stored procedure that uses a cursor to kill all processes one by one except for the process currently being used: mysql_deadlock_fix_procedure.sql. The following will create a simple Event that will run on the scheduled time : mysql_deadlock_fix_event.sql

Handy collection of SQL scripts, snippets, stored procedures, and functions.

SQL Stored Programs

Relational Database Fundamentals, Stored Procedure, Triggers, Views, Normalization

This contains of T-SQL which check one by one record and retrieve the selected record

MS SQL Server Code

A tree representation in SQL

Automation tool for checking vandalism on websites

Procedimientos, Funciones y tablas, Consultas y cláusulas para base de datos MySQL

My PL/SQL codes what I wrote while I was studying the language