【MySQL学习】1、MySQL搭建环境（Windows、Linux在线/离线）安装

心已赠人 2022-12-06 01:14 159阅读 0赞

### 文章目录 ###

*  1、Windows安装MySQL
 *  2、Linux安装MySQL
 *   *   *  （1）Linux在线安装MySQL
         *  （2）Linux离线安装MySQL
 *  3、创建测试数据库
 *  微信公众号

# 1、Windows安装MySQL #

# 2、Linux安装MySQL #

### （1）Linux在线安装MySQL ###

### （2）Linux离线安装MySQL ###

# 3、创建测试数据库 #

后续测试都是在这个数据库的基础上，直接复制下面的内容到cmd的mysql中一粘贴就完事了

create database demo_01 default charset=utf8mb4;
    
    use demo_01;
    
    CREATE TABLE `city` (
      `city_id` int(11) NOT NULL AUTO_INCREMENT,
      `city_name` varchar(50) NOT NULL,
      `country_id` int(11) NOT NULL,
      PRIMARY KEY (`city_id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    
    CREATE TABLE `country` (
      `country_id` int(11) NOT NULL AUTO_INCREMENT,
      `country_name` varchar(100) NOT NULL,
      PRIMARY KEY (`country_id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    
    
    insert into `city` (`city_id`, `city_name`, `country_id`) values(1,'西安',1);
    insert into `city` (`city_id`, `city_name`, `country_id`) values(2,'NewYork',2);
    insert into `city` (`city_id`, `city_name`, `country_id`) values(3,'北京',1);
    insert into `city` (`city_id`, `city_name`, `country_id`) values(4,'上海',1);
    
    insert into `country` (`country_id`, `country_name`) values(1,'China');
    insert into `country` (`country_id`, `country_name`) values(2,'America');
    insert into `country` (`country_id`, `country_name`) values(3,'Japan');
    insert into `country` (`country_id`, `country_name`) values(4,'UK');

# 微信公众号 #

![每天Get一个小技巧][Get]

[Get]: /images/20221123/78fac0778e5a4561820c85688a6dc9fa.png