MySQL Tutorials |
MySQL One LinersCollection of one-line commands for MySQL. MySQL FULLTEXT Searching TutorialA tutorial that shows how to perform Fulltext searching in MySQL MySQL has had FULLTEXT searching in one form or another. FULLTEXT indices in MySQL allow database administrators and programmers to designate any character-based field (CHAR, VARCHAR, or TEXT) as a FULLTEXT index, which allows for complex text searching against data stored in those fields. ... MySQL Sub Queries TutorialA tutorial that shows how to write subqueries/sub selects Subqueries can make it possible to do more advanced queries againts the database than usual. This way you don't have to do that much logic in your programming language (PHP etc).... Backup MySQL with Cron Jobs TutorialA tutorial that shows how to make and use a Cron Tab from within Cron Jobs installed on Cpanel The first step in to log into your websites Cpanel and click your Cron Jobs Icon. When the next page loads you should have somthing like this (scaled down)... MySQL Tables Optimization TutorialA tutorial that shows how to set up an automatic optimization for your db Speed in MySQL is all about how fast the database can find the information you request. To help MySQL clean up and get all the best possibilities to gather your information, you can perform the command "Optimize" on your tables... MySQL DB Backup/Restore TutorialA tutorial that shows how to backup and restore data in your MySQL database The quickest and easiest way to backup and restore your database would be to use MySQLDump. If you've got shell or telnet access to your server, you can backup MySQL data by issuing the mysqldump command... Using a MySQL database with PHP TutorialA tutorial that shows how to add some dynamic content to your website using combination of PHP and MySQL Assume that there is a database and table already running on MySQL, which we'll use with the PHP scripts. The database is called first_test, and has a table called people with some data in it.... Optimizing MySQL Queries and Indexes TutorialA tutorial that shows how to optimize MySQL queries and Indexes When there is a situation like the database is just too slow. Queries are queuing up, backlogs growing, users being refused connection..... Database Replication In MySQL TutorialA tutorial that shows how to set up Database Replication in MySQL MySQL replication allows you to have an exact copy of a database from a master server on another server (slave), and all updates to the database on the master server are immediately replicated to the database on the slave server so that both databases are in sync.... Working with Stored Procedure TutorialA tutorial that shows how to create & call stored prcedures MySQL refers to stored procedure execution as calling, and so the MySQL statement to execute a stored procedure is simply CALL. CALL takes the name of the stored procedure and any parameters that need to be passed to it... Triggers TutorialA tutorial that shows how to create triggers in MySQL
When creating a trigger you need to specify four pieces of information: The unique trigger name,
Create Your First MySQL DatabaseTutorial to creating your very first MySQL database via cPanel. blog comments powered by Disqus |
Discuss MySQL Tutorials in the forums.
