1 / 9

SQL (Structure Query Language) Tingkat Lanjut

SQL (Structure Query Language) Tingkat Lanjut. Endah Priyanti , S.Kom. Store Procedure Di  MySQL.

zeroun
Download Presentation

SQL (Structure Query Language) Tingkat Lanjut

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. SQL (Structure Query Language) Tingkat Lanjut EndahPriyanti, S.Kom

  2. Store Procedure Di MySQL • Store Procedure adalahinovasiterbaikdariMySQL 5.0. beberapa SQL prosedurataufungsidapatdisimpandandieksekusilangsungdiMySQL server. Layaknyapadapenulisan code dibahasapemrogramanseperti C programming, penulisanprosedurdanfungsikinibisadigunakanpadaMySQL

  3. KegunaanProseduratauFungsi KegunaandariadanyaprosedurataufungsipadaMySQLadalah : Mempercepatproses coding ( efesiensi) maksudnyabilakitamengetikan SQL yang isinyamemasukan data (insert) misalnya Insert into anggota values (1,’adiputra’,’bekasi’,’ad1.putr4@yahoo.co.id’); Sebanyak1000 anggota, makaakanpegelngetikSQLnya. Solusinyaadalahpembuatanprosedursepertiberikutini,

  4. Create procedure insert_anggota (in no int, nm varchar(255), kotavarchar(50), email varchar(255)) Begin Insert into anggota values (no,nm,kota,email); End Nah setelahprosedurinsert_anggotadibuat, kitacukupmemanggilnyadenganperintah call, seperti : Call insert_anggota(1,’adiputra’,’bekasi’,’ad1.putr4@yahoo.co.id’);

  5. Jadilebihmudahkan….ituhanyasecuil code,, danakansangatbergunanantibilabermaindengan data yang lebihbanyaksepertipada data-data perusahaan

  6. MembuatProsedur • BerikutinikitapraktikanmembuatprosedursederhanadiMySQL. • Pertama, kitabuat database dan table baruuntukpercobaanbelajarkitamengenaiprosedur. Disinidibuatdatabase dengannamaprosedur_test. • Create database prosedur_test;

  7. MembuatProsedur • Lalukitabuattablenya, Create table anggota( no int not null primary key, namavarchar(255) not null, k kotavarchar(50) not null, email varchar(255) not null ); Setelahdibuatdatabase dantablenya, Langkahberikutnyaadalahmembuat prosedurnya

  8. MembuatProsedur • Awalnyakitamestimengganti delimiter (tandaakhir code, defaultnyaadalah titikkomadengan symbol lain. Delimiter $ • Setelahkitagantidelimiternya, sekarangbuatprosedurnya

  9. www.animationfactory.com Title Backdrop Slide Backdrop Transitional Backdrop Print Backdrop Backdrops: - These are full sized backdrops, just scale them up! - Can be Copy-Pasted out of Templates for use anywhere! • Additional Graphics: • Scale them up or down! • .GIF clipart is animated. • .JPG clipart can be scaled up and take up little file space. • .PNG clipart can be scaled unusually large without distortion. Animated GIFs Still Frame JPGs

More Related