Create a MYSQL SERVER Query Management

• create database sql_tutorial

CREATE TABLE users (
id int primary key identity,
firstname VARCHAR(50),
lastname VARCHAR(50),
email VARCHAR(50),
phone VARCHAR(50),
password VARCHAR(100),
address VARCHAR(60),
comment VARCHAR(255)
)

Select Query

SELECT * from users

Insert

insert into userData values ('Muhammad Idrees','123456')
insert into users values ('Muhammad', 'Idrees','[e-mail]','[phone]','123456789','staff colony DUHS flat no D6','no comments')