Tugas database Supplier

Membuat sebuah Database pada mysql

Membuat Database pada mysql

1. * Masuk dengan mengisi server, database, Usernama dan password.
*Kemudian ketik " CREATE DATABASE" utuk membuat database baru.
* Ketik CREATE TABLE Mahasiswa(NPM INTEGER NOT NULL, Nama Varchar(30),PRIMARY KEY(NPM));
Set NPM sebagai PRIMARY KEY karea akan dihubungkan denga NPM di tabel lain.













2. * Ketik \dt untuk melihat tabel * Ketik " insert into Mahasiswa(NPM, Nama) values (1093001,'Inke Gratia M Sinaga'); untuk mengisi table. Dan lajukan dengan mengisi sesuai yang Anda inginkan.













.3. * Buatlah sebuah tabel dengan nama Mata_kuliah seperti membuat tabel Mahasiswa di atas.
* Ketik insert into Mata_kuliah(IDM, Matkul) values ('A06', 'Agama'); dan selanjutnya seperti yang Anda inginkan. dan set IDM sebagai PRIMARY KEY karena akan dihubungkan / ada relationship dengan tabel berikutnya.












4. * Buatlah tabel baru dengan nama Nilai.
* Isi tabel ini dengan NPM_Mahasiswa (Karena akan dihubungkan dengan NPM pada tabel mahasiswa) , IDM_Mata_kuliah (Karena akan dihubungkan dengan tabel Mata_kuliah)dan nilai. Kemudian isi sesuai yang diinginkan dengan menggunakan insert into nilai(........).













5. *Ketik' select *from Nilai;' untuk menampilkan isi tabel.













6. * Untuk menampilkan nama dan NPM ketik, "select Mahasiswa.NPM,Mahasiswa.
Nama FROM Mahasiswa, Nilai Where Mahasiswa. NPM=Nilai.NPM_Mahasiswa; "






































7. Ketik " select NPM_Mahasiswa,Nilai From Where Nilai='A'; " Untuk menampilkan siapa saja yang mendapatkan nilai A.

















































8. Untuk menampilkan siapa saja yang mengambil mata kuliah "MATEMATIKA" KETIK ,"select NPM_Mahasiswa, IDM_Mata_kuliah From Nilai IDM_Mata_kuliah ='A04'; " karena kode matematika adalah ="A04"

mySQL

MySQL is the world's most popular open source database software, with over 100 million copies of its software downloaded or distributed throughout it's history. With its superior speed, reliability, and ease of use, MySQL has become the preferred choice for Web, Web 2.0, SaaS, ISV, Telecom companies and forward-thinking corporate IT Managers because it eliminates the major problems associated with downtime, maintenance and administration for modern, online applications.

Many of the world's largest and fastest-growing organizations use MySQL to save time and money powering their high-volume Web sites, critical business systems, and packaged software — including industry leaders such as Yahoo!, Alcatel-Lucent, Google, Nokia, YouTube, Wikipedia, and Booking.com.

The flagship MySQL offering is MySQL Enterprise, a comprehensive set of production-tested software, proactive monitoring tools, and premium support services available in an affordable annual subscription.

MySQL is a key part of LAMP (Linux, Apache, MySQL, PHP / Perl / Python), the fast-growing open source enterprise software stack. More and more companies are using LAMP as an alternative to expensive proprietary software stacks because of its lower cost and freedom from platform lock-in.

MySQL was originally founded and developed in Sweden by two Swedes and a Finn: David Axmark, Allan Larsson and Michael "Monty" Widenius, who had worked together since the 1980's.

Functions in MySQL

Many developers are completely unaware that MySQL actually has a huge number of functions built in, to do everything from regular expression-based string comparisons to complicated mathematical calculations. The outsides of the cheat sheet list MySQL functions (note: a few of the more unusual and least used functions have not been included due to constraints of space).

MySQL Data Types

MySQL allows for many data types for columns, and it is very easy to forget what constraints there are on these data types. This is especially important when it comes to validation - many developers do not check the length of data before inserting it into a table. This section lists the data types available and their constraints.

MySQL Functions in PHP

PHP has a MySQL module and this is used by most PHP developers to connect to, and query, a MySQL database. This section lists the functions available in PHP for connecting to and managing a MySQL database.

Sample Queries

Finally, the cheat sheet includes a short list of sample queries and a brief explanation of each.

TERSENYUMLAH INDONESIAKU!!!

Ditengah keterpurukan bangsa kita, setelah terjadinya ledakan Bom di hotel RitZ C dan J.W M. dan terorisme yang membabi buta. Kitra harus bisa tersenyum manis seperti seorang anak kecil yang manis.
Bukan hanya itu saja, di tahun ini kita kehilangan orang-orang yang berjasa dalam bidang-bidangnya yakni Michael Jackson seb. The King of Pop, W.S Rendra seb. seorang seniman yang sangat berjasa dalam dunia sastra puisi, juga Mbah Surip seb seorang musisi yang menggendong dunia musik dengan gebrakan dan cara-caranya bernyanyi dan tertawa. Mereka patut kita contoh dan kita teladani khususnya Mbah Surip, Ia selalu tertawa dan tersenyum pada semua orang walaupun sakit yang dideritanya sangat menghujam.

Marilah kita Bangsa Indonesia TERSENYUMLAH dan Mari Kita Bangkitkan dan Gendong Negeri Kita Tercinta INDONESIA RAYA!!!!

