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 / sapin
Choice 5
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
Do you need a license for mysql?
How do I change a procedure in mysql?
Can mysql function return a table?
What does mysql flush tables do?
How to control the max size of a heap table?
How to find second highest salary from a table?
How do I stop a mysql service?
Write a query to count the number of rows of a table in mysql.
How do you create a schema?
How can you validate emails using a single query?
can you tell the order of sql select statement? : Mysql dba
What is longblob?
What is mysql and why it is used?
Where does mysql store data?
How do I disconnect mysql workbench?