Pythonใฉใคใใฉใชใmysql-connector-pythonใใ็จใใฆใMySQLใฎใใผใฟใใผในใธใใผใฟใๅ้ค๏ผๆถๅป๏ผใใๆนๆณใจใฝใผในใณใผใใซใคใใฆ็ดนไปใใพใใ
ใใผใฟใใผในใฎใใผใฟๅ้ค
Pythonใฉใคใใฉใชใmysql-connector-pythonใใงใฏใexecuteใกใฝใใใงใฏใจใชใSQLๆใงๅฎ่กใงใใพใใ
ไปๅใฏใใใ็จใใฆใMySQLใฎใใผใฟใใผในใฎใใผใฟใๅ้คใใฆใฟใพใใใ
(โปPythonใใDELETEๆใๅฎ่ก)
ใๆธๅผใ
execute(SQLๆ)
ใฝใผในใณใผใ
ใตใณใใซใใญใฐใฉใ ใฎใฝใผในใณใผใใฏไธ่จใฎ้ใใงใใ
ใDELETEๆใ
DELETE FROM ใใผใใซๅ WHERE ใซใฉใ ๅ = ๅ้คใใใใผใฟ;
โปๆๅฎใใใใผใใซใฎใซใฉใ ใซใใใใผใฟใๅ้ค
โปไธ่จใฎใตใณใใซใใญใฐใฉใ ใงใฏใใใผใใซใartoriaใใฎใซใฉใ ใnameใใซใใใใผใฟใnero claudiusใใๅ้ค
ๅฎ่ก็ตๆ
ใตใณใใซใใญใฐใฉใ ใฎๅฎ่ก็ตๆใฏไธ่จใฎ้ใใงใใ
โปไธ่จไบใงไฝๆใใใใผใฟใใผในใไฝฟใฃใฆใใพใ
ใphpMyAdminใCSVใใกใคใซใฎ่ชญใฟ่พผใฟ
[(โartoriaโ,), (‘artoria alter’,), (‘artoria lily’,), (‘artoria lancer’,), (‘artoria lancer alter’,), (‘artoria swimwear’,), (‘artoria santa alter’,), (‘mystery heroine x’,), (‘mystery heroine x alter’,)]
ใ้ข้ฃ่จไบใ
PythonใงMySQLๆไฝ
Pythonๅ
ฅ้ ใตใณใใซ้
ใณใกใณใ