How Will You Create a Table With Boolean Data Type in MySQL?


Scott Campbell

In this tutorial, we will learn how to create a table with the boolean data type in MySQL. The boolean data type represents two states, true or false, and is commonly used to store binary values.

Step 1: Creating a Database

Before we create a table, let’s start by creating a database to hold our table. We can use the following SQL statement:

CREATE DATABASE your_database_name;

Make sure to replace your_database_name with the desired name for your database.

Step 2: Creating a Table

To create a table with the boolean data type, we can use the CREATE TABLE statement followed by the column name and its data type. Here’s an example:

CREATE TABLE your_table_name (
   name VARCHAR(50),
   is_active BOOLEAN

In this example, we have created a table called your_table_name. It consists of three columns:

  • ID: An integer column that serves as the primary key with the AUTO_INCREMENT attribute.
  • Name: A varchar column that stores names with a maximum length of 50 characters.
  • Is_active: A boolean column that represents whether an entry is active or not.

Step 3: Inserting Data into the Table

We can insert data into our newly created table using the INSERT INTO statement. Here’s an example:

INSERT INTO your_table_name (name, is_active)
VALUES ('John Doe', true);

In this example, we are inserting a row with the name ‘John Doe’ and setting the is_active column to true.

Step 4: Retrieving Data from the Table

To retrieve data from our table, we can use the SELECT statement. Here’s an example:

SELECT * FROM your_table_name;

This query will return all rows and columns from the your_table_name table.


Congratulations! You have successfully learned how to create a table with the boolean data type in MySQL.

Remember that the boolean data type is useful for storing binary values such as true or false. You can now create tables with boolean columns and perform various operations on them.

Make sure to practice what you have learned to reinforce your understanding. Happy coding!

Discord Server - Web Server - Private Server - DNS Server - Object-Oriented Programming - Scripting - Data Types - Data Structures

Privacy Policy