对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);

posted on 2017-08-05 12:44  如风105  阅读(100)  评论(0编辑  收藏  举报

导航