import mysql.connector

mydb = mysql.connector.connect(
  host='192.168.1.10',
  user='username',
  password='password',
  database='database name'
)

mycursor = mydb.cursor()
#sqlQuery=('SELECT * FROM boyName WHERE id BETWEEN 10 AND 30')
sqlQuery2=('SELECT * FROM boyName WHERE firstBoyName LIKE \'Al%\'')
#sqlQuery3=('SELECT * FROM boyName LIMIT 5')

mycursor.execute(sqlQuery2)

myresult = mycursor.fetchall()

for x in myresult:
  print(x) #Tuple

for x in myresult:
  print(x[0], x[1])

mydb.close()

'''
INSERT INTO `boyName` (`id`, `firstBoyName`) VALUES
(10, 'Alecto'),
(11, 'Alessio'),
(12, 'Alex'),
(13, 'Alexej'),
(14, 'Alexis'),
(15, 'Alfons'),
(16, 'Alfredo'),
(17, 'Algot'),
(18, 'Allan'),
(19, 'Alvar'),
(20, 'Alve'),
(21, 'Alvin'),
(22, 'Amadeus'),
(23, 'Amir'),
(24, 'Amos'),
(25, 'Andrée'),
(26, 'Andrew'),
(27, 'Angelo'),
(28, 'Anthony'),
(29, 'Antonio'),
(30, 'Ariel'),
(31, 'Aron'),
(32, 'Arthur'),
(33, 'Artur'),
(34, 'Arturo');
'''