MySQL - Tutorial - Tutorial

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: 911 | Added by: joao_franco | Date: 2013-11-30 | Comments (0)

Cara Membuat View dengan MySQL

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`;

Attachments: Image 1

Category: MySQL | Views: 985 | Added by: joao_franco | Date: 2013-11-28 | Comments (0)

Cara Membuat Tabel dengan MySQL

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;

Attachments: Image 1 ·Image 2