Syntax and Queries | Eklavya Online

Syntax and Queries

MySQL Commands:
Show databases;
Create database db_name;
Use dbname;
Show tables;
Create table tb_name(id int, name varchar(20));
Desc tb_name;
Insert into tb_name values(101 , ‘name of person’);
Insert into tb_name (id) values(102);
Update tb_name set name=’person name’ where id=102;
Select * from tb_name;
Delete from tb_name where id=102;
Drop table tb_name;
Drop database db_name;
Rename table tb_old_name to tb_new_name;
Alter table customer add (remark varchar(20));
Alter table customer modify remark varchar(25);
Alter table customer modify remark varchar(20);
Alter table customer drop remark;
Alter table customer add remark varchar(20) first;
Alter table customer add remark varchar(20) after customer_name;