Quadcap Embeddable Database

• QED Home
• User's Guide
• Developer's Guide
• API Documentation
• SQL Reference
• FAQ
• Changes

Quadcap Software

• Home
• Download
• Products
• Services
• Purchase
• Support
• About

The INSERT statement is used to insert new rows into a table or updatable view. The source of the new rows is a queryExpression, typically a VALUES expression or a SELECT expression.

insertStmt
  :  "insert" "into" sqlId 
    (  LPAREN idList RPAREN 
    |  
    ) 
    (  queryExpression 
    |  "default" "values" 
    ) 
  ;

INSERT INTO STAFF VALUES ('E1','Alice',12,'Deale');
INSERT INTO TEMP_S
SELECT EMPNUM,GRADE,CITY
FROM STAFF
WHERE GRADE > 11;

None.