Sabtu, 18 Juni 2022

XSL | XML

XSL

My CD Collection

Title:

Artist:

XML

<?xml version="1.0" encoding="UTF-8"?>
<catalog>
  <cd>
    <title>Empire Burlesque</title>
    <artist>Bob Dylan</artist>
    <country>USA</country>
    <company>Columbia</company>
    <price>10.90</price>
    <year>1985</year>
  </cd>
  <cd>
    <title>Hide your heart</title>
    <artist>Bonnie Tyler</artist>
    <country>UK</country>
    <company>CBS Records</company>
    <price>9.90</price>
    <year>1988</year>
  </cd>
  <cd>
    <title>Greatest Hits</title>
    <artist>Dolly Parton</artist>
    <country>USA</country>
    <company>RCA</company>
    <price>9.90</price>
    <year>1982</year>
  </cd>
  <cd>
    <title>Still got the blues</title>
    <artist>Gary Moore</artist>
    <country>UK</country>
    <company>Virgin records</company>
    <price>10.20</price>
    <year>1990</year>
  </cd>
  <cd>
    <title>Eros</title>
    <artist>Eros Ramazzotti</artist>
    <country>EU</country>
    <company>BMG</company>
    <price>9.90</price>
    <year>1997</year>
  </cd>
  <cd>
    <title>One night only</title>
    <artist>Bee Gees</artist>
    <country>UK</country>
    <company>Polydor</company>
    <price>10.90</price>
    <year>1998</year>
  </cd>
  <cd>
    <title>Sylvias Mother</title>
    <artist>Dr.Hook</artist>
    <country>UK</country>
    <company>CBS</company>
    <price>8.10</price>
    <year>1973</year>
  </cd>
  <cd>
    <title>Maggie May</title>
    <artist>Rod Stewart</artist>
    <country>UK</country>
    <company>Pickwick</company>
    <price>8.50</price>
    <year>1990</year>
  </cd>
  <cd>
    <title>Romanza</title>
    <artist>Andrea Bocelli</artist>
    <country>EU</country>
    <company>Polydor</company>
    <price>10.80</price>
    <year>1996</year>
  </cd>
  <cd>
    <title>When a man loves a woman</title>
    <artist>Percy Sledge</artist>
    <country>USA</country>
    <company>Atlantic</company>
    <price>8.70</price>
    <year>1987</year>
  </cd>
  <cd>
    <title>Black angel</title>
    <artist>Savage Rose</artist>
    <country>EU</country>
    <company>Mega</company>
    <price>10.90</price>
    <year>1995</year>
  </cd>
  <cd>
    <title>1999 Grammy Nominees</title>
    <artist>Many</artist>
    <country>USA</country>
    <company>Grammy</company>
    <price>10.20</price>
    <year>1999</year>
  </cd>
  <cd>
    <title>For the good times</title>
    <artist>Kenny Rogers</artist>
    <country>UK</country>
    <company>Mucik Master</company>
    <price>8.70</price>
    <year>1995</year>
  </cd>
  <cd>
    <title>Big Willie style</title>
    <artist>Will Smith</artist>
    <country>USA</country>
    <company>Columbia</company>
    <price>9.90</price>
    <year>1997</year>
  </cd>
  <cd>
    <title>Tupelo Honey</title>
    <artist>Van Morrison</artist>
    <country>UK</country>
    <company>Polydor</company>
    <price>8.20</price>
    <year>1971</year>
  </cd>
  <cd>
    <title>Soulsville</title>
    <artist>Jorn Hoel</artist>
    <country>Norway</country>
    <company>WEA</company>
    <price>7.90</price>
    <year>1996</year>
  </cd>
  <cd>
    <title>The very best of</title>
    <artist>Cat Stevens</artist>
    <country>UK</country>
    <company>Island</company>
    <price>8.90</price>
    <year>1990</year>
  </cd>
  <cd>
    <title>Stop</title>
    <artist>Sam Brown</artist>
    <country>UK</country>
    <company>A and M</company>
    <price>8.90</price>
    <year>1988</year>
  </cd>
  <cd>
    <title>Bridge of Spies</title>
    <artist>T`Pau</artist>
    <country>UK</country>
    <company>Siren</company>
    <price>7.90</price>
    <year>1987</year>
  </cd>
  <cd>
    <title>Private Dancer</title>
    <artist>Tina Turner</artist>
    <country>UK</country>
    <company>Capitol</company>
    <price>8.90</price>
    <year>1983</year>
  </cd>
  <cd>
    <title>Midt om natten</title>
    <artist>Kim Larsen</artist>
    <country>EU</country>
    <company>Medley</company>
    <price>7.80</price>
    <year>1983</year>
  </cd>
  <cd>
    <title>Pavarotti Gala Concert</title>
    <artist>Luciano Pavarotti</artist>
    <country>UK</country>
    <company>DECCA</company>
    <price>9.90</price>
    <year>1991</year>
  </cd>
  <cd>
    <title>The dock of the bay</title>
    <artist>Otis Redding</artist>
    <country>USA</country>
    <company>Stax Records</company>
    <price>7.90</price>
    <year>1968</year>
  </cd>
  <cd>
    <title>Picture book</title>
    <artist>Simply Red</artist>
    <country>EU</country>
    <company>Elektra</company>
    <price>7.20</price>
    <year>1985</year>
  </cd>
  <cd>
    <title>Red</title>
    <artist>The Communards</artist>
    <country>UK</country>
    <company>London</company>
    <price>7.80</price>
    <year>1987</year>
  </cd>
  <cd>
    <title>Unchain my heart</title>
    <artist>Joe Cocker</artist>
    <country>USA</country>
    <company>EMI</company>
    <price>8.20</price>
    <year>1987</year>
  </cd>
</catalog>

Empire Burlesque Bob Dylan USA Columbia 10.90 1985 Hide your heart Bonnie Tyler UK CBS Records 9.90 1988 Greatest Hits Dolly Parton USA RCA 9.90 1982 Still got the blues Gary Moore UK Virgin records 10.20 1990 Eros Eros Ramazzotti EU BMG 9.90 1997 One night only Bee Gees UK Polydor 10.90 1998 Sylvias Mother Dr.Hook UK CBS 8.10 1973 Maggie May Rod Stewart UK Pickwick 8.50 1990 Romanza Andrea Bocelli EU Polydor 10.80 1996 When a man loves a woman Percy Sledge USA Atlantic 8.70 1987 Black angel Savage Rose EU Mega 10.90 1995 1999 Grammy Nominees Many USA Grammy 10.20 1999 For the good times Kenny Rogers UK Mucik Master 8.70 1995 Big Willie style Will Smith USA Columbia 9.90 1997 Tupelo Honey Van Morrison UK Polydor 8.20 1971 Soulsville Jorn Hoel Norway WEA 7.90 1996 The very best of Cat Stevens UK Island 8.90 1990 Stop Sam Brown UK A and M 8.90 1988 Bridge of Spies T`Pau UK Siren 7.90 1987 Private Dancer Tina Turner UK Capitol 8.90 1983 Midt om natten Kim Larsen EU Medley 7.80 1983 Pavarotti Gala Concert Luciano Pavarotti UK DECCA 9.90 1991 The dock of the bay Otis Redding USA Stax Records 7.90 1968 Picture book Simply Red EU Elektra 7.20 1985 Red The Communards UK London 7.80 1987 Unchain my heart Joe Cocker USA EMI 8.20 1987

