Create a Table if it Does not Exist:
import sqlite3
import os
current_directory = os.path.dirname(os.path.abspath(__file__))
db_name = 'your_database.db'
file_path = os.path.join(current_directory, db_name)
conn = sqlite3.connect(file_path)
cursor = conn.cursor()
create_table = '''
create table if not exists your_table(
id integer primary key,
name text,
email text
)
'''
cursor.execute(create_table)
conn.commit()
conn.close()
With this project we create an IoT Environmental control device that uses a MariaDB (MySQL) database as the datastore. This allows you to use database functionality to create log files and be able to corrrelate […]
WARNING: “Fair Use” is not a global right. It is an American concept that does not have a corresponding legal concept in many countries. Even in the United States Fair Use is not set in […]
WARINING: “Fair Use” is not a global right. It is an American concept that does not have a corresponding legal concept in many countries. Even in the United States Fair Use is not set in […]
Be the first to comment