You can use a php script to create MySQL table.<\/p>\n
Example.<\/strong><\/p>\n [php]<?php \/\/ Create connection \/\/ sql to create table if ($conn->query($sql) === TRUE) { $conn->close(); Code Explanation:<\/strong><\/p>\n First, we have to use the code to connect the server.<\/p>\n \/\/ Create connection Once the connection is successfully establish the next step is creating a MySQL table. To do that we will run the MySQL query.<\/p>\n In the $sql query we are asking php script to In the next line of php, we are checking if the connection is successfully achieve by using if statement.<\/p>\n In the if statement we are checking both the connection If everything goes well as per the script then you will see a new entry in your mysql table.<\/p>\n","protected":false},"excerpt":{"rendered":" You can use a php script to create MySQL table. Example. [php]<?php $servername = "localhost"; $username = "username"; $password = "password"; $dbname = "myDB"; \/\/<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-373","post","type-post","status-publish","format-standard","hentry","category-php"],"_links":{"self":[{"href":"https:\/\/www.mddir.com\/how-to\/wp-json\/wp\/v2\/posts\/373","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mddir.com\/how-to\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.mddir.com\/how-to\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.mddir.com\/how-to\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mddir.com\/how-to\/wp-json\/wp\/v2\/comments?post=373"}],"version-history":[{"count":1,"href":"https:\/\/www.mddir.com\/how-to\/wp-json\/wp\/v2\/posts\/373\/revisions"}],"predecessor-version":[{"id":374,"href":"https:\/\/www.mddir.com\/how-to\/wp-json\/wp\/v2\/posts\/373\/revisions\/374"}],"wp:attachment":[{"href":"https:\/\/www.mddir.com\/how-to\/wp-json\/wp\/v2\/media?parent=373"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mddir.com\/how-to\/wp-json\/wp\/v2\/categories?post=373"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mddir.com\/how-to\/wp-json\/wp\/v2\/tags?post=373"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n$servername = "localhost";
\n$username = "username";
\n$password = "password";
\n$dbname = "myDB";<\/p>\n
\n$conn = new mysqli($servername, $username, $password, $dbname);
\n\/\/ Check connection
\nif ($conn->connect_error) {
\n die("Connection failed: " . $conn->connect_error);
\n} <\/p>\n
\n$sql = "CREATE TABLE MyGuests (
\nid INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
\nfirstname VARCHAR(30) NOT NULL,
\nlastname VARCHAR(30) NOT NULL,
\nemail VARCHAR(50),
\nreg_date TIMESTAMP
\n)";<\/p>\n
\n echo "Table MyGuests created successfully";
\n} else {
\n echo "Error creating table: " . $conn->error;
\n}<\/p>\n
\n?>[\/php]<\/p>\n$servername = \"localhost\";
\n$username = \"username\";
\n$password = \"password\";
\n$dbname = \"myDB\";<\/p>\n
\n$conn = new mysqli($servername, $username, $password, $dbname);
\n\/\/ Check connection
\nif ($conn->connect_error) {
\n die(\"Connection failed: \" . $conn->connect_error);
\n} <\/code><\/p>\n
\n$sql = \"CREATE TABLE MyGuests (
\nid INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
\nfirstname VARCHAR(30) NOT NULL,
\nlastname VARCHAR(30) NOT NULL,
\nemail VARCHAR(50),
\nreg_date TIMESTAMP
\n)\";<\/code><\/p>\nCREATE TABLE myGuests<\/code>. In myGuest table, we will be having different columns. <\/p>\nid<\/code> – The id represents the integer value means it will hold the numbers. We have assigned the AUTO_INCREMENT condition which will increase the number by 1 when new entry added to the database. It has given the value PRIMARY KEY which means it will be always unique. You can add duplicate value to the PRIMARY Key.<\/p>\nfirstname<\/code> – In this column, we will be adding text value which will consider the VARCHAR. The NOT NULL condition says you can’t keep it blank. There has to be some value in this field.<\/p>\nlastname <\/code>– In this column similar to the firstname we have instructed the mysql to give the condition VARCHAR with NOT NULL value.<\/p>\nemail <\/code>– The email field has the VARCHAR value with no special condition. It means it can be run without adding any value to it.<\/p>\nreg_date <\/code>– Is the statement to add default date to the column.<\/p>\nif ($conn->query($sql) === TRUE) {
\n echo \"Table MyGuests created successfully\";
\n} else {
\n echo \"Error creating table: \" . $conn->error;
\n}<\/code><\/p>\n$conn<\/code> which represents the server connection and query($sql)<\/code> represents the mysql connection. The identical check operator is used to see whether the value is TRUE or not. According to the outcome, the echo statement is generated.<\/p>\n