Category: MySQL Notes

MySQL-Constraints

CONSTRAINTS: A Constraint is a condition or checks applicable on a field or set of fields. Constraints are also known as integrity constraints because they applied to maintain data integrity. Two types of constraints: Column constraints: Apply only to individual columns. Table constraints: Apply to group of one or more columns. Syntax: CREATE TABLE…

MySQL Notes

Pallavi S No Comments

MySQL Notes MySQL Termionologies:- Data :- Raw facts and figures are called data.it can be in the form of name,phone,unique id ,address etc. We cannot take decisions on the basis of data. Information:- Well organised and processed data is called information. We can take decisions on the basis of information Field: Set of characters that…