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
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.
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
While Loop in MySQL Stored Procedure
This is merely to show newcomers how to create a while loop within a stored procedure. Because the while loop requires BEGIN and END statements,
AWS Aurora vs AWS MySQL
The distributed relational database service known as Amazon Relational Database Service is provided by Amazon Web Services. It is a web service that runs “in
Big Data & SQL 