Starting from MySQL 5, you get Stored Procedure in Mysql What is a stored procedure: A stored procedure is simply a procedure that is stored on the database server like MySQL. In programming languages, you write procedures to execute a function/logic. You can write similar procedure in SQL and store it in the database. From …
Category: FromSitesTree.com
Aug 12
MySQL Reference Manual #5
MySQL Reference Manual From: http://sitestree.com/?p=4903 Categories:5Tags: Post Data:2009-06-08 18:12:34 Shop Online: <a href=’https://www.ShopForSoul.com/’ target=’new’ rel=”noopener”>https://www.ShopForSoul.com/</a> (Big Data, Cloud, Security, Machine Learning): Courses: <a href=’http://Training.SitesTree.com’ target=’new’ rel=”noopener”> http://Training.SitesTree.com</a> In Bengali: <a href=’http://Bangla.SaLearningSchool.com’ target=’new’ rel=”noopener”>http://Bangla.SaLearningSchool.com</a> <a href=’http://SitesTree.com’ target=’new’ rel=”noopener”>http://SitesTree.com</a> 8112223 Canada Inc./JustEtc: <a href=’http://JustEtc.net’ target=’new’ rel=”noopener”>http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a> Shop Online: <a href=’https://www.ShopForSoul.com’> https://www.ShopForSoul.com/</a> Medium: <a href=’https://medium.com/@SayedAhmedCanada’ …
Aug 12
MySQL: Special Interests #5
Optimization MySQL Load Balancher MySQL Replication MySQL Cluster Stored Procedures and Functions MySQL High Availability and Scalability From: http://sitestree.com/?p=4904 Categories:5Tags: Post Data:2008-02-06 01:16:07 Shop Online: <a href=’https://www.ShopForSoul.com/’ target=’new’ rel=”noopener”>https://www.ShopForSoul.com/</a> (Big Data, Cloud, Security, Machine Learning): Courses: <a href=’http://Training.SitesTree.com’ target=’new’ rel=”noopener”> http://Training.SitesTree.com</a> In Bengali: <a href=’http://Bangla.SaLearningSchool.com’ target=’new’ rel=”noopener”>http://Bangla.SaLearningSchool.com</a> <a href=’http://SitesTree.com’ target=’new’ rel=”noopener”>http://SitesTree.com</a> 8112223 Canada Inc./JustEtc: <a …
Aug 12
Securing MySQL Database #5
After installing mysql, we will need to remove test database and associated users and their permissions. We will need to use mysql database to remove associated users and permission. –DROP DATABASE test; –SELECT db.Host, db.Db, db.User, db.Select_priv -> FROM db WHERE (db.DB = “vworksDB”); —SELECT db.User, db.Host, db.Db -> FROM db -> WHERE (db.Db LIKE …
Aug 12
Joins in MySQL #5
Cross-Join: All row by all row, ex: SELECT FROM , The Equi-Join or Inner Join:Syntax: SELECT FROM , WHERE (Table1.column = Table2.column) SELECT cds.artist, cds.title, genres.genre -> FROM cds, genres -> WHERE (cds.genreID = genres.genreID); The Left Join:Syntax: SELECT FROM LEFT JOIN ON Table1.column = Table2.column Without adding a WHERE clause the Left Join produces …
Aug 12
MySQL Resources: MySQL Start #5
Mysql Resources: First you need the latest/stable version of MySQL. Right now 6.0 is the latest version. Mysql has two different releases like:community server[free] enterprise server[commercial] Note: MAXDB is the current full package with many features that may not be fully tested. Download MySQL: You can download MySQL from http://dev.mysql.com/downloads/mysql/5.0.html Check the lower portion of …
Aug 12
MySql Administration SQL Commands #5
Using MySQL, AdministrationWorkshop RequirementsYou should have access to the MySQL command line client software.Various different PRIVILEGES on the MySQL ServerIntroductionIn the other MySQL Virtual Workshops we have used commands that are pretty much applicable to anyone. This part of the MySQL series is aimed at giving a rudimentary understanding of managing a MySQL database server. …
Aug 11
Positive Attitude: Develop a Positive Attitude for Stress Relief #51
Positive Attitude: Develop a Positive Attitude for Stress Relief From: http://sitestree.com/?p=4947 Categories:51Tags: Post Data:2011-07-04 00:14:23 Shop Online: <a href=’https://www.ShopForSoul.com/’ target=’new’ rel=”noopener”>https://www.ShopForSoul.com/</a> (Big Data, Cloud, Security, Machine Learning): Courses: <a href=’http://Training.SitesTree.com’ target=’new’ rel=”noopener”> http://Training.SitesTree.com</a> In Bengali: <a href=’http://Bangla.SaLearningSchool.com’ target=’new’ rel=”noopener”>http://Bangla.SaLearningSchool.com</a> <a href=’http://SitesTree.com’ target=’new’ rel=”noopener”>http://SitesTree.com</a> 8112223 Canada Inc./JustEtc: <a href=’http://JustEtc.net’ target=’new’ rel=”noopener”>http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a> Shop Online: …
Aug 11
Wanna be a good manager? #51
Read the book: Fifty StoriesThe Ugly Truth About Managing People: 50 Must-Get-Right Management Challenges…and How to Really Handle Them by Ruth King First lesson: Take the responsibility/blame for your team [deal with the trouble maker in private], acknowledge the strength of each of your team members, be willing to learn from your team members From: …
Aug 11
Some management quotes #51
“Do not give up when you meet the first obstacle. Many a time there will be heated discussions. As long as there is trust, even with differing opinions, you know that you can keep at it until you reach a solution.” “Make sure that you are not so tied to your ideas that you cannot …
