SQL

What is KEY in SQL? A key in SQL is an attribute or a set of attribute which helps you

Creating Database: CREATE DATABASE Database_name; Selecting Database: USE Databasname; Creating Table: CREATE TABLE Table_NAME (field1 datatype, field2 datatype,…); Inserting values

SQL Key A key is SQL is an attribute or a set of attribute which helps you uniquely identify a

Exact Numeric Bit                       decimal Tiny int      

MYSQL DATA TYPES MYSQL DATA TYPES MySQL there are three main types text, number, and Date/ Time types. MYSQL DATA

SQL DATA TYPES SQL DATA TYPES Data types and ranges for Microsoft Access, MySQL and SQL Server. SQL DATA TYPES

SQL CASE STATEMENT SQL CASE STATEMENT SQL CASE statement is used to provide Conditional (if-then-else) type of logic in  SQL.

SQL BETWEEN OPERATOR SQL BETWEEN OPERATOR The BETWEEN Operator The Between Operator selects a range of data between two values.

SQL ALTER TABLE STATEMENT SQL ALTER TABLE STATEMENT The ALTER TABLE statement is used to add, delete, or modify columns