链接：https://pan.baidu.com/s/1YZ6ZN-fUnwBxJO3geo6PUw 

提取码：28ri 

 

Microsoft Windows [版本 10.0.19043.1165]

(c) Microsoft Corporation。保留所有权利。

 

C:\Users\Gavin>mysql -hlocalhost  -u Gavin -p

Enter password: ******

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 9

Server version: 8.0.26 MySQL Community Server - GPL

 

Copyright (c) 2000, 2021, Oracle and/or its affiliates.

 

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

 

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

 

mysql> show databases;

+--------------------+

| Database           |

+--------------------+

| gavin              |

| information_schema |

| mysql              |

| performance_schema |

| sakila             |

| sys                |

| world              |

+--------------------+

7 rows in set (0.02 sec)

 

mysql> use gavin

Database changed

mysql> show tables;

+-----------------+

| Tables_in_gavin |

+-----------------+

| orders          |

| test01          |

| testbinary      |

| testbit         |

| testchar        |

| testdate        |

| testdatetime    |

| testenum        |

| testenum2       |

| testset         |

| testtext        |

| testtimestamp   |

+-----------------+

12 rows in set (0.00 sec)

 

mysql> drop database gavin;

Query OK, 12 rows affected (0.17 sec)

 

mysql> create table testyunsuan(

    -> a int(11),

    -> b float,

    -> c decimal(5,2)

    -> );

ERROR 1046 (3D000): No database selected

mysql> create database test;

Query OK, 1 row affected (0.01 sec)

 

mysql> create table testyunsuan(

    -> a int(11),

    -> b float,

    -> c decimal(5,2)

    -> );

ERROR 1046 (3D000): No database selected

mysql> use test ;

Database changed

mysql> create table testyunsuan(

    -> a int(11),

    -> b float,

    -> c decimal(5,2)

    -> );

Query OK, 0 rows affected, 1 warning (0.06 sec)

 

mysql> insert into table test values(1,2,3);

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'table test values(1,2,3)' at line 1

mysql> insert into table testyunsuan values(1,2,3);

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'table testyunsuan values(1,2,3)' at line 1

mysql> insert into table testyunsuan values(1,2,3.00);