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
- 3 Answers
- 6359 Views
- I also Faced
- E-Mail Answers
Answer Posted / sapin
SELECT * FROM vtable WHERE 1 = 1
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is schema in mysql?
What is text in mysql?
Are stored procedures precompiled?
What are the difference between now and current_date in mysql?
How triggers can be used in mysql?
How to get a list of indexes of an existing table?
How to use 'mysql' to run sql statements?
How to show table names with 'mysqlshow'?
What is the use of count function in mysql?
What is a blob datatype?
How to connect html form to mysql database using php?
What is mysql vs sql?
What are the technical specifications of mysql?
What is the use of i-am-a-dummy flag in mysql?
What is the purpose of using ifnull() function?
