SQL Cheatsheet for MySQL client CLI

cheatsheet.sql

create table table_name (
    id integer primary key
    name varchar(255)
);

insert into table_name (column1,c2) values ('','') ;

drop user '<user_name>'@'localhost';

update table_name set first_name = value where id = '1';

alter table employees add new_column varchar(255)

alter table employees modify column varchar(255)

select * from employees as e inner join dept_emp as de on e.emp_no = de.emp_no inner join departments as d on d.dept_no = de.dept_no limit 1;

select * from employees order by id desc limit 1;

select *, users.id as userrr from users inner join tasks on tasks.user_id = users.id ;


select * from employees where age between (20,49) 

-- a virtual table based on the result of an sql query
create view virtual_emp as select * from employees;


-- Creating and droping indexes 
-- Creating prodecures