Create new column in existing SQLite3 table

Question

I have a table shown below

Id	Retweet_count	Fav_count
1	5	8
2	3	3
3	4	1
4	0	1

How do i create a new column in the table called "Total_interaction", where it shows the values of the sum of both Retweet_count and Fav_count like this.

Id	Retweet_count	Fav_count	Total_interaction
1	5	8	13
2	3	3	6
3	4	1	5
4	0	1	1

Currently i have my connection to my database as shown below.

import sqlite3

conn = sqlite3.connect('tweets_data.sqlite')
cur = conn.cursor()

Read about [Generated columns](https://www.sqlite.org/gencol.html) — Barmar, Sep 04 '21 at 06:41

Gunesh Shanbhag · Accepted Answer · 2021-09-04T06:50:54.140

1

If you want to create a new column with the already present columns then you can use generated columns.

ALTER TABLE your_table_name
  ADD Total_interaction INTEGER GENERATED ALWAYS
    AS (Retweet_count + Fav_count);

Replace your_table_name with your Table name. You can read more about it here

edited Sep 04 '21 at 06:50

answered Sep 04 '21 at 06:42

Gunesh Shanbhag

559
5
13

This might not fully answer what OP needs. This would just create a new column without any values. – sushanth Sep 04 '21 at 06:44
ADDED changes @sushanth – Gunesh Shanbhag Sep 04 '21 at 06:51
You may also look at [Can I create computed column in SQLite](https://stackoverflow.com/questions/1124695/can-i-create-computed-columns-in-sqlite) – Ptit Xav Sep 04 '21 at 06:57

Create new column in existing SQLite3 table

1 Answers1