select * from cap;
use cap;
desc cap;
/*DDL: DATA DEFINITION LANGUGE: create,alter,drop,truncate,rename */
create table cap(cid int,cname varchar(20));
select * from cap;
desc cap;
alter table cap add column csal int(3);
alter table cap rename column csal to csalary;
alter table cap modify column cname varchar(20);
alter table cap drop column csalary;
rename table cap to capg;
drop table cap;
/*DML: DATA MANIPULATION LANGUGAE: INSERT,UPDATE,DELETE*/
INSERT INTO CAP VALUES(120,'mixed');
UPDATE CAP SET CNAME="SOMA" WHERE CID=121;
DELETE FROM CAP WHERE CID=121;
TRUNCATE TABLE CAP;
DELETE FROM CAP;
/*tcl:trasaction control langugage: commit ,rollback,savepoint*/
start transaction;
commit;
rollback;
savepoint first;...