mysql

Select rows from table SQL query

//select all rows from table
SELECT * FROM table_name

//select rows based on a condition
SELECT * FROM table_name WHERE column_name='value'

You can use the 'SELECT' query in SQL if you want to get the list of rows inserted into the table. You can get all rows or by applying conditions on the table columns.

Was this helpful?

Similar Posts

Add columns, alter table SQL query
Create table with constraints MySQL query
Insert data into table mysql query
Show all column names of a table MySql query
Create and select database MySQL
Select second highest column value MySQL
Get duplicate rows and its counts MySQL

Search all posts...

Programmer's Homepage

Your One-Stop Chrome Extension for Curated Developer Feeds, Where Learning and Growth Never Stop!