To create table:
create table table_name(col1 datatype(size),col2 datatype(size)……..);
create table ramgodgift (eno int,ename varchar(20));
To Insert Values into Table;
Insert into table_name(col1,col2…) values ( field value1,field value2…..);
insert into ramgodgift(eno,ename) values(1,'ramgodgift');
To create database::
Create database data_base_name;
Create database ramgodgift;
To delete the database::
Drop database database_name;
To get the backUp::
Mysqldump –u [username] -p [password] > [select a drive] [give back up name].sql;
Mysqldump –u root –p mifos > c:\ramgodgift.sql
To Update Table::
Update Table_name SET field1=value where field2=value;
Update ramgodgift set ename=’suresh’ where eno=2;
Note: varchar should be in single(‘’) quotes.
