You might be interested in how to install MySQL in windows, check up this link for details.
- Run MySQL workbench after clicking Finish
In the MySQL workbench, copy below scripts to create a new database called “MyBooks”:
create database MyBooks
Select the above script line, then click the thunder icon to execute the sql statement
A new DB is created, as shown in the left DB group:
Next create some table, using below scripts:
create table books
id INT NOT NULL AUTO_INCREMENT,
Now the DB and tables are ready. Next, let’s start programming mysql database.