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 * FROM rcf_visitor_mas")

myresult = mycursor.fetchall()

for x in myresult:

  print(x)

http://localhost:81/python/hi.py  open in browser(WAMP + MYSQL CONNECTOR INSTALLED USING PYTHON THEN WORK)

('8567859566', 'akhil', '06012021', 'trtF', ' OFFICE', 'K', 'P', '14470', 2121, 1)

HERE hi,py =my file name u can name as per ur wishes