3 ms·
While reading the documentation for iff(), I noticed the command line function edit(), which is pretty cool. UPDATE docs SET body=edit(body) WHERE name='repo
by dtf 6y ago
While reading the documentation for iff(), I noticed the command line function edit(), which is pretty cool.
UPDATE docs SET body=edit(body) WHERE name='report-15';
UPDATE pics SET img=edit(img,'gimp') WHERE id='pic-1542';
- thibran 6y agoIf you like edit, you might like :memory: too :) https://sqlite.org/inmemorydb.html https://sqlite.org/inmemorydb.html
- edwinyzh 6y agoI also didn't know about it before! Cool
- combatentropy 6y agohttps://sqlite.org/cli.html#the_edit_sql_function https://sqlite.org/cli.html#the_edit_sql_function