SET C 1,2

    create database student;

use student;

create table students(
studentID int primary key,
studentName varchar (100),
age int,
class varchar (10),
marks float
);

insert into students values(1,"Alice Johnson",17,"12th",85);
insert into students values(2,"Bob smith",18,"12th",92);
insert into students values(3,"Charlie Brown",17,"11th",74);
insert into students values(4,"Diana Prince",18,"12th",88);
insert into students values(5,"Edward Wilson",17,"11th",64);
-----------------------------------------------------------------------------------------------

create database product;

use product;

create table customer
(
CustomerID int primary key,
CustomerName varchar(100),
City varchar(100),
Age varchar(100),
Phone int);

CREATE TABLE Orders(
OrderID int primary key,
Orderdate date,
CustomerID int,
amount float,
FOREIGN KEY (CustomerID) REFERENCES customer(CustomerID)
);

insert into customer values(1,”Alice Johnson”,”New York”,28,123456789);
insert into customer values(2,”Bob Smith”,”Los Angeles”,35,987654321);
insert into customer values(3,”Charlie Brown”,”Chicago”,30,456789123);
insert into customer values(4,”Diana Prince”,”Houston”,40,789012345);
insert into customer values(5,”Edward Wilson”,”Phoenix”,25,321654987);

insert into orders values(101,'2025-01-01',1,500);
insert into orders values(102,'2025-01-03',2,1000);
insert into orders values(103,'2025-01-05',3,700);
insert into orders values(104,'2025-01-10',4,1200);
insert into orders values(105,'2025-01-12',5,300);

SELECT * FROM Customer WHERE Age > 30;

UPDATE Customer SET Phone = '555666777' WHERE CustomerID = 2;

SELECT Orders.OrderID, Orders.OrderDate, Customer.CustomerName, Customer.Phone FROM Orders , Customer where Orders.CustomerID = Customer.CustomerID;

SELECT * FROM Orders WHERE OrderDate > '2025-01-05';


11:37 20-01-2025

    import mysql.connector

try:
    connection = mysql.connector.connect(
        host="localhost", 
        user="root",        
        password="root",  
        database="student",    
        auth_plugin = "mysql_native_password"
        )
    if connection.is_connected():
        print("Connected to the database successfully!")

    cursor = connection.cursor()

    two = "SELECT * FROM Students"
    cursor.execute(two)
    records = cursor.fetchall()
    print("\nAll Records:")
    for record in records:
        print(record)

    three = "INSERT INTO Students (studentID, studentName, age, class, marks) VALUES ('7', 'Fiona Adams', '16', '11th', '78')"
    cursor.execute(three)
    connection.commit()
    print("\nNew record inserted successfully.")

    three1 = "SELECT * FROM Students"
    cursor.execute(three1)
    records = cursor.fetchall()
    print("\nAll Records After Insertion:")
    for record in records:
        print(record)

    update_query = "UPDATE Students SET Marks = %s WHERE StudentID = %s"
    cursor.execute(update_query, (90, 5))
    connection.commit()
    print("\nMarks updated successfully for StudentID = 5.")


    fetch_query = "SELECT * FROM Students WHERE StudentID = %s"
    cursor.execute(fetch_query, (5,))
    updated_record = cursor.fetchone()
    print("\nUpdated Record:")
    print(updated_record)


finally:
    if connection.is_connected():
        cursor.close()
        connection.close()
        print("\nDatabase connection closed.")

SET C 1,2

SET C 1,2

Leave a Reply Cancel reply

sign up!