January, 2022 - KSH TUTOR

MySQL UNIQUE Constraint

UNIQUE Constraint makes sure all values in a column are exclusive. PRIMARY KEY Constraint is also had the same property as UNIQUE Constraint. But there are some differences. In a table only one PRIMARY KEY

CHECK Constraint MySQL

January 25, 2022January 25, 2022 Education, Science And Technology CHECK, CHECK Constraint MySQL, Constraint MySQL, mysql

A CHECK constraint is used to control or limit the value of a particular column of the table. Every time CHECK constraint ensures to match a particular condition of inserted value. Before MySQL version 8..0.16,

MYSQL FOREIGN KEY CONSTRAINT

January 19, 2022January 19, 2022 Education, Science And Technology FOREIGN KEY, MYSQL FOREIGN KEY, MYSQL FOREIGN KEY CONSTRAINT

FOREIGN KEY is used to relate two or more tables together. Basically, it produces a parent-child relationship. The parent table consists of PRIMARY KEY. And another table that keeps the reference of parent table PRIMARY

MySQL PRIMARY KEY CONSTRAINT

January 18, 2022January 18, 2022 Education, Science And Technology CONSTRAINT, mysql, MySql Constraint, MySQL PRIMARY KEY CONSTRAINT, PRIMARY KEY, PRIMARY KEY CONSTRAINT

PRIMARY KEY:- A PRIMARY KEY constrains uniquely identify each row of the table. A PRIMARY KEY can not be a NULL value. Each table has only one PRIMARY KEY and each table column can have

MySQL Constraint

January 17, 2022January 17, 2022 Education, Science And Technology MySql Constraint

MySql Constraint Syntax:- Constraints have specified the rule of data that will store in a database table. That means, constraints will allow or restrict what value of data will store in the table. So, constraints

MySQL TIMESTAMPDIFF Function

January 16, 2022January 16, 2022 Education, Science And Technology MySQL TIMESTAMPDIFF

TIMESTAMPDIFF() function returns the difference or subtractions of a given two date-time. Syntax of TIMESTAMPDIFF(unit, timestamp_exp1, timestamp_exp2 ) Here unit may be FRAC_SECOND (microseconds), SECOND, MINUTE, HOUR, DAY, WEEK, MONTH, QUARTER, or YEAR. timestamp_exp1 will

Load Data Statement in MySQL

January 15, 2022January 15, 2022 Education, Science And Technology MySQL Load Data

LOAD DATA and INSERT statements in MySQL are used for populating records into MySQL tables. LOAD DATA populates record in bulk But INSERT statement populates record in a single row. mysql> LOAD DATA LOCAL INFILE

MYSQL JOINS

January 9, 2022January 10, 2022 Education, Science And Technology CROSS JOIN, INNER JOIN, LEFT JOIN, LEFT OUTER JOIN, MySql Joins, NATURAL JOIN, RIGHT JOIN, RIGHT OUTER JOIN, SELF JOIN

Joining is an important part of SQL queries. Since MySQL is an RDMS, So it also supports JOIN. Here I am putting some knowledge about MySql joining. It is based on my understanding. Hoping you