MySQL VIEWS are awesome

Рет қаралды 57,398

Күн бұрын

#MySQL #tutorial #course
MySQL tutorial for beginners
CREATE VIEW employee_attendance AS
SELECT first_name, last_name
FROM employees;
CREATE VIEW customer_emails AS
SELECT email
FROM customers;

Пікірлер: 31

@BroCodez Жыл бұрын

CREATE VIEW employee_attendance AS SELECT first_name, last_name FROM employees; CREATE VIEW customer_emails AS SELECT email FROM customers;

@shaikakhil681 3 ай бұрын

Create view employee_attendance AS Select* from employees Is it correct or not?

@nicholaspreston9586 Ай бұрын

where has this been all my life?

@krzysiekkrzysiek9059 Жыл бұрын

Briefly and concisely 👍

@romanmatton2636 Жыл бұрын

Thanks man, you're really the best

@kamranalizade98 Жыл бұрын

Bro İ really likes your videos,I am appreciate,but we need react lessons

@kamranalizade98 Жыл бұрын

@@BroCodez Ok bro thank you very much😎

@beepbeepgamer1305 Жыл бұрын

can you do python connectivity with mysql, i learned it in school but its hard for me to understand. Always checking my notification for the videos, Thanks!!

@adameelmadani 7 ай бұрын

learn mysqlAlchemy you can search for it in google or youtube

@vincdraws4742 Жыл бұрын

I'm still in the beginning Episodes and still far to get here at the latest but I just wanna say Thank you!

@xanhxanh5097 8 ай бұрын

after this video I just had to subcribe

@anushibisen8739 6 ай бұрын

Hey! great videos as always. I was hoping if you could make a video on creating views using multiple tables, it'll be really helpful. thanks a lot

@name1927 Жыл бұрын

Very good, simple example.

@chef_david1 10 ай бұрын

Well explained. Thanks

@theinvisiblegentleman1142 Жыл бұрын

So Mrs. Puff's first name is Poppy? I came looking for iron(information for my assignment) and struck gold.

@Starmanfansunofficial Ай бұрын

💙💙

@thenoob3198 Жыл бұрын

Is the playlist ended here? BTW,Want videos on Django.

@gitagliaudyte4741 10 ай бұрын

So if a view does not store the data, where it gets its data from? For example, where is the data of 'tables' from 'information_schema' stored? And how to access it? I'm just curious.

@OptimusVlad 6 ай бұрын

The view references the table(s) from where it was created. The view is not a "copy" of the table, it's a "reference" to it.