{"id":543,"date":"2022-08-23T20:46:54","date_gmt":"2022-08-23T19:46:54","guid":{"rendered":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/?page_id=543"},"modified":"2022-08-23T20:47:33","modified_gmt":"2022-08-23T19:47:33","slug":"sql-insert-into","status":"publish","type":"page","link":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/sql-insert-into\/","title":{"rendered":"SQL \u2013 Insert Into"},"content":{"rendered":"<header class=\"entry-header\">\n<div class=\"comments-link\"><span style=\"font-size: 1rem\">The INSERT INTO statement is used to add a record to a table<\/span><\/div>\n<div><\/div>\n<\/header>\n<div class=\"entry-content\">\n<p><strong>INSERT INTO\u00a0TableName\u00a0\u00a0(<span style=\"color: #0000ff\">fieldname1<\/span>,\u00a0<span style=\"color: #008000\">fieldname2\u00a0<\/span>,\u00a0<span style=\"color: #ff0000\">fieldname3<\/span>)<\/strong><\/p>\n<p><strong>VALUES\u00a0(<span style=\"color: #0000ff\">value1<\/span>,\u00a0\u00a0 <span style=\"color: #008000\">value2<\/span>,\u00a0\u00a0 <span style=\"color: #ff0000\">value3<\/span>);<\/strong><\/p>\n<p><span data-contrast=\"none\">We specify the table name, then in brackets the fields we wish to insert to (you can add to all or only some).\u00a0<\/span><b><i><span data-contrast=\"none\">Note\u00a0<\/span><\/i><\/b><b><i><span data-contrast=\"none\">\u2013 the values and field names must be in the same order.<\/span><\/i><\/b><\/p>\n<p><span data-contrast=\"none\">Next, we must specify the values to add to the database.<\/span><\/p>\n<p><span data-contrast=\"none\"><strong>For example<\/strong>, to add a new film to the FILMS table:<\/span><\/p>\n<p><a href=\"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23195840\/GetImage-3-1.jpeg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-full wp-image-511\" src=\"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23195840\/GetImage-3-1.jpeg\" alt=\"\" width=\"410\" height=\"190\" srcset=\"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23195840\/GetImage-3-1.jpeg 410w, https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23195840\/GetImage-3-1-300x139.jpeg 300w\" sizes=\"auto, (max-width: 410px) 100vw, 410px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><strong>INSERT INTO\u00a0FILMS(<span style=\"color: #0000ff\">Title<\/span>, <span style=\"color: #008000\" data-contrast=\"none\">Rating<\/span>,\u00a0<span style=\"color: #ff0000\" data-contrast=\"none\">RunningTime<\/span>,<span style=\"color: #ff6600\" data-contrast=\"none\"><span style=\"color: #ff00ff\"> Genre<\/span>, Distributor<\/span>)<\/strong><\/p>\n<p><strong>VALUES\u00a0(\u201c<span style=\"color: #0000ff\">Avengers: End Game<\/span>\u201c, <span style=\"color: #008000\">12<\/span>,<span style=\"color: #ff0000\" data-contrast=\"none\"> 182<\/span>,\u00a0\u201c<span style=\"color: #ff00ff\">Action<\/span>\u201c,\u201c<span style=\"color: #ff6600\">Disney<\/span>\u201d);<\/strong><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>The INSERT INTO statement is used to add a record to a table INSERT INTO\u00a0TableName\u00a0\u00a0(fieldname1,\u00a0fieldname2\u00a0,\u00a0fieldname3) VALUES\u00a0(value1,\u00a0\u00a0 value2,\u00a0\u00a0 value3); We specify the table name, then in brackets the fields we wish to insert to (you can add to all or only some).\u00a0Note\u00a0\u2013 the values and field names must be in the same order. Next, we must [&hellip;]<\/p>\n","protected":false},"author":79984,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-543","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/pages\/543","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/users\/79984"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/comments?post=543"}],"version-history":[{"count":2,"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/pages\/543\/revisions"}],"predecessor-version":[{"id":545,"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/pages\/543\/revisions\/545"}],"wp:attachment":[{"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/media?parent=543"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}