Page 120 - Computer Software Application TP - Volume 1

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