Course Process
SELECT Statement MYSQL
We have a database created, table created, and data records inserted.
Now let’s what are the differect ways we can query the stored data.
The SELECT statement is used to select data from a database table.
Syntax:
SELECT column1, column2, …
FROM table_name;
Query:
Let’s select data with all the columns from the employees table using ‘*’
SELECT * FROM employees
Output:
As you see we have fetched tables data with all columns
Select Selected Columns
Query:
Let’s fetch with selected columns ( only no and name information) from the employees table
SELECT emp_no,first_name,last_name FROM employees
Output:
Tester Usage Tips:
- To verify the data visible in UI from one or more database tables.
- To verify the data saved through the UI is correctly stored in database
- To verify the records stored in specific database tables