Posts

Showing posts with the label Python MySQL Select From

Python Getting Started

  Python  Getting Started Python Install Many PCs and Macs will have python already installed. To check if you have python installed on a Windows PC, search in the start bar for Python or run the following on the Command Line (cmd.exe): C:\Users\ Your Name >python --version To check if you have python installed on a Linux or Mac, then on linux open the command line or on Mac open the Terminal and type: python --version If you find that you do not have Python installed on your computer, then you can download it for free from the following website:  https://www.python.org/ Python Quickstart Python is an interpreted programming language, this means that as a developer you write Python (.py) files in a text editor and then put those files into the python interpreter to be executed. The way to run a python file is like this on the command line: C:\Users\ Your Name >python helloworld.py Where "helloworld.py" is the name of your python file. Let's write our first Python fi

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 *