$ docker run --name zxj-mysql -e MYSQL_ROOT_PASSWORD=123456 -p 3306:3306  -d mysql:5.7.38
$ docker ps //用于查看container的运行状态 
$ docker exec -it mysql1 bash//用bash 执行
$ docker kill zxj-mysql //关掉容器
$ docker container start mysql1 //启动MySQL
$ mysql1 mysql -u root -p//使用root权限登录

$ CREATE DATABASE db1 CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;//创建数据库 
$ create table users(id serial,name text);//创建表 
$ show databases;//查看所有的数据库 use dataName;//使用dataName数据库 
$ show tables;//查看所有表 
$ select * from user;//查看user表的全部内容 
$ describe user;//查看user的描述字段 
$ insert into user(name,age) values('alsan',18)//插入数据 
$ delete from user where name = 'gouzi';//删除名为gouzi的数据 
$ update user set age=70 where name='aslan';//将名字为aslan的年龄更新，如果不写name会将数据库全部内容更改
$ alter table user add id serial;//添加自增长的id(序列号);

const mysql      = require('mysql');
const connection = mysql.createConnection({
  host     : 'localhost', //连接的数据库地址。（默认:localhost）
  user     : 'me',    //mysql的连接用户名
  password : 'secret',    // 对应用户的密码
  database : 'my_db'      //所需要连接的数据库的名称（可选）
});
connection.connect();
connection.query('SELECT 1 + 1 AS solution', function (error, results, fields) {
  if (error) throw error;
  console.log('The solution is: ', results[0].solution);
});
connection.end();

//test.js
const mysql= require('mysql');
const connection = mysql.createConnection({
    host: '192.168.99.100',
    port:3306,
    user: 'root',
    password: '123456',
});
connection.connect();
connection.query('CREATE DATABASE IF NOT EXISTS mydb CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;', function (error, results, fields) {
    if (error) throw error;
    console.log('创建数据库')
    console.log(results)
});
connection.query('use mydb;')
connection.query(`CREATE TABLE IF NOT EXISTS myuser(
        name text,
        age int
    )`, function (error, results, fields) {
    if (error) throw error;
    console.log('创建表')
    console.log(results)
});
connection.end();

connection.query('use mydb;')
复制代码

const { Sequelize,Model, DataTypes} = require('sequelize');
const sequelize = new Sequelize('HU', 'root', '123456', {
    host: '192.168.99.100',
    dialect: 'mysql'
});
class User extends Model {}
User.init({
    username: DataTypes.STRING,
    age:DataTypes.INTEGER
}, { sequelize, modelName: 'user' });
(async () => {
    await sequelize.sync();
    const jane = await User.create({
    username: 'janedoe',
    birthday: new Date(1980, 6, 20)
    });
    const users_name = await User.findAll({
        where: {
            username:'huanqi'
        }
    });
    console.log("All users:", JSON.stringify(users_name, null, 2));
})();