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
Where is the mysql database stored?
How can you filter the duplicate data while retrieving records from the table?
What, if a table has one column defined as TIMESTAMP?
How to create table with same structure of student table in mysql?
What is ntext?
How much does mysql enterprise cost?
How MySQL Optimizes DISTINCT?
What is truncate command?
How do I tune a mysql query?
What is the full form of mysql?
What is database url for mysql?
How to show table structure mysql?
What is difference between mysql_connect and mysql_pconnect?
What could be the reason that the mysql statement 'select avg (salary) from emp' generates an inaccurate output?
how to show all records starting with the letters 'sonia' and the phone number '9876543210' limit to records 1 through 5.