Home>

I want to insert a row name in the first column in SQL

I don't know how to do it

Corresponding source code
cur = conn.cursor ()
cur.execute ("SELECT items1.user_id, items1.price_yen, items2.timestamp, items3.timestamp AS shukudai1 FROM items1 INNER JOIN items2 ON items1.user_id = items2.user_id INNER JOIN items3 ON items2.user_id = items3.user_id;")
items_list = cur.fetchall ()
items_list```

Enter the language name here SQL, python, SQLite

``` Enter the language here
result
I want to insert a name in this first column
[(10003, 5400, '2016-03-23 ​​11:05:00', '2016-03-23 ​​11:00:00'),
 (10003, 5400, '2016-03-23 ​​11:05:00', '2016-03-24 09:10:00'),
 (10003, 5400, '2016-03-23 ​​11:05:00', '2016-03-24 11:20:00'),
 (10003, 5400, '2016-03-23 ​​11:05:00', '2016-05-01 11:20:00'),


user_id, payment, quest_log, login_log
I want to insert the name

  • Answer # 1

    How about referring to .headers on?

Related articles