Posts by CarrieStark • 1 point
4 posts
-
0
votes1
answer23
viewsA: PROCEDURE ERROR PERFORMS ONLY ONCE AFTER GOING MYSQL CONDITION
Apparently, when using INTO in some query it returns 1, with this it was giving error inserting only one because it assigned my variable endDoCursor the value of one or if I removed DECLARE CONTINUE…
-
-3
votes1
answer23
viewsQ: PROCEDURE ERROR PERFORMS ONLY ONCE AFTER GOING MYSQL CONDITION
I have a problem in my past, the scenario is that I have null and not null values that are primary key fields, I am making a Datawarehouse. As all these values need to be calculated, when running…
-
0
votes1
answer147
viewsA: How to create a function to delete all database records with Postgresql?
With the help of the comments I was able to finish my job. Follow: CREATE OR REPLACE FUNCTION public.funcao_zerar_banco_dados() RETURNS VOID AS $$ DECLARE tabelas RECORD; sequencia RECORD; BEGIN --…
-
-2
votes1
answer147
viewsQ: How to create a function to delete all database records with Postgresql?
I need to create a script to delete all records from my database in all tables, without deleting the tables and restarting the sequence. I know I should use the TRUNCATE or the DELETE. My bank has…