跳到主要內容


Python-資料庫-mysql-pymysql

Python
資料庫
mysql-pymysql

安裝:
linux、mac:pip3 install PyMySql
windows    : 之後補充

import pymysql.cursors

connection = pymysql.connect(host='ip',
user='root', password='password', db='database_name',charset='utf8mb4',
cursorclass=pymysql.cursors.DictCursor)

#    CREATE TABLE `users` (
#    `id` int(11) NOT NULL AUTO_INCREMENT,
#    `email` varchar(255) COLLATE utf8_bin NOT NULL,
#    `password` varchar(255) COLLATE utf8_bin NOT NULL,
#    PRIMARY KEY (`id`)
#) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin
#AUTO_INCREMENT=1 ;


with connection.cursor() as cursor:
    sql = "INSERT INTO `users` (`email`, `password`) VALUES (%s, %s)"
    cursor.execute(sql, ('ab123ab456g@example.com', 'very-secret'))

connection.commit()

with connection.cursor() as cursor:
    sql = "SELECT `id`, `password` FROM `users` WHERE `email`=%s"
    cursor.execute(sql, ('ab123ab456g@example.com',))
    result = cursor.fetchone()
    print(result)


with connection.cursor() as cursor:
    sql = "Update  `password`=%s FROM `users` WHERE `email`=%s"
    cursor.execute(sql, ('new_password','ab123ab456g@example.com'))

with connection.cursor() as cursor:
    sql = "Delete FROM `users` WHERE `email`=%s"
    cursor.execute(sql, ('ab123ab456g@example.com'))

connection.close()


程式碼說明

匯入module
建立connection
#字號後面建立table的SQL語法
第一個cursor,Insert
第二個cursor,Search
第三個cursor,Update
第四個cursor,Delete
sql:sql語法
cursor:指標的概念
execute:執行指令
close:一定要關閉

這邊在看的重點是,如何建立連結、如何執行指令

留言

這個網誌中的熱門文章

程式語言學習概論(1)

程式語言 介紹

語言學習-English-Lights

Song Lyric Title : Lights Singer :Ellie Goulding Album :  Bright Lights Release Date :  2011 I had a way then losing it all on my own I had a heart then but the queen has been overthrown And I'm not sleeping now the dark is too hard to beat And I'm not keeping up the strength I need to push me You show the lights that stop me turn to stone You shine it when I'm alone And so I tell myself that I'll be strong And dreaming when they're gone 'Cause they're calling, calling, calling me home Calling, calling, calling home You show the lights that stop me turn to stone You shine them when I'm alone Noises, I play within my head Touch my own skin and hope they'll still be there And I think back to when my brother and my sister slept In and on my place the only time I feel safe You show the lights that stop me turn to stone You shine it when I'm alone And so I tell myself that I'...

Python-資料庫

Python 資料庫 基本概念說明 參考程式語言概念- 資料庫內容 。 對於這邊的介紹其實,主要是對基本語法、資料庫的基本操作進行說明,所以大多只會看到語法指令,而不會深究內容,因為其內容會在SQL跟noSQL的文章內容進行說明,這邊說明會讓篇幅太多。 常見的資料庫 SQL:MySQL NoSQL:Mongodb 以下是處理該類型檔案對應函式或模組 資料庫名稱 模組 MySql MySQLdb mysqlclient PyMySQL mysql.connector peewee SQLAlchemy Mongodb pymongo PyMySQL 用python全實作的model,需要下SQL語法。 範例- 連結 SQLAlchemy 用ORM的概念做出來,支援各種SQL資料庫。 範例- 連結 pymongo 專門用來連結mongodb的module 範例- 連結