Excel table converted to TXT import

Insert into T_user (Userid,username,usercard,corpid,roleid,phone,useradd,userpost,usermail,userpasswd,failtimes, Userstate,authcode,workdate,passwddate) values
(' 10010 ', ' goat one ', ' ', ' 901080200 ', ' 7 ', ' ', ' ', ' ', ' ', ' ' 965eb72c92a549dd ', ' 0 ', ' xx ', ' timestamp,current ', current ' date '),// Note that the number and each set of values are added before and after ()
(' 10011 ', ' goat two ', ' ', ' 901080200 ', ' 9 ', ' ', ', ', ' ', ' ' 965eb72c92a549dd ', ' 0 ', ' xx ', ' timestamp,current ', current ' date ')

The second method of

INSERT INTO T_user values
(' 10010 ', ' goat one ', ' ', ' 901080200 ', ' 7 ', ' ', ' ', ', ' ', ' ' 965eb72c92a549dd ', ' 0 ', ' xx ', ' timestamp,current ', current ' date '),
(' 10011 ', ' goat two ', ' ', ' 901080200 ', ' 9 ', ' ', ', ', ' ', ' ' 965eb72c92a549dd ', ' 0 ', ' xx ', ' timestamp,current ', current ' date ')

Note that varchar uses single quotes in the UE

Use the UE in the Column mode tool and the Ctrl+r replacement tool

The third method, using the formula of Excel table

Insert function, find text, concatenate function

Grammar

Concatenate (TEXT1,[TEXT2],[TEXT3],.... The CONCATENATE function syntax has the following parameters (parameters are: values that provide information for operations, events, methods, properties, functions, or procedures). ）：
Text1 required. The first text item to connect.
Text2, ... Optional. Other text items, up to 255 items. Items must be separated from items by commas.

Example

The Excel content is as follows:

NSRBM MC Gly
001 A1 Xiao Li
002 A2 Xiao Wang
003 A3 Small Three
004 A4 Small Four

First look at the following expression:

=concatenate ("INSERT into Daoru (nsrbm,mc,gly) VALUES ('", A2, "', '", B2, "', '", C2, "');")

This preferred expression is preceded by a "=", then the expression name concatenate (), and finally its argument, which is the most complex.

The first parameter: "INSERT INTO Daoru (nsrbm,mc,gly) VALUES ('" This is a string

Second parameter: A2 This is a cell reference

The third argument: "', '" This is a string

Fourth parameter: B2 This is a cell reference

The fifth parameter: "', '" This is a string

Sixth parameter: C2 This is a cell reference

Seventh parameter: "');" This is a string

The last statement generated is as follows:

Insert into Daoru (nsrbm,mc,gly) VALUES (' 001 ', ' A1 ', ' Xiao Li ');
Insert into Daoru (nsrbm,mc,gly) VALUES (' 002 ', ' A2 ', ' Xiao Wang ');

=concatenate ("INSERT into T_user (Username,userid,usercard,userpost,userpwd,authod) VALUES ('",B4, "', '",C4,"', '",D4,"', ' ",E4," ', "," ' 965eb72c92a549dd ', ' 01 '); " )

Each purple color represents a text, each yellow color represents a text, black, comma is not a comma of SQL statement, is used to distinguish the individual text of the identity, each text to use the "" "double quotation marks

Callouts, double quotes are not displayed, and double quotation marks include content that is displayed

In the Excel table, the following SQL statement is followed by the corresponding records in the right

Insert into T_user (Username,userid,usercard,userpost,userpwd,authod) VALUES (' Shaon ', ' 130000 ', ' 12022119731214003X ', ' ', ' 965eb72c92a549dd ', ' 01 ');
Insert into T_user (Username,userid,usercard,userpost,userpwd,authod) VALUES (' Chen Hongliang ', ' 130001 ', ' 120221197802240017 ', ' ', ' 965eb72c92a549dd ', ' 01 ');
Insert into T_user (Username,userid,usercard,userpost,userpwd,authod) VALUES (' Hu Jianmin ', ' 130002 ', ' 120221198903271319 ', ' 13820437489 ', ' 965eb72c92a549dd ', ' 01 ');

1 identification in an Excel table, select cells behind each row of records

2 Identification Insert =concatenate function

4 fields in the identity table can be inserted in the Excel table again

The 2nd logo is also correct, press ENTER, 1 displays the corresponding data information

3. After the above steps are displayed correctly, you can drag the entire cell down to display more data information

Copy the above SQL content to TXT document for insert operation

Excel table converted to TXT import