• Product
  • Developers
    • Get Started
    • HarperDB Cloud
    • Developer Marketplace
    • Bounty Program
    • Benchmarks
    • Documentation
    • API Documentation
    • Developer Examples
    • Support
    • Release Notes
  • Pricing
  • Company
    • Contact Us
    • The HDBlog
    • About Us
    • The Team
    • Core Values
    • SELECT*: A HarperDB Podcast
    • Press
    • Careers
    • Workshop
    • Resources
  • Studio Login
  • Start Free

Documentation

Topics


  • Overview
  • Getting Started
  • Install HarperDB
    • Offline Install
    • Automated Installation
    • With Docker
    • On Linux
    • On Mac
    • On Digital Ocean
    • On Windows 10 (WSL 2)
  • HarperDB Studio
    • Create an Account
    • Log In & Password Reset
    • Resources (Marketplace, Drivers, Tutorials, & Example Code)
    • Organizations
    • Instances
    • Charts
    • Manage Schemas / Browse Data
    • Query Instance Data
    • Manage Clustering
    • Manage Instance Users
    • Manage Instance Roles
    • Instance Metrics
    • Instance Configuration
    • Instance Example Code
    • Enable Mixed Content
  • HarperDB Cloud
    • IOPS Impact on Performance
    • Instance Size Hardware Specs
    • Alarms
  • HarperDB API
  • Security
    • JWT Authentication
    • Basic Authentication
    • Configuration
    • Users & Roles
  • Clustering
    • Requirements and Definitions
    • Creating A Subscription
    • Schema Replication Across A Cluster
    • Clustering Users and Roles
    • Pub/Sub Connector
    • Queueing
  • SQL Overview
    • SQL Features Matrix
    • Insert
    • Update
    • Delete
    • Select
    • Joins
    • SQL Date Functions
    • SQL Reserved Word
    • SQL Functions
  • SQL JSON Search
  • SQL Geospatial Functions
    • geoArea
    • geoLength
    • geoCircle
    • geoDifference
    • geoDistance
    • geoNear
    • geoContains
    • geoEqual
    • geoCrosses
    • geoConvert
  • Reference
    • Configuration File
    • Logging
    • Job Logs
    • Transaction Log
    • HarperDB Limits
  • Add-Ons & SDKs
    • Google Data Studio
  • Common Issues
  • Support
  • FAQ

Insert

HarperDB supports inserting 1 to n records into a table.  The only constraint is the hash_attribute must be defined and supplied a unique value per row. HarperDB does not support selecting from one table to insert into another at this time.

 

INSERT INTO dev.dog (id, dog_name, age, breed_id) 
   VALUES(1, 'Penny', 5, 347), (2, 'Kato', 4, 347)

Legal Stuff | Privacy Policy | © HarperDB. All Rights Reserved