We are in processing for copying data from one to another table but it should be only distinct ones. so we are trying execute below syntax by stopping pipeline.
INSERT INTO newtable (select distinct(*) from existingtable);
but it is throwing syntax error as
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘*) from existingtable’ at line 1
can someone please help on how to fix that