Toggle navigation
Email or Username
Password
Remember
Login
Register
|
I forgot my password
Questions
Unanswered
Tags
Users
Ask a Question
How to temporarily disable triggers in mysql 5.0?
0
like
0
dislike
13
views
Googled variations on a theme
SET @DISABLE_TRIGER = 1;
SET @DISABLE_TRIGERS = 1;
SET @DISABLE_TRIGGER = 1;
SET @DISABLE_TRIGGERS = 1;
However, they do not work.
Tell me — is there a solution to this problem?
mysql
asked
Mar 22, 2019
by
casey
|
13
views
answer
comment
Please
log in
or
register
to add a comment.
Please
log in
or
register
to answer this question.
1
Answer
0
like
0
dislike
Special session settings to turn off triggers in mysql no.
Where did you Google offered in each trigger write the harness, checking the state of ordinary user-defined variable.
\r
... IF (@DISABLE_TRIGGERS IS NULL) then...
\r
Push +1 and maybe you'll feel better
bugs.mysql.com/bug.php?id=14661
answered
Mar 24, 2019
by
pwlnw
ask related question
comment
Please
log in
or
register
to add a comment.
Related questions
0
like
0
dislike
1
answer
As for MySQL 8.0 to do the dump of the entire database (tables, triggers, stored procedures), but no one signs? How to exclude from the dump of the entire database?
asked
May 21, 2019
by
immelnikoff
mysql
0
like
0
dislike
2
answers
How to work with triggers in MySql?
asked
Jun 8, 2019
by
Alk90
mysql
0
like
0
dislike
3
answers
Check in triggers MySQL
asked
Mar 22, 2019
by
steff
mysql
0
like
0
dislike
2
answers
Triggers in MySQL
asked
Mar 22, 2019
by
steff
mysql
0
like
0
dislike
2
answers
How to prepare MySQL 8.0 dataset of 5 million photos (2 TB) and the text-numerical information (50 GB) for maximum performance on the reading?
asked
May 22, 2019
by
immelnikoff
mysql
Most popular tags
javascript
php
css
html
jquery
wordpress
python
linux
web-development
mysql
android
windows
java
layout
c#
computer-networks
node.js
cpp
iron
yii
vue.js
1C-Bitrix
react
laravel
django
nginx
system-administration
search-engine-optimization
api
ubuntu
the-it-education.
ajax
sql
programming
hosting
cms
design
apache
google-chrome
bootstrap
Vkontakte
macos
google
network-administration
git
laptops
algorithms
regular-expressions
unity-game-engine
email
angular
database
network-equipment
software
wooсommerce
debian
.net
ios
information-security
video
law-in-it
browsers
books
parsing
wi-fi
game-development
career
htaccess
postgresql
telegram
mikrotik
mobile-development
ruby-on-rails
the-domain-name-system
modx
Yandex
c
json
opencart
Habr
freelance
vpn
asp.net
windows-server
symfony
bots
hard-drives
math
qt
DIY
audio
frontend
payment-system
bash
electronics
gulp.js
user-interface
docker
online-shopping
110,608
questions
257,186
answers
0
comments
32,835
users