MySQL
Boost Website Speed with Query Caching
One of the best ways to speed up your web application is to enable query caching in your database, which caches commonly used SQL queries in memory for virtually instant access by the next page that makes the same request.
The reason this method is so powerful is that you don't have to make any changes to your web application, you just have to sacrifice a little bit of memory. This isn't going to fix all of your problems, but it definitely can't hurt.
Access to MySQL Data Transfer
Transferring database from one system to another is always a headache regardless of how big or small the migration scale is. Therefore, database managers, generally, look out for a simple tool which can perform export and import operations with all the variations involved. If you’re planning to migrate data from Access to MySql, you’d probably have a lot methods in mind to port databases. Before implementing any of them, try MS Access to MySQL. It is an ingeniously simple utility to quickly port Access database to user-defined MySql database. While it supports a wide range of database formats, including, MDB, MDE, ACCDB, and ACCDE, it shows MySql database hierarchy to choose the destination database path. Furthermore, password protected (encrypted) databases can also be exported on the fly without having to decrypt them.
Protecting your Websites Against SQL Injection
To show you how SQL Injection attacks works and how to protect your website against SQL injection , I've created one web application vulnerable and other that is invulnerable to SQL injection , so you’ll be able to try live example of sql injection and learn easily how to protect your web app/ sites .
SQL & PHP mass settings update, auto form generation
This time, I'll show you how you can easily generate a settings table with an update button. This only takes a few lines of code! I've used this in one of my own scripts, it's very easy once you've figured it out.
PHP and MySQL Communication Class
MySQL and PHP are a very common combination, especially with large scale websites, or websites with frequently updated content. So if you're going to creating a website, its best that you manage your PHP and MySQL relationship well. In this tutorial we will look at making a class that we can use to manage all of our connections and queries to our MySQL Database.
Auto Increment in mysql
Consider a row where in we need to auto increment it. So, instead of using any of the algorithms to increase the row count we can use AUTO_INCREMENT. But make sure that the field which you are using for auto increment has to be the PRIMARY KEY.
Ordering and displaying your news articles
I thought I should start making a habit of posting tutorials on the site. The web is full of great websites where people have taken the time to teach others what they have learnt and I feel it''s always good to 'pay it forward'.
What is database transaction management with Example
In this database transaction tutorial we will learn what is transaction in database, why do you need transaction in database, ACID properties of database transaction and an example of database transaction along with commit and rollback. Almost all vendors like Oracle, MySQL, SQL Server or Sybase provide transaction facility though MySQL only provide it for certain storage engine like InnoDB and BDB and not for MyISAM.
SQL Select Based on Text Inserted Into a Text Box
This tutorial will walk you through using PHP to select entries from a database based on the text that is entered into a textbox on the site. This guide will also walk you through making the insert script to insert the comments into the database as well as help you make the database.
How to retreive from mysql database
This tutorial will teach you how to create a getting data from database.
How to insert into mysql database
This tutorial will show you how to make a inserting data into database using php.
Start, Stop, Restart MySQL Server
To start, stop or restart MySQL server in Ubuntu, open the terminal and enter the following commands:
How to change mySQL root password
MySQL is first set up with root and no password. The best thing to do is change this, as soon as MySQL is installed.
Monitor MySQL queries with mtop
Today I found an application called mtop that monitors MySQL queries. It shows you which queries are taking the most amount of time to complete.
Import - Export MySQL Databases using the terminal
Learn how to Import - Export MySQL Databases using the terminal in Ubuntu Linux
Using the terminal
A basic SSH (pUTTY)tutorial, here is a list of commands that can be entered in the terminal to create, drop, show and use MySQL.
Create a new database, User and set permissions
Learn how to create a new database in MySQL, Create user & Set permission, Change user password.
Search and Replace Data
If you have imported your database, only to find that funny characters have appeared, you can issue the following mysql statement inside PHPMyAdmin to find and replace.
Encrypt a password using MySQL
This tutorial will show show how to create a MD5 encrypted password with mysql.
Structured Query Language (SQL)
Structured Query Language (SQL) is a computer language for creating database and manipulating data. SQL is an ANSI (American National Standard Institute) standard and is supported by almost all Relational Data Base Management Systems (RDBMS) like Oracle, MySQL, SQLServer, MS Access, PostGreSQL etc. SQL has two parts: