Database - Introduction to SQL - Discussion

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.

INSERT is only keyword to add a row in database/table.

The "insert" is the only keyword to add rows into table

insert into ( table_name ) values ( 'value1' , 'value2' , ...);

If the value is number don't put the quotes .

You can add a row using INSERT keyword.