MySQL with Applications: Real Examples

Build a Simple User Table

Create a MySQL table for users with columns for id, username, and password_hash. Insert three sample users.

Expected output: A users table with three inserted records.

Hint: Use AUTO_INCREMENT for id and VARCHAR for username and password_hash.

Query Product Data

Write a SQL query to select all products with price greater than 50 from a products table.

Expected output: A list of products priced above 50.

Hint: Use the WHERE clause with a comparison operator.

Connect MySQL with Python

Write a Python script to connect to a MySQL database and print all usernames from the users table.

Expected output: Printed usernames from the users table.

Hint: Use mysql-connector-python library and cursor to execute SELECT queries.

Use parameterized queries or prepared statements provided by database libraries to safely handle user inputs and prevent SQL injection.

Indexes improve query performance by allowing faster data retrieval, especially on columns used in WHERE clauses or JOIN conditions.

Passwords should be hashed using strong algorithms like bcrypt or Argon2 before storing, never saved as plain text.