The basic use of MySQL database is based on workbench

Part I: MySQL installation tutorial for Windows

The first step Download the installation package in MySQL website: dev.mysql.com/downloads/w…

The second step



The third step



The fourth step



Step 5

Step 6



Step 7

Step 8

Part two: Configuring the environment

Step 2 Open advanced System Settings, click Environment Variables and add the bin path to path

The third step



The fourth step

Part three: the basic code of the database

Creata database db_name; Create table tb_name Creates a database. Drop database db_name; Drop TABLE tb_name Drop a table. Show database create db_name; Run the following command to query details about a database: show table create db_name; Insert into tb_name values(); insert into tb_name values(); insert into tb_name values(); Field constraint *

Three common data types

• Int Integer type

  

• Float decimal type

  

• Char String type

  

• Small data table creation examples

  

  conclusionDatabase statements are actually very close to people, most of the statements can be by a command statement such as (create, SELECT,drop,show,)+ table or database English (table,database)+ the corresponding database and table name to complete. In Workbench tests, the running database is saved directly to the system and does not disappear with an error or a closed page. So when you want to test again, you should drop the database created last time and test again.