python from mycli import MyCli def main(): cli = MyCli() cli.connect(database='your_database', user='your_username', password='your_password', host='your_host') result = cli.run_query("SELECT * FROM your_table") for row in result: print(row) params = {'id': 1} result = cli.run_query("SELECT * FROM your_table WHERE id=%(id)s", params) for row in result: print(row) cli.run_query("UPDATE your_table SET column1=%s WHERE column2=%s", ('value1', 'value2')) cli.disconnect() if __name__ == '__main__': main()


上一篇:
下一篇:
切换中文