파이썬 SQL1

• 

  [Python] 22. [DBMS] Sqlite3 + Python 연동 실습, 140자 일기장 만들기 01. Sqlite3 + Python 연동 실습1. SQL ▷ /sqlite3/diary140.sql ------------------------------------------------------------------------------------- CREATE TABLE diary ( diary_id INTEGER PRIMARY KEY AUTOINCREMENT, createdate DATETIME, note CHAR(140) ); CREATE TABLE diary_img ( img_id INTEGER PRIMARY KEY AUTOINCREMENT, img BLOB, diary_id INTEGER, FOREIGN KEY(diary_id) REFERENCES diary(diary_id) ); SELE.. 빅데이터 프로그래밍/Python 2017. 8. 5.