Mysql

目录

 docker run mysql

创建和删除数据库

docker备份数据库

---

 docker run mysql

docker run --name mysql -e MYSQL_ROOT_PASSWORD=password -d mysql:tag

创建和删除数据库

创建数据库语句

create database testdb DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

删除数据库

drop database testdb;

docker备份数据库

docker exec mysql mysqldump -uroot -ppassword testdb > /backup/testdb_backup.sql;

docker-compose.yml 示例：可使用.yml或.yaml作为文件扩展名

mysql：

version:"3.0"

services:
  mysql:
    image:mysql:5.7
    container_name:mysqlname
    privileged: true
    ports:
    - "3306:3306"
    environment:
      MYSQL_ROOT_PASSWORD:password
      volumes:
      - './suzhudir/db:/var/lib/mysql'
      - './mysql-conf:/etc/mysql/conf.d'

nginx：

version:"3.2"

services:
  mynginx:
    image:nginx
    restart: always
    container_name:mynginx
    ports:
    - "80:80"
    volumes:
    - './nginx.conf:/etc/nginx/nginx.conf'
    - './myjars:/workspace/myjars'
    - './logs:/logs'

使用rownum

SELECT CONCAT('202303',LPAD(@rownum:=@rownum+1,7,'0'))
FROM (SELECT @rownum:=0) seq;