SELECT * FROM vtable WHERE 1 = 1

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 / sapin

3 Answers
7774 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

Please Help Members By Posting Answers For Below Questions

How do I select a table in mysql?

878

What is procedural api?

952

What is use of mysql?

889

What is required to create mysql database?

949

How do I edit a table in mysql workbench?

816

What do ddl, dml, and dcl stand for?

862

what is database white box testing? : Mysql dba

954

Can we store images in mysql database?

866

How to see the create table statement of an existing table?

1004

What are the advantages of myisam over innodb?

933

List the different types of normalization?

903

What is the use of procedure in mysql?

899

How do I backup mysql database on linux?

895

How to run a sql statement?

983

What is the maximum connection pool size?

916