Menu

SQL query for data retrieve or select from table


To select or retrieve data from table SELECT statement is used.

SQL SELECT Syntax

SELECT column_name,column_name

FROM table_name;

and

SELECT * FROM table_name;

Here select column_name,column_name specifies only two column data select from table.

SELECT * FROM table_name; query is for select all the data from table.

Example :

SELECT FirstName,LastName

FROM Student;

and

SELECT * FROM Student;








Connection failed: SQLSTATE[28000] [1045] Access denied for user 'studentdb'@'localhost' (using password: YES)

Subscribe