Introduction to Selenium

• Selenium is a free (open source) automated testing suite for web applications across different browsers and platforms.
• Selenium is a set of different software tools each with a different approach to supporting test automation. Selenium is composed of multiple software tools. Each has a specific role.

1. Selenium WebDriver
2. RC or Remote Control
3. Selenium IDE
4. Selenium-Grid

How to use the update command in MySQL

Update command-  

• To update the department & mobile no of suneel

Query-
update employee set Department= ‘IT’, salary= ‘15000’ where Emp_ID= 5775

update user_leave_balance set cl_balance= ’20’ where Emp_id=’005969′; 

How to use ORDER BY query in MySQL

ORDER BY Query:

• used to sort the result-set by one or more columns
• ORDER BY keyword sorts the records in ascending order by
• To sort the records in a descending order, you can use the
• By default, it’s ascending order

Query –

select Salary from employee order by Salary 

 

 

 

select Emp_ID,FirstName,LastName,Department,Mobile_No,Salary,Address from employee order by Salary

How to insert data into table in MySQL

Insert data into table- 

Query-
insert into employee
( Emp_ID,FirstName,LastName,Department,Mobile_No,Salary,Address)
values(5776,’Zahid’,’Iqbal’,’Computer’,12345,11000,’Chandigarh’)

Import the data from excel 

• Data should be arrange in the table format and save the .csv format
• Now select the import and choose the file
• Now data are inserted into the table.

After inserting the data table is-

How to create the table in MySQL

Create the table in MySQL

Create table employee
( Emp_ID varchar(255),FirstName varchar(255),LastName varchar(255),Department varchar(255),Mobile_No int,Salary int,Address varchar()
);