SQL query to update multiple tables with same column name

Question

I have a database that include many tables with have same column name and I would like to run a SQLITE3 query to change the values of all tables.

  Table XXX (id integer, name text);
  Table YYY (id integer, .....);
  Table ZZZ (id integer, .....);
  Table....

To run a query on all table which jave a field name "id" I used the query: select name from sqlite_master where sql like ('%id%');

But, how could I use the UPDATE query with the list of tables?

Can you give a more realistic example? Is this your actual situation? — Yosi Dahari
– Yosi Dahari, Commented Nov 24, 2013 at 19:16
I have a database which includes a default key value for all tables. I would like to change all default in all tables in one query. This key is not unique, there is other columns that are unique but all belong to same id. — Moti
– Moti, Commented Nov 24, 2013 at 19:24

wvdz · Accepted Answer · 2013-11-24 19:13:17Z

1

Not possible with regular sql without simply listing all table/column combinations.

Possible solutions could be functions/procedures or other ways to execute dynamically generated sql.

answered Nov 24, 2013 at 19:13

wvdz

16.2k4 gold badges60 silver badges97 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Moti Over a year ago

The list of tables that includes th "I'd" field is appear above. Select name from sqlite_master where.... But I need to include in update a list of tables and not one

pkoulianos · Accepted Answer · 2020-01-10 20:34:38Z

0

You can use a trigger in order to update as many tables you want after insert in a single table .

example trigger

CREATE TRIGGER update_tables
AFTER INSERT ON XXX
BEGIN

INSERT INTO YYY (new.id,new.integer);
INSERT INTO ZZZ (new.id,new.integer);

END

answered Jan 10, 2020 at 20:34

pkoulianos

1872 silver badges5 bronze badges

Collectives™ on Stack Overflow

SQL query to update multiple tables with same column name

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related