Adding a field with mySQL
Hello, I'm trying to add a new field to an existing data set via mySQL (my first time doing this). The new field will take data from my existing data set (Product Name) and re-assign a new name leveraging a case statement. Below is my code. I'm currently receiving an syntax error, which I'm looking for assistance on.…