Let's start by creating a table authors:
CREATE TABLE Authors (
authid SMALLINT not NULL PRIMARY KEY,
authfn VARCHAR (),
authmn VARCHAR ()
AUTHLN VARCHAR
)
Engine=innodb;
Then insert more than one piece of data into the table, and the SQL Insert code is as follows:
INSERT into Authors VALUES (1006, ' H ', ' S. ', ' T '),
(1007, ' J ', ' C ', ' O '),
(1008, ' B ', NULL, ' E '),
(1009, ' R ') , ' M ', ' R '), (
1010, ' j ', ' K ', ' T '),
(1011, ' j ', ' G. ', ' N '),
(1012, ' a ', null, ' P '),
(1013, ' a ', NULL, ' W '),
(1014, ' N ', NULL, ' A ');
is actually very similar to an inserted SQL statement, except that multiple INSERT statements separate each piece of data with commas.
The results are as follows:
Authid |
Authfn |
Authmn |
Authln |
1006 |
H |
S. |
T |
1007 |
J |
C |
O |
1008 |
B |
|
E |
1009 |
R |
M |
R |
1010 |
J |
K |
T |
1011 |
J |
G. |
N |
1012 |
A |
|
P |
1013 |
A |
|
W |
1014 |
N |
|
A |
Thank you for reading, I hope to help you, thank you for your support for this site!