inSUBJECTS
Stored Procedure in mysql
Stored Procedure in MySQL · A procedure (also called a stored procedure) is a collection of pre-compiled SQL statements, stored inside the database. · It is a subroutine or a subprogram used for computing. · It contains a name, parameter lists, and SQL statements . · It is also used in triggers, other procedures, and a…
Read more
inSUBJECTS
MySQL commands - II--(DML (DATA MANIPULATION LANGUAGE))
DML (DATA MANIPULATION LANGUAGE) Support various types of commands such as I. Insert II. Update III. Delete IV. Select 1. INSERT Used to store or add data in MySQL table within the database in two ways using a single query: Insert record in a single row Insert record in multiple rows Syntax:- INSERT I…
Read more
Social Plugin