demo_db. Set up a user called demo who is given full access to the
demo_db database from localhost. Log in to mysql as demo and modify
the database by creating a table called fun with two columns. Add several
rows to fun. Be prepared to show your table to the lab instructor on lab
day.
You can use these SQL commands to create and populate a table or you can make your own:
CREATE TABLE fun ( fun_id INTEGER, desc VARCHAR(80) ); INSERT INTO fun (fun_id, desc) VALUES (1, 'This'); INSERT INTO fun (fun_id, desc) VALUES (2, 'is'); INSERT INTO fun (fun_id, desc) VALUES (3, 'super'); INSERT INTO fun (fun_id, desc) VALUES (4, 'fun!');