1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
|
# Import MariaDB Connector/Python module
import mariadb
# connection parameters
conn_params= {
"user" : "example_user",
"password" : "GHbe_Su3B8",
"host" : "localhost",
"database" : "test"
}
# Establish a connection
connection= mariadb.connect(**conn_params)
cursor= connection.cursor()
# Create a database table
cursor.execute("DROP TABLE IF EXISTS mytest")
cursor.execute("CREATE TABLE mytest(id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,"
"first_name VARCHAR(100), last_name VARCHAR(100))")
# Populate table with some data
cursor.execute("INSERT INTO mytest(first_name, last_name) VALUES (?,?)",
("Robert", "Redford"))
# retrieve data
cursor.execute("SELECT id, first_name, last_name FROM mytest")
# print content
row= cursor.fetchone()
print(*row, sep='\t')
# free resources
cursor.close()
connection.close()
|
