MySQL – Table Locking Table of content MySQL database provides a multi-user environment, that allows multiple clients to access the database at the same time. To run this environment smoothly, MySQL introduced the concept of locks. A client in a session can lock a certain table they are working on, in order to prevent other […]

MySQL – Drop Tables Table of content The MySQL DROP TABLE statement The MySQL DROP TABLE statement is a Data Definition Language (DDL) command that is used to remove a table”s definition, and its data, indexes, triggers, constraints and permission specifications (if any). In simple terms, this statement will delete the entire table from the […]

MySQL – Rename Columns Table of content The ALTER TABLE statement in MySQL can be used to change the structure of a table. For instance, we can add, delete, or rename the columns, etc. using this statement. Following are the two options that can be used with the ALTER TABLE statement to rename a column(s) […]