GitHub

MySQL Spatial User Defined Functions

What is an User Defined Function? An User Defined Function (UDF) is a C/C++ library that extends the functionality of a MySQL server by adding new functions that behaves just like a native (built-in) ...
STAREAST

Window Functions in MySQL 8

Window functions are a new feature in MySQL 8. Window functions are not as simple as the other built-in MySQL functions. While most functions operate only on the data pertaining to a single row of ...
GitHub

A module for managing MySQL connections at serverless scale.

Serverless MySQL is a wrapper for Doug Wilson's amazing mysql2 Node.js module. Normally, using the mysql2 module with Node apps would be just fine. However, serverless functions (like AWS Lambda, ...
findnerd.com

Stored Procedures and Functions in MySQL - Part 2

For example lets create a stored procedure to increment salaries of employees by percentage DELIMITER $$ CREATE PROCEDURE salary_increment(increment_percent decimal(5,2)) BEGIN UPDATE employee_master ...
Ubuntu

Create MySQL Database And Table Using PHP In XAMPP

Make sure you have setup XAMPP stack in your system. The following guide explains how to setup XAMPP stack in Linux. Alternatively, you can use the LAMP or LEMP stacks which provides both PHP and ...
TheServerSide

Comparing MySQL and Postgres 9.0 Replication

Replication is one of the most popular features used in RDBMS’s today. Replication is used for disaster recovery purposes (i.e. backup or warm stand-by servers), reporting systems where query activity ...