3 ms·
I believe this could all be done with a single CONCAT. Looks like author is unaware that you can CONCAT(param1, param2, param3, ..., paramN)
by babuskov 14y ago
I believe this could all be done with a single CONCAT. Looks like author is unaware that you can CONCAT(param1, param2, param3, ..., paramN)
- meritt 14y agoIt could also be done without a sub-table either select concat("*4\r\n$4\r\nHSET\r\n$15\r\nevents_all_time\r\n$", length(action), "\r\n", action, "\r\n$", length(`count`), "\r\n", `count`, "\r") from events_all_time
- twerquie 14y agoGood point, I removed the nested CONCATs for clarity. Thanks!