ROHIT's Smart Class Room

 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...

  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...

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...

  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.                                 ...

  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 : -     

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.

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.

  Selecting and opening the table: - To view the records from the table, we use “ SELECT ” statement. Import mysql.connector. Connect to MySQL database using connect( ) method. Create a cursor( ) object then pass SQL select query command as a string to the execute( ) method. Use fetchall( ) of cursor object to display all records in table. To display all records from table, we use for loop in python. The SQL command to select all the records from the table in database with python code is:                     Example : -                      output: - To display specific records from table, we use where clause. It filters the data as per the condition. We can fetch, delete or update a set of data in MySQL database. The SQL command to select specific records from the table in database with python code is:               ...

Inserting records into tables: - To insert the records into tables, we use the “ insert into ” query. Import mysql.connector. Connect to the MySQL database using connect( ) method. Create a cursor( ) object, then pass the SQL insert query command as a string to the execute( ) method.                Syntax: - To insert only single record into table, we use To insert multiple records into table, we use The SQL command to insert the records or data into table in database with python code is:                          output: - To view the records of table, we use  command.