Author: admin

INSERT statement MySQL INSERT statement is used to insert record(s) or row(s) into a table. The insertion of records or rows in the table can be done in two ways, insert a single row at a time, and insert multiple rows at a time. Version: MySQL 5.6 Syntax:INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE] [INTO] tbl_name…

What is Partitioning? Partitioning (a database design technique) improves performance, manageability, simplifies maintenance and reduce the cost of storing large amounts of data. Partitioning can be achieved without splitting tables by physically putting tables on individual disk drives. Partitioning allows tables, indexes, and index-organized tables to be subdivided into smaller pieces, therefore queries that access…

INSERT statement MySQL INSERT statement is used to insert record(s) or row(s) into a table. The insertion of records or rows in the table can be done in two ways, insert a single row at a time, and insert multiple rows at a time. Version: MySQL 5.6 Syntax:INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE] [INTO] tbl_name…

What is Partitioning? Partitioning (a database design technique) improves performance, manageability, simplifies maintenance and reduce the cost of storing large amounts of data. Partitioning can be achieved without splitting tables by physically putting tables on individual disk drives. Partitioning allows tables, indexes, and index-organized tables to be subdivided into smaller pieces, therefore queries that access…

ALTER TABLE The ALTER TABLE command is used  to change the structure of an existing table. It helps to add or delete columns, create or destroy indexes, change the type of existing columns, rename columns or the table itself. It  can also be used to change the comment for the table and type of the…

CREATE INDEX In MySQL, an index can be created on a table when the table is created with CREATE TABLE command. Otherwise, CREATE INDEX enables to add indexes to existing tables. A multiple-column index can be created using multiple columns. The indexes are formed by concatenating the values of the given columns. CREATE INDEX cannot…

CONSTRAINT MySQL CONSTRAINT is used to define rules to allow or restrict what values can be stored in columns. The purpose of inducing constraints is to enforce the integrity of a database. MySQL CONSTRAINTS are used to limit the type of data that can be inserted into a table. MySQL CONSTRAINTS can be classified into…

What is a database? When an amount of data is stored in an organized way, that is called a database.In computers, a database is managed by a software called Database Management System. What is a table? A table is a set of data values. These values are organized using vertical columns and horizontal rows. Columns…

Connecting to MySQL Before you perform any operations, you need to connect to MySQL server and select a MySQL database. Connecting to MySQL server from command line Command:MySQL -h HostName -u UserName -p Parameters: Name Description -h Keyword, followed by HOSTNAME. HostName MySQL server name -u Keyword, followed by USERNAME. UserName MySQL user name -p…

What is a database? When an amount of data is stored in an organized way, that is called a database.In computers, a database is managed by a software called Database Management System. What is a table? A table is a set of data values. These values are organized using vertical columns and horizontal rows. Columns…