{"id":9,"date":"2016-01-10T17:45:51","date_gmt":"2016-01-10T17:45:51","guid":{"rendered":"http:\/\/mr-west.uk\/sql\/?page_id=9"},"modified":"2024-10-10T07:21:33","modified_gmt":"2024-10-10T07:21:33","slug":"viewing-databases","status":"publish","type":"page","link":"https:\/\/learnlearn.uk\/sql\/viewing-databases\/","title":{"rendered":"Opening and Viewing Databases"},"content":{"rendered":"<div class=\"responsive-tabs\">\n<h2 class=\"tabtitle\">Introduction<\/h2>\n<div class=\"tabcontent\">\n\n<h3>Introduction<\/h3>\n<p>SQLite is a simple database format that is great for beginners to learn how Structured Query Language works<\/p>\n<ul>\n<li>SQLite3 &#8211; How to open a database<\/li>\n<li>.table &#8211; How to view the names of all the tables in a database<\/li>\n<li>PRAGMA table_info &#8211; How to see the column names and data types in a table<\/li>\n<li>SELECT &#8211; How to view the contents of table<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n\n<\/div><h2 class=\"tabtitle\">sqlite3<\/h2>\n<div class=\"tabcontent\">\n\n<h3><span style=\"color: #999999;\">sqlite3 <\/span>&#8211; How to open\/create a database<\/h3>\n<p>SQLite databases are stored in a single file which you can access directly using the sqlite3 command. If the file does not exist(or if it exists but in a different directory!) then a new database file will be created.<br \/>\n<!-- HTML generated using hilite.me --><\/p>\n<p>In the following the example we open the chinook.db database.<\/p>\n<div style=\"background: #000000!important; overflow: auto; width: auto; border: solid gray; border-width: .1em .1em .1em .8em; padding: .2em .6em;\">\n<pre style=\"background: #000000; margin: 0; line-height: 125%;\"><span style=\"color: #cccccc;\">#<\/span> <span style=\"color: #cccccc;\">Open<\/span> <span style=\"color: #cccccc;\">in<\/span> <span style=\"color: #cccccc;\">Linux<\/span> <span style=\"color: #cccccc;\">terminal<\/span>\r\n<span style=\"color: #ffff00;\">sqlite3 chinook.db <\/span>\r\n\r\n<span style=\"color: #cccccc;\"># Open<\/span> <span style=\"color: #cccccc;\">in<\/span> <span style=\"color: #cccccc;\">Windows<\/span> <span style=\"color: #cccccc;\">PowerShell<\/span>\r\n<span style=\"color: #ffff00;\">\\.sqlite3.exe chinook.db \r\n<\/span><\/pre>\n<\/div>\n\n<\/div><h2 class=\"tabtitle\">.table<\/h2>\n<div class=\"tabcontent\">\n\n<h3><span style=\"color: #999999;\">.table<\/span> &#8211; Show all table names<br \/>\n<!-- HTML generated using hilite.me --><\/h3>\n<p>This command returns a list of the names of the tables in the database. Useful if you don&#8217;t know the name of a table.<\/p>\n<div style=\"background: #000000!important; overflow: auto; width: auto; border: solid gray; border-width: .1em .1em .1em .8em; padding: .2em .6em;\">\n<pre style=\"background: #000000; margin: 0; line-height: 125%;\"><span style=\"color: #ffff00;\">.table\r\n<\/span><\/pre>\n<\/div>\n<p>&nbsp;<\/p>\n<p>Output:<\/p>\n<p><!-- HTML generated using hilite.me --><\/p>\n<div style=\"background: #000000!important; overflow: auto; width: auto; border: solid gray; border-width: .1em .1em .1em .8em; padding: .2em .6em;\">\n<pre style=\"background: #000000; margin: 0; line-height: 125%;\"><span style=\"color: #cccccc;\">sqlite<\/span><span style=\"color: #3399cc;\">&gt;<\/span> <span style=\"color: #cccccc;\">.<\/span><span style=\"color: #cdcd00;\">table<\/span>\r\n<span style=\"color: #cccccc;\">albums<\/span>          <span style=\"color: #cccccc;\">employees<\/span>       <span style=\"color: #cccccc;\">invoices<\/span>        <span style=\"color: #cccccc;\">playlists<\/span>\r\n<span style=\"color: #cccccc;\">artists<\/span>         <span style=\"color: #cccccc;\">genres<\/span>          <span style=\"color: #cccccc;\">media_types<\/span>     <span style=\"color: #cccccc;\">tracks<\/span>\r\n<span style=\"color: #cccccc;\">customers<\/span>       <span style=\"color: #cccccc;\">invoice_items<\/span>   <span style=\"color: #cccccc;\">playlist_track<\/span>\r\n<\/pre>\n<\/div>\n\n<\/div><h2 class=\"tabtitle\">Pragma<\/h2>\n<div class=\"tabcontent\">\n\n<h3><span style=\"color: #999999;\">PRAGMA<\/span> &#8211; View details about a table&#8217;s structure<br \/>\n<!-- HTML generated using hilite.me --><\/h3>\n<p>If you don&#8217;t know what columns are contained within a table, you can use the PRAGMA table_info statement to list all available columns.<\/p>\n<p>Example &#8211; view the album table structure.<\/p>\n<div style=\"background: #000000!important; overflow: auto; width: auto; border: solid gray; border-width: .1em .1em .1em .8em; padding: .2em .6em;\">\n<pre style=\"background: #000000; margin: 0; line-height: 125%;\"><span style=\"color: #ffff00;\">PRAGMA table_info(albums);<\/span><\/pre>\n<\/div>\n<p>Output:<\/p>\n<div style=\"background: #000000!important; overflow: auto; width: auto; border: solid gray; border-width: .1em .1em .1em .8em; padding: .2em .6em;\">\n<pre style=\"background: #000000; margin: 0; line-height: 125%;\"><span style=\"color: #e0e0e0;\">0|AlbumId|INTEGER|1||1\r\n1|Title|NVARCHAR(160)|1||0\r\n2|ArtistId|INTEGER|1||0\r\n<\/span><\/pre>\n<\/div>\n<p>&nbsp;<\/p>\n\n<\/div><h2 class=\"tabtitle\">SELECT  *<\/h2>\n<div class=\"tabcontent\">\n\n<h3><span style=\"color: #999999;\">SELECT *<\/span>\u00a0&#8211; Select all rows from a table<\/h3>\n<p>If you just want to display the entire contents of a database table, the you can use the SELECT * FROM statement. This will get the entire contents of the table.<\/p>\n<p>Example &#8211; display all data in the albums table<\/p>\n<p><!-- HTML generated using hilite.me --><\/p>\n<div style=\"background: #000000!important; overflow: auto; width: auto; border: solid gray; border-width: .1em .1em .1em .8em; padding: .2em .6em;\">\n<pre style=\"background: #000000; margin: 0; line-height: 125%;\"><span style=\"color: #ffff00;\">SELECT * FROM albums;\r\n<\/span><\/pre>\n<\/div>\n<p>&nbsp;<\/p>\n<p>Output:<br \/>\n<!-- HTML generated using hilite.me --><\/p>\n<div style=\"background: #000000!important; overflow: auto; width: auto; border: solid gray; border-width: .1em .1em .1em .8em; padding: .2em .6em;\">\n<pre style=\"background: #000000; margin: 0; line-height: 125%;\"><span style=\"color: #e0e0e0;\">344|Schubert: The Late String Quartets &amp; String Quintet (3 CD's)|272\r\n345|Monteverdi: L'Orfeo|273\r\n346|Mozart: Chamber Music|274\r\n347|Koyaanisqatsi (Soundtrack from the Motion Picture)|275\r\n<\/span><\/pre>\n<\/div>\n<p>&nbsp;<\/p>\n<h3><\/h3>\n\n<\/div><h2 class=\"tabtitle\">SELECT Columns<\/h2>\n<div class=\"tabcontent\">\n\n<h3><span style=\"color: #999999;\">SELECT column_name\u00a0FROM table_name<\/span> &#8211; View specific column data<\/h3>\n<p>If you just want to select a single column or certain columns, then you can specify the column names you want, separated by a comma.<br \/>\n<!-- HTML generated using hilite.me --><\/p>\n<p>Example &#8211; display all the first names and last names in the employees table.<\/p>\n<div style=\"background: #000000; overflow: auto; width: auto; border: solid gray; border-width: .1em .1em .1em .8em; padding: .2em .6em;\">\n<pre style=\"background: #000000; margin: 0; line-height: 125%;\"><span style=\"color: #ffff00;\">SELECT FirstName, Email FROM employees;\r\n<\/span><\/pre>\n<\/div>\n<p>&nbsp;<\/p>\n<p>Output:<\/p>\n<p><!-- HTML generated using hilite.me --><\/p>\n<div style=\"background: #000000; overflow: auto; width: auto; border: solid gray; border-width: .1em .1em .1em .8em; padding: .2em .6em;\">\n<pre style=\"background: #000000; margin: 0; line-height: 125%;\"><span style=\"color: #cccccc;\">Andrew|andrew@chinookcorp.com<\/span>\r\n<span style=\"color: #cccccc;\">Nancy|nancy@chinookcorp.com<\/span>\r\n<span style=\"color: #cccccc;\">Jane|jane@chinookcorp.com<\/span>\r\n<span style=\"color: #cccccc;\">Margaret|margaret@chinookcorp.com<\/span>\r\n<span style=\"color: #cccccc;\">Steve|steve@chinookcorp.com<\/span>\r\n<span style=\"color: #cccccc;\">Michael|michael@chinookcorp.com<\/span>\r\n<span style=\"color: #cccccc;\">Robert|robert@chinookcorp.com<\/span>\r\n<span style=\"color: #cccccc;\">Laura|laura@chinookcorp.com<\/span>\r\n<\/pre>\n<\/div>\n\n<\/div><h2 class=\"tabtitle\">SELECT WHERE <\/h2>\n<div class=\"tabcontent\">\n\n<h3><span style=\"color: #999999;\">SELECT WHERE<\/span> &#8211; Select filtered results from a table<\/h3>\n<p>If you want to only select rows from the table where data in a column matches a certain value, you need to use the WHERE clause.<\/p>\n<p><!-- HTML generated using hilite.me --><\/p>\n<div style=\"background: #000000; overflow: auto; width: auto; border: solid gray; border-width: .1em .1em .1em .8em; padding: .2em .6em;\">\n<pre style=\"background: #000000; margin: 0; line-height: 125%;\"><span style=\"color: #ffff00;\">SELECT FirstName,LastName,Country FROM customers where firstname = \"Mark\";\r\n<\/span><\/pre>\n<\/div>\n<p>Output:<\/p>\n<p><!-- HTML generated using hilite.me --><\/p>\n<div style=\"background: #000000; overflow: auto; width: auto; border: solid gray; border-width: .1em .1em .1em .8em; padding: .2em .6em;\">\n<pre style=\"background: #000000; margin: 0; line-height: 125%;\"><span style=\"color: #cccccc;\">Mark|Philips|Canada<\/span>\r\n<span style=\"color: #cccccc;\">Mark|Taylor|Australia<\/span>\r\n<\/pre>\n<\/div>\n<p>&nbsp;<\/p>\n<h3>&lt; &gt; &#8211; Greater Than &gt; and Less Than Filter<\/h3>\n<p>If you want to filter data from a table where values are greater or less than an amount, then you can use &lt; and &gt; operators<\/p>\n<p><!-- HTML generated using hilite.me --><\/p>\n<div style=\"background: #000000; overflow: auto; width: auto; border: solid gray; border-width: .1em .1em .1em .8em; padding: .2em .6em;\">\n<pre style=\"background: #000000; margin: 0; line-height: 125%;\"><span style=\"color: #ffff00;\">select * from invoice_items where InvoiceId &gt; 400 and UnitPrice &gt; 1;\r\n<\/span><\/pre>\n<\/div>\n<h3><\/h3>\n<h3>A Like B &#8211;\u00a0None case-sensitive match<\/h3>\n<p>When using the equals =\u00a0 operator, SQL will only search for an exact, case sensitive match. If you want to do a case non sensitive search then use <strong>like<\/strong> instead of equals.<\/p>\n<div style=\"background: #000000; overflow: auto; width: auto; border: solid gray; border-width: .1em .1em .1em .8em; padding: .2em .6em;\">\n<pre style=\"background: #000000; margin: 0; line-height: 125%;\"><span style=\"color: #ffff00;\">SELECT Name from Artists WHERE Name LIKE \"julian\";\r\n<\/span><\/pre>\n<\/div>\n<h3><\/h3>\n<h3>% &#8211; Wildcard operator<\/h3>\n<p>A wildcard operator(%) can be used for more extensive matching. A wildcard matches and character or number of characters.<\/p>\n<p>Here in the example wildcard operator serves to find any artist whose name begins with the word &#8216;the&#8217;.<\/p>\n<p><!-- HTML generated using hilite.me --><\/p>\n<div style=\"background: #000000; overflow: auto; width: auto; border: solid gray; border-width: .1em .1em .1em .8em; padding: .2em .6em;\">\n<pre style=\"background: #000000; margin: 0; line-height: 125%;\"><span style=\"color: #ffff00;\">SELECT Name from Artists WHERE Name LIKE \"the %\";\r\n<\/span><\/pre>\n<\/div>\n<p><!-- HTML generated using hilite.me --><\/p>\n<div style=\"background: #000000; overflow: auto; width: auto; border: solid gray; border-width: .1em .1em .1em .8em; padding: .2em .6em;\">\n<pre style=\"background: #000000; margin: 0; line-height: 125%;\"><span style=\"color: #cccccc;\">The Black Crowes<\/span>\r\n<span style=\"color: #cccccc;\">The Clash<\/span>\r\n<span style=\"color: #cccccc;\">The Cult<\/span>\r\n<span style=\"color: #cccccc;\">The Doors<\/span>\r\n<span style=\"color: #cccccc;\">The Police<\/span>\r\n<span style=\"color: #cccccc;\">The Rolling Stones<\/span>\r\n<span style=\"color: #cccccc;\">The Tea Party<\/span>\r\n<\/pre>\n<\/div>\n\n<\/div><h2 class=\"tabtitle\">Challenges<\/h2>\n<div class=\"tabcontent\">\n\n<p><strong>Challenge 1<\/strong><br \/>\nFind out what tables the database contains.<\/p>\n<p><strong>Challenge 2<\/strong><\/p>\n<p>Find out what column names and types the Album table contains<\/p>\n<p><strong>Challenge\u00a03<\/strong><\/p>\n<p>Find out what artists are in the Artist table.<\/p>\n<p><strong>Challenge 4<\/strong><\/p>\n<p>Create a query that lists the first name and last name of all customers in the Customer table.<\/p>\n<p><strong>Challenge 5<\/strong><\/p>\n<p>Create a query that selects all rows\u00a0in the Employee table where the Title is &#8216;Sales Support Agent&#8217;<\/p>\n<p><strong>Challenge 6<\/strong><\/p>\n<p>Create a query that lists all rows in the PlaylistTrack table where the TrackId is greater than 3000.<\/p>\n<p>&nbsp;<\/p>\n<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Introduction SQLite is a simple database format that is great for beginners to learn how Structured Query Language works SQLite3 &#8211; How to open a database .table &#8211; How to view the names of all the tables in a database PRAGMA table_info &#8211; How to see the column names and data types in a table&hellip;&nbsp;<a href=\"https:\/\/learnlearn.uk\/sql\/viewing-databases\/\" class=\"\" rel=\"bookmark\">Read More &raquo;<span class=\"screen-reader-text\">Opening and Viewing Databases<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"on","neve_meta_content_width":93,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":""},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Opening and Viewing Databases - SQL<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/learnlearn.uk\/sql\/viewing-databases\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Opening and Viewing Databases - SQL\" \/>\n<meta property=\"og:description\" content=\"Introduction SQLite is a simple database format that is great for beginners to learn how Structured Query Language works SQLite3 &#8211; How to open a database .table &#8211; How to view the names of all the tables in a database PRAGMA table_info &#8211; How to see the column names and data types in a table&hellip;&nbsp;Read More &raquo;Opening and Viewing Databases\" \/>\n<meta property=\"og:url\" content=\"https:\/\/learnlearn.uk\/sql\/viewing-databases\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL\" \/>\n<meta property=\"article:modified_time\" content=\"2024-10-10T07:21:33+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/learnlearn.uk\/sql\/viewing-databases\/\",\"url\":\"https:\/\/learnlearn.uk\/sql\/viewing-databases\/\",\"name\":\"Opening and Viewing Databases - SQL\",\"isPartOf\":{\"@id\":\"https:\/\/learnlearn.uk\/sql\/#website\"},\"datePublished\":\"2016-01-10T17:45:51+00:00\",\"dateModified\":\"2024-10-10T07:21:33+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/learnlearn.uk\/sql\/viewing-databases\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/learnlearn.uk\/sql\/viewing-databases\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/learnlearn.uk\/sql\/viewing-databases\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/learnlearn.uk\/sql\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Opening and Viewing Databases\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/learnlearn.uk\/sql\/#website\",\"url\":\"https:\/\/learnlearn.uk\/sql\/\",\"name\":\"SQL\",\"description\":\"Databases\",\"publisher\":{\"@id\":\"https:\/\/learnlearn.uk\/sql\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/learnlearn.uk\/sql\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/learnlearn.uk\/sql\/#organization\",\"name\":\"SQL\",\"url\":\"https:\/\/learnlearn.uk\/sql\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/learnlearn.uk\/sql\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/learnlearn.uk\/sql\/wp-content\/uploads\/sites\/6\/2019\/02\/LearnLearnLogowhite.png\",\"contentUrl\":\"https:\/\/learnlearn.uk\/sql\/wp-content\/uploads\/sites\/6\/2019\/02\/LearnLearnLogowhite.png\",\"width\":710,\"height\":98,\"caption\":\"SQL\"},\"image\":{\"@id\":\"https:\/\/learnlearn.uk\/sql\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Opening and Viewing Databases - SQL","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:\/\/learnlearn.uk\/sql\/viewing-databases\/","og_locale":"en_GB","og_type":"article","og_title":"Opening and Viewing Databases - SQL","og_description":"Introduction SQLite is a simple database format that is great for beginners to learn how Structured Query Language works SQLite3 &#8211; How to open a database .table &#8211; How to view the names of all the tables in a database PRAGMA table_info &#8211; How to see the column names and data types in a table&hellip;&nbsp;Read More &raquo;Opening and Viewing Databases","og_url":"https:\/\/learnlearn.uk\/sql\/viewing-databases\/","og_site_name":"SQL","article_modified_time":"2024-10-10T07:21:33+00:00","twitter_card":"summary_large_image","twitter_misc":{"Estimated reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/learnlearn.uk\/sql\/viewing-databases\/","url":"https:\/\/learnlearn.uk\/sql\/viewing-databases\/","name":"Opening and Viewing Databases - SQL","isPartOf":{"@id":"https:\/\/learnlearn.uk\/sql\/#website"},"datePublished":"2016-01-10T17:45:51+00:00","dateModified":"2024-10-10T07:21:33+00:00","breadcrumb":{"@id":"https:\/\/learnlearn.uk\/sql\/viewing-databases\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/learnlearn.uk\/sql\/viewing-databases\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/learnlearn.uk\/sql\/viewing-databases\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/learnlearn.uk\/sql\/"},{"@type":"ListItem","position":2,"name":"Opening and Viewing Databases"}]},{"@type":"WebSite","@id":"https:\/\/learnlearn.uk\/sql\/#website","url":"https:\/\/learnlearn.uk\/sql\/","name":"SQL","description":"Databases","publisher":{"@id":"https:\/\/learnlearn.uk\/sql\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/learnlearn.uk\/sql\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/learnlearn.uk\/sql\/#organization","name":"SQL","url":"https:\/\/learnlearn.uk\/sql\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/learnlearn.uk\/sql\/#\/schema\/logo\/image\/","url":"https:\/\/learnlearn.uk\/sql\/wp-content\/uploads\/sites\/6\/2019\/02\/LearnLearnLogowhite.png","contentUrl":"https:\/\/learnlearn.uk\/sql\/wp-content\/uploads\/sites\/6\/2019\/02\/LearnLearnLogowhite.png","width":710,"height":98,"caption":"SQL"},"image":{"@id":"https:\/\/learnlearn.uk\/sql\/#\/schema\/logo\/image\/"}}]}},"rttpg_featured_image_url":null,"rttpg_author":{"display_name":"learnlearnadmin","author_link":"https:\/\/learnlearn.uk\/sql\/author\/learnlearnadmin\/"},"rttpg_comment":0,"rttpg_category":null,"rttpg_excerpt":"Introduction SQLite is a simple database format that is great for beginners to learn how Structured Query Language works SQLite3 &#8211; How to open a database .table &#8211; How to view the names of all the tables in a database PRAGMA table_info &#8211; How to see the column names and data types in a table&hellip;&nbsp;Read&hellip;","_links":{"self":[{"href":"https:\/\/learnlearn.uk\/sql\/wp-json\/wp\/v2\/pages\/9"}],"collection":[{"href":"https:\/\/learnlearn.uk\/sql\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/learnlearn.uk\/sql\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/learnlearn.uk\/sql\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/learnlearn.uk\/sql\/wp-json\/wp\/v2\/comments?post=9"}],"version-history":[{"count":20,"href":"https:\/\/learnlearn.uk\/sql\/wp-json\/wp\/v2\/pages\/9\/revisions"}],"predecessor-version":[{"id":240,"href":"https:\/\/learnlearn.uk\/sql\/wp-json\/wp\/v2\/pages\/9\/revisions\/240"}],"wp:attachment":[{"href":"https:\/\/learnlearn.uk\/sql\/wp-json\/wp\/v2\/media?parent=9"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}