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.
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.
Introduction to MySQL MySQL / General Guides
MySQL is the most popular open source SQL database management system, is developed, distributed, and supported by MySQL AB. MySQL AB is a commercial company, founded by the MySQL developers.
MySQL DELAY_KEY_WRITE Option MySQL / General Guides
Another performance option in MySQL is the DELAY_KEY_WRITE option. According to the MySQL documentation the option makes index updates faster because they are not flushed to disk until the table is closed.
MySQL Command Line Help MySQL / General Guides
We tend to use MySQL from the interactive command line shell quite a bit (SSH to your db server and type the command mysql to start). We noticed today that there is a pretty extensive built in help system in this command.
Improve The Performance Of Your MySQL Server MySQL / General Guides
MySQL is a rock solid, lighting fast database server which has been designed for two factors speed and performance. It is the Ferrari of databases: Light weight, fast and Built for the high speed tracks! Learn how to get the best performance from you MySQL database server.
Building a High-Availability MySQL Cluster MySQL / General Guides
Serious business services really can't go down, whether due to hardware or software failures. If your necessary services rely on MySQL, clustering and high availability can prevent failures. How MySQL Cluster and Heartbeat to provide redundant, failure-proof replication and availability of their data.
What is MySQL MySQL / General Guides
MySQL is a open source Relational Database Management System. MySQL is very fast reliable and flexible Database Management System. It provides a very high performance and it is multi threaded and multi user Relational Database management system.
Working with SQL Server MySQL / General Guides
In this lesson, you'll learn how to connect and log into SQL Server, how to issue SQL Server statements, and how to obtain information about databases and tables.
Modifying your MySQL databases to be UTF-8 compliant MySQL / General Guides
Most of us have had problems with UTF-8 problems in PHP and MySQL. Here is how to modify your database and table to be UTF-8 compliant. Most of the time we do set the character set to utf8 but forget to set the collation set to utf8.
Using Triggers MySQL / General Guides
MySQL statements are executed when needed, as are stored procedures. But what if you wanted a statement (or statements) to be executed automatically when events occur? For example: Every time a customer is added to a database table, check that the phone number is formatted correctly and that the state abbreviation is in uppercase, Every time a product is ordered, subtract the ordered quantity from the number in stock, Whenever a row is deleted, save a copy in an archive table.
Fixing column encoding mess in MySQL MySQL / General Guides
Just had an interesting issue with an encoding mess on a column containing non-ASCII text. The solution was not immediately obvious so I decided it's worth sharing.