Search
 
SCRIPT & CODE EXAMPLE
 

SQL

psql while loop

do $$
declare
add integer := 0;
begin
while add <10 loop
raise notice 'Out addition count %', add;
add := add+1;
end loop;
end$$;
Comment

PREVIOUS NEXT
Code Example
Sql :: sql add column after another column 
Sql :: mysql columns values as comma separated string 
Sql :: begin transaction in sql 
Sql :: delete top N rows in sql 
Sql :: restore postgres database from dump 
Sql :: add column with foreign key constraint sql server 
Sql :: sql offset 
Sql :: python sqlalchemy connection show server 
Sql :: sql backup database statement 
Sql :: oracle difference between two dates in seconds 
Sql :: postgresql extract hour and minutes from timestamp 
Sql :: Write a query to create an empty table from an existing table? 
Sql :: mysql limit rows 
Sql :: ubuntu connect to mssql database 
Sql :: SHOW COLUMNS Statement 
Sql :: mysql grant access to one database 
Sql :: how to update random rows in sql 
Sql :: display 2 numbers after decimal mysql 
Sql :: t-sql merge example 
Sql :: enable sql server full text indexing 
Sql :: How to drop a foreign key constraint in mysql ? 
Sql :: sql declare table variable 
Sql :: sql only five first row 
Sql :: mysql get last insert id 
Sql :: show table postgres command 
Sql :: sql server insert into select 
Sql :: t-sql drop function if exists 
Sql :: update table disable constraint 
Sql :: sql left characters 
Sql :: sp in sql server 
ADD CONTENT
Topic
Content
Source link
Name
3+5 =