Skip to content
  • Home
  • Roadmap
  • Blog
  • Home
  • Roadmap
  • Blog

How to solve Can’t connect to local MySQL server through socket

  • by Ruslan
  • September 10, 2020September 11, 2020

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

Default MySQL username and password: the ultimate guide

  • by Ruslan
  • September 6, 2020September 7, 2020

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

MySQL: How To Concatenate Multiple Rows Into Single String

  • by Ruslan
  • April 5, 2020April 5, 2020

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

[MySQL]: How to use Single quotes, double quotes, and backticks

  • by Ruslan
  • April 3, 2020October 28, 2020

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

ORDER BY: How to sort data in SQL using ORDER BY clause

  • by Ruslan
  • March 30, 2020March 30, 2020

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

Anatomy of SELECT FROM Queries for beginners

  • by Ruslan
  • March 24, 2020March 31, 2020
  • 2 Comments

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

How to create an SQLite Database. Use dbHarbor to save time.

  • by Ruslan
  • March 16, 2020March 24, 2020

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.

How to insert from select query – the ultimate guide

  • by Ruslan
  • February 15, 2020October 28, 2020

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

How to create an SQLite table in 5 Minutes

  • by Ruslan
  • January 31, 2020March 14, 2020

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

Exciting news! dbHarbor is almost there.

  • by Ruslan
  • January 20, 2020January 20, 2020

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.

  • 1
  • 2
  • Next »

dbHarbor