SQL Question - it\'s a basic one, but I need some help. I have to write raw SQL

Question

SQL Question - it's a basic one, but I need some help.

I have to write raw SQL to create and insert data into a database and table. I've already created the table(empty) and the database that contains it. Now, I have to enter the new data into the table. Here's what I've got:

INSERT INTO Clients(ClientID,name,email)

VALUES('001','John Smith','JSmith@gmail.com');

I believe this is correct for adding a single row of data. However, I've got about 10 records to add. What is the best way to do this? Do I have to enter EACH LINE like this? Is there a better way?

Explanation / Answer

Answer:

I'm giving example to insert multiple rows to insert at a time

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.