Hello, how can I clear all triggers on a particular

I did read it . Its done in loop in procedure . I m searching for a straight SQL query that can be fired via php . But seems there is no provision for the same

0

17 дней назад

Rafael Dias

Innocent Devil
I did read it . Its done in loop in procedure . I ...

Well, it's a shame. Of course, remove the "limit 4" from the SQL to test it.

0

17 дней назад

Stefanie Janine Stölting

Innocent Devil
I did read it . Its done in loop in procedure . I ...

There's not a one query thing available to ruine your data integrity by disabling all triggers. Make a procedure of the code @CaptainKirkFan published and than it's one stupid query to run from your php source code. Or change the session as Marcos showed you. If you don't want to handles databases, write your data to files.

0

16 дней назад

Innocent Devil Автор вопроса

Stefanie Janine Stölting
There's not a one query thing available to ruine y...

Yeah got it . Thanks everyone

0

16 дней назад

Kirk · Accepted Answer

Which tool? Is a stored procedure Acceptable. But you must loop over all the tables involved. (information_schrema.tables) and then ALTER TABLE <tbl> DISABLE TRIGGER ALL; select FORMAT('ALTER TABLE %I.%I DISABLE TRIGGER all;',table_schema,table_name) as cmd from i nformation_schema.tables limit 4; And as a pseudo function: DO $$ DECLARE cur_tables CURSOR FOR select FORMAT('ALTER TABLE %I.%I DISABLE TRIGGER all;',table_schema,table_name) as cmd from information_schema.tables limit 4; BEGIN FOR cval in cur_tables LOOP RAISE NOTICE 'EXECUTE(%);', cval.cmd; -- EXECUTE cval.cmd; -- The Real Command END LOOP; END; $$; But be careful, get the schema_name filtered down to your tables.

169 похожих чатов

Hello, how can I clear all triggers on a particular

9 ответов

Похожие вопросы