You know what? I don’t mind it. I don’t use it a lot these days, but I remember learning it and liking how clean and clinical and logical it could be. Sure, it’s an old language now. Maybe there’s a new “Swift” to MySQL’s “C++” these days.
[ - ] seeker 1 point 4 yearsApr 22, 2021 09:40:28 ago (+1/-0)
In that cursor statement, you're using the old syntax for table joins "from table a, b, c where a.x = b.y...". Why not modern joins? Also a cursor is always slower, do you definitely need it?
[ + ] account deleted by user
[ - ] account deleted by user [op] 0 points 4 yearsApr 21, 2021 19:20:43 ago (+0/-0)
[ + ] account deleted by user
[ - ] account deleted by user [op] 6 points 4 yearsApr 21, 2021 19:22:41 ago (+6/-0)
[ + ] Tallest_Skil
[ - ] Tallest_Skil 1 point 4 yearsApr 21, 2021 19:27:29 ago (+1/-0)
[ + ] Lostandfound
[ - ] Lostandfound 2 points 4 yearsApr 21, 2021 19:39:52 ago (+2/-0)
[ + ] shitface9000
[ - ] shitface9000 1 point 4 yearsApr 21, 2021 20:42:26 ago (+1/-0)*
Assuming of course that's a large table, otherwise why would it be slow.
[ + ] Armiger
[ - ] Armiger 1 point 4 yearsApr 21, 2021 23:43:23 ago (+1/-0)
[ + ] seeker
[ - ] seeker 1 point 4 yearsApr 22, 2021 09:40:28 ago (+1/-0)
[ + ] account deleted by user
[ - ] account deleted by user [op] 0 points 4 yearsApr 22, 2021 10:00:36 ago (+0/-0)
[ + ] seeker
[ - ] seeker 1 point 4 yearsApr 22, 2021 10:19:59 ago (+1/-0)
[ + ] account deleted by user
[ - ] account deleted by user [op] 0 points 4 yearsApr 22, 2021 10:35:43 ago (+0/-0)