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 ...