Create a table of animals that includes a text-type column (e.g. varchar or text) called "animal_name".
Create a trigger that prevents you from inserting any animal name containing the word "cat". E.g. "Wildcat", "Housecat", etc.
If someone tries to insert any kind of cat, the trigger should insert "xxx" instead and should log the attempted entry, including the animal name,
in a "violations" table, along with the date and time it occurred.
Animals
primary key
animal name
(anything else)
Violations
primary key
animal name
date and time
135个mysql入门语法sql案例资源集合.zip
需积分: 1 121 浏览量
2023-08-11
10:25:04
上传
评论
收藏 813KB ZIP 举报
135个mysql入门语法sql案例集合.zip （63个子文件） 
135个mysql入门语法sql案例集合 
066_Indexing_Multiple_Columns.sql 65B makefile 5KB
out.png 830KB 044_Solutions3.sql 2KB 012_Exporting_Data.sql 2KB 071_With_Check_Option.sql 390B 123_Solutions4.sql 6KB 111_Transactional_Withdrawal.sql 513B 048_Joins_and_Cartesian_Products.sql 163B 106_Out_Parameters.sql 401B 108_If.sql 256B 055_Joining_Tables_to_Themselves.sql 383B 120_Case_Expression.sql 2KB 069_Views.sql 369B 087_Select_for_Update.sql 458B 119_Fetching_Cursor_Data_With_Loops.sql 854B 065_Adding_Indexes.sql 311B 116_Generating_Random_Data.sql 474B 115_Labelled_Loops.sql 450B 089_String_functions.sql 307B 124_Introducing_Triggers.sql 791B 056_Restrict.sql 1KB 088_Lock_in_Share_Mode.sql 652B 054_Many_to_Many.sql 631B 020_Solutions1.sql 993B 128_Solution5.sql 679B 050_Left_and_Right_Outer_Joins.sql 401B 110_Account_Withdrawal.sql 615B 109_Local_Variables.sql 297B 099_Hello_World.sql 227B 015_Some_Test_Data.sql 2KB 077_Fixing_Select_Update_With_Table_Locks.sql 337B 091_Control_Flow_Functions.sql 567B 102_Procedure_Permissions.sql 733B 040_Health_Database.sql 15KB clean.sql 121B 126_Triggers_and_Transactions.sql 1KB 059_Online_Shop.sql 2KB 076_Select_Update_Example.sql 449B 101_Procedure_Permission_Example.sql 502B 051_Joins_Between_Pairs_of_Tables.sql 185B 046_Foreign_Keys.sql 714B 113_Error_Handlers.sql 664B 063_Adding_Columns.sql 238B 100_Setting_the_Definer.sql 377B 070_View_Algorithms.sql 445B 075_Setting_Variables_With_Selects.sql 148B 064_Adding_Foreign_keys.sql 549B 114_While_Loops.sql 318B 130_Defining_Functions.sql 674B 103_Passing_Parameters.sql 219B 118_Cursors.sql 341B 079_A_Simple_Transaction.sql 365B 090_Date_Functions.sql 517B 092_Casting.sql 138B 117_A_Data_Generating_Procedure.sql 1KB 049_Inner_Joins.sql 170B 125_Triggers_and_Validation.sql 623B 074_Using_Variables.sql 182B
127_Triggers_Exercise.txt 547B 035_Solutions2.sql 2KB 082_Demonstrating_Isolation_Levels_and_Row_Locking.sql 386B 135_Art_Shop.sql 2KB资源评论
