{"id":144364,"date":"2020-11-11T09:29:05","date_gmt":"2020-11-11T09:29:05","guid":{"rendered":"https:\/\/www.softwaretestinghelp.com\/?page_id=144364"},"modified":"2025-04-01T08:35:50","modified_gmt":"2025-04-01T08:35:50","slug":"mysql-create-database","status":"publish","type":"page","link":"https:\/\/www.softwaretestinghelp.com\/mysql-create-database\/","title":{"rendered":"MySQL Create Database &#8211; How To Create A Database In MySQL"},"content":{"rendered":"<p><strong>This tutorial explains the steps to Create a Database in MySQL with syntax and examples. Also includes how to delete a database with an example:<\/strong><\/p>\n<p>In MySQL, to perform any of the operations, the primary necessity is of the availability of a database. A database holds various tables within it, which in turn holds crucial data. Therefore, it\u2019s important to learn about the creation process of the database.<\/p>\n<p>Please note, you may not have these kinds of privileges in an actual production environment. Creation of a database, in an actual production environment, is entirely a domain of DBAs.<\/p>\n<p><strong><em> <\/em><\/strong><\/p>\n<p><strong>=&gt;\u00a0<a href=\"https:\/\/www.softwaretestinghelp.com\/mysql-tutorial-series\/\">Click here for the complete MySQL tutorial series<\/a><\/strong><\/p>\n<p><a href=\"https:\/\/www.softwaretestinghelp.com\/wp-content\/qa\/uploads\/2020\/10\/MySQL-Create-Database.png\"><img decoding=\"async\" class=\"alignnone wp-image-144525 size-full\" src=\"https:\/\/www.softwaretestinghelp.com\/wp-content\/qa\/uploads\/2020\/10\/MySQL-Create-Database.png\" alt=\"MySQL Create Database\" width=\"700\" height=\"394\" srcset=\"https:\/\/www.softwaretestinghelp.com\/wp-content\/qa\/uploads\/2020\/10\/MySQL-Create-Database.png 700w, https:\/\/www.softwaretestinghelp.com\/wp-content\/qa\/uploads\/2020\/10\/MySQL-Create-Database-300x169.png 300w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/a><\/p>\n<p>Before proceeding ahead, please note that we have used MySQL version 8.0.<\/p>\n<p><em><strong>&gt;&gt; Download <a href=\"http:\/\/www.mysql.com\/downloads\" target=\"_blank\" rel=\"noopener nofollow\">MySQL Version8.0<\/a><\/strong><\/em><\/p>\n<h2>MySQL Create Database<\/h2>\n<p><strong> Syntax:<\/strong><\/p>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">CREATE DATABASE &#x5B;IF NOT EXISTS] db_name\r\n&#x5B;CHARACTER SET characterset_name\r\n&#x5B;COLLATE coll_name];\r\n<\/pre>\n<p><strong>Syntax Explanation:<\/strong><\/p>\n<ul>\n<li>The syntax starts with the keyword \u201cCREATE DATABASE\u201d, thereby informing the MySQL Server about the type of activity to be performed. This is a mandatory keyword and cannot be omitted.<\/li>\n<li>Next comes the optional field of \u201cIF NOT EXISTS\u201d. As it\u2019s an optional field, it can be ignored. If we try to create a database that already exists and we have not mentioned this optional keyword then it will throw an error.<\/li>\n<li>Character set is a legal set of characters that are valid in a string in MySQL. This is an optional clause and if not mentioned the default character set of latin1 is used.<\/li>\n<li>Collate is a set of rules to be used to compare characters of a particular character set. This is an optional clause and if not mentioned, the default collate of latin1_swedish_ci is used.<\/li>\n<li>Next, will be the database name and it has to be unique.<\/li>\n<li>One needs to have CREATE DATABASE privilege in order to execute this command.<\/li>\n<li>In other databases, like DB2, there is a difference between database and schema. Its like, the database is a group of schemas and schemas are a group of tables.<\/li>\n<li>But in MySQL, a schema is synonymous with the database. Therefore, database or schema are groups of tables.<\/li>\n<li>This implies that the following syntax will achieve the same results as the one we have discussed above.<\/li>\n<\/ul>\n<pre>CREATE SCHEMA [IF NOT EXISTS] db_name;<\/pre>\n<h3>MySQL Create Database Example<\/h3>\n<p>We will show a step-by-step process to create a database and schema as well. The output should help you understand the fact that schema is synonymous with the database.<\/p>\n<p><strong>#1)<\/strong> Open MySQL Workbench for Executing the \u201cCreate Database\u201d query.<\/p>\n<p><a href=\"https:\/\/www.softwaretestinghelp.com\/wp-content\/qa\/uploads\/2020\/11\/1.-Create-Database.png\"><img decoding=\"async\" class=\"alignnone size-full wp-image-148394\" src=\"https:\/\/www.softwaretestinghelp.com\/wp-content\/qa\/uploads\/2020\/11\/1.-Create-Database.png\" alt=\"1. Create Database\" width=\"722\" height=\"289\" srcset=\"https:\/\/www.softwaretestinghelp.com\/wp-content\/qa\/uploads\/2020\/11\/1.-Create-Database.png 722w, https:\/\/www.softwaretestinghelp.com\/wp-content\/qa\/uploads\/2020\/11\/1.-Create-Database-300x120.png 300w\" sizes=\"(max-width: 722px) 100vw, 722px\" \/><\/a><\/p>\n<p><strong>#2)<\/strong> To see the output of the executed query, press the \u201cRefresh\u201d button (as highlighted in the image below). This will result in showing up of the new database under the Schemas. Also, note the information under the output tab which depicts the successful completion of the query.<\/p>\n<p><a href=\"https:\/\/www.softwaretestinghelp.com\/wp-content\/qa\/uploads\/2020\/11\/2.-Output-of-the-execute-query.png\"><img decoding=\"async\" class=\"alignnone size-full wp-image-148395\" src=\"https:\/\/www.softwaretestinghelp.com\/wp-content\/qa\/uploads\/2020\/11\/2.-Output-of-the-execute-query.png\" alt=\"2. Output of the execute query\" width=\"631\" height=\"363\" srcset=\"https:\/\/www.softwaretestinghelp.com\/wp-content\/qa\/uploads\/2020\/11\/2.-Output-of-the-execute-query.png 631w, https:\/\/www.softwaretestinghelp.com\/wp-content\/qa\/uploads\/2020\/11\/2.-Output-of-the-execute-query-300x173.png 300w\" sizes=\"(max-width: 631px) 100vw, 631px\" \/><\/a><\/p>\n<p><strong>#3)<\/strong> Now let\u2019s create a schema and see if there is any difference. Execute a CREATE SCHEMA command with the schema name as pacificppk_schema.<\/p>\n<p><a href=\"https:\/\/www.softwaretestinghelp.com\/wp-content\/qa\/uploads\/2020\/11\/3create-a-schema.png\"><img decoding=\"async\" class=\"alignnone size-full wp-image-148396\" src=\"https:\/\/www.softwaretestinghelp.com\/wp-content\/qa\/uploads\/2020\/11\/3create-a-schema.png\" alt=\"3create a schema\" width=\"740\" height=\"353\" srcset=\"https:\/\/www.softwaretestinghelp.com\/wp-content\/qa\/uploads\/2020\/11\/3create-a-schema.png 740w, https:\/\/www.softwaretestinghelp.com\/wp-content\/qa\/uploads\/2020\/11\/3create-a-schema-300x143.png 300w\" sizes=\"(max-width: 740px) 100vw, 740px\" \/><\/a><\/p>\n<p><strong>#4)<\/strong> After executing the command, refresh the schemas to find the new schema popping up there.<\/p>\n<p><a href=\"https:\/\/www.softwaretestinghelp.com\/wp-content\/qa\/uploads\/2020\/11\/4refresh-the-schemas.png\"><img decoding=\"async\" class=\"alignnone size-full wp-image-148397\" src=\"https:\/\/www.softwaretestinghelp.com\/wp-content\/qa\/uploads\/2020\/11\/4refresh-the-schemas.png\" alt=\"4refresh the schemas\" width=\"706\" height=\"444\" srcset=\"https:\/\/www.softwaretestinghelp.com\/wp-content\/qa\/uploads\/2020\/11\/4refresh-the-schemas.png 706w, https:\/\/www.softwaretestinghelp.com\/wp-content\/qa\/uploads\/2020\/11\/4refresh-the-schemas-300x189.png 300w\" sizes=\"(max-width: 706px) 100vw, 706px\" \/><\/a><\/p>\n<p><strong>#5)<\/strong> Please do observe the results of both the queries closely. It shows that database and schema objects created by the above queries are stored in MySQL as \u201cSchemas\u201d.<\/p>\n<p><strong>#6)<\/strong> Let\u2019s learn about one more way of verifying this. It\u2019s done by executing the command:<strong><a href=\"https:\/\/www.softwaretestinghelp.com\/mysql-show-databases\/\"> SHOW DATABASES<\/a><\/strong>. This command will list all the databases that have been created under the MySQL Server that we have logged on to.<\/p>\n<p><a href=\"https:\/\/www.softwaretestinghelp.com\/wp-content\/qa\/uploads\/2020\/11\/5-SHOW-DATABASES.png\"><img decoding=\"async\" class=\"alignnone size-full wp-image-148398\" src=\"https:\/\/www.softwaretestinghelp.com\/wp-content\/qa\/uploads\/2020\/11\/5-SHOW-DATABASES.png\" alt=\"5 SHOW DATABASES\" width=\"583\" height=\"575\" srcset=\"https:\/\/www.softwaretestinghelp.com\/wp-content\/qa\/uploads\/2020\/11\/5-SHOW-DATABASES.png 583w, https:\/\/www.softwaretestinghelp.com\/wp-content\/qa\/uploads\/2020\/11\/5-SHOW-DATABASES-300x296.png 300w\" sizes=\"(max-width: 583px) 100vw, 583px\" \/><\/a><\/p>\n<p><strong>#7)<\/strong> In the above image, please observe the highlighted areas. The two objects, database, and schema that we have created are listed in it as databases. Your database is now ready to hold tables!<\/p>\n<h3>Alternate Way To Create Database<\/h3>\n<p>Apart from creating a MySQL database using commands, we can also create using the MySQL Workbench.<\/p>\n<p><strong>The below steps depict the procedure:<\/strong><\/p>\n<p><strong>#1) <\/strong>Click on the new schema symbol as shown below:<\/p>\n<p><a href=\"https:\/\/www.softwaretestinghelp.com\/wp-content\/qa\/uploads\/2020\/11\/6Click-on-the-new-schema-symbol.png\"><img decoding=\"async\" class=\"alignnone size-full wp-image-148399\" src=\"https:\/\/www.softwaretestinghelp.com\/wp-content\/qa\/uploads\/2020\/11\/6Click-on-the-new-schema-symbol.png\" alt=\"6Click on the new schema symbol\" width=\"429\" height=\"228\" srcset=\"https:\/\/www.softwaretestinghelp.com\/wp-content\/qa\/uploads\/2020\/11\/6Click-on-the-new-schema-symbol.png 429w, https:\/\/www.softwaretestinghelp.com\/wp-content\/qa\/uploads\/2020\/11\/6Click-on-the-new-schema-symbol-300x159.png 300w\" sizes=\"(max-width: 429px) 100vw, 429px\" \/><\/a><\/p>\n<p><strong>#2)<\/strong> Provide the name of the database of the schema. Please observe the character set and collate options.<\/p>\n<p><a href=\"https:\/\/www.softwaretestinghelp.com\/wp-content\/qa\/uploads\/2020\/11\/7Provide-the-name-of-the-database-of-schema.png\"><img decoding=\"async\" class=\"alignnone size-full wp-image-148400\" src=\"https:\/\/www.softwaretestinghelp.com\/wp-content\/qa\/uploads\/2020\/11\/7Provide-the-name-of-the-database-of-schema.png\" alt=\"7Provide the name of the database of schema\" width=\"505\" height=\"233\" srcset=\"https:\/\/www.softwaretestinghelp.com\/wp-content\/qa\/uploads\/2020\/11\/7Provide-the-name-of-the-database-of-schema.png 505w, https:\/\/www.softwaretestinghelp.com\/wp-content\/qa\/uploads\/2020\/11\/7Provide-the-name-of-the-database-of-schema-300x138.png 300w\" sizes=\"(max-width: 505px) 100vw, 505px\" \/><\/a><\/p>\n<p><strong>#3)<\/strong> Below image depicts the Online DDL creation based on the inputs provided above.<\/p>\n<p><a href=\"https:\/\/www.softwaretestinghelp.com\/wp-content\/qa\/uploads\/2020\/11\/8Online-DDL-creation-based-on-the-inputs.png\"><img decoding=\"async\" class=\"alignnone size-full wp-image-148401\" src=\"https:\/\/www.softwaretestinghelp.com\/wp-content\/qa\/uploads\/2020\/11\/8Online-DDL-creation-based-on-the-inputs.png\" alt=\"8Online DDL creation based on the inputs\" width=\"715\" height=\"278\" srcset=\"https:\/\/www.softwaretestinghelp.com\/wp-content\/qa\/uploads\/2020\/11\/8Online-DDL-creation-based-on-the-inputs.png 715w, https:\/\/www.softwaretestinghelp.com\/wp-content\/qa\/uploads\/2020\/11\/8Online-DDL-creation-based-on-the-inputs-300x117.png 300w\" sizes=\"(max-width: 715px) 100vw, 715px\" \/><\/a><\/p>\n<p><strong>#4)<\/strong> Completion of the MySQL Database create process is shown in the image below.<\/p>\n<p><a href=\"https:\/\/www.softwaretestinghelp.com\/wp-content\/qa\/uploads\/2020\/11\/9Completion-of-MySQL-Database-create.png\"><img decoding=\"async\" class=\"alignnone size-full wp-image-148402\" src=\"https:\/\/www.softwaretestinghelp.com\/wp-content\/qa\/uploads\/2020\/11\/9Completion-of-MySQL-Database-create.png\" alt=\"9Completion of MySQL Database create\" width=\"646\" height=\"209\" srcset=\"https:\/\/www.softwaretestinghelp.com\/wp-content\/qa\/uploads\/2020\/11\/9Completion-of-MySQL-Database-create.png 646w, https:\/\/www.softwaretestinghelp.com\/wp-content\/qa\/uploads\/2020\/11\/9Completion-of-MySQL-Database-create-300x97.png 300w\" sizes=\"(max-width: 646px) 100vw, 646px\" \/><\/a><\/p>\n<p><strong>#5)<\/strong> On refreshing the database details, we can see a new database, test_schema, being added.<\/p>\n<p><a href=\"https:\/\/www.softwaretestinghelp.com\/wp-content\/qa\/uploads\/2020\/11\/10database-details.png\"><img decoding=\"async\" class=\"alignnone size-full wp-image-148403\" src=\"https:\/\/www.softwaretestinghelp.com\/wp-content\/qa\/uploads\/2020\/11\/10database-details.png\" alt=\"10database details\" width=\"326\" height=\"397\" srcset=\"https:\/\/www.softwaretestinghelp.com\/wp-content\/qa\/uploads\/2020\/11\/10database-details.png 326w, https:\/\/www.softwaretestinghelp.com\/wp-content\/qa\/uploads\/2020\/11\/10database-details-246x300.png 246w\" sizes=\"(max-width: 326px) 100vw, 326px\" \/><\/a><\/p>\n<h3>Default Database Or Schemas<\/h3>\n<p><strong>Following are the default databases of schemas in MySQL:<\/strong><\/p>\n<ol>\n<li>information_schema<\/li>\n<li>mysql<\/li>\n<li>performance_schema<\/li>\n<li>sys<\/li>\n<\/ol>\n<h3>Operational Commands<\/h3>\n<p><strong>We can use the following commands while working with the databases:<\/strong><\/p>\n<ul>\n<li><strong>use db_name: <\/strong>This command sets the database \u201cdb_name\u201d as the default database for all DML (Data Manipulation Language) operations. We don\u2019t need to specify the DB name every time.<\/li>\n<li><strong>show databases: <\/strong>This command shows the list of all the databases, including the default databases mentioned above, present under the MySQL Server.<\/li>\n<\/ul>\n<p>The above two commands do not need DBA privileges and even with developer access, one can execute it in real-time projects.<\/p>\n<h3>MySQL Delete Database<\/h3>\n<p>So far, we have understood how to create and work with the databases in MySQL. Now, let&#8217;s learn about how to delete a database.<\/p>\n<p>Again, as mentioned above, Delete Database privilege is only with the DBAs. One cannot perform this operation with DBA access in real-time projects.<\/p>\n<p><strong>Delete Database Syntax:<\/strong><\/p>\n<pre>DROP DATABASE [IF EXISTS] db_name;<\/pre>\n<p><strong>Syntax Explanation:<\/strong><\/p>\n<p><strong>#1)<\/strong> The first keyword in the syntax, \u201cDROP\u201d, informs the MySQL Server about the DDL (Data Definition Language) to be performed.<\/p>\n<p><strong>#2)<\/strong> The second keyword in the syntax, \u201cDATABASE\u201d, informs the MySQL Server about the MySQL object on which the DDL operation is to be performed.<\/p>\n<p><strong>#3)<\/strong> \u201cIF EXISTS\u201d is an optional command. If we do not mention this command and if the database does not exist, then the SQL will return the error code. Its best practice to use it.<\/p>\n<p><strong>#4)<\/strong> \u201cdb_name\u201d is the name of the database that we intend to drop.<\/p>\n<h4>Delete Database Example<\/h4>\n<p><strong>#1)<\/strong> Execute the drop database command on the MySQL Workbench.<\/p>\n<p><a href=\"https:\/\/www.softwaretestinghelp.com\/wp-content\/qa\/uploads\/2020\/11\/11drop-database-command.png\"><img decoding=\"async\" class=\"alignnone size-full wp-image-148404\" src=\"https:\/\/www.softwaretestinghelp.com\/wp-content\/qa\/uploads\/2020\/11\/11drop-database-command.png\" alt=\"11drop database command\" width=\"740\" height=\"356\" srcset=\"https:\/\/www.softwaretestinghelp.com\/wp-content\/qa\/uploads\/2020\/11\/11drop-database-command.png 740w, https:\/\/www.softwaretestinghelp.com\/wp-content\/qa\/uploads\/2020\/11\/11drop-database-command-300x144.png 300w\" sizes=\"(max-width: 740px) 100vw, 740px\" \/><\/a><\/p>\n<p><strong>#2)<\/strong> Observe the output of the command. The MySQL database \u201ctest_schema\u201d has been removed from the list, and the execution of the command is successful.<\/p>\n<p><a href=\"https:\/\/www.softwaretestinghelp.com\/wp-content\/qa\/uploads\/2020\/11\/12output-of-the-command.png\"><img decoding=\"async\" class=\"alignnone size-full wp-image-148405\" src=\"https:\/\/www.softwaretestinghelp.com\/wp-content\/qa\/uploads\/2020\/11\/12output-of-the-command.png\" alt=\"12output of the command\" width=\"579\" height=\"391\" srcset=\"https:\/\/www.softwaretestinghelp.com\/wp-content\/qa\/uploads\/2020\/11\/12output-of-the-command.png 579w, https:\/\/www.softwaretestinghelp.com\/wp-content\/qa\/uploads\/2020\/11\/12output-of-the-command-300x203.png 300w\" sizes=\"(max-width: 579px) 100vw, 579px\" \/><\/a><\/p>\n<h3>Frequently Asked Questions<\/h3>\n<p><span style=\"color: #ff6600;\"><strong>Q #1) How do I create a new database in MySQL?<\/strong><\/span><\/p>\n<p><strong>Answer:<\/strong> Use the CREATE DATABASE command as explained in the above sections to create a database in MySQL.<\/p>\n<p><strong><span style=\"color: #ff6600;\">Q #2) How can I see the fMySQL database?<\/span><\/strong><\/p>\n<p><strong>Answer:<\/strong> Execute the command SHOW DATABASES and it will list all the databases in that particular MySQL Server.<\/p>\n<p><strong><span style=\"color: #ff6600;\">Q #3) How do I select MySQL database?<\/span><\/strong><\/p>\n<p><strong>Answer:<\/strong> Login to MySQL Server Database and execute the command \u201cUSE db_name\u201d to select the database of your choice.<\/p>\n<p><span style=\"color: #ff6600;\"><strong>Q #4) How to delete a MySQL database?<\/strong><\/span><\/p>\n<p><strong>Answer:<\/strong> Use the \u201cDROP DATABASE\u201d command to delete MySQL Database.<\/p>\n<p><span style=\"color: #ff6600;\"><strong>Q #5) I am not sure if the database name that I am creating exists on the MySQL Server. How to create a database in such a situation?<\/strong><\/span><\/p>\n<p><strong>Answer:<\/strong> While creating a database, use the option \u201cIF NOT EXISTS\u201d and it will create your database only if the db_name that you are using is not present on the MySQL Server.<\/p>\n<h2>Conclusion<\/h2>\n<p>With this course, we have tried to explain about a database in MySQL, how to create a database, differences between databases and schemas, default databases and schemas available in MySQL, and last, steps to perform MySQL Delete Database.<\/p>\n\r\n\t\t\t<div id=\"daexthefup-container\"\r\n\t\t\t\tclass=\"daexthefup-container daexthefup-layout-stacked daexthefup-alignment-center\"\r\n\t\t\t\tdata-post-id=\"144364\">\r\n\r\n\t\t\t\t<div class=\"daexthefup-feedback\">\r\n\t\t\t\t\t<div class=\"daexthefup-text\">\r\n\t\t\t\t\t\t<h3 class=\"daexthefup-title\">Was this helpful?<\/h3>\r\n\t\t\t\t\t<\/div>\r\n\t\t\t\t\t<div class=\"daexthefup-buttons-container\">\r\n\t\t\t\t\t\t<div class=\"daexthefup-buttons\">\r\n\t\t\t\t\t\t\t\r\n\t\t\t<div class=\"daexthefup-yes daexthefup-button daexthefup-button-type-icon\" data-value=\"1\">\r\n\t\t\t\t\r\n                <svg>\r\n                    <defs>\r\n                        <style>.thumb-up-cls-1{fill:#c9c9c9;}.thumb-up-cls-2{fill:#e1e1e1;}.thumb-up-cls-3{fill:#676767;}<\/style>\r\n                    <\/defs>\r\n                    <g id=\"thumb_up\">\r\n                        <path class=\"thumb-up-cls-2 daexthefup-icon-circle\" d=\"m24,3c11.58,0,21,9.42,21,21s-9.42,21-21,21S3,35.58,3,24,12.42,3,24,3m0-1C11.85,2,2,11.85,2,24s9.85,22,22,22,22-9.85,22-22S36.15,2,24,2h0Z\" \/>\r\n                        <g>\r\n                            <rect class=\"thumb-up-cls-3 daexthefup-icon-secondary-color\" x=\"10\" y=\"20\" width=\"6\" height=\"15\" rx=\"1.5\" ry=\"1.5\" \/>\r\n                            <path class=\"thumb-up-cls-1 daexthefup-icon-primary-color\" d=\"m30.57,9.06l-.49-.1c-.81-.17-1.61.35-1.78,1.16l-5.3,11.74c-.17.81,3.16,1.61,3.97,1.78l1.96.41c.81.17,1.61-.35,1.78-1.16l2.18-10.27c.34-1.61-.7-3.21-2.31-3.56Z\" \/>\r\n                            <path class=\"thumb-up-cls-1 daexthefup-icon-primary-color\" d=\"m38.17,20h-18.67c-.83,0-1.5.67-1.5,1.5v12c0,.83.67,1.5,1.5,1.5h16.27c.71,0,1.33-.5,1.47-1.21l2.4-12c.19-.93-.53-1.8-1.47-1.8Z\" \/>\r\n                        <\/g>\r\n                    <\/g>\r\n                <\/svg>\t\t\t<\/div>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t<div class=\"daexthefup-no daexthefup-button daexthefup-button-type-icon\" data-value=\"0\">\r\n\t\t\t\t\r\n                <svg>\r\n                    <defs>\r\n                        <style>.thumb-down-cls-1{fill:#c9c9c9;}.thumb-down-cls-2{fill:#e1e1e1;}.thumb-down-cls-3{fill:#676767;}<\/style>\r\n                    <\/defs>\r\n                    <g id=\"thumb_down\">\r\n                        <path class=\"thumb-down-cls-2 daexthefup-icon-circle\" d=\"m24,3c11.58,0,21,9.42,21,21s-9.42,21-21,21S3,35.58,3,24,12.42,3,24,3m0-1C11.85,2,2,11.85,2,24s9.85,22,22,22,22-9.85,22-22S36.15,2,24,2h0Z\" \/>\r\n                        <g>\r\n                            <rect class=\"thumb-down-cls-3 daexthefup-icon-secondary-color\" x=\"10\" y=\"13\" width=\"6\" height=\"15\" rx=\"1.5\" ry=\"1.5\" \/>\r\n                            <path class=\"thumb-down-cls-1 daexthefup-icon-primary-color\" d=\"m30.57,38.94l-.49.1c-.81.17-1.61-.35-1.78-1.16l-5.3-11.74c-.17-.81,3.16-1.61,3.97-1.78l1.96-.41c.81-.17,1.61.35,1.78,1.16l2.18,10.27c.34,1.61-.7,3.21-2.31,3.56Z\" \/>\r\n                            <path class=\"thumb-down-cls-1 daexthefup-icon-primary-color\" d=\"m38.17,28h-18.67c-.83,0-1.5-.67-1.5-1.5v-12c0-.83.67-1.5,1.5-1.5h16.27c.71,0,1.33.5,1.47,1.21l2.4,12c.19.93-.53,1.8-1.47,1.8Z\" \/>\r\n                        <\/g>\r\n                    <\/g>\r\n                <\/svg>\t\t\t<\/div>\r\n\r\n\t\t\t\t\t\t\t\t\t<\/div>\r\n\t\t\t\t\t<\/div>\r\n\t\t\t\t<\/div>\r\n\r\n\t\t\t\t<div class=\"daexthefup-comment\">\r\n\t\t\t\t\t<div class=\"daexthefup-comment-top-container\">\r\n\t\t\t\t\t\t<label id=\"daexthefup-comment-label\" class=\"daexthefup-comment-label\"><\/label>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"daexthefup-comment-character-counter-container\">\r\n\t\t\t\t\t\t\t\t<div id=\"daexthefup-comment-character-counter-number\"\r\n\t\t\t\t\t\t\t\t\tclass=\"daexthefup-comment-character-counter-number\"><\/div>\r\n\t\t\t\t\t\t\t\t<div class=\"daexthefup-comment-character-counter-text\"><\/div>\r\n\t\t\t\t\t\t\t<\/div>\r\n\t\t\t\t\t\t\t\t\t\t\t<\/div>\r\n\t\t\t\t\t<textarea id=\"daexthefup-comment-textarea\" class=\"daexthefup-comment-textarea\"\r\n\t\t\t\t\t\t\t\tplaceholder=\"Type your message\"\r\n\t\t\t\t\t\t\t\tmaxlength=\"\r\n\t\t\t\t\t\t\t\t400\t\t\t\t\t\t\t\t\t\"><\/textarea>\r\n\t\t\t\t\t<div class=\"daexthefup-comment-buttons-container\">\r\n\t\t\t\t\t\t<button class=\"daexthefup-comment-submit daexthefup-button\">Submit<\/button>\r\n\t\t\t\t\t\t<button class=\"daexthefup-comment-cancel daexthefup-button\">Cancel<\/button>\r\n\t\t\t\t\t<\/div>\r\n\t\t\t\t<\/div>\r\n\r\n\t\t\t\t<div class=\"daexthefup-successful-submission-text\">Thanks for your feedback!<\/div>\r\n\r\n\t\t\t<\/div>\r\n\r\n\t\t\t","protected":false},"excerpt":{"rendered":"<p>This tutorial explains the steps to Create a Database in MySQL with syntax and examples. Also includes how to delete a database with an example: In MySQL, to perform any of the operations, the primary necessity is of the availability of a database. A database holds various tables within it, &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"MySQL Create Database &#8211; How To Create A Database In MySQL\" class=\"read-more button\" href=\"https:\/\/www.softwaretestinghelp.com\/mysql-create-database\/#more-144364\" aria-label=\"Read more about MySQL Create Database &#8211; How To Create A Database In MySQL\">Read more<\/a><\/p>\n","protected":false},"author":9,"featured_media":144525,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"_acf_changed":false,"_helpful_pro_status":1,"footnotes":""},"categories":[603],"tags":[],"class_list":{"0":"post-144364","1":"page","2":"type-page","3":"status-publish","4":"has-post-thumbnail","6":"category-mysql"},"acf":[],"_links":{"self":[{"href":"https:\/\/www.softwaretestinghelp.com\/wp-json\/wp\/v2\/pages\/144364","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.softwaretestinghelp.com\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.softwaretestinghelp.com\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.softwaretestinghelp.com\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/www.softwaretestinghelp.com\/wp-json\/wp\/v2\/comments?post=144364"}],"version-history":[{"count":0,"href":"https:\/\/www.softwaretestinghelp.com\/wp-json\/wp\/v2\/pages\/144364\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.softwaretestinghelp.com\/wp-json\/wp\/v2\/media\/144525"}],"wp:attachment":[{"href":"https:\/\/www.softwaretestinghelp.com\/wp-json\/wp\/v2\/media?parent=144364"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.softwaretestinghelp.com\/wp-json\/wp\/v2\/categories?post=144364"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.softwaretestinghelp.com\/wp-json\/wp\/v2\/tags?post=144364"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}