Category Archives: Python

Creating a Table To create a table in MySQL, use the “CREATE TABLE” statement. Make sure you define the name of the database when you create the connection Example Create a table named “customers”:import mysql.connectormydb = mysql.connector.connect(  host=”localhost”,  user=”yourusername“,  password=”yourpassword“,  database=”mydatabase”)mycursor = mydb.cursor()mycursor.execute(“CREATE TABLE customers (name VARCHAR(255), address VARCHAR(255))”)#If this page is executed with no error, you… Read More »

Creating a Database To create a database in MySQL, use the “CREATE DATABASE” statement: Example create a database named “mydatabase”:import mysql.connectormydb = mysql.connector.connect(  host=”localhost”,  user=”yourusername“,  password=”yourpassword“)mycursor = mydb.cursor()mycursor.execute(“CREATE DATABASE mydatabase”)#If this page is executed with no error, you have successfully created a database. Output:C:\Users\My Name>python demo_mysql_create_db.py If the above code was executed with no errors, you have… Read More »

Python can be used in database applications. One of the most popular databases is MySQL. MySQL Database To be able to experiment with the code examples in this tutorial, you should have MySQL installed on your computer. You can download a free MySQL database at https://www.mysql.com/downloads/. Install MySQL Driver Python needs a MySQL driver to access… Read More »

Delete a File To delete a file, you must import the OS module, and run its os.remove() function: Example Remove the file “demofile.txt”:import osos.remove(“demofile.txt”) Check if File exist: To avoid getting an error, you might want to check if the file exists before you try to delete it: Example Check if file exists, then delete it:import osif os.path.exists(“demofile.txt”):  os.remove(“demofile.txt”)else:  print(“The file does not… Read More »

Write to an Existing File To write to an existing file, you must add a parameter to the open() function: “a” – Append – will append to the end of the file “w” – Write – will overwrite any existing content Example Open the file “demofile2.txt” and append content to the file:f = open(“demofile2.txt”, “a”)f.write(“Now the file has more content!”)f.close() #open… Read More »

Open a File on the Server Assume we have the following file, located in the same folder as Python: demofile.txtHello! Welcome to demofile.txtThis file is for testing purposes.Good Luck! To open the file, use the built-in open() function. The open() function returns a file object, which has a read() method for reading the content of the file: Example f = open(“demofile.txt”, “r”)print(f.read()) Output:C:\Users\My… Read More »

File handling is an important part of any web application. Python has several functions for creating, reading, updating, and deleting files. File Handling The key function for working with files in Python is the open() function. The open() function takes two parameters; filename, and mode. There are four different methods (modes) for opening a file: “r” – Read – Default value. Opens… Read More »

To make sure a string will display as expected, we can format the result with the format() method. String format() The format() method allows you to format selected parts of a string. Sometimes there are parts of a text that you do not control, maybe they come from a database, or user input? To control such values, add placeholders… Read More »

User Input Python allows for user input. That means we are able to ask the user for input. The method is a bit different in Python 3.6 than Python 2.7. Python 3.6 uses the input() method. Python 2.7 uses the raw_input() method. The following example asks for the username, and when you entered the username, it gets printed on… Read More »

The try block lets you test a block of code for errors. The except block lets you handle the error. The finally block lets you execute code, regardless of the result of the try- and except blocks. Exception Handling When an error occurs, or exception as we call it, Python will normally stop and generate an error message. These exceptions can… Read More »