
Now go to View->Show Symbol->Show End of Line

We can see this is a carriage return
So to do a find and replace here, we need

Note the search mode above is set to extended

To now add to the beginning of each line you need

Note we use ^ as a regular expression, but with this we need to escape special characters like ‘(‘ and ‘)’ that we’re using in the replace with \ for it to work

Note also with the SQL, the primary key is not set back to 0
delete from profession_skills
So we can use
ALTER TABLE profession_skills AUTO_INCREMENT = 1
before executing the INSERT statements to do the above statement to reset the AUTO_INCREMENT