MySQL CREATE TABLE Summary: in this tutorial, we will show you how to use the MySQL CREATE TABLE statement to create a new table in the database. MySQL CREATE TABLE syntax The CREATE TABLE statement allows you to create a new table in a database. The following illustrates the basic syntax of the CREATE TABLE…
Read more
Understanding MySQL Storage Engines Summary: in this tutorial, you will learn various MySQL storage engines or table types. It is essential to understand the features of each storage engine in MySQL so that you can use them effectively to maximize the performance of your databases. MySQL provides various storage engines for its tables as follows:…
Read more
MySQL DROP DATABASE Summary: in this tutorial, you will learn how to use the MySQL DROP DATABASE statement to delete an existing database in the server. Introduction to the MySQL DROP DATABASE statement The DROP DATABASE statement drops all tables in the database and deletes the database permanently. Therefore, you need to be very careful…
Read more
MySQL CREATE DATABASE Summary: in this tutorial, you will learn how to use the MySQL CREATE DATABASE statement to create a new database on a MySQL database server. Introduction to the MySQL CREATE DATABASE statement To create a new database in MySQL, you use the CREATE DATABASE statement with the following syntax: CREATE DATABASE [IF…
Read more
Selecting a MySQL Database Using USE Statement Summary: in this tutorial, you will learn how to select a database in the mysql program and MySQL Workbench by using the USE statement. Selecting a MySQL database using the mysql client tool When you log in to a MySQL database server using the mysql client tool without specifying…
Read more
MySQL Table Locking Summary: in this tutorial, you will learn how to use MySQL locking for cooperating table accesses between sessions. A lock is a flag associated with a table. MySQL allows a client session to explicitly acquire a table lock for preventing other sessions from accessing the same table during a specific period. A…
Read more
MySQL Prepared Statement Summary: in this tutorial, you will learn how to use MySQL prepared statement to make your queries execute faster and more secure. Introduction to MySQL prepared statement Prior MySQL version 4.1, a query is sent to the MySQL server in the textual format. In turn, MySQL returns the data to the client using…
Read more
MySQL REPLACE Summary: in this tutorial, you will learn how to use the MySQL REPLACE statement to insert or update data in database tables. Introduction to MySQL REPLACE statement The MySQL REPLACE statement is an extension to the SQL Standard. The MySQL REPLACE statement works as follows: Step 1. Insert a new row into the…
Read more
MySQL DELETE JOIN Summary: in this tutorial, we will show you how to delete data from multiple tables by using MySQL DELETE JOIN statement. In the previous tutorial, you learned how to delete rows of multiple tables by using: A single DELETE statement on multiple tables. A single DELETE statement on multiple related tables which the child table…
Read more
MySQL ON DELETE CASCADE Summary: in this tutorial, you will learn how to use MySQL ON DELETE CASCADE referential action for a foreign key to delete data from multiple related tables. In the previous tutorial, you learned how to delete data from multiple related tables using a single DELETE statement. However, MySQL provides a more effective…
Read more