SQL Python

Question 1

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

Answer 1

host=

Question 2

What mysql.connector method is used to make changes to a database permanent?

Answer 2

commit()

Question 3

What SQL command is used to link two tables together during an SQL select statement?

Answer 3

Join

Question 4

What methods is used to used to limit the number records returned from an SQL query?

Answer 4

Use the LIMIT SQL clause in the query

Question 5

What python command is required at the top of a python program to allow the use of the mysql connector?

Answer 5

import mysql.connector