Add Row Sql Code Example

Example 1: sql insert query

--sql insert quest example INSERT INTO table_name (column1, column2, column3, ...) VALUES (value1, value2, value3, ...);

Example 2: how to add records to sql table

INSERT INTO Customer (FirstName, LastName, City, Country, Phone) VALUES ('Craig', 'Smith', 'New York', 'USA', 1-01-993 2800)

Example 3: sql insert

-- Note: This is specifically for SQL - Oracle -- --------------------------------------------------------------- -- OPTION 1: Insert specific values (other values will be null)  -- syntax  INSERT INTO <TABLE_NAME> (<column1>,<column2>,<column3>,...)  VALUES (<value1>,<value2>,<value3>,...);  -- example INSERT INTO SALES (SALE_ID,ITEM_ID,QUANTITY,AMOUNT) VALUES (631,13,4,59.99); -- --------------------------------------------------------------- -- OPTION 2: Insert a value for every field  -- syntax INSERT INTO <TABLE_NAME> VALUES (<value1>,<value2>,...,<valueN>);  -- example (SALES table only consists of 4 columns) INSERT INTO SALES VALUES (631,13,4,59.99); -- ---------------------------------------------------------------

Example 4: sql command to add row to table

INSERT INTO table(column1, column2,...) VALUES (value1, value2,...);

Example 5: how to add records to sql table

INSERT INTO table-name (column-names) VALUES (values)