TheDeveloperBlog.com
C-Sharp | Java | Python | Swift | GO | WPF | Ruby | Scala | F# | JavaScript | SQL | PHP | Angular | HTML
SQLite Insert Query
SQLite Insert Query with history, features, advantages, installation, commands, syntax, datatypes, operators, expressions, databases, table, crud operations, clauses, like, glob, limit, and clause, advance sqlite
SQLite Insert QueryIn SQLite, INSERT INTO statement is used to add new rows of data into a table. After creating the table, this command is used to insert data into the table. There are two types of basic syntaxes for INSERT INTO statement: Syntax1: INSERT INTO TABLE_NAME [(column1, column2, column3,...columnN)] VALUES (value1, value2, value3,...valueN); Here, column1, column2, column3,...columnN specifies the name of the columns in the table into which you have to insert data. You don't need to specify the columns name in the SQlite query if you are adding values to all the columns in the table. But you should make sure that the order of the values is in the same order of the columns in the table. Then the syntax will be like this: Syntax2: INSERT INTO TABLE_NAME VALUES (value1,value2,value3,...valueN); Let's take an example to demonstrate the INSERT query in SQLite database. We have already created a table named "STUDENT". Now enter some records in that table. Inserting values by first method: INSERT INTO STUDENT (ID,NAME,AGE,ADDRESS,FEES) VALUES (1, 'Ajeet', 27, 'Delhi', 20000.00); INSERT INTO STUDENT (ID,NAME,AGE,ADDRESS,FEES) VALUES (2, 'Akash', 25, 'Patna', 15000.00 ); INSERT INTO STUDENT (ID,NAME,AGE,ADDRESS,FEES) VALUES (3, 'Mark', 23, 'USA', 2000.00 ); INSERT INTO STUDENT (ID,NAME,AGE,ADDRESS,FEES) VALUES (4, 'Chandan', 25, 'Banglore', 65000.00 ); INSERT INTO STUDENT (ID,NAME,AGE,ADDRESS,FEES) VALUES (5, 'Kunwar', 26, 'Agra', 25000.00 ); 
Second Method: You can also insert the data into the table by second method. INSERT INTO STUDENT VALUES (6, 'Kanchan', 21, 'Meerut', 10000.00 ); 
Output: You can see the output by using the SELECT statement: SELECT * FROM STUDENT; 
Next TopicSQLite Select Query
|
Related Links:
- Learn SQLite Tutorial
- SQLite History
- SQLite Interview Questions (2021)
- SQLite Data Types
- SQLite Operators
- SQLite Features
- SQLite Advantages and Disadvantages
- SQLite Installation
- SQLite Commands
- SQLite Syntax
- SQLite Expressions
- SQLite Create Database
- SQLite Attach Database
- SQLite Detach Database
- SQLite Create Table
- SQLite Like Clause
- SQLite Drop Table
- SQLite Insert Query
- SQLite Select Query
- SQLite Joins
- SQLite Update Query
- SQLite Delete Query
- SQLite Where Clause
- SQLite And Clause
- SQLite OR Clause
- SQLite Glob Clause
- SQLite Limit Clause
- SQLite Order by Clause
- SQLite juliandday
- SQLite strftime
- SQLite time
- SQLite Group by Clause
- SQLite Having Clause
- SQLite Distinct Keyword
- SQLite Union
- SQLite Union All
- SQLite Inner Join
- SQLite Outer Join
- SQLite Cross Join
- SQLite Date and Time
- SQLite date
- SQLite datetime
- SQLite now
- SQLite Aggregate Functions
- SQLite MIN Function
- SQLite MAX Function
- SQLite AVG Function
- SQLite COUNT Function
- SQLite SUM Function
- SQLite Triggers
- SQLite Trigger After Insert
- SQLite Trigger After Update
- SQLite Trigger After Delete
- SQLite Drop Trigger
- SQLite Primary Key
- SQLite Foreign Key
- SQLite Import
- SQLite Export