{"id":9540,"date":"2022-12-06T11:53:59","date_gmt":"2022-12-06T06:23:59","guid":{"rendered":"https:\/\/selfimagination.in\/tips\/?p=9540"},"modified":"2022-12-06T11:58:54","modified_gmt":"2022-12-06T06:28:54","slug":"mysql-library-management-system","status":"publish","type":"post","link":"https:\/\/selfimagination.in\/tips\/mysql-library-management-system\/","title":{"rendered":"MySQL Library Management System"},"content":{"rendered":"\n<p>MySQL ka upyog kar library Management software kaise banaye, Library ko aasani se kaise manage kare, trigger ke upyog se books stock kaise manage kare. <\/p>\n\n\n\n<p>\u0907\u0938 \u0906\u0930\u094d\u091f\u093f\u0915\u0932 \u092e\u0947 \u0939\u092e\u0928\u0947 \u090f\u0915 Library \u0915\u0940 \u0935\u0930\u094d\u0915\u093f\u0902\u0917 \u0915\u094b MySQL Database \u092e\u0947 design \u0915\u093f\u092f\u093e \u0939\u0948\u0902, \u092f\u0939 \u092c\u0939\u0941\u0924 \u0939\u0940 \u091b\u094b\u091f\u093e \u0938\u093e \u092a\u094d\u0930\u094b\u091c\u0947\u0915\u094d\u091f \u0939\u0948\u0902 \u0907\u0938\u092e\u0947 \u0939\u092e\u0928\u0947 \u090f\u0915 Project \u092e\u0947 \u091c\u094b \u092d\u0940 \u0939\u094b\u0928\u093e \u091a\u093e\u0939\u093f\u090f \u0938\u092d\u0940 point \u0915\u094b \u091c\u094b\u095c\u093e \u0939\u0948\u0902, \u092f\u0926\u093f \u0906\u092a \u0907\u0938 Project \u0915\u094b \u0905\u091a\u094d\u091b\u0947 \u0938\u0947 \u0938\u092e\u091d \u091c\u093e\u0924\u0947 \u0939\u0948\u0902 \u0924\u094b \u0906\u092a \u0928\u093f\u0936\u094d\u091a\u092f \u0939\u0940 \u0916\u0941\u0926 \u0938\u0947 \u0915\u094b\u0908 \u092d\u0940 Project \u092c\u0928\u093e \u092a\u093e\u090f\u0902\u0917\u0947 \u0964 \u0907\u0938 \u092a\u094d\u0930\u094b\u091c\u0947\u0915\u094d\u091f \u0915\u094b \u0939\u092e\u0928\u0947 \u0915\u0941\u0932 7 \u092d\u093e\u0917\u094b\u0902 \u092e\u0947 \u0935\u093f\u092d\u093e\u091c\u093f\u0924 \u0915\u093f\u092f\u093e \u0939\u0948 \u0964 \u0914\u0930 \u092a\u094d\u0930\u0924\u094d\u092f\u0947\u0915 \u092d\u093e\u0917 \u0915\u093e \u090f\u0915 Video \u092d\u0940 \u092c\u0928\u093e\u092f\u093e \u0939\u0948\u0902 \u0924\u093e\u0915\u093f \u0906\u092a \u0914\u0930 \u0905\u091a\u094d\u091b\u0947 \u0938\u0947 \u0938\u092e\u091d \u0938\u0915\u0947 \u0964 <\/p>\n\n\n\n<p>\u0907\u0938 Project \u0915\u094b \u0907\u0938 \u0924\u0930\u0939 \u0938\u0947 Design \u0915\u093f\u092f\u093e \u0917\u092f\u093e \u0939\u0948\u0902 \u0915\u0940 \u0906\u092a Front end \u092a\u0930 \u092c\u0939\u0941\u0924 \u0939\u0940 \u0915\u092e Coding \u0915\u0930 \u092d\u0940 \u0906\u0938\u093e\u0928\u0940 \u0938\u0947 Project \u092c\u0928\u093e \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 \u0907\u0938 Project \u092e\u0947 \u0939\u092e\u0928\u0947 Entry Level Check \u0915\u0947 \u0932\u093f\u090f Triggers \u0915\u093e \u092d\u0940 \u0909\u092a\u092f\u094b\u0917 \u0915\u093f\u092f\u093e \u0939\u0948\u0902 \u091c\u093f\u0938\u0938\u0947 \u0915\u0940 Data \u0915\u0940 Accuracy \u092c\u0928\u0940 \u0930\u0939\u0924\u0940 \u0939\u0948\u0902 \u0964 \u0938\u093e\u0925 \u092e\u0947 \u0915\u0941\u091b \u0905\u0928\u094d\u092f Trigger \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u0939\u092e\u0928\u0947 Data \u0915\u094b \u092d\u0940 \u0907\u0938 \u0924\u0930\u0939 \u0938\u0947 Manage \u0915\u093f\u092f\u093e \u0939\u0948\u0902 \u0924\u093e\u0915\u093f \u0906\u092a\u0915\u094b Report \u092c\u0928\u093e\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u092c\u095c\u0940 \u092c\u095c\u0940 SQL \u0932\u093f\u0916\u0928\u0947 \u0915\u0940 \u0906\u0935\u0936\u094d\u092f\u0915\u0924\u093e \u0928 \u0939\u094b\u0964 <\/p>\n\n\n\n<p>\u0907\u0938 Project \u092e\u0947 \u0906\u092a\u0915\u094b \u0915\u093f\u0938 \u0924\u0930\u0939 \u0938\u0947 Calculation \u0932\u093f\u0916\u0928\u093e \u0939\u0948\u0902, \u0915\u093f\u0938 \u0924\u0930\u0939 \u0938\u0947 Validation \u0932\u0917\u093e\u0928\u093e \u0939\u0948\u0902 \u0964 \u090f\u0915 Table \u0915\u0947 data \u0915\u094b \u0926\u0942\u0938\u0930\u0940 \u091f\u0947\u092c\u0932 \u092e\u0947 \u0915\u093f\u0938 \u0924\u0930\u0939 \u0938\u0947 Update \u0915\u0930\u0928\u093e \u0939\u0948\u0902 \u0964 Table \u092e\u0947 data Insert \u0939\u094b\u0928\u0947 \u0938\u0947 \u092a\u0939\u0932\u0947 \u0915\u094b\u0908 \u092c\u0926\u0932\u093e\u0935 \u0906\u0926\u093f \u0915\u0930\u0928\u0947 \u0939\u094b \u0924\u094b \u0909\u0928\u094d\u0939\u0947 \u0915\u0948\u0938\u0947 \u0915\u093f\u092f\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0902 \u0906\u0926\u093f \u0938\u092d\u0940 \u092a\u094d\u0930\u0915\u093e\u0930 \u0915\u0947 \u0915\u093e\u0930\u094d\u092f \u0907\u0938 \u092a\u094d\u0930\u094b\u091c\u0947\u0915\u094d\u091f \u092e\u0947 \u0915\u093f\u090f \u0917\u090f \u0939\u0948\u0902 \u0964 \u091a\u0932\u093f\u090f \u0936\u0941\u0930\u0942 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Project Overview <\/h2>\n\n\n\n<p>\u092f\u0939 \u090f\u0915 Library Management Software \u0939\u0948\u0902\u0964 \u0907\u0938\u092e\u0947 \u0939\u092e\u093e\u0930\u0947 \u092a\u093e\u0938 \u0915\u0941\u091b Books \u0939\u0948\u0902 \u091c\u093f\u0928\u0915\u094b \u0915\u0940 \u0939\u092e Members \u0915\u094b Issue \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 , \u0915\u0941\u091b \u0938\u092e\u092f \u092c\u093e\u0926 Member \u0915\u0947 \u0926\u094d\u0935\u093e\u0930\u093e \u091c\u092c book \u0915\u094b \u0926\u0947 \u0926\u093f\u092f\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0902 \u0924\u092c \u0909\u0938 Book \u0915\u094b Receive \u0915\u0930 \u0932\u093f\u092f\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0902\u0964 System \u0915\u0947 \u0926\u094d\u0935\u093e\u0930\u093e \u0926\u0947\u0928\u0947 \u0914\u0930 \u092a\u094d\u0930\u093e\u092a\u094d\u0924 \u0939\u094b\u0928\u0947 \u0915\u0940 Date \u0915\u0947 \u092c\u093f\u091a \u0915\u0947 Difference \u0928\u093f\u0915\u093e\u0932 \u0915\u0930 \u092a\u094d\u0930\u0924\u093f \u0926\u093f\u0928 \u0915\u093e \u091c\u094b \u092d\u0940 Rent \u0939\u094b \u0909\u0938\u0938\u0947 \u0926\u093f\u0928\u094b\u0902 \u0915\u0940 \u0938\u0916\u094d\u092f\u093e \u092e\u0947 \u0917\u0941\u0923\u093e \u0915\u0930 \u0930\u093e\u0936\u093f Calculate \u0915\u0940 \u091c\u093e\u0924\u0940 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<p>\u0907\u0938 \u092a\u094d\u0930\u094b\u091c\u0947\u0915\u094d\u091f \u092e\u0947 Book \u0915\u093e Stock Manage \u0939\u094b \u091c\u093e\u0924\u093e \u0939\u0948\u0902 \u0964 \u0914\u0930 \u0938\u093e\u0925 \u092e\u0947 \u0915\u093f\u0924\u0928\u0940 Book Member \u0915\u0947 \u092a\u093e\u0938 \u0939\u0948\u0902 \u0909\u0928\u0915\u0940 \u091c\u093e\u0928\u0915\u093e\u0930\u0940 \u0939\u092e\u090f \u092a\u094d\u0930\u093e\u092a\u094d\u0924 \u0939\u094b \u091c\u093e\u0924\u0940 \u0939\u0948\u0902 \u0964 \u0938\u093e\u0925 \u091c\u092c \u092d\u0940 \u0906\u092a \u0907\u0938 Project \u0915\u094b \u0936\u0941\u0930\u0942 \u0915\u0930\u0947 \u0924\u092c \u0915\u093e Stock Entry \u0915\u0947 \u0932\u093f\u090f Opening \u0915\u093e \u092d\u0940 Provision \u0915\u093f\u092f\u093e \u0917\u092f\u093e \u0939\u0948\u0902\u0964 \u0907\u0938\u0915\u0947 \u0938\u093e\u0925 \u091c\u092c Book Stock \u092e\u0947 \u0928\u0939\u0940\u0902 \u0939\u094b\u0917\u0940 \u0924\u092c \u0906\u092a Book Issue \u0928\u0939\u0940\u0902 \u0915\u0930 \u092a\u093e\u090f\u0902\u0917\u0947 \u0907\u0938 \u0924\u0930\u0939 \u0915\u0947 Check \u092d\u0940 \u0932\u0917\u093e\u090f \u0917\u090f \u0939\u0948\u0902 \u0964 \u0907\u0928 \u0938\u093e\u0924 \u092d\u093e\u0917 \u092e\u0947 \u0905\u092a\u0928\u0947 \u0907\u0938 \u092a\u094d\u0930\u094b\u091c\u0947\u0915\u094d\u091f \u0915\u094b Distribute \u0915\u093f\u092f\u093e \u0939\u0948 \u0964 <\/p>\n\n\n\n<p><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"#a1\">1. Table Structure<\/a><\/li>\n\n\n\n<li><a href=\"#a2\">2. Before Trigger<\/a><\/li>\n\n\n\n<li><a href=\"#a3\">3. After Trigger<\/a><\/li>\n\n\n\n<li><a href=\"#a4\">4. Validation<\/a><\/li>\n\n\n\n<li><a href=\"#a5\">5. Old &amp; New  Keyword<\/a><\/li>\n\n\n\n<li><a href=\"#a6\">6. Calculation<\/a><\/li>\n\n\n\n<li><a href=\"#a7\">7. Report SQL<\/a><\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"a1\">1. Table Structure For Library Management System <\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">1.1 Book <\/h3>\n\n\n\n<p>\u0907\u0938 Table \u092e\u0947 Book \u0915\u0940 Entry \u0939\u094b\u0917\u0940, \u0907\u0938\u092e\u0947 \u0939\u092e\u0928\u0947 Book \u0915\u093e \u0928\u093e\u092e \u0914\u0930 Opening , Issue, Receive, Closing \u0915\u0947 \u0939\u0940 \u0915\u0949\u0932\u092e \u0932\u093f\u090f \u0939\u0948\u0902 \u0964 \u0906\u092a \u0905\u092a\u0928\u0940 Requirement \u0915\u0947 \u0905\u0928\u0941\u0938\u093e\u0930 \u0907\u0938\u092e\u0947 ISBN , Location Book Price \u0906\u0926\u093f \u0914\u0930 \u092d\u0940 \u091c\u094b \u0915\u0949\u0932\u092e \u0932\u0947\u0928\u093e \u091a\u093e\u0939\u0947 \u0932\u0947 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902\u0964 Implement \u0915\u0930\u0924\u0947 \u0938\u092e\u092f \u0939\u092e\u0928\u0947 \u092c\u093e\u0926 \u092e\u0947 \u0907\u0938\u092e\u0947 Rate \u0915\u093e \u0915\u0949\u0932\u092e \u092d\u0940 \u091c\u094b\u095c\u093e \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">CREATE TABLE `mst_book` (\n `id` int(10) NOT NULL AUTO_INCREMENT,\n `book_nm` varchar(40) COLLATE utf8_unicode_ci NOT NULL,\n `op` int(5) NOT NULL,\n `iss` int(5) NOT NULL,\n `rec` int(5) NOT NULL,\n `cl` int(5) NOT NULL,\n `rate` decimal(9,2) NOT NULL DEFAULT '0.00',\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci<\/code><\/pre>\n\n\n\n<p>\u0906\u092a\u0915\u094b \u0907\u0938\u092e\u0947 book_nm , op, rate \u092e\u0947 \u0939\u0940 \u090f\u0902\u091f\u094d\u0930\u0940 Front end \u0938\u0947 \u0915\u0930\u0935\u093e\u0928\u093e \u0939\u0948\u0902 \u0964 iss, rec, cl \u0906\u0926\u093f column \u0915\u0940 \u0935\u0948\u0932\u094d\u092f\u0942 Trigger \u0915\u0947 \u0926\u094d\u0935\u093e\u0930\u093e Update \u0939\u094b\u0917\u0940\u0964 <\/p>\n\n\n\n<h3 class=\"wp-block-heading\">1.2 Member <\/h3>\n\n\n\n<p>\u0906\u092a \u091c\u093f\u0928\u094d\u0939\u0947 \u092d\u0940 Book Issue \u0915\u0930\u0928\u093e \u091a\u093e\u0939\u0924\u0947 \u0939\u0948\u0902 \u091a\u093e\u0939\u0947 \u0935\u0939 Student \u0939\u094b, Teacher \u0939\u094b  \u092f\u093e Staff \u0939\u094b , \u0906\u092a \u0938\u092d\u0940 \u0915\u0947 Entry \u0907\u0938 Table \u092e\u0947 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 \u0907\u0938\u092e\u0947 \u092e\u0947\u0928\u0947 id \u0915\u0947 \u092c\u093e\u0926 \u0915\u0947\u0935\u0932 Member Name \u0915\u093e \u0939\u0940 Column \u0932\u093f\u092f\u093e \u0939\u0948\u0902 \u0964 \u0906\u092a \u0907\u0938\u092e\u0947 Mobile Number, Member Type, Address, City \u0906\u0926\u093f \u0915\u0940 \u091c\u093e\u0928\u0915\u093e\u0930\u0940 \u092d\u0940 \u0932\u0947 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964  <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">CREATE TABLE `mst_member` (\n `id` int(10) NOT NULL AUTO_INCREMENT,\n `mem_nm` varchar(40) COLLATE utf8_unicode_ci NOT NULL,\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\"> 1.3 Issue \/ Receive <\/h3>\n\n\n\n<p>\u0907\u0938 \u090f\u0915 \u0939\u0940 Table \u0938\u0947 \u0939\u092e\u0928\u0947 Book Issue \u0914\u0930 Receive \u0915\u0930\u0928\u0947 \u0915\u093e \u0915\u093e\u0930\u094d\u092f \u0915\u093f\u092f\u093e \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Primary Key :<\/strong> \u0907\u0938 Table \u092e\u0947 id \u0915\u094b Primary \u0915\u093f\u092f\u093e \u0932\u093f\u092f\u093e \u0939\u0948\u0902 \u0914\u0930 Auto Increment \u0938\u0947\u091f \u0915\u093f\u092f\u093e \u0939\u0948\u0902 \u0964 <\/li>\n\n\n\n<li><strong>Foreign Key :<\/strong> \u0907\u0938 \u091f\u0947\u092c\u0932 \u092e\u0947 book_id \u0914\u0930 mem_id \u0915\u094b Foreign key \u0932\u093f\u092f\u093e \u0939\u0948\u0902 \u0964   <\/li>\n<\/ul>\n\n\n\n<p><a href=\"https:\/\/selfimagination.in\/tips\/mysql-foreign-key-constraint\/\">Foreign Key Constrain \u0915\u094b \u0938\u092e\u091d\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0915\u094d\u0932\u093f\u0915 \u0915\u0930\u0947 \u0964 <\/a><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">CREATE TABLE `trn_issue` (\n `id` int(10) NOT NULL AUTO_INCREMENT,\n `tr_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,\n `book_id` int(10) NOT NULL,\n `mem_id` int(10) NOT NULL,\n `rec_flag` int(1) NOT NULL DEFAULT '0',\n `rec_dt` datetime NOT NULL,\n `no_days` int(5) NOT NULL DEFAULT '0',\n `rate` decimal(9,2) NOT NULL DEFAULT '0.00',\n `amt` decimal(9,2) NOT NULL DEFAULT '0.00',\n PRIMARY KEY (`id`),\n KEY `cont_book` (`book_id`),\n KEY `cont_mem` (`mem_id`),\n CONSTRAINT `cont_book` FOREIGN KEY (`book_id`) REFERENCES `mst_book` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,\n CONSTRAINT `cont_mem` FOREIGN KEY (`mem_id`) REFERENCES `mst_member` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE\n) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci<\/code><\/pre>\n\n\n\n<p><a href=\"https:\/\/youtu.be\/6YRM3OK40YA\" target=\"_blank\" rel=\"noopener\">Related Video : MySQL Table Structure For Library Management System (Part 1\/7)<\/a><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"a2\">2. Before Triggers for Library Management System <\/h2>\n\n\n\n<p>Closing calculate \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0939\u092e\u0928\u0947 Before Insert \u0914\u0930 Before Update Trigger \u0932\u093f\u0916\u0947 \u0939\u0948\u0902 \u0964 \u092f\u0939 \u0926\u094b\u0928\u094b\u0902 \u0939\u0940 Calculation Book Table \u092a\u0930 \u0939\u094b\u0902\u0917\u0947 \u0964 <\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"299\" height=\"139\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/image.png?resize=299%2C139&#038;ssl=1\" alt=\"\" class=\"wp-image-9564\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/image.png?w=299&amp;ssl=1 299w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/image.png?resize=150%2C70&amp;ssl=1 150w\" sizes=\"auto, (max-width: 299px) 100vw, 299px\" \/><\/figure>\n\n\n\n<p><a href=\"https:\/\/selfimagination.in\/tips\/mysql-trigger\/\"><a href=\"https:\/\/selfimagination.in\/tips\/mysql-trigger\/\">\u091c\u093e\u0928\u0947 MySQL Triggers \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947<\/a><\/a><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">\nCREATE TRIGGER `mst_book_bi` BEFORE INSERT ON `mst_book`\n FOR EACH ROW BEGIN\n\n    SET new.cl = new.op - new.iss + new.rec; \n\nEND\n\n#---------------------\n\nCREATE TRIGGER `mst_book_bu` BEFORE UPDATE ON `mst_book`\n FOR EACH ROW BEGIN\n\n    SET new.cl = new.op - new.iss + new.rec; \n\nEND\n<\/code><\/pre>\n\n\n\n<p><a href=\"https:\/\/youtu.be\/stO257fOTNo\" target=\"_blank\" rel=\"noopener\">Related Video : MySQL Before Triggers for Library Management System (Part 2\/7)<\/a><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"a3\">3. After Trigger for Library Management System<\/h2>\n\n\n\n<p>Book Table \u092e\u0947 iss \u092f\u093e\u0928\u093f \u0915\u0940 Issue \u0914\u0930 rec \u092f\u093e\u0928\u093f \u0915\u0940 Receive \u0915\u094b Update \u0915\u0930\u0928\u0947 \u0915\u093e \u0915\u093e\u0930\u094d\u092f After Insert,  After Update \u0914\u0930 After Delete Trigger \u0938\u0947 \u0915\u093f\u092f\u093e \u0917\u092f\u093e \u0939\u0948\u0902 \u092f\u0939 \u0924\u0940\u0928\u094b\u0902 \u0939\u0940 Trigger Issue \u0935\u093e\u0932\u0940 table \u092a\u0930 \u0932\u093f\u0916\u0947 \u0917\u090f \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"385\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/image-1.png?resize=640%2C385&#038;ssl=1\" alt=\"\" class=\"wp-image-9569\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/image-1.png?w=677&amp;ssl=1 677w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/image-1.png?resize=300%2C180&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/image-1.png?resize=150%2C90&amp;ssl=1 150w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/figure>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">CREATE TRIGGER `trn_issue_ai` AFTER INSERT ON `trn_issue`\n FOR EACH ROW BEGIN\n\nUPDATE mst_book SET iss = iss + 1 WHERE id = new.book_id;\nUPDATE mst_book SET rec = rec + new.rec_flag WHERE id = new.book_id;\n\nEND\n\n#---------------------\n\nCREATE TRIGGER `trn_issue_au` AFTER UPDATE ON `trn_issue`\n FOR EACH ROW BEGIN\n\nUPDATE mst_book SET iss = iss - 1 WHERE id = old.book_id;\nUPDATE mst_book SET rec = rec - old.rec_flag WHERE id = old.book_id;\n\nUPDATE mst_book SET iss = iss + 1 WHERE id = new.book_id;\nUPDATE mst_book SET rec = rec + new.rec_flag WHERE id = new.book_id;\n\nEND\n\n#---------------------\n\nCREATE TRIGGER `trn_issue_ad` AFTER DELETE ON `trn_issue`\n FOR EACH ROW BEGIN\n\nUPDATE mst_book SET iss = iss - 1 WHERE id = old.book_id;\nUPDATE mst_book SET rec = rec - old.rec_flag WHERE id = old.book_id;\n\nEND\n\n<\/code><\/pre>\n\n\n\n<p><a href=\"https:\/\/youtu.be\/gJvxrwXFaoo\" target=\"_blank\" rel=\"noopener\">Related Video : MySQL After Triggers for Library Management System (Part 3\/7)<\/a><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"a4\">4. Validation for Library Management System<\/h2>\n\n\n\n<p>\u091c\u093f\u0924\u0928\u0940 \u092c\u0941\u0915 \u0939\u092e\u093e\u0930\u0947 \u092a\u093e\u0938 \u0938\u094d\u091f\u0949\u0915 \u092e\u0947 \u0939\u0948 \u0909\u0938\u0938\u0947 \u091c\u094d\u092f\u093e\u0926\u093e \u0907\u0936\u0942 \u0928\u0939\u0940\u0902 \u0939\u094b\u0928\u093e \u091a\u093e\u0939\u093f\u090f , \u092f\u093e \u0915\u0939\u0947 \u0915\u0940 \u092f\u0926\u093f \u0915\u093f\u0938\u0940 Book \u0915\u093e Closing Stock 0 \u0939\u094b \u0924\u092c Book Issue \u0928\u0939\u0940\u0902 \u0939\u094b\u0928\u093e \u091a\u093e\u0939\u093f\u090f \u0964 \u0924\u092c \u0939\u092e Signal SQLSTATE &#8216;45000&#8217; \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 Entry Time Check \u0932\u0917\u093e \u0915\u0930 Insert \u0915\u094b \u0930\u094b\u0915 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902\u0964 <\/p>\n\n\n\n<p>\u092f\u0939 \u0915\u093e\u0930\u094d\u092f Before Insert \u092a\u0930 \u0939\u0940 \u0915\u093f\u092f\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0902 \u0964 <\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"365\" height=\"259\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/image-3.png?resize=365%2C259&#038;ssl=1\" alt=\"\" class=\"wp-image-9578\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/image-3.png?w=365&amp;ssl=1 365w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/image-3.png?resize=300%2C213&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/image-3.png?resize=150%2C106&amp;ssl=1 150w\" sizes=\"auto, (max-width: 365px) 100vw, 365px\" \/><\/figure>\n<\/div>\n\n\n<p>\u0938\u093e\u0925 \u092e\u0947 \u091c\u094b Book Master \u092e\u0947 \u091c\u094b rate \u0939\u0948\u0902 \u0909\u0938 Transaction table \u092e\u0947 \u0905\u092a\u0921\u0947\u091f \u0915\u0930\u0928\u0947 \u0915\u093e \u0915\u093e\u0930\u094d\u092f \u092d\u0940 \u0907\u0938\u0940 Trigger \u0938\u0947 \u0915\u0930\u0935\u093e\u092f\u093e \u0917\u092f\u093e \u0939\u0948\u0902 \u0964 <\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"284\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/image-2.png?resize=640%2C284&#038;ssl=1\" alt=\"\" class=\"wp-image-9577\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/image-2.png?w=684&amp;ssl=1 684w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/image-2.png?resize=300%2C133&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/image-2.png?resize=150%2C67&amp;ssl=1 150w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/figure>\n<\/div>\n\n\n<pre class=\"wp-block-code\"><code class=\"\">CREATE TRIGGER `trn_issue_bi` BEFORE INSERT ON `trn_issue`\n FOR EACH ROW BEGIN\n\nDECLARE li_cl integer DEFAULT 0;\nDECLARE ld_rate decimal(9,2) DEFAULT 0;\n\nSELECT cl INTO li_cl\nFROM mst_book WHERE id = new.book_id;\n\n#For Stock 0 Message \nIF (li_cl &lt; 1) THEN\n\tSIGNAL SQLSTATE '45000'\n    SET MESSAGE_TEXT = 'Book Not in Stock';\nEND IF;\n\n\n#For Set Book Rate From Master \nSELECT rate into ld_rate\nFROM `mst_book` where id = new.book_id;\n\nset new.rate = ld_rate; \n\n\nEND<\/code><\/pre>\n\n\n\n<p><a href=\"https:\/\/youtu.be\/NqUWBjpO5sE\" target=\"_blank\" rel=\"noopener\">Related Video : MySQL Validation for Library Management System (Part 4\/7)<\/a><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"a5\">5. Old &amp; New  Keyword for Library Management System<\/h2>\n\n\n\n<p>\u091c\u092c \u092d\u0940 Update \u0915\u0930\u0928\u0947 \u092a\u0930 \u0915\u093f\u0938\u0940 \u0915\u0949\u0932\u092e \u0915\u094b Update \u0915\u0930\u0928\u0947 \u092a\u0930 \u0909\u0938\u0915\u0947 Update \u0915\u0930\u0928\u0947 \u0915\u0947 \u092a\u0939\u0932\u0947 \u0915\u0940 value \u0914\u0930 bad \u0915\u0940 \u0935\u0948\u0932\u094d\u092f\u0942 \u0915\u094b Compare \u0915\u0930 \u0915\u094b\u0908 \u092d\u0940 operation \u0915\u0930\u0928\u093e \u0939\u094b \u0924\u092c \u0939\u092e \u0907\u0938 \u092a\u094d\u0930\u0915\u093e\u0930 \u0938\u0947 Trigger \u0932\u093f\u0916\u0924\u0947 \u0939\u0948\u0902 \u0964 \u0907\u0938 \u0924\u0930\u0939 \u0915\u0947 Trigger Before Update \u092a\u0930 \u0932\u093f\u0916\u0947 \u091c\u093e\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u0907\u0938\u092e\u0947 \u091c\u092c \u091c\u092c Rec Flag \u092a\u0939\u0932\u0947 0 \u0939\u094b \u0914\u0930 \u092c\u093e\u0926 \u092e\u0947 1 \u0939\u094b \u0924\u094b \u092f\u0939 \u092e\u0928 \u091c\u093e\u0924\u093e \u0939\u0948\u0902 \u0915\u0940 \u092c\u0941\u0915 Receive \u0915\u0940 \u0917\u0908 \u0939\u0948\u0902 \u0964 <\/li>\n\n\n\n<li>\u0914\u0930 \u091c\u092c \u092a\u0939\u0932\u0947 1 \u0914\u0930 \u092c\u093e\u0926 \u092e\u0947 0 \u0939\u094b \u0924\u094b \u092f\u0939 \u092e\u093e\u0928\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0902 \u0915\u0940 \u0906\u092a\u0928\u0947 \u091c\u094b receive \u0915\u0940 entry \u0915\u0940 \u0925\u0940 \u0909\u0938\u0947 \u092a\u093e\u0938 Reverse \u0915\u0930 \u0930\u0939\u0947 \u0939\u0948 \u092f\u093e \u0906\u092a Edit \u0915\u0930 Receive \u0915\u0940 Entry \u0939\u091f\u093e\u0928\u093e \u091a\u093e\u0939\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code class=\"\">CREATE TRIGGER `trn_issue_bu` BEFORE UPDATE ON `trn_issue`\n FOR EACH ROW BEGIN\n\nIF (old.rec_flag = 0 and new.rec_flag = 1) THEN\n\tSET new.rec_dt = now();\n        set new.no_days = datediff(new.rec_dt, new.tr_dt) + 1;\n\tset new.amt = new.no_days * new.rate;\nELSEIF (old.rec_flag = 1 and new.rec_flag = 0) THEN\n\tSET new.rec_dt = '0000-00-00';\nEND IF;\n\nEND<\/code><\/pre>\n\n\n\n<p><a href=\"https:\/\/youtu.be\/hTMmc2H15yM\" target=\"_blank\" rel=\"noopener\">Related Video : 86. MySQL OLD &amp; NEW Keywords for Library Management System (Part 5\/7)<\/a><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"a6\">6. Calculation for Library Management System<\/h2>\n\n\n\n<p>\u0939\u092e\u0947 \u0907\u0938 \u092a\u094d\u0930\u094b\u091c\u0947\u0915\u094d\u091f \u092e\u0947 \u0924\u0940\u0928 Calculation Issue \u0935\u093e\u0932\u0940 \u091f\u0947\u092c\u0932 \u092a\u0930 \u0915\u0930\u0928\u093e \u0939\u0948\u0902 <\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"187\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/image-5.png?resize=640%2C187&#038;ssl=1\" alt=\"\" class=\"wp-image-9597\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/image-5.png?w=663&amp;ssl=1 663w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/image-5.png?resize=300%2C88&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/image-5.png?resize=150%2C44&amp;ssl=1 150w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>1. <strong>No of Day :<\/strong> \u0907\u0938\u092e\u0947 \u0939\u092e\u0947 Issue Date \u0914\u0930 Receive Date \u0915\u0947 \u092c\u093f\u091a \u0915\u0947 Difference \u0915\u094b no_days \u0935\u093e\u0932\u0947 \u0915\u0949\u0932\u092e \u092e\u0947 Update \u0915\u0930\u0928\u093e \u0939\u0948\u0902 \u0964 <\/li>\n\n\n\n<li>2. <strong>Rate Pick from Master :<\/strong> \u0939\u092e\u0947 Book Issue \u0915\u0930\u0924\u0947 \u0938\u092e\u092f Book Master \u0938\u0947 Rate \u0915\u094b \u0932\u093e\u0915\u0930 Issue Table \u092e\u0947 Store \u0915\u0930\u0928\u093e \u0939\u0948\u0902 \u0964 <\/li>\n\n\n\n<li>3. <strong>Find Amount :<\/strong> \u0905\u092c \u091c\u094b \u0939\u092e No of Days \u0914\u0930 Rate \u0932\u093e\u090f \u0939\u0948\u0902 \u0926\u094b\u0928\u094b\u0902 \u0915\u093e \u0917\u0941\u0928\u093e \u0915\u0930 \u0939\u092e\u0947 \u0930\u093e\u0936\u093f Calculate \u0915\u0930\u0928\u093e \u0939\u0948\u0902 \u0964 <\/li>\n<\/ul>\n\n\n\n<p><\/p>\n\n\n\n<p>Rate Pick \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0939\u092e\u0928\u0947 Issue Table \u092a\u0930 Before Insert Trigger \u092e\u0947 \u0928\u093f\u092e\u094d\u0928 Code \u0932\u093f\u0916\u093e \u0925\u093e \u091c\u094b \u0915\u0940 \u0906\u092a\u0915\u094b Validation \u0935\u093e\u0932\u0947 \u092a\u0949\u0907\u0902\u091f \u092e\u0947 \u092e\u093f\u0932 \u091c\u093e\u090f\u0917\u093e\u0964 \u0907\u0938\u092e\u0947 \u0915\u0947\u0935\u0932 \u0909\u0924\u0928\u093e \u0938\u093e code \u0939\u0940 \u0932\u093f\u0916\u093e \u0917\u092f\u093e \u0939\u0948 \u0964 <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code class=\"\">SELECT rate into ld_rate\nFROM `mst_book` where id = new.book_id;\n\nset new.rate = ld_rate; <\/code><\/pre>\n\n\n\n<p>No Of day \u0914\u0930 Amount Calculate \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0939\u092e\u0928\u0947 5 \u0935\u0947 \u092a\u0949\u0907\u0902\u091f \u092e\u0947 Before Update Trigger \u091c\u094b \u0915\u0940 Issue table \u092a\u0930 \u0932\u093f\u0916\u093e \u0917\u092f\u093e \u0939\u0948\u0902 \u0909\u0938\u092e\u0947 \u0928\u093f\u092e\u094d\u0928 Code \u0932\u093f\u0916\u093e \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code class=\"\"> set new.no_days = datediff(new.rec_dt, new.tr_dt) + 1;\n set new.amt = new.no_days * new.rate;<\/code><\/pre>\n\n\n\n<p>\u0907\u0938\u092e\u0947 \u092a\u0939\u0932\u0940 Line \u0938\u0947 Day Calculate \u0915\u093f\u090f \u0939\u0948\u0902 \u0914\u0930 \u0926\u0942\u0938\u0930\u0940 \u0932\u093e\u0907\u0928 \u0938\u0947 Amount Calculate \u0915\u093f\u092f\u093e \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<p><a href=\"https:\/\/youtu.be\/NywtoDEBlRs\" target=\"_blank\" rel=\"noopener\">Related Video : MySQL Calculations for Library Management System (Part 6\/7)<\/a><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"a7\">7. Report SQL for Library Management System<\/h2>\n\n\n\n<p>Report \u0915\u0947 \u0932\u093f\u090f \u0915\u0941\u091b \u091b\u094b\u091f\u0940 \u091b\u094b\u091f\u0940 SQL \u0932\u093f\u0916\u0940 \u0917\u0908 \u0939\u0948\u0902 \u0964 SQL Execute \u0915\u0930\u0928\u0947 \u0938\u0947 \u092a\u0939\u0932\u0947 \u0915\u093e Data \u0907\u0938 \u092a\u094d\u0930\u0915\u093e\u0930 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"129\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/image-7.png?resize=640%2C129&#038;ssl=1\" alt=\"\" class=\"wp-image-9602\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/image-7.png?resize=1024%2C207&amp;ssl=1 1024w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/image-7.png?resize=300%2C61&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/image-7.png?resize=768%2C155&amp;ssl=1 768w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/image-7.png?resize=150%2C30&amp;ssl=1 150w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/image-7.png?w=1073&amp;ssl=1 1073w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p><strong>Q 1. \u0915\u093f\u0924\u0928\u0940 Books \u0939\u092e\u093e\u0930\u0947 \u092a\u093e\u0938 Stock \u092e\u0947 \u0939\u0948\u0902 ?<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT * FROM `mst_book` WHERE cl &gt; 0 ORDER BY `id` ASC<\/code><\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"326\" height=\"112\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/image-8.png?resize=326%2C112&#038;ssl=1\" alt=\"\" class=\"wp-image-9603\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/image-8.png?w=326&amp;ssl=1 326w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/image-8.png?resize=300%2C103&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/image-8.png?resize=150%2C52&amp;ssl=1 150w\" sizes=\"auto, (max-width: 326px) 100vw, 326px\" \/><\/figure>\n<\/div>\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p><strong>Q 2. \u0915\u093f\u0924\u0928\u0940 Books \u0910\u0938\u0940 \u0939\u0948\u0902 \u091c\u093f\u0928\u0915\u093e Stock \u0939\u092e\u093e\u0930\u0947 \u092a\u093e\u0938 \u0928\u0939\u0940\u0902 \u0939\u0948\u0902 ?<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT * FROM `mst_book` WHERE cl = 0 ORDER BY `id` ASC\n<\/code><\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"291\" height=\"57\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/image-9.png?resize=291%2C57&#038;ssl=1\" alt=\"\" class=\"wp-image-9606\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/image-9.png?w=291&amp;ssl=1 291w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/image-9.png?resize=150%2C29&amp;ssl=1 150w\" sizes=\"auto, (max-width: 291px) 100vw, 291px\" \/><\/figure>\n<\/div>\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p><strong>Q 3. \u0915\u093f\u0924\u0928\u0940 \u0910\u0938\u0940 Books \u0939\u0948\u0902 \u091c\u093f\u0928\u0915\u094b \u0939\u092e\u0928\u0947 Issue \u0915\u093f\u092f\u093e \u0939\u0948 \u0964 <\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT * FROM `mst_book` WHERE iss &gt; 0 ORDER BY `id` ASC\n<\/code><\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"328\" height=\"82\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/image-10.png?resize=328%2C82&#038;ssl=1\" alt=\"\" class=\"wp-image-9612\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/image-10.png?w=328&amp;ssl=1 328w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/image-10.png?resize=300%2C75&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/image-10.png?resize=150%2C38&amp;ssl=1 150w\" sizes=\"auto, (max-width: 328px) 100vw, 328px\" \/><\/figure>\n<\/div>\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p><strong>Q 4. \u0915\u093f\u0924\u0928\u0940 \u0910\u0938\u0940 Books \u0939\u0948\u0902 \u091c\u093f\u0928\u0915\u094b \u0939\u092e\u0928\u0947 Issue \u0915\u093f\u092f\u093e \u0939\u0948 , Book \u0915\u0947 \u0928\u093e\u092e \u0914\u0930 Member \u0915\u0947 \u0928\u093e\u092e \u092d\u0940 \u092c\u0924\u093e\u0928\u093e \u0939\u0948\u0902 \u0964 <\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT a.tr_dt, b.book_nm, c.mem_nm \nFROM `trn_issue` a \nleft join mst_book b on a.book_id = b.id \nleft join mst_member c on a.mem_id = c.id \nWHERE a.rec_flag = 0\nORDER BY a.tr_dt<\/code><\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"287\" height=\"77\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/image-11.png?resize=287%2C77&#038;ssl=1\" alt=\"\" class=\"wp-image-9615\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/image-11.png?w=287&amp;ssl=1 287w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/image-11.png?resize=150%2C40&amp;ssl=1 150w\" sizes=\"auto, (max-width: 287px) 100vw, 287px\" \/><\/figure>\n<\/div>\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p><strong>Q . \u0915\u093f\u0924\u0928\u0940 \u0910\u0938\u0940 Books \u0939\u0948\u0902 \u091c\u093f\u0928\u0915\u094b \u0939\u092e\u0928\u0947 Issue \u0915\u093f\u092f\u093e \u0939\u0948 \u091c\u093f\u0928\u0915\u094b 7 \u0926\u093f\u0928 \u0938\u0947 \u091c\u094d\u092f\u093e\u0926\u093e \u0915\u093e \u0938\u092e\u092f \u0939\u094b \u0917\u092f\u093e \u0939\u094b?<\/strong><\/p>\n\n\n\n<p>\u0907\u0938 SQL \u0915\u094b 05-12-2022 \u0915\u094b Execute \u0915\u093f\u092f\u093e \u0939\u0948\u0902 \u0909\u0938 \u0905\u0928\u0941\u0938\u093e\u0930 \u0926\u093f\u0928 Calculate \u0939\u0941\u0935\u0947 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT a.tr_dt, b.book_nm, c.mem_nm , ( datediff(now(), tr_dt) + 1 ) as no_days \nFROM `trn_issue` a \nleft join mst_book b on a.book_id = b.id \nleft join mst_member c on a.mem_id = c.id \nWHERE a.rec_flag = 0 and ( datediff(now(), tr_dt) + 1 ) &gt; 7 \nORDER BY a.tr_dt<\/code><\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"365\" height=\"45\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/image-12.png?resize=365%2C45&#038;ssl=1\" alt=\"\" class=\"wp-image-9617\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/image-12.png?w=365&amp;ssl=1 365w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/image-12.png?resize=300%2C37&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/image-12.png?resize=150%2C18&amp;ssl=1 150w\" sizes=\"auto, (max-width: 365px) 100vw, 365px\" \/><\/figure>\n<\/div>\n\n\n<p><a href=\"https:\/\/youtu.be\/CDyHwWeNrGA\" target=\"_blank\" rel=\"noopener\">Related Video : MySQL Report SQL for Library Management System (Part 7\/7)<\/a><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p>\u0907\u0938 Article \u0938\u0947 Related \u0906\u092a\u0915\u0940 \u0915\u094b\u0908 \u092d\u0940 Query \u0939\u094b \u0924\u094b \u0906\u092a \u0928\u093f\u0938\u0902\u0915\u094b\u091a Comment \u0915\u0930\u0947, \u092f\u0939 Article \u0915\u0948\u0938\u093e \u0932\u0917\u093e \u092c\u0924\u093e\u0928\u093e \u0928 \u092d\u0942\u0932\u0947 , \u092e\u093f\u0932\u0924\u0947 \u0939\u0948\u0902 Next Article \u092e\u0947 , Thanks For Reading \u0964 <\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u0938\u0940\u0916\u0947 VIDEO \u0915\u0947 \u092e\u093e\u0927\u094d\u092f\u092e \u0938\u0947<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u0938\u0930\u0932 \u092d\u093e\u0937\u093e \u092e\u0947 Programming \u0938\u0940\u0916\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f&nbsp;<a href=\"https:\/\/www.youtube.com\/channel\/UCHLuWJ4xcq70qvWgog4YSrg\" target=\"_blank\" rel=\"noreferrer noopener\">Imagination Code Channel<\/a>&nbsp;\u0915\u094b Subscribe \u0915\u0930\u0947\u0964<\/li>\n\n\n\n<li><a href=\"https:\/\/t.me\/tutorialforlearnmysql\" target=\"_blank\" rel=\"noreferrer noopener\">MySQL Telegram Channel<\/a>&nbsp;\u0938\u0947 \u091c\u0941\u0921\u093c\u0947 \u0914\u0930 \u092a\u093e\u090f Article &amp; Video \u092a\u094d\u0930\u0924\u093f\u0926\u0940\u0928<\/li>\n\n\n\n<li><a href=\"https:\/\/www.youtube.com\/watch?v=dwKr33RG3UA&amp;list=PLhJ6tQK0qIcOLAiCWg00L79euGSNVoVno\" target=\"_blank\" rel=\"noreferrer noopener\">MySQL Beginner &amp; Advance Playlist in Hindi<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/youtu.be\/dwKr33RG3UA\" target=\"_blank\" rel=\"noreferrer noopener\">MySQL Overview in One Video<\/a><\/li>\n<\/ol>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>\u0939\u092e\u093e\u0930\u0947 \u0905\u0928\u094d\u092f \u0906\u0930\u094d\u091f\u093f\u0915\u0932<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/selfimagination.in\/tips\/mysql-function\/\">MySQL Function<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/mysql-stored-procedure\/\">MySQL Stored Procedure<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/get-post-method\/\">PHP Get \/Post Method \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947\u0902 \u091c\u093e\u0928\u0947<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/php-math-function\/\">PHP Math Function \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947\u0902 \u091c\u093e\u0928\u0947<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/learn-cpp-from-c\/\">C \u0938\u0947 C ++ \u0938\u0940\u0916\u0947 \u0938\u0930\u0932 \u0936\u092c\u094d\u0926\u094b\u0902 \u092e\u0947\u0902<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/php-variables\/\">PHP Variable \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947\u0902 \u091c\u093e\u0928\u0947<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/arduino-control-structure\/\">Arduino Control Structure<\/a>&nbsp;<\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/c-union\/\">Union in C<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/c-pointer\/\">Declaration of Pointer in C<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/search-jquery\/\">jQuery Search Filter<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/mysql-table-create-alter-drop\/\">MySQL Create Table | Alter Table | Drop Table<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/api-using-node-react-express-mysql\/\">API Using NODE REACT EXPRESS MYSQL SEQUELIZE (For Backend OR Server Side)<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/cpanel\/\">CPANEL In Hindi<\/a><\/li>\n<\/ul>\n\n\n\n<p> <\/p>\n","protected":false},"excerpt":{"rendered":"<p>MySQL ka upyog kar library Management software kaise banaye, Library ko aasani se kaise manage kare, trigger ke upyog se books stock kaise manage kare. \u0907\u0938 \u0906\u0930\u094d\u091f\u093f\u0915\u0932 \u092e\u0947 \u0939\u092e\u0928\u0947 \u090f\u0915 Library \u0915\u0940 \u0935\u0930\u094d\u0915\u093f\u0902\u0917 \u0915\u094b MySQL Database \u092e\u0947 design \u0915\u093f\u092f\u093e \u0939\u0948\u0902, \u092f\u0939 \u092c\u0939\u0941\u0924 \u0939\u0940 \u091b\u094b\u091f\u093e \u0938\u093e \u092a\u094d\u0930\u094b\u091c\u0947\u0915\u094d\u091f \u0939\u0948\u0902 \u0907\u0938\u092e\u0947 \u0939\u092e\u0928\u0947 \u090f\u0915 Project \u092e\u0947 \u091c\u094b \u092d\u0940 \u0939\u094b\u0928\u093e [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":9627,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[5,27],"tags":[],"class_list":["post-9540","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql","category-projects"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/library-management-using-mysql.jpg?fit=1200%2C628&ssl=1","_links":{"self":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/9540","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/comments?post=9540"}],"version-history":[{"count":87,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/9540\/revisions"}],"predecessor-version":[{"id":9642,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/9540\/revisions\/9642"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/media\/9627"}],"wp:attachment":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/media?parent=9540"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/categories?post=9540"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/tags?post=9540"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}