Scribd
Upload
2 views3 pages

sql-1

Uploaded by

Sim toor
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
2 views3 pages

sql-1

Uploaded by

Sim toor
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Method B: Without Specifying Column Names

If you are adding values for all columns in the exact order they were created, you can omit the column names.

Sql

INSERT INTO Students


VALUES (2, 'Jane', 'Smith', 22);
Method C: Inserting Multiple Rows At Once
You can insert several records efficiently within a single query by separating each row's data with a comma

You might also like