Shulou(Shulou.com)06/01 Report--

When you install mysql, you can install all the necessary accessories, especially mysql for excel, which is extremely convenient to import data from Excel to the database later.

Workbench is a good auxiliary software. Install the default connection by default.

Workbench defaults to the line where the input prompt is executed, remember to add the symbol ";" at the end of each line.

Each time you open workbench, which database to run: use database name

Datetime format input format: xxxx-xxxxx-xxxx xx:xx:xx

Insert into statement, if only partial columns are inserted, use: insert into table name (column 1, column 2.) values (value 1, value 2.). If all columns are inserted, use: insert into table name (value 1, value 2, value 3.). Note: all the symbols here should be in English.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.