MySQL数据库操作

目录

mySql数据库操作常用命令

1. 启动MySQL服务

2. 创建数据库mydata1

3. 导入数据库到mydata1

4. 导出数据到文件

---

mySql数据库操作常用命令

.\mysqld.exe -install
net start MySQL

.\mysql -uroot -p
 show databases;
 create database mydata1;
use mydata1;
source d:\manager\mydata20220622.sql
quit

//导出数据库
.\mysqldump -uroot -p mydata1 > d:mydata1_off_20221124.sql

;停止MySQL服务
net stop MySQL
;启动MySQL服务
net start MySQL

//删除数据表指定日期前的数据条
use mydata1;
show tables;
select * from testout;
select * from testinfo;
DELETE FROM testout
WHERE Time < '2023-10-20';
DELETE FROM testinfo
WHERE Time < '2023-10-22';

//导入数据库
cd "c:\Program Files (x86)\MySQL\MySQL Server 5.6\bin"
.\mysql -uroot -p
create database mydata2;
use mydata2;
source F:\mydata2_20231201.sql
quit

1. 启动MySQL服务

2. 创建数据库mydata1

3. 导入数据库到mydata1

4. 导出数据到文件