#?-*-?coding=utf-8?-*-
import?MySQLdb
account?=?input（‘請輸入MySQL用戶名\n?>‘）
password?=?input（‘請輸入MySQL密碼\n?>‘）
table?=?input（‘請輸入數據庫名稱\n?>‘）
#?連接數據庫
db?=?MySQLdb.connect（‘localhost‘account?str（password）?table）
#?獲取游標
cursor?=?db.cursor（）
sql?=?“““CREATE?TABLE?lianjia（
????title?VARCHAR（30）
????LOCATION?VARCHAR（100）
????ZONE?VARCHAR（10）
????METERS?VARCHAR（10）
????DIRECTION?VARCHAR（10）
????MONEY?VARCHAR（10）
）
“““
#?執行sql語句
cursor.execute（sql）
#?關閉數據庫
db.close（）

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-01-08?04:02??LianjiaSpider-master\
?????文件??????????65??2018-01-08?04:02??LianjiaSpider-master\.gitattributes
?????文件????????1063??2018-01-08?04:02??LianjiaSpider-master\LICENSE
?????文件?????????435??2018-01-08?04:02??LianjiaSpider-master\README.md
?????文件?????????543??2018-01-08?04:02??LianjiaSpider-master\database.py
?????目錄???????????0??2018-01-08?04:02??LianjiaSpider-master\screenshots\
?????文件?????1452678??2018-01-08?04:02??LianjiaSpider-master\screenshots\mysql.png
?????目錄???????????0??2018-01-08?04:02??LianjiaSpider-master\src\
?????目錄???????????0??2018-01-08?04:02??LianjiaSpider-master\src\LianjiaSpider\
?????文件???????????0??2018-01-08?04:02??LianjiaSpider-master\src\LianjiaSpider\__init__.py
?????目錄???????????0??2018-01-08?04:02??LianjiaSpider-master\src\LianjiaSpider\__pycache__\
?????文件?????????152??2018-01-08?04:02??LianjiaSpider-master\src\LianjiaSpider\__pycache__\__init__.cpython-36.pyc
?????文件?????????456??2018-01-08?04:02??LianjiaSpider-master\src\LianjiaSpider\__pycache__\items.cpython-36.pyc
?????文件????????1590??2018-01-08?04:02??LianjiaSpider-master\src\LianjiaSpider\__pycache__\middlewares.cpython-36.pyc
?????文件????????1164??2018-01-08?04:02??LianjiaSpider-master\src\LianjiaSpider\__pycache__\pipelines.cpython-36.pyc
?????文件?????????795??2018-01-08?04:02??LianjiaSpider-master\src\LianjiaSpider\__pycache__\proxy_middleware.cpython-36.pyc
?????文件?????????688??2018-01-08?04:02??LianjiaSpider-master\src\LianjiaSpider\__pycache__\settings.cpython-36.pyc
?????文件????????2857??2018-01-08?04:02??LianjiaSpider-master\src\LianjiaSpider\__pycache__\useragent_middleware.cpython-36.pyc
?????文件?????????656??2018-01-08?04:02??LianjiaSpider-master\src\LianjiaSpider\items.py
?????文件????????1911??2018-01-08?04:02??LianjiaSpider-master\src\LianjiaSpider\middlewares.py
?????文件?????????917??2018-01-08?04:02??LianjiaSpider-master\src\LianjiaSpider\pipelines.py
?????文件?????????392??2018-01-08?04:02??LianjiaSpider-master\src\LianjiaSpider\proxy_middleware.py
?????文件????????3704??2018-01-08?04:02??LianjiaSpider-master\src\LianjiaSpider\settings.py
?????目錄???????????0??2018-01-08?04:02??LianjiaSpider-master\src\LianjiaSpider\spiders\
?????文件????????1705??2018-01-08?04:02??LianjiaSpider-master\src\LianjiaSpider\spiders\LianjiaSpider.py
?????文件?????????161??2018-01-08?04:02??LianjiaSpider-master\src\LianjiaSpider\spiders\__init__.py
?????目錄???????????0??2018-01-08?04:02??LianjiaSpider-master\src\LianjiaSpider\spiders\__pycache__\
?????文件????????1480??2018-01-08?04:02??LianjiaSpider-master\src\LianjiaSpider\spiders\__pycache__\LianjiaSpider.cpython-36.pyc
?????文件?????????160??2018-01-08?04:02??LianjiaSpider-master\src\LianjiaSpider\spiders\__pycache__\__init__.cpython-36.pyc
?????文件?????????173??2018-01-08?04:02??LianjiaSpider-master\src\LianjiaSpider\spiders\__pycache__\downloader_middleware.cpython-36.pyc
?????文件?????????932??2018-01-08?04:02??LianjiaSpider-master\src\LianjiaSpider\spiders\__pycache__\middlewares.cpython-36.pyc
............此處省略4個文件信息