Untitled

Microsoft Windows [Version 10.0.26100.7623]
(c) Microsoft Corporation. All rights reserved.

C:\Users\user>cd\

C:\>cd xampp

C:\xampp>cd mysql

C:\xampp\mysql>cd bin\

C:\xampp\mysql\bin>mysql -u root -p -h 127.0.0.1
Enter password:
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 2
Server version: 10.1.21-MariaDB mariadb.org binary distribution

Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> create database eemc_db;
ERROR 1007 (HY000): Can't create database 'eemc_db'; database exists
MariaDB [(none)]> create database dbms_db;
ERROR 1007 (HY000): Can't create database 'dbms_db'; database exists
MariaDB [(none)]> show databases;
+---------------------------+
| Database                  |
+---------------------------+
| a                         |
| aadb                      |
| aashish                   |
| aashlab                   |
| ashi                      |
| college_management_system |
| customer_dbv              |
| db_name                   |
| db_nirakar                |
| dbms_db                   |
| ddddd                     |
| doce                      |
| education                 |
| eemc                      |
| eemc_db                   |
| eemcdb                    |
| employ_e                  |
| employe                   |
| employee                  |
| employee_db               |
| employeee                 |
| fourthit                  |
| hospital                  |
| hospital1                 |
| hospital_info             |
| information_schema        |
| items                     |
| lokesh                    |
| md                        |
| mysql                     |
| netra                     |
| nirakar                   |
| nitesh                    |
| performance_schema        |
| phpmyadmin                |
| rodex                     |
| set_db                    |
| sushmita                  |
| test                      |
+---------------------------+
39 rows in set (0.06 sec)

MariaDB [(none)]> create database grg_db;
Query OK, 1 row affected (0.00 sec)

MariaDB [(none)]> use grg_db;
Database changed
MariaDB [grg_db]> create table items(itemid int primary key,itemname varchar(50),inventorylevel int,minimumlevel int);
Query OK, 0 rows affected (0.05 sec)

MariaDB [grg_db]> describe items;
+----------------+-------------+------+-----+---------+-------+
| Field          | Type        | Null | Key | Default | Extra |
+----------------+-------------+------+-----+---------+-------+
| itemid         | int(11)     | NO   | PRI | NULL    |       |
| itemname       | varchar(50) | YES  |     | NULL    |       |
| inventorylevel | int(11)     | YES  |     | NULL    |       |
| minimumlevel   | int(11)     | YES  |     | NULL    |       |
+----------------+-------------+------+-----+---------+-------+
4 rows in set (0.02 sec)

MariaDB [grg_db]> insert into items values(1,'item A',10,5),(2,'item B',8,6),(3,'item C',15,10);
Query OK, 3 rows affected (0.02 sec)
Records: 3  Duplicates: 0  Warnings: 0

MariaDB [grg_db]> select* from items;
+--------+----------+----------------+--------------+
| itemid | itemname | inventorylevel | minimumlevel |
+--------+----------+----------------+--------------+
|      1 | item A   |             10 |            5 |
|      2 | item B   |              8 |            6 |
|      3 | item C   |             15 |           10 |
+--------+----------+----------------+--------------+
3 rows in set (0.00 sec)

MariaDB [grg_db]> create table orders(orderid int auto_increment primary key,itemid int,quantity int,orderdate date);
Query OK, 0 rows affected (0.08 sec)

MariaDB [grg_db]> describe orders;
+-----------+---------+------+-----+---------+----------------+
| Field     | Type    | Null | Key | Default | Extra          |
+-----------+---------+------+-----+---------+----------------+
| orderid   | int(11) | NO   | PRI | NULL    | auto_increment |
| itemid    | int(11) | YES  |     | NULL    |                |
| quantity  | int(11) | YES  |     | NULL    |                |
| orderdate | date    | YES  |     | NULL    |                |
+-----------+---------+------+-----+---------+----------------+
4 rows in set (0.03 sec)

MariaDB [grg_db]> delimiter //
MariaDB [grg_db]> create trigger check_inventory_level
    -> after update on items
    -> for each row
    -> begin
    -> declare current_inventory int;
    -> declare minimum_level int;
    -> set current_inventory= new.inventorylevel;
    -> set minimum_level = new.minimumlevel;
    -> if current_inventory<minimum_level then
    -> insert into orders(itemid,quantity,orderdate)
    -> values(new.itemid,(minimum_level-current_inventory),curdate());
    -> end if;
    -> end //
Query OK, 0 rows affected (0.02 sec)

MariaDB [grg_db]> delimiter ;
MariaDB [grg_db]> update items set inventorylevel=3 where itemid=1;
Query OK, 1 row affected (0.02 sec)
Rows matched: 1  Changed: 1  Warnings: 0

MariaDB [grg_db]> update items set inventorylevel=4 where itemid=2;
Query OK, 1 row affected (0.02 sec)
Rows matched: 1  Changed: 1  Warnings: 0

MariaDB [grg_db]> select *from orders;
+---------+--------+----------+------------+
| orderid | itemid | quantity | orderdate  |
+---------+--------+----------+------------+
|       1 |      1 |        2 | 2026-01-25 |
|       2 |      2 |        2 | 2026-01-25 |
+---------+--------+----------+------------+
2 rows in set (0.00 sec)