Souy Soeng

School Management Dashboard in Laravel ​9 | Login and Register

Laravel 9 REST API with Passport Authentication Tutorial

Admin dashboard in Laravel ​9 | Login and Register Click to Download Project …

Admin dashboard in Laravel ​9 | Sample Template

Laravel 9 REST API Authentication using Sanctum Tutorial

What’s new in Laravel 9? Laravel has dominated the PHP web framework landscape for many years now. If you build custom PHP websites, chances are yo…

Admin dashboard in Laravel ​8 HR System

MySQL INDEXES

SQL DROP TABLE

SQL TRUNCATE TABLE

Understanding SQL ALTER TABLE Statement The SQL ALTER TABLE statement is used to modify the structure of an existing table. It allows you to add, d…

SQL CREATE TABLE

SQL DROP DATABASE

SQL SELECT DATABASE

SQL SHOW DATABASE

SQL CREATE DATABASE

PostgreSQL CREATE DATABASE

PHP MySQL: Transactions Transactions in MySQL allow you to execute a series of queries as a single unit of work. If any query fails, you can roll bac…

MySQL IS NULL The IS NULL operator in MySQL is used to check if a column's value is NULL . A NULL value represents missing or unknown data, and…

MySQL Alias An alias in MySQL is a temporary name given to a table or column for the duration of a query. Aliases make queries more readable, especia…

MySQL JOIN The JOIN  The clause in MySQL combines rows from two or more tables based on a related column. Joins are essential when retrieving data fr…

MySQL INNER JOIN The INNER JOIN clause in MySQL is used to combine rows from two or more tables based on a related column between them. It returns o…

MySQL LEFT JOIN The LEFT JOIN clause in MySQL retrieves all rows from the left table and the matching rows from the right table. If no match is foun…

MySQL RIGHT JOIN The RIGHT JOIN clause in MySQL retrieves all rows from the right table and the matching rows from the left table. If no match is fo…

MySQL CROSS JOIN The CROSS JOIN clause in MySQL generates a Cartesian product of two tables. It combines every row from the first table with every r…

MySQL Self Join A Self Join is a regular join where a table is joined with itself. It is used when there is a need to compare rows within the same t…

MySQL HAVING Clause The HAVING clause in MySQL is used to filter the results of a GROUP BY operation based on aggregate function conditions. It is …

MySQL ROLLUP The ROLLUP operator in MySQL is used with the GROUP BY clause to generate subtotals and grand totals for grouped data. It provides a c…

MySQL Subquery A subquery in MySQL is a query nested inside another query. Subqueries allow you to perform operations where the result of one query …

An Essential Guide to MySQL Derived Table A derived table in MySQL is a subquery that is used in the FROM clause of a query. It acts as a temporary…

MySQL EXISTS The EXISTS operator in MySQL is used to test for the existence of rows in a subquery. It returns TRUE if the subquery returns one or m…

An Introduction to MySQL CTE (Common Table Expressions) A CTE (Common Table Expression) in MySQL is a temporary result set that you can reference wi…

A Definitive Guide to MySQL Recursive CTE A Recursive Common Table Expression (CTE) in MySQL is a type of CTE that allows a query to refer to itself…

MySQL UNION Clause The UNION operator in MySQL is used to combine the result sets of two or more SELECT statements into a single result set, elimin…

MySQL Data Types In MySQL, data types define the data type that can be stored in a column. Choosing the right data type ensures efficient storage, be…

MySQL INTERSECT Clause The INTERSECT operator in SQL is used to return the common records (intersection) from two SELECT statements. It retrieves o…

MySQL MINUS Operator The MINUS operator in SQL is used to return the rows from the first query that are not present in the second query. It effectiv…

MySQL INSERT Statement The INSERT statement in MySQL is used to add new rows of data into a table. It allows you to insert one or more rows at a tim…

MySQL INSERT Multiple Rows In MySQL, the INSERT statement allows you to insert multiple rows of data into a table in a single query. This method is …

