Posts

Showing posts with the label Install WAMP server

Python MySQL Select METHOD

  Python MySQL  Select  1. #!C:/Python3.9.1/python.exe print("content-type: text/html\n\n" ) import mysql.connector mydb = mysql.connector.connect(   host="localhost",   user="root",   password="",   database="rcf_entry_system" ) mycursor = mydb.cursor() mycursor.execute("SHOW TABLES") for x in mycursor:   print(x) http://localhost:81/python/hi.py  open in browser(WAMP + MYSQL CONNECTOR INSTALLED USING PYTHON THEN WORK) LET MY END IT WERE ('actual_visit_detail',) (' rcf_visitor_mas ',) ('user_master',) ('visit_mas',) ('visitor_matser_person',) 2. LET FETCH DATA FROM  rcf_visitor_mas #!C:/Python3.9.1/python.exe print("content-type: text/html\n\n" ) import mysql.connector mydb = mysql.connector.connect(   host="localhost",   user="root",   password="",   database="rcf_entry_system" ) mycursor = mydb.cursor() mycursor.execute("SELECT *