Metadata-Version: 2.4
Name: krtool
Version: 1.0.0
Summary: Perform simple operations on the MySQL database without entering SQL commands.
Author: Xuchang Su
Author-email: krlrtear@163.com
Keywords: python,windows,mysql
Classifier: Development Status :: 1 - Planning
Classifier: Intended Audience :: Developers
Classifier: Programming Language :: Python :: 3
Classifier: Operating System :: Microsoft :: Windows
Description-Content-Type: text/markdown
Requires-Dist: pymysql
Dynamic: author
Dynamic: author-email
Dynamic: classifier
Dynamic: description
Dynamic: description-content-type
Dynamic: keywords
Dynamic: requires-dist
Dynamic: summary


# Krlrtear's Toolbox



## Installation

```shell

pip3 install krtool

pip3 uninstall krtool

```



## Table of Contents



- MySQL

  - closeconnect 关闭连接

  - closecursor 关闭游标

  - refreshcursor 重载游标

  - getcolumnname 按序获取列名

  - fetchone 同fetchone

  - fetchmany 执行多次fetchone

  - fetchall 同fetchall

  - select 同select，数据保存在游标，通过fetch获取

  - selectitems 查找返回指定行数据

  - insert 插入行数据

  - update 更新行数据

  - delete 删除行数据
