Question: Using the World War II database, write a transaction that -Deletes all German ship in all the tables -Add a new ship for USA That
Using the World War II database, write a transaction that
-Deletes all German ship in all the tables
-Add a new ship for USA
That is you want to ensure that both delete and insert will occur together

mysql> SELECT FROM Ships; name | class | launched | 1921 | 1915 | 1914 | 1943 1915 | 1913 | 1944 | 1942 I 1943 1941 | 1917 | 1916 | 1916 | 1916 | 1916 | 1916 | 1916 | 1916 | 1916 | 1920 I 1941 | 1944 | 1941 | | California | Tennessee | Kongo | Kongo | Iowa | Kongo | Kongo | Iowa | Yamato | Iowa Haruna Hiei | Iowa | Kirishima | Kongo | Missouri |Musashi |New Jersey | North Carolina North Carolina | | Ramillies |Renowrn |Renowrn |Revenge |Renowrn |Renowrn |Renowrn |Renowrn |Revenge |Revenge |Revenge Repulse Repulse | Resolutiorn |Revenge | Royal 0ak | Royal Sovereign | Revenge | Tennessee | Washington | Tennessee | North Carolina | Iowa | Yamato Wisconsin | Yamato 23 rows in set (0.00 sec) mysql>
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
