Skip to content

Commit f5ec335

Browse files
authored
Update README.md
1 parent ac0d9b2 commit f5ec335

File tree

1 file changed

+4
-1
lines changed

1 file changed

+4
-1
lines changed

README.md

Lines changed: 4 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -176,8 +176,9 @@ alter table employee drop column salary;
176176
alter table employee modify column salary int;
177177
```
178178

179-
#### Truncate Table
179+
#### Truncate Table
180180
```sql
181+
-- deletes all the rows from table
181182
truncate employee;
182183
```
183184

@@ -279,7 +280,9 @@ select * from employee where salary > 3000 and salary < 4000;
279280

280281
#### BETWEEN and AND
281282
```sql
283+
282284
select * from employee where salary between 3000 and 4000;
285+
-- it also includes 3000 & 4000
283286
```
284287

285288
### OR

0 commit comments

Comments
 (0)