On 1/26/2018 4:43 PM, Roman Fleysher wrote:
I would like to use primary key as a way to create unique column entry:
CREATE TABLE A( id INTEGER PRIMARY KEY, fileName TEXT NOT NULL)
such that file name is always prefix followed by the ID for the content to be:
ID fileName
1 prefix_1
2 prefix_2
Why do you want to store redundant data? What's the actual problem this is
supposed to help you solve? As stated, this looks like an XY problem (
http://xyproblem.info/ )
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
