SQL select all statement

[Arkie]

The select statement is used to retrieve data from a table from a database.

To get the data from a table you can write:

Code

GeSHi (sql):
SELECT * FROM tableName
Created by GeSHI 1.0.7.20

or if you want to specifiy all the columns specifically you can write:

Code

GeSHi (sql):
SELECT column1, column2, column3 FROM tableName
Created by GeSHI 1.0.7.20

Both will give the same result.

[ashish]

hay friend this good u done.


regards,
phe9oxis,