MySQL Stored Procedure 9 - Database API (Application Programming Interface)

~~~~~~~~~~~~~~~ CONNECT ~~~~~~~~~~~~~~~

~~~~~~~~~~~~~~ SUPPORT ME ~~~~~~~~~~~~~~

🅑 Bitcoin - 3HnF1SWTzo1dCU7RwFLhgk7SYiVfV37Pbq
🅔 Eth - 0x350139af84b60d075a3a0379716040b63f6D3853

[marrallisa]

I just discovered your existence 4 hours before my exam. If i pass it, its bc of you dude!

[aristotledoria]

you are one of those youtuber's that does not need any precious materials for comedy. just a blackboard and a chalk..

[lucianacostilla]

ive never enjoyed sql lessons as much as i'm doing with this guy rn hahaha he was so cute

[adezcom]

not awful. really helpful thanks. I like the way you came up with a better example on the fly (city first then car). keep up the great work

[kparoboabala]

Amazing content, silly with the analogy, but gave me great insight into those stuff. Thanks

[sarmadchandio]

Awesome really enjoying your lectures...

[elisavianna]

Estou aprendendo muito com você. Obrigada!

[hosampb]

Is this where Trump got his campaign ideas from ?
Look guys we're gonna build a beautiful wall and call it API and make mexico pay for it.

[scottwisniewski]

Hey just a question. I am in the middle of watching your SQL and RDBMS videos and I have to say that I love them. Will I be able to learn how to actually create a database from scratch and then build on it?

[farzadsole]

You're awesome dude :)
Thanks for the video, by the way I really like the API examples, LOL
Peace

[ayoobalshahri]

if I have API but no wall and database what can I do, please help.

[hosampb]

o my god, i'm sitting in the library laughing my ass off. Lol drop database XD XD
dude you've just made my day
I've learned something new and got a good laugh

[ojasaf]

we have a car, you have a super car!!!!

[stephenstrang]

Instead of a city make it an amusement park. Like Disney world.

[athanaaa]

what is the difference between

select first_name, last_name, salary, hire_date from employees where employee_id=100;

vs

create or replace procedure sp_pd
as
v_fname varchar2(50);
v_lname varchar2(50);
v_salary number;
v_hdate date;
begin
select first_name, last_name, salary, hire_date into v_fname, v_lname, v_salary, v_hdate from employees where employee_id=100;
end;