vendredi 21 août 2015

SQLite - How To add a column to multiple tables?

I get a syntax error when I'm trying to add "one" column to multiple tables.

ALTER TABLE x , y add column z INT;

I get : near ",": syntax error

I tried this code below but it doesn't work either :

ALTER TABLE (SELECT * FROM x, y) add column z INT;

Error: near "(": syntax error

Aucun commentaire:

Enregistrer un commentaire