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
How to show all records starting with the letters 'sonia' and the phone number '9876543210'
What is root password?
What is meant by sharding?
What is pdo connection?
Is oracle better than mysql?
How do I install mysql workbench?
How to create trigger in mysql workbench?
How do I download a mysql community server?
How to set mysql variable in php?
What is dirty read and phantom read?
What are the 'mysql' command line options?
What is data types in mysql?
how to Return total number of rows.
How do you create a new database in mysql?
What is localhost in mysql?