{"id":1503,"date":"2020-03-06T11:43:23","date_gmt":"2020-03-06T00:43:23","guid":{"rendered":"https:\/\/www.dynamicwebtraining.com.au\/blog\/?p=1503"},"modified":"2024-11-14T14:08:55","modified_gmt":"2024-11-14T03:08:55","slug":"mysql-interview-questions","status":"publish","type":"post","link":"https:\/\/www.dynamicwebtraining.com.au\/blog\/mysql-interview-questions","title":{"rendered":"Top 20 MySQL Interview Questions Answered"},"content":{"rendered":"\n<p>MySQL is a multi-user SQL database management system founded by MySQL AB. Currently, Oracle owns MYSQL. It is the world\u2019s 2nd most used &amp; popular open-source database, i.e., free to use. A significant factor behind its popularity is its compatibility with different languages (like C, C++, JAVA, PHP, PERL, etc.), notably PHP. PHP is mostly used in web development accompanied by MySQL.<\/p>\n\n\n\n<!--more-->\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"536\" src=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2020\/03\/mysql-interview-feature-1-1024x536.jpg\" alt=\"Top 20 MySQL Interview Questions Answered - Dynamic Web Training\" class=\"wp-image-1505\" srcset=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2020\/03\/mysql-interview-feature-1-1024x536.jpg 1024w, https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2020\/03\/mysql-interview-feature-1-300x157.jpg 300w, https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2020\/03\/mysql-interview-feature-1.jpg 1200w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Being popular, interviewers expect a candidate to be thorough with MySQL. Here are Top MySQL Interview Questions, which might be pretty helpful to you.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">MySQL Interview Questions<\/h2>\n\n\n\n<h4 class=\"wp-block-heading\">1) What are the technical specifications of MySQL?<\/h4>\n\n\n\n<p><em>Ans:<\/em><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>High Efficiency<\/li>\n\n\n\n<li>Easy to Use &amp; Manageable<\/li>\n\n\n\n<li>Flexible Structure<\/li>\n\n\n\n<li>Replication<\/li>\n\n\n\n<li>Portable<\/li>\n\n\n\n<li>Security &amp; Storage Management<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">2) Is there any difference between MySQL &amp; SQL? If yes, then what?<\/h4>\n\n\n\n<p><em>Ans: <\/em><\/p>\n\n\n\n<p>SQL or Structured Query Language is a database language used for creation, deletion, retrieving or modifying, etc. of the database. Meanwhile, MySQL is a database that stores different types of data safely. So MySQL is a database &amp; SQL is a database language which works on MySQL.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">3) MySQL supports large databases up to which extent?<\/h4>\n\n\n\n<p>Ans: <\/p>\n\n\n\n<p>MySQL supports up to 50 million rows or tables. And the table limit is up to 4 GB. However, you can increase these limits according to your operating system\u2019s strength. Theoretically, the size of the table can extend up to 8 million terabytes.&nbsp;<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">4) List all categories of datatypes of MySQL.<\/h4>\n\n\n\n<p><em>Ans: <\/em><\/p>\n\n\n\n<p>Type of data declared is termed as \u201cDatatype.\u201d Each data type has a fixed amount of space which will be allotted if declared. Example: declaration of int will create 2 bits. MySQL has three categories of data types; Numeric, Time &amp; String.&nbsp;<\/p>\n\n\n\n<p>There are eight datatypes categorized in Numeric, five in the Time &amp; eight in the String.&nbsp;<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">5) What are the different tables in MySQL?<\/h4>\n\n\n\n<p><em>Ans: <\/em><\/p>\n\n\n\n<p>There are five different tables in MySQL, out of which MyISAM is the default database engine.&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>MyISAM<\/li>\n\n\n\n<li>Heap<\/li>\n\n\n\n<li>Merge<\/li>\n\n\n\n<li>INNO DB<\/li>\n\n\n\n<li>ISAM<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">6) Name the triggers allowed in MySQL.<\/h4>\n\n\n\n<p><em>Ans:<\/em> There are six triggers allowed in MySQL as follows:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Before Insert<\/li>\n\n\n\n<li>After Insert<\/li>\n\n\n\n<li>Before Update<\/li>\n\n\n\n<li>After Update<\/li>\n\n\n\n<li>Before Delete<\/li>\n\n\n\n<li>After Delete&nbsp;<\/li>\n<\/ol>\n\n\n\n<h4 class=\"wp-block-heading\">7) What are the differences between the heap table &amp; temporary table?<\/h4>\n\n\n\n<p><em>Ans:<\/em><\/p>\n\n\n\n<p><strong>Heap Table:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Found in memory. It works as storage temporarily.&nbsp;<\/li>\n\n\n\n<li>BLOB &amp; TEXT fields aren\u2019t allowed<\/li>\n\n\n\n<li>Indexes should be \u201cNOT NULL\u201d<\/li>\n\n\n\n<li>Doesn\u2019t supports \u201cAUTO_INCREMENT\u201d<\/li>\n\n\n\n<li>Can be shared among clients<\/li>\n\n\n\n<li>Only comparison operators can be used (=,&lt;,&gt;,&gt;=, &lt;=)<\/li>\n<\/ul>\n\n\n\n<p><strong>Temporary Table:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Used to store provisional data<\/li>\n\n\n\n<li>Temporarily stored data is deleted after client session ends<\/li>\n\n\n\n<li>Aren\u2019t shared among clients<\/li>\n\n\n\n<li>Special syntax is used; &#8220;create temporary table&#8221;<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">8) What is the difference between MySQL_connect &amp; MySQL_pconnect?<\/h4>\n\n\n\n<p><em>Ans:<\/em><\/p>\n\n\n\n<p><strong>MySQL_connect:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Opens a new connection to the database<\/li>\n\n\n\n<li>Depending on request you need to open &amp; close a database connection<\/li>\n\n\n\n<li>Opens page whenever loaded<\/li>\n<\/ul>\n\n\n\n<p><strong>MySQL_pconnect:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>In MySQL_pconnect, \u201cp\u201d stands for \u201cPersistent\u201d so its persistent connection<\/li>\n\n\n\n<li>A database cannot be closed<\/li>\n\n\n\n<li>No need to open &amp; close thus suitable for sites with huge traffic<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">9) How to display nth highest salary from a table in MySQL?<\/h4>\n\n\n\n<p><em>Ans:&nbsp;<\/em><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>nth highest salary:<\/strong>\n<ul class=\"wp-block-list\">\n<li><code>Select distinct(salary) from the employee order by salary desc limit (n-1),1<\/code><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>3rd highest salary:<\/strong>\n<ul class=\"wp-block-list\">\n<li><code>Select distinct(salary) from employee order by salary desc limit 2,1<\/code><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>6th highest salary:<\/strong>\n<ul class=\"wp-block-list\">\n<li><code>Select distinct(salary) from employee order by salary desc limit 5,1<\/code><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">10) What is BLOB &amp; TEXT in MySQL?<\/h4>\n\n\n\n<p>Ans:&nbsp;<\/p>\n\n\n\n<p><strong>BLOB:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>BLOB or Binary Large Object stores the variable amount of data.&nbsp;<\/li>\n\n\n\n<li>There are four types of BLOB:\n<ul class=\"wp-block-list\">\n<li>TINYBLOB<\/li>\n\n\n\n<li>BLOB(size)<\/li>\n\n\n\n<li>MEDIUMBLOB<\/li>\n\n\n\n<li>LONGBLOB<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th><strong>Data Type Syntax<\/strong><\/th><th><strong>Maximum Size<\/strong><\/th><\/tr><\/thead><tbody><tr><td>TINYBLOB<\/td><td>Maximum size of 255 Bytes<\/td><\/tr><tr><td>BLOB(size)<\/td><td>Maximum size of 65,535 Bytes<\/td><\/tr><tr><td>MEDIUMBLOB<\/td><td>Maximum size of 16,777,215 Bytes<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><strong>TEXT:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Case-insensitive BLOB<\/li>\n\n\n\n<li>Values are a character string or non-binary string<\/li>\n\n\n\n<li>Have a character set<\/li>\n\n\n\n<li>Four types of TEXT:<\/li>\n\n\n\n<li>TINYTEXT<\/li>\n\n\n\n<li>TEXT&nbsp; &nbsp; &nbsp;<\/li>\n\n\n\n<li>MEDIUM TEXT<\/li>\n\n\n\n<li>LONGTEXT<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th><strong>Data Type Syntax<\/strong><\/th><th>M<strong>aximum Size<\/strong><\/th><\/tr><\/thead><tbody><tr><td>TINYTEXT<\/td><td>Maximum Size of 255 characters<\/td><\/tr><tr><td>TEXT(size)<\/td><td>Maximum Size of 65,535 characters<\/td><\/tr><tr><td>MEDIUMTEXT<\/td><td>Maximum Size of 16,777,215 characters<\/td><\/tr><tr><td>LONGTEXT<\/td><td>Maximum Size of 4 GB or 4,294,967,295 characters<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>The factor that makes BLOB &amp; TEXT different is \u201csorting &amp; comparison.\u201d It is performed case sensitive for BLOB &amp; case-insensitive for TEXT values.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">11) What are the differences between CHAR &amp; VARCHAR?<\/h4>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th><strong>CHAR<\/strong><\/th><th><strong>VARCHAR<\/strong><\/th><\/tr><\/thead><tbody><tr><td>Column Length is fixed<\/td><td>Column Length isn\u2019t fixed<\/td><\/tr><tr><td>Maximum characters holding capacity: 255 characters<\/td><td>Maximum characters holding capacity: 4000 characters<\/td><\/tr><tr><td>Faster than VARCHAR<\/td><td>Little slower than CHAR<\/td><\/tr><tr><td>Uses Static Memory Allocation<\/td><td>Uses Dynamic Memory Allocation<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">12) What is SQLyog?<\/h4>\n\n\n\n<p><em>Ans: <\/em><\/p>\n\n\n\n<p>SQLyog program is a GUI tool for admin. It\u2019s a popular MySQL manager &amp; admin tool. It\u2019s an integration of MySQL administration, phpMyAdmin &amp; other MySQL GUI tools.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">13) How is the MyISAM table stored?<\/h4>\n\n\n\n<p><em>Ans: <\/em><\/p>\n\n\n\n<p>You can store MyISAM table in the following format on disk:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>&#8216;.frm<\/strong>&#8216; : File<\/li>\n\n\n\n<li>&#8216;<strong>.MYI<\/strong>&#8216;: (MY Index) : Index file<\/li>\n\n\n\n<li>&#8216;<strong>.MYD<\/strong>&#8216;: (MYData) : Data File<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">14) How can we make a conversion between UNIX &amp; MySQL timestamp?<\/h4>\n\n\n\n<p><em>Ans:&nbsp;<\/em><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>UNIX_TIMESTAMP<\/strong> is the command used to convert MySQL timestamp to Unix timestamp<\/li>\n\n\n\n<li> <strong>FROM_TIMESTAMP<\/strong> is the command used to convert Unix timestamp to MySQL timestamp<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">15) What is the difference between UNIX &amp; MySQL timestamp?<\/h4>\n\n\n\n<p><em>Ans: <\/em><\/p>\n\n\n\n<p>You can store UNIX &amp; MySQL timestamp in 32-bit integers. However, MySQL is represented in \u201cYYYY-MM-DD HH:MM:SS\u201d format.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">16) How to use &#8220;Like Condition&#8221;?<\/h4>\n\n\n\n<p><em>Ans: <\/em><\/p>\n\n\n\n<p>LIKE condition or pattern patch has three primary rules for use:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Used in the pattern to match anyone character<\/li>\n\n\n\n<li> &#8220;%&#8221; corresponds to zero or more characters<\/li>\n\n\n\n<li> &#8220;_&#8221; is exactly one character<\/li>\n\n\n\n<li> ESCAPE used to provide ESCAPE character in the pattern<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">17) What are Regular Expressions? State their uses.<\/h4>\n\n\n\n<p><em>Ans: <\/em><\/p>\n\n\n\n<p>Regular Expressions are for complex search in a string. It\u2019s a way of specifying patterns for search.&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>Pattern<\/th><th>What it matches<\/th><\/tr><\/thead><tbody><tr><td>*<\/td><td>Zero instance or more instances of the preceding element<\/td><\/tr><tr><td>^<\/td><td>Beginning of String<\/td><\/tr><tr><td>$<\/td><td>End of String<\/td><\/tr><tr><td>+<\/td><td>One instance or more instances of the preceding element<\/td><\/tr><tr><td>.<\/td><td>Any Single Character<\/td><\/tr><tr><td>[\u2026]<\/td><td>Characters are written\/listed between square brackets<\/td><\/tr><tr><td>[^\u2026]<\/td><td>Characters not written\/listed between square brackets<\/td><\/tr><tr><td>{n}<\/td><td>N instances of preceding element<\/td><\/tr><tr><td>{m,n}<\/td><td>M through to n instances of preceding element<\/td><\/tr><tr><td>|<\/td><td>Matches any one of the pattern<\/td><\/tr><tr><td><\/td><td>Example: p1|p2|p3 means&nbsp;p1,p2 or p3<\/td><\/tr><tr><td>?<\/td><td>0 or 1 instance of the preceding element<\/td><\/tr><tr><td>&nbsp;&nbsp;REGEXP<\/td><td>Matches input character with database<\/td><\/tr><tr><td><\/td><td>Example: REGEXP \u2018abc\u2019 or REGEXP \u201810\u2019<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">18) For what we use &#8220;i-am-a-dummy flag&#8221; in MySQL?<\/h4>\n\n\n\n<p><em>Ans:<\/em><\/p>\n\n\n\n<p>&nbsp;&#8220;i-am-a-dummy&#8221; flag is used at places where we want to deny or stop \u201cUPDATE &amp; DELETE\u201d commands unless there\u2019s a WHERE clause present.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">19) How to add a new column &amp; delete an existing column in a table?<\/h4>\n\n\n\n<p>Ans:&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Add a new column<\/strong>:\n<ul class=\"wp-block-list\">\n<li><code>ALTER TABLE ADD COLUMN column_name datatype(size);<\/code><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Delete an existing column<\/strong>:\n<ul class=\"wp-block-list\">\n<li><code>ALTER TABLE DROP COLUMN column_name;<\/code><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">20) What are the common MySQL functions?<\/h4>\n\n\n\n<p>Ans:&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table><thead><tr><th><strong>FUNCTION<\/strong><\/th><th><strong>USED FOR&nbsp;<\/strong><\/th><\/tr><\/thead><tbody><tr><td>CONCAT<\/td><td>Adds two or more strings\/fields together to form one<\/td><\/tr><tr><td>CONCAT_WS<\/td><td>Similar like CONCAT but has a separator<\/td><\/tr><tr><td>INSERT<\/td><td>Inserts a string within a string at a specific position<\/td><\/tr><tr><td>REVERSE<\/td><td>Reverses a string&nbsp;<\/td><\/tr><tr><td>STRCMP<\/td><td>Compares two strings<\/td><\/tr><tr><td>LOWER &amp; UPPER<\/td><td>Converts string into lowercase &amp; uppercase respectively<\/td><\/tr><tr><td>FORMAT<\/td><td>Formats a specified position from A to B in &#8220;#&#8221;<\/td><\/tr><tr><td><\/td><td>Example: &#8220;###IA&#8221;<\/td><\/tr><tr><td>CURRDATE() &amp; CURRTIME()<\/td><td>Returns current date &amp; time<\/td><\/tr><tr><td>SUBSTR<\/td><td>Extracts substring from a specific position of a string<\/td><\/tr><tr><td>REPLACE<\/td><td>Replaces values of a substring within a string with a new substring&nbsp;<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Conclusion:<\/h3>\n\n\n\n<p>These were Top MySQL Interview Questions commonly asked by interviewers. The purpose is to make you equipped for it. I hope you liked it!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>MySQL is a multi-user SQL database management system founded by MySQL AB. Currently, Oracle owns MYSQL. It is the world\u2019s 2nd most used &amp; popular open-source database, i.e., free to use. A significant factor behind its popularity is its compatibility with different languages (like C, C++, JAVA, PHP, PERL, etc.), notably PHP. PHP is mostly&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1621],"tags":[],"class_list":["post-1503","post","type-post","status-publish","format-standard","hentry","category-programming"],"yoast_head":"<title>Top 20 MySQL Interview Questions with Answers to learn<\/title>\n<meta name=\"description\" content=\"View and Share Dynamic Web Training Blog Archives. This is a great source of articles and posts on Computer and IT training, tutorials and insights\" \/>\n<meta name=\"robots\" content=\"index, follow\" \/>\n<meta name=\"googlebot\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta name=\"bingbot\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/mysql-interview-questions\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Top 20 MySQL Interview Questions with Answers to learn\" \/>\n<meta property=\"og:description\" content=\"Learn top 20 MySQL interview questions, which can be helpful to you when interviewers expect an applicant to be acquainted with the open-source database.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/mysql-interview-questions\" \/>\n<meta property=\"og:site_name\" content=\"Dynamic Web Training Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DynamicWebTraining\/\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/DynamicWebTraining\/\" \/>\n<meta property=\"article:published_time\" content=\"2020-03-06T00:43:23+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-11-14T03:08:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2020\/03\/mysql-interview-feature-1-1024x536.jpg\" \/>\n<meta name=\"twitter:card\" content=\"summary\" \/>\n<meta name=\"twitter:creator\" content=\"@dynamicwebtrain\" \/>\n<meta name=\"twitter:site\" content=\"@dynamicwebtrain\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#organization\",\"name\":\"Dynamic Web Training\",\"url\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/\",\"sameAs\":[\"https:\/\/www.facebook.com\/DynamicWebTraining\/\",\"https:\/\/www.linkedin.com\/company\/dynamic-web-training\",\"https:\/\/twitter.com\/dynamicwebtrain\"],\"logo\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#logo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2016\/02\/logo.png\",\"width\":361,\"height\":109,\"caption\":\"Dynamic Web Training\"},\"image\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#logo\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#website\",\"url\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/\",\"name\":\"Dynamic Web Training Blog\",\"description\":\"The Ultimate Training Experience.\",\"publisher\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/?s={search_term_string}\",\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/mysql-interview-questions#primaryimage\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2020\/03\/mysql-interview-feature-1.jpg\",\"width\":1200,\"height\":628},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/mysql-interview-questions#webpage\",\"url\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/mysql-interview-questions\",\"name\":\"Top 20 MySQL Interview Questions with Answers to learn\",\"isPartOf\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/mysql-interview-questions#primaryimage\"},\"datePublished\":\"2020-03-06T00:43:23+00:00\",\"dateModified\":\"2024-11-14T03:08:55+00:00\",\"description\":\"Learn top 20 MySQL interview questions, which can be helpful to you when interviewers expect an applicant to be acquainted with the open-source database.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/mysql-interview-questions#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dynamicwebtraining.com.au\/blog\/mysql-interview-questions\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/mysql-interview-questions#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\",\"url\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\",\"name\":\"Training Blog\"}},{\"@type\":\"ListItem\",\"position\":2,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/category\/programming\",\"url\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/category\/programming\",\"name\":\"Programming\"}},{\"@type\":\"ListItem\",\"position\":3,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/mysql-interview-questions\",\"url\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/mysql-interview-questions\",\"name\":\"Top 20 MySQL Interview Questions Answered\"}}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/mysql-interview-questions#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/mysql-interview-questions#webpage\"},\"author\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#\/schema\/person\/c94653aed4a6decc8e357af0a1082233\"},\"headline\":\"Top 20 MySQL Interview Questions Answered\",\"datePublished\":\"2020-03-06T00:43:23+00:00\",\"dateModified\":\"2024-11-14T03:08:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/mysql-interview-questions#webpage\"},\"publisher\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/mysql-interview-questions#primaryimage\"},\"articleSection\":\"Programming\",\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#\/schema\/person\/c94653aed4a6decc8e357af0a1082233\",\"name\":\"Dynamic Web Training\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#personlogo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0a14e92e62ad4eee0843f5cf7da3a00e1df4c9763922d4d20ba3ed2402a6896d?s=96&d=mm&r=g\",\"caption\":\"Dynamic Web Training\"},\"description\":\"Dynamic Web Training is Australia's leading provider of instructor led software training. We offer training courses in Adobe, Web Design, Graphic Design, Photoshop, InDesign, Dreamweaver and many more.\",\"sameAs\":[\"https:\/\/www.facebook.com\/DynamicWebTraining\/\",\"https:\/\/www.linkedin.com\/company\/dynamic-web-training\",\"https:\/\/twitter.com\/dynamicwebtrain\"]}]}<\/script>","_links":{"self":[{"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/posts\/1503","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/comments?post=1503"}],"version-history":[{"count":8,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/posts\/1503\/revisions"}],"predecessor-version":[{"id":1971,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/posts\/1503\/revisions\/1971"}],"wp:attachment":[{"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/media?parent=1503"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/categories?post=1503"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/tags?post=1503"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}