Definitions More Info.
Definition ID	691
Title	POSTGRESQL
Category	NOTES
Definition	Simple WHILE operation gelismis
Definition Description	pagila veritabanindaki film tablosu icindeki kayitlari film_yedek icinde cogaltmak icin kullanilan dongu DO $$ DECLARE i integer; BEGIN i:=0; while (i<=100) loop BEGIN RAISE NOTICE 'number %', i; INSERT INTO film_yedek( title, description, release_year, language_id, rental_duration, rental_rate, length, replacement_cost, rating, last_update, special_features, fulltext) SELECT title, description, release_year, language_id, rental_duration, rental_rate, length, replacement_cost, rating, last_update, special_features, fulltext FROM film; i=i+1; END; end loop; END $$;
RecordBy	cunay
Record Date	22-12-2015 11:22:15
Düzenle
Kopyala
Sil