MySql basic querries - show, create, select, insert, delete, update, alter, drop, truncate
Channel:
Subscribers:
3,010
Published on ● Video Link: https://www.youtube.com/watch?v=XMY6Wt1NREg
1761) show databases
2) create database thewayur
3) use thewayur
4) show tables
5) create table nishu(
id int(3) auto_increment primary key,
name varchar(20) not null,
age int(3))
6) select *from nishu
7) insert into nishu (name,age) values('varun',21)
8) Update nishu set name ="sanjay" where id =2
9) delete from nishu where name ="varun"
10) alter table nishu add password varchar(16) not null
11) alter table nishu drop password
12) truncate table nishu
13) drop table nishu
14) drop database thewayur
Other Videos By NishuFun
Tags:
mysql
thewayur
querries
mysql 5.5
MySql basic querries - show
create
select
insert
delete
update
alter
drop
truncate