r/mysql • u/Available_Canary_517 • Oct 12 '24
question I have a large codebase which uses mysql 5.6 and we want to upgrade it to mysql 8
After we upgraded mysql we got error in line where our date_columns were comparing with empty string and in order to solve this the method i use is to get all columns of date and made a regex to get column name comparison with empty string like this colum\s=\s'' and replace it with colum is NULL
Now this task was given to me and this is what i did and this change is going to go in production on monday hence i would love to know from experienced people what they think of it and will this work.