INSERT INTO SELECT Statement Overview and Examples
This article covers the SQL INSERT INTO SELECT statement along with its syntax, examples, and … Read More
SQL DELETE duplicate Rows Using GROUP BY and HAVING clause
This article explains the process of performing SQL delete activity for duplicate rows from a … Read More
SQL SELECT INTO statement
This article will cover the SQL SELECT INTO statement including syntax, parameters and use with … Read More
How to Backup and Restore MySQL Databases Using the mysqldump Command
In this article, I am going to explain different ways to generate the backup in … Read More
Dump and Restore MySQL Databases using Windows Command Prompt
For most database work I use phpMyAdmin. However, on the rare occasion I encounter a … Read More
How to Import Large Database
How to Import Large Database Answer 1 It is always recommended to restore large MySQL … Read More
Tool to Import Large Database: BigDump
You can use Bigdump – BigDump: Staggered MySQL Dump Importer 20 Very very handy script, … Read More
Tuning MySQL my.cnf? Avoid this common pitfall!
It took me some time to decide the title for this article. MariaDB has been … Read More
MySQL Performance Tuning: Tips, Scripts and Tools
With MySQL, common configuration mistakes can cause serious performance problems. In fact, if you misconfigure … Read More
“MySQL server has gone away” Solutions
The MySQL server has gone away error, means that MySQL server (mysqld) timed out and … Read More
How to Optimize MySQL Performance Using MySQLTuner
Running MySQL at optimal settings for specific resources helps handle larger server loads and prevents … Read More
How to Sort an Alphanumeric Column in MYSQL?
I have a column with values like below after ordering by it’s column name (equipment_no) … Read More
How to Select Only Non-numeric Values from varchar Column in MySQL?
You need to use REGEXP for this. The syntax is as follows SELECT *FROM yourTableName … Read More
MySQL Query To Get max id From varchar Type And The Values In Numeric?
Use CAST() in MAX() to get max id from varchar type and values in numeric. … Read More