Page 120 - Computer Software Application TP - Volume 1
P. 120
COMPUTER SOFTWARE APPLICATION - CITS
EXERCISE 32 : Creating and executing MySQL table
level Triggers
Objectives
At the end of this exercise you shall be able to
• create the table level triggers
• use the table level triggers
Requirements
Tools/Materials
• Desktop/Laptop with latest configuration
• Operating system: window 10:11
• XAMPP server r3.3.0
Procedure
TASK 1 :Create & execute triggers
1 Connect to Your Database –
mysql -u your username –p
Enter your password when prompted.
Select Your Database –
USE your database name;
Replace your database name with the name of your actual database.
2 Create a table –
Let’s create a simple table for this example:
CREATE TABLE example table (
id INT PRIMARY KEY AUTO INCREMENT,
data VARCHAR(255),
created at TIMESTAMP DEFAULT CURRENT TIMESTAMP
);
105
CITS : IT & ITES - Computer Software Application - Exercise 31