Use PyMysql to insert 100,000 pieces of data into the database

import pymysql

conn = pymysql.connect(host='www.litemall360.com',port=3306,user='root',
                       password='123456',database='litemall',charset='utf8')

cursor = conn.cursor()
sql1 = "INSERT INTO `litemall`.`litemall_goods` (`id`, `goods_sn`, `name`, `category_id`, `brand_id`, `gallery`, `keywords`, `brief`, `is_on_sale`, `sort_order`, `pic_url`, `share_url`, `is_new`, `is_hot`, `unit`, `counter_price`, `retail_price`, `detail`, `add_time`, `update_time`, `deleted`) VALUES ( {}, {}, 'Mother's Day Gift-Comfortable Sleep Set', {}, '1001020', '["http://yanxuan.nosdn.127.net/355efbcc32981aa3b7869ca07ee47dac.jpg\ ", "http://yanxuan.nosdn.127.net/43e283df216881037b70d8b34f8846d3.jpg", "http://yanxuan.nosdn.127.net/12e41d7e5dabaf9150a8bb45c41cf422.jpg\\ ", "http://yanxuan.nosdn.127.net/5c1d28e86ccb89980e6054a49571cdec.jpg"]', '', 'Safety and comfort are the best gifts', '1\ ', '1', 'http://yanxuan.nosdn.127.net/1f67b1970ee20fd572b7202da0ff705d.png', '', '1', '0', 'pieces' , '2618.00', '2598.00', '<p><img src="http://yanxuan.nosdn.127.net/3ddfe10db43f7df33ba82ae7570ada80.jpg" _src="http://yanxuan.nosdn.127.net/3ddfe10db43f7df33ba82ae7570ada80.jpg\ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/7682b7930b4776ce032f509c24a74a1e.jpg" _src="http://yanxuan.nosdn.127.net/7682b7930b4776ce032f509c24a74a1e .jpg\ " style=""/></p><p><IMG SRC = \\ "http://yanxuan.nosdn.127.net/e0bb6a50e27681925bb26bceb67ef4.jpg " _src = \\ "http://yanxuan.nosdn.net/bbb6 A50E27681925C5BBB26BCEB67EF4.jpg \ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/ba63b244c74ce06fda82bb6a29cc0f71.jpg" _src="http://yanxuan.nosdn.127.net/ba63b244c74ce06fda82bb6a29cc0f71.jpg\ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/3c7808c3a4769bad5af4974782f08654.jpg" _src="http://yanxuan.nosdn.127.net/3c7808c3a4769bad5af4974782f08654.jpg \ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/71798aaac23a91fdab4d77e1b980a4df.jpg" _src="http://yanxuan.nosdn.127.net/71798aaac23a91fdab4d77e1b980a4df.j pg\ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/c88cbb2dd2310b732571f49050fe4059.jpg" _src="http://yanxuan.nosdn.127.net/c88cbb2dd2310b732571f49050fe4059.jpg \ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/5dfdcd654e0f3076f7c05dd9c19c15ea.jpg" _src="http://yanxuan.nosdn.127.net/5dfdcd654e0f3076f7c05dd9c19c15ea.j pg\ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/bd55d6ef7af69422d8d76af10ee70156.jpg" _src="http://yanxuan.nosdn.127.net/bd55d6ef7af69422d8d76af10ee70156.jpg\ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/bae571b22954c521b35e446d652edc1d.jpg" _src="http://yanxuan.nosdn.127.net/bae571b22954c521b35e446d652edc1d.j pg\ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/e709c4d9e46d602a4d2125e47110f6ae.jpg" _src="http://yanxuan.nosdn.127.net/e709c4d9e46d602a4d2125e47110f6ae .jpg\ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/83e41915035c418db177af8b1eca385c.jpg" _src="http://yanxuan.nosdn.127.net/83e41915035c418db177af8b1eca385c.j pg\ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/f42c561e6935fe3e0e0873653da78670.jpg" _src="http://yanxuan.nosdn.127.net/f42c561e6935fe3e0e0873653da78670.j pg\ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/8317726fbae80b98764dc4c6233a913e.jpg" _src="http://yanxuan.nosdn.127.net/8317726fbae80b98764dc4c6233a913e .jpg\ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/ba904b7c948b8015db2171435325270f.jpg" _src="http://yanxuan.nosdn.127.net/ba904b7c948b8015db2171435325270f .jpg\ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/4969c73d0d8f29bffb69529c96ca4889.jpg" _src="http://yanxuan.nosdn.127.net/4969c73d0d8f29bffb69529c96ca4889.j pg\ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/d80b9b8c5c31031d1cd5357e48748632.jpg" _src="http://yanxuan.nosdn.127.net/d80b9b8c5c31031d1cd5357e487486 32.jpg\ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/3fe79bdae40662a7b1feed3179d3dd1f.jpg" _src="http://yanxuan.nosdn.127.net/3fe79bdae40662a7b1feed3179d3dd1f.jpg\ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/79eef059963b12479f65e782d1dca128.jpg" _src="http://yanxuan.nosdn.127.net/79eef059963b12479f65e782d1dca128.j pg\ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/e5a8f64f4297ccc01b41df98b0f252c8.jpg" _src="http://yanxuan.nosdn.127.net/e5a8f64f4297ccc01b41df98b0f252c8 .jpg\ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/a940b9e9525c4861407e4c3b07b02977.jpg" _src="http://yanxuan.nosdn.127.net/a940b9e9525c4861407e4c3b07b029 77.jpg\ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/224b8b81cbe12e4ad060a50f1e26601a.jpg" _src="http://yanxuan.nosdn.127.net/224b8b81cbe12e4ad060a50f1e26601a.j pg\ " style=""/></p><p><IMG SRC = \\ "http://yanxuan.nosdn.127.net/85e151647452fad718Effb7b18e2.jpg " _src = \\ "http://yanxuan.nosdn.net/85ET/85e1515151515ET/85ET/85ET/85ET/85ET/85ET/85ET/85ET/85e1515ET/85e15ET/8ET/8et 1647452fad718Effb7b7b1adc18e2.jpg \ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/d47444ff3bb9dc0aa4ab1f9b84d83768.jpg" _src="http://yanxuan.nosdn.127.net/d47444ff3bb9dc0aa4ab1f9b84d83768.jpg \ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/136262743f0c849cc0c55c8e7963dd7e.jpg" _src="http://yanxuan.nosdn.127.net/136262743f0c849cc0c55c8e7963dd7e.j pg\ " style=""/></p><p><IMG SRC = \\ "http://yanxuan.nosdn.127.net/331a97cbaff5b25a3b08ed7cdfe29.jpg " _src = \\ "http://yanxuan.nosdn.net/331a99 7CBFF5B25A3B08ED7CDFE29DF9.jpg \ " style=""/></p><p><IMG SRC = \\ "http: //yanxuan.nosdn.127.net/89b450a8a8a8a8a8a8a8a8a8a8a8a8a8a8a8a8a8a8a8a8a8a8a8a8a8a8a8a8a8a8a8a 0AA0A8AFE1DB566DCAD926F1fe8.jpg \ " style=""/></p><p><IMG SRC = \\ "http://yanxuan.nosdn.127.net/cf94f94f13b7280a97573fa78.jpg " _src = \\ "http://yanxuan.nosdn.net/c1cf9 4F13B7280A97E751cebe573FA78.jpg \ " style=""/></p><p><IMG SRC = \\ "http://yanxuan.nosdn.127.net/1822c23Def83B77607C24237EEC74.jpg " _src = \\ "http://yanxuan.nosdn.net/1822c/1822c 23DEF83B77E7607C24237EEC74.jpg \ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/2af234312b3914d6d0bc316f92134614.jpg" _src="http://yanxuan.nosdn.127.net/2af234312b3914d6d0bc316f92134614 .jpg\ " style=""/></p><p><IMG SRC = \\ "http: //yanxuan.nosdn.127.net/c4f8ab2b38132754a8bedcf902d26.jpg " _src = \\ "http://yanxuan.nosdn.net/c4F8a B2B3813275D954A8BEDCF902D26.jpg \ " style=""/></p><p><IMG SRC = \\ "http://yanxuan.nosdn.127.net/42F18842FF0C949C4401AE47bb61.jpg " _src = \\ "http://yanxuan.nosdn.net/42F18 842ff0c92ed849c4401ae47bb61.jpg \ " style=""/></p><p><IMG SRC = \\ "http://yanxuan.nosdn.127.net/a8ea64a35799e50ab31ecb6534.jpg " _src = \\ "http://yanxuan.nosdn.net/a8ea6ea66ea66ea6ea6 4A35799E50AB31ECB65345fe8f4.jpg \ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/18759fa90cd153bdd744280807c3c155.jpg" _src="http://yanxuan.nosdn.127.net/18759fa90cd153bdd744280807c3c155.j pg\ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/431f00d068a8e747959deb3b7bdd495a.jpg" _src="http://yanxuan.nosdn.127.net/431f00d068a8e747959deb3b7bdd495a.j pg\ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/5bd3b44f1f4c627bfa39f7809e866ec6.jpg" _src="http://yanxuan.nosdn.127.net/5bd3b44f1f4c627bfa39f7809e866ec6.j pg\ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/7fc36778fe2f6129b9c26e8298c5be7e.jpg" _src="http://yanxuan.nosdn.127.net/7fc36778fe2f6129b9c26e8298c5be7e.j pg\ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/c568432e3d5ab6786cd9dcae8008891b.jpg" _src="http://yanxuan.nosdn.127.net/c568432e3d5ab6786cd9dcae8008891b.j pg\ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/ec82ff5aecafa48807117da68cce2ce9.jpg" _src="http://yanxuan.nosdn.127.net/ec82ff5aecafa48807117da68cce2ce9.jpg\ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/b8ecccbed570da595e6f8a71ed4abc42c.jpg" _src="http://yanxuan.nosdn.127.net/b8ecccbed570da595e6f8a71ed4abc42c.jpg\ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/9cae1fed6ecefcd61435fe6e2c700fd6.jpg" _src="http://yanxuan.nosdn.127.net/9cae1fed6ecefcd61435fe6e2c700fd6.jpg\ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/e306a418f82777399f5e88b93cca22db.jpg" _src="http://yanxuan.nosdn.127.net/e306a418f82777399f5e88b93cca22db .jpg\ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/a66d717084e23864ce079f936557709f.jpg" _src="http://yanxuan.nosdn.127.net/a66d717084e23864ce079f936557709f .jpg\ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/6ae06c6505cdbf87a0210fe3b8727d5f.jpg" _src="http://yanxuan.nosdn.127.net/6ae06c6505cdbf87a0210fe3b8727d5f.j pg\ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/58ac2086725b0ba2fe800195f274a0b4.jpg" _src="http://yanxuan.nosdn.127.net/58ac2086725b0ba2fe800195f274a0b4.jpg \ " style=""/></p><p><IMG SRC = \\ "http: //yanxuan.nosdn.127.net/5e2e9d9eb099647FBE045AC034.jpg " _src = \\ "http://yanxuan.nosdn.127.net/5e2e9e9e9e9e9e9e9e9e9e9e9e9 D9EB099647FBE041EC6645ac034.jpg \ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/8154357c0fab82bd4e67cda9aaa128c0.jpg" _src="http://yanxuan.nosdn.127.net/8154357c0fab82bd4e67cda9aaa128c0.j pg\ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/4325763b738ec3183ecf0d82b2b28e32.jpg" _src="http://yanxuan.nosdn.127.net/4325763b738ec3183ecf0d82b2b28e32.j pg\ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/06d8ea9d10035a00f26c5c52cc601ca7.jpg" _src="http://yanxuan.nosdn.127.net/06d8ea9d10035a00f26c5c52cc601ca7.jpg \ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/499f30b9e69b5dddf3db36f105756111.jpg" _src="http://yanxuan.nosdn.127.net/499f30b9e69b5dddf3db36f105756111 .jpg\ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/ed7e1733d54e711a560edb3a76f1a60c.jpg" _src="http://yanxuan.nosdn.127.net/ed7e1733d54e711a560edb3a76f1a60c.j pg\ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/b6474347eebdb917d2e827fd526dd01c.jpg" _src="http://yanxuan.nosdn.127.net/b6474347eebdb917d2e827fd526dd01c.j pg\ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/b2c0691f9204c5ebc94b4ff678919ca7.jpg" _src="http://yanxuan.nosdn.127.net/b2c0691f9204c5ebc94b4ff678919ca7.jpg \ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/b4811e702a6884a9251d7cc9e3b06b6f.jpg" _src="http://yanxuan.nosdn.127.net/b4811e702a6884a9251d7cc9e3b06b6f .jpg\ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/d518783c054695acf329e81d597fdec3.jpg" _src="http://yanxuan.nosdn.127.net/d518783c054695acf329e81d597fdec3.jpg \ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/835ce09e785cca635c176008975053a1.jpg" _src="http://yanxuan.nosdn.127.net/835ce09e785cca635c176008975053a1.j pg\ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/769af780de81a302c0a3b03ed8e6c528.jpg" _src="http://yanxuan.nosdn.127.net/769af780de81a302c0a3b03ed8e6c528.jpg \ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/da34f99daf9141f0fe56a766461b8485.jpg" _src="http://yanxuan.nosdn.127.net/da34f99daf9141f0fe56a766461b8485.jpg \ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/d7c9cd8722a2f9a78e158ce02ec5d4f2.jpg" _src="http://yanxuan.nosdn.127.net/d7c9cd8722a2f9a78e158ce02ec5d4f2.j pg\ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/09ea18953884b15227819e326103462b.jpg" _src="http://yanxuan.nosdn.127.net/09ea18953884b15227819e326103462b .jpg\ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/5ef728213983842edf1aec27b2c1f5b6.jpg" _src="http://yanxuan.nosdn.127.net/5ef728213983842edf1aec27b2c1f5b6.jpg \ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/95409f2a884dcfeaabfe5e61fcf9ec37.jpg" _src="http://yanxuan.nosdn.127.net/95409f2a884dcfeaabfe5e61fcf9ec37.jpg\ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/6807836dc2a940ba56ea10c7a63b14c9.jpg" _src="http://yanxuan.nosdn.127.net/6807836dc2a940ba56ea10c7a63b14c9.j pg\ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/e1d976d06853e7a0e6c9cc4ab484ac8a.jpg" _src="http://yanxuan.nosdn.127.net/e1d976d06853e7a0e6c9cc4ab484ac8a.jpg \ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/47f5673dec5005092f6d897d6335966c.jpg" _src="http://yanxuan.nosdn.127.net/47f5673dec5005092f6d897d6335966c.j pg\ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/1b0109abd0e6a0d13fa2423a96c1167e.jpg" _src="http://yanxuan.nosdn.127.net/1b0109abd0e6a0d13fa2423a96c1167e.j pg\ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/916111a8f94cc0bd39375b3dcac14e35.jpg" _src="http://yanxuan.nosdn.127.net/916111a8f94cc0bd39375b3dcac14e35.j pg\ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/c1360df3d6b703c5df9b2f47a2a3d12e.jpg" _src="http://yanxuan.nosdn.127.net/c1360df3d6b703c5df9b2f47a2a3d1 2e.jpg\ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/1d5a31eb93ef873a165993bd99f29df1.jpg" _src="http://yanxuan.nosdn.127.net/1d5a31eb93ef873a165993bd99f29df1.j pg\ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/997a48948b89dd7261ed5a59ba884f45.jpg" _src="http://yanxuan.nosdn.127.net/997a48948b89dd7261ed5a59ba884f45.jpg \ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/eb96d9689735c9f4019ebf76da43b2b2.jpg" _src="http://yanxuan.nosdn.127.net/eb96d9689735c9f4019ebf76da43b2b2.jpg \ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/a92cf2172e6cafe080e4511205568d79.jpg" _src="http://yanxuan.nosdn.127.net/a92cf2172e6cafe080e4511205568d79.jpg \ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/c9e94570428f197292bb3f43609963f5.jpg" _src="http://yanxuan.nosdn.127.net/c9e94570428f197292bb3f43609963f5 .jpg\ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/37145f06cce747311692ad7f276645db.jpg" _src="http://yanxuan.nosdn.127.net/37145f06cce747311692ad7f276645db.j pg\ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/c9a698b71ed911364fc6f243006c241c.jpg" _src="http://yanxuan.nosdn.127.net/c9a698b71ed911364fc6f243006c241c .jpg\ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/e89db969711efaa441c43d6b90498a0c.jpg" _src="http://yanxuan.nosdn.127.net/e89db969711efaa441c43d6b90498a0c .jpg\ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/3803bb1a18229562f18943512b1d3524.jpg" _src="http://yanxuan.nosdn.127.net/3803bb1a18229562f18943512b1d3524 .jpg\ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/235cbb5be905ac2b87e7e8f7c8d90144.jpg" _src="http://yanxuan.nosdn.127.net/235cbb5be905ac2b87e7e8f7c8d90144.jpg \ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/3e38435b3fdbae4ee80b83995592901e.jpg" _src="http://yanxuan.nosdn.127.net/3e38435b3fdbae4ee80b83995592901e.j pg\ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/8ceb7cd3231585da60a74dd2c1aa9015.jpg" _src="http://yanxuan.nosdn.127.net/8ceb7cd3231585da60a74dd2c1aa9015.jpg \ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/e151e225c2e30aab7ccf086094381577.jpg" _src="http://yanxuan.nosdn.127.net/e151e225c2e30aab7ccf086094381577.j pg\ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/363c19306953daf10968f4aa86617997.jpg" _src="http://yanxuan.nosdn.127.net/363c19306953daf10968f4aa86617997 .jpg\ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/4237a392cf2e69b110ad4ecf35e44059.jpg" _src="http://yanxuan.nosdn.127.net/4237a392cf2e69b110ad4ecf35e44059.jpg \ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/da8ab35ada2dfe55006db01efa96e51a.jpg" _src="http://yanxuan.nosdn.127.net/da8ab35ada2dfe55006db01efa96e51a.jpg\ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/aa1d4fd00b7879db3f1051dc6d16aa87.jpg" _src="http://yanxuan.nosdn.127.net/aa1d4fd00b7879db3f1051dc6d16aa 87.jpg\ " style=""/></p><p><IMG SRC = \\ "http://yanxuan.nosdn.127.net/302A8F2D997FF22BEDCD837672CDAFC2.jpg " _src = \\ "http://yanxuan.nosdn.net/302a882a8a8 F2D997FF22BEDCD837672CDAFC2.jpg \ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/a39ff68c00522aef0472402958a334d2.jpg" _src="http://yanxuan.nosdn.127.net/a39ff68c00522aef0472402958a334d2.j pg\ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/86ccd0eb677c8b552398869d11a8917e.jpg" _src="http://yanxuan.nosdn.127.net/86ccd0eb677c8b552398869d11a8917e.j pg\ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/a6d0ede352da947060d912d903646a5d.jpg" _src="http://yanxuan.nosdn.127.net/a6d0ede352da947060d912d903646a5d.j pg\ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/e6a118bf95bdb61891409d25f193e9c4.jpg" _src="http://yanxuan.nosdn.127.net/e6a118bf95bdb61891409d25f193e9 c4.jpg\ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/c214066e9bf65d60bcebd691b5b1cbc1.jpg" _src="http://yanxuan.nosdn.127.net/c214066e9bf65d60bcebd691b5b1cbc1 .jpg\ " style=""/></p><p><IMG SRC = \\ "http://yanxuan.nosdn.127.net/c301559ba3ee280bcbfc4269bfa9ca.jpg " _src = \\ "http://yanxuan.nosdn.net/c33015 59ba3ee280BCBF2FC4269bFA9CA.jpg \ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/573748f5c12ecb4515ba00a7b6e981dc.jpg" _src="http://yanxuan.nosdn.127.net/573748f5c12ecb4515ba00a7b6e981dc.j pg\ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/27bcc8bf512a7e6f994a9683b3deea82.jpg" _src="http://yanxuan.nosdn.127.net/27bcc8bf512a7e6f994a9683b3deea82.jpg \ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/e22a4507fd1e4b5ef859035e857ae419.jpg" _src="http://yanxuan.nosdn.127.net/e22a4507fd1e4b5ef859035e857ae419.j pg\ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/27b07b4ca709c33ad71b368f87781307.jpg" _src="http://yanxuan.nosdn.127.net/27b07b4ca709c33ad71b368f87781307.j pg\ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/ef31eb48bcb133728bffda7e1239b592.jpg" _src="http://yanxuan.nosdn.127.net/ef31eb48bcb133728bffda7e1239b592.jpg\ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/5f49aaaca59c0733ec92f100d01bc0af.jpg" _src="http://yanxuan.nosdn.127.net/5f49aaaca59c0733ec92f100d01bc0af.jpg \ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/818889261deb75044e1018ec53485d85.jpg" _src="http://yanxuan.nosdn.127.net/818889261deb75044e1018ec53485d85.j pg\ " style=""/></p><p><img src="http://yanxuan.nosdn.127.net/200369f023243e2faeb18a2a0a352ef1.jpg" _src="http://yanxuan.nosdn.127.net/200369f023243e2faeb18a2a0a352ef1.jpg \ " style=""/></p><p><br/></p>', '2018-02-01 00:00:00', '2018-02-01 00:00:00', '0');"
sql2 = "INSERT INTO `litemall`.`litemall_goods_attribute` (`id`, `goods_id`, `attribute`, `value`, `add_time`, `update_time`, `deleted`) VALUES ({}, {}, 'Specifications', 'Combination 1: AB side independent spring mattress imported latex 150*200cm*1 + washable antibacterial and anti-mite silk down pillow*2.\\
Composition 2: AB side independent spring mattress imported latex 180*200cm*1 + washable antibacterial and anti-mite silk down pillow*2', '2018-02-01 00:00:00', '2018-02-01 00:00:00', \ '0');"
sql3 = "INSERT INTO `litemall`.`litemall_goods_product` (`id`, `goods_id`, `specifications`, `price`, `number`, `url`, `add_time`, `update_time`, `deleted`) VALUES ({}, {}, '["1.5m mattress*1 + pillow*2","Light apricot powder"]', '999.00' , '100', 'http://yanxuan.nosdn.127.net/1f67b1970ee20fd572b7202da0ff705d.png', '2018-02-01 00:00:00', '2018-02-01 00 :00:00', '0');"
sql4 = "INSERT INTO `litemall`.`litemall_goods_specification` (`id`, `goods_id`, `specification`, `value`, `pic_url`, `add_time`, `update_time`, `deleted`) VALUES ({} , {}, 'Specifications', '1.5m mattress*1 + pillow*2', '', '2018-02-01 00:00:00', '2018-02 -01 00:00:00', '0');"
goods_start = 100000
for i in range(100000):
    print("The {}th data has been inserted, the order number is: {}".format(i + 1,goods_start + i))
    cursor.execute(sql1.format(goods_start + i,goods_start + i,goods_start + i))
    cursor.execute(sql2.format(goods_start + i,goods_start + i))
    cursor.execute(sql3.format(goods_start + i,goods_start + i))
    cursor.execute(sql4.format(goods_start + i,goods_start + i))
conn.commit()
cursor.close()
conn.close()

result: