Mar 01

Displaying or SELECTing Rows or Tuples from a Table

Shout by Imam | No Comments »

In relational database terminology, a table is called a relation, and is denoted by the name of the relation followed by the columns (or attributes), as shown here:

Dependent(pno, dname, relationship, sex, age)

Popularity: 8% [?]

Feb 27

Snap Shoot in Borneo

Shout by Imam | 2 Comments »

Sungai Kahayan

Sungai Kahayan dilihat dari ketinggian. Pantesan pas lagi kecil kalo pulang kampung dari palangka raya ke kapuas atau ke barito bisa makan waktu 2 hari 2 malam :))…Lha wong jalan sungainya aja kayak gitu :p.

hpim3881.jpg

Sungai Kahayan di liat dari udara, tampak dipinggiran hutan-hutannya sudah gundul…

Popularity: 11% [?]

Feb 22

The SELECT Statement

Database by Imam | No Comments »

The SELECT Statement

The first SQL command you will learn, and the one you will use most frequently, is SELECT. In this lesson, you begin by learning how to fetch data records from a single table.

A SELECT statement begins with the SELECT keyword and is used to retrieve information from MySQL database tables. You must specify the table name to fetch data fromusing the FROM keywordand one or more columns that you want to retrieve from that table.

Keywords and Statements

A keyword is a word that is part of the SQL language. In the examples in this book, SQL keywords are always written in capitals, although they are not case sensitive.

A SQL statement begins with a keyword and can contain several more keywords that must appear in the correct, structured wayknown as the statement’s syntax.

Popularity: 9% [?]

Feb 22

Busway Terbakar di Tugu Tani

Shout by Imam | No Comments »

Satu bus Transjakarta terbakar Jumat pagi di kawasan Tugu Tani, Kwitang, Jakarta Pusat, namun belum diketahui adanya korban.”Saya lihat api berasal dari AC di bagian atap, lalu hanya 10 menit kemudian, api sudah membakar sebagian besar bus,”kata Iwan Salami, (38), pengguna kendaraan yang menyaksikan peristiwa itu.

dsc00197.JPG

Popularity: 7% [?]

Feb 22

Daerah yang terkena dampak pemadaman listrik

Shout by Imam | No Comments »

*Area Jaringan* *Daerah yang terkena dampak pemadaman*Selasa, 26 Februari 2008 Gambir (09.00-17.00 WIB) Jl Griya Kemayoran, Gunung Sahari XI dsk (GI-Ancol) ,Jl Meruya Ilir, Jl H Lebar dsk (GI-Kembangan)

Senin, 25 Februari 2008 Gambir (09.00-17.00 WIB) Jl Gunung Sahari dsk (GI-Ancol)

Minggu, 24 Februari 2008 Gambir ( 09.00-17.00 WIB) PT Puninar Sarana Jaya Jl Inspeksi Kali Cakung Drain (GI-Marunda)

Sabtu, 23 Februari 2008 Disjaya (09.00-17.00 WIB) ? Komp Nurtanio, Komp Kodam, Jl Raya Bogor, Cibubur, HUBAD Cijantung, Asrama Polisi Jatibaru, Petamburan, S Parman, Sudirman PDAM Pejompongan, Thamrin, Kb Kacang Raya, Benhil, Percetakan Negara, Menteng, Kwitang, Kramat Jaya, Budi Utomo, Suprapto, Cempaka Baru, Kemayoran, Sunter, Kelapa Gading, Cempaka Putih, Johar Baru 2, Imam Bonjol, Tn Abang, Karet, Slipi dsk

Disjaya ( 13.00-17.00 WIB) Jl Duren Tiga, Raya Buncit, Ps Minggu, Mampang Prapatan, Kemang, Kuningan dsk, Gatot Subroto, Jl. Raya Serang, Curug, Cikupa, Legok Kadu Sirung, Kp Cisoka Balaraja,Jl Ry Serang, Balaraja, Jatake, Ps Kemis, Kp Ganda Sari, Cibodas, Kp Jati Uwung, Cipondoh, Serpong,Modern Land, Daan Mogot, Duri Kosambi, Medan Merdeka Selatan, Taman Pekalongan, Karet, Sudirman, Kamal Cengkareng, Teluk Naga, Taman Suka Tani, Tanah Abang, Slipi, Benhil, Hayam Wuruk, Mangga Besar, Kebon Jeruk, Samanhudi, Gn Sahari, Sawah Besar, Cakung Cilincing, Jl Raya Bekasi, Pegangsaan dsk.

