appending string in existing string in sqlite3 manager fro firefox? -


Hello, I have to do something like that.

I have 4 rows with unique ID1, 2,3,4 all four rows include some strings like option 1, option 2, option 3, option 4

Now, I want to add option1, "b" to option2 and so on, so there is no way i can do this with a query. I'm adding these to several rows manually

It is not quite clear what code You want to choose to include the field in somestring , but for example, "Caesar's Cipher" (1 'A' returns, 2 returns' B '' etc.) based on < Code> id field, as your question suggests, then it should work:

  preset SET somestring = (substr ('abcdefghijklmnopqrstuvwxy Z ', id, 1) ||') '|| Somestering) WHERE id & lt; = 26;  

... is definitely not for more than 26 lines, since then the argument should change and we can not explicitly estimate how you want to expand it (Id modulo 26 + 1, just use more characters than small letters, or ...?) Because you do not tell why you want to do this.


Comments

Popular posts from this blog

c# - ListView onScroll event -

PHP - get image from byte array -

Linux Terminal Problem with Non-Canonical Terminal I/O app -