• LANJUTKAN PEMERINTAHAN BEBAS KORUPSI !!!
• STOP TERORISME !!!
• BANGKITKAN SEMANGAT KEMERDEKAAN !!!
• AND SAY, " HA.... HA... HA.... !!!!!"

Inspirated By :

" Penderita AIDS Indonesia Meningkat"

Di tengah-tengah gentarnya dunia oleh virus H1N1, ternyata Penyakit Krusial yang sudah menjadi polemik di seluruh penjuru dunia kembali mengguncang negara kita tercinta, Indonesia. Hal ini ditunjukkan oleh grafik yang dikeluarkan oleh Komisi Nasional AIDS yang menyatakan bahwa dalam kurun waktu Januari-Maret tahun 2009 ini, terdapat 23.632 penderita AIDS di Indonesia.

Hal ini diperkuat oleh ditemukannya seorang balita berusia 4 tahun penderita penyakit HIV/AIDS di Malang. Selain balita ini, dalam Liputan SERGAp (RCTI) dikatakan terdapat pula 25 orang anak lainnya yang menderita AIDS di Malang.

Oleh karena itu, marilah kita para generasi muda penerus bangsa menghindarkan diri dari segala sesatu yang dapat merangsang pertumbuhan maupun penyebaran penyakit HIV/AIDS. Dan Marilah kita ciptakan FREE AIDS NATION!!!!.

Let's do ," HEAL THE WORLD!!!!"

little girl talking

((i think about the gererations
and thay say thay want to make it
a better place for our children & our children's children
so that thay thay thay know it's a better world for them
and i think thay can make it a better place))


There's A Place In
Your Heart
And I Know That It Is Love
And This Place Could
Be Much
Brighter Than Tomorrow
And If You Really Try
You'll Find There's No Need
To Cry
In This Place You'll Feel
There's No Hurt Or Sorrow

There Are Ways
To Get There
If You Care Enough
For The Living
Make A Little Space
Make A Better Place...

Heal The World
Make It A Better Place
For You And For Me
And The Entire Human Race
There Are People Dying
If You Care Enough
For The Living
Make A Better Place
For You And For Me

If You Want To Know Why
There's A Love That
Cannot Lie
Love Is Strong
It Only Cares For
Joyful Giving
If We Try
We Shall See
In This Bliss
We Cannot Feel
Fear Or Dread
We Stop Existing And
Start Living

Then It Feels That Always
Love's Enough For
Us Growing
So Make A Better World
Make A Better World...

Heal The World
Make It A Better Place
For You And For Me
And The Entire Human Race
There Are People Dying
If You Care Enough
For The Living
Make A Better Place
For You And For Me

And The Dream We Were
Conceived In
Will Reveal A Joyful Face
And The World We
Once Believed In
Will Shine Again In Grace
Then Why Do We Keep
Strangling Life
Wound This Earth
Crucify Its Soul
Though It's Plain To See
This World Is Heavenly
Be God's Glow

We Could Fly So High
Let Our Spirits Never Die
In My Heart
I Feel You Are All
My Brothers
Create A World With
No Fear
Together We'll Cry
Happy Tears
See The Nations Turn
Their Swords
Into Plowshares

We Could Really Get There
If You Cared Enough
For The Living
Make A Little Space
To Make A Better Place...

Heal The World
Make It A Better Place
For You And For Me
And The Entire Human Race
There Are People Dying
If You Care Enough
For The Living
Make A Better Place
For You And For Me

Heal The World
Make It A Better Place
For You And For Me
And The Entire Human Race
There Are People Dying
If You Care Enough
For The Living
Make A Better Place
For You And For Me

Heal The World
Make It A Better Place
For You And For Me
And The Entire Human Race
There Are People Dying
If You Care Enough
For The Living
Make A Better Place
For You And For Me

There Are People Dying
If You Care Enough
For The Living
Make A Better Place
For You And For Me

There Are People Dying
If You Care Enough
For The Living
Make A Better Place
For You And For Me

You And For Me

You And For Me
Make A Better Place
You And For Me
Make A Better Place
You And For Me
Make A Better Place
You And For Me
heal the wordl we live in
You And For Me
save it for our children
You And For Me
heal the world we live in
You And For Me
save it for our children
You And For Me
heal the world we live in
You And For Me
save it for our children
You And For Me
heal the world we live in
You And For Me
save it for our children

You are NOt Alone, MIchael!!!!

Another day has gone
I'm still all alone
How could this be
You're not here with me
You never said goodbye
Someone tell me why
Did you have to go
And leave my world so cold

Everyday I sit and ask myself
How did love slip away
Something whispers in my ear and says
That you are not alone
For I am here with you
Though you're far away
I am here to stay

But you are not alone
For I am here with you
Though we're far apart
You're always in my heart
But you are not alone

'Lone, 'lone
Why, 'lone

Just the other night
I thought I heard you cry
Asking me to come
And hold you in my arms
I can hear your prayers
Your burdens I will bear
But first I need your hand
Then forever can begin

Everyday I sit and ask myself
How did love slip away
Something whispers in my ear and says
That you are not alone
For I am here with you
Though you're far away
I am here to stay

For you are not alone
For I am here with you
Though we're far apart
You're always in my heart
For you are not alone

Whisper three words and I'll come runnin'
And girl you know that I'll be there
I'll be there

You are not alone
For I am here with you
Though you're far away
I am here to stay
For you are not alone
For I am here with you
Though we're far apart
You're always in my heart

For you are not alone
For I am here with you
Though you're far away
I am here to stay

For you are not alone
For I am here with you
Though we're far apart
You're always in my heart

For you are not alone...