sql工作总结

mysql> create database test03;
Query OK, 1 row affected
/在命令列界面创界库

mysql> create table em3(
    -> ID int,
    -> Name varchar(255),
    -> Salary varchar(255),
    -> DeparmentId varchar(255)
    -> )
    -> ;
Query OK, 0 rows affected
/在库的命令列界面创建表

mysql> select database()
    -> ;
+------------+
| database() |
+------------+
| c1         |
+------------+
1 row in set
/在命令列界面查询当前所在库

mysql> show tables like 'em3';
+--------------------+
| Tables_in_c1 (em3) |
+--------------------+
| em3                |
+--------------------+
1 row in set
/在命令列界面查询表所在库