MySQL INSERT IGNORE Statement The INSERT IGNORE statement in MySQL is used to insert data into a table while ignoring rows that would cause errors. …

MySQL REPLACE Statement The REPLACE statement in MySQL is used to insert a new row into a table or replace an existing row if a duplicate key value …

MySQL Prepared Statement A Prepared Statement in MySQL is a feature that lets you execute SQL queries multiple times efficiently and securely. It is…

MySQL UNIQUE Constraint The UNIQUE constraint in MySQL is used to ensure that all values in a column or a combination of columns are unique across a…

MySQL ON DELETE CASCADE The ON DELETE CASCADE is a referential action that is used in foreign key constraints to automatically delete rows in a chil…

MySQL DELETE JOIN The DELETE JOIN operation in MySQL allows you to delete rows from one or more tables based on a condition that involves a join bet…

MySQL Transactions A transaction in MySQL is a sequence of one or more SQL operations (such as INSERT , UPDATE , DELETE , etc.) that are executed as…

MySQL Table Locking Table locking in MySQL is a mechanism used to control access to a table by multiple database clients to ensure data consistency a…

Selecting a MySQL Database Using the USE Statement The USE statement in MySQL is used to select a database to work with. Once a database is selecte…

Managing Databases in MySQL In MySQL, managing databases is a fundamental task, and it includes creating, deleting, selecting, modifying, and maintai…

Managing Databases in MySQL In MySQL, managing databases involves creating, modifying, dropping, and interacting with databases efficiently. Below is…

MySQL DROP DATABASE The DROP DATABASE statement is used in MySQL to delete an entire database, including all its tables, data, and associated object…

MySQL CREATE DATABASE

Understanding MySQL Storage Engines

MySQL Sequence

MySQL Temporary Table

MySQL TRUNCATE TABLE

How To Use The MySQL Generated Columns

MySQL INT Data Type

MySQL DECIMAL Data Type

An Introduction to MySQL BOOLEAN Data Type

Pragmatic Uses of MySQL BIT Data Type

MySQL CHAR Data Type

The Essential Guide to MySQL VARCHAR Data Type

The Basics Of MySQL TEXT Data Type

The Ultimate Guide To MySQL DATE and Date Functions

Mastering MySQL TIME Data Type

A Complete Guide To MySQL DATETIME Data Type

MySQL TIMESTAMP

A Practical Guide to MySQL JSON Data Type By Example

A Comprehensive Guide to Using MySQL ENUM

MySQL NOT NULL Constraint

MySQL Primary Key

MySQL Foreign Key

MySQL Disable Foreign Key Checks

MySQL CHECK Constraint

MySQL CHECK Constraint Emulation

MySQL Collation

MySQL Character Set

Import CSV File Into MySQL Table

MySQL Export Table to CSV

MySQL Natural Sorting

Introduction to MySQL Stored Procedures

MySQL CREATE PROCEDURE Statement In MySQL, a stored procedure is a collection of SQL statements stored on the server and executed as a single unit. …

MySQL DROP PROCEDURE

MySQL Stored Procedure Variables In MySQL, stored procedures support two types of variables for use within the procedure: Local Variables and User-D…

Create a Trigger in MySQL

MySQL CREATE VIEW

MySQL OR Operator The OR operator in MySQL is used to combine two or more conditions in a SQL query. It returns results when at least one of the con…

MySQL IF Function

MySQL Stored Procedure Parameters In MySQL, stored procedures can accept parameters that allow them to perform dynamic operations based on the input …

Alter Stored Procedures

Listing Stored Procedures

MySQL CASE Statement The CASE statement in MySQL is used for conditional logic. It evaluates a series of conditions and returns a value when the fir…

MySQL IF Statement

MySQL LOOP Statement The LOOP statement in MySQL provides a way to execute a block of code repeatedly within a stored procedure, function, or trigge…

MySQL WHILE Loop

MySQL REPEAT Loop

