Eli, you're killing it! By far the easiest to comprehend explanation and application of use for stored procedures that I've received. I appreciate the great instruction and video.
First of all... The way you explained is fantastic. It was easy to understand. Now I have a question. Suppose if I call a procedure in a production db, will it impact the production?
• You'd think MySQL would be smart enough to recognize you're in a create-procedure call and ignore semicolons; maybe have a separate delimiter for it and similar functions. The developers need to take a class on creating user-friendly programs. ¬_¬ • Stored procedures are useful when running in the CLI client, but is there a practical use for developers? It seems unnecessary when running SQL queries in a program since even the most convoluted query is trivial when it's run from code. 🤔
we set up a system where we were getting 1000 orders a day coming on through 3 different sites, means out code stack got enormous. Procedures saved us a lot of time to keep data integrity in tact. also i didnt have to repeat the logic in multiple clients.
Eli, you're killing it! By far the easiest to comprehend explanation and application of use for stored procedures that I've received. I appreciate the great instruction and video.
Quite impressive and comprehensive concept of stored procedures. awesome Eli..!
Can we pass parameters while calling Stored Procedures?
www.mysqltutorial.org/stored-procedures-parameters.aspx
@@elithecomputerguy Thanks!
Eli never fails
this dude is good at teaching
Interesting video, very simple to understand.
this is amazing ! thanks eli!
First of all... The way you explained is fantastic. It was easy to understand. Now I have a question. Suppose if I call a procedure in a production db, will it impact the production?
I was hoping you would get into passing parameters, but good video.
can you create a tutorial of creating a procedure to be used on datagridview in c# for real time editing directly from datagridview?
Why not creating View ? What’s the difference ?
What I learned the hard way, Is just don't type anything at all on a live database LOL... I backup before doing any manual functions
You can't die Eli!
• You'd think MySQL would be smart enough to recognize you're in a create-procedure call and ignore semicolons; maybe have a separate delimiter for it and similar functions. The developers need to take a class on creating user-friendly programs. ¬_¬
• Stored procedures are useful when running in the CLI client, but is there a practical use for developers? It seems unnecessary when running SQL queries in a program since even the most convoluted query is trivial when it's run from code. 🤔
we set up a system where we were getting 1000 orders a day coming on through 3 different sites, means out code stack got enormous. Procedures saved us a lot of time to keep data integrity in tact. also i didnt have to repeat the logic in multiple clients.
1m subscribers and 154 likes...Shame on you people.