My Sql Queries

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.