Hajime MATSUMOTO wrote: > ALTER TABLE ADD COLUMN UNIQUE(avap_id, vacation_start_date) ON > CONFLICT REPLACE; > SQL error near line 3: near "ADD": syntax error
First, it's ALTER TABLE tablename ADD ... . That's the immediate cause of the syntax error you get. But it's not going to fly anyway. You can only add new columns, you can't add new constraints on existing columns. Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