MySQL LEAVE Statement The LEAVE statement in MySQL is used to exit from a loop or block of code within a stored procedure, function, or trigger. I…

Raising Error Conditions with MySQL SIGNAL and RESIGNAL Statements The SIGNAL and RESIGNAL statements in MySQL allow you to explicitly raise error …

MySQL Error Handling in Stored Procedures Error handling in MySQL stored procedures allows developers to anticipate, manage, and respond to runtime e…

MySQL Cursor A cursor in MySQL is a database object used to retrieve and process rows from a query result set one at a time. Cursors are typically u…

MySQL Stored Object Access Control In MySQL, access control for stored objects like stored procedures , functions , triggers , and events is governe…

MySQL DROP FUNCTION The DROP FUNCTION statement in MySQL is used to delete a stored function from the database. It permanently removes the function …

MySQL DROP FUNCTION The DROP FUNCTION statement in MySQL is used to delete a stored function from the database. It permanently removes the function …

Listing Stored Functions

Working with MySQL Scheduled Events MySQL Scheduled Events allow you to execute SQL statements automatically at specified intervals. They are similar…

MySQL NOT NULL Constraint The NOT NULL constraint in MySQL ensures that a column cannot contain NULL values. It is a common constraint used to enfo…

MySQL DROP TRIGGER

MySQL BEFORE INSERT Trigger

MySQL CONCAT Function The CONCAT function in MySQL is used to concatenate (combine) two or more strings into a single string. It is especially usefu…

MySQL SHOW ERRORS

MySQL BEFORE UPDATE Trigger A BEFORE UPDATE trigger in MySQL is a type of trigger that is fired before an UPDATE operation is executed on a table.…

MySQL AFTER UPDATE Trigger An AFTER UPDATE trigger in MySQL is a type of trigger that is fired after an UPDATE operation is performed on a table. …

MySQL BEFORE DELETE Trigger

MySQL SUM

MySQL SHOW TRIGGERS The SHOW TRIGGERS command in MySQL allows you to list all the triggers that exist in a specific database. This can be useful for…

MySQL AFTER DELETE Trigger

Creating Multiple Triggers in MySQL Triggers in MySQL are database objects that automatically execute specified actions in response to certain events…

MySQL SHOW TABLES: List Tables In a MySQL Database

MySQL REGEXP: Search Based on Regular Expressions The REGEXP (or RLIKE ) operator in MySQL allows you to search for patterns in strings using regula…

MySQL Replace String Function

MySQL: Select Random Records MySQL provides an easy way to fetch random records from a table, which is useful for use cases like displaying random co…

How To Create User Accounts Using MySQL CREATE USER Statement

MySQL REVOKE

MySQL AND Operator The AND operator in MySQL is used to combine two or more conditions in a WHERE , HAVING , or ON clause. It ensures that all the …

MySQL NULL: The Beginner’s Guide

MySQL Date Functions

The Essential Guide To MySQL ISNULL Function

MySQL IFNULL

MySQL NULLIF() Function The NULLIF() function in MySQL compares two expressions and returns NULL if they are equal. If the expressions are not equa…

MySQL SHOW COLUMNS and DESCRIBE: List All Columns in a Table

MySQL CREATE INDEX

MySQL String Length

MySQL GROUP_CONCAT() Function The GROUP_CONCAT() function in MySQL concatenates values from a group into a single string. It is a powerful tool for …

Understanding SQL Primary Key In SQL, a Primary Key is a constraint that uniquely identifies each record in a table. It ensures that no two rows in …

PostgreSQL Data Types

MySQL LAST_VALUE Function

MySQL CURDATE Function

MySQL Aggregate Functions MySQL provides several aggregate functions that perform calculations on a set of values and return a single summarized res…

MySQL AVG

MySQL COUNT

PostgreSQL ORDER BY

MySQL CAST Function

PostgreSQL SELECT

PostgreSQL LIMIT

MySQL MAX() Function The MAX() function in MySQL is an aggregate function that returns the largest (maximum) value from a specified column in a data…