INSERT, UPDATE, DELETE

Leave a comment

September 26, 2012 by Er.Hem Raj Thakur

here we declare the some tables example for inserting Data statement…

Q. 1 :- What is DML Command?

Answer:- DML is abbreviation of (Data Manipulation Language). It is used to retrieve,store, modify, delete, insert and update data in database.

Examples: SELECT, UPDATE, INSERT statements

tbl_department, tbl_designation, tbl_country, tbl_state, tbl_district, tbl_area, tbl_employee

**************************************************************

tbl_department

insert into tbl_department (department,location) values(‘Management’,’Mandi’)
insert into tbl_department (department,location) values(‘HR’,’Mandi’)

*************************************************************

tbl_country

insert into tbl_country (country_name,isd_code) values(‘India’,’+91′)
insert into tbl_country (country_name,isd_code) values(‘Pakistan’,’+92′)

*************************************************************

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: