Resolved: Lost my data while running query
Good day
I had an error (1055) while trying to output the result. So, i ran this query "set @@global.sql_mode := replace(@@global.sql_mode, 'ONLY_FULL_GROUP_BY', '');" as advised. But, unfortunately for me, I lost my data. How do I solve this issue?
1 answers ( 1 marked as helpful)
Hi Chiamaka!
Thanks for reaching out.
It seems that you have deleted some of the tables. You can create again the duplicate tables using the same code as you previously have used.
Hope this helps.
Best,
Tsvetelin