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
Get step-by-step solutions from verified subject matter experts
