Index is used to make data search faster in table. We use index to get the record quickly without searching each row in a database table whenever the table is accessed. We can create an index by using one or more columns of the table for accessing the records....
MySQL DROP Database query is used to delete database from mysql. It removes database with all the tables, indexes and constraints permanently....
The DROP TABLE Query is used to drop an existing table in a database. We cannot recover the lost data after droping table....
The ALTER TABLE query is used to add, delete, rename or modify any table field in an existing table. The ALTER TABLE query is also used to add and drop various constraints on an existing table....
The GROUP BY statement is often used with aggregate functions like COUNT, MAX, MIN, SUM, AVG to group the result-set by one or more columns. The MYSQL GROUP BY Clause is used to collect data from multiple records and group the result by one or more column. It is generally used in a SELECT statement....
MySQL CROSS JOIN is used to combine all possibilities of the two or more tables and returns the result that contains every row from all contributing tables. The CROSS JOIN clause returns the Cartesian product of rows from the joined tables. The CROSS JOIN is also known as CARTESIAN JOIN, which provides the Cartesian product of all associated tables. if each table has n and m rows respectively, the result set will have n x m rows....
RIGHT JOIN Query in mysql is used to join multiple tables which return all the records from the second (right side) table even no matching records found from the first (left-side) table. If it will not find any matches record from the left side first table, then returns null....
LEFT JOIN Query in mysql is used to join multiple tables which return all the records from the first (left-side) table even no matching records found from the second (right side) table. If it will not find any matches record from the right side table, then returns null....
INNER JOIN keyword is used to join two tables and selects records that have matching values in both tables....
MYSQL SELECT Query is used to fetch existing records from database....
MYSQL DELETE Query is used to delete existing records in a table....
MYSQL UPDATE Query is used to update existing records in a table....
MySQL - insert into statement is used to insert new records in a table. Insert query doesn't have WHERE clause....
The CREATE TABLE statement is used to create a new table in MYSQL database....
You have the root user access to create database in mysql. The CREATE DATABASE statement is used to create a new MYSQL database....
You can establish the MySQL database server connection using the mysql command at the command prompt or using php mysql function....
PHP - MySQLi Functions - MySQL can be used with PHP programming languages. PHP provides verious function to call mysql database query....
What is MYSQL Database? MySQL is a freely available open source Relational Database Management System (RDBMS) that uses Structured Query Language (SQL). Mysql database is used to store data....
Learn MYSQL Trigger. A MYSQL trigger is a stored program invoked automatically in response to an event such as insert, update, or delete that occurs in the associated table....