how to create table in mysql

We can create a table in the database, and there are many ways to create a table.

CREATE A NEW TABLE

CREATE TABLE IF NOT EXISTS testuser (

user_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,

name VARCHAR(20),

age INT,

email VARCHAR(50)

);

After executing the statement, MySQL will returns you a message to notify the new table successfully created or not.

DISPLAY