Categories: MySQL

Manage Triggers in MySQL

Share

Here you will learn how to manage triggers like modifying, removing etc.

To display the trigger use following sql:

SELECT * FROM Information_Schema.Triggers WHERE Trigger_schema = 'database_name' AND Trigger_name = 'trigger_name';

To view trigger:

SHOW TRIGGERS;

To drop a trigger:

DROP TRIGGER tbl_name.trigger_name

Recent Posts

What Is Commonly Misdiagnosed as Pink Eye: Understanding Eye Conditions and Their Symptoms

Introduction: Pink eye, or conjunctivitis, is a common eye condition characterized by redness and inflammation…

3 hours ago

Why Flexible Financing is the Future of Small Business

Small businesses are the backbone of the economy. Still, they often face daunting hurdles when…

10 hours ago

Warm Comfort: Choosing the Best Hot Water Bottle for Cozy Nights

Introduction: As the chill of winter settles in or a bout of cold weather strikes,…

1 day ago

One Location, Different Perspectives: The Allure of Dubai Marina Apartments

Nestled along the glittering waterfront of the City of Gold, Dubai Marina beckons to discerning…

1 day ago

How to launch a successful online dating app?

If you want to open a match-making dating app in the wide digital market and…

1 day ago

Role Of Gojek Clone In Growth Campaigns For Your Business

When was the last time you heard that a clone app like Gojek could efficiently…

1 day ago