Python学习笔记-pyMySQL连接MySQL数据库

下载pyMySQL模块包

 
 

 
 

  
  

   
   

    
    1
   
   
   
   

    
    2
   
   
   
   

    
    3
   
   
   
   

    
    4
   
   
   
   

    
    5
   
   
   
   

    
    6
   
   
  
  
  
  

 
 
 
 

  
  

   
   

    
    

   
   
   
   

    
    

   
   
   
   

    
    

     
     

      
      [
      
      root@
      
      kurol 
      
      ~
      
      ]# 
      
      python36 
      
      -
      
      m 
      
      pip 
      
      install 
      
      pyMySQL
     
     
    
    
    
    

     
     

      
      Collecting 
      
      pyMySQL
     
     
    
    
    
    

     
     

      
        
      
      Downloading 
      
      PyMySQL
      
      -
      
      0.7.11
      
      -
      
      py2.
      
      py3
      
      -
      
      none
      
      -
      
      any.
      
      whl 
      
      (
      
      78
      
      kB
      
      )
     
     
    
    
    
    

     
     

      
          
      
      100% |################################| 
      
      81
      
      kB 
      
      8.9
      
      kB
      
      /
      
      s 
     
     
    
    
    
    

     
     

      
      Installing 
      
      collected 
      
      packages: 
      
      pyMySQL
     
     
    
    
    
    

     
     

      
      Successfully 
      
      installed 
      
      pyMySQL
      
      -
      
      0.7.11
     
     
    
    
   
   
   
   

   
   

    
    

   
   
  
  
 
 
 
 

  
  

  
  

 
 

创建py文件

  
  

  
  

   
   

    
    

     
     1
    
    
    
    

     
     2
    
    
   
   
   
   

  
  
  
  

   
   

    
    

     
     

    
    
    
    

     
     

    
    
    
    

     
     

      
      
 
       [ 
       root@ 
       kurol  
       ~ 
       ] 
       #touch mysqltest.py 
      
     
     
     
     

      
      
 
       [ 
       root@ 
       kurol  
       ~ 
       ] 
       #vim mysqltest.py 
      
     
     
    
    
    
    

    
    

     
     

    
    
   
   
  
  
  
  

   
   

   
   

  
  

 

  
  

  
  

   
   

    
    

     
     1
    
    
    
    

     
     2
    
    
    
    

     
     3
    
    
    
    

     
     4
    
    
    
    

     
     5
    
    
    
    

     
     6
     
     
    
    
    
    

     
     7
    
    
    
    

     
     8
     
     
    
    
    
    

     
     9
    
    
    
    

     
     10
    
    
    
    

     
     11
    
    
    
    

     
     12
    
    
    
    

     
     13
    
    
    
    

     
     14
    
    
    
    

     
     15
     
     
    
    
    
    

     
     16
     
     
    
    
    
    

     
     17
    
    
    
    

     
     18
    
    
    
    

     
     19
    
    
   
   
   
   

  
  
  
  

   
   

    
    

     
     

    
    
    
    

     
     

    
    
    
    

     
     

      
      
 
       #!/usr/bin/python36 
      
     
     
     
     

      
      
 
       # -*- coding: UTF-8 -*- 
      
     
     
     
     

      
      
 
       # 
      
     
     
     
     

      
      
 
       import  
       os, 
       sys 
      
     
     
     
     

      
      
 
       import  
       pymysql 
      
     
     
     
     

      
      
 
       try: 
      
     
     
     
     

      
      

             
       conn  
       =  
       pymysql. 
       connect 
       ( 
       host 
       = 
       'localhost', 
       user 
       = 
       'root', 
       passwd 
       = 
       '', 
       db 
       = 
       'db_student' 
       ) 
      
     
     
     
     

      
      
 
       except  
       Exception  
       as  
       e: 
      
     
     
     
     

      
      

             
       print  
       ( 
       e 
       )  
      
     
     
     
     

      
      

             
       sys. 
       exit 
       ( 
       ) 
      
     
     
     
     

      
      
 
       cursor  
       =  
       conn. 
       cursor 
       ( 
       ) 
      
     
     
     
     

      
      
 
       sql  
       =  
       "select * from stu_inf" 
      
     
     
     
     

      
      
 
       cursor. 
       execute 
       ( 
       sql 
       ) 
      
     
     
     
     

      
      
 
       data  
       =  
       cursor. 
       fetchall 
       ( 
       ) 
      
     
     
     
     

      
      
 
       if  
       data: 
      
     
     
     
     

      
      

             
       for  
       x  
       in  
       data: 
      
     
     
     
     

      
      

             
       print  
       ( 
       x 
       [ 
       0 
       ], 
       x 
       [ 
       1 
       ], 
       x 
       [ 
       2 
       ], 
       x 
       [ 
       3 
       ], 
       x 
       [ 
       4 
       ], 
       x 
       [ 
       5 
       ]) 
      
     
     
     
     

      
      
 
       cursor. 
       close 
       ( 
       ) 
      
     
     
     
     

      
      
 
       conn. 
       close 
       ( 
       )