• USER GUIDE
    • Getting Started
    • Introduction to MonetDB
    • Client Interfaces
    • SQL Summary
    • SQL Manual
      • Lexical Structure
      • Data Types
      • Data Definition
      • Data Manipulation
        • Table Expressions
        • Table Updates
        • Set Statement
        • Prepare Statement
        • Database Sample
        • Analyze Statement
        • Statistic Functions
        • Window Functions
        • Subqueries
        • Merge Statement
      • Importing and Exporting
      • Transaction Management
    • SQL Functions
    • SQL Programming
    • SQL Catalog
    • SQL Timing
    • Tutorials
  • ADMINISTRATOR GUIDE
  • DEVELOPER GUIDE

Need more help?

  •   GitHub Issues
  •   Stack Overflow
  •   Help Center

Documentation > USER GUIDE > SQL Manual > Data Manipulation

Data Manipulation

Data Manipulation

SELECTSELECT INTOWITH SELECT
INSERT VALUESINSERT SELECT
UPDATEMERGEDELETETRUNCATE
PREPAREEXECUTEDEALLOCATECALL
SETSET TIME ZONESET CURRENT_TIMEZONE

Transaction Management

START TRANSACTIONCOMMITROLLBACK
SET TRANSACTIONSET LOCAL TRANSACTION
SAVEPOINTRELEASE SAVEPOINTROLLBACK TO SAVEPOINT

Development Commands

EXPLAINPLANTRACEDEBUG
ANALYZESET OPTIMIZER

Pseudo Columns

CURRENT_SCHEMACURRENT_USERCURRENT_DATECURRENT_TIME
CURRENT_TIMESTAMPCURRENT_TIMEZONELOCALTIMELOCALTIMESTAMP
LOCALTIMESTAMPNEXT VALUE FOR
Index Definitions Table Expressions

Copyright © 2008-2022 MonetDB B.V. All rights reserved