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
SELECT * FROM vtable WHERE 1 = 1
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How do you select a table?
What is limit in mysql?
What are the disadvantages of stored procedures?
How do I declare a variable in mysql?
What is truncate in mysql?
Is mysql a scripting language?
What is row level locking?
How to use regular expression in pattern match conditions?
How can you retrieve a portion of any column value by using a select query?
How do I stop a mysql command?
What are mysql data types?
How many entries can mysql handle?
How to show table structure mysql?
What you can use regular expression for in mysql?
How to start mysql server?