MySQL Tutorial

MySQL Queries

mysql query

In this section, you will learn more about the MySQL queries and it will also help you to improve your database query concepts.

How to Create MySQL Database

You can create the MySQL database by using the below query:

create database database_name;

1	create database database_name;

How to create MySQl Table

Use below MySQL query to create a MySQL table:

CREATE TABLE tbl_employee(  
   emp_id INT NOT NULL AUTO_INCREMENT,
   dept_id INT NOT NULL,
   emp_firstname VARCHAR(100) NOT NULL,
   emp_lastname VARCHAR(100) NOT NULL,
   emp_salary VARCHAR(100) NOT NULL,
   PRIMARY KEY (emp_id)
);

CREATE TABLE tbl_employee(

emp_id INT NOT NULL AUTO_INCREMENT,

dept_id INT NOT NULL,

emp_firstname VARCHAR(100) NOT NULL,

emp_lastname VARCHAR(100) NOT NULL,

emp_salary VARCHAR(100) NOT NULL,

PRIMARY KEY (emp_id)

);

How to insert data in MySQl Table

Want to insert data in MySQL table, then use the below query:

INSERT INTO employee(emp_id, emp_name, salary) VALUES
(002, 'Amit Kumar', 30000);

1 2	INSERT INTO employee(emp_id, emp_name, salary) VALUES (002, 'Amit Kumar', 30000);

How to delete data in MySQl Table

Use below code to delete the data from MySQL table.

DELETE FROM employee WHERE
emp_id = 6;

1 2	DELETE FROM employee WHERE emp_id = 6;

How to truncate MySQl Table

Use below MySQL query to truncate MySQL table.

TRUNCATE TABLE  tbl_employee;

1	TRUNCATE TABLE tbl_employee;

How to write a MySQL select query

Below is an example to fetch data from MySQL table by using the select query:

SELECT emp_id, emp_name, emp_dept FROM
employee
WHERE emp_dept='HR';

SELECT emp_id, emp_name, emp_dept FROM

employee

WHERE emp_dept='HR';

How to write a MySQL update query

Want to update the existing data in MySQL table, then use the below query to update the data in MySQL table.

UPDATE employee  
SET emp_name = 'Ramesh Singh'
WHERE emp_id = 12;

UPDATE employee

SET emp_name = 'Ramesh Singh'

WHERE emp_id = 12;