MYSQL: Merge data from one column to another
You need to update your table not insert

update my_jobs set city=substring_index(location, ", ",1) ,
state=SUBSTRING(location, LENGTH(location)-2, LENGTH(location))


If you want more explanation add a comment