构建大数据insert select

<h1>数据库表</h1> <p><img src="https://www.showdoc.cc/server/api/common/visitfile/sign/045cdfa463f3ba87d757605b62e8e28e?showdoc=.jpg" alt="" /></p> <h1>插入语句</h1> <pre><code>insert into agency(id,name,addr,pid) value(REPLACE(UUID(),'-',''),'nzh','BeiJin','0');</code></pre> <h1>指数级插入语句</h1> <p>重复执行，就可构建大量数据</p> <pre><code>insert into agency(id,name,addr,pid) select REPLACE(UUID(),'-',''),name,addr,pid from agency;</code></pre>