Konten SQL

Sintaks SQL

❮ Sebelumnya Berikutnya ❯

Tabel Database

Database paling sering berisi satu atau beberapa tabel. Setiap tabel diidentifikasi dengan nama (misalnya "Pelanggan" atau "Pesanan"). Tabel berisi rekaman (baris) dengan data.

Dalam tutorial ini kita akan menggunakan database sampel Northwind yang terkenal (termasuk dalam MS Access dan MS SQL Server).

Di bawah ini adalah pilihan dari tabel "Pelanggan":

CustomerID	CustomerName	ContactName	Address	City	PostalCode	Country
1	Alfreds Futterkiste	Maria Anders	Obere Str. 57	Berlin	12209	Germany
2	Ana Trujillo Emparedados y helados	Ana Trujillo	Avda. de la Constitución 2222	México D.F.	05021	Mexico
3	Antonio Moreno Taquería	Antonio Moreno	Mataderos 2312	México D.F.	05023	Mexico
4	Around the Horn	Thomas Hardy	120 Hanover Sq.	London	WA1 1DP	UK
5	Berglunds snabbköp	Christina Berglund	Berguvsvägen 8	Luleå	S-958 22	Sweden

Tabel di atas berisi lima catatan (satu untuk setiap pelanggan) dan tujuh kolom (CustomerID, CustomerName, ContactName, Address, City, PostalCode, dan Country).

Pernyataan SQL

Sebagian besar tindakan yang perlu Anda lakukan pada database dilakukan dengan pernyataan SQL.

Pernyataan SQL berikut memilih semua rekaman dalam tabel "Pelanggan":

Contoh

SELECT * FROM Customers;

Cobalah sendiri »

Dalam tutorial ini kami akan mengajari Anda semua tentang pernyataan SQL yang berbeda.

Keep in Mind That...

SQL keywords are NOT case sensitive: is the same as select SELECT

In this tutorial we will write all SQL keywords in upper-case.

Semicolon after SQL Statements?

