import sqlite3

conn = sqlite3.connect('sample.db')
cur = conn.cursor()

p_data = ('Yamazaki Takashi', 172, 59.3)

# プレースホルダーを使う
sql = """INSERT INTO personal
  VALUES(
  '004',
  ?,
  ?,
  ?)"""
cur.execute(sql, p_data)
conn.commit()

sql = """SELECT * FROM personal
  ORDER BY id"""
for row in cur.execute(sql):
  print(row)
print() # 改行

id = ('002', )

# プレースホルダーを使う
sql = """SELECT * FROM personal
   WHERE id = ?"""
cur.execute(sql, id)
print(cur.fetchone())

conn.close()