{"id":140,"date":"2022-02-11T12:36:59","date_gmt":"2022-02-11T12:36:59","guid":{"rendered":"https:\/\/openquery.com\/?p=140"},"modified":"2022-02-28T13:57:42","modified_gmt":"2022-02-28T13:57:42","slug":"how-to-create-a-table-in-sql-2","status":"publish","type":"post","link":"https:\/\/openquery.com\/how-to-create-a-table-in-sql-2\/","title":{"rendered":"How To Create A Table In SQL"},"content":{"rendered":"\n<p>SQL may be primarily used to find action data requests, but another major benefit it brings to the table is, well\u2026 tables.<\/p>\n\n\n\n<p>Yep, you can use SQL to create and alter tables in your database easily and efficiently, so no matter how much data you\u2019re dealing with, keeping on top of it all is an absolute doddle.<\/p>\n\n\n\n<p>Today, we\u2019re going to be running through a beginner-friendly, step-by-step SQL table making tutorial. Stick with me, and you\u2019ll have it mastered in no time at all!<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"683\" src=\"https:\/\/openquery.com\/wp-content\/uploads\/2022\/02\/How-To-Create-Table-In-SQL-1024x683.png\" alt=\"How To Create Table In SQL\" class=\"wp-image-141\" srcset=\"https:\/\/openquery.com\/wp-content\/uploads\/2022\/02\/How-To-Create-Table-In-SQL-1024x683.png 1024w, https:\/\/openquery.com\/wp-content\/uploads\/2022\/02\/How-To-Create-Table-In-SQL-300x200.png 300w, https:\/\/openquery.com\/wp-content\/uploads\/2022\/02\/How-To-Create-Table-In-SQL-768x512.png 768w, https:\/\/openquery.com\/wp-content\/uploads\/2022\/02\/How-To-Create-Table-In-SQL.png 1200w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"ddl-is-the-key\"><strong>DDL Is The Key<\/strong><\/h2>\n\n\n\n<p>To <a href=\"https:\/\/openquery.com\/how-to-create-a-table-in-sql\/\" target=\"_blank\" rel=\"noopener\">create a table in an SQL<\/a> server, you\u2019ll actually be using DDL (Data Definition Language), a subset of SQL, rather than SQL itself.<\/p>\n\n\n\n<p>Don\u2019t let that spook you, though, as DDL uses the exact same syntactic principles as SQL, so if you know your way around a database query, creating a table using DDL should come naturally.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"ddl-keywords-and-syntax-creating-a-table\"><strong>DDL Keywords And Syntax: Creating A Table<\/strong><\/h2>\n\n\n\n<p>Rather fittingly, the DDL keyword for creating database objects is \u201cCreate\u201d, so that will always be your very first word in the statement. To create a certain object, you simply have to specify which, directly after Create in the syntax chain, i.e. <strong>Create<\/strong> Table.<\/p>\n\n\n\n<p>Next up, you have to supply an identifier, or, in other words, a name for your new table, and this name goes right next to \u201cTable\u201d in the syntax. For the sake of example, let\u2019s say that you want to name your table <em>tbl_Clientele.<\/em> That would leave the statement looking a little something like this\u2026&nbsp;<\/p>\n\n\n\n<p><strong>Create<\/strong> Table tbl_Clientele<\/p>\n\n\n\n<p>Now you can add your column titles, but beforehand, insert some brackets like so:<\/p>\n\n\n\n<p><strong>Create<\/strong> Table tbl_Clientele<\/p>\n\n\n\n<p>(<\/p>\n\n\n\n<p>)<\/p>\n\n\n\n<p>In the space between your brackets, you\u2019ll detail your first column. Let\u2019s say we want it to list the first names of your clientele; we\u2019ll type that out within hard brackets which, for the uninitiated, are these guys here: [ ]<\/p>\n\n\n\n<p>So, now our statement looks like this\u2026<\/p>\n\n\n\n<p><strong>Create<\/strong> Table tbl_Clientele<\/p>\n\n\n\n<p>(<\/p>\n\n\n\n<p>[first name]<\/p>\n\n\n\n<p>)<\/p>\n\n\n\n<p>Now\u2019s the time to add a string and character limit to our first column. A string is essential just a data type, and you\u2019ve got two to choose from here:<\/p>\n\n\n\n<ul><li>Char<\/li><li>Varchar<\/li><\/ul>\n\n\n\n<p>\u201cChar\u201d means character, and should be used if all the data values in the column will be equal in length. Char is commonly employed for numerical columns. Varchar, on the other hand, stands for variable characters, meaning it\u2019s used for columns that will have irregular data values.<\/p>\n\n\n\n<p>As our example column will be listing names of differing lengths, we have to use Varchar as our string, and all that\u2019s left to do then is to give a character limit as a number in brackets, followed by a comma. <\/p>\n\n\n\n<p>It\u2019s unlikely that anybody&#8217;s first name will be longer than 20 characters, so let\u2019s pick that for our character limit. Now our syntax should resemble\u2026<\/p>\n\n\n\n<p><strong>Create<\/strong> Table tbl_Clientele<\/p>\n\n\n\n<p>(<\/p>\n\n\n\n<p>[first name] Varchar (20) ,<\/p>\n\n\n\n<p>)<\/p>\n\n\n\n<p>Now you can rinse and repeat the same method for your remaining columns. For instance, if we added middle name, last name, phone number, city, and age columns, we\u2019d end up with\u2026<\/p>\n\n\n\n<p><strong>Create<\/strong> Table tbl_Clientele<\/p>\n\n\n\n<p>(<\/p>\n\n\n\n<p>[first name] Varchar (20) ,<\/p>\n\n\n\n<p>[middle name] Varchar (20) ,<\/p>\n\n\n\n<p>[last name] Varchar (20) ,<\/p>\n\n\n\n<p>[phone number] Char (11) ,<\/p>\n\n\n\n<p>[city] Varchar (20) ,<\/p>\n\n\n\n<p>[age] INT<\/p>\n\n\n\n<p>)<\/p>\n\n\n\n<p>Don\u2019t be alarmed by the \u201cINT\u201d section in our age column. That stands for integer, and all that means is that the data values in that column must be whole numbers.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"adding-values-to-your-table\"><strong>Adding Values To Your Table<\/strong><\/h2>\n\n\n\n<p>With our columns established, next on the agenda is to fill them up with values. To kick this process off, you simply need to add the keyword \u201cInsert\u201d beneath your closing brackets. Then you have to explain to your database where you want the values to go, which is, of course, our new table, <em>tbl_Clientele<\/em>, so you would type\u2026<\/p>\n\n\n\n<p><strong>Insert<\/strong> INTO tbl_Clientele<\/p>\n\n\n\n<p>But this isn\u2019t enough information. In brackets, you also need to explain which columns you wish to add values to:<\/p>\n\n\n\n<p><strong>Insert<\/strong> INTO tbl_Clientele (first name, middle name, last name, phone number, city, age)<\/p>\n\n\n\n<p>With the value locations set, we can enter our values, first by typing the keyword \u201cValues\u201d, followed by the data in brackets. Each value should be separated by a comma, and they\u2019ll be assigned in sequence to the columns labeled in the above example. It should look like this\u2026<\/p>\n\n\n\n<p><strong>Insert<\/strong> INTO tbl_Clientele (first name, middle name, last name, phone number, city, age)<\/p>\n\n\n\n<p><strong>Values<\/strong> (Joseph, Jedediah, Bloggs, XXXXXXXXXXX, Austin, 38)<\/p>\n\n\n\n<p>That\u2019s the first row of data entered \u2014 Woo! But how do we go about adding our second, third, fourth, and so on? Well, it\u2019s easy, you just put a comma after your first bracketed row, and type in another, for example\u2026<\/p>\n\n\n\n<p><strong>Insert<\/strong> INTO tbl_Clientele (first name, middle name, last name, phone number, city, age)<\/p>\n\n\n\n<p><strong>Values<\/strong>&nbsp;<\/p>\n\n\n\n<p>(Joseph, Jedediah, Bloggs, XXXXXXXXXXX, Austin, 38) ,<\/p>\n\n\n\n<p>(John, Jeremy, Doe, XXXXXXXXXXX, Dallas, 29)<\/p>\n\n\n\n<p>And you can keep on doing that, ad infinitum. So, our full syntax should now look like\u2026<\/p>\n\n\n\n<p><strong>Create<\/strong> Table tbl_Clientele<\/p>\n\n\n\n<p>(<\/p>\n\n\n\n<p>[first name] Varchar (20) ,<\/p>\n\n\n\n<p>[middle name] Varchar (20) ,<\/p>\n\n\n\n<p>[last name] Varchar (20) ,<\/p>\n\n\n\n<p>[phone number] Char (11) ,<\/p>\n\n\n\n<p>[city] Varchar (20) ,<\/p>\n\n\n\n<p>[age] INT<\/p>\n\n\n\n<p>)<\/p>\n\n\n\n<p><strong>Insert<\/strong> INTO tbl_Clientele (first name, middle name, last name, phone number, city, age)<\/p>\n\n\n\n<p><strong>Values<\/strong>&nbsp;<\/p>\n\n\n\n<p>(Joseph, Jedediah, Bloggs, XXXXXXXXXXX, Austin, 38) ,<\/p>\n\n\n\n<p>(John, Jeremy, Doe, XXXXXXXXXXX, Dallas, 29)<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"id-columns\"><strong>ID Columns<\/strong><\/h2>\n\n\n\n<p>If you\u2019re worried about identical information in a simple table, an ID column will help you differentiate between the two interchangeable entries.&nbsp;<\/p>\n\n\n\n<p>The ID column should always be first and look a little something like this\u2026<\/p>\n\n\n\n<p>[Id] INT IDENTITY (1, 1)<\/p>\n\n\n\n<p>First, you have the column name (Id) set as an integer, which, if you remember, means the value has to be a whole number. Then, instead of Char or Varchar, we have \u201cIDENTITY\u201d, which is a data type that will automatically increase in value with each row.<\/p>\n\n\n\n<p>The first number in brackets next to IDENTITY establishes the value the column will start at, which in our example, is 1, and the second number in the brackets determines the increment of value increase, which, again, for us, is 1.<\/p>\n\n\n\n<p>All that\u2019s left to do is to attach \u201cPRIMARY KEY\u201d after the bracketed numbers, which will ensure there can only ever be single values in our identity column.<\/p>\n\n\n\n<p>So, our final table including an ID column would look like this\u2026<\/p>\n\n\n\n<p><strong>Create<\/strong> Table tbl_Clientele<\/p>\n\n\n\n<p>(<\/p>\n\n\n\n<p>[Id] INT IDENTITY (1, 1) PRIMARY KEY ,<\/p>\n\n\n\n<p>[first name] Varchar (20) ,<\/p>\n\n\n\n<p>[middle name] Varchar (20) ,<\/p>\n\n\n\n<p>[last name] Varchar (20) ,<\/p>\n\n\n\n<p>[phone number] Char (11) ,<\/p>\n\n\n\n<p>[city] Varchar (20) ,<\/p>\n\n\n\n<p>[age] INT<\/p>\n\n\n\n<p>)<\/p>\n\n\n\n<p><strong>Insert<\/strong> INTO tbl_Clientele (first name, middle name, last name, phone number, city, age)<\/p>\n\n\n\n<p><strong>Values<\/strong>&nbsp;<\/p>\n\n\n\n<p>(Joseph, Jedediah, Bloggs, XXXXXXXXXXX, Austin, 38) ,<\/p>\n\n\n\n<p>(John, Jeremy, Doe, XXXXXXXXXXX, Dallas, 29)<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"final-thoughts\"><strong>Final Thoughts<\/strong><\/h2>\n\n\n\n<p>And there you have it \u2014 you can now create your own detailed tables in a database using SQL\/DDL languages. Once you\u2019ve got the syntax memorized, it\u2019s a total breeze!<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<div class=\"container-lazyload preview-lazyload container-youtube js-lazyload--not-loaded\"><a href=\"https:\/\/www.youtube.com\/watch?v=SPPTQwx4FfE\" class=\"lazy-load-youtube preview-lazyload preview-youtube\" data-video-title=\"Creating Tables - SQL - Tutorial 6\" title=\"Play video &quot;Creating Tables - SQL - Tutorial 6&quot;\">https:\/\/www.youtube.com\/watch?v=SPPTQwx4FfE<\/a><noscript>Video can&#8217;t be loaded because JavaScript is disabled: <a href=\"https:\/\/www.youtube.com\/watch?v=SPPTQwx4FfE\" title=\"Creating Tables - SQL - Tutorial 6\">Creating Tables &#8211; SQL &#8211; Tutorial 6 (https:\/\/www.youtube.com\/watch?v=SPPTQwx4FfE)<\/a><\/noscript><\/div>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>SQL may be primarily used to find action data requests, but another major benefit it brings to the table is, well\u2026 tables. Yep, you can use SQL to create and alter tables in your database easily and efficiently, so no matter how much data you\u2019re dealing with, keeping on top of it all is an &#8230; <a title=\"How To Create A Table In SQL\" class=\"read-more\" href=\"https:\/\/openquery.com\/how-to-create-a-table-in-sql-2\/\" aria-label=\"More on How To Create A Table In SQL\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":141,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[7],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.11 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How To Create A Table In SQL - Open Query<\/title>\n<meta name=\"description\" content=\"Learn how to create a table in SQL with our simple, step-by-step tutorial.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/openquery.com\/how-to-create-a-table-in-sql-2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Create A Table In SQL - Open Query\" \/>\n<meta property=\"og:description\" content=\"Learn how to create a table in SQL with our simple, step-by-step tutorial.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/openquery.com\/how-to-create-a-table-in-sql-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Open Query\" \/>\n<meta property=\"article:published_time\" content=\"2022-02-11T12:36:59+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-02-28T13:57:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/openquery.com\/wp-content\/uploads\/2022\/02\/How-To-Create-Table-In-SQL.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"800\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Albert Niall\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Albert Niall\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/openquery.com\/how-to-create-a-table-in-sql-2\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/openquery.com\/how-to-create-a-table-in-sql-2\/\"},\"author\":{\"name\":\"Albert Niall\",\"@id\":\"https:\/\/openquery.com\/#\/schema\/person\/95a786c4eec250fba9d6c71974a39656\"},\"headline\":\"How To Create A Table In SQL\",\"datePublished\":\"2022-02-11T12:36:59+00:00\",\"dateModified\":\"2022-02-28T13:57:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/openquery.com\/how-to-create-a-table-in-sql-2\/\"},\"wordCount\":1156,\"publisher\":{\"@id\":\"https:\/\/openquery.com\/#organization\"},\"articleSection\":[\"Guides\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/openquery.com\/how-to-create-a-table-in-sql-2\/\",\"url\":\"https:\/\/openquery.com\/how-to-create-a-table-in-sql-2\/\",\"name\":\"How To Create A Table In SQL - Open Query\",\"isPartOf\":{\"@id\":\"https:\/\/openquery.com\/#website\"},\"datePublished\":\"2022-02-11T12:36:59+00:00\",\"dateModified\":\"2022-02-28T13:57:42+00:00\",\"description\":\"Learn how to create a table in SQL with our simple, step-by-step tutorial.\",\"breadcrumb\":{\"@id\":\"https:\/\/openquery.com\/how-to-create-a-table-in-sql-2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/openquery.com\/how-to-create-a-table-in-sql-2\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/openquery.com\/how-to-create-a-table-in-sql-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/openquery.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Create A Table In SQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/openquery.com\/#website\",\"url\":\"https:\/\/openquery.com\/\",\"name\":\"Open Query\",\"description\":\"Everything about IT\",\"publisher\":{\"@id\":\"https:\/\/openquery.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/openquery.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/openquery.com\/#organization\",\"name\":\"Open Query\",\"url\":\"https:\/\/openquery.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/openquery.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/openquery.com\/wp-content\/uploads\/2022\/02\/cropped-openquerylogo.png\",\"contentUrl\":\"https:\/\/openquery.com\/wp-content\/uploads\/2022\/02\/cropped-openquerylogo.png\",\"width\":1016,\"height\":323,\"caption\":\"Open Query\"},\"image\":{\"@id\":\"https:\/\/openquery.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/openquery.com\/#\/schema\/person\/95a786c4eec250fba9d6c71974a39656\",\"name\":\"Albert Niall\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/openquery.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/4728d76122b10a705d1e313fb3a924de?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/4728d76122b10a705d1e313fb3a924de?s=96&d=mm&r=g\",\"caption\":\"Albert Niall\"},\"description\":\"Hi, I\u2019m Albert Niall, and I want people to make the most out of their online presence and use it to their advantage. Here at Open Query I want to make it as easy as possible for you to learn about topics that might not be easily accessible elsewhere online. I don\u2019t know about you, but I haven\u2019t seen many other websites talking about the MariaDB Foundation and its updates. That\u2019s what makes Open Query truly unique. While others might assume everyone knows this information already automatically, I am filling my online resource to help.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Create A Table In SQL - Open Query","description":"Learn how to create a table in SQL with our simple, step-by-step tutorial.","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:\/\/openquery.com\/how-to-create-a-table-in-sql-2\/","og_locale":"en_US","og_type":"article","og_title":"How To Create A Table In SQL - Open Query","og_description":"Learn how to create a table in SQL with our simple, step-by-step tutorial.","og_url":"https:\/\/openquery.com\/how-to-create-a-table-in-sql-2\/","og_site_name":"Open Query","article_published_time":"2022-02-11T12:36:59+00:00","article_modified_time":"2022-02-28T13:57:42+00:00","og_image":[{"width":1200,"height":800,"url":"https:\/\/openquery.com\/wp-content\/uploads\/2022\/02\/How-To-Create-Table-In-SQL.png","type":"image\/png"}],"author":"Albert Niall","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Albert Niall","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/openquery.com\/how-to-create-a-table-in-sql-2\/#article","isPartOf":{"@id":"https:\/\/openquery.com\/how-to-create-a-table-in-sql-2\/"},"author":{"name":"Albert Niall","@id":"https:\/\/openquery.com\/#\/schema\/person\/95a786c4eec250fba9d6c71974a39656"},"headline":"How To Create A Table In SQL","datePublished":"2022-02-11T12:36:59+00:00","dateModified":"2022-02-28T13:57:42+00:00","mainEntityOfPage":{"@id":"https:\/\/openquery.com\/how-to-create-a-table-in-sql-2\/"},"wordCount":1156,"publisher":{"@id":"https:\/\/openquery.com\/#organization"},"articleSection":["Guides"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/openquery.com\/how-to-create-a-table-in-sql-2\/","url":"https:\/\/openquery.com\/how-to-create-a-table-in-sql-2\/","name":"How To Create A Table In SQL - Open Query","isPartOf":{"@id":"https:\/\/openquery.com\/#website"},"datePublished":"2022-02-11T12:36:59+00:00","dateModified":"2022-02-28T13:57:42+00:00","description":"Learn how to create a table in SQL with our simple, step-by-step tutorial.","breadcrumb":{"@id":"https:\/\/openquery.com\/how-to-create-a-table-in-sql-2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/openquery.com\/how-to-create-a-table-in-sql-2\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/openquery.com\/how-to-create-a-table-in-sql-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/openquery.com\/"},{"@type":"ListItem","position":2,"name":"How To Create A Table In SQL"}]},{"@type":"WebSite","@id":"https:\/\/openquery.com\/#website","url":"https:\/\/openquery.com\/","name":"Open Query","description":"Everything about IT","publisher":{"@id":"https:\/\/openquery.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/openquery.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/openquery.com\/#organization","name":"Open Query","url":"https:\/\/openquery.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/openquery.com\/#\/schema\/logo\/image\/","url":"https:\/\/openquery.com\/wp-content\/uploads\/2022\/02\/cropped-openquerylogo.png","contentUrl":"https:\/\/openquery.com\/wp-content\/uploads\/2022\/02\/cropped-openquerylogo.png","width":1016,"height":323,"caption":"Open Query"},"image":{"@id":"https:\/\/openquery.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/openquery.com\/#\/schema\/person\/95a786c4eec250fba9d6c71974a39656","name":"Albert Niall","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/openquery.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/4728d76122b10a705d1e313fb3a924de?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4728d76122b10a705d1e313fb3a924de?s=96&d=mm&r=g","caption":"Albert Niall"},"description":"Hi, I\u2019m Albert Niall, and I want people to make the most out of their online presence and use it to their advantage. Here at Open Query I want to make it as easy as possible for you to learn about topics that might not be easily accessible elsewhere online. I don\u2019t know about you, but I haven\u2019t seen many other websites talking about the MariaDB Foundation and its updates. That\u2019s what makes Open Query truly unique. While others might assume everyone knows this information already automatically, I am filling my online resource to help."}]}},"_links":{"self":[{"href":"https:\/\/openquery.com\/wp-json\/wp\/v2\/posts\/140"}],"collection":[{"href":"https:\/\/openquery.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/openquery.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/openquery.com\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/openquery.com\/wp-json\/wp\/v2\/comments?post=140"}],"version-history":[{"count":2,"href":"https:\/\/openquery.com\/wp-json\/wp\/v2\/posts\/140\/revisions"}],"predecessor-version":[{"id":240,"href":"https:\/\/openquery.com\/wp-json\/wp\/v2\/posts\/140\/revisions\/240"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/openquery.com\/wp-json\/wp\/v2\/media\/141"}],"wp:attachment":[{"href":"https:\/\/openquery.com\/wp-json\/wp\/v2\/media?parent=140"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/openquery.com\/wp-json\/wp\/v2\/categories?post=140"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/openquery.com\/wp-json\/wp\/v2\/tags?post=140"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}