Example #1
0
from config.db import pyCursor

sqlCommand = "SELECT * FROM customers ORDER BY name DESC"
pyCursor.execute(sqlCommand)

results = pyCursor.fetchall()
for customer in results:
    print(customer)
Example #2
0
from config.db import pyDb, pyCursor

prepareStatement = "UPDATE customers SET address = %s WHERE id = %s"
prepareValues = ("Valley 345", 3)
pyCursor.execute(prepareStatement, prepareValues)
pyDb.commit()

print(pyCursor.rowcount, "records(s) affected")
Example #3
0
from config.db import pyCursor

prepareStatement = "SELECT * FROM customers WHERE address LIKE '%way%'"
pyCursor.execute(prepareStatement)

results = pyCursor.fetchall()

for customer in results:
    print(customer)
Example #4
0
from config.db import pyCursor
""" Add Column """
# ALTER TABLE table_name ADD column_name datatype
addColumn = 'ALTER TABLE customers ADD slug VARCHAR(255)'
addFirstColumn = 'ALTER TABLE customers ADD COLUMN id INT AUTO_INCREMENT PRIMARY KEY FIRST'
""" Drop Column """
# ALTER TABLE table_name DROP COLUMN column_name
dropColumn = 'ALTER TABLE customers DROP test VARCHAR(255)'
""" Modify Column """
# ALTER TABLE table_name MODIFY COLUMN column_name datatype
modifyColumn = 'ALTER TABLE customers MODIFY COLUMN name VARCHAR(50)'

pyCursor.execute(addFirstColumn)