SQL Insert Command

Advertisements

Select Unique in SQL Alter Command in SQL

SQL Insert Command

Insert Command is used to insert new record in table. Using Insert Command you can insert a single or a multiple records in a table.

Insert data in table in two form, which is given below.

  • Insert data without speficying column name
  • Insert data by specifies both the column names and the values to be inserted

Insert data without speficying column name

Syntax

	
INSERT INTO table_name
VALUES (value1,value2,value3,...);

Insert data by specifies both the column names and the values to be inserted

Syntax

	
INSERT INTO table_name (column1,column2,column3,...)
VALUES (value1,value2,value3,...);

Employee table

Here you can insert data in Employee table by using Insert Command

emp_idnamesalary

Example

INSERT INTO Employee
VALUES (101, 'amit', 24000);

Result after Execute above query.

emp_idnamesalary
101Amit24000

Select Unique in SQL Alter Command in SQL

Advertisements

Buy This Ad Space @$20 per Month, Ad Size 600X200 Contact on: hitesh.xc@gmail.com or 9999595223

Pure VPN Privide Lowest Price VPN Just @ $1.65. Per Month with Non Detected IP Lowest Price Non Detected IP VPN

Magenet is best Adsense Alternative here we earn $2 for single link, Here we get links ads. Magenet

Download Projects

Google Advertisements


Buy Websites 9999595223

Buy College Projects with Documentation Contact on whatsapp 9999595223. Contact on: hitesh.xc@gmail.com or 9999595223 Try this Keyword C++ Programs

Advertisements