很简单的MySQL入门，MySQL连接Pycharm

1.安装MySQL

1.1 window上安装MySQL

https://blog.csdn.net/qq_39652397/article/details/124022739

1.2 Linux/UNIX 上安装 MySQL

https://blog.csdn.net/qq_39652397/article/details/124022739

2.PyCharm尝试连接数据库

2.1

https://jingyan.baidu.com/article/046a7b3eadec2bb8c37fa92c.html

2.2

https://blog.51cto.com/u_13682316/5017857

3.测试

3.1测试数据库

连接数据库

C:\Users\ren>mysql -u root -p
Enter password: ****

# 查看数据库
SHOW DATABASES;
# 创建数据库
CREATE DATABASE mydata;
# 选择数据库
USE mydata;
# 创建数据表
CREATE TABLE IF NOT EXISTS `mytable` (id INT NOT NULL AUTO_INCREMENT,a varchar(100), b varchar(100), PRIMARY KEY (`id`) )engine INNODB charset utf8;
# 查看表
SHOW TABLES;
# 写入一行数据
INSERT INTO mytable (a, b) VALUES (1, 2);
# 查看数据
SELECT * FROM mytable;

3.2查看PyCharm中已创建数据