[Python]SQLiteへデータを更新(update)するサンプル

2021年8月13日

書式
sqlite3.connect(r’dbパス名’)

使用例

# coding: utf-8

import sqlite3

#SQLiteに接続

conn = sqlite3.connect(r'D:\arkgame\sample.db')

c = conn.cursor()

try:

c.execute("update usertbl set uname=?,depno=? where uid=10",('User01','dep01'))

c.execute("update usertbl set uname=:uname,depno=:r1 where uid=20",('User02','dep02'))

#例外処理

except sqlite3.Error as e:

print("error",e.args[0])

#反映

conn.commit()

#接続を閉じる

conn.close()

# coding: utf-8 import sqlite3 #SQLiteに接続 conn = sqlite3.connect(r'D:\arkgame\sample.db') c = conn.cursor() try: c.execute("update usertbl set uname=?,depno=? where uid=10",('User01','dep01')) c.execute("update usertbl set uname=:uname,depno=:r1 where uid=20",('User02','dep02')) #例外処理 except sqlite3.Error as e: print("error",e.args[0]) #反映 conn.commit() #接続を閉じる conn.close()

# coding: utf-8
import sqlite3

#SQLiteに接続
conn = sqlite3.connect(r'D:\arkgame\sample.db')

c = conn.cursor()

try:

      c.execute("update usertbl set uname=?,depno=? where uid=10",('User01','dep01'))
      c.execute("update usertbl set uname=:uname,depno=:r1 where uid=20",('User02','dep02'))

#例外処理
except sqlite3.Error as e:
      print("error",e.args[0])
#反映
conn.commit()

#接続を閉じる
conn.close()

Python

Posted by arkgame

関連投稿: