I know about autoincrement, and that I might be better off doing a table of its own for this, but for some specific performance reasons I would prefer not to.
I have a row looking like this:
id,log
1 | 1:345;2:2345;3:234
Is there ANY way where I with a single SQL update can add X to the log column, and automatically a '4' as the log entry's id?
From your example I can't be entirely sure, but it looks like you don't even need the index numbers, i.e.
id | log
1 | 345;234;234
So you can simply add the entry, optionally prefixed with a ;. Later, any code can interpret the log contents by splitting on ;.
how about build a new table like this:
my_log
-------
id
sub_id
val
and populate it with all the proper parsed values -
then query from here to rebuild the string if needed, otherwise throw out the original table completely - terrible design.
