O czym chcesz poczytać na blogach?

Left join

Lazowski’s Weblog

11. Tworzymy widoki :
Widok może być bardzo prosty, np:

Jak i bardziej złożony :
AS SELECT O.Osoba, O.Nazwisko, O.Imie1, O.DataUrodzenia, AO.Miejscowosc, AO.KodPocztowy, AO.Ulica, AO.NumerDomu, AO.NumerLokalu FROM Osoby O
LEFT JOIN OsobyAdresy AO ON O.idOsoby=AO.idOsoby

Od tej pory możemy wykonywać polecenie SELECT na widoku jak na zwykłej tabeli, np:
WHERE OSOBA>='00020'

W bazie zapamiętane zostaną tylko definicje poszczególnych kolumn widoków, nie zaś wartości!

12. Łączenie zapytań poprzez UNION..

Fearless - Onet.pl Blog

You don't have to call anymore
I won't pick up the phone
This is the last straw
Don't wanna hurt anymore
And you can tell me that you're sorry
But I don't believe you baby
Like I did before
You're not sorry...no, no, no, no

You're looking so innocent
I might believe you if I didn't know
Could've loved you all my life
If you hadn't left me waiting in the cold
And you got your share of secrets
And I'm tired of being last to know
And now you're asking me to listen cause it's worked each time before

But you don't have to call anymore
I won't pick up the phone
This is the last straw
Don't wanna hurt anymore
And you can tell me that you're sorry
But I don't believe you.Kill or die for / Nic, za co możnabyłoby zabić ani umrzeć
And no religion too / Ani żadnej religii
Imagine all the people / Wyobraź sobie, że wszyscy ludzie
Living life in peace / Żyją w pokoju

You may say that I'm a dreamer / Możesz powiedzieć, że jestem marzycielem
But I'm not the only one / Ale nie jestem jedyny
I hope someday you'll join us / Mam nadzieję, że kiedyś do nas dołączysz
And the world will be as one / A świat będzie jak jedna całość

Imagine no possessions / Wyobraź sobie, że nie ma własności
I wonder if you can / Zastanawiam się, czy potrafisz
No need for greed or hunger / Żadnej chciwości ani głodu
A brotherhood of man / Braterstwo ludzi

Testmbu's Blog

