List/Grid MYSQL Subscribe RSS feed of category MYSQL

important MYSQL syntaxes or query in php program

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… Read more »

How to Optimise mysql queries, importance of closing db connections

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… Read more »

How to upload bulk files in mysql

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… Read more »

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

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… Read more »

How to protect your site from SQL injection

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,… Read more »

© 2017 Expert Shout. All rights reserved. XHTML / CSS Valid.