pycharm编写python，图中import MySQLdb没问题，import mysql.connector出错，为什么会出错？ python中mysqldb模块在pycharm叫什么
python\u53ef\u4ee5import mysqldb\uff0c\u4f46\u662fpycharm\u65e0\u6cd5 import mysqldb\uff01\u82e6\u607c~\u90a3\u662f\u56e0\u4e3apycharm\u8bbe\u7f6e\u7684python\u73af\u5883\u4e0d\u6b63\u786e
file\u2014\u2014settings
Project\uff1apythons\u2014\u2014project interpreter
\u8fdb\u53bb\u4e4b\u540eproject interpreter\u9009\u62e9\u4f60\u7684python\u5b89\u88c5\u8def\u5f84\u4fdd\u5b58\u5c31ok\u4e86
\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0cMySQLdb\u5305\u662f\u6ca1\u6709\u5b89\u88c5\u7684\uff0c\u4e0d\u4fe1\uff1f \u770b\u5230\u7c7b\u4f3c\u4e0b\u9762\u7684\u4ee3\u7801\u4f60\u5c31\u4fe1\u4e86\u3002
\u590d\u5236\u4ee3\u7801\u4ee3\u7801\u5982\u4e0b:
-bash-3.2# /usr/local/python2.7.3/bin/python get_cnblogs_news.py
Traceback (most recent call last):
File "get_cnblogs_news.py", line 9, in
import MySQLdb
ImportError: No module named MySQLdb
\u8fd9\u65f6\u6211\u4eec\u5c31\u4e0d\u5f97\u4e0d\u5b89\u88c5MySQLdb\u5305\u4e86\u3002\u5b89\u88c5\u5176\u5b9e\u4e5f\u633a\u7b80\u5355\uff0c\u5177\u4f53\u6b65\u9aa4\u5982\u4e0b\uff1a
1\u3001\u4e0b\u8f7d MySQL for Python
\u5730\u5740\uff1ahttp://sourceforge.net/projects/mysql-python/files/mysql-python/
\u6211\u8fd9\u91cc\u5b89\u88c5\u7684\u662f1.2.3\u7248\u672c
\u590d\u5236\u4ee3\u7801\u4ee3\u7801\u5982\u4e0b:
wget http://sourceforge.net/projects/mysql-python/files/mysql-python/1.2.3/MySQL-python-1.2.3.tar.gz
2\u3001\u89e3\u538b
\u590d\u5236\u4ee3\u7801\u4ee3\u7801\u5982\u4e0b:
tar zxvf MySQL-python-1.2.3.tar.gz
3\u3001\u5b89\u88c5
\u590d\u5236\u4ee3\u7801\u4ee3\u7801\u5982\u4e0b:
$ cd MySQL-python-1.2.3
$ python setup.py build
$ python setup.py install
\u6ce8\uff1a
\u5982\u679c\u5728\u6267\u884c\uff1apython setup.py build \u9047\u5230\u4ee5\u4e0b\u9519\u8bef\uff1a
\u590d\u5236\u4ee3\u7801\u4ee3\u7801\u5982\u4e0b:
EnvironmentError: mysql_config not found
\u9996\u5148\u67e5\u627emysql_config\u7684\u4f4d\u7f6e\uff0c\u4f7f\u7528
find / -name mysql_config \uff0c\u6bd4\u5982\u6211\u7684\u5728/usr/local/mysql/bin/mysql_config
\u4fee\u6539setup_posix.py\u6587\u4ef6\uff0c\u572826\u884c\uff1a
mysql_config.path = \u201cmysql_config\u201d \u4fee\u6539\u4e3a\uff1a
\u590d\u5236\u4ee3\u7801\u4ee3\u7801\u5982\u4e0b:
mysql_config.path = \u201c/usr/local/mysql/bin/mysql_config\u201d
你好：
python3.6的是引入
pip3 install PyMySQL
#!/usr/bin/python3
import pymysql
# 打开数据库连接db = pymysql.connect("localhost","testuser","test123","TESTDB" )
# 使用cursor()方法获取操作游标 cursor = db.cursor()
# SQL 插入语句sql = """INSERT INTO EMPLOYEE(FIRST_NAME,
LAST_NAME, AGE, SEX, INCOME)
VALUES ('Mac', 'Mohan', 20, 'M', 2000)"""try: # 执行sql语句
cursor.execute(sql)
# 提交到数据库执行
db.commit()except: # 如果发生错误则回滚
db.rollback()
# 关闭数据库连接db.close()
祝你工作顺利。谢谢！
需要安装的，python2可以使用 pip命令安装 ，python3的话建议使用 pip3命令安装
需要安装
pip install mysql-connector
绛旓細Python缂栫▼甯哥敤鐨勮蒋浠舵槸Python IDLE鍜PyCharm銆侾ython IDLE鏄疨ython鑷甫鐨勯泦鎴愬紑鍙戠幆澧冿紝瀹冩槸瀛︿範Python缂栫▼鐨勪竴涓緢濂界殑宸ュ叿銆侾ython IDLE鍖呮嫭浜嗕唬鐮佺紪杈戝櫒銆佸懡浠よ鍜屼氦浜掑紡瑙ｉ噴鍣ㄣ傚畠鐨勭晫闈㈢畝鍗曠洿瑙傦紝闈炲父閫傚悎鍒濆鑰呭叆闂ㄥ涔燩ython璇█鐨勫熀纭鐭ヨ瘑銆傚悓鏃讹紝Python IDLE杩樻敮鎸佷唬鐮佽皟璇曞拰浠ｇ爜浼樺寲绛夊姛鑳斤紝鍙互甯姪寮鍙...
绛旓細缂栧啓python婧愪唬鐮佺殑杞欢.棣栨帹鐨Pycharm銆PyCharm鐢ㄤ簬bai涓鑸琁DE鍏峰鐨勫姛鑳斤紝姣斿锛 璋冭瘯銆佽娉曢珮浜丳roject绠＄悊銆乨u浠ｇ爜璺宠浆銆佹櫤鑳芥彁绀恒佽嚜鍔ㄥ畬zhi鎴愩佸崟鍏冩祴璇曘佺増鏈帶鍒 鍙﹀锛孭yCharm杩樻彁渚涗簡涓浜涘緢濂界殑鍔熻兘鐢ㄤ簬Django寮鍙戯紝鍚屾椂鏀寔Google App Engine锛屾洿閰风殑鏄紝PyCharm鏀寔IronPython銆傚叾娆℃槸sublime text...
绛旓細3)绗笁鐐规槸锛孭ython鏄竴涓В閲婂櫒锛孭ycharm鏄竴绉嶄笓闂ㄤ负Python缂栫▼璇█璁捐鐨処DE(闆嗘垚寮鍙戠幆澧)锛屼娇鐢Pycharm缂栧啓Python绋嬪簭锛屽苟鏈缁堝緱鍒癙ython瑙ｉ噴鍣ㄧ殑鏀寔锛岃繖涓ょ鏂规硶閮藉彲浠ヤ娇鐢;4)绗洓鐐规槸锛屽崟鐙笅杞戒竴涓狿ycharm骞朵笉閫傜敤锛岃繕闇瑕佷笅杞絇ython鐨勮В閲婂櫒銆傚皬浼欎即浠渶瑕佷簡瑙ｇ殑鏄細Pycharm鏄疨ython IDE锛屽嵆闆嗘垚...
绛旓細鎮ㄥ彲浠ヤ娇鐢ㄤ竴涓凡缁忓瓨鍦ㄧ殑virtualenv鎴栦粠PyCharm鍒涘缓涓涓柊鐨(Settings鈫扨roject Interpreter鈫Python Interpreters)銆傚浜庤繖涓」鐩,鎴戝皢鍒涘缓涓涓柊鐨剉irtualenv骞朵娇鍏剁敤浜庢墍鏈夌殑椤圭洰:鎮ㄥ彲浠ュ揩閫熸悳绱,闃呰璇存槑,骞朵粠PyCharm瀹夎杞欢鍖呫傛病鏈変粈涔堟槸浣犲湪鍦ㄧ粓绔笂涓嶈兘鍋氱殑,浣嗗畠鑳藉浣夸綘鏃犻渶绂诲紑IDE,鏇村姞鏂逛究鍦板鎼滅储鍖呫備竴浜...
绛旓細pycharm鍜宲ython鍖哄埆濡備笅锛1銆佸畠浠殑涓嬭浇鍦板潃鍜屽畨瑁呯殑鏂瑰紡涓嶅悓銆2銆乸ython鏄竴绉嶅熀鏈紪璇戠幆澧冿紝灏卞儚java鍜宩ar涓鏍枫俻ycharm鏄竴绉嶉泦鎴愬紑鍙戠幆澧冿紝涓轰簡鑳藉璁╀綘蹇熺紪鍐欎唬鐮侊紝渚夸簬璋冭瘯銆3銆佺畝鍗曟潵璇达細Python鏄釜瑙ｉ噴鍣紝pycharm鏄负Python缂栫▼璇█涓撻棬鎵撻犵殑涓娆綢DE锛堥泦鎴愬紑鍙戠幆澧冿級銆傚湪pycharm涓缂栧啓Python绋嬪簭...
绛旓細pycharm閰嶇疆python鐜鐨勬柟娉曟槸锛1銆佷緷娆＄偣鍑汇怓ile銆戙併怭roject Interpreter銆戯紱2銆佺偣鍑汇怱how All銆戯紝閫夋嫨銆怑xisting Environment銆戯紱3銆侀夋嫨python鐨勫畨瑁呰矾寰勶紝鐐瑰嚮OK鍗冲彲銆傞厤缃柟娉曪細锛堟帹鑽愬涔狅細Python鍏ラ棬鏁欑▼锛1銆佹墦寮杞欢锛屼緷娆＄偣鍑汇怓ile銆戔啋銆怱ettings銆戔啋銆怭roject銆戔啋銆怭roject Interpreter銆戯紝杩欐牱...
绛旓細缂栧啓python婧愪唬鐮佺殑杞欢.棣栨帹鐨Pycharm銆PyCharm鐢ㄤ簬bai涓鑸琁DE鍏峰鐨勫姛鑳斤紝姣斿锛 璋冭瘯銆佽娉曢珮浜丳roject绠＄悊銆乨u浠ｇ爜璺宠浆銆佹櫤鑳芥彁绀恒佽嚜鍔ㄥ畬zhi鎴愩佸崟鍏冩祴璇曘佺増鏈帶鍒 鍙﹀锛孭yCharm杩樻彁渚涗簡涓浜涘緢濂界殑鍔熻兘鐢ㄤ簬Django寮鍙戯紝鍚屾椂鏀寔Google App Engine锛屾洿閰风殑鏄紝PyCharm鏀寔IronPython銆傚叾娆℃槸sublime text...
绛旓細鍚屾牱鎷ユ湁浠樿垂鐗堬紙涓撲笟鐗堬級鍜屽厤璐瑰紑婧愮増锛堢ぞ鍖 鐗堬級锛PyCharm涓嶈鏄湪Windows, Mac OS X绯荤粺涓, 杩樻槸鍦↙inux绯荤粺涓兘鏀寔蹇熷畨瑁呭拰浣跨敤銆傚紑绠卞嵆鐢紝PyCharm鐩存帴鏀寔Python寮鍙戠幆澧冿紝鎵撳紑涓涓柊鐨勬枃浠剁劧鍚庡氨鍙互寮濮缂栧啓浠ｇ爜銆備綘涔熷彲浠ュ湪PyCharm涓洿鎺ヨ繍琛屽拰璋冭瘯 Python绋嬪簭锛屽苟涓斿畠鏀寔婧愮爜绠＄悊鍜岄」鐩
绛旓細Python绋嬪簭濡備笅(娉ㄦ剰鍥句腑婧愪唬鐮佺殑缂╄繘)锛1锛墂eek=['MON','TUE','WED','THU','FRI','SAT','SUN']while True:n=int(input("璇疯緭鍏ユ暟瀛1~7锛堣緭鍏0缁撴潫锛夛細"))if n==0:print("绋嬪簭缁撴潫!")break elif 1<=n and n<=7:print(week[n-1])else:print("璇烽噸鏂拌緭鍏")锛2锛塶=int(input...
绛旓細銆Python 3.9.7杞欢銆嬬櫨搴︾綉鐩樿祫婧愬厤璐逛笅杞:閾炬帴: https://pan.baidu.com/s/1BY60FGfwL3exK7xOooF_nw ?pwd=nhfc 鎻愬彇鐮: nhfc Python 3.9.7鏈鏂版寮忕増鏄竴绉嶉潰鍚戝璞°佺洿璇戝紡璁＄畻鏈虹▼搴忚璁¤瑷锛屼篃鏄竴绉嶅姛鑳藉己澶ц屽畬鍠勭殑閫氱敤鍨嬭瑷锛屽凡缁忓叿鏈夊崄澶氬勾鐨勫彂灞曞巻鍙诧紝鎴愮啛涓旂ǔ瀹氥python鍏锋湁闈炲父绠鎹...
