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
Answers were Sorted based on User's Feedback
How to insert dynamic values in mysql using php?
What is latest version of mysql?
Is mysql relational database?
What is blob datatype in mysql?
What are the differences between drop a table and truncate a table?
Does mysql case matter?
How to enter numeric values as hex numbers?
can you elaborate on blob and text in mysql? : Mysql dba
Can you tell the difference between mysql_fetch_object and mysql_fetch_array?
How to analyze tables with 'mysqlcheck'?
What are the features of mysql?
What is the role of a limit in a mysql query?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)