mysql
-
Software Development
Fix MySQL Key Length Error
Fixing the MySQL Error ‘Specified key was too long’ is essential for developers working with MySQL databases. This error occurs…
Read More » -
sql
SQL Cheat Sheet
1. Introduction A sql cheat sheet is a notepaper where you write down some information that you will need sometimes…
Read More » -
sql
SQL IF Statement Example
1. Introduction Structured Query Language (SQL) supports the IF statement like any other programming language. The IF statement tests a…
Read More » -
sql
How to Create a Table in MySQL
In this article, we explain how to create a table in MySQL. 1. Introduction MySQL database is used by developers…
Read More » -
sql
Date Format in SQL
In this article, we will explain the Date Format in SQL. 1. Introduction Structured Query Language (SQL) defines the date…
Read More » -
sql
How to Download and Install MySQL
In this article, we’re going to see how to download and install MySQL using the default installer. Also, we’ll set…
Read More » -
sql
MySQL UPDATE Statement
In this example, I will demonstrate how to use the UPDATE statement to modify values using MySQL. 1. Introduction MySQL…
Read More » -
sql
SQL SUBSTRING Function
In this article, we’re going to explain the SUBSTRING function in SQL. 1. Introduction The SUBSTRING function is available in…
Read More » -
sql
MySQL with Node.js and Express.js
Hello in this tutorial, we will understand how to create a RESTful API in a Node.js environment running on an…
Read More » -
sql
SQL Between, MySQL Between Dates, Not Between
In this example, we will see how to use the BETWEEN operator included in the SQL. 1. Introduction The BETWEEN is…
Read More »