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
7899 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

What is the use of mysqli_fetch_array?

1047

Can mysql function return a table?

1093

State the differences between mongodb and mysql.

1179

How can I create table in mysql?

1021

Is mysql relational database?

902

Where does mysql store data?

876

How to calculate expressions with sql statements?

1117

What is flush privileges in mysql?

996

What are the functions of commit and rollback statements?

1027

How to analyze tables with 'mysqlcheck'?

1206

How triggers can be used in mysql?

1017

How to execute mysql query in php?

915

Is there a free mysql?

901

What is regexp?

1141

Why do we need mysql?

972