PHP Tutorials
- What is MySqli
- mysql query
- mysql query example
- InnoDB
- mysql column Type
- CRUD Example
- Connection Using Function
- mysql keys
- SELECT
- WHERE
- UPDATE
- Count no of Rows
- ALIAS
- AND, AND & OR
- BETWEEN
- COMPARISON OPERATOR
- DELETE
- DELETE LIMIT
- DISTINCT
- EXISTS
- FROM
- GROUP BY
- HAVING
- IN
- INTERSECT
- IS NULL & IS NOT NULL
- LIKE
- NOT
- ORDER BY
- SELECT LIMIT
- SUBQUERY
- TRUNCATE
- UNION && UNION ALL
- Concat & Group_Concat
- mysql Function
- Mysql Insert Id
- MySql Aggregate Function
- Mysql Join
- JOIN in MySql
- Trigger
- Procedure
- Transaction
- views
- Index
- SQL Injection
- Normalization
- Query Bind
- Interview Questions
Important Link
Select clause in mysql
the SELECT staement is the most important in the sql.
The main purpose of SELECT statement’s is to retrieve the data from the database table and return it in a tabular format. The SELECT is executed after the FROM clause.
The SELECT Clause is used to get records in the form of a result set (i.e. rows) from one or more database tables.
.
SELECT * FROM Table_Name
SELECT Specific Columns
SELECT column1, column2, column3,......... FROM Table_Name
SELECT Id, Name, Department, Age, City FROM employee;
SELECT All Columns with Conditions
SELECT * FROM table_name [WHERE conditions];
SELECT * FROM ittutorial WHERE Department = ‘IT’;