MySQL autoincrement is used to automatically generate unique numbers for new rows. Usually, it used for identifiers. Let’s write SQL statement to create a new table with autoincrement id column. Every time when you insert a new row into the table new id will be generated: As you can see I don’t provide any values … Read more
I’ll explain how to join more than two tables in SQL. But first of all, you need to be sure that your MySQL server is installed and running. Let’s create 3 table and write a join SQL statement. For example, we have a student table with 3 students “John”, “Henry” and “Michael”. id name 1 … Read more
Installing MySQL on Ubuntu using the command line is the same as on Ubuntu server. The short answer is: Additionally, you can run the secure installation script: Let’s take a deeper look how to install MySQL on Ubuntu, how to check MySQL version, how to access database as admin and how to remove it completely. … Read more
I prepared a list of the best books with author names for learning, optimizing, troubleshooting, and administrating your MySQL database. Most of these books are in my home library. Books for Beginners These books could be useful for beginners to learn MySQL from scratch and for developers with some experience to structure your knowledge. Murach’s … Read more
First of all, let’s define what is DDL, DML, DCL, and TCL in DBMS. DDL is Data Definition Language DML is Data Manipulation Language DCL is Data Control Language TCL is Transaction Control Language As you see from its name it allows to define, manipulate and control data and transactions in SQL language. It’s four … Read more