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?