Welcome, Guest! Sign Up RSS

TUTORIAL

Saturday, 2017-10-21
Main » MySQL
-- List of world's countries containing the official short names in English as given in ISO 3166-1,
-- the ISO 3166-1-alpha-2 code provided by the International Organization for Standardization
-- (http://www.iso.org/iso/prods-services/iso3166ma/02iso-3166-code-lists/country_names_and_code_elements)
-- and the ISO alpha-3 code provided by the United Nations Statistics Division
-- (http://unstats.un.org/unsd/methods/m49/m49alpha.htm)
--
-- compiled by Stefan Gabos
-- version 1.2 (last revision: December 09, 2012)
--
-- http://stefangabos.ro/other-projects/list-of-world-countries-with-national-flags/

DOWNLOAD
Category: MySQL | Views: 304 | Added by: joao_franco | Date: 2013-11-30 | Comments (0)

Contoh View dari tabel penjualan dan tabel barang yang telah dibuat pada tutorial sebelumnya di sini

Code
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `jualdetail` AS select `p`.`kd_brg` AS `kd_brg`,`b`.`nm_brg` AS `nm_brg`,`b`.`mrk_brg` AS `mrk_brg`,`b`.`kat_brg` AS `kat_brg`,`b`.`harga` AS `harga`,`p`.`jumlah` AS `jumlah`,`p`.`harga` AS `harga total`,`p`.`nm_pembeli` AS `nm_pembeli`,`p`.`tanggal` AS `tanggal` from (`tbbarang` `b` join `tbpenjualan` `p`) where (`p`.`kd_brg` = `b`.`no_brg`) order by `p`.`tanggal`;

... Read more »
Attachments: Image 1
Category: MySQL | Views: 413 | Added by: joao_franco | Date: 2013-11-28 | Comments (1)

Contoh tabel penjualan

Code
CREATE TABLE IF NOT EXISTS `tbpenjualan` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `kd_brg` varchar(200) NOT NULL,
  `nm_pembeli` varchar(200) NOT NULL,
  `tanggal` date NOT NULL,
  `jumlah` int(10) NOT NULL,
  `harga` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

... Read more »
Attachments: Image 1 ·Image 2
Category: MySQL | Views: 257 | Added by: joao_franco | Date: 2013-11-28 | Comments (0)