MySQL – Stored Procedure Table of content The MySQL Stored Procedure A MySQL stored procedure is a group of pre-compiled SQL statements that can be reused anytime. Stored procedures can be used to perform different database operations such as such as inserting, updating, or deleting data. Syntax The basic syntax to create a stored procedure […]
Category Archives: mysql
MySQL – Upsert Table of content The MySQL UPSERT Operation The MySQL UPSERT operation combines INSERT and UPDATE into a single statement, allowing you to insert a new row into a table or update an existing row if it already exists. We can understand in the name (UPSERT) itself, where UP stands for UPDATE and […]
MySQL – JSON Table of content MySQL provides a native JSON (JavaScript Object Notation) datatype that enables efficient access to the data in JSON documents. This datatype is introduced in MySQL versions 5.7.8 and later. Before it was introduced, the JSON-format strings were stored in the string columns of a table. However, the JSON datatype […]