COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
INSERT (’Olsen’) INTO Persons (LastName)
|
|
|
INSERT INTO Persons (’Olsen’) INTO LastName
|
|
|
INSERT INTO Persons (LastName) VALUES (’Olsen’)
|
|
|
None of the above
|
Detailed explanation-1: -With SQL, how can you insert “Olsen” as the “LastName” in the “Persons” table? INSERT INTO Persons (LastName) VALUES (’Olsen’);
Detailed explanation-2: -If you want to add data to your SQL table, then you can use the INSERT statement. Here is the basic syntax for adding rows to your SQL table: INSERT INTO table name (column1, column2, column3, etc) VALUES (value1, value2, value3, etc); The second line of code is where you will add the values for the rows.
Detailed explanation-3: -There are two ways to insert values in a table. In the first method there is no need to specify the column name where the data will be inserted, you need only their values. The second method specifies both the column name and values which you want to insert.