Show TOC

insert_statementLocate this document in the navigation structure

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