Category: SQL

SQL add column to table with query example. Learn queries to add new column as a first column or at the end or after a

SQL DEFAULT Constraint SQL DEFAUULT CONSTRAINT example – Learn how to store default value if no value inserted for columns in the table in MySQL

SQL PRIMARY KEY CONSTRAINT example – Learn how to accept unique values and deny null values for columns in MySQL database with example and important

SQL UNIQUE CONSTRAINT example – Learn how to accept of unique values for columns in MySQL database with example and important points. Unique constraint creates

SQL NOT NULL CONSTRAINT example – Learn how to deny accepting of NULL values for columns in MySQL database with example and important points. All

SQL Truncate a table example – Learn how to delete data from table  in MySQL database with example and important points. TRUNCAT TABLE statement is

SQL Rename a table example – Learn how to rename existing table name in MySQL database with example and important points. SQL RENAME TABLE is

SQL ALIASES example – Learn how to create temporary name / readable name for columns or tables in MySQL database with example using AS keyword

SQL Update table examples for single and multiple columns – Learn how to Update existing records in a table in MySQL database with example. SQL

SQL Delete table example – Learn how to Delete data from a table in MySQL database with example and important points. SQL delete statement used