Question: DO THIS ON MariaDB . show the code and screenshot 1. Create a database named 'mydatabase'. 2. Within 'mydatabase', create a table named 'mytable' with

DO THIS ON MariaDB .

show the code and screenshot

1. Create a database named 'mydatabase'.

2. Within 'mydatabase', create a table named 'mytable' with the following columns: id set to integer of 2 characters, name set to varchar of 10 characters, and age set to integer of 2 characters.

3. Create a user named 'myuser' with password set to 'mypass'.

4. Grant 'myuser' with all the privileges to only mytable from mydatabase.

5. Create a view named 'myview' for 'mytable' that only queries the the columns 'id' and 'age'.

6. Insert the following information into 'mytable': 1, ricky bobby, 32

7. Display all the columns in 'myview'.

8. Insert the following information into 'mytable' in the name column: Ricky Bobby.

9. In 'mytable', set id equal 2 where name is equal to 'Ricky Bobby'

10. Delete 'mytable' from 'mydatabase'.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!