How to create database?
create database databasename
How to create table?
Create table tablename(tablefieldname varchar(50),tablefieldname1 varchar(50),tablefieldname2 varchar(50))
How to alter table?
alter table tablename add tablefieldname3 int
How to read from table?
select * from tablename
How to insert data to table?
insert into tablename values ('ANURAJ S','Chathannoor','9447990404')
How to update data from table?
update tablename set tablefieldname3=5 where ptablefieldname='ANURAJ S'
How to delete data from table?
delete from tablenamewhere ptablefieldname='ANURAJ S'
how to join 2 tables?
select * from tablename a INNER JOIN tablename1 b on a.tablefieldname=b.tablefieldname2
in this tablefieldname and tablefieldname2 contain common values and they are in same format
