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 […]
Category Archives: mysql
MySQL – Show Privileges Table of content The users in MySQL must have enough privileges to interact with the server. This is possible by assigning authentication details, like passwords to the users. In addition to this, operational or administrative privileges are granted separately if a user wants to interact with and operate on the data. […]
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 […]