Most Voted Solution!

CREATE DATABASE mydb;</p><br />

<p>CREATE TABLE my_table<br /><br />

(<br /><br />

my_table_id INT AUTO_INCREMENT,<br /><br />

my_table_name VARCHAR(30) NOT NULL,<br /><br />

my_foreign_key INT NOT NULL,<br /><br />

my_tb_created TIMESTAMP DEFAULT CURRENT_TIMESTAMP,<br /><br />

my_tb_updated TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, ,<br /><br />

# Any other properties here<br /><br />

PRIMARY KEY(my_table_id),<br /><br />

CONSTRAINT fk_name_of_parent_table<br /><br />

FOREIGN KEY(my_foreign_key) REFERENCES parent_table(parent_table_column)<br /><br />

);</p><br />

<p>SHOW DATABASES;

create #database #mysql #Code

The post Create Database Mysql Code Example appeared first on Stack All Flow.