What Are You Doing Right Now? (477 Viewers)

[.zero]

nothing better than a good burger

Damn straight

http://ia.media-imdb.com/images/M/M...anBnXkFtZTcwMzY5NzAyMQ@@._V1_SX640_SY720_.jpg

No idea. Best to avoid suitcases around 11th & Mission.

More of what I experienced last night were all the helicopters overhead for the 4-alarm fire at 22nd & Mission that you could hear from my house all night. Saw the overhead news footage and thought, "Fire across the Sketchers again? Looks like the Giants won the World Series."

It was mine. Moving in slowly but surely

 

Buy on AliExpress.com

[IncuboRossonero]

What am I doing right now?

I set a record of not having a bowel movement in 10 days...that coupled with the permanent diarrhea I decided to sit on the bowl and throw a Juventus flag in the bowl along with an over rated Del Piero poster and took what is the most massive dump in the history of dumps...


Burp

 

[Dostoevsky]

Wow, blast from the past.

 

[.zero]

What am I doing right now?

I set a record of not having a bowel movement in 10 days...that coupled with the permanent diarrhea I decided to sit on the bowl and throw a Juventus flag in the bowl along with an over rated Del Piero poster and took what is the most massive dump in the history of dumps...


Burp

Wonderful drop-in cameo

 

[Dostoevsky]

@Martin

SELECT CustomerName, Address+', '+City+', '+PostalCode+', '+Country AS Address
FROM Customers;

I understand what this does. What I don't understand is why the bold parts. I mean, why that order (starting +' and ending '+)? I don't think I've seen the explanation for it before.

 

[.zero]

@Dule90

http://www.w3schools.com/sql/

 

[Dostoevsky]

I'm there and it's where I found that part actually. I'm just trying to make the sense out of it.

 

[Martin]

@Martin

SELECT CustomerName, Address+', '+City+', '+PostalCode+', '+Country AS Address
FROM Customers;

I understand what this does. What I don't understand is why the bold parts. I mean, why that order (starting +' and ending '+)? I don't think I've seen the explanation for it before.

So this would be on a table that looks like this:

--------------------------------------------------------
| CustomerName | Address | City | PostalCode | Country |
--------------------------------------------------------
| Bob          | at home | Roma | 234234     | Italy   |
| Frank        | at work | Roma | 45644      | France  |
--------------------------------------------------------

The result of that select would be:

--------------------------------------------------------
| CustomerName | Address                               |
--------------------------------------------------------
| Bob          | at home, Roma, 234234, Italy          |
| Frank        | at work, Roma, 45644, France          |
--------------------------------------------------------

So from a table with 5 columns you're returning two columns of values, the first being CustomerName just as its stored, the second being a combination of the other 4.

Is that clear?

 

[.zero]

Let me see

 

[Nzoric]

3rd day straight drunk. I've made nothing but smart decisions the past few days.

 

[swag]

What am I doing right now?

I set a record of not having a bowel movement in 10 days...that coupled with the permanent diarrhea I decided to sit on the bowl and throw a Juventus flag in the bowl along with an over rated Del Piero poster and took what is the most massive dump in the history of dumps...


Burp

Nick! You poor-man's Christian-Vieri-looking anal hairball! How you been?

@Martin

SELECT CustomerName, Address+', '+City+', '+PostalCode+', '+Country AS Address
FROM Customers;

I understand what this does. What I don't understand is why the bold parts. I mean, why that order (starting +' and ending '+)? I don't think I've seen the explanation for it before.

Bobby Tables

 

[Martin]

3rd day straight drunk. I've made nothing but smart decisions the past few days.

i had champagne today. at work.

 

[Dostoevsky]

So this would be on a table that looks like this:

--------------------------------------------------------
| CustomerName | Address | City | PostalCode | Country |
--------------------------------------------------------
| Bob          | at home | Roma | 234234     | Italy   |
| Frank        | at work | Roma | 45644      | France  |
--------------------------------------------------------

The result of that select would be:

--------------------------------------------------------
| CustomerName | Address                               |
--------------------------------------------------------
| Bob          | at home, Roma, 234234, Italy          |
| Frank        | at work, Roma, 45644, France          |
--------------------------------------------------------

So from a table with 5 columns you're returning two columns of values, the first being CustomerName just as its stored, the second being a combination of the other 4.

Is that clear?

It is clear. That does make sense.

I just don't know why is is written like this +'. This

 

[Firestarter]

3rd day straight drunk. I've made nothing but smart decisions the past few days.

Yay

i had champagne today. at work.

How come?

 

[Martin]

It is clear. That does make sense.

I just don't know why is is written like this +'. This

I don't know how many concepts you've learned already.

In programming there is a basic concept called a string. It means a sequence of characters.

"a" is a character
"abc" is a string (more than one character)

In the SELECT you showed there are several strings being concatenated (ie. glued together) using the + sign (which means "joing two strings into one string").

So:

"a" + "b" => "ab"

- - - Updated - - -

How come?

I'll tell you later

 

[Dostoevsky]

I don't know how many concepts you've learned already.

In programming there is a basic concept called a string. It means a sequence of characters.

"a" is a character
"abc" is a string (more than one character)

In the SELECT you showed there are several strings being concatenated (ie. glued together) using the + sign (which means "joing two strings into one string").

So:

"a" + "b" => "ab"

This post made me feel like a retard.

Thanks.

Nick! You poor-man's Christian-Vieri-looking anal hairball! How you been?


Bobby Tables

Hey, I'm just trying to expand the universe of not-knowing.

 

[.zero]

3rd day straight drunk. I've made nothing but smart decisions the past few days.

Applauded

3rd day straight drunk. I've made nothing but smart decisions the past few days.

Seems like we have a scandal in our midst

 

[swag]

Hey, I'm just trying to expand the universe of not-knowing.

I dunno if you get my Bobby Tables reference. I am not one for geek jokes at all, but this one from xkcd is legendary and inspired an entire web site:

http://bobby-tables.com/

 

[.zero]

I dunno if you get my Bobby Tables reference. I am not one for geek jokes at all, but this one from xkcd is legendary and inspired an entire web site:

http://bobby-tables.com/

That made my day

 

[Dostoevsky]

I dunno if you get my Bobby Tables reference. I am not one for geek jokes at all, but this one from xkcd is legendary and inspired an entire web site:

http://bobby-tables.com/

I had to google it before and I've seen it everywhere, but I didn't see that that's epic.