对guanglanroadvoltage 表添加随机测试数据的代码,仅支持添加一条数据

 insert into guanglanroadvoltage values(id,floor(rand()*50),floor(rand()*50),floor(rand()*50),floor(rand()*50),floor(rand()*50),floor(rand()*50),CURRENT_TIMESTAMP);
 
 insert into guanglanroadvoltage values(id,floor(rand()*10),floor(rand()*50),floor(rand()*50),floor(rand()*50),floor(rand()*50),floor(rand()*50),floor(rand()*50),floor(rand()*50),floor(rand()*50),floor(rand()*50),floor(rand()*50),floor(rand()*50),floor(rand()*50),CURRENT_TIMESTAMP);
原文地址:https://www.cnblogs.com/jimorulang/p/7289915.html