1.安装mysql-installer-community-8.0.19.0.msi(过程中设置root密码)
2.配置环境变量
3.常用语句有
//1.开关服务
cd C:\Program Files\MySQL\MySQL Server 8.0\bin //在bin下操作
mysqld --console //开启(暂有未知错误)
mysqladmin -uroot -p... shutdown //关闭 ...换成密码
//2.登录,查看
mysql -uroot -p...
show databases; //不分大小写
use database; //database替换
show tables;
select * from table1; //table1替换
//3.创建数据库
create database books;
mysqladmin -u root -p create books; //普通用户登录时;
//4.删除数据库
drop database books;
mysqladmin -u root -p drop books; //普通用户登录时;
//5.创建表
create table table_name(col_name col_type);
eg:
CREATE TABLE IF NOT EXISTS `runoob_tbl`(
`runoob_id` INT UNSIGNED AUTO_INCREMENT,
`runoob_title` VARCHAR(100) NOT NULL,
`runoob_author` VARCHAR(40) NOT NULL,
`submission_date` DATE,
PRIMARY KEY ( `runoob_id` )
)ENGINE=InnoDB DEFAULT CHARSET=utf8;
//6.删除表
drop table table_name;
//7.插入表
insert into table_name (field1,field2,field3)
values
(value1,value2,value3);
//8.操作示例:
UPDATE runoob_tbl SET runoob_title='学习 C++' WHERE runoob_id=3;
DELETE FROM runoob_tbl WHERE runoob_id=3;
SELECT * from runoob_tbl WHERE runoob_author LIKE '%COM';
//9.退出
exit
更高级用法 https://www.runoob.com/mysql/mysql-union-operation.html
4.执行sql文件
mysql -uroot -proot
use database;
source result.sql ; //绝对路径,或者当前文件夹下。
5.出现mysql无法启动时,没有data文件夹和my.ini时,参考:解决方案