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
Post a Comment