Access to MySQL Database

ImportPymysql#creates a Connection object that represents a database connectionConnection =Pymysql.connect (Host=" ",#Database IP AddressUser=" ",#MySQL user namePasswd=" ",#mysql User login passworddb=" ",#Database name                #if the text inside the database is UTF8 encoded,                #charset designation is UTF8CharSet ="UTF8")   #returns a Cursor objectc =connection.cursor ()#executes an SQL statement that gets all the records in the XX tableC.execute ("""SELECT * from XX""")#The rowcount property records the number of rows of data fetched by the most recent Execute methodNumRows =C.rowcount forXinchRange (numrows):#returns a tuple in which each element represents a fieldrow =C.fetchone ()Print(ROW)

The above code is an example of reading a database table. (I use MySQL, which Pymysql library, also useful MYSQLDB library)

Access to MySQL Database