MySQL Tutorial
Introduction Installation of MySQL Getting MySQL server information RDBMS Concepts Data Definition Language Data types Managing Databases Managing Tables Managing Views Inserting records in a table Updating records in a table Deleting records from a table Retrieving Records Data Control Language Variables in MySQL Procedures in MySQL Built-In functions in MySQL User Defined functions in MySQL Triggers in MySQL Cursors in MySQL Transaction control Event scheduler Tuning MySQL Server Performance Managing users Importing and Exporting data Database Testing Workbench PHPMyAdminTuning performance in MySQL
Indexing is used to speed up the performance of the database. We can create an index on a specific column in a table containing huge number of rows. To view what index is being used on the table, you can use below syntax.
SHOW INDEX FROM CUSTOMER
show index in customer;
You can create 3 types of index.- Unique Index
- Normal Index
- FullText Index
CREATE UNIQUE INDEX `idin` on `temptable` (`Id`);
CREATE INDEX `name` on `temptable` (`FirstName`);
ALTER TABLE `temptable` ADD INDEX `name` (`FirstName`);
ALTER TABLE `temptable` DROP INDEX `name`;
ALTER TABLE `temptable` Add FULLTEXT lname(`LastName`);
Preventing performance issues due to SQL attacks
To prevent SQL injection, you need to do below things. Escape special SQL characters from the input values used in the query. Use prepared statements.Web development and Automation testing
solutions delivered!!