Which one of the following is the correct way to select all
columns and all rows from "vtable"?
Choice 1
SELECT FROM vtable SELF JOIN vtable
Choice 2
SELECT ALL COLUMNS FROM vtable WHERE ALL ROWS = *
Choice 3
SELECT EVERYTHING FROM vtable
Choice 4
SELECT vtable.* WHERE vtable = vtable
Choice 5
SELECT * FROM vtable WHERE 1 = 1
Answer Posted / v
SELECT * FROM vtable;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do I update a variable in mysql?
What is the default port of mysql server?
How do you concatenate strings in mysql?
How to enter boolean values in sql statements?
What is the purpose of -> in the mysql terminal?
write a query to mysql in safe mode and to change the root password
How can I see connections in mysql?
How we can create index in mysql?
What is difference between schema and table?
Which statement is used in a select query for partial matching?
What is data type for image in mysql?
Is mysql better than oracle?
How many tables we can create in mysql database?
Is sql and mysql same?
What is the storage engine for mysql?