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. Essential SQL queries 1. To create a database in mysql  Create database is used to create the database. Syntax CREATE DATABASE database_name; … Read moreimportant MYSQL syntaxes or query in php program

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, no matter how large the table is. SELECT * FROM table_name WHERE 0; If you execute the query, MYSQL looks at … Read moreHow to Optimise mysql queries, importance of closing db connections

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 indexing as been done. For example, indexing in database is also similar to what we seen in books. Indexing can be … Read moreWhat is indexing in database , how to optimize the mysql database table