Developing and programming with databases is a major step towards a
large information base. It was quite a difficult process some time ago
but now it has become easy with the help of resources on the web.
As referenced on designm.ag, the 15 best MySQL tutorials along with their description and links.
1. Pagination SQL Server vs MySQL – This can be done in a different manner in SQL Server and MySQL. Pagination is a way of showing results in small set of batches in case the results return a large amount of data. For further information you can go to -
http://www.sqlservercurry.com/2012/09/pagination-sql-server-vs-mysql.html
2. Creating Simple MySQL Tables – This is to help beginners at MySql who do not have prior experience in it. For further information you can go to - http://www.dreamincode.net/forums/topic/42301-beginners-guide-to-creating-simple-mysql-tables/
3. Beginner’s Guide MySQL installation – This tutorial is helpful in understanding what MySQL means and after going through it one can install MySQL, and connect to it via PHP. For further information you can go to –
http://www.thehelper.net/threads/beginners-guide-to-mysql-use-and-installation.45908/
4. Insert/Update with One MySQL Statement - This tutorial is good for saving time and effort in constructing separate code and separate logic to deal with inserts vs updates. For further information you can go to –
http://www.endyourif.com/mysql-insert-or-update-in-one-sql-statement/
5. Run MySQL Server on your PC – It can be quite tricky to set up databases like MySQL. You can learn more about it by going to -
http://www.wikihow.com/Install-the-MySQL-Database-Server-on-Your-Windows-PC
6. Setup PHP & MySQL on OSX 10.8 – You can refer to this tutorial for setting up from a clean install of 10.8. You can learn more by going to -
http://php.dzone.com/articles/setting-php-and-mysql-os-x-108
7. How to Automatically Backup MySQL – This is among the most popular open source database management system for the development of interactive Websites. In case your site stores its sensitive data in a MySQL database, you will need a backup of that information for it to be restored in the event of a disaster. For further information you can go to -
http://www.noupe.com/how-tos/10-ways-to-automatically-manually-backup-mysql- database.html
8. Ajax Dropdown with PHP/MySQL – This tutorial shows you how a basic dropdown list works with Ajax. It is aimed for beginners to show the basics of how it works. For further information you can go to -
http://www.jeremymorgan.com/tutorials/php-tutorials/how-to-create-an-ajax-drop-down-menu-with-php-and-mysql/
9. Create New Users and Grant Permissions -.MySQL has a range of options for granting specific users nuanced permissions within tables and databases—this tutorial provides a short overview of few of the several options. For further information you can go to - https://www.digitalocean.com/community/articles/how-to-create-a-new-user-and-grant-permissions-in-mysql
10. Setup A New MySQL User Account – This tutorial shows you how you can gain access to MySQL database server from client such as mysql or even programming language such as php or perl. For further information you can go to- http://www.cyberciti.biz/faq/mysql-user-creation/
11. Find and Replace Text SQL – This has a handy and simple string function REPLACE () allowing table data with the matching string (from_string) to be changed by new string (to_string). For more information you can go to -http://www.mydigitallife.info/how-to-find-and-replace-text-in-mysql-database-using-sql/
12. Eight WordPress SQL Hacks – In this tutorial you can look at 8 useful SQL hacks for WordPress. Each section presents a problem, suggests a solution and gives an explanation to assist you in comprehending the solution. For further information you can go to -http://wp.smashingmagazine.com/2008/12/18/8-useful-wordpress-sql-hacks/
13. Generate MySQL Database Size in MB- This tutorial demonstrates how you can find database size in MySQL if you don’t have a command prompt. For further information you can go to -https://www.suse.com/communities/conversations/check-mysql-database-size-using-sql-query/
14. Backup and Restore MySQL Databases - phpMyAdmin can be used to export or backup MySQL databases easily. But if the database size is huge it will not be a good idea. For further information you can go to -http://www.mydigitallife.info/how-to-backup-and-restore-export-and-import-mysql-databases-tutorial/
15. How to Import and Export in MySQL –This tutorial shows you how to update hardware or replace obsolete hardware on MySQL server. For further information you can go to - http://www.ghacks.net/2009/12/29/how-to-import-and-export-a-database-in-mysql/
1. Pagination SQL Server vs MySQL – This can be done in a different manner in SQL Server and MySQL. Pagination is a way of showing results in small set of batches in case the results return a large amount of data. For further information you can go to -
http://www.sqlservercurry.com/2012/09/pagination-sql-server-vs-mysql.html
2. Creating Simple MySQL Tables – This is to help beginners at MySql who do not have prior experience in it. For further information you can go to - http://www.dreamincode.net/forums/topic/42301-beginners-guide-to-creating-simple-mysql-tables/
3. Beginner’s Guide MySQL installation – This tutorial is helpful in understanding what MySQL means and after going through it one can install MySQL, and connect to it via PHP. For further information you can go to –
http://www.thehelper.net/threads/beginners-guide-to-mysql-use-and-installation.45908/
4. Insert/Update with One MySQL Statement - This tutorial is good for saving time and effort in constructing separate code and separate logic to deal with inserts vs updates. For further information you can go to –
http://www.endyourif.com/mysql-insert-or-update-in-one-sql-statement/
5. Run MySQL Server on your PC – It can be quite tricky to set up databases like MySQL. You can learn more about it by going to -
http://www.wikihow.com/Install-the-MySQL-Database-Server-on-Your-Windows-PC
6. Setup PHP & MySQL on OSX 10.8 – You can refer to this tutorial for setting up from a clean install of 10.8. You can learn more by going to -
http://php.dzone.com/articles/setting-php-and-mysql-os-x-108
7. How to Automatically Backup MySQL – This is among the most popular open source database management system for the development of interactive Websites. In case your site stores its sensitive data in a MySQL database, you will need a backup of that information for it to be restored in the event of a disaster. For further information you can go to -
http://www.noupe.com/how-tos/10-ways-to-automatically-manually-backup-mysql- database.html
8. Ajax Dropdown with PHP/MySQL – This tutorial shows you how a basic dropdown list works with Ajax. It is aimed for beginners to show the basics of how it works. For further information you can go to -
http://www.jeremymorgan.com/tutorials/php-tutorials/how-to-create-an-ajax-drop-down-menu-with-php-and-mysql/
9. Create New Users and Grant Permissions -.MySQL has a range of options for granting specific users nuanced permissions within tables and databases—this tutorial provides a short overview of few of the several options. For further information you can go to - https://www.digitalocean.com/community/articles/how-to-create-a-new-user-and-grant-permissions-in-mysql
10. Setup A New MySQL User Account – This tutorial shows you how you can gain access to MySQL database server from client such as mysql or even programming language such as php or perl. For further information you can go to- http://www.cyberciti.biz/faq/mysql-user-creation/
11. Find and Replace Text SQL – This has a handy and simple string function REPLACE () allowing table data with the matching string (from_string) to be changed by new string (to_string). For more information you can go to -http://www.mydigitallife.info/how-to-find-and-replace-text-in-mysql-database-using-sql/
12. Eight WordPress SQL Hacks – In this tutorial you can look at 8 useful SQL hacks for WordPress. Each section presents a problem, suggests a solution and gives an explanation to assist you in comprehending the solution. For further information you can go to -http://wp.smashingmagazine.com/2008/12/18/8-useful-wordpress-sql-hacks/
13. Generate MySQL Database Size in MB- This tutorial demonstrates how you can find database size in MySQL if you don’t have a command prompt. For further information you can go to -https://www.suse.com/communities/conversations/check-mysql-database-size-using-sql-query/
14. Backup and Restore MySQL Databases - phpMyAdmin can be used to export or backup MySQL databases easily. But if the database size is huge it will not be a good idea. For further information you can go to -http://www.mydigitallife.info/how-to-backup-and-restore-export-and-import-mysql-databases-tutorial/
15. How to Import and Export in MySQL –This tutorial shows you how to update hardware or replace obsolete hardware on MySQL server. For further information you can go to - http://www.ghacks.net/2009/12/29/how-to-import-and-export-a-database-in-mysql/
Comments
Post a Comment