Basics of My SQL:

SQL is mainly used for storing and retrieving data from databases, but it can do much more than that. Anything you need to do with a database, you can do with SQL. It’s flexible, powerful, and quick while being accessible and affordable for most businesses.

Basic steps:

Open My SQL Workbench.

Create Database:

A database is an organized collection of structured information, or data, typically stored electronically in a computer system. A database is usually controlled by a database management system (DBMS).

• First create new Database eg:(learning).
• next step use database learning

Create table:

Create table inside the (Learning)database

• Table name (movies)
• using Data type (varchar(20))

create table movies(movie_name varchar(20),actor varchar(20),release_year int,director varchar(20),production varchar(20));

movie_name	actor	release_year	Director	production

Insert value inside the table:

insert into movies value("jilla","vijay",1998,"sk","sunpictures");
insert into movies value("Kathi","vijay",2000,"sk",sunpictures");
insert into movies value("theri","vijay",2001,"sk","sunpictures");
insert into movies value("villu","vijay",2002,"sk","sunpictures");

movie_name	actor	release_year	director	production
jilla	vijay	1998	sk	sunpictures
kathi	vijay	2000	sk	sunpictures
theri	vijay	2001	sk	sunpictures
villu	vijay	2002	sk	sunpictures

If you Want to delete particular database:

delete from movies where movie_name=""kathi";

movie_name	actor	release_year	director	production
jilla	vijay	1998	sk	sunpictures
theri	vijay	2001	sk	sunpictures
villu	vijay	2002	sk	sunpictures

If you Want to update the table:

update movies set movie_name="beast" where release_year=1998;

movie_name	actor	release_year	director	production
beast	vijay	1998	sk	sunpictures
theri	vijay	2001	sk	sunpictures
villu	vijay	2002	sk	sunpictures

If you Want to insert the another values in table:

insert into movies value("billa","ajith",2020,"null","sunpictures);

movie_name	actor	release_year	direction	production
beast	vijay	1998	sk	sunpictures
theri	vijay	2001	sk	sunpictures
villu	vijay	2002	sk	sunpictures
billa	ajith	2020		sunpictures

If youWant count the table how many Rows:

select count(*) from movies;

4 rows in a table

If you want to select particular name from table:

select * from movies where movie_name<="theri";

movie_name	actor	release_year	direction	production
theri	vijay	2001	sk	sunpictures

My output: