Hi, recently I implemented a feature for an gui admin I use internally, but I think it would be useful also for sqlite shell. Sorry if it already exists in some form, I could not find similar.
The idea is to use bind syntax together with csv (or clipboard compatible) import. So if one enters a query with question marks and other symbols that allows parameters numbering (but not naming obviously) and also provides csv file, shell will allow to interate through each row of the file and perform the query using the row as the parameters set. It will allow not only using a complex inserts with concatenation and so on but also give the ability to make mass updates or other conditional operations. There are errors possible like conflict between expected number of parameters and provided, but this could be resolved either with returrning an error (% expected, but % found) or allowing ignoring extra fields with padding. I don't know whether the clipboard content can be used in sqlite ideologically, but in my case it saved additional time allowing importing for example from excel without the intermediate file (csv). Thanks Max Vlasov www.maxerist.net _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
