mysql学习笔记

1:下载mysql ::

https://downloads.mysql.com/archives/community/

安装后配置环境创建～/.bash_profile文件并添加如下内容 ::

export PATH=${PATH}:/usr/local/mysql/bin
export DYLD_LIBRARY_PATH=/usr/local/mysql/lib/

可以安装MySQL Workbench ::

https://devk.mysql.com/downloads/workbench/

2:下载安装mysql
https://dev.mysql.com/downloads/mysql/
如果链接的是mysql数据库需要安装原生驱动mysqlclient，不需要安装 pymysql

pip3 install  -i https://pypi.tuna.tsinghua.edu.cn/simple mysqlclient

mysql -u root -p

密码：Apple_840924

show databases;

建立数据库

create DATABASE covidseq CHARACTER SET utf8;

删除数据库

drop database covidseq;

退出

exit;

进入数据库

use covidseq;

查看数据里包含那些表

show tables;

查看具体表的内容

desc fastp_book