Basic SQL Query

create database sample;
/*DROP DATABASE database_name;*/
DROP DATABASE sample;
use sample;
create table tbl1 (Fname varchar(10),age int,city varchar(5));
insert into tbl1 values ('AFname',20,'Acity');
insert into tbl1 values ('BFname',20,'Bcity');
insert into tbl1 values ('BFname',20,'Bcity');
INSERT INTO tbl1 (Fname, age) VALUES ('CFname', 67);
select * from tbl1;

truncate table tbl1;
drop table tbl1;

select * from tbl1;
select DISTINCT Fname,age,city from tbl1;

SELECT * FROM tbl1 WHERE Fname LIKE 'a%';/*Fname start with an 'a'*/
SELECT * FROM tbl1 WHERE Fname LIKE '%e';/*Fname end with an 'e'*/
SELECT * FROM tbl1 WHERE Fname LIKE '%bn%';/*Fnames that contain the pattern 'bn'*/

UPDATE
UPDATE tbl1 SET Fname = 'CCFname' WHERE Fname = 'CFname';
UPDATE tbl1 SET Fname = 'CFname',age=7,city='Ccity' WHERE Fname = 'CCFname';

DELETE
DELETE FROM tbl1 WHERE Fname = 'BFname';
DELETE FROM tbl1;
DELETE * FROM tbl1;--Incorrect syntax near '*'.

ORDER BY
SELECT * FROM tbl1 ORDER BY Fname;
SELECT * FROM tbl1 ORDER BY Fname ASC;
SELECT * FROM tbl1 ORDER BY Fname, age;
SELECT * FROM tbl1 ORDER BY Fname DESC;

AND/ OR
SELECT * FROM tbl1 WHERE Fname='AFname' AND age<21;>
SELECT * FROM tbl1 WHERE Fname='AFname' OR age<21;>

IN
SELECT * FROM tbl1 WHERE (Fname='AFname' AND age<21) city="'Ccity';">
SELECT * FROM tbl1 WHERE Fname NOT IN ('AFname','BFname');

BETWEEN
SELECT * FROM tbl1 WHERE Fname BETWEEN 'AFname' AND 'BFname';
SELECT * FROM tbl1 WHERE age BETWEEN 10 AND 20;
SELECT * FROM tbl1 WHERE age NOT BETWEEN 10 AND 20;

Alias Name
SELECT Fname AS Name FROM tbl1;//Column Fname Alias
SELECT Fname FROM tbl1 AS t1;//Table Fname Alias
SELECT t1.Fname,t1.age FROM tbl1 AS t1;