{"id":279,"date":"2015-12-03T11:45:49","date_gmt":"2015-12-03T04:45:49","guid":{"rendered":"http:\/\/www.sqlitetutorial.net\/?page_id=279"},"modified":"2022-04-03T15:03:15","modified_gmt":"2022-04-03T08:03:15","slug":"sqlite-insert","status":"publish","type":"page","link":"https:\/\/www.sqlitetutorial.net\/sqlite-insert\/","title":{"rendered":"SQLite Insert"},"content":{"rendered":"\r\n<p><strong>Summary<\/strong>: in this tutorial, you will learn how to use SQLite <code>INSERT<\/code> statement to insert new rows into a table.<\/p>\r\n\r\n\r\n\r\n<p>To insert data into a table, you use the <code>INSERT<\/code> statement. SQLite provides various forms of the <code>INSERT<\/code> statements that allow you to insert a single row, multiple rows, and default values into a table.<\/p>\r\n\r\n\r\n\r\n<p>In addition, you can insert a row into a table using data provided by a&nbsp; <code><a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-select\/\">SELECT<\/a><\/code> statement.<\/p>\r\n\r\n\r\n\r\n<h2 class=\"wp-block-heading\">SQLite INSERT &#8211; inserting a single row into a table<\/h2>\r\n\r\n\r\n\r\n<p>To insert a single row into a table, you use the following form of the <code>INSERT<\/code> statement:<\/p>\r\n\r\n\r\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-1\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">INSERT<\/span> <span class=\"hljs-keyword\">INTO<\/span> <span class=\"hljs-keyword\">table<\/span> (column1,column2 ,..)\r\n<span class=\"hljs-keyword\">VALUES<\/span>( value1,\tvalue2 ,...);<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-1\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\r\n\r\n\r\n<p>Let&#8217;s examine the <code>INSERT<\/code> statement in more detail:<\/p>\r\n\r\n\r\n\r\n<ul class=\"wp-block-list\"><li>First, specify the name of the table to which you want to insert data after the <code>INSERT INTO<\/code> keywords.<\/li><li>Second, add a comma-separated list of columns after the table name. The column list is optional. However, it is a good practice to include the column list after the table name.<\/li><li>Third, add a comma-separated list of values after the <code>VALUES<\/code> keyword. If you omit the column list, you have to specify values for all columns in the value list. The number of values in the value list must be the same as the number of columns in the column list.<\/li><\/ul>\r\n\r\n\r\n\r\n<p>We will use the <code>artists<\/code> table in the <a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-sample-database\/\">sample database<\/a> for the demonstration.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"174\" height=\"84\" src=\"https:\/\/www.sqlitetutorial.net\/wp-content\/uploads\/2018\/11\/artists.png\" alt=\"\" class=\"wp-image-1560\"\/><\/figure>\r\n\r\n\r\n\r\n<p>The following statement insert a new row into the <code>artists<\/code> table:<\/p>\r\n\r\n\r\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-2\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">INSERT<\/span> <span class=\"hljs-keyword\">INTO<\/span> artists (<span class=\"hljs-keyword\">name<\/span>)\r\n<span class=\"hljs-keyword\">VALUES<\/span>(<span class=\"hljs-string\">'Bud Powell'<\/span>);<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-2\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\r\n\r\n\r\n<p><a class=\"sql\" href=\"https:\/\/www.sqlitetutorial.net\/tryit\/query\/sqlite-insert\/#1\" target=\"_blank\" rel=\"noopener noreferrer\">Try It<\/a><\/p>\r\n\r\n\r\n\r\n<p>Because the <code>ArtistId<\/code> column is an <a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-autoincrement\/\">auto-increment column<\/a>, you can ignore it in the statement. SQLite automatically geneate a sequential integer number to insert into the <code>ArtistId<\/code> column.<\/p>\r\n\r\n\r\n\r\n<p>You can verify the insert operation by using the following <code>SELECT<\/code> statement:<\/p>\r\n\r\n\r\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-3\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">SELECT<\/span>\r\n\tArtistId,\r\n\t<span class=\"hljs-keyword\">Name<\/span>\r\n<span class=\"hljs-keyword\">FROM<\/span>\r\n\tArtists\r\n<span class=\"hljs-keyword\">ORDER<\/span> <span class=\"hljs-keyword\">BY<\/span>\r\n\tArtistId <span class=\"hljs-keyword\">DESC<\/span>\r\n<span class=\"hljs-keyword\">LIMIT<\/span> <span class=\"hljs-number\">1<\/span>;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-3\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\r\n\r\n\r\n<p><a class=\"sql\" href=\"https:\/\/www.sqlitetutorial.net\/tryit\/query\/sqlite-insert\/#2\" target=\"_blank\" rel=\"noopener noreferrer\">Try It<\/a><\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"206\" height=\"42\" src=\"https:\/\/www.sqlitetutorial.net\/wp-content\/uploads\/2015\/12\/SQLite-Insert-Example.jpg\" alt=\"SQLite Insert Example\" class=\"wp-image-294\"\/><\/figure>\r\n\r\n\r\n\r\n<p>As you see, we have a new row in the <code>artists<\/code> table.<\/p>\r\n\r\n\r\n\r\n<h2 class=\"wp-block-heading\">SQLite INSERT &#8211; Inserting multiple rows into a table<\/h2>\r\n\r\n\r\n\r\n<p>To insert multiple rows into a table, you use the following form of the <code>INSERT<\/code> statement:<\/p>\r\n\r\n\r\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-4\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">INSERT<\/span> <span class=\"hljs-keyword\">INTO<\/span> table1 (column1,column2 ,..)\r\n<span class=\"hljs-keyword\">VALUES<\/span> \r\n   (value1,value2 ,...),\r\n   (value1,value2 ,...),\r\n    ...\r\n   (value1,value2 ,...);\r\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-4\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\r\n\r\n\r\n<p>Each value list following the <code>VALUES<\/code> clause is a row that will be inserted into the table.<\/p>\r\n\r\n\r\n\r\n<p>The following example inserts three rows into the <code>artists<\/code> table:<\/p>\r\n\r\n\r\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-5\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">INSERT<\/span> <span class=\"hljs-keyword\">INTO<\/span> artists (<span class=\"hljs-keyword\">name<\/span>)\r\n<span class=\"hljs-keyword\">VALUES<\/span>\r\n\t(<span class=\"hljs-string\">\"Buddy Rich\"<\/span>),\r\n\t(<span class=\"hljs-string\">\"Candido\"<\/span>),\r\n\t(<span class=\"hljs-string\">\"Charlie Byrd\"<\/span>);<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-5\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\r\n\r\n\r\n<p><a class=\"sql\" href=\"https:\/\/www.sqlitetutorial.net\/tryit\/query\/sqlite-insert\/#3\" target=\"_blank\" rel=\"noopener noreferrer\">Try It<\/a><\/p>\r\n\r\n\r\n\r\n<p>SQLite issued a message:<\/p>\r\n\r\n\r\n<pre class=\"wp-block-code\"><span><code class=\"hljs\">Row Affected: 3<\/code><\/span><\/pre>\r\n\r\n\r\n<p>You can verify the result using the following statement:<\/p>\r\n\r\n\r\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-6\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">SELECT<\/span>\r\n\tArtistId,\r\n\t<span class=\"hljs-keyword\">Name<\/span>\r\n<span class=\"hljs-keyword\">FROM<\/span>\r\n\tartists\r\n<span class=\"hljs-keyword\">ORDER<\/span> <span class=\"hljs-keyword\">BY<\/span>\r\n\tArtistId <span class=\"hljs-keyword\">DESC<\/span>\r\n<span class=\"hljs-keyword\">LIMIT<\/span> <span class=\"hljs-number\">3<\/span>;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-6\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\r\n\r\n\r\n<p><a class=\"sql\" href=\"https:\/\/www.sqlitetutorial.net\/tryit\/query\/sqlite-insert\/#4\" target=\"_blank\" rel=\"noopener noreferrer\">Try It<\/a><\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"206\" height=\"83\" src=\"https:\/\/www.sqlitetutorial.net\/wp-content\/uploads\/2015\/12\/SQLite-Insert-Multiple-Example.jpg\" alt=\"SQLite Insert Multiple Example\" class=\"wp-image-295\"\/><\/figure>\r\n\r\n\r\n\r\n<h2 class=\"wp-block-heading\">SQLite INSERT &#8211; Inserting default values<\/h2>\r\n\r\n\r\n\r\n<p>When you create a new table using the <code><a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-create-table\/\">CREATE TABLE<\/a><\/code> statement, you can specify default values for columns, or a <code>NULL<\/code> if a default value is not specified.<\/p>\r\n\r\n\r\n\r\n<p>The third form of the <code>INSERT<\/code> statement is <code>INSERT DEFAULT VALUES<\/code>, which inserts a new row into a table using the default values specified in the column definition or <code>NULL<\/code> if the default value is not available and the column does not have a <code><a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-not-null-constraint\/\">NOT NULL<\/a><\/code> constraint.<\/p>\r\n\r\n\r\n\r\n<p>For example, the following statement inserts a new row into the <code>artists<\/code> table using <code>INSERT DEFAULT VALUES<\/code>:<\/p>\r\n\r\n\r\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-7\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">INSERT<\/span> <span class=\"hljs-keyword\">INTO<\/span> artists <span class=\"hljs-keyword\">DEFAULT<\/span> <span class=\"hljs-keyword\">VALUES<\/span>;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-7\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\r\n\r\n\r\n<p><a class=\"sql\" href=\"https:\/\/www.sqlitetutorial.net\/tryit\/query\/sqlite-insert\/#5\" target=\"_blank\" rel=\"noopener noreferrer\">Try It<\/a><\/p>\r\n\r\n\r\n\r\n<p>To verify the insert, you use the following statement:<\/p>\r\n\r\n\r\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-8\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">SELECT<\/span>\r\n\tArtistId,\r\n\t<span class=\"hljs-keyword\">Name<\/span>\r\n<span class=\"hljs-keyword\">FROM<\/span>\r\n\tartists\r\n<span class=\"hljs-keyword\">ORDER<\/span> <span class=\"hljs-keyword\">BY<\/span>\r\n\tArtistId <span class=\"hljs-keyword\">DESC<\/span>;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-8\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\r\n\r\n\r\n<p><a class=\"sql\" href=\"https:\/\/www.sqlitetutorial.net\/tryit\/query\/sqlite-insert\/#6\" target=\"_blank\" rel=\"noopener noreferrer\">Try It<\/a><\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"207\" height=\"141\" src=\"https:\/\/www.sqlitetutorial.net\/wp-content\/uploads\/2015\/12\/SQLite-Insert-default-values.jpg\" alt=\"SQLite Insert default values\" class=\"wp-image-296\"\/><\/figure>\r\n\r\n\r\n\r\n<p>The default value of the <code>ArtistId<\/code> column is the next sequential integer . However, the <code>name<\/code> column does not have any default value, therefore, the <code>INSERT DEFAULT VALUES<\/code> statement inserts <code>NULL<\/code>&nbsp; into it.<\/p>\r\n\r\n\r\n\r\n<h2 class=\"wp-block-heading\">SQLite INSERT &#8211; Inserting new rows with data provided by a SELECT statement<\/h2>\r\n\r\n\r\n\r\n<p>Suppose you want to backup the <code>artists<\/code> table, you can follow these steps:<\/p>\r\n\r\n\r\n\r\n<p>First, create a new table named <code>artists_backup<\/code> as follows:<\/p>\r\n\r\n\r\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-9\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">CREATE<\/span> <span class=\"hljs-keyword\">TABLE<\/span> artists_backup(\r\n   ArtistId <span class=\"hljs-built_in\">INTEGER<\/span> PRIMARY <span class=\"hljs-keyword\">KEY<\/span> AUTOINCREMENT,\r\n   <span class=\"hljs-keyword\">Name<\/span> <span class=\"hljs-keyword\">NVARCHAR<\/span>\r\n);<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-9\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\r\n\r\n\r\n<p><a class=\"sql\" href=\"https:\/\/www.sqlitetutorial.net\/tryit\/query\/sqlite-insert\/#7\" target=\"_blank\" rel=\"noopener noreferrer\">Try It<\/a><\/p>\r\n\r\n\r\n\r\n<p>To insert data into the <code>artists_backup<\/code> table with the data from the <code>artists<\/code> table, you use the <code>INSERT INTO SELECT<\/code> statement as follows:<\/p>\r\n\r\n\r\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-10\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">INSERT<\/span> <span class=\"hljs-keyword\">INTO<\/span> artists_backup \r\n<span class=\"hljs-keyword\">SELECT<\/span> ArtistId, <span class=\"hljs-keyword\">Name<\/span>\r\n<span class=\"hljs-keyword\">FROM<\/span> artists;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-10\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\r\n\r\n\r\n<p><a class=\"sql\" href=\"https:\/\/www.sqlitetutorial.net\/tryit\/query\/sqlite-insert\/#8\" target=\"_blank\" rel=\"noopener noreferrer\">Try It<\/a><\/p>\r\n\r\n\r\n\r\n<p>If you query data from the <code>artists_backup<\/code> table, you will see all data in the <code>artists<\/code> table.<\/p>\r\n\r\n\r\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-11\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">SELECT<\/span> * <span class=\"hljs-keyword\">FROM<\/span> artists_backup;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-11\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\r\n\r\n\r\n<p><a class=\"sql\" href=\"https:\/\/www.sqlitetutorial.net\/tryit\/query\/sqlite-insert\/#9\" target=\"_blank\" rel=\"noopener noreferrer\">Try It<\/a><\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"209\" height=\"181\" src=\"https:\/\/www.sqlitetutorial.net\/wp-content\/uploads\/2015\/12\/SQLite-Insert-Into-Select.jpg\" alt=\"SQLite Insert Into Select\" class=\"wp-image-297\"\/><\/figure>\r\n\r\n\r\n\r\n<p>In this tutorial, you have learned how to use various forms of SQLite <code>INSERT<\/code> statement that insert new rows into a table.<\/p>\r\n\r\n\r\n\r\n<h2 class=\"wp-block-heading\">References<\/h2>\r\n\r\n\r\n\r\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/www.sqlite.org\/lang_insert.html\">https:\/\/www.sqlite.org\/lang_insert.html<\/a> &#8211; SQLite INSERT statement<\/li><\/ul>\r\n<div class=\"helpful-block-content\" data-title=\"\">\n\t<header>\n\t\t<div class=\"wth-question\">Was this tutorial helpful ?<\/div>\n\t\t<div class=\"wth-thumbs\">\n\t\t\t<button\n\t\t\t\tdata-post=\"279\"\n\t\t\t\tdata-post-url=\"https:\/\/www.sqlitetutorial.net\/sqlite-insert\/\"\n\t\t\t\tdata-post-title=\"SQLite Insert\"\n\t\t\t\tdata-response=\"1\"\n\t\t\t\tclass=\"wth-btn-rounded wth-yes-btn\"\n\t\t\t>\n\t\t\t\t<svg\n\t\t\t\t\txmlns=\"http:\/\/www.w3.org\/2000\/svg\"\n\t\t\t\t\tviewBox=\"0 0 24 24\"\n\t\t\t\t\tfill=\"none\"\n\t\t\t\t\tstroke=\"currentColor\"\n\t\t\t\t\tstroke-width=\"2\"\n\t\t\t\t\tstroke-linecap=\"round\"\n\t\t\t\t\tstroke-linejoin=\"round\"\n\t\t\t\t\tclass=\"feather feather-thumbs-up block w-full h-full\"\n\t\t\t\t>\n\t\t\t\t\t<path\n\t\t\t\t\t\td=\"M14 9V5a3 3 0 0 0-3-3l-4 9v11h11.28a2 2 0 0 0 2-1.7l1.38-9a2 2 0 0 0-2-2.3zM7 22H4a2 2 0 0 1-2-2v-7a2 2 0 0 1 2-2h3\"\n\t\t\t\t\t><\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t<span class=\"sr-only\"> Yes <\/span>\n\t\t\t<\/button>\n\n\t\t\t<button\n\t\t\t\tdata-response=\"0\"\n\t\t\t\tdata-post=\"279\"\n\t\t\t\tdata-post-url=\"https:\/\/www.sqlitetutorial.net\/sqlite-insert\/\"\n\t\t\t\tdata-post-title=\"SQLite Insert\"\n\t\t\t\tclass=\"wth-btn-rounded wth-no-btn\"\n\t\t\t>\n\t\t\t\t<svg\n\t\t\t\t\txmlns=\"http:\/\/www.w3.org\/2000\/svg\"\n\t\t\t\t\tviewBox=\"0 0 24 24\"\n\t\t\t\t\tfill=\"none\"\n\t\t\t\t\tstroke=\"currentColor\"\n\t\t\t\t\tstroke-width=\"2\"\n\t\t\t\t\tstroke-linecap=\"round\"\n\t\t\t\t\tstroke-linejoin=\"round\"\n\t\t\t\t>\n\t\t\t\t\t<path\n\t\t\t\t\t\td=\"M10 15v4a3 3 0 0 0 3 3l4-9V2H5.72a2 2 0 0 0-2 1.7l-1.38 9a2 2 0 0 0 2 2.3zm7-13h2.67A2.31 2.31 0 0 1 22 4v7a2.31 2.31 0 0 1-2.33 2H17\"\n\t\t\t\t\t><\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t<span class=\"sr-only\"> No <\/span>\n\t\t\t<\/button>\n\t\t<\/div>\n\t<\/header>\n\n\t<div class=\"wth-form hidden\">\n\t\t<div class=\"wth-form-wrapper\">\n\t\t\t<div class=\"wth-title\"><\/div>\n\t\t\t\n\t\t\t<textarea class=\"wth-message\"><\/textarea>\n\n\t\t\t<button class=\"btn btn-primary wth-btn-submit\">Send<\/button>\n\t\t\t<button class=\"btn wth-btn-cancel\">Cancel<\/button>\n\t\t\n\t\t<\/div>\n\t<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Summary: in this tutorial, you will learn how to use SQLite INSERT statement to insert new rows into a table. To insert data into a table, you use the INSERT statement. SQLite provides various forms of the INSERT statements that allow you to insert a single row, multiple rows, and default values into a table. [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":2,"menu_order":29,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-279","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQLite Insert Into - Inserting New Rows Into a Table<\/title>\n<meta name=\"description\" content=\"This tutorial shows you how to use SQLite INSERT statement to insert new rows into a table. You will learn various forms of the INSERT INTO statement.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.sqlitetutorial.net\/sqlite-insert\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQLite Insert Into - Inserting New Rows Into a Table\" \/>\n<meta property=\"og:description\" content=\"This tutorial shows you how to use SQLite INSERT statement to insert new rows into a table. You will learn various forms of the INSERT INTO statement.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlitetutorial.net\/sqlite-insert\/\" \/>\n<meta property=\"og:site_name\" content=\"SQLite Tutorial\" \/>\n<meta property=\"article:modified_time\" content=\"2022-04-03T08:03:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.sqlitetutorial.net\/wp-content\/uploads\/2018\/11\/artists.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.sqlitetutorial.net\/sqlite-insert\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlitetutorial.net\/sqlite-insert\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\/\/www.sqlitetutorial.net\/#\/schema\/person\/6d69b968cad0102e30d6694ed8dc6427\"},\"headline\":\"SQLite Insert\",\"datePublished\":\"2015-12-03T04:45:49+00:00\",\"dateModified\":\"2022-04-03T08:03:15+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.sqlitetutorial.net\/sqlite-insert\/\"},\"wordCount\":566,\"image\":{\"@id\":\"https:\/\/www.sqlitetutorial.net\/sqlite-insert\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.sqlitetutorial.net\/wp-content\/uploads\/2018\/11\/artists.png\",\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sqlitetutorial.net\/sqlite-insert\/\",\"url\":\"https:\/\/www.sqlitetutorial.net\/sqlite-insert\/\",\"name\":\"SQLite Insert Into - Inserting New Rows Into a Table\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlitetutorial.net\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.sqlitetutorial.net\/sqlite-insert\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.sqlitetutorial.net\/sqlite-insert\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.sqlitetutorial.net\/wp-content\/uploads\/2018\/11\/artists.png\",\"datePublished\":\"2015-12-03T04:45:49+00:00\",\"dateModified\":\"2022-04-03T08:03:15+00:00\",\"description\":\"This tutorial shows you how to use SQLite INSERT statement to insert new rows into a table. You will learn various forms of the INSERT INTO statement.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlitetutorial.net\/sqlite-insert\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlitetutorial.net\/sqlite-insert\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlitetutorial.net\/sqlite-insert\/#primaryimage\",\"url\":\"https:\/\/www.sqlitetutorial.net\/wp-content\/uploads\/2018\/11\/artists.png\",\"contentUrl\":\"https:\/\/www.sqlitetutorial.net\/wp-content\/uploads\/2018\/11\/artists.png\",\"width\":174,\"height\":84},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlitetutorial.net\/sqlite-insert\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlitetutorial.net\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQLite Insert\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sqlitetutorial.net\/#website\",\"url\":\"https:\/\/www.sqlitetutorial.net\/\",\"name\":\"SQLite Tutorial\",\"description\":\"A Step-by-step SQLite Tutorial\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sqlitetutorial.net\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.sqlitetutorial.net\/#\/schema\/person\/6d69b968cad0102e30d6694ed8dc6427\",\"name\":\"admin\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQLite Insert Into - Inserting New Rows Into a Table","description":"This tutorial shows you how to use SQLite INSERT statement to insert new rows into a table. You will learn various forms of the INSERT INTO statement.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.sqlitetutorial.net\/sqlite-insert\/","og_locale":"en_US","og_type":"article","og_title":"SQLite Insert Into - Inserting New Rows Into a Table","og_description":"This tutorial shows you how to use SQLite INSERT statement to insert new rows into a table. You will learn various forms of the INSERT INTO statement.","og_url":"https:\/\/www.sqlitetutorial.net\/sqlite-insert\/","og_site_name":"SQLite Tutorial","article_modified_time":"2022-04-03T08:03:15+00:00","og_image":[{"url":"https:\/\/www.sqlitetutorial.net\/wp-content\/uploads\/2018\/11\/artists.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.sqlitetutorial.net\/sqlite-insert\/#article","isPartOf":{"@id":"https:\/\/www.sqlitetutorial.net\/sqlite-insert\/"},"author":{"name":"admin","@id":"https:\/\/www.sqlitetutorial.net\/#\/schema\/person\/6d69b968cad0102e30d6694ed8dc6427"},"headline":"SQLite Insert","datePublished":"2015-12-03T04:45:49+00:00","dateModified":"2022-04-03T08:03:15+00:00","mainEntityOfPage":{"@id":"https:\/\/www.sqlitetutorial.net\/sqlite-insert\/"},"wordCount":566,"image":{"@id":"https:\/\/www.sqlitetutorial.net\/sqlite-insert\/#primaryimage"},"thumbnailUrl":"https:\/\/www.sqlitetutorial.net\/wp-content\/uploads\/2018\/11\/artists.png","inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.sqlitetutorial.net\/sqlite-insert\/","url":"https:\/\/www.sqlitetutorial.net\/sqlite-insert\/","name":"SQLite Insert Into - Inserting New Rows Into a Table","isPartOf":{"@id":"https:\/\/www.sqlitetutorial.net\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.sqlitetutorial.net\/sqlite-insert\/#primaryimage"},"image":{"@id":"https:\/\/www.sqlitetutorial.net\/sqlite-insert\/#primaryimage"},"thumbnailUrl":"https:\/\/www.sqlitetutorial.net\/wp-content\/uploads\/2018\/11\/artists.png","datePublished":"2015-12-03T04:45:49+00:00","dateModified":"2022-04-03T08:03:15+00:00","description":"This tutorial shows you how to use SQLite INSERT statement to insert new rows into a table. You will learn various forms of the INSERT INTO statement.","breadcrumb":{"@id":"https:\/\/www.sqlitetutorial.net\/sqlite-insert\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlitetutorial.net\/sqlite-insert\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlitetutorial.net\/sqlite-insert\/#primaryimage","url":"https:\/\/www.sqlitetutorial.net\/wp-content\/uploads\/2018\/11\/artists.png","contentUrl":"https:\/\/www.sqlitetutorial.net\/wp-content\/uploads\/2018\/11\/artists.png","width":174,"height":84},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlitetutorial.net\/sqlite-insert\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlitetutorial.net\/"},{"@type":"ListItem","position":2,"name":"SQLite Insert"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlitetutorial.net\/#website","url":"https:\/\/www.sqlitetutorial.net\/","name":"SQLite Tutorial","description":"A Step-by-step SQLite Tutorial","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlitetutorial.net\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.sqlitetutorial.net\/#\/schema\/person\/6d69b968cad0102e30d6694ed8dc6427","name":"admin"}]}},"_links":{"self":[{"href":"https:\/\/www.sqlitetutorial.net\/wp-json\/wp\/v2\/pages\/279","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlitetutorial.net\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.sqlitetutorial.net\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlitetutorial.net\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlitetutorial.net\/wp-json\/wp\/v2\/comments?post=279"}],"version-history":[{"count":1,"href":"https:\/\/www.sqlitetutorial.net\/wp-json\/wp\/v2\/pages\/279\/revisions"}],"predecessor-version":[{"id":2788,"href":"https:\/\/www.sqlitetutorial.net\/wp-json\/wp\/v2\/pages\/279\/revisions\/2788"}],"up":[{"embeddable":true,"href":"https:\/\/www.sqlitetutorial.net\/wp-json\/wp\/v2\/pages\/2"}],"wp:attachment":[{"href":"https:\/\/www.sqlitetutorial.net\/wp-json\/wp\/v2\/media?parent=279"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}