{"id":19,"date":"2024-01-18T20:15:00","date_gmt":"2024-01-18T20:15:00","guid":{"rendered":"https:\/\/themes.estudiopatagon.com\/wordpress\/zento\/?p=19"},"modified":"2024-01-18T20:15:00","modified_gmt":"2024-01-18T20:15:00","slug":"how-to-insert-data-into-your-table","status":"publish","type":"post","link":"https:\/\/aidailyflow.com\/?p=19","title":{"rendered":"How to insert data into your Table, the correct way"},"content":{"rendered":"\n<p>After your table is already created, you can add multiple kind of information..<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Let&#8217;s start<\/h2>\n\n\n\n<p>You can now start adding data into it with the\u00a0<code><strong>INSERT INTO<\/strong><\/code>\u00a0command:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Inserting a single record:<\/li>\n<\/ol>\n\n\n\n<pre class=\"wp-block-code lang-sql\"><code>INSERT INTO people VALUES (20, 'Tony');<\/code><\/pre>\n\n\n\n<ol class=\"wp-block-list\" start=\"2\">\n<li>Inserting multiple records:<\/li>\n<\/ol>\n\n\n\n<pre class=\"wp-block-code lang-sql\"><code>INSERT INTO people VALUES (57, 'Joe'), (8, 'Ruby');\n<\/code><\/pre>\n\n\n\n<ol class=\"wp-block-list\" start=\"3\">\n<li>Inserting data into specific columns:<\/li>\n<\/ol>\n\n\n\n<pre class=\"wp-block-code lang-sql\"><code>INSERT INTO people (name) VALUES ('Harry');<\/code><\/pre>\n\n\n\n<p>To execute these queries using <strong>TablePlus SQL<\/strong> editor, follow these steps:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Open <strong>TablePlus <\/strong>and connect to your database.<\/li>\n\n\n\n<li>In the <strong>SQL editor<\/strong>, paste one of the provided queries.<\/li>\n\n\n\n<li>Select the query with your mouse.<\/li>\n\n\n\n<li>Click on <strong>&#8220;Run Current&#8221;<\/strong> to execute the query.<\/li>\n<\/ol>\n\n\n\n<p>After executing the queries, you can refresh the database view, click on the &#8220;people&#8221; table, and inspect its content. You&#8217;ll see the inserted data reflecting the changes made.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusion<\/h2>\n\n\n\n<p>These <strong>INSERT INTO<\/strong> commands allow you to populate your database tables with the necessary data, providing a foundation for meaningful interactions and queries. Feel free to experiment with different values and combinations to familiarize yourself with the process of inserting data into a SQL database.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>After your table is already created, you can add multiple kind of information.. Let&#8217;s start You can now start adding data into it with the\u00a0INSERT&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,10],"tags":[],"class_list":["post-19","post","type-post","status-publish","format-standard","hentry","category-5-databases","category-sql"],"menu_order":0,"_links":{"self":[{"href":"https:\/\/aidailyflow.com\/index.php?rest_route=\/wp\/v2\/posts\/19","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/aidailyflow.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/aidailyflow.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/aidailyflow.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/aidailyflow.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=19"}],"version-history":[{"count":0,"href":"https:\/\/aidailyflow.com\/index.php?rest_route=\/wp\/v2\/posts\/19\/revisions"}],"wp:attachment":[{"href":"https:\/\/aidailyflow.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=19"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aidailyflow.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=19"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aidailyflow.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=19"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}