C Programming and MySQL Queries

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

Write a C program to extract the individual digits from a given string.

#include <stdio.h>
#include <string.h>

int main() {
    char str[100];
    int i, len;

    printf("Enter a string: ");
    gets(str);

    len = strlen(str);

    printf("The digits in the string are: ");
    for (i = 0; i < len; i++) {
        if (str[i] >= '0' && str[i] <= '9') {
            printf("%c ", str[i]);
        }
    }

    return 0;
}

Write a C program to dynamically allocate memory for an array to store 10 integers and display the first 5 out of them.

#include <stdio.h>
#include <stdlib.h>

int main() {
    int *ptr, i;

    // Dynamically allocate memory for an array of 10 integers
    ptr = (int *)malloc(10 * sizeof(int));

    if (ptr == NULL) {
        printf("Memory allocation failed!
");
        return 1;
    }

    // Assign values to the array
    printf("Enter 10 integers:\n");
    for (i = 0; i < 10; i++) {
        scanf("%d", &ptr[i]);
    }

    // Display the first 5 integers
    printf("The first 5 integers are:\n");
    for (i = 0; i < 5; i++) {
        printf("%d ", ptr[i]);
    }

    // Free the dynamically allocated memory
    free(ptr);

    return 0;
}

Insert data into the table as follows:

INSERT INTO Sales (SalesmanNo, SalesmanName, DateOfJoining, SalesZone, SalesAmount)
VALUES
('S001', 'Ratul Saha', '2015-07-06', 'SOUTH', 8000000),
('S002', 'Amir Hamza', '2017-08-09', 'EAST', 3400000),
('S003', 'Pankaj Pathak', '2018-03-09', 'WEST', 2400000),
('S004', 'Abdus Salam', '2019-08-05', 'NORTH', 5000000),
('S005', 'Amrit Paul', '2013-07-09', 'SOUTH', 4700000),
('S006', 'Ramesh Sharma', '2012-05-12', 'EAST', 7000000);

Display Salesman No and Salesman Name of each record.

<pre><code class="language-sql">SELECT SalesmanNo, SalesmanName FROM Sales; </code></pre> Signup and view all the answers

Display Salesman No and Salesman Name of East Zone.

<pre><code class="language-sql">SELECT SalesmanNo, SalesmanName FROM Sales WHERE SalesZone = 'EAST'; </code></pre> Signup and view all the answers

Display the records having Sales Amount in the range 2,00,000 to 3,50,000.

<pre><code class="language-sql">SELECT * FROM Sales WHERE SalesAmount BETWEEN 200000 AND 350000; </code></pre> Signup and view all the answers

Display the maximum and minimum Sales Amount.

<pre><code class="language-sql">SELECT MAX(SalesAmount), MIN(SalesAmount) FROM Sales; </code></pre> Signup and view all the answers

Flashcards

C Program

A set of instructions written in C language to perform specific tasks.

Dynamic Memory Allocation

Allocating memory at runtime using functions like malloc and free in C.