Shulou(Shulou.com)06/02 Report--

Editor to share with you how to use Notepad++ to record macros, I believe most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

We need to change the header of the csv document into the MySQL DB field, so that when importing csv data, we can process and import the corresponding field data according to the set field, and use Notepad++ to achieve this semi-automatic function.

The steps are as follows:

Open Notepad++-> Macro-> Start Recoding

Copy and paste the csv header that needs to be processed into Notepad++:

Ctrl+F, call out Find, and then process it with regular expressions: copy spaces, Replace with with\ r

Then add 'before and after' with ^ and $.

Then add the field data type after it:

Save Macro when you are finished

In this way, you can refine the sql statement:

CREATE TABLE `xxx`.`xxxx-test` (`BoardNo` varchar, `StationID` varchar), `starttime` datetime, `SFCStatus` varchar, `TotalTestTime` varchar, `result` varchar, `WIFI_11AG_TX1_ 2437` varchar, `Board2472` varchar,) the above ENGINE=InnoDB DEFAULT CHARSET=utf8 is all the contents of the article "how to record Macros with Notepad++". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.