Blog Category: MySQL

MySQL

Efficiently Managing Data with SELECT During INSERT Queries

We may sometimes need data which is already present in table but we need that data during insert. If we query data first and then insert the data, it will require running 2 SQL commands. In this article, we will learn how to do it one singlw SQL Command.

MySQL

How to access mysql remote database from command line?

Sometimes we may need to access remote mysql database. we can access it with a simple command very easily.