The FLUSH statement can be used to clean or reload various internal caches, flush tables, or acquire locks. Flush means reset. The command FLUSH TABLES
Author: SHAFI SHAIK
Hi, this is Shafi Shaik, Microsoft Solutions Specialist in Data platform as well as in Data Management & Analytics. I am a certified associate in Oracle SQL*Plus and extensively trained in MongoDB Administration. My current role is Database administration with hands-on expertise in almost all relational databases namely Microsoft SQL Server, MySQL, Oracle SQL*Plus, PostGreSQL & Teradata. I'm also specialized in database development, warehousing, traditional data analysis and Big Data analysis.
Flush Hosts – MySQL
The FLUSH statement can be used to clean or reload various internal caches, flush tables, or acquire locks. Flush means reset. MySQL will clear the
Flush Privileges – MySQL
After creating the user and granting the necessary permissions, reload mysqladmin or restart the MySQL service to enforce the changes. Aside from that, the flush
SQL, TSQL and PL/SQL
The distinction between SQL, TSQL, and PL/SQL is a question that regularly arises while teaching data platform courses because these terminologies are used frequently in
INSERT the key into multiple tables in MySQL
Foreign key relationships may occasionally need to be inserted at the same time as the primary key. We won’t know what the primary key will
Last Insert ID in MySQL
LAST_INSERT_ID() function return the AUTO_INCREMENT id of the last row that has been inserted or updated in a table. Here is an example. DROP TABLE
Big Data and SQL 