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
What is the use of mysqli_fetch_array?
Can mysql function return a table?
State the differences between mongodb and mysql.
How can I create table in mysql?
Is mysql relational database?
Where does mysql store data?
How to calculate expressions with sql statements?
What is flush privileges in mysql?
What are the functions of commit and rollback statements?
How to analyze tables with 'mysqlcheck'?
How triggers can be used in mysql?
How to execute mysql query in php?
Is there a free mysql?
What is regexp?
Why do we need mysql?