Popularity: 7% [?]

Feb 20

Info SIM dan STNK Keliling

Shout by Imam | 1 Comment »

JAKARTA, KAMIS-Berikut lokasi pelayanan SIM-STNK keliling berdasarkan informasi dari Traffic Management Centre (TMC) Polda Metro Jaya:

1.Jakarta Pusat.
SIM & STNK : PRJ Kemayoran Pintu 6.
2.Jakarta Utara.
.SIM & STNK : Mall Artha Gading.
3.Jakarta Barat.
SIM & STNK :SPBU Raja Mas Glodok .
4.Jakarta Selatan
SIM & STNK :Taman makam Pahlawan Kalibata.
5.Jakarta Timur
STNK:Mesjid at-tin TMII
SIM : (mengalami kerusakan tidak beroperasi)
6. Depok
SIM :Rumah Makan Pujasari ,Sawangan.
7.Tangerang
SIM :Plaza Sinta Karawaci

Popularity: 13% [?]

Feb 20

Opera Mini error

HiTech, Shout, Software by Imam | No Comments »

Hari ini opera mini di BB ane bermasalah. Ketika pengen ngebuka situs selalu muncul error server date time gak matchin sama handheld ane.

Ane coba masuk ke option dan reset seluruh setting aplikasi default. Tapi sebelum masuk ke advanced options ane masuk ke date/time terus coba cek, tampaknya gak ada masalah. Ngeliat jamnya bener, tanggal juga benar.

Popularity: 7% [?]

Feb 20

Conditional Functions in MySQL

Database by Imam | No Comments »

MySQL also includes a set of functions that return their result based on a condition, just like the conditions you use in a WHERE clause.

TRUE and FALSE
Every condition returns a value, TRUE or FALSE, depending on whether the condition is satisfied. There is no Boolean data type in MySQL TRUE equates to 1, and FALSE equates to 0.

You can actually see these values by executing a condition as a query, as follows:

mysql> SELECT code, price, price > 10.00
-> FROM products;
+——+——-+—————+
| code | price | price > 10.00 |
+——+——-+—————+
| MINI | 5.99 | 0 |
| MIDI | 9.99 | 0 |
| MAXI | 15.99 | 1 |
+——+——-+—————+
3 rows in set (0.00 sec)

The output from this query shows each product and its price from the products table. The conditional column returns TRUE when the price is greater than 10.00.

Popularity: 8% [?]

Feb 19

Numeric Functions in MySQL

Database by Imam | No Comments »

A function is a MySQL command used in an SQL statement that takes one or more arguments and returns a value based on the values supplied. Just as with expressions, you can use a function anywhere a fixed value could otherwise be used, or to manipulate the value returned in a database column.

Case Sensitivity
Function names are not case sensitive in MySQL. For example, you can use ROUND(), Round(), or round()these all perform the same function call.

Arguments
To pass a function more than one argument, separate the values in parentheses using a comma. If a function does not require any arguments, the parentheses must still be givenfor instance, RAND().

Random Numbers
To generate a random number, use the RAND() function with no arguments. The result is a random decimal number between 0 and 1.

Popularity: 8% [?]

Feb 18

Nasab Rasullah saw yang mulia

Sisi Lain by Imam | No Comments »

Beliau adalah Muhammad bin Abdullah bin Abdul Mutthalib bin Hasyim bin Abdu Manaf bin Qushay bin Kilab bin Murrah bin Ka’ab bin Lu’ay bin Ghalib bin Fihr bin Malik bin Nadhr bin Kinanah bin Khuzaimah bin Mudrikah bin Ilyas bin Mudhar bin Nizar bin Ma’ad bin Adnan … Hingga Nabi Ibrahim alaihis salam.

Popularity: 5% [?]

Next Page »