Select Record MySQL / General Guides
This tutorial will show you how to get records in your table in database to show on your PHP files. This SQL statement has many options.
Beginners Guide to MySQL MySQL / General Guides
MySQL can be quite confusing when you first start learning it, but the truth is, once you get the basics down, it can be quite easy.
Using MySQL to analyze web usage from Windows ISA logs MySQL / General Guides
This tutorial will teach you how to import a tab delimited file in to a MySQL database. We built a program to do this for Windows ISA Server logs which contained over 500,000 lines which was way too many for Microsoft Excel to handle and too much for notepad to handle properly.
What is MySQL? MySQL / General Guides
MySQL is a freely available open source Relational Database Management System [RDBMS], a database engine of sorts that uses Structured Query Language (SQL). SQL is the most popular language for adding, accessing, and processing data in a database, and is most noted for its rapid processing, proven reliability, and ease and flexibility of use.
Backup and Restore MySQL Databases MySQL / Replication and Backup
It is a good idea to backup your MySQL data occasionally as a precautionary measure. It is also a good idea to create a backup before making any major changes, incase something goes wrong and you need to revert to the unmodified version. Database backups can also be used to transfer your database from one server to another if you change web hosts.
Creating Users and Setting Permissions in MySQL MySQL / General Guides
MySQL is an extremely powerful database, but in order to properly maximize its potential you may need to learn how to set up users and their respective permissions. In this article take a look at using the MySQL console application to create users and grant permissions to them. We also shows us how to grant permissions from remote hosts, how to reduce user privledges and more. MySQL is an extremely powerful database, but in order to properly maximize its potential, you may need to learn how to set up users and their respective permissions.
MySQL System Architecture MySQL / General Guides
We are going to take a look at MySQL internals. It will be a fun, informative examination of how all the different pieces and parts of the MySQL server operate together. MySQL's implementation is a fascinating mix of technology that is truly a remarkable achievement - an achievement born from the sweat and inspiration of numerous developers overmany years.