Last answered:

13 Nov 2023

Posted on:

12 Nov 2023


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)
Posted on:

13 Nov 2023


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.

Submit an answer