Database - Introduction to SQL - Discussion

The reason you use "INSERT" in SQL to add a row is that the "INSERT" statement is specifically designed to add new records into tables within a database. It allows you to specify both the table and the values for each column you want to add, making it the standard and correct command for this operation in SQL.

You have to add a row, not a table because of that I used the insert query to add the row.

For adding the table you can write the add table.

Thanks everyone for explaining the answer.

insert into TABLENAME into VALUES(col1,col2,....);

insert into T.N values(1,2,3,4,5,....etc)

"How to insert values into a table"?

Queries explanation:

1] ADD : It is used to add the column in already created table using alter keyword.
ex. alter table table_name ADD (column_name data_type(size));

2] CREATE: it is used to create the new table .
ex. CREATE table table_name (column_name data_type(size) );

3] INSERT: it is used to insert the row values into the already created table.
ex. INSERT into table_name values (1 ,'XYZ', ....)
or INSERT into table_name values(&column1, '&column2()',.....);

INSERT is for putting in a fresh record to a table.

Insert into <table_name>[(column names)] values(value1,value2,....); .

You can add a row using INSERT keyword.