| Chapter 10 - Computer Science |
image |
/default_org/ncert_images/class-xii/c... |
15 |
|
Delete Content |
| Chapter 9 - Computer Science |
text |
Let us insert some records in the StudentAttendance datab... |
24 |
|
Delete Content |
| Chapter 9 - Computer Science |
image |
/default_org/ncert_images/class-xii/c... |
25 |
|
Delete Content |
| Chapter 9 - Computer Science |
text |
mysql> INSERT INTO GUARDIAN(GUID, GName, GAddress) -> VAL... |
26 |
|
Delete Content |
| Chapter 9 - Computer Science |
image |
/default_org/ncert_images/class-xii/c... |
27 |
|
Delete Content |
| Chapter 9 - Computer Science |
text |
mysql> INSERT INTO STUDENT -> VALUES(3, 'Taleem Shah','20... |
28 |
|
Delete Content |
| Chapter 9 - Computer Science |
image |
/default_org/ncert_images/class-xii/c... |
29 |
|
Delete Content |
| Chapter 9 - Computer Science |
text |
To select all the data available in a table, we use the f... |
30 |
|
Delete Content |
| Chapter 9 - Computer Science |
image |
/default_org/ncert_images/class-xii/c... |
31 |
|
Delete Content |
| Chapter 9 - Computer Science |
text |
N otes | 103 | | 104 | | 105 | | 106 | | 107 | | 108 | | ... |
32 |
|
Delete Content |
| Chapter 9 - Computer Science |
image |
/default_org/ncert_images/class-xii/c... |
33 |
|
Delete Content |
| Chapter 9 - Computer Science |
text |
+----------+-----------+ N otes | Name | Salary*12 | +---... |
34 |
|
Delete Content |
| Chapter 9 - Computer Science |
image |
/default_org/ncert_images/class-xii/c... |
35 |
|
Delete Content |
| Chapter 9 - Computer Science |
text |
N otes +--------+ | DeptId | +--------+ | D02 | | D01 | |... |
36 |
|
Delete Content |
| Chapter 9 - Computer Science |
image |
/default_org/ncert_images/class-xii/c... |
37 |
|
Delete Content |
| Chapter 9 - Computer Science |
text |
| EmpNo | Ename | Salary | Bonus | DeptId | +-------+----... |
38 |
|
Delete Content |
| Chapter 9 - Computer Science |
image |
/default_org/ncert_images/class-xii/c... |
39 |
|
Delete Content |
| Chapter 9 - Computer Science |
text |
N otes mysql> SELECT * -> FROM EMPLOYEE -> WHERE DeptId =... |
40 |
|
Delete Content |
| Chapter 9 - Computer Science |
image |
/default_org/ncert_images/class-xii/c... |
41 |
|
Delete Content |
| Chapter 9 - Computer Science |
text |
(F) ORDER BY Clause ORDER BY clause is used to display da... |
42 |
|
Delete Content |
| Chapter 9 - Computer Science |
image |
/default_org/ncert_images/class-xii/c... |
43 |
|
Delete Content |
| Chapter 9 - Computer Science |
text |
N otes is different from 0 (zero). Also, any arithmetic o... |
44 |
|
Delete Content |
| Chapter 9 - Computer Science |
image |
/default_org/ncert_images/class-xii/c... |
45 |
|
Delete Content |
| Chapter 9 - Computer Science |
text |
• _ (underscore)- used to represent exactly a single char... |
46 |
|
Delete Content |
| Chapter 9 - Computer Science |
image |
/default_org/ncert_images/class-xii/c... |
47 |
|
Delete Content |