If you getting the 2002 error trying to connect to MySQL: It simply means that the MySQL server is not installed or running, or mysql.sock… Read More »How to solve Can’t connect to local MySQL server through socket
Almost every MySQL user did ask the question „how to find MySQL default root password“ at least once.The answer is easy for those, who did… Read More »Default MySQL username and password: the ultimate guide
You can concatenate rows into a single string using GROUP_CONCAT method. GROUP_CONCAT method can be used as an aggregate function(like GROUP BY), which returns a… Read More »MySQL: How To Concatenate Multiple Rows Into Single String
Are you struggle with how to properly use the quote sign in MySQL? This tutorial gives you exhausting information about how and when to use… Read More »[MySQL]: How to use Single quotes, double quotes, and backticks
This tutorial helps you to understand, how to sort the result set of an SQL query by one or more columns using ORDER BY clause.… Read More »ORDER BY: How to sort data in SQL using ORDER BY clause
In this post, you will learn how to collect data from a database using a “SELECT FROM” statement. Without many words, let’s dive into an… Read More »Anatomy of SELECT FROM Queries for beginners
In this tutorial, you will learn how to create an SQLite database using a command line or dbHarbor: SQLite. SQLite – CREATE Database using the… Read More »How to create an SQLite Database. Use dbHarbor to save time.
INSERT INTO with SELECT FROM another table as a value Usually, you use SELECT FROM statement to query data from a table. But there is… Read More »How to insert from select query – the ultimate guide
SQLite ‘CREATE’ table statement In this article, we will see how to create a table in SQLite with examples using dbHarbor. SQL CREATE TABLE statement is… Read More »How to create an SQLite table in 5 Minutes
It’s almost 10 months from the start of developing dbHarbor. Slowly we are getting to the point, where we want to be with dbHarbor. Almost… Read More »Exciting news! dbHarbor is almost there.