What Are You Doing Right Now? (391 Viewers)

[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

 

Buy on AliExpress.com

[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.

 

[.zero]

It is now time