Unlimited knowledge
How to create database user account in cPanel ? To create a database user account in cPanel. Follow the below steps : Step 1: Log in to your cPanel account. Step 2: In Database menu, click the ‘MYSQL database wizard’. Step 3: Next to New Database, enter the name for your database and click ‘Next Step’. … Read more
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 more
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 more
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 database and select the table, in which you would like to upload a file Step 4: After completing the above step, … Read more
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 more
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 or modify the content of your database, while other may want to get the sensible data like passwords. For example, if … Read more