Python操作mysql之插入数据
mysql> select * from log;+----+----------------+---------------------------+--------+-------+
| id | ip | url | status | total |
+----+----------------+---------------------------+--------+-------+
|1 | 1.1.1.1 | http | 200 | 66 |
|2 | 2.2.2.2 | http | 200 | 66 |
|3 | 10.200.56.80 | /api/sshpasswd/ | 200 | 1 |
|4 | 10.201.201.82| /business/add | 200 | 20 |
|5 | 10.200.56.80 | / | 403 | 1 |
|6 | 10.200.56.80 | /account/login?next=%2F | 200 | 1 |
|7 | 10.200.56.80 | /icons/apache_pb.gif | 200 | 1 |
|8 | 10.200.56.80 | /icons/unknown.gif | 200 | 1 |
|9 | 127.0.0.1 | / | 403 | 1 |
| 10 | 10.200.56.80 | /account/login_auth | 200 | 1 |
| 11 | 10.200.56.80 | /static/js/echarts.min.js | 304 | 1 |
| 12 | 10.200.56.80 | /business/collist | 200 | 2 |
| 13 | 10.200.56.80 | /business/chlist | 200 | 1 |
| 14 | 10.200.56.80 | / | 200 | 1 |
| 15 | 10.200.56.80 | /icons/text.gif | 200 | 1 |
| 16 | 10.200.56.80 | /icons/poweredby.png | 200 | 1 |
| 17 | 10.200.42.50 | /host/addscan | 200 | 1 |
| 18 | 10.200.56.80 | /icons/blank.gif | 200 | 1 |
| 19 | 10.200.56.80 | / | 302 | 1 |
| 20 | 10.200.56.80 | /icons/back.gif | 200 | 1 |
| 21 | 10.200.56.80 | /account/is_activate | 200 | 1 |
| 22 | 10.200.56.80 | /favicon.ico | 404 | 4 |
| 23 | 61.159.140.123 | /favicon.ico | 404 | 4 |
+----+----------------+---------------------------+--------+-------+
23 rows in set (0.00 sec)
页:
[1]