The UPDATE Statement, first begins with making table will be updated later in which field update.

The UPDATE Format :

UPDATE <TABEL_NAME> 
SET 
<FIELDNAME>=<DATA_FIELD> 
WHERE 
<FIELDWHERE>=<ROWWHERE>;

Continue reading

The INSERT INTO Statement, the first begins with making table in the insert and fill the data.

The INSERT INTO Format :

INSERT INTO TABLE_NAME
 (<FIELDNAME1>,<FIELDNAME2>,<FIELDNAME3>) 
VALUES 
 (<FIELD_DATA1>, <FIELD_DATA2>, <FIELD_DATA3>);

Continue reading

The SELECT statement is used to select any data from a database.

 

The SQL SELECT Format :

 SELECT * FROM <TABEL_NAME>; 

 SELECT <FIELDNAME1>, <FIELDNAME2>, .... FROM <TABEL_NAME>; 

Continue reading