Some database systems require a semicolon at the end of each SQL statement.

Semicolon is the standard way to separate each SQL statement in database systems that allow more than one SQL statement to be executed in the same call to the server.

In this tutorial, we will use semicolon at the end of each SQL statement.

Some of The Most Important SQL Commands

SELECT - extracts data from a database
UPDATE - updates data in a database
DELETE - deletes data from a database
INSERT INTO - inserts new data into a database
CREATE DATABASE - creates a new database
ALTER DATABASE - modifies a database
CREATE TABLE - creates a new table
ALTER TABLE - modifies a table
DROP TABLE - deletes a table
CREATE INDEX - creates an index (search key)
DROP INDEX - deletes an index

❮ Previous Next ❯

BARU

Kami baru saja meluncurkan
video W3Schools

Jelajahi sekarang

PEMILIH WARNA

Dapatkan sertifikasi dengan

menyelesaikan kursus SQL
hari ini!

Memulai

PERMAINAN KODE

Play Game

Kamis, 09 Juni 2022

Tema-tema Blog

https://newbloggerthemes.com/

https://childthemewp.com/gridwp/

http://www.skincorner.com/

Kamis, 02 Juni 2022

Rumus Fullskrin dan Prakteknya

.overlaykencakatengen {
  height: 100%;
  width: 0;
  position: fixed;
  z-index: 1;
  top: 0;
  left: 0;
  background-color: rgb(0,0,0);
  background-color: rgba(0,0,0, 0.9);
  overflow-x: hidden;
  transition: 0.5s;
}

.overlaykencakatengen-konten {
  position: relative;
  top: 25%;
  width: 100%;
  text-align: center;
  margin-top: 30px;
  background: yellow;
  padding: 5px
}

.overlaykencakatengen-isikonten {
  position: relative;
  top: 25%;
  width: cal(100%-10px);
  text-align: center;
  margin-top: 30px;
  background: green;
  padding: 5px
}

.overlaykencakatengen a {
  padding: 8px;
  text-decoration: none;
  font-size: 36px;
  color: #818181;
  display: block;
  transition: 0.3s;
}

.overlaykencakatengen a:hover, .overlaykencakatengen a:focus {
  color: #f1f1f1;
}

.overlaykencakatengen .tutupbtn {
  position: absolute;
  top: 20px;
  right: 45px;
  font-size: 60px;
}

@media screen and (max-height: 450px) {
  .overlaykencakatengen a {font-size: 20px}
  .overlaykencakatengen .tutupbtn {
  font-size: 40px;
  top: 15px;
  right: 35px;
  }
}
</style>

<div id="drcjgteaNavikencakatengen" class="overlaykencakatengen">
  <a href="javascript:void(0)" class="tutupbtn" onclick="tutupNav()">×</a>
  <div class="overlaykencakatengen-konten">
    <div class="overlaykencakatengen-isikonten">
    <a href="#">Tentang</a>
    <a href="#">Layanan</a>
    <a href="#">Kelayan</a>
    <a href="#">Kontak</a>
    </div>
  </div>
</div>

<h2>Judul</h2>
<p>Deskripsi - Penjelasan.</p>
<p>Silahkan perhatikan secara seksama:</p>
<span style="font-size:30px;cursor:pointer" onclick="bukaNav()">☰ buka</span>

function tutupNav() {
  document.getElementById("drcjgteaNavikencakatengen").style.width = "0%";
}
</script>

Hasilnya adalah seperti di bawah ini

Overlay dari kiri ke kanan (Bahasa Sunda: ti kenca ka katuhu - ti kiwa ka tengen)

Silahkan baca. Mangga pintonan, rumus bmtt (bahasa mesin tingkat tinggi)na aya di luhur.

Semoga bermanfaat. Wassalam.

Tentang Layanan Kelayan Kontak

Judul

Deskripsi - Penjelasan.

Silahkan perhatikan secara seksama:

☰ buka

D'RID-ONE PUTRA MENA-ONE NGAWEB

AKSELELATOR DURIDWANGURUNATAFKAR

Sabtu, 18 Juni 2022

XSL | XML

My CD Collection

Konten SQL

SQL Tutorial

SQL Basis data

SQL Referensi

SQL Contoh

Sintaks SQL

Tabel Database

Pernyataan SQL

Contoh

Keep in Mind That...

Semicolon after SQL Statements?

Some of The Most Important SQL Commands

PEMILIH WARNA

PERMAINAN KODE

Top Tutorials

Top References

Top Examples

Web Courses

Kamis, 09 Juni 2022

Tema-tema Blog

Kamis, 02 Juni 2022

Rumus Fullskrin dan Prakteknya

Judul

AKSELELATOR DURIDWANGURUNATFKAR | drAPACEU

Laporkan Penyalahgunaan

Label