Get Started: SQL Working With Dates

In This Article, You Will Know About SQL Working With Dates. Before moving ahead, let’s know a bit about the SQL CREATE INDEX Statement. Table of Contents Note: Your database date formate should be matched with the date formate you are inserting. SQL Date Data Types Here’s the following MySQL command for inserting a date or … Read more

Get Started: SQL AUTO INCREMENT Field

sql-auto-increment-field

In This Article, You Will Know About SQL AUTO INCREMENT. Before moving ahead, let’s know a bit about the SQL CREATE INDEX Statement. Table of Contents SQL AUTO INCREMENT The SQL AUTO INCREMENT Field is defined as adding up a new number as new data is inserted into the table. Although this work is likely to … Read more

Get Started: SQL CREATE INDEX Statement

In This Article, You Will Know About SQL CREATE INDEX. Before moving ahead, let’s know a bit about the SQL DEFAULT Constraint. Table of Contents CREATE INDEX  The CREATE INDEX statement is used to create indexes in tables. Indexes are just a way to speed up users’ search or queries in the whole database. SQL indexes … Read more

Get Started: SQL DEFAULT Constraint

sql-default-constraint

In This Article, You Will Know About SQL DEFAULT Constraint. Before moving ahead, let’s know a bit about the SQL CHECK Constraint. Table of Contents SQL DEFAULT Constraint The SQL DEFAULT Constraint is used to assign a default value to the column. If not any other value is specified, then the default value is applied to … Read more

Get Started: SQL CHECK Constraint

sql-check-constraint

In This Article, You Will Know About SQL CHECK Constraint. Before moving ahead, let’s know a bit about the SQL UNIQUE Constraint. Table of Contents SQL CHECK Constraint The SQL CHECK Constraint applies a rule or set of rules that check the values based on certain conditions. Table1: Student_Info Serial Number Name Class Roll_No Subject 1 … Read more

Get Started: SQL FOREIGN KEY Constraint

sql-foreign-key-constraint

In This Article, You Will Know About SQL FOREIGN KEY Constraint.  Before moving ahead, let’s know a bit about the SQL ALTER TABLE Statement. Table of Contents SQL FOREIGN KEY Constraint The FOREIGN KEY Constraint is a column or the set of columns that establishes a link between data of two tables. The FOREIGN KEY is … Read more

Get Started: SQL PRIMARY KEY Constraint

sql-primary-key-constraint

In This Article, You Will Know About SQL PRIMARY KEY Constraint.  Before moving ahead, let’s know a bit about the SQL ALTER TABLE Statement. Table of Contents The SQL PRIMARY KEY constraint identifies uniquely each row/record in the table. A table can have only one PRIMARY KEY but can have single or multiple columns in the … Read more

Get Started: SQL UNIQUE Constraint

sql-unique-constraint

In This Article, You Will Know About SQL UNIQUE Constraint. Before moving ahead, let’s know a bit about the SQL ALTER TABLE Statement. Table of Contents SQL UNIQUE Constraint The UNIQUE Constraint makes sure that all values present in the table should be different meaning that not a single value should be duplicated. The  UNIQUE and … Read more

Get Started: SQL NOT NULL Constraint

sql-not-null-constraint

In This Article, You Will Know About SQL NOT NULL Constraint.  Before moving ahead, let’s know a bit about the SQL ALTER TABLE Statement. Table of Contents SQL NOT NULL Constraint In SQL, a table can have a null value by default but NOT NULL Constraint stops taking any null value in the table. It always … Read more

Stay in the loop

codingstreets