SQL Python Flashcards
1
Q
What parameter is used in the mysql.connector.connect function to define the network location of the database server being accessed in the python program
A
host=
2
Q
What mysql.connector method is used to make changes to a database permanent?
A
commit()
3
Q
What SQL command is used to link two tables together during an SQL select statement?
A
Join
4
Q
What methods is used to used to limit the number records returned from an SQL query?
A
Use the LIMIT SQL clause in the query
5
Q
What python command is required at the top of a python program to allow the use of the mysql connector?
A
import mysql.connector
