\n Using the MySQL workbench 8.0 CE\n <\/p>\n
\n Modifying Tables\n <\/p>\n
\n Using the My Guitar Shop database , develop the following queries.\n <\/p>\n
\n To test whether a table has been modified correctly as you do these exercises, you can write and run an appropriate SELECT statement.\n <\/p>\n
\n category_name:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Brass\n <\/p>\n
\n Code the INSERT statement so MySQL automatically generates the category_id column. Execute the query and take a screenshot of the query and the results.\n <\/p>\n
\n product_id:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 The next automatically generated ID\n <\/p>\n
\n category_id:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4\n <\/p>\n
\n product_code:\u00a0\u00a0 dgx_640\n <\/p>\n
\n category_name:\u00a0\u00a0\u00a0 Yamaha DGX 640 88-Key Digital Piano\n <\/p>\n
\n description:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Long description to come.\n <\/p>\n
\n list_price:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 799.99\n <\/p>\n
\n discount_percent:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\n <\/p>\n
\n date_added:\u00a0\u00a0\u00a0\u00a0\u00a0 Today\u2019s date\/time.\n <\/p>\n
\n Use a column list for this statement. Execute the query and take a screenshot of the query and the results.\n <\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
Using the MySQL workbench 8.0 CE Modifying Tables Using the My Guitar Shop database , develop the following queries. To test whether a table has been modified correctly as you do these exercises, you can write and run an appropriate SELECT statement. Write an INSERT statement that adds this row to the Categories table: category_name:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_joinchat":[]},"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/posts\/254232"}],"collection":[{"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/comments?post=254232"}],"version-history":[{"count":1,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/posts\/254232\/revisions"}],"predecessor-version":[{"id":256055,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/posts\/254232\/revisions\/256055"}],"wp:attachment":[{"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/media?parent=254232"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/categories?post=254232"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/tags?post=254232"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}