How to build website with foreign or regional languages using PHP and MySQL
In this tutorial we going to learn how to build regional or foreign language website using PHP and MySQL. Let see. Step 1: Create new table in the name of article. Character should be UTF-8 format. CREATE TABLE `articles` ( […]
How to use prepared statement in Mysql ?
In order to use MySQL prepared statement, you need to use other three MySQL statements as follows: PREPARE – Prepares statement for execution. EXECUTE – Executes a prepared statement preparing by a PREPARE statement. DEALLOCATE PREPARE – Releases a prepared […]
MySQL Storage Engines or Table Types
MySQL Storage Engines or Table Types is essential to understand the features of each table type in MySQL so that you can use them effectively to maximize the performance of your MySQL databases. MySQL provides various storage engines for its […]
Basic Mysql Database manage queries
Now you will learn how to manage databases in MySQL. You will learn 1) How to create a new databases, 2) Display all databases from database server 3) Use database 4) Remove databases from database server 1. Creating Database Before […]
Select Random Records in mysql Table
Objective: In this tutorial, discuss various techniques to select random records from a database table in MySQL. There is no automatic way to select random items from a mysql database table. In order to achieve this result, MySQL allows to do that via RAND function. To […]