Posts

2.3 control statements ( Jumping control structures (or) Jumps in Loops )

Image
 4)   Jumping control structures (or) Jumps in Loops: - Jumping control statements is also known as Unconditional control statements . Jumping control statements are the control statements that transfer the program control from one part to another part directly, without checking any condition. They unconditionally jump to a specified location in the program. There are 4 types of jumping statements.                         a)  goto statement                         b)  break statement                         c)  continue statement                         d)  return statement   a) goto statement: - The goto statement is a jumping control statement which is u...

2.2 Control statements ( Iterative or looping control statements)

Image
  3)   Iterative control structures: - Iterative control structure is also called as looping control statements. Looping control statements are used to execute a block of code repeatedly as long as a given condition is true. Instead of writing the same code multiple times, loops help avoid writing repetitive code. Loop declaration and execution can be done in the following ways: Check the condition to start a loop. Initialize the loop with declares a variable. Executing the statements inside a loop. There are three main types of loops in C:                    a)  for loop.                    b)  while loop.                    c)  do while loop.   a) For loop: - For loop a best looping control structure which is used to execute the statement repeatedly as long as a giv...

3.3 Windows operating system

Windows operating system: - Windows or win is an operating environment created by  Microsoft  that provides an interface known as a  GUI  (graphical user interface). Windows eliminates the need to memorise commands for the  command line  ( MS-DOS ) by using a  mouse  to navigate through menus, dialog boxes,  buttons ,  tabs , and  icons . Windows is a collection of programs known as an  operating system  (OS) that controls a PC (personal computer).  Windows is a series of  operating systems developed by Microsoft. Each version of Windows includes a  graphical user interface , with a  desktop  that allows users to view files and folders in  windows . It was first introduced with version 1.0 on April 10,  1985 . It is designed for both home computing and professional purposes. Past versions of Windows home editions include Windows 3.0 (1990), Windows 3.1 (1992), Windows...

3.2 Type of operating system

  Types of operating systems: - The various operating systems are developed depending on the requirements and the cost-bearing capacity of the users.                                    1.  Single-User Operating System.                                   2.  Multi-User Operating System.                                   3.  Single-Tasking Operating System.                                   4.  Multi-Tasking Operating System.                                 ...

3.9 Drop table from MYSQL database

Image
  Drop table from database: - The drop command affects the structure of the table, not the data. It is used to delete an existing table from the database. We use the “ DROP TABLE table_name ” command statement to delete a table. The SQL command to delete the table from the database with Python code is:                          Example: -                               output: -                                    final : -     

3.8 Deleting records from table in MYSQL

Image
Deleting records from table: - We can delete records from an existing table by using “ Delete from ” statement. The SQL command to delete the records from table with python code is:                Example: -                       output: - To view the updated records of table, we use command.

3.7 Updating Records in table MYSQL

Image
Updating records in table: - The update command is used to change the existing values in a database. By using update command, we can correct or update a specific value. It only affects the data but not the structure of the table.   The SQL command to update the records values in table with python code is: To view the updated records of the table, we use the command.