mysql中exeits用法_Windows下MySql几个基础操作

1.停止/启动mysql服务

C:\Users\Eliefly>net stop mysql

The MySQL service is stopping....

The MySQL service was stopped successfully.

C:\Users\Eliefly>net start mysql

The MySQL service is starting..

The MySQL service was started successfully.

2.进入mysql

D:\work\WSGI>mysql -u root -p

Enter password: ******

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

Your MySQL connection id is 8

Server version: 5.7.11 MySQL Community Server (GPL)

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

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>

3.创建数据库

mysql> create database mydatabase;

Query OK, 1 row affected (0.00 sec)

mysql> show databases;

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

| Database |

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

| information_schema |

| crashcourse |

| mydatabase |

| mysql |

| performance_schema |

| sys |

| test |

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

7 rows in set (0.00 sec)

mysql>

4.删除数据库

mysql> drop database mydatabase;

Query OK, 0 rows affected (0.11 sec)

mysql> show databases;

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

| Database |

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

| information_schema |

| crashcourse |

| mysql |

| performance_schema |

| sys |

| test |

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

6 rows in set (0.00 sec)

mysql>

5.使用mydatabase数据库，切换进入

`mysql> use mydatabase;`

`Database changed`

6.创建表格，查看数据库中的表格

mysql> create table orders_copy

-> (

-> order_num int not null auto_increment,

-> order_date datetime not null,

-> cust_id int not null,

-> primary key(order_num)

-> )engine=innodb;

Query OK, 0 rows affected (0.20 sec)

mysql> show tables;

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

| Tables_in_mydatabase |

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

| orders_copy |

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

1 row in set (0.00 sec)

7.删除表格

mysql> drop table orders_copy;

Query OK, 0 rows affected (0.25 sec)

mysql> show tables;

Empty set (0.00 sec)

8.清空表中的数据

truncate table [tablename];

9.执行sql脚本，在已连接database的情况下

mysql> source D:\SQL script\create.sql

Query OK, 0 rows affected (0.49 sec)

Query OK, 0 rows affected (0.29 sec)

...

mysql>