Category: MYSQL

important MYSQL syntaxes or query in php program 0

important MYSQL syntaxes or query in php program

SQL QUERY SQL stands  for Structured Query Language, it is used for accessing and manipulating  databases. Using SQL one can perform more actions in a database.Such as insert, update, select and delete a records from the database....

How to Optimise mysql queries, importance of closing db connections 0

How to Optimise mysql queries, importance of closing db connections

How to optimize MYSQL queries The MYSQL query optimization takes the advantages of indexes, but it is also uses other information.For example, if we use the following query, MYSQL will execute it very quickly,...

How to upload bulk files in mysql 0

How to upload bulk files in mysql

Steps to upload a bulk file in MYSQL Step 1: First have to start a server.It may be XAMPP/WAMP Step 2: Access the Phpmyadmin page.  Examle : localhost/phpmyadmin/ in your browser Step 3: Create a...

What is indexing in database , how to optimize the mysql database table 0

What is indexing in database , how to optimize the mysql database table

Indexing in database / how to optimize mysql table Indexing is a data structure technique, which is used to efficiently retrieve a records from the database files, based on some attributes on which the...

How to protect your site from SQL injection 0

How to protect your site from SQL injection

What is SQL injection? When someone is trying to run the unintended SQL query against your database is called SQL injection. There can be different intention to use SQL injection, some want to delete...