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
- 6367 Views
- I also Faced
- E-Mail Answers
Answer Posted / sapin
Choice 5
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
Is mysql easy to learn?
How to load a csv file into a table
Is blocked because of many connection errors unblock with mysqladmin flush hosts?
What are the non-standard sql commands supported by 'mysql'?
Is mysql case-sensitive?
How do I set user privileges in mysql?
What is mysqli procedural?
What is an example of a delimiter?
Write a command to list all databases in mysql?
What is foreign key in mysql?
write a command to view the content of the table
How to update info already in a table and delete a row(s) from a table.
How to present a past time in hours, minutes and seconds?
What could be the reason that the mysql statement 'select avg (salary) from emp' generates an inaccurate output?
What is database migration in mysql?
