MySQL Interview Questions

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 …

MySQL Interview Questions Read More »