一个向mysql中插入测试数据时常用的sql语句,提高开发效率
INSERT INTO driver
.tb_dealer_meeting_question
(id
,
openid
,
comment
,
question
,
createtime
)
VALUES (NULL,
FLOOR(10+(RAND()*100)),
CONCAT(‘测试评论’,FLOOR(888+(RAND()*999))),
FLOOR(1+(RAND()*4)) ,
UNIX_TIMESTAMP());
mysql中插入动态自定义数据,开发自测常用
最新推荐文章于 2024-03-11 16:07:15 发布