Using notepad++ to add characters to end of line

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

Leave a Reply