MySQL Subcategories |
Using MySQL Full-text Searching |
| MySQL | Views: 9 | |
| In this tutorial, you will learn: - How to modify your current database to accommodate Full-text searching - How to use a simple Full-text search to quickly gather relevant responses - How to execute a more complex Full-text search with Boolean capabilit.. |
Using Fulltext Indexes in MySQL - Part 2, Boolean searches |
| MySQL | Views: 1 | |
| Part 1 of this article looked at the fulltext index, and how to search on it using an ordinary MATCH() AGAINST(). Even more powerful, (although only available on the newer MySQL version 4), is the ability to do a boolean search. Part 2 of this article ex.. |
Using Fulltext Indexes in MySQL - Part 1 |
| MySQL | Views: 3 | |
| Ian Gilfillan delves into the benefits (and problems) of MySQL's FULLTEXT index |
Transferring Data to MySQL Using SQLyog |
| MySQL | Views: 3 | |
| Need any easy way to import data from your ODBC-compliant database into MySQL? Look no further than SQLyog's ODBC Import tool. Read all about it inside |
Transactions in MySQL |
| MySQL | Views: 6 | |
| Protect your data from crashes and the confusion of multiple user requests with a transaction-capable database |
Synchronizing Your MySQL Databases Using a Free MySQL Admin Tool - SQLyog |
| MySQL | Views: 0 | |
| Bring two remote MySQL databases in Sync quickly and easily. Insanely Great gives you a close-up look at SQLyog |
Simulating Transactions in MySQL |
| MySQL | Views: 2 | |
| MySQL is the most popular open source database on Earth. The current stable release, 3.22 does not support transactions, but with a little bit of intelligence and discipline, we can simulate transactions |
Optimizing MySQL, Hardware and the Mysqld Variable |
| MySQL | Views: 0 | |
| You've fine-tuned your indexes, and have optimized those queries to the bone. But still your MySQL database is crawling. It's time to look at tweaking the mysqld variables, what hardware improvements you can make, and how you can compile MySQL to run jus.. |
Optimizing MySQL Queries and Indexes |
| MySQL | Views: 5 | |
| Building a database-driven site is one thing. But all too often your masterpiece starts performing like a donkey when it becomes popular. Learn how to optimize your queries and indexes in MySQL, and potentially speed up your application many times over |
Oh, my--MySQL! |
| MySQL | Views: 2 | |
| If you are running a host Web site, the chances are good you have MySQL access. Discover when, where, and why you should use MySQL |
MySQL's Over-looked and Under-worked Slow Query Log |
| MySQL | Views: 0 | |
| You say you've never heard of the Slow Query Log? That may be because it's de-activated by default. Following along with Ian Gilfillan, as he explores one of MySQL's less-used logs |
MySQL wizardry |
| MySQL | Views: 0 | |
| Cross tabulations are statistical reports where you de-normalize your data and show results grouped by one field, having one column for each distinct value of a second field |
MySQL FULLTEXT Searching |
| MySQL | Views: 2 | |
| Storing text in your database is handy, but searching can be a pain. MySQL's FULLTEXT search can save your sanity. Joe Stump demonstrates how it works and gives several ideas on how to use it in your own applications. |
MySQL File Overwrite Vulnerability |
| MySQL | Views: 0 | |
| Noel Davis shows us a buffer overflow in ASPSeek; a denial of service attack against timed; a new version of OpenSSH with many improvements; an attack against the private keys used by GnuPG; a race condition in the UFS and EXT2FS file systems; and proble.. |
Many Web developers prefer MySQL |
| MySQL | Views: 1 | |
| As database technology evolves, a growing number of developers are choosing MySQL as the most stable and efficient application for server programming |
Introducing SQLyog, a MySQL Front End |
| MySQL | Views: 1 | |
| With the combination of PHP and MySQL becoming one of the defacto standards for Web development, the need for a good front end for MySQL is increasing. This article takes a look at the basics of connecting to and using one of the most popular MySQL graph.. |
Incrementing/De-Incrementing columns |
| MySQL | Views: 2 | |
| Here is a MySQL columns drill for you to follow |
Importing Data into MySQL with Navicat |
| MySQL | Views: 3 | |
| In today's article Michael takes a look at using Navicat (a MySQL management tool) to quickly and easily import/export data to and from MySQL |
Give me back my MySQL Command Line! |
| MySQL | Views: 0 | |
| Does every Web host you try stick you with a Web-based control panel, when you really want a down-and-dirty MySQL command line interface? The solution? Kev's spiffy PHP script |
Diary of A Webmaster Part 4 - Backing Up With MySQLDump |
| MySQL | Views: 0 | |
| MySQLDump backups needn't be a chore. Mitchell explains why, covering 5 backup methods -- and easy backup restoration -- in detail |
|
