priya

A trigger is a set of codes that executes in response to some events. A trigger in MySQL is a set of SQL statements that automatically “fires” or executes when a specific event occurs on a table, such as INSERT, UPDATE, or DELETE operations. Triggers are commonly used to enforce data integrity rules, audit changes … Read more

BLOB is an acronym that stands for a large binary object. It is used to hold a variable amount of data. There are four types of the BLOB. TINYBLOB BLOB MEDIUMBLOB LONGBLOB The differences among all these are the maximum length of values they can hold. TEXT is a case-insensitive BLOB. TEXT values are non-binary … Read more

Tables that are present in memory is known as HEAP tables. When you create a heap table in MySQL, you should need to specify the TYPE as HEAP. These tables are commonly known as memory tables. They are used for high-speed storage on a temporary basis. They do not allow BLOB or TEXT fields. In … Read more

There are only six Triggers allowed to use in the MySQL database. Before Insert After Insert Before Update After Update Before Delete After Delete In MySQL, the number of triggers you can create depends on the version you are using and the specific configuration of your MySQL instance. Generally, MySQL imposes a limit on the … Read more

TRUNCATE is a DDL command, and DELETE is a DML command. It is not possible to use Where command with TRUNCATE QLbut you can use it with DELETE command. TRUNCATE cannot be used with indexed views, whereas DELETE can be used with indexed views. The DELETE command is used to delete data from a table. … Read more