Posts

Showing posts with the label Insert Into

INSERT INTO Statement

After Creating Table successfully we need to insert value in the existing table.So,I am showing you how to insert value in a row. The INSERT INTO Statement is used for insert value in a table as a row wise. There are two basic syntax.I am giving both of them. INSERT INTO TABLE_NAME (column1, column2, column3,...columnN) VALUES (value1, value2, value3,...valueN); and the other one is : INSERT INTO TABLE_NAME VALUES (value1,value2,value3,...valueN);   If we create a table for Customers then the query looks like:       INSERT INTO Customers(Cust_Id, Cust_Name, Cust_Addr,Cust_Phone) VALUES (1001, Harish, Park Street,+9178999999);   Similarly we can use the other one.Here we just put the value directly. never break the sequence , otherwise you 'll get wrong values.