FilesExpand file tree

master

/

update.py

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

12 lines (7 loc) · 307 Bytes

master

/

update.py

Copy path

Top

File metadata and controls

• Code
• Blame

12 lines (7 loc) · 307 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

import MySQLdb

db = MySQLdb.connect("localhost", "test", "abc@123", "testdb", charset='utf8')

cursor = db.cursor()

cursor.execute("UPDATE student SET address=%s WHERE address=%s",

['TP.Hà Nội', 'Hà Nội'])

db.commit()

db.close()