Ok all mysql gurus, I need help here.
I have a table with few fields:
f_1, f_2, f_3, f_4
I want to run a query in mysql to get all the fields together and update the result into f_1
Update `table` set `f_1`=`f_1`. " ".`f_2`." ".`f_3`." ". `f_4`
is this possible directly on the server using Navicat?
I have a table with few fields:
f_1, f_2, f_3, f_4
I want to run a query in mysql to get all the fields together and update the result into f_1
Update `table` set `f_1`=`f_1`. " ".`f_2`." ".`f_3`." ". `f_4`
is this possible directly on the server using Navicat?