Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import mysql.connector
- n_mysql_server = "MLAB-01-NIM01";
- n_mysql_user = "root";
- n_mysql_pass = "nim2014";
- n_mysql_db_name = "n_proj";
- cnx = mysql.connector.connect(user=n_mysql_user, host=n_mysql_server, password=n_mysql_pass, database=n_mysql_db_name)
- cursor = cnx.cursor()
- query = ("SELECT * FROM assets")
- cursor.execute(query)
- for first_name in cursor:
- print("{}".format(first_name))
- cursor.close()
- cnx.close()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement