You are the best!!! For some reason, when I watch your videos...I can remember everything. When I watch someone's else tutorial...I fall asleep with the headache. :)))
My colleague shared this link with me. I listened to 1-16 so far. I have to admit this is the best tutorial I've ever known. Thank you for sharing your knowledge. Love it! Looking forward to more videos:)
Used diaper from my sister :D Rofl Bucky!! you're the man !! Its been years since your tutorials are out but still there is no quality alternative to them!
for all the sqlplus users that are following along but using the correct syntax for sqlplus.. this is the correct syntax for CONCAT the city and state with the comma SQL> select city || ',' || state from customers order by state;
Hi, FIrst of all thank you very much for your informative tutorials i am following your tutorials. I have a question. how can i concat 2 columns from 2 different tables without any relation between them??? Thanks in Advance.
I love your tutorial and excellent, I may say... I will be better for to learn more from you. if you can provide the database sample that we can type the script at the same time with you. Don't you think it's much better?
You are the best!!! For some reason, when I watch your videos...I can remember everything. When I watch someone's else tutorial...I fall asleep with the headache. :)))
My colleague shared this link with me. I listened to 1-16 so far. I have to admit this is the best tutorial I've ever known. Thank you for sharing your knowledge. Love it! Looking forward to more videos:)
Lucky for you...you are watching my tutorials....love this statement..
Bucky... listening to you is a totally different pleasure.
Used diaper from my sister :D Rofl
Bucky!! you're the man !!
Its been years since your tutorials are out but still there is no quality alternative to them!
important note for everyone: You can do this too!:
SELECT name, cost, (cost/2)*1.2 AS sale_price FROM items
+Nethertar Thanks. That was useful buddy.
Kou np man.
Nethertar That was very quick.
Kou Thats what my ex said :
Nethertar Hahaha!!
You are my teacher BUCKY.... you make shorter videos and in interesting way ....that's the beauty of you !!
Anybody watching this in 2018? Well I do XD
2020 :P
2021 bro
you are the best, love the way you talk!!!
exactly
Thanks Bucky, your videos are awesome. Greetings from Catalonia!
Thanks for the awesome tutorials!
For multiples columns..
SELECT name, cost AS current_price,cost-1 AS sale_price FROM ITEMS
AS can also go on the end, eg: SELECT something FROM table AS whatever
for all the sqlplus users that are following along but using the correct syntax for sqlplus.. this is the correct syntax for CONCAT the city and state with the comma
SQL> select city || ',' || state from customers order by state;
great videos bucky however anyone else hear a high pitched monotone in the background of the vid ?
THANK YOU ARE A LIFESAVER !
Excellent.
you the man
thnx a lot man i've learnd a lot
Anyone in 2019
YOU CAN RENAME WITHOUT USING AS IN 2017 VERSION:
SELECT CONCAT(city, ', ', state ) new_address FROM customers
Hi, FIrst of all thank you very much for your informative tutorials i am following your tutorials.
I have a question. how can i concat 2 columns from 2 different tables without any relation between them???
Thanks in Advance.
Thanks for helping us
))) stidy )))
Dude, you're a tongue breaker )))
The "AS" is optional, FYI.
Thanks Bucky You're the sheezy
Bucky, as of 21st March, 16 it doesn't really give weird calculations results.
I feel a lil bad ruining the '123' likes, but this video is just that good
Did he just said asstitties?! - Great Concatenation example! -Anybody wants to add something to that? "SELECT SELECT" LOL
Thanks Bucky
Thanks bucky!!
Some people use their smartphones to watch youtube videos. The youtube client for smartphones (at least for android) does not support replying ...
Error said:
#1054 - Unknown column 'description' in 'field list'
Why ? :(
Why dont you make some C# tutorials? i think you can make the best tutorials than we have on you tube.
No dislikes? Awesome. ^^
I love your tutorial and excellent, I may say... I will be better for to learn more from you. if you can provide the database sample that we can type the script at the same time with you. Don't you think it's much better?
+Johnny Phan its already there on his forum. he talked about it in his initial tutorials. check the 2nd or 3rd video in this playlist.
STITY ADAM!!!
Question! Can I just echo that result?
Oh, I'm sorry, sir. I'm anaspeptic, phrasmotic, even compunctious to have
caused you such pericombobulation.
anyone can help sale_price and new_adress didn't saved on table ?
thank u
Concatenate, not an easy word to remember :-)
I am not able run this command CONCAT in w3 schools
love the boss scenario...i find it hard to follow tutorials with no real world explanation of why the heck u need to know it.
Yep, it was freaking annoying, but the vid was still great :D
2:16 rod text?
Raw* Text
It means he want to include something that isn't part of orignal data
4:25 "That...ASS!"
I get your drift. Maybe not that hard after all :-)
It's prolly his PS on the computer
cant run the CONCAT command, help needed please @thenewboston
Same here!
If you're using Oracle like I'am, Try this:
SELECT CONCAT(CONCAT(city,', '),state) AS Moram FROM customers;
Worked with me..
SELECT CONCAT(address, '
', city, ', ', state, ' ', zip) from customers ORDER BY state
Gives the full address. :)
You found the reply button!
thanks #bucky :*
Man, you are the shit.
You are shit
Get a reply button. O_o
Roman Rozhok Computers cant do anything.. if u dont tell/learn them to xD
What is your Facebook name??
4:25
you said ASS xd
lol ok
@MrBlack04004
go watch some TV XD no tnx
This is easy compared to C++ or others :P And I was thinking it was gonna be a pain in the ass
You seriously replying to a 7 months old comment? I don't even remember why I made that comment ...
thanks bucky