python mysql mysqlclient MySQLdb

설치

pip install mysqlclient

모듈 로드

import MySQLdb

데이터베이스 연결

connection = MySQLdb.connect(
    user="username",
    passwd="password",
    host="localhost",
    db="dbname",
    charset="utf8"
)

커서 추출

cursor = connection.cursor()

업데이트 쿼리

# create table note ( title varchar(100), content text )
cursor.execute("insert into note(title, content) values(%s,%s)", ("a", "b"))
connection.commit()

조회 쿼리

sql = "select * from note where title=%s"
cursor.execute(sql, ('a',))

for row in cursor.fetchall():
    print(row)  # ('a', 'b')

Dict 커서로 변경

cursor = connection.cursor(MySQLdb.cursors.DictCursor)

cursor.execute(sql, ('a',))
for row in cursor.fetchall():
    print(row)  # {'title': 'a', 'content': 'b'}
    print(row['title'], row['content'])     # a b

연결 종료

connection.close()

mysql drop table if exists

DROP TABLE IF EXISTS `table name`;


https://dev.mysql.com/doc/refman/8.0/en/drop-table.html
https://stackoverflow.com/questions/20155989/if-table-exists-drop-table-then-create-it-if-it-does-not-exist-just-create-it

javascript date clone and equal comparison

d1 = new Date()
d2 = new Date(d1)
d3 = new Date(d1.getTime())

d1.getTime() === d2.getTime()
d1.valueOf() === d3.valueOf()

https://stackoverflow.com/questions/1090815/how-to-clone-a-date-object/11051108#11051108
https://stackoverflow.com/questions/7244513/javascript-date-comparisons-dont-equal