Had 30m users pre android app. Mobile video market still to be claimed.kiwinlondon1 day ago

  • @KentBaddeley cheers Kent. Right back at yakiwinlondon1 day ago
  • Good post RT @bloggeratlarge: Here's a blog on a trip to Cuba with Peter Urlich u might like! http://t.co/oYXoCxsGkiwinlondon1 day ago
  • Be our 50th member. Join http://t.co/qriOtPy5 It's free and connects you with people quietly digitising the Bay. Ask a Q, free answers.kiwinlondon1 day ago
  • Sensible words RT @lancewiggs: Instagram, value and hard work http://t.co/VJ4DL8makiwinlondon1 day ago
  • @wljennings I would bet their strategy will be preserve and hold. Better for them than.
    When it come […]
  • CSS selector engine clarification? Kwiecień 11, 2012
    I've always believed (although I now doubt the validity of these beliefs) that: div.name Was faster than: .name However I've read recently that most CSS selector engines read from right to left, in which case wouldn't the first example actually be slower? As the selector engine would simply find every element with a class of name, and then hav […]
    Sean Dunwoody
  • ajax call to login.php , response failed Kwiecień 11, 2012
    iam doing login.php with the ajax call..Below.

  • Egzamin gimnazjalny - Daniel Szczypior

    Says he can’t come. The teacher wants us to learn some words for the next lesson.

    8. Wyrażenie przyczyny, skutku, warunku, celu; powiązanie informacji

    Np.: I don’t want to talk to you now because I have a headache. He was very busy, so he couldn’t see us. If we win the match, we will celebrate. I am going to join a computer course to learn new programmes. He is very good at maths, and he is going to study it at university. I like walking, but my friend prefers cycling.


    1. Wyrażenie własnej opinii, np. na temat osoby, przedmiotu, sytuacji

    Np.: I think he is very rude. In my.


    1. Identyfikacja i lokalizacja osoby lub przedmiotu

    Np.: This tall girl is my sister. Are you Miss Wilson? John is standing behind the teacher. Susan is in London now. My flat is on the ground floor. Your book is on the table. There is a kitchen on the right and a bathroom on the left.

    2. Pytanie i prośba o informację

    Np.: Who is that girl? What’s her name? How old is she? Where are you from? Where do you live? What does your father do? Which of these men is your teacher? What is there in this building? What are you doing tonight? Can you swim? Do you speak Japanese? What time does the match start?.

    Dominika In Afryka =)

    Dyrektora szkoły dostałam maila o tej treści:

    “The year begun with excitement when six girls scooped over 300 marks in the national grade eight exam giving them opportunity to join high school. The excitement shortly turned to gloom when the Landlord served us with notice to sell the very rooms that we have known as our classrooms.

    We are left to negotiate with the Landlord hoping that we are going to raise the Kshs. 300,000 required for the 12 rooms by 1st March 2011 to save the little children from being thrown out, noting the long rains that begin in March.

    We are going to send you monthly updates and post the names of those who donate and you will also be able to be updated with every development. Each room bought will be dedicated to you or any person of your choice. You also can join to support. “Cast your bread upon the waters, for you will find it after many days” (Ecc. 11:1)”.

    Czasu jest baaaardzo mało, ale wierzę, że uda się zgromadzić potrzebną kwotę i uratować szkołę przed zamknięciem.

    Żeby im pomóc zorganizowałam już event z pokazem slajdów, opowieściami, kursem bębniarskim, degustacją.

    . : m ó j ś w i a t : .

    Ten torsik.
    Dziś będę mieć piękne sny. Takie rozanielone.
    Podobno ludzie są do połowy aniołami.
    Mamy po jednym skrzydle.
    I dlatego mozemy latać wtedy
    i tylko wtedy
    gdy obejmujemy drugą osobę.
    Jednak ja wznoszę się ku niebu nie tylko wtedy gdy mnie obejmujesz.
    Choć rób to jak najczęściej.
    Dziś będę mieć piękne sny o Tobie.
    Miłość jest piękna.
    I poznaje się ją kochając.
    2006-02-25 22:47:10 skomentuj (6)

    Najpierw Kamienie...
    You better shape up, cause I need a man,
    and my heart is set on you
    You better shape up, you better understand,
    to my heart I must be true
    Nothing left, nothing left for me to do!
    You're one that I want...

    Chciałam napisać coś twórczego.
    Nie wyszło.
    Chciałam napisać coś mądrego.
    Nie wyszło.
    Chciałam napisać coś przejmującego, chwytającego za serce.
    Nie wyszło.
    Chciałam napisać coś wesołego.
    Nie wyszło.
    Chciałam napisać coś w ogóle sensownego...
    Nie wyszło. Brak pomysłów. Apogeum wkurzenia, po nim EUREKO! aż znalazłam odpowiednich kandydatów do ostatnich ról. Break The Wall jednak wyjdzie. I powiem Wam, że bardzo jestem zadowolona z tego:)
    A poza tym, dziś była msza za... Nie, dziś nie smucę. A chciałabym.
    Dodatkowo dodam, ze dziś już tu nic nie powsta.

    "Even with nougat, you can have a perfect moment"- "prawdziwa" twarz Draco Maleficium

    That is, of course, if it was shocking enough. The media are getting more and more picky nowadays… maybe because, with all the atrocities going on in the world, it is getting increasingly difficult to actually shock the public.
    That is not my intention.
    What is my intention, then? You will learn. Eventually, you will. And when the time comes, it will be left for you to decide whether to believe me or not, whether to ponder on it a little deeper or just return to your daily newspaper in search for more interesting – and gruesome – news from some distant land. I know how true my story is. Or, at least, I think I know, which is more or less the same thing. That is why I do not seek your acceptance or advice,.A candle here and there, stopping every now and then for a moment of silence by the graves of people I have never even heard of before. It felt… comforting, being among so many people who did not have to worry about anything anymore – not even the worms. Those solitary moments gave me peace, and I found in them a soothing certainty that, one day, I too will join this necropolis of decaying bodies. There was no fear in this knowledge, only calm realization and maybe a slight hint of curiosity. After all, lying around all day without doing anything could not be all that bad, could it? Coming to think of it, no-one has ever come back to raise a complaint…
    So I would walk leisurely, minding my own business and.