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

luckysingh_ profile image

Master AWS by Building a Scalable Car Rental Web App

Lucky Singh Chauhan -

informatik-ninja profile image

🇩🇪 PHP 8.4: Was ist neu?

Pascal Kleindienst -

siddharthbhalsod profile image

Open-Source AI Models: A Comprehensive Overview

Siddharth Bhalsod -

arafatweb profile image

Have you noticed? When you type in the Quickie Post text box, it grows larger with every keystroke—it feels like an unintentional bug. But hey, Quickie Post is finally here, and it’s looking amazing! 🥳

Arafat Hossain Ar -