DevDummy

It is always convenient to copy a selected set of data to a table directly from another table using nested select queries. INSERT INTO table...

While we are working with SQL Server, it is often required to see the tables under the different schemas.  You can still do that via SQL Ser...

How to Insert Data to a Table by Selecting from a Different Table It is often required to insert data in to a table selectively fetch...

Drop/ Truncate all the tables in a schema in MySQL Database It is often required to delete tables from a MySQL schema. Following is a...

Is it often required to find the exact MySQL version running in a specific system. Specially it is required to check the version incomp...

While working with developer testing and related stuff, it is often required to update the database schema, use old versions or r...

In SQL Scripting, it is often required to reuse the queried values, while executing queries in sequence. User defined variables are ...

INSERT IGNORE  option by MySQL is a very convenient keyword to gracefully handle an INSERT of a record with an existing Key. The r...

It is often required to investigate the queries executed on MySQL Server Log for many reasons when debugging. Specially it allows to...

Define the variable and set it in the server, SET @country = 'Sri Lanka'; SET @section = 'Science Fiction '; Now...