Merge pull request Cheatsheet-lang#7 from CodeWithBishal/master

AnuragAnalog · web-flow · commit da1ce06c739e · 2021-10-03T15:01:58.000+05:30
added more snippets to the cheatsheet
diff --git a/README.md b/README.md
@@ -8,6 +8,92 @@ To run sql files
 source <filename>.sql;
 ```
 
+## Data Types
+
+#### Integers
+
+```sql
+INT
+```
+```sql
+TINYINT
+```
+```sql
+SMALLINT
+```
+```sql
+MEDIUMINT
+```
+```sql
+BIGINT
+```
+
+#### Float
+
+```sql
+FLOAT(M,D)
+```
+
+#### Double
+
+```sql
+DOUBLE(M,D)
+```
+
+#### Decimal
+
+```sql
+DECIMAL(M,D)
+```
+
+#### Date
+
+```sql
+DATE -- Format - (YYYY-MM-DD)
+```
+
+#### Date Time
+
+```sql
+DATETIME -- Format - (YYYY-MM-DD HH:MM:SS)
+```
+
+#### Time
+
+```sql
+TIME -- Format - (HH:MM:SS)
+```
+
+#### String
+
+```sql
+CHAR(M)
+```
+
+```sql
+VARCHAR(M)
+```
+
+```sql
+BLOB or TEXT
+```
+
+## Comments
+
+```sql
+/* Multi
+line
+comment */
+```
+
+```sql
+# Single Line Comment
+```
+
+```sql
+-- Single Line Comment
+```
+
 ## Data Definition Language (DDL)
 
 #### Create Database
