SQLite Database

  1. Data Manipulation Language
    1. Inserting Data
      1. INSERT INTO VALUES Syntax
        1. Inserting Multiple Rows
          1. INSERT OR REPLACE Statement
            1. INSERT OR IGNORE Statement
              1. INSERT SELECT for Bulk Inserts
                1. Handling Auto-Increment Fields
                  1. Default Value Handling
                  2. Updating Data
                    1. Basic UPDATE Syntax
                      1. Using SET to Modify Columns
                        1. Filtering with WHERE
                          1. UPDATE OR REPLACE
                            1. UPDATE OR IGNORE
                              1. Multi-Table Updates
                              2. Deleting Data
                                1. DELETE FROM WHERE Syntax
                                  1. Deleting All Rows from a Table
                                    1. Effects on Auto-Increment Counters
                                      1. Conditional Deletion
                                      2. Data Import and Export
                                        1. CSV Import and Export
                                          1. Using .import Command
                                            1. Bulk Data Operations
                                              1. Data Validation During Import

                                            Previous

                                            3. Core SQL Concepts and Data Definition

                                            Go to top

                                            Next

                                            5. Querying Data with SELECT