SELECT * FROM vtable;

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

Question Posted / v

3 Answers
7725 Views
I also Faced
E-Mail Answers

Answer Posted / v

SELECT * FROM vtable;

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Where is the myisam table stored?

899

How does triggers work in mysql?

895

What is blob and clob?

893

What tools available for managing mysql server?

949

Can we write procedure in mysql?

866

Which is better mysql or microsoft sql?

852

What does mysqli_fetch_assoc do?

857

How can we run batch mode in mysql?

991

How to convert numeric values to character strings?

978

What do ddl, dml, and dcl stand for?

851

How many types of indexes are there in mysql?

856

What is heap table in mysql?

911

How to include character strings in sql statements?

913

What is mysql data directory? How to determine the location of the data directory?

876

What, if a table has one column defined as TIMESTAMP?

932