sql structure query language tingkat lanjut n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
SQL (Structure Query Language) Tingkat Lanjut PowerPoint Presentation
Download Presentation
SQL (Structure Query Language) Tingkat Lanjut

Loading in 2 Seconds...

play fullscreen
1 / 9

SQL (Structure Query Language) Tingkat Lanjut - PowerPoint PPT Presentation


  • 203 Views
  • Uploaded on

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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'SQL (Structure Query Language) Tingkat Lanjut' - zeroun


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
store procedure di mysql
Store Procedure Di MySQL
  • Store Procedure adalahinovasiterbaikdariMySQL 5.0. beberapa SQL prosedurataufungsidapatdisimpandandieksekusilangsungdiMySQL server. Layaknyapadapenulisan code dibahasapemrogramanseperti C programming, penulisanprosedurdanfungsikinibisadigunakanpadaMySQL
kegunaan prosedur atau fungsi

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,

slide4

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’);

slide5

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

membuat prosedur
MembuatProsedur
  • BerikutinikitapraktikanmembuatprosedursederhanadiMySQL.
  • Pertama, kitabuat database dan table baruuntukpercobaanbelajarkitamengenaiprosedur. Disinidibuatdatabase dengannamaprosedur_test.
  • Create database prosedur_test;
membuat prosedur1
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

membuat prosedur2
MembuatProsedur
  • Awalnyakitamestimengganti delimiter

(tandaakhir code, defaultnyaadalah

titikkomadengan symbol lain.

Delimiter $

  • Setelahkitagantidelimiternya,

sekarangbuatprosedurnya

slide9

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