MySQL tutorial 3 - Selecting stuff

This tutorial will show you how to select data from a database.

Don't forget to tell them I sent you.

Download the database here:

Follow me on social media:

Become a Patron:

Subscribe to my Vlog channel:

Subscribe to this channel:

Please note:
I do not offer web development services, private tutoring, or "assistance" on school or university projects. I am not an online support service, and I'm not interested in setting up a "start up" business with viewers.

[kylehoffels]

I'm glad i found your page ! so great learning from a South African, kinda tired of the other guys, if you know you know ;)

[antoinesiz]

Awesome video, very clear and detailed. Just getting into MYSQL and your videos are really helpful!

[hejfarvel]

I love your videos! They have helped me so much. I finally understand what all of this is about and how it works! THANKS!

[sanjto]

When I am using mysql via the command line on linux, I do not need to use the back tick to pull info from a table. I have honestly not learned to do that from the codecademy courses I took before starting to watch this. Is it just good common practice to get into the habit of using the back tick? I did notice that I could not run any queries via phpmyadmin if I did not use the back tick so I will get into the habit of doing so from now on.

[finlx]

Think american keyboard might be different? I found the back tick next to the 1 key and I'm in the UK

[lsag]

if this is a MySQL tut, not phpmyadmin, then info about db and tables should be include:

-- names os databses
show DATABASES

-- see all tables
show TABLES;

-- info about a table
DESCRIBE users;

[mebanteikupar]

Hey Quentin, Can we also include WHERE clause with the SELECT command?

[DarkPaadin]

where is this back tick key?!! is it `? beside 1?

[nicklasbach]

I enjoy your videos a lot, but it does however annoys me, that you say your channel is advertising free, when it is not.
It is true, that you do NOT cooperate with youtube and get money from their ads. You do however send a shoutout to your "sponsors" in every video you upload and that is advertising, which is why your statement is false..

Keep up the good work tho, and consider not saying your channel is "100% advertising free". :)

[katherineli]

Why I use "SELECT username, password FROM users" still working?

[karthickrajalearn]

Sir Can I get Source Code for This Selecting Query in Mysql GUI

[andreslederer]

I code this in my SQL tab:

SELECT 'name' FROM `users`

And I DO get the field "name" but in every row it says "name"... sth isn't working

[luizmatthew]

zee? What abomination is that? It's called zed.

[alexmacca]

Anyone else spot the Fizz in the background ahah

[KettleCheese]

Part 3, 19 Minutes and 25 seconds wasted. the First mention of how to use MySQL.