Is there a way of deleting all of my data in one of my tables?
I have a customer table that has Customer values that are in various cases (Upper/Lower), they are email addresses. I have a purchases table that was not formatted BUT they have different cases for different purchases. I am finding that [email protected] and [email protected] are NOT the same thing. So I’m getting tons of errors when I am trying to load the table.
What I was going to do is export my data, change the email addresses to all lower case, then re-import them. Painful but easier than correcting them one by one.
Problem is that I don’t know how to bulk erase my tables and start from scratch.
Any insight?