MySql笔记
基本使用
DDL语句
1. 创建database
mysql> create database test1;
Query OK, 1 row affected (0.00 sec)
2. 查看datebase
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| cluster |
| mysql |
| test |
| test1 |
+--------------------+
5 rows in set (0.00 sec)
3. 使用database
mysql> use mysql
Database changed
4. 查看数据库所有表
mysql> show tables;
+---------------------------+
| Tables_in_mysql |
+---------------------------+
| columns_priv |
| db |
| event |
| func |
| general_log |
| help_category |
| help_keyword |
| help_relation |
| help_topic |
| host |
| plugin |
| proc |
| procs_priv |
| slow_log |
| tables_priv |
| time_zone |
| time_zone_leap_second |
| time_zone_name |
| time_zone_transition |
| time_zone_transition_type | 郑州治疗血管瘤的医院 http://www.zykdyjyy.com/
| user | +---------------------------+
21 rows in set (0.00 sec)
5. 删除数据库
mysql> drop database test1;
Query OK, 0 rows affected (0.00 sec)
6. 创建表
mysql> create table emp(ename varchar(10),hiredate date,sal decimal(10,2),deptno int(2));
Query OK, 0 rows affected (0.02 sec)
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/69979119/viewspace-2719489/ ，如需转载，请注明出处，否则将追究法律责任。
