Insert multiple records in one statement

[rhonda11]

Please help me to insert multiple record in a single statement and what the max record I can insert in one statement. The below is what I been doing for inserting a as a signal record.

Insert into emp123
(first, last, age)values
('Charles', 'Smith', 26);

Thanks in advance

 

[vadimg]

There is no max.

Try the union statement

Insert into emp123 (first, last, age)
select 'Charles', 'Smith', 26
union
select 'Jane', 'Doe', 27
union
select 'Bill', 'Doe', 27



................... and so on

 

[rhonda11]

Thank, you save me a lot of time.