question archive Create a new table in the ap database using the code below
Create a new table in the ap database using the code below
Subject:Computer SciencePrice: Bought3
Create a new table in the ap database using the code below. CREATE TABLE `new invoice records new invoice record id' int (11) NOT NULL AUTO INCREMENT, `new invoice record text' varchar (255) DEFAULT NULL, `new invoice record timestamp datetime DEFAULT NULL, PRIMARY KEY ( new invoice record id ) ) ENGINE=InnoDB Develop a trigger that will execute when a new record is added into the invoice table, and will add to the new invoice records table a new row with the following values: 1) An auto-incremented ID value into the new invoice records column, 2) A text message value, "You have added a new invoice from <vendor name> with an invoice total of $<invoice total value>", into the new invoice records column,
