#!/bin/bash # 设置变量 BACKUP_DIR="/app/backsql" # 本地备份目录 MYSQL_USER="" # MySQL 用户名 MYSQL_PASSWORD="" # MySQL 密码 MYSQL_HOST="mysql..com" # MySQL 服务器地址 MYSQL_PORT="3306" # MySQL 端口号 DATABASE_NAME="" # 要备份的数据库名称 BAC...

SELECT t1.* FROM table_name AS t1 JOIN (SELECT ROUND(RAND()*(SELECT MAX(id) FROM table_name)) AS id) AS t2 WHERE t1.id>=t2.id ORDER BY t1.id LIMIT 1;

where FIND_IN_SET(id,‘xxxx’)

场景:插入一条数据,这条数据的ID是自增的主键.需要在插入的时候拿到这个IDnpm i mysql conn.query(sql,(err,data)=>{ console.log(data.insertId) })