My SQL - Complete Notes

Table of Content

  1. My SQL Summarized
  2. Constraints in MySQL

Comments

Post a Comment

Popular posts from this blog

Java Script - Table of Content

 Table of Content 1. Introduction to JavaScript What is JavaScript? Evolution of JavaScript How JavaScript Works in Browsers Setting Up the Environment: Choosing a Code Editor (VS Code, Sublime, etc.) Running JavaScript in the Browser Console Setting Up Live Servers 2. JavaScript Fundamentals 2.1 Variables and Data Types Declaring Variables (var, let, const) Primitive Data Types (String, Number, Boolean, Null, Undefined, Symbol, BigInt) Type Conversion and Coercion 2.2 Operators Arithmetic Operators Logical and Comparison Operators Assignment Operators Conditional (Ternary) Operator 2.3 Control Flow Conditional Statements (if, else if, else, switch) Loops (for, while, do-while) Break and Continue 2.4 Functions Function Declaration and Invocation Parameters and Arguments Function Expressions and Arrow Functions Default Parameters 3. Working with the DOM 3.1 DOM Basics What is the DOM? Selecting Elements ( getElementById , querySelector , etc.) Modifyin...
Read more

Constraints in MySQL

Constraints in MySQL are rules enforced on data in a database to ensure its accuracy, integrity, and consistency. They are applied at the table column or table level to restrict the type of data that can be stored. Constraints help prevent invalid data entry and maintain relational database integrity. Types of Constraints in MySQL 1. NOT NULL Constraint Ensures that a column cannot have a NULL value. Used to ensure that important fields always contain data. Syntax: CREATE TABLE students ( id INT NOT NULL, name VARCHAR(50) NOT NULL ); Example: If you try to insert a record with a NULL value in the name column, it will result in an error: INSERT INTO students (id, name) VALUES (1, NULL); -- This will throw an error 2. UNIQUE Constraint Ensures that all the values in a column are distinct (no duplicates allowed). Multiple UNIQUE constraints can be applied to a table. Syntax: CREATE TABLE employees ( emp_id INT UNIQUE, email VARCHAR(100) UNIQUE ); E...
Read more