It would be better for you to leave the original comment, use markdown to strike it through*, and create an edit showing that you realized it was wrong.
It shows humility and reflects positively on you, but it also allows the history of this conversation to remain preserved.
*not sure if this is possible on Lemmy yet
Edit: it is :)