DEV Community

Cover image for Create a MYSQL SERVER Query Management
Muhammad Idrees
Muhammad Idrees

Posted on

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)
)
Enter fullscreen mode Exit fullscreen mode

Select Query 

SELECT * from users
Enter fullscreen mode Exit fullscreen mode

Insert 

insert into userData values ('Muhammad Idrees','123456')
insert into users values ('Muhammad', 'Idrees','abc@gmail.com','+92123456789','123456789','staff colony DUHS flat no D6','no comments')
Enter fullscreen mode Exit fullscreen mode

Top comments (0)

Read next

ngobrolinit profile image

Path Environment Variable Di Windows

Ngobrolin IT -

byali_macqueline_lea profile image

Git And Markdown Basics

Byali Macqueline -

adamgazdiev profile image

Frontend Challenge - December Edition, Glam Up My Markup: Winter Solstice

Adam Gazdiev -

fadi-bck profile image

Managing Database Migrations for Multiple Services in a Monorepo with Alembic

Fadi -