Syntax documentationinsert_statement Locate this document in the navigation structure

Syntax Syntax

  1. <insert_statement> ::=
      INSERT [INTO] <table_name>
        [(<column_name>,...)]
        VALUES (<insert_expression>,...)
        [<duplicates_clause>]
        [IGNORE TRIGGER]
        [NOWAIT]
    | INSERT [INTO] <table_name>
        [(<column_name>,...)]
        <query_expression>
        [<duplicates_clause>]
        [IGNORE TRIGGER]
        [NOWAIT]
    | INSERT [INTO] <table_name>
        SET <set_insert_clause>,...
        [<duplicates_clause>] 
        [IGNORE TRIGGER]
        [NOWAIT]
    <!  This SQL clause is no longer recommended to be used 
        and might be removed from future versions.  !>
End of the code.