Mysql 随机数据 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; 2021-09-15 11:41:41 未分类 mysql ·
MySql拿到插入的ID 场景:插入一条数据,这条数据的ID是自增的主键.需要在插入的时候拿到这个IDnpm i mysql conn.query(sql,(err,data)=>{ console.log(data.insertId) }) 2021-04-16 04:40:31 mysql ·