MySQL Data Types Summary: in this tutorial, you will learn about MySQL data types and how to use them effectively in designing databases in MySQL. A database table contains multiple columns with specific data types such as numeric or string. MySQL provides more data types other than just numeric and string. Each data type in MySQL can be…
Read more
How To Use The MySQL Generated Columns Summary: in this tutorial, you will learn how to use MySQL-generated columns to store data computed from an expression or other columns. Introduction to MySQL generated column When you create a new table, you specify the table columns in the CREATE TABLE statement. Then, you use the INSERT,…
Read more
MySQL TRUNCATE TABLE Summary: in this tutorial, you will learn how to use the MySQL TRUNCATE TABLE statement to delete all data in a table. Introduction to the MySQL TRUNCATE TABLE statement The MySQL TRUNCATE TABLE statement allows you to delete all data in a table. Logically, the TRUNCATE TABLE statement is like a DELETE statement…
Read more
MySQL Temporary Table Summary: in this tutorial, we will discuss MySQL temporary table and show you how to create, use and drop temporary tables. Introduction to MySQL temporary tables In MySQL, a temporary table is a special type of table that allows you to store a temporary result set, which you can reuse several times…
Read more
MySQL DROP TABLE Summary: in this tutorial, you will learn how to use the MySQL DROP TABLE statement to drop a table from the database. MySQL DROP TABLE statement syntax To remove existing tables, you use the MySQL DROP TABLE statement. Here is the basic syntax of the DROP TABLE statement: DROP [TEMPORARY] TABLE [IF EXISTS]…
Read more
How to Add Columns to a Table Using MySQL ADD COLUMN Statement Summary: in this tutorial, we will show you how to add a column to a table using MySQL ADD COLUMN statement. Introduction to MySQL ADD COLUMN statement To add a new column to an existing table, you use the ALTER TABLE ADD COLUMN statement as…
Read more
MySQL DROP COLUMN Summary: in this tutorial, you will learn how to drop a column from a table using the MySQL DROP COLUMN statement. Introduction to MySQL DROP COLUMN statement In some situations, you want to remove one or more columns from a table. In such cases, you use the following ALTER TABLE DROP COLUMN statement:…
Read more
How To Rename Table Using MySQL RENAME TABLE Statement Summary: in this tutorial, you will learn how to rename tables using MySQL RENAME TABLE statement and ALTER TABLE statement. Introduction to MySQL RENAME TABLE statement Because business requirements change, we need to rename the current table to a new one to better reflect the new…
Read more
MySQL ALTER TABLE Summary: in this tutorial, you will learn how to use the MySQL ALTER TABLE statement to add a column, alter a column, rename a column, drop a column and rename a table. Setting up a sample table Let’s create a table named vehicles for the demonstration: CREATE TABLE vehicles ( vehicleId INT,…
Read more
MySQL Sequence Summary: in this tutorial, you will learn how to use MySQL sequence to automatically generate unique numbers for ID columns of tables. Creating MySQL sequence In MySQL, a sequence is a list of integers generated in the ascending order i.e., 1,2,3… Many applications need sequences to generate unique numbers mainly for identification e.g.,…
Read more