1. Create a table with the following structure in PhPMyAdmin. Assign userID as the primary key.

2. Verify other fields (userID and password) one by one, and write your query to show all information from the given userID from the user table.

3. Write a query to show the name from the user table based on the given userID and password.

4. Write a query to list all users' names and their ID's.

Write a query which updates a user's password based on a given userID.

Write a query to delete a user's record based on the given userID

Also fill in the blanks for the IF statements in the code.

3. Create a table with the following structure in PhPMyAdmin. Assign userID as the primary key. user (userID, name, password) Type varchar(10) varchar(10) latin1_swedish_ci Collation Attributes Null Default Name userID 2 name # No None No None No None 1 latin 1-swedish-ci 3 password varchar( 10) latin1_swedish_ci