MySQL Database Management Fundamentals
Database Concepts and Initialization
A database is a repository for structured data storage and management.
Service Management Commands
net start mysql
net stop mysql
mysqladmin -u root password new_password
mysql -u root -p
SQL Statement Categories
Type
Full Name
Purpose
DDL
Data Definition Language
Defines database objects
DML
Data ...
Posted on Tue, 28 Jul 2026 16:20:57 +0000 by orangehairedboy
Leveraging Stored Routines, Triggers, and MySQL 8 Advanced Features
Encapsulating Business Logic with Stored Procedures and Functions
Stored procedures and stored functions bundle multiple SQL statements into reusable server-side objects, reducing network overhead and improving security. A stored procedure accepts input, output, or both types of parameters, while a stored function always returns a single value. ...
Posted on Tue, 14 Jul 2026 16:59:58 +0000 by ClaytonBellmor
Writing Efficient MySQL Stored Procedures: A Practical Reference
Creating a Stored Procedure
CREATE PROCEDURE <procedure_name> (parameter_list datatype)
BEGIN
<body -- SQL statements>
END;
Example:
DROP PROCEDURE IF EXISTS FetchTopEmployees;
CREATE PROCEDURE FetchTopEmployees()
BEGIN
SELECT emp_id, first_name, last_name FROM employee ORDER BY salary DESC LIMIT 20;
END;
CALL FetchTopEmpl ...
Posted on Thu, 09 Jul 2026 17:12:55 +0000 by alfieshooter
MySQL Stored Procedures: Definition, Creation, and Parameterized Usage
Definition
A predefined, reusable set of SQL statements tailored to a specific task that executes when explicitly invoked.
Creation and Execution Syntax
2.1 Create a Stored Procedure
Lowercase syntax example:
create procedure proc_name([parameters])
begin
-- SQL statements block
end;
Uppercase syntax example:
CREATE PROCEDURE proc_name([parame ...
Posted on Mon, 22 Jun 2026 18:52:56 +0000 by skyturk
Implementing Dynamic Monthly Data Management with MySQL List Partitioning
Organizations often face challenges when managing time-series or periodic data, particularly for analytical dashboards requiring monthly aggregations. A common requirement is to update or refresh an entire month's data. Traditional approaches, such as fully truncating and re-inserting all historical data, or performing a DELETE followed by an I ...
Posted on Wed, 13 May 2026 19:30:18 +0000 by silrayn
Essential MySQL Operations and Advanced Query Techniques
1. Fundamental Database and Table Management
1.1 Schema and Table Structure Operations
1.1.1 Renaming Tables and Inspecting Structure
This task demonstrates how to rename an existing table and subsequently verify its new structure.
USE Company;
-- Rename the 'tb_emp' table to 'employee_records'
ALTER TABLE tb_emp RENAME TO employee_records;
- ...
Posted on Wed, 13 May 2026 00:29:55 +0000 by kael.shipman
Advanced MySQL Database Objects: Views, Stored Procedures, and Triggers
Database View Fundamentals
Views provide a virtual table interface based on the result of an SQL query. They simplify complex operations and enhance data security.
Basic view operations:
-- Create or replace a view
CREATE [OR REPLACE] VIEW view_name [(column_list)]
AS SELECT_statement [ WITH [ CASCADED | LOCAL ] CHECK OPTION ];
-- Display vie ...
Posted on Thu, 07 May 2026 13:50:24 +0000 by toro04