How to use nodejs to read the contents of txt files and convert them into insert statements of msyql

I have a txt file

there are 10,000 lines

the first line is as follows

27466726----6837605--------398705040011----7605----60664----qq

what I want to extract is

27466726
6837605
398705040011
7605
60664
qq

the second line is as follows

zaistarm----tian--------35046301X----chi----18289----zais

zaistarm
tian
35046301X
chi
18289
zais

the third line is as follows

weizhon.com----wz--------2106260513----wzj----18700----weizhong

the third line looks like

I want to read each line and convert the extracted content in each line into

insert statement of mysql

insert into message_board (name, content, a, b, c, abc) values();

how can I achieve this?

Es6 node.js javascript

May.19,2022

use split as the delimiter - as the separator. The result of the segmentation is an array, and you can just take it by position

Previous: After port mapping, Thrift protocol access error

Next: I used spring boot to implement a login interface, the problem encountered.

Does Object.keys traverse objects?
Object.keys(obj).forEach(item => { console.log(obj[item]) }) is this equivalent to traversing twice, and will it have an impact on performance? ...

Es6 node.js javascript

Mar.09,2021
Try/catch was unable to capture the problem with promise.reject
function f2() { try { Promise.reject( ); } catch(e) { console.log(e) } } execute f2 () , and Uncaught (in promise) cannot be thrown from the promise.reject, console captured by try catch. async function f() { try { await Pr...

Es6 node.js javascript

Mar.14,2021
How to implement Set of ES6 without using ES6
such as the title. If you implement ES6 built-in feature Set, without using other es6 API (such as Map) if you want to write a Set that class imitates, should the underlying data structure use array or Object? ...

Es6 node.js javascript

Mar.16,2021

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1e40cbe-433be.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1e40cbe-433be.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?