tag:blogger.com,1999:blog-7881032605604625532024-03-16T06:39:13.196+05:30MAC+ tech Computer,Electronic,Digital,mobile & New TechnologyKishor M Sonawanehttp://www.blogger.com/profile/12171589855304919032noreply@blogger.comBlogger64125tag:blogger.com,1999:blog-788103260560462553.post-51932763598185186172023-10-19T22:01:00.008+05:302023-10-19T22:03:12.122+05:30How to delete duplicate records from a SQL data table<p> <strong style="box-sizing: border-box; color: #212121; font-family: "open sans", sans-serif; font-size: 16px; margin: 0px; padding: 0px;">introduction</strong></p><p style="background-color: white; box-sizing: border-box; color: #212121; font-family: "open sans", sans-serif; font-size: 16px; line-height: 1.5; margin: 1em 0px; padding: 0px;">How to delete duplicate records from a SQL data table using CTE (common table expression). Specifies a temporary named result set, known as a common table expression (CTE).</p><p style="background-color: white; box-sizing: border-box; color: #212121; font-family: "open sans", sans-serif; font-size: 16px; line-height: 1.5; margin: 1em 0px; padding: 0px;"><strong style="box-sizing: border-box; margin: 0px; padding: 0px;">Syntax</strong></p><div style="background-color: white; box-sizing: border-box; color: #212121; font-family: "open sans", sans-serif; font-size: 16px; margin: 0px; padding: 0px;"><div class="dp-highlighter" style="background-color: #e7e5dc; box-sizing: border-box; font-family: Consolas, "Courier New", Courier, mono, serif; margin: 18px 0px; overflow: auto; padding: 1px 0px 0px; width: 815.094px;"><div class="bar" style="box-sizing: border-box; margin: 0px; padding: 0px 0px 0px 45px;"></div><ol class="dp-sql" start="1" style="background-color: white; border: none; box-sizing: border-box; color: #5c5c5c; list-style-image: initial; list-style-position: initial; margin-bottom: 10px; margin-left: 35px; margin-right: 0px !important; margin-top: 10px; margin: 10px 0px 10px 35px; padding: 0px;"><li class="alt" style="border-bottom: none; border-image: initial; border-left: 3px solid rgb(108, 226, 108); border-right: none; border-top: none; box-sizing: border-box; color: inherit; line-height: 18px; list-style-image: initial; list-style-position: outside !important; list-style-type: decimal-leading-zero; list-style: outside decimal-leading-zero; margin: 0px; padding: 0px 3px 0px 10px;"><span style="background-color: inherit; border: none; box-sizing: border-box; color: black; margin: 0px; padding: 0px;"><span class="keyword" style="background-color: inherit; border: none; box-sizing: border-box; color: #006699; font-weight: bold; margin: 0px; padding: 0px;">WITH</span><span style="background-color: inherit; border: none; box-sizing: border-box; margin: 0px; padding: 0px;"> table_nameCTE </span><span class="keyword" style="background-color: inherit; border: none; box-sizing: border-box; color: #006699; font-weight: bold; margin: 0px; padding: 0px;">AS</span><span style="background-color: inherit; border: none; box-sizing: border-box; margin: 0px; padding: 0px;"> </span></span></li><li style="background-color: #f8f8f8; border-bottom: none; border-image: initial; border-left: 3px solid rgb(108, 226, 108); border-right: none; border-top: none; box-sizing: border-box; line-height: 18px; list-style-image: initial; list-style-position: outside !important; list-style-type: decimal-leading-zero; list-style: outside decimal-leading-zero; margin: 0px; padding: 0px 3px 0px 10px;"><span style="background-color: inherit; border: none; box-sizing: border-box; color: black; margin: 0px; padding: 0px;">( </span></li><li class="alt" style="border-bottom: none; border-image: initial; border-left: 3px solid rgb(108, 226, 108); border-right: none; border-top: none; box-sizing: border-box; color: inherit; line-height: 18px; list-style-image: initial; list-style-position: outside !important; list-style-type: decimal-leading-zero; list-style: outside decimal-leading-zero; margin: 0px; padding: 0px 3px 0px 10px;"><span style="background-color: inherit; border: none; box-sizing: border-box; color: black; margin: 0px; padding: 0px;"><span class="keyword" style="background-color: inherit; border: none; box-sizing: border-box; color: #006699; font-weight: bold; margin: 0px; padding: 0px;"> SELECT</span><span style="background-color: inherit; border: none; box-sizing: border-box; margin: 0px; padding: 0px;">*, ROW_NUMBER() over (PARTITION </span><span class="keyword" style="background-color: inherit; border: none; box-sizing: border-box; color: #006699; font-weight: bold; margin: 0px; padding: 0px;">BY</span><span style="background-color: inherit; border: none; box-sizing: border-box; margin: 0px; padding: 0px;"> ID </span><span class="keyword" style="background-color: inherit; border: none; box-sizing: border-box; color: #006699; font-weight: bold; margin: 0px; padding: 0px;">ORDER</span><span style="background-color: inherit; border: none; box-sizing: border-box; margin: 0px; padding: 0px;"> </span><span class="keyword" style="background-color: inherit; border: none; box-sizing: border-box; color: #006699; font-weight: bold; margin: 0px; padding: 0px;">BY</span><span style="background-color: inherit; border: none; box-sizing: border-box; margin: 0px; padding: 0px;"> ID) </span><span class="keyword" style="background-color: inherit; border: none; box-sizing: border-box; color: #006699; font-weight: bold; margin: 0px; padding: 0px;">as</span><span style="background-color: inherit; border: none; box-sizing: border-box; margin: 0px; padding: 0px;"> < alias_name > </span></span></li><li style="background-color: #f8f8f8; border-bottom: none; border-image: initial; border-left: 3px solid rgb(108, 226, 108); border-right: none; border-top: none; box-sizing: border-box; line-height: 18px; list-style-image: initial; list-style-position: outside !important; list-style-type: decimal-leading-zero; list-style: outside decimal-leading-zero; margin: 0px; padding: 0px 3px 0px 10px;"><span style="background-color: inherit; border: none; box-sizing: border-box; color: black; margin: 0px; padding: 0px;"><span class="keyword" style="background-color: inherit; border: none; box-sizing: border-box; color: #006699; font-weight: bold; margin: 0px; padding: 0px;"> FROM</span><span style="background-color: inherit; border: none; box-sizing: border-box; margin: 0px; padding: 0px;"> table_name </span></span></li><li class="alt" style="border-bottom: none; border-image: initial; border-left: 3px solid rgb(108, 226, 108); border-right: none; border-top: none; box-sizing: border-box; color: inherit; line-height: 18px; list-style-image: initial; list-style-position: outside !important; list-style-type: decimal-leading-zero; list-style: outside decimal-leading-zero; margin: 0px; padding: 0px 3px 0px 10px;"><span style="background-color: inherit; border: none; box-sizing: border-box; color: black; margin: 0px; padding: 0px;">) </span></li><li style="background-color: #f8f8f8; border-bottom: none; border-image: initial; border-left: 3px solid rgb(108, 226, 108); border-right: none; border-top: none; box-sizing: border-box; line-height: 18px; list-style-image: initial; list-style-position: outside !important; list-style-type: decimal-leading-zero; list-style: outside decimal-leading-zero; margin: 0px; padding: 0px 3px 0px 10px;"><span style="background-color: inherit; border: none; box-sizing: border-box; color: black; margin: 0px; padding: 0px;"><span class="keyword" style="background-color: inherit; border: none; box-sizing: border-box; color: #006699; font-weight: bold; margin: 0px; padding: 0px;">DELETE</span><span style="background-color: inherit; border: none; box-sizing: border-box; margin: 0px; padding: 0px;"> </span><span class="keyword" style="background-color: inherit; border: none; box-sizing: border-box; color: #006699; font-weight: bold; margin: 0px; padding: 0px;">FROM</span><span style="background-color: inherit; border: none; box-sizing: border-box; margin: 0px; padding: 0px;"> table_nameCTE </span><span class="keyword" style="background-color: inherit; border: none; box-sizing: border-box; color: #006699; font-weight: bold; margin: 0px; padding: 0px;">WHERE</span><span style="background-color: inherit; border: none; box-sizing: border-box; margin: 0px; padding: 0px;"> alias_name >1 </span></span></li></ol></div></div><p style="background-color: white; box-sizing: border-box; color: #212121; font-family: "open sans", sans-serif; font-size: 16px; line-height: 1.5; margin: 1em 0px; padding: 0px;"><strong style="box-sizing: border-box; margin: 0px; padding: 0px;">Step 1</strong></p><div style="background-color: white; box-sizing: border-box; color: #212121; font-family: "open sans", sans-serif; font-size: 16px; margin: 0px; padding: 0px;">Open SQL Server 2014 or your choice. Create table with name Employees.</div><div class="dp-highlighter" style="background-color: #e7e5dc; box-sizing: border-box; color: #212121; font-family: Consolas, "Courier New", Courier, mono, serif; font-size: 16px; margin: 18px 0px; overflow: auto; padding: 1px 0px 0px; width: 815.094px;"><div class="bar" style="box-sizing: border-box; margin: 0px; padding: 0px 0px 0px 45px;"></div><ol class="dp-cpp" start="1" style="background-color: white; border: none; box-sizing: border-box; color: #5c5c5c; list-style-image: initial; list-style-position: initial; margin-bottom: 10px; margin-left: 35px; margin-right: 0px !important; margin-top: 10px; margin: 10px 0px 10px 35px; padding: 0px;"><li class="alt" style="border-bottom: none; border-image: initial; border-left: 3px solid rgb(108, 226, 108); border-right: none; border-top: none; box-sizing: border-box; color: inherit; line-height: 18px; list-style-image: initial; list-style-position: outside !important; list-style-type: decimal-leading-zero; list-style: outside decimal-leading-zero; margin: 0px; padding: 0px 3px 0px 10px;"><span style="background-color: inherit; border: none; box-sizing: border-box; color: black; margin: 0px; padding: 0px;">create table Employees </span></li><li style="background-color: #f8f8f8; border-bottom: none; border-image: initial; border-left: 3px solid rgb(108, 226, 108); border-right: none; border-top: none; box-sizing: border-box; line-height: 18px; list-style-image: initial; list-style-position: outside !important; list-style-type: decimal-leading-zero; list-style: outside decimal-leading-zero; margin: 0px; padding: 0px 3px 0px 10px;"><span style="background-color: inherit; border: none; box-sizing: border-box; color: black; margin: 0px; padding: 0px;">( </span></li><li class="alt" style="border-bottom: none; border-image: initial; border-left: 3px solid rgb(108, 226, 108); border-right: none; border-top: none; box-sizing: border-box; color: inherit; line-height: 18px; list-style-image: initial; list-style-position: outside !important; list-style-type: decimal-leading-zero; list-style: outside decimal-leading-zero; margin: 0px; padding: 0px 3px 0px 10px;"><span style="background-color: inherit; border: none; box-sizing: border-box; color: black; margin: 0px; padding: 0px;"> ID <span class="datatypes" style="background-color: inherit; border: none; box-sizing: border-box; margin: 0px; padding: 0px;">int</span><span style="background-color: inherit; border: none; box-sizing: border-box; margin: 0px; padding: 0px;">, </span></span></li><li style="background-color: #f8f8f8; border-bottom: none; border-image: initial; border-left: 3px solid rgb(108, 226, 108); border-right: none; border-top: none; box-sizing: border-box; line-height: 18px; list-style-image: initial; list-style-position: outside !important; list-style-type: decimal-leading-zero; list-style: outside decimal-leading-zero; margin: 0px; padding: 0px 3px 0px 10px;"><span style="background-color: inherit; border: none; box-sizing: border-box; color: black; margin: 0px; padding: 0px;"> Name nvarchar(50), </span></li><li class="alt" style="border-bottom: none; border-image: initial; border-left: 3px solid rgb(108, 226, 108); border-right: none; border-top: none; box-sizing: border-box; color: inherit; line-height: 18px; list-style-image: initial; list-style-position: outside !important; list-style-type: decimal-leading-zero; list-style: outside decimal-leading-zero; margin: 0px; padding: 0px 3px 0px 10px;"><span style="background-color: inherit; border: none; box-sizing: border-box; color: black; margin: 0px; padding: 0px;"> Gender <span class="datatypes" style="background-color: inherit; border: none; box-sizing: border-box; margin: 0px; padding: 0px;">char</span><span style="background-color: inherit; border: none; box-sizing: border-box; margin: 0px; padding: 0px;">(10), </span></span></li><li style="background-color: #f8f8f8; border-bottom: none; border-image: initial; border-left: 3px solid rgb(108, 226, 108); border-right: none; border-top: none; box-sizing: border-box; line-height: 18px; list-style-image: initial; list-style-position: outside !important; list-style-type: decimal-leading-zero; list-style: outside decimal-leading-zero; margin: 0px; padding: 0px 3px 0px 10px;"><span style="background-color: inherit; border: none; box-sizing: border-box; color: black; margin: 0px; padding: 0px;"> Salary <span class="datatypes" style="background-color: inherit; border: none; box-sizing: border-box; margin: 0px; padding: 0px;">int</span><span style="background-color: inherit; border: none; box-sizing: border-box; margin: 0px; padding: 0px;"> </span></span></li><li class="alt" style="border-bottom: none; border-image: initial; border-left: 3px solid rgb(108, 226, 108); border-right: none; border-top: none; box-sizing: border-box; color: inherit; line-height: 18px; list-style-image: initial; list-style-position: outside !important; list-style-type: decimal-leading-zero; list-style: outside decimal-leading-zero; margin: 0px; padding: 0px 3px 0px 10px;"><span style="background-color: inherit; border: none; box-sizing: border-box; color: black; margin: 0px; padding: 0px;">) </span></li></ol></div><p style="background-color: white; box-sizing: border-box; color: #212121; font-family: "open sans", sans-serif; font-size: 16px; line-height: 1.5; margin: 1em 0px; padding: 0px;"><strong style="box-sizing: border-box; margin: 0px; padding: 0px;">Step 2</strong></p><div style="background-color: white; box-sizing: border-box; color: #212121; font-family: "open sans", sans-serif; font-size: 16px; margin: 0px; padding: 0px;">Insert some duplicate record. Below is sample record.</div><div class="dp-highlighter" style="background-color: #e7e5dc; box-sizing: border-box; color: #212121; font-family: Consolas, "Courier New", Courier, mono, serif; font-size: 16px; margin: 18px 0px; overflow: auto; padding: 1px 0px 0px; width: 815.094px;"><div class="bar" style="box-sizing: border-box; margin: 0px; padding: 0px 0px 0px 45px;"></div><ol class="dp-cpp" start="1" style="background-color: white; border: none; box-sizing: border-box; color: #5c5c5c; list-style-image: initial; list-style-position: initial; margin-bottom: 10px; margin-left: 35px; margin-right: 0px !important; margin-top: 10px; margin: 10px 0px 10px 35px; padding: 0px;"><li class="alt" style="border-bottom: none; border-image: initial; border-left: 3px solid rgb(108, 226, 108); border-right: none; border-top: none; box-sizing: border-box; color: inherit; line-height: 18px; list-style-image: initial; list-style-position: outside !important; list-style-type: decimal-leading-zero; list-style: outside decimal-leading-zero; margin: 0px; padding: 0px 3px 0px 10px;"><span style="background-color: inherit; border: none; box-sizing: border-box; color: black; margin: 0px; padding: 0px;"><span style="background-color: inherit; border: none; box-sizing: border-box; margin: 0px; padding: 0px;">insert into Employees values(1,</span><span class="string" style="background-color: inherit; border: none; box-sizing: border-box; color: blue; margin: 0px; padding: 0px;">'Farhan Ahmed'</span><span style="background-color: inherit; border: none; box-sizing: border-box; margin: 0px; padding: 0px;">,</span><span class="string" style="background-color: inherit; border: none; box-sizing: border-box; color: blue; margin: 0px; padding: 0px;">'Male'</span><span style="background-color: inherit; border: none; box-sizing: border-box; margin: 0px; padding: 0px;">,60000) </span></span></li><li style="background-color: #f8f8f8; border-bottom: none; border-image: initial; border-left: 3px solid rgb(108, 226, 108); border-right: none; border-top: none; box-sizing: border-box; line-height: 18px; list-style-image: initial; list-style-position: outside !important; list-style-type: decimal-leading-zero; list-style: outside decimal-leading-zero; margin: 0px; padding: 0px 3px 0px 10px;"><span style="background-color: inherit; border: none; box-sizing: border-box; color: black; margin: 0px; padding: 0px;">insert into Employees values(5,<span class="string" style="background-color: inherit; border: none; box-sizing: border-box; color: blue; margin: 0px; padding: 0px;">'Monika'</span><span style="background-color: inherit; border: none; box-sizing: border-box; margin: 0px; padding: 0px;">,</span><span class="string" style="background-color: inherit; border: none; box-sizing: border-box; color: blue; margin: 0px; padding: 0px;">'Female'</span><span style="background-color: inherit; border: none; box-sizing: border-box; margin: 0px; padding: 0px;">,25000) </span></span></li><li class="alt" style="border-bottom: none; border-image: initial; border-left: 3px solid rgb(108, 226, 108); border-right: none; border-top: none; box-sizing: border-box; color: inherit; line-height: 18px; list-style-image: initial; list-style-position: outside !important; list-style-type: decimal-leading-zero; list-style: outside decimal-leading-zero; margin: 0px; padding: 0px 3px 0px 10px;"><span style="background-color: inherit; border: none; box-sizing: border-box; color: black; margin: 0px; padding: 0px;">insert into Employees values(2,<span class="string" style="background-color: inherit; border: none; box-sizing: border-box; color: blue; margin: 0px; padding: 0px;">'Abdul Raheem'</span><span style="background-color: inherit; border: none; box-sizing: border-box; margin: 0px; padding: 0px;">,</span><span class="string" style="background-color: inherit; border: none; box-sizing: border-box; color: blue; margin: 0px; padding: 0px;">'Male'</span><span style="background-color: inherit; border: none; box-sizing: border-box; margin: 0px; padding: 0px;">,30000) </span></span></li><li style="background-color: #f8f8f8; border-bottom: none; border-image: initial; border-left: 3px solid rgb(108, 226, 108); border-right: none; border-top: none; box-sizing: border-box; line-height: 18px; list-style-image: initial; list-style-position: outside !important; list-style-type: decimal-leading-zero; list-style: outside decimal-leading-zero; margin: 0px; padding: 0px 3px 0px 10px;"><span style="background-color: inherit; border: none; box-sizing: border-box; color: black; margin: 0px; padding: 0px;">insert into Employees values(4,<span class="string" style="background-color: inherit; border: none; box-sizing: border-box; color: blue; margin: 0px; padding: 0px;">'Rahul Sharma'</span><span style="background-color: inherit; border: none; box-sizing: border-box; margin: 0px; padding: 0px;">,</span><span class="string" style="background-color: inherit; border: none; box-sizing: border-box; color: blue; margin: 0px; padding: 0px;">'Male'</span><span style="background-color: inherit; border: none; box-sizing: border-box; margin: 0px; padding: 0px;">,60000) </span></span></li><li class="alt" style="border-bottom: none; border-image: initial; border-left: 3px solid rgb(108, 226, 108); border-right: none; border-top: none; box-sizing: border-box; color: inherit; line-height: 18px; list-style-image: initial; list-style-position: outside !important; list-style-type: decimal-leading-zero; list-style: outside decimal-leading-zero; margin: 0px; padding: 0px 3px 0px 10px;"><span style="background-color: inherit; border: none; box-sizing: border-box; color: black; margin: 0px; padding: 0px;">insert into Employees values(1,<span class="string" style="background-color: inherit; border: none; box-sizing: border-box; color: blue; margin: 0px; padding: 0px;">'Farhan Ahmed'</span><span style="background-color: inherit; border: none; box-sizing: border-box; margin: 0px; padding: 0px;">,</span><span class="string" style="background-color: inherit; border: none; box-sizing: border-box; color: blue; margin: 0px; padding: 0px;">'Male'</span><span style="background-color: inherit; border: none; box-sizing: border-box; margin: 0px; padding: 0px;">,60000) </span></span></li><li style="background-color: #f8f8f8; border-bottom: none; border-image: initial; border-left: 3px solid rgb(108, 226, 108); border-right: none; border-top: none; box-sizing: border-box; line-height: 18px; list-style-image: initial; list-style-position: outside !important; list-style-type: decimal-leading-zero; list-style: outside decimal-leading-zero; margin: 0px; padding: 0px 3px 0px 10px;"><span style="background-color: inherit; border: none; box-sizing: border-box; color: black; margin: 0px; padding: 0px;">insert into Employees values(2,<span class="string" style="background-color: inherit; border: none; box-sizing: border-box; color: blue; margin: 0px; padding: 0px;">'Abdul Raheem'</span><span style="background-color: inherit; border: none; box-sizing: border-box; margin: 0px; padding: 0px;">,</span><span class="string" style="background-color: inherit; border: none; box-sizing: border-box; color: blue; margin: 0px; padding: 0px;">'Male'</span><span style="background-color: inherit; border: none; box-sizing: border-box; margin: 0px; padding: 0px;">,30000) </span></span></li><li class="alt" style="border-bottom: none; border-image: initial; border-left: 3px solid rgb(108, 226, 108); border-right: none; border-top: none; box-sizing: border-box; color: inherit; line-height: 18px; list-style-image: initial; list-style-position: outside !important; list-style-type: decimal-leading-zero; list-style: outside decimal-leading-zero; margin: 0px; padding: 0px 3px 0px 10px;"><span style="background-color: inherit; border: none; box-sizing: border-box; color: black; margin: 0px; padding: 0px;">insert into Employees values(5,<span class="string" style="background-color: inherit; border: none; box-sizing: border-box; color: blue; margin: 0px; padding: 0px;">'Monika'</span><span style="background-color: inherit; border: none; box-sizing: border-box; margin: 0px; padding: 0px;">,</span><span class="string" style="background-color: inherit; border: none; box-sizing: border-box; color: blue; margin: 0px; padding: 0px;">'Female'</span><span style="background-color: inherit; border: none; box-sizing: border-box; margin: 0px; padding: 0px;">,25000) </span></span></li><li style="background-color: #f8f8f8; border-bottom: none; border-image: initial; border-left: 3px solid rgb(108, 226, 108); border-right: none; border-top: none; box-sizing: border-box; line-height: 18px; list-style-image: initial; list-style-position: outside !important; list-style-type: decimal-leading-zero; list-style: outside decimal-leading-zero; margin: 0px; padding: 0px 3px 0px 10px;"><span style="background-color: inherit; border: none; box-sizing: border-box; color: black; margin: 0px; padding: 0px;">insert into Employees values(4,<span class="string" style="background-color: inherit; border: none; box-sizing: border-box; color: blue; margin: 0px; padding: 0px;">'Rahul Sharma'</span><span style="background-color: inherit; border: none; box-sizing: border-box; margin: 0px; padding: 0px;">,</span><span class="string" style="background-color: inherit; border: none; box-sizing: border-box; color: blue; margin: 0px; padding: 0px;">'Male'</span><span style="background-color: inherit; border: none; box-sizing: border-box; margin: 0px; padding: 0px;">,60000) </span></span></li><li class="alt" style="border-bottom: none; border-image: initial; border-left: 3px solid rgb(108, 226, 108); border-right: none; border-top: none; box-sizing: border-box; color: inherit; line-height: 18px; list-style-image: initial; list-style-position: outside !important; list-style-type: decimal-leading-zero; list-style: outside decimal-leading-zero; margin: 0px; padding: 0px 3px 0px 10px;"><span style="background-color: inherit; border: none; box-sizing: border-box; color: black; margin: 0px; padding: 0px;">insert into Employees values(1,<span class="string" style="background-color: inherit; border: none; box-sizing: border-box; color: blue; margin: 0px; padding: 0px;">'Farhan Ahmed'</span><span style="background-color: inherit; border: none; box-sizing: border-box; margin: 0px; padding: 0px;">,</span><span class="string" style="background-color: inherit; border: none; box-sizing: border-box; color: blue; margin: 0px; padding: 0px;">'Male'</span><span style="background-color: inherit; border: none; box-sizing: border-box; margin: 0px; padding: 0px;">,60000) </span></span></li><li style="background-color: #f8f8f8; border-bottom: none; border-image: initial; border-left: 3px solid rgb(108, 226, 108); border-right: none; border-top: none; box-sizing: border-box; line-height: 18px; list-style-image: initial; list-style-position: outside !important; list-style-type: decimal-leading-zero; list-style: outside decimal-leading-zero; margin: 0px; padding: 0px 3px 0px 10px;"><span style="background-color: inherit; border: none; box-sizing: border-box; color: black; margin: 0px; padding: 0px;">insert into Employees values(3,<span class="string" style="background-color: inherit; border: none; box-sizing: border-box; color: blue; margin: 0px; padding: 0px;">'Priya'</span><span style="background-color: inherit; border: none; box-sizing: border-box; margin: 0px; padding: 0px;">,</span><span class="string" style="background-color: inherit; border: none; box-sizing: border-box; color: blue; margin: 0px; padding: 0px;">'Female'</span><span style="background-color: inherit; border: none; box-sizing: border-box; margin: 0px; padding: 0px;">,20000) </span></span></li><li class="alt" style="border-bottom: none; border-image: initial; border-left: 3px solid rgb(108, 226, 108); border-right: none; border-top: none; box-sizing: border-box; color: inherit; line-height: 18px; list-style-image: initial; list-style-position: outside !important; list-style-type: decimal-leading-zero; list-style: outside decimal-leading-zero; margin: 0px; padding: 0px 3px 0px 10px;"><span style="background-color: inherit; border: none; box-sizing: border-box; color: black; margin: 0px; padding: 0px;">insert into Employees values(5,<span class="string" style="background-color: inherit; border: none; box-sizing: border-box; color: blue; margin: 0px; padding: 0px;">'Monika'</span><span style="background-color: inherit; border: none; box-sizing: border-box; margin: 0px; padding: 0px;">,</span><span class="string" style="background-color: inherit; border: none; box-sizing: border-box; color: blue; margin: 0px; padding: 0px;">'Female'</span><span style="background-color: inherit; border: none; box-sizing: border-box; margin: 0px; padding: 0px;">,25000) </span></span></li><li style="background-color: #f8f8f8; border-bottom: none; border-image: initial; border-left: 3px solid rgb(108, 226, 108); border-right: none; border-top: none; box-sizing: border-box; line-height: 18px; list-style-image: initial; list-style-position: outside !important; list-style-type: decimal-leading-zero; list-style: outside decimal-leading-zero; margin: 0px; padding: 0px 3px 0px 10px;"><span style="background-color: inherit; border: none; box-sizing: border-box; color: black; margin: 0px; padding: 0px;">insert into Employees values(4,<span class="string" style="background-color: inherit; border: none; box-sizing: border-box; color: blue; margin: 0px; padding: 0px;">'Rahul Sharma'</span><span style="background-color: inherit; border: none; box-sizing: border-box; margin: 0px; padding: 0px;">,</span><span class="string" style="background-color: inherit; border: none; box-sizing: border-box; color: blue; margin: 0px; padding: 0px;">'Male'</span><span style="background-color: inherit; border: none; box-sizing: border-box; margin: 0px; padding: 0px;">,60000) </span></span></li><li class="alt" style="border-bottom: none; border-image: initial; border-left: 3px solid rgb(108, 226, 108); border-right: none; border-top: none; box-sizing: border-box; color: inherit; line-height: 18px; list-style-image: initial; list-style-position: outside !important; list-style-type: decimal-leading-zero; list-style: outside decimal-leading-zero; margin: 0px; padding: 0px 3px 0px 10px;"><span style="background-color: inherit; border: none; box-sizing: border-box; color: black; margin: 0px; padding: 0px;">insert into Employees values(5,<span class="string" style="background-color: inherit; border: none; box-sizing: border-box; color: blue; margin: 0px; padding: 0px;">'Monika'</span><span style="background-color: inherit; border: none; box-sizing: border-box; margin: 0px; padding: 0px;">,</span><span class="string" style="background-color: inherit; border: none; box-sizing: border-box; color: blue; margin: 0px; padding: 0px;">'Female'</span><span style="background-color: inherit; border: none; box-sizing: border-box; margin: 0px; padding: 0px;">,25000) </span></span></li><li style="background-color: #f8f8f8; border-bottom: none; border-image: initial; border-left: 3px solid rgb(108, 226, 108); border-right: none; border-top: none; box-sizing: border-box; line-height: 18px; list-style-image: initial; list-style-position: outside !important; list-style-type: decimal-leading-zero; list-style: outside decimal-leading-zero; margin: 0px; padding: 0px 3px 0px 10px;"><span style="background-color: inherit; border: none; box-sizing: border-box; color: black; margin: 0px; padding: 0px;">insert into Employees values(2,<span class="string" style="background-color: inherit; border: none; box-sizing: border-box; color: blue; margin: 0px; padding: 0px;">'Abdul Raheem'</span><span style="background-color: inherit; border: none; box-sizing: border-box; margin: 0px; padding: 0px;">,</span><span class="string" style="background-color: inherit; border: none; box-sizing: border-box; color: blue; margin: 0px; padding: 0px;">'Male'</span><span style="background-color: inherit; border: none; box-sizing: border-box; margin: 0px; padding: 0px;">,30000) </span></span></li><li class="alt" style="border-bottom: none; border-image: initial; border-left: 3px solid rgb(108, 226, 108); border-right: none; border-top: none; box-sizing: border-box; color: inherit; line-height: 18px; list-style-image: initial; list-style-position: outside !important; list-style-type: decimal-leading-zero; list-style: outside decimal-leading-zero; margin: 0px; padding: 0px 3px 0px 10px;"><span style="background-color: inherit; border: none; box-sizing: border-box; color: black; margin: 0px; padding: 0px;">insert into Employees values(1,<span class="string" style="background-color: inherit; border: none; box-sizing: border-box; color: blue; margin: 0px; padding: 0px;">'Farhan Ahmed'</span><span style="background-color: inherit; border: none; box-sizing: border-box; margin: 0px; padding: 0px;">,</span><span class="string" style="background-color: inherit; border: none; box-sizing: border-box; color: blue; margin: 0px; padding: 0px;">'Male'</span><span style="background-color: inherit; border: none; box-sizing: border-box; margin: 0px; padding: 0px;">,60000) </span></span></li><li style="background-color: #f8f8f8; border-bottom: none; border-image: initial; border-left: 3px solid rgb(108, 226, 108); border-right: none; border-top: none; box-sizing: border-box; line-height: 18px; list-style-image: initial; list-style-position: outside !important; list-style-type: decimal-leading-zero; list-style: outside decimal-leading-zero; margin: 0px; padding: 0px 3px 0px 10px;"><span style="background-color: inherit; border: none; box-sizing: border-box; color: black; margin: 0px; padding: 0px;">insert into Employees values(4,<span class="string" style="background-color: inherit; border: none; box-sizing: border-box; color: blue; margin: 0px; padding: 0px;">'Rahul Sharma'</span><span style="background-color: inherit; border: none; box-sizing: border-box; margin: 0px; padding: 0px;">,</span><span class="string" style="background-color: inherit; border: none; box-sizing: border-box; color: blue; margin: 0px; padding: 0px;">'Male'</span><span style="background-color: inherit; border: none; box-sizing: border-box; margin: 0px; padding: 0px;">,60000) </span></span></li></ol></div><p style="background-color: white; box-sizing: border-box; color: #212121; font-family: "open sans", sans-serif; font-size: 16px; line-height: 1.5; margin: 1em 0px; padding: 0px;"><strong style="box-sizing: border-box; margin: 0px; padding: 0px;">Step 3</strong></p><div style="background-color: white; box-sizing: border-box; color: #212121; font-family: "open sans", sans-serif; font-size: 16px; margin: 0px; padding: 0px;">Write CTE (Common table expression) and partition records.</div><div class="dp-highlighter" style="background-color: #e7e5dc; box-sizing: border-box; color: #212121; font-family: Consolas, "Courier New", Courier, mono, serif; font-size: 16px; margin: 18px 0px; overflow: auto; padding: 1px 0px 0px; width: 815.094px;"><div class="bar" style="box-sizing: border-box; margin: 0px; padding: 0px 0px 0px 45px;"></div><ol class="dp-cpp" start="1" style="background-color: white; border: none; box-sizing: border-box; color: #5c5c5c; list-style-image: initial; list-style-position: initial; margin-bottom: 10px; margin-left: 35px; margin-right: 0px !important; margin-top: 10px; margin: 10px 0px 10px 35px; padding: 0px;"><li class="alt" style="border-bottom: none; border-image: initial; border-left: 3px solid rgb(108, 226, 108); border-right: none; border-top: none; box-sizing: border-box; color: inherit; line-height: 18px; list-style-image: initial; list-style-position: outside !important; list-style-type: decimal-leading-zero; list-style: outside decimal-leading-zero; margin: 0px; padding: 0px 3px 0px 10px;"><span style="background-color: inherit; border: none; box-sizing: border-box; color: black; margin: 0px; padding: 0px;">WITH EmployeesCTE as </span></li><li style="background-color: #f8f8f8; border-bottom: none; border-image: initial; border-left: 3px solid rgb(108, 226, 108); border-right: none; border-top: none; box-sizing: border-box; line-height: 18px; list-style-image: initial; list-style-position: outside !important; list-style-type: decimal-leading-zero; list-style: outside decimal-leading-zero; margin: 0px; padding: 0px 3px 0px 10px;"><span style="background-color: inherit; border: none; box-sizing: border-box; color: black; margin: 0px; padding: 0px;">( </span></li><li class="alt" style="border-bottom: none; border-image: initial; border-left: 3px solid rgb(108, 226, 108); border-right: none; border-top: none; box-sizing: border-box; color: inherit; line-height: 18px; list-style-image: initial; list-style-position: outside !important; list-style-type: decimal-leading-zero; list-style: outside decimal-leading-zero; margin: 0px; padding: 0px 3px 0px 10px;"><span style="background-color: inherit; border: none; box-sizing: border-box; color: black; margin: 0px; padding: 0px;"> SELECT*, ROW_NUMBER() over (PARTITION BY ID ORDER BY ID) as RowNumber </span></li><li style="background-color: #f8f8f8; border-bottom: none; border-image: initial; border-left: 3px solid rgb(108, 226, 108); border-right: none; border-top: none; box-sizing: border-box; line-height: 18px; list-style-image: initial; list-style-position: outside !important; list-style-type: decimal-leading-zero; list-style: outside decimal-leading-zero; margin: 0px; padding: 0px 3px 0px 10px;"><span style="background-color: inherit; border: none; box-sizing: border-box; color: black; margin: 0px; padding: 0px;"> FROM Employees </span></li><li class="alt" style="border-bottom: none; border-image: initial; border-left: 3px solid rgb(108, 226, 108); border-right: none; border-top: none; box-sizing: border-box; color: inherit; line-height: 18px; list-style-image: initial; list-style-position: outside !important; list-style-type: decimal-leading-zero; list-style: outside decimal-leading-zero; margin: 0px; padding: 0px 3px 0px 10px;"><span style="background-color: inherit; border: none; box-sizing: border-box; color: black; margin: 0px; padding: 0px;">) </span></li><li style="background-color: #f8f8f8; border-bottom: none; border-image: initial; border-left: 3px solid rgb(108, 226, 108); border-right: none; border-top: none; box-sizing: border-box; line-height: 18px; list-style-image: initial; list-style-position: outside !important; list-style-type: decimal-leading-zero; list-style: outside decimal-leading-zero; margin: 0px; padding: 0px 3px 0px 10px;"><span style="background-color: inherit; border: none; box-sizing: border-box; color: black; margin: 0px; padding: 0px;">SELECT * FROM EmployeesCTE </span></li></ol></div><div style="background-color: white; box-sizing: border-box; color: #212121; font-family: "open sans", sans-serif; font-size: 16px; margin: 0px; padding: 0px; text-align: center;"><img alt="Delete Duplicate Record From SQL Database Using CTE" data-src="https://n7b3p4s2.stackpathcdn.com/UploadFile/BlogImages/12152018111644AM/Delete Duplicate Record From SQL Database Using CTE1.png" src="https://n7b3p4s2.stackpathcdn.com/UploadFile/BlogImages/12152018111644AM/Delete%20Duplicate%20Record%20From%20SQL%20Database%20Using%20CTE1.png" style="box-sizing: border-box; margin: 0px; max-width: 100%; padding: 0px;" /></div><div style="background-color: white; box-sizing: border-box; color: #212121; font-family: "open sans", sans-serif; font-size: 16px; margin: 0px; padding: 0px;"> </div><div style="background-color: white; box-sizing: border-box; color: #212121; font-family: "open sans", sans-serif; font-size: 16px; margin: 0px; padding: 0px;"><strong style="box-sizing: border-box; margin: 0px; padding: 0px;">Step 4</strong></div><div style="background-color: white; box-sizing: border-box; color: #212121; font-family: "open sans", sans-serif; font-size: 16px; margin: 0px; padding: 0px;"> </div><div style="background-color: white; box-sizing: border-box; color: #212121; font-family: "open sans", sans-serif; font-size: 16px; margin: 0px; padding: 0px;">Write query for delete duplicate record with CTE (common table expression).</div><div style="background-color: white; box-sizing: border-box; color: #212121; font-family: "open sans", sans-serif; font-size: 16px; margin: 0px; padding: 0px;"><div class="dp-highlighter" style="background-color: #e7e5dc; box-sizing: border-box; font-family: Consolas, "Courier New", Courier, mono, serif; margin: 18px 0px; overflow: auto; padding: 1px 0px 0px; width: 815.094px;"><div class="bar" style="box-sizing: border-box; margin: 0px; padding: 0px 0px 0px 45px;"></div><ol class="dp-cpp" start="1" style="background-color: white; border: none; box-sizing: border-box; color: #5c5c5c; list-style-image: initial; list-style-position: initial; margin-bottom: 10px; margin-left: 35px; margin-right: 0px !important; margin-top: 10px; margin: 10px 0px 10px 35px; padding: 0px;"><li class="alt" style="border-bottom: none; border-image: initial; border-left: 3px solid rgb(108, 226, 108); border-right: none; border-top: none; box-sizing: border-box; color: inherit; line-height: 18px; list-style-image: initial; list-style-position: outside !important; list-style-type: decimal-leading-zero; list-style: outside decimal-leading-zero; margin: 0px; padding: 0px 3px 0px 10px;"><span style="background-color: inherit; border: none; box-sizing: border-box; color: black; margin: 0px; padding: 0px;">WITH EmployeesCTE as </span></li><li style="background-color: #f8f8f8; border-bottom: none; border-image: initial; border-left: 3px solid rgb(108, 226, 108); border-right: none; border-top: none; box-sizing: border-box; line-height: 18px; list-style-image: initial; list-style-position: outside !important; list-style-type: decimal-leading-zero; list-style: outside decimal-leading-zero; margin: 0px; padding: 0px 3px 0px 10px;"><span style="background-color: inherit; border: none; box-sizing: border-box; color: black; margin: 0px; padding: 0px;">( </span></li><li class="alt" style="border-bottom: none; border-image: initial; border-left: 3px solid rgb(108, 226, 108); border-right: none; border-top: none; box-sizing: border-box; color: inherit; line-height: 18px; list-style-image: initial; list-style-position: outside !important; list-style-type: decimal-leading-zero; list-style: outside decimal-leading-zero; margin: 0px; padding: 0px 3px 0px 10px;"><span style="background-color: inherit; border: none; box-sizing: border-box; color: black; margin: 0px; padding: 0px;"> SELECT*, ROW_NUMBER() over (PARTITION BY ID ORDER BY ID) as RowNumber </span></li><li style="background-color: #f8f8f8; border-bottom: none; border-image: initial; border-left: 3px solid rgb(108, 226, 108); border-right: none; border-top: none; box-sizing: border-box; line-height: 18px; list-style-image: initial; list-style-position: outside !important; list-style-type: decimal-leading-zero; list-style: outside decimal-leading-zero; margin: 0px; padding: 0px 3px 0px 10px;"><span style="background-color: inherit; border: none; box-sizing: border-box; color: black; margin: 0px; padding: 0px;"> FROM Employees </span></li><li class="alt" style="border-bottom: none; border-image: initial; border-left: 3px solid rgb(108, 226, 108); border-right: none; border-top: none; box-sizing: border-box; color: inherit; line-height: 18px; list-style-image: initial; list-style-position: outside !important; list-style-type: decimal-leading-zero; list-style: outside decimal-leading-zero; margin: 0px; padding: 0px 3px 0px 10px;"><span style="background-color: inherit; border: none; box-sizing: border-box; color: black; margin: 0px; padding: 0px;">) </span></li><li style="background-color: #f8f8f8; border-bottom: none; border-image: initial; border-left: 3px solid rgb(108, 226, 108); border-right: none; border-top: none; box-sizing: border-box; line-height: 18px; list-style-image: initial; list-style-position: outside !important; list-style-type: decimal-leading-zero; list-style: outside decimal-leading-zero; margin: 0px; padding: 0px 3px 0px 10px;"><span style="background-color: inherit; border: none; box-sizing: border-box; color: black; margin: 0px; padding: 0px;">DELETE FROM EmployeesCTE WHERE RowNumber>1 </span></li><li class="alt" style="border-bottom: none; border-image: initial; border-left: 3px solid rgb(108, 226, 108); border-right: none; border-top: none; box-sizing: border-box; color: inherit; line-height: 18px; list-style-image: initial; list-style-position: outside !important; list-style-type: decimal-leading-zero; list-style: outside decimal-leading-zero; margin: 0px; padding: 0px 3px 0px 10px;"><span style="background-color: inherit; border: none; box-sizing: border-box; color: black; margin: 0px; padding: 0px;"> </span></li><li style="background-color: #f8f8f8; border-bottom: none; border-image: initial; border-left: 3px solid rgb(108, 226, 108); border-right: none; border-top: none; box-sizing: border-box; line-height: 18px; list-style-image: initial; list-style-position: outside !important; list-style-type: decimal-leading-zero; list-style: outside decimal-leading-zero; margin: 0px; padding: 0px 3px 0px 10px;"><span style="background-color: inherit; border: none; box-sizing: border-box; color: black; margin: 0px; padding: 0px;">SELECT * FROM Employees </span></li></ol></div><div style="box-sizing: border-box; margin: 0px; padding: 0px; text-align: center;"><img alt="Delete Duplicate Record From SQL Database Using CTE" data-src="https://n7b3p4s2.stackpathcdn.com/UploadFile/BlogImages/12152018111644AM/Delete Duplicate Record From SQL Database Using CTE2.png" src="https://n7b3p4s2.stackpathcdn.com/UploadFile/BlogImages/12152018111644AM/Delete%20Duplicate%20Record%20From%20SQL%20Database%20Using%20CTE2.png" style="box-sizing: border-box; margin: 0px; max-width: 100%; padding: 0px;" /></div><div style="box-sizing: border-box; margin: 0px; padding: 0px; text-align: center;"><br /></div><div style="box-sizing: border-box; margin: 0px; padding: 0px; text-align: center;"><br /></div><div style="box-sizing: border-box; margin: 0px; padding: 0px; text-align: center;">Source : https://www.c-sharpcorner.com/blogs/delete-duplicate-record-from-sql-data-table-using-cte</div></div>Kishor M Sonawanehttp://www.blogger.com/profile/12171589855304919032noreply@blogger.com0India20.593684 78.96288-4.5329883666990725 43.80663 45.720356366699072 114.11913tag:blogger.com,1999:blog-788103260560462553.post-75316588941561766112021-07-27T15:17:00.000+05:302021-07-27T15:17:20.802+05:30how to run C Graphics Program in UBUNTU <div dir="ltr" style="text-align: left;" trbidi="on">
<h3 class="post-title entry-title" itemprop="name">
</h3>
<div class="post-header">
</div>
<br />
<span style="color: blue;">
<span style="font-family: "verdana" , sans-serif;">how to Include gcc <graphics.h>?</span></span><br />
<span style="font-family: "verdana" , sans-serif;">ans</span><br />
<span style="font-family: "verdana" , sans-serif;"> </span><span style="font-family: "verdana" , sans-serif;"> This post is about how you can run graphics program in Ubuntu platform. </span><br />
<h3 style="text-align: left;">
<b><u><span style="font-family: "verdana" , sans-serif;">Steps:</span></u></b></h3>
<div>
<b><u><span style="font-family: "verdana" , sans-serif;"><br /></span></u></b></div>
<div>
<span style="color: #38761d;"><span style="background-color: #eeeeee; font-family: "arial" , "helvetica" , sans-serif; font-size: medium;">Step:1</span></span><br />
<span style="font-family: "verdana" , sans-serif;">Make sure that you have basic compilers installed. For this run the command:</span></div>
<pre style="background-color: #eeeeee; border: 1px dashed #999999; color: black; font-family: Andale Mono, Lucida Console, Monaco, fixed, monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 100%;"><code style="color: black; word-wrap: normal;"> sudo apt-get install build-essential</code></pre>
<div>
<span style="font-family: "verdana" , sans-serif;"></span><br />
<a name='more'></a><span style="font-family: "verdana" , sans-serif;"><br /></span>
<br />
<div>
<span style="color: #38761d;"><b><u><span style="font-family: "verdana" , sans-serif;"><br /></span></u></b></span></div>
<span style="color: #38761d;">
<span style="background-color: #eeeeee; font-family: "arial" , "helvetica" , sans-serif; font-size: medium;">Step:</span><span style="background-color: #eeeeee; font-family: "arial" , "helvetica" , sans-serif; font-size: medium;">2</span></span><br />
<span style="font-family: "verdana" , sans-serif;">Install few packages that required. Run the command:</span></div>
<pre style="background-color: #eeeeee; border: 1px dashed #999999; color: black; font-family: Andale Mono, Lucida Console, Monaco, fixed, monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; scroll: no; width: 100%;"><code style="color: black; word-wrap: normal;"> sudo apt-get install libsdl-image1.2 libsdl-image1.2-dev guile-1.8 guile-1.8-dev libsdl1.2debian libart-2.0-dev libaudiofile-dev libesd0-dev libdirectfb-dev libdirectfb-extra libfreetype6-dev libxext-dev x11proto-xext-dev libfreetype6 libaa1 libaa1-dev libslang2-dev libasound2 libasound2-dev</code></pre>
<span style="background-color: white; font-family: "verdana" , sans-serif;"><br /></span>
<br />
<div>
<b><u><span style="font-family: "verdana" , sans-serif;"><br /></span></u></b></div>
<span style="color: #38761d;"><span style="background-color: #eeeeee; font-family: "arial" , "helvetica" , sans-serif; font-size: medium;">Step:</span><span style="background-color: #eeeeee; font-family: "arial" , "helvetica" , sans-serif; font-size: medium;">3</span></span><br />
<span style="background-color: white; font-family: "verdana" , sans-serif;">Now download <a href="http://download.savannah.gnu.org/releases/libgraph/libgraph-1.0.2.tar.gz">libgraph</a>.</span><br />
<span style="background-color: white; font-family: "verdana" , sans-serif;">Copy libgraph-1.0.2.tar.gz to your home folder. Right click on it and select "Extract Here".</span><br />
<span style="background-color: white; font-family: "verdana" , sans-serif;">Then run following commands one by one.</span>
<br />
<pre style="background-color: #eeeeee; border: 1px dashed #999999; color: black; font-family: Andale Mono, Lucida Console, Monaco, fixed, monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 100%;"><code style="color: black; word-wrap: normal;"> cd libgraph-1.0.2</code></pre>
<pre style="background-color: #eeeeee; border: 1px dashed #999999; color: black; font-family: Andale Mono, Lucida Console, Monaco, fixed, monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 100%;"><code style="color: black; word-wrap: normal;"> ./configure</code></pre>
<pre style="background-color: #eeeeee; border: 1px dashed #999999; color: black; font-family: Andale Mono, Lucida Console, Monaco, fixed, monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 100%;"><code style="color: black; word-wrap: normal;"> sudo make</code></pre>
<pre style="background-color: #eeeeee; border: 1px dashed #999999; color: black; font-family: Andale Mono, Lucida Console, Monaco, fixed, monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 100%;"><code style="color: black; word-wrap: normal;"> sudo make install</code></pre>
<pre style="background-color: #eeeeee; border: 1px dashed #999999; color: black; font-family: Andale Mono, Lucida Console, Monaco, fixed, monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 100%;"><code style="color: black; word-wrap: normal;"> sudo cp /usr/local/lib/libgraph.* /usr/lib</code></pre>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<br />
<div>
<b><u><span style="font-family: "verdana" , sans-serif;"><br /></span></u></b></div>
<span style="color: #38761d;"><span style="background-color: #eeeeee; font-family: "arial" , "helvetica" , sans-serif; font-size: medium;">Step:</span><span style="background-color: #eeeeee; font-family: "arial" , "helvetica" , sans-serif; font-size: medium;">4</span></span><br />
<span style="font-family: "verdana" , sans-serif;">Now Ubuntu is ready to run graphics program. To do that add </span><span style="font-family: "courier new" , "courier" , monospace;"><span style="color: #0b5394;">#include</span><span style="color: magenta;"><graphics.h></span></span><span style="font-family: "verdana" , sans-serif;"> in your C program.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">>>In Turbo C we use following lines</span><br />
<pre style="background-color: #eeeeee; border: 1px dashed #999999; color: black; font-family: Andale Mono, Lucida Console, Monaco, fixed, monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; scroll: no; width: 100%;"><code style="color: black; word-wrap: normal;"> int gd=DETECT,gm;
initgraph(&gd,&gm,"c:\\tc\\bgi");</code></pre>
<span style="font-family: "verdana" , sans-serif;">>>In Ubuntu instead of "</span><span style="font-family: "courier new" , "courier" , monospace;">c:\\tc\\bgi</span><span style="font-family: "verdana" , sans-serif;">" write </span><span style="font-family: "courier new" , "courier" , monospace;">NULL</span><br />
<pre style="background-color: #eeeeee; border: 1px dashed #999999; color: black; font-family: Andale Mono, Lucida Console, Monaco, fixed, monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; scroll: no; width: 100%;"><code style="color: black; word-wrap: normal;"> int gd=DETECT,gm;
initgraph(&gd,&gm,NULL);</code></pre>
<br />
<br />
Example<br />
copy following code<br />
<br />
<br />
<span style="background-color: #eeeeee;">///--------------------------------------------------------------------<br /><span style="color: #b45f06;"><span style="color: blue;">#include<graphics.h><br />int main()<br />{<br />int gd=DETECT,gm; <br />initgraph(&gd,&gm,NULL); //<-use NULL<br />setcolor(BLUE);<br />line(100,100,200,200);<br />delay(5000); </span></span></span><span style="background-color: #eeeeee;"><span style="color: #b45f06;"><span style="color: blue;"><span style="background-color: #eeeeee;"><span style="color: #b45f06;"><span style="color: blue;">//wait for output</span></span></span> </span></span></span><br />
<span style="background-color: #eeeeee;"><span style="color: #b45f06;"><span style="color: blue;"><span style="background-color: #eeeeee;"><span style="color: #b45f06;"><span style="color: blue;"></span></span></span>closegraph(); <br />return(0);<br />}</span></span></span><br />
//------------------------------------------------------------------------<br />
<br />
>save code any location<br />
>open terminal (Ctrl+Alt+t)<br />
>go to program saved DIR $cd mydir<br />
type following commands:<br />
<span style="font-family: "verdana" , sans-serif;">Run it with following command:</span><br />
<br />
<pre style="background-color: #eeeeee; border: 1px dashed #999999; color: black; font-family: Andale Mono, Lucida Console, Monaco, fixed, monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; scroll: no; width: 100%;"><code style="color: black; word-wrap: normal;"> gcc sample.c -o sample -lgraph</code></pre>
<pre style="background-color: #eeeeee; border: 1px dashed #999999; color: black; font-family: Andale Mono, Lucida Console, Monaco, fixed, monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; scroll: no; width: 100%;"><code style="color: black; word-wrap: normal;"> ./sample</code></pre>
<br />
oputput:-<br />
<br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgvz70raJOq4kOHfwOEjJLJ-esibtEO48l0D12iYsBhpv4NtQtf0qh-zgrhiMxWPWqhkOTpIN48tgzN3PnWG-s_Rbauz9ZZynM7ym485WyQ76ohUjLA3rBIxn87HXdJovuoP5h_xGBUou4/s1600/Screenshot+from+2016-08-12+22%253A47%253A02.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="356" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgvz70raJOq4kOHfwOEjJLJ-esibtEO48l0D12iYsBhpv4NtQtf0qh-zgrhiMxWPWqhkOTpIN48tgzN3PnWG-s_Rbauz9ZZynM7ym485WyQ76ohUjLA3rBIxn87HXdJovuoP5h_xGBUou4/s640/Screenshot+from+2016-08-12+22%253A47%253A02.png" width="640" /></a></div>
<br /></div>
Kishor M Sonawanehttp://www.blogger.com/profile/12171589855304919032noreply@blogger.com1tag:blogger.com,1999:blog-788103260560462553.post-8826568756284932422020-11-19T21:06:00.004+05:302021-06-18T15:10:54.604+05:30PYMONGO INSTALLATION STEPS<p> PYMONGO INSTALLATION STEPS :</p><p>1. Copy & paste pymongo-2.7.1.tar.gz in Home Directory and extract it. 2. Open terminal</p><p>>cd pymongo-2.7.1</p><p>>sudo python setup.py install</p><p>installation complete.</p><p>PYMONGO SUPPORT TOOLS INSTALLATION STEPS :</p><p>1. Copy & paste pypa-setuptools-9616be97e6a7.tar.gz in Home Directory and extract it.</p><p>2. Open terminal</p><p>>cd pypa-setuptools-9616be97e6a7</p><p>>sudo python setup.py install</p><p>installation complete.</p><p>Copy & paste jdk-7u25-linux-i586.tar.gz in home folder and extract it.</p><p>Copy & paste eclipse-jee-luna-R-linux-gtk.tar.gz in home folder & extract it. Copy & paste apache-tomcat-7.0.55.tar.gz in home folder and extract it. Copy & paste mysql-connector-java-5.1.18-bin.jar in home folder, apache-tomcat-7.0.55/bin, apache-tomcat-7.0.55/lib.</p><p>Copy & paste mongo-java-driver-2.12.2.jar in home folder</p>
<iframe style="width:120px;height:240px;" marginwidth="0" marginheight="0" scrolling="no" frameborder="0" src="//ws-in.amazon-adsystem.com/widgets/q?ServiceVersion=20070822&OneJS=1&Operation=GetAdHtml&MarketPlace=IN&source=ac&ref=tf_til&ad_type=product_link&tracking_id=macplustech-21&marketplace=amazon&region=IN&placement=B08F4F32PG&asins=B08F4F32PG&linkId=9e9f05629827c08ec838a5000eba610f&show_border=false&link_opens_in_new_window=false&price_color=333333&title_color=0066c0&bg_color=ffffff">
</iframe>
Kishor M Sonawanehttp://www.blogger.com/profile/12171589855304919032noreply@blogger.com0tag:blogger.com,1999:blog-788103260560462553.post-42008205899520421332020-11-19T21:05:00.004+05:302021-06-18T15:13:42.958+05:30PYTHON INSTALLATION STEPS<p> PYTHON INSTALLATION STEPS :</p><p>1. Copy Python-3.3.2.tar.bz2 and Django-1.5.2.tar.gz & paste both in Home Directory and extract them.</p><p>2. Open terminal</p><p>>cd Django-1.5.2</p><p>>sudo python setup.py install</p><p> </p><p> installation complete.</p>
<iframe style="width:120px;height:240px;" marginwidth="0" marginheight="0" scrolling="no" frameborder="0" src="//ws-in.amazon-adsystem.com/widgets/q?ServiceVersion=20070822&OneJS=1&Operation=GetAdHtml&MarketPlace=IN&source=ac&ref=tf_til&ad_type=product_link&tracking_id=macplustech-21&marketplace=amazon&region=IN&placement=B08697N43N&asins=B08697N43N&linkId=2d4ce5a124e3041d70b31e220ddb9304&show_border=false&link_opens_in_new_window=false&price_color=333333&title_color=0066c0&bg_color=ffffff">
</iframe>Kishor M Sonawanehttp://www.blogger.com/profile/12171589855304919032noreply@blogger.com1tag:blogger.com,1999:blog-788103260560462553.post-30558053681807355232020-11-19T21:04:00.003+05:302020-11-19T21:04:47.431+05:30MONGODB INSTALLATION STEPS<p> MONGODB INSTALLATION STEPS :</p><p>1. Copy & paste mongodb-linux-i686-2.4.6.tgz and extract it in home folder and create one folder in mongodb-linux-i686-2.4.6 \bin folder (ex. snjb) >sudo mkdir /data</p><p>>sudo mkdir /data/db</p><p>>sudo chmod 777 /data/*</p><p>>cd ~/mongodb-linux-i686-2.4.6/bin >./mongod --dbpath snjb</p><p>right click and open new terminal and give following command >./mongo</p><p>installation complete.</p>Kishor M Sonawanehttp://www.blogger.com/profile/12171589855304919032noreply@blogger.com0tag:blogger.com,1999:blog-788103260560462553.post-30963341081770322412020-11-13T18:50:00.000+05:302020-11-13T18:50:23.680+05:30Difference between Intel Core i3, i5 and i7<div dir="ltr" style="text-align: left;" trbidi="on">
<div dir="ltr">
Difference between Intel Core i3, i5 and i7</div>
<div dir="ltr">
To conclude in a statement, Core i7s are better than Core i5s, and Core i5s are better than Core i3s. The main reason here being performance. In general, Core i3 chips are found in budget PCs and low-end laptops. For a normal user who does browsing and watching videos, Core i3 works just fine. Core i3s have a low Cache size.</div>
<div dir="ltr">
The mainstream or mid-range systems usually have i5. Systems with Core i5 are good for a moderate user and light gamer.</div>
<a name='more'></a><br />
<div dir="ltr">
The Core i7 CPUs are reserved for – and found usually in – high-end, expensive laptops and PCs. These are used by users who wish to do video editing( For example using premier pro), Lot of Gaming and other CPU intensive stuff.</div>
<div dir="ltr">
Number of cores: Core i3, i5 and i7</div>
<div dir="ltr">
The first thing you’ll notice from the table is that Core i5 and i7 processors have four cores, while Core i3 models only have two. Out of all the differences between the Intel processor ranges, this is the one that will affect performance the most.</div>
<div dir="ltr">
Each core is effectively its own processor – your PC would still work (slowly) with just one core enabled. Having multiple cores means that the computer can work on more than one task at a time more efficiently, which will help keep your system running snappily even if you have tasks, such as an antivirus scan, running in the background.</div>
<div dir="ltr">
Having several cores can also drastically increase the speed at which certain programs run. This doesn’t apply to all applications, as creating software that takes advantage of multiple cores is difficult. While two cores are now the accepted minimum in a processor, if you generally only tend to have a handful of tabs open in a web browser and your most demanding application is a word processor, you won’t see a huge benefit from a quad-core chip. However, modern games benefit from quad-core chips as does video encoding.</div>
<div dir="ltr">
Typically all the Core i3s comes with Hyper-Threading capabilities in them. Some versions of Core i5s have Hyper-Threading and Turbo boost features enabled.</div>
<div dir="ltr">
Coming to the big brother- i7, it has comes with anywhere from 2 to 8 cores with Hyper-Threading, Turbo boosting and Overclocking abilities.</div>
<div dir="ltr">
Core i7s are the best Intel has to offer for general consumers while Core i3s being the most affordable in the series ( forget Pentium).</div>
</div>
Kishor M Sonawanehttp://www.blogger.com/profile/12171589855304919032noreply@blogger.com0tag:blogger.com,1999:blog-788103260560462553.post-57484961961035224332020-05-13T16:57:00.002+05:302020-05-13T16:57:58.573+05:30Text Editor Python Using tkinterText Editor using python<br />
<br />
<br />
<br />
<br />
from tkinter import *<br />
from tkinter.filedialog import *<br />
from tkinter.messagebox import *<br />
from tkinter.font import Font<br />
from tkinter.scrolledtext import *<br />
import file_menu<br />
import edit_menu<br />
import format_menu<br />
import help_menu<br />
<br />
root = Tk()<br />
<br />
root.title("Text Editor-Untiltled")<br />
root.geometry("300x250+300+300")<br />
root.minsize(width=400, height=400)<br />
<br />
text = ScrolledText(root, state='normal', height=400, width=400, wrap='word', pady=2, padx=3, undo=True)<br />
text.pack(fill=Y, expand=1)<br />
text.focus_set()<br />
<br />
menubar = Menu(root)<br />
<br />
file_menu.main(root, text, menubar)<br />
edit_menu.main(root, text, menubar)<br />
format_menu.main(root, text, menubar)<br />
help_menu.main(root, text, menubar)<br />
root.mainloop()<br />
<br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiRhmIIlvSNsg9KzX8d7r8D6zwpgnm1oXjRbltfhyphenhyphenVErQgfHtGfgphgZfxkZ7f2yX6nK2JS1jpIVmzSBI_yC-c3Aw1MEbzQ_CqYGVLDS8BQFFYdrHVxJchtUZndMaA9wrCOS1rZbmJxrB8/s1600/Screenshot_20200513_165418.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="720" data-original-width="1440" height="160" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiRhmIIlvSNsg9KzX8d7r8D6zwpgnm1oXjRbltfhyphenhyphenVErQgfHtGfgphgZfxkZ7f2yX6nK2JS1jpIVmzSBI_yC-c3Aw1MEbzQ_CqYGVLDS8BQFFYdrHVxJchtUZndMaA9wrCOS1rZbmJxrB8/s320/Screenshot_20200513_165418.jpg" width="320" /></a></div>
<br />
<div>
<br /></div>
Kishor M Sonawanehttp://www.blogger.com/profile/12171589855304919032noreply@blogger.com1tag:blogger.com,1999:blog-788103260560462553.post-54274284919536255682020-05-13T16:51:00.000+05:302020-05-13T16:51:23.730+05:30Youtube video download using python<br />
Hi all,<br />
<br />
Code for Youtube video downloader using python.<br />
<br />
Program:<br />
<br />
#youtube<br />
import webbrowser<br />
print("Mac Plus Tech solution")<br />
print("-------------------------------------")<br />
url = input("ENTER YOUTUBE URL:")<br />
download=url[:12]+"ss"+url[12:]<br />
webbrowser.open_new(download)<br />
<br />
<br />
<br />Kishor M Sonawanehttp://www.blogger.com/profile/12171589855304919032noreply@blogger.com0tag:blogger.com,1999:blog-788103260560462553.post-58427793465930054432020-04-21T01:00:00.000+05:302020-04-21T00:43:10.756+05:30How to Compress 1GB files into 10MB<div dir="ltr" style="text-align: left;" trbidi="on">
<div data-iceapc="1" data-iceapw="46">
Managing space on your hard disk is
sometimes a tedious task. Many used to compress their files to save the
space. But they could only manage to save a bit . By following the
instructions of this article you can Compress 1GB files into 10mb archive.<span id="more-37"></span> </div>
<div data-iceapw="19">
<a href="http://www.factsnfakes.in/wp-content/uploads/2013/08/kgb.jpg" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img alt="kgb archiver" class="aligncenter size-full wp-image-144" height="206" src="http://www.factsnfakes.in/wp-content/uploads/2013/08/kgb.jpg" width="245" /></a>First of all you need to <span class="IL_AD" id="IL_AD1">download</span> a software called as KGB Archiver. You can download it by clicking here.</div>
<div data-iceapw="12">
After <span class="IL_AD" id="IL_AD2">downloading</span> and installing the software Follow the screenshots below to start archiving.</div>
<div data-iceapc="1" data-iceapw="9">
<strong data-iceapw="1">Step1:</strong> Start the KGB Archiver Program and click next.</div>
<div data-iceapc="1" data-iceapw="9">
<br /> </div>
<br />
<div data-iceapc="1" data-iceapw="10">
<br /></div>
<div data-iceapc="1" data-iceapw="10">
<br /></div>
<div data-iceapc="1" data-iceapw="10">
<br /></div>
<div data-iceapc="1" data-iceapw="10">
<br /></div>
<a name='more'></a><br />
<div data-iceapc="1" data-iceapw="10">
<br /></div>
<div data-iceapc="1" data-iceapw="10">
<strong data-iceapw="1">Step2:</strong> select and add the files you want to compress.</div>
<a href="http://www.factsnfakes.in/wp-content/uploads/2013/08/KGB-Archiver.png"><img alt="KGB Archiver" class="aligncenter size-full wp-image-981" height="426" src="http://www.factsnfakes.in/wp-content/uploads/2013/08/KGB-Archiver.png" width="496" /></a><br />
<div data-iceapc="1" data-iceapw="8">
<strong data-iceapw="3">Step 3 :</strong> Now select the compression level.</div>
<div data-iceapw="22">
The more the compression level is the lesser will be the size of the archive and higher the compression time will be.</div>
<a href="http://www.factsnfakes.in/wp-content/uploads/2013/08/KGB-Archiver-compression.png"><img alt="KGB Archiver compression" class="aligncenter size-full wp-image-982" height="426" src="http://www.factsnfakes.in/wp-content/uploads/2013/08/KGB-Archiver-compression.png" width="496" /></a><br />
<div data-iceapw="8">
Step 4: Just click next and start compressing.</div>
<div data-iceapw="20">
Please let us know if you’re having any problems with this <span class="IL_AD" id="IL_AD3">method</span> . If you like it then please share it.</div>
</div>
Kishor M Sonawanehttp://www.blogger.com/profile/12171589855304919032noreply@blogger.com0tag:blogger.com,1999:blog-788103260560462553.post-29510154346250859412020-04-20T22:53:00.001+05:302020-04-20T22:53:54.348+05:30MS SQL Server Space / Memory Manegment<br />
Execute This<br />
<br />
<br />
SELECT SUM(unallocated_extent_page_count) AS [free_pages]<br />
<br />
,(SUM(unallocated_extent_page_count) * 1.0 / 128) AS [free_space_MB]<br />
<br />
,SUM(version_store_reserved_page_count) AS [version_pages_used]<br />
<br />
,(SUM(version_store_reserved_page_count) * 1.0 / 128) AS [version_space_MB]<br />
<br />
,SUM(internal_object_reserved_page_count) AS [internal_object_pages_used]<br />
<br />
,(SUM(internal_object_reserved_page_count) * 1.0 / 128) AS [internal_object_space_MB]<br />
<br />
,SUM(user_object_reserved_page_count) AS [user object pages used]<br />
<br />
,(SUM(user_object_reserved_page_count) * 1.0 / 128) AS [user_object_space_MB]<br />
<br />
FROM sys.dm_db_file_space_usage;<br />
<br />
GO<br />
<br />Kishor M Sonawanehttp://www.blogger.com/profile/12171589855304919032noreply@blogger.com0tag:blogger.com,1999:blog-788103260560462553.post-28852061253657659692020-04-20T22:49:00.001+05:302020-04-20T22:49:13.562+05:30Activate curl Wamp : windowsThe steps are as follows :<br />
<br />
<br />
<ol>
<li>Close WAMP (if running)</li>
<li>Navigate to <b>WAMP\bin\php\(your version of php)\</b></li>
<li>Edit<b> php.ini</b></li>
<li>Search for curl,<b> uncomment extension=php_curl.dll</b></li>
<li>Navigate to WAMP\bin\Apache\(your version of apache)\bin\</li>
<li>Edit <b>php.ini</b></li>
<li>Search for curl, <b>uncomment extension=php_curl.dll</b></li>
<li>Save both</li>
<li>Restart WAMP</li>
</ol>
Kishor M Sonawanehttp://www.blogger.com/profile/12171589855304919032noreply@blogger.com0tag:blogger.com,1999:blog-788103260560462553.post-83899051825970973782020-04-20T22:45:00.000+05:302020-04-20T22:47:37.896+05:30open Rar File Ubuntu<div class="post-text" itemprop="text">
<br />
<br />
<br />
First i need to run :<br />
<br />
<span style="color: blue;"><code>sudo apt-get install unrar</code> </span><br />
for install unrar.<br />
<br />
<br />
If i want to unpack all files within the .rar files in the same directory<br />
<code>unrar e -r /home/work/software/myfile.rar</code><br />
<br />
<br />
<br />
if You want to unpack the files in full path<br />
<code>unrar x -r /home/work/software/myfile.rar</code></div>
Kishor M Sonawanehttp://www.blogger.com/profile/12171589855304919032noreply@blogger.com0tag:blogger.com,1999:blog-788103260560462553.post-16070789410736602902020-04-20T21:37:00.000+05:302020-04-20T22:45:12.722+05:30tracert cmd Command for Trace Root<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<b><span style="font-size: large;">tracert cmd Command for Trace Root</span></b><br />
<br />
syntax<br />
<br />
>tracert google.com<br />
<br />
<br />
-------------------------------------------------------<br />
<br />
all over Word<b> cable map</b><br />
<span style="background-color: white; color: #111111; font-family: "roboto" , "arial" , sans-serif; font-size: 14px; white-space: pre-wrap;">Cables Map: </span><a class="yt-simple-endpoint style-scope yt-formatted-string" href="https://www.youtube.com/redirect?q=https%3A%2F%2Fwww.submarinecablemap.com&event=video_description&v=6epiGBMXBDs&redir_token=0TrX_kt4T0CWC5TN5GLRHbA3b9t8MTUwODM0NzMyNUAxNTA4MjYwOTI1" style="background-color: white; cursor: pointer; display: inline-block; font-family: Roboto, Arial, sans-serif; font-size: 14px; text-decoration-line: none; white-space: pre-wrap;">https://www.submarinecablemap.com</a><br />
<br />
<span style="background-color: white;">speed all over word pont</span><br />
<span style="background-color: white;">Speed Meter: </span><a class="yt-simple-endpoint style-scope yt-formatted-string" href="https://www.youtube.com/redirect?q=http%3A%2F%2Fwww.nixi.in%2Fen%2Fmrtg-statistics&event=video_description&v=6epiGBMXBDs&redir_token=0TrX_kt4T0CWC5TN5GLRHbA3b9t8MTUwODM0NzMyNUAxNTA4MjYwOTI1" style="background-color: white; cursor: pointer; display: inline-block; font-family: Roboto, Arial, sans-serif; font-size: 14px; text-decoration-line: none; white-space: pre-wrap;">http://www.nixi.in/en/mrtg-statistics</a><br />
--------------------------------------------------------------<br />
<br />
oky<br />
<br />
-Kishor </div>
Kishor M Sonawanehttp://www.blogger.com/profile/12171589855304919032noreply@blogger.com1tag:blogger.com,1999:blog-788103260560462553.post-13713490491418556362020-04-20T21:33:00.000+05:302020-04-20T22:50:35.534+05:30Bluetooth + Arduino Connectivity <div dir="ltr" style="text-align: left;" trbidi="on">
/*<br />
* The program for ON/ Off LED Using Bluetooth<br />
* MAC+tech Development<br />
* http://macplustechnology.blogspot.in/<br />
* Email: macplustech@gmail.com<br />
* <br />
*/<br />
char data = 0; //Variable for storing Bluetooth incoming data<br />
void setup()<br />
{<br />
Serial.begin(9600); <br />
pinMode(13, OUTPUT); //output pin (+5V) other connect (GND)<br />
}<br />
void loop()<br />
{<br />
if(Serial.available() > 0) // resive data<br />
{<br />
data = Serial.read(); //Read the incoming data<br />
Serial.print(data); //Print ValueSerial monitor<br />
Serial.print("\n MAC+tech"); <br />
if(data == '1') //Checks whether value of data is equal to 1<br />
digitalWrite(13, HIGH); //If value is 1 then LED turns ON<br />
else if(data == '0') //Checks whether value of data is equal to 0<br />
digitalWrite(13, LOW); //If value is 0 then LED turns OFF<br />
} <br />
<br />
} <br />
<br />
<br />
load to Arduino And Send data though Android App. where make simple android app. to send data though Bluetooth .....<br />
<br /></div>
Kishor M Sonawanehttp://www.blogger.com/profile/12171589855304919032noreply@blogger.com0tag:blogger.com,1999:blog-788103260560462553.post-12139866600429918502020-04-20T17:04:00.000+05:302020-04-20T22:43:43.559+05:30On off Light Using MObile And ArduinoSteps :<br />
<br />
1 . go to <a href="http://ai2.appinventor.mit.edu/">http://ai2.appinventor.mit.edu </a><br />
and open Account <br />
2 Download Android App Source Code from My Drive <a href="https://drive.google.com/open?id=1GS3NbGwm0DaKM89chzyWDuAxkW35xR75">https://drive.google.com/open?id=1GS3NbGwm0DaKM89chzyWDuAxkW35xR75</a><br />
<br />
Or Directly <a href="https://drive.google.com/open?id=1gOX-pfHDy5Gf1f5ffu5pa3ttj__rJ3Cz">Download </a>APK File from <a href="https://drive.google.com/open?id=1gOX-pfHDy5Gf1f5ffu5pa3ttj__rJ3Cz">here.. </a> <br />
3 import this code to <a href="http://ai2.appinventor.mit.edu/">http://ai2.appinventor.mit.edu</a><br />
and Build App Download it Using QR Code Directly Your Android Mobile<br />
<br />
<br />
<br />
Step to run :<br />
1 . Connect LED, BT HC-05 To Arduino Upload bellow Program on it (* <span style="color: red;">IMP NODE : During Upload Arduino Remove Bluetooth HC-05</span> )<br />
2. Using in mobile pair with Bt Devices HC-05 (Default password 1234)<br />
3. Open App select Device from list connect it<br />
4. on/ off light <br />
<br />
<br />
<br />
<br />
Write CODE on Arduino AND Config Pin...<br />
<br />
<br />
CODE:<br />
<pre><span style="color: #95a5a6;">/* </span>
<span style="color: #95a5a6;"> * </span>
<span style="color: #95a5a6;"> * Coder - Kishor M Sonawane</span>
<span style="color: #95a5a6;"></span>
<span style="color: #95a5a6;"></span>
<span style="color: #95a5a6;"></span>
<span style="color: #95a5a6;"></span>
<span style="color: #95a5a6;">Bluetooth connection:-</span>
<span style="color: #95a5a6;">Arduino Pins Bluetooth Pins</span>
<span style="color: #95a5a6;">RX (Pin 0) ———-> TX</span>
<span style="color: #95a5a6;">TX (Pin 1) ———-> RX</span>
<span style="color: #95a5a6;">5V ———-> VCC</span>
<span style="color: #95a5a6;">GND ———-> GND</span>
<span style="color: #95a5a6;"></span>
<span style="color: #95a5a6;"></span>
<span style="color: #95a5a6;"> */</span>
<span style="color: #00979c;">char</span> <span style="color: black;">data</span> <span style="color: #434f54;">=</span> <span style="color: black;">0</span><span style="color: black;">;</span> <span style="color: #434f54;">//Variable for storing received data</span>
<span style="color: #00979c;">void</span> <span style="color: #5e6d03;">setup</span><span style="color: black;">(</span><span style="color: black;">)</span>
<span style="color: black;">{</span>
<b><span style="color: #d35400;">Serial</span></b><span style="color: #434f54;">.</span><span style="color: #d35400;">begin</span><span style="color: black;">(</span><span style="color: black;">9600</span><span style="color: black;">)</span><span style="color: black;">;</span>
<span style="color: #d35400;">pinMode</span><span style="color: black;">(</span><span style="color: black;">13</span><span style="color: #434f54;">,</span> <span style="color: #00979c;">OUTPUT</span><span style="color: black;">)</span><span style="color: black;">;</span> <span style="color: #434f54;">//Sets digital pin 13 as output pin</span>
<span style="color: black;">}</span>
<span style="color: #00979c;">void</span> <span style="color: #5e6d03;">loop</span><span style="color: black;">(</span><span style="color: black;">)</span>
<span style="color: black;">{</span>
<span style="color: #5e6d03;">if</span><span style="color: black;">(</span><b><span style="color: #d35400;">Serial</span></b><span style="color: #434f54;">.</span><span style="color: #d35400;">available</span><span style="color: black;">(</span><span style="color: black;">)</span> <span style="color: #434f54;">></span> <span style="color: black;">0</span><span style="color: black;">)</span> <span style="color: #434f54;">/</span>
<span style="color: black;">{</span>
<span style="color: black;">data</span> <span style="color: #434f54;">=</span> <b><span style="color: #d35400;">Serial</span></b><span style="color: #434f54;">.</span><span style="color: #d35400;">read</span><span style="color: black;">(</span><span style="color: black;">)</span><span style="color: black;">;</span> <span style="color: #434f54;">//Read the incoming data and store on variable >> data</span>
<b><span style="color: #d35400;">Serial</span></b><span style="color: #434f54;">.</span><span style="color: #d35400;">print</span><span style="color: black;">(</span><span style="color: black;">data</span><span style="color: black;">)</span><span style="color: black;">;</span>
<b><span style="color: #d35400;">Serial</span></b><span style="color: #434f54;">.</span><span style="color: #d35400;">print</span><span style="color: black;">(</span><span style="color: #005c5f;">"\n"</span><span style="color: black;">)</span><span style="color: black;">;</span>
<span style="color: #5e6d03;">if</span><span style="color: black;">(</span><span style="color: black;">data</span> <span style="color: #434f54;">==</span> <span style="color: #00979c;">'1'</span><span style="color: black;">)</span> <span style="color: #434f54;">//Checks whether value of data is equal to 1 </span>
<span style="color: #d35400;">digitalWrite</span><span style="color: black;">(</span><span style="color: black;">13</span><span style="color: #434f54;">,</span> <span style="color: #00979c;">HIGH</span><span style="color: black;">)</span><span style="color: black;">;</span> <span style="color: #434f54;">//If value is 1 then LED turns ON</span>
<span style="color: #5e6d03;">else</span> <span style="color: #5e6d03;">if</span><span style="color: black;">(</span><span style="color: black;">data</span> <span style="color: #434f54;">==</span> <span style="color: #00979c;">'0'</span><span style="color: black;">)</span>
<span style="color: #d35400;">digitalWrite</span><span style="color: black;">(</span><span style="color: black;">13</span><span style="color: #434f54;">,</span> <span style="color: #00979c;">LOW</span><span style="color: black;">)</span><span style="color: black;">;</span> <span style="color: #434f54;">//If value is 0 then LED turns OFF</span>
<span style="color: black;">}</span>
<span style="color: black;">}</span>
</pre>
<br />
<br />
<br />Kishor M Sonawanehttp://www.blogger.com/profile/12171589855304919032noreply@blogger.com1tag:blogger.com,1999:blog-788103260560462553.post-42163106468658021512018-11-01T23:51:00.001+05:302018-11-01T23:51:00.566+05:30Shakti processor |Shakti Processor Program | indias first processor
<p dir="ltr">General purpose on-chip processors have become ubiquitous today. These processors range from extremely small and low power micro-controllers (used in motor controls, robotic platforms, home-appliances, etc.) to hefty and high-performance multi-core processors (used in servers and supercomputers). However, the growth of modern domain-specific languages (like Caffe, Tensorflow, etc.) and the need for more specialized features like machine-learning, enhanced security, etc. has forced the industry to look beyond general purpose solutions and towards mass-customization. While a large number of companies today can develop custom ASICs (Application Specific Integrated Chips) and license specific silicon blocks from chip-vendors to develop a customized SoCs (System on Chips), at the heart of every design is the processor and the associated hardware. To serve modern workloads better, these processors also need to be customized, upgraded, re-designed and augmented suitably. This requires that vendors/consumers have access to relevant processor variants and the flexibility to make modifications and ship them at an endurable cost. </p>
<p dir="ltr">Today, a fair share of the processor market is dominated by just a few giants like Intel, ARM, AMD, etc. Each of these companies have an impressive IP portfolio of processors catering to various market trends. Almost all of the IP offerings of these companies fall under a licensing model which varies significantly. For example, Intel licenses its ISA only to limited users like AMD. ARM on the other hand offers a broad of range of licenses from ISA to architectural licenses. Apart from just license fees, these companies also charge royalties on devices using their IPs. Having sustained a successful IP model, today some of these licenses can go up to 1-10\$ Million in addition to strict NDAs which may restrict the user from making any proprietary changes or even publishing relevant numbers. All these aspects of the licensing model, while benefiting the respective companies, has made is difficult for consumers to develop truly customized solutions for modern day workloads. Some of these customizations cater to too low a market sector for the giants themselves to invest in, thereby prohibiting growth and novelty. </p>
<p dir="ltr">In essence, the closed-source IP model in the processor community is proving to be a hindrance to build scalable solutions. A similar struggle in the software industry against closed-source IP led to the rise of the open-source Linux kernel in the 1990s. Since then the software community has seen a plethora of open-source software and tool-chains which have been adopted by industry and academia both. The hardware community however, hasn't seen such a revolution yet and is probably in dire need of the same. An open-source processor ecosystem will not only boost customization but also allow bright minds of the industry and academia to collaborate and provide a stable and viable framework competent enough with modern-day products. SHAKTI, an open-source initiative by IIT-Madras (Indian Institute of Technology Madras) is primarily aimed at building such open-source processor development ecosystems which can equip the community with enough ammunition to build custom and industrial grade processors without the hassle of licensing, NDAs, royalties or any other sort of restrictions. <br></p>
<div align="center"><p dir="ltr"><span style="font-size:1.40em;"><b>The SHAKTI Program</b></span><br>
</p>
</div><p dir="ltr"><br>
The SHAKTI Processor Program, was started as an academic initiative back in 2014 by the <a href="http://rise.cse.iitm.ac.in/rise1/index.html">RISE group</a> at <a href="https://www.iitm.ac.in/">IIT-Madras</a>. Realizing the limitations of the processor industry mentioned above, the initiative aimed at not only creating open-source industrial grade processors but also building associated components of a bigger ecosystem - like interconnect fabrics, scalable verification platforms, peripheral IPs, etc. - which enables rapid adoption of the processors. Some of the major highlights of the program which make it a viable option for adoption are:</p>
<p dir="ltr">Source code of all the components of the SHAKTI ecosystem are open under the 3 part BSD license. This means a user could freely use, modify and circulate the source code without having to sign any NDAs, licenses or even notify the authors as long as the license header file remains. The SHAKTI program itself will not assert any patents and thereby removes the burden of paying royalties as well.<br>
</p>
<p dir="ltr"></p>
<p dir="ltr">The processors of the SHAKTI ecosystem are build using the open-source <a href="https://www.riscv.org/">RISC-V</a> ISA. RISC-V has been designed for modularity and extensions, thereby perfectly fitting the prologue of "customization". The ISA also comes with a complete software stack, including compilers, operating systems, and debuggers, which are open source and thus also modifiable. Since the ISA does not dictate micro-architectural features, the software and hardware can be maintained by two complete different entities and yet be compatible. This allows for great re-usability and sharing of code-base across the community.<br>
</p>
<p dir="ltr"></p>
<p dir="ltr">The SHAKTI processors and the front-end (RTL) designs are developed using the open-source High Level Synthesis (HLS) language:<a href="https://www.bluespec.com/">Bluespec System Verilog (BSV)</a>. BSV equips the user to develop extremely modular and parameterized modules with defined interfaces. This feature facilitates the user to focus and modify only the designs of interest without having to break the rest of the flow. Today there exists a free <a href="https://github.com/rsnikhil/goParseBSV">bsv-parser</a> which the community can use to develop open/proprietary compilers for BSV.<br>
</p>
<p dir="ltr"></p>
<p dir="ltr">Academia now has access to a real world working prototypes of processors which they can play with for free. This enables them to depart from the world of "simulators" and "emulation models" and try out their research and ideas in practice. They are no longer tied down by strict NDAs on publishing and can thereby participate more actively in shaping the future of the processor industry.<br>
</p>
<p dir="ltr"></p>
<p dir="ltr">A typical process of acquiring ISA or architectural licenses from companies like ARM can vary anywhere between 6-12 months. This increases the time-to market for the consumers. SHAKTI, can immensely reduce this time by avoiding such formalities and providing a powerful modular framework allowing small tech start-ups to only modify components of interest rather than building a solution from scratch.<br>
</p>
<p dir="ltr"></p>
<p dir="ltr">With minds from all over the community pouring in ideas and solutions, SHAKTI has the potential to become a state-of-the-art offering quickly<br>
</p>
<p dir="ltr"></p>
<p dir="ltr">An open-source ecosystem such as SHAKTI promotes a mix-and-match environment where users can plug-in different open-source or proprietary IPs and innovate on new ideas and projects.<br>
</p>
<p dir="ltr"></p>
<p dir="ltr">Being completely open-source, it is close-to-impossible for external entities to add back-doors and black-boxes. This is of particular interest to strategic sectors of a countries like India, which today depend on black-box solutions provided by industries which are headquartered in foreign countries.<br>
</p>
<p dir="ltr"></p>
<p dir="ltr">SHAKTI can also enable the software community drastically. Fearing strong patent lawsuits, software developers who own licensed HW IPs for development are forced to release only binaries rather source code and also provide minimal documentation. This leaves the software Libre community in dangling state, spending months and even years \emph{"picking up pieces"}.<br>
</p>
<p dir="ltr"></p>
<p dir="ltr">In addition to the above arguments, a combination of the open-source processor ecosystems such as SHAKTI and a fabrication entity like TSMC, which is offering upto 100 small tests chips on its latest technology node for only 30,000\$, can virtually enable any project with real-chips for their final validation at drastically low costs and time.</p><p dir="ltr"><br></p><p dir="ltr"><br></p><div class="col-md-12" style="box-sizing: border-box; position: relative; width: 360px; min-height: 1px; padding-right: 15px; padding-left: 15px; color: rgb(64, 65, 66); font-family: Dosis, sans-serif; font-size: 16px; letter-spacing: 0.8px; text-align: center; background-color: rgb(255, 255, 255);"><h2 class="row-title" style="box-sizing: border-box; margin-top: 0px; margin-bottom: 0.5rem; font-family: inherit; font-weight: 400; line-height: 1.2; color: inherit; font-size: 2rem;">Architectural Features</h2><div><br></div><div><br></div><div><br></div></div><div class="col-md-6 feature feature-half" style="box-sizing: border-box; position: relative; width: 360px; min-height: 1px; padding: 20px; margin-top: 30px; transition: all 0.3s ease 0s; border: 3px solid rgb(246, 246, 246); border-radius: 5px; color: rgb(64, 65, 66); font-family: Dosis, sans-serif; font-size: 16px; letter-spacing: 0.8px; text-align: center; background-color: rgb(255, 255, 255);"><h3 style="box-sizing: border-box; margin-top: 0px; margin-bottom: 0.5rem; font-family: inherit; font-weight: 200; line-height: 1.2; color: inherit; font-size: 1.75rem;">Overview</h3><ul class="proc3" style="box-sizing: border-box; margin: 0px; padding: 0px; list-style: square inside; text-align: left; min-height: 17.5rem;"><li style="box-sizing: border-box;">In-order 3 stage 32/64 bit microcontroller supporting a subset of RISC-V ISA.</li><li style="box-sizing: border-box;">Low area and power consumption - operational frequency of < 200MHz on silicon.</li><li style="box-sizing: border-box;">Optimized variants for FPGA based soft-cores.</li><li style="box-sizing: border-box;">AXI4/AXI4-Lite/TileLink peripherals supported</li><li style="box-sizing: border-box;">Positioned against ARM’s M class cores</li></ul></div><div class="col-md-6 feature feature-half" style="box-sizing: border-box; position: relative; width: 360px; min-height: 1px; padding: 20px; margin-top: 30px; transition: all 0.3s ease 0s; border: 3px solid rgb(246, 246, 246); border-radius: 5px; box-shadow: rgb(204, 204, 204) 3px 3px 10px; transform: translateY(-10px); color: rgb(64, 65, 66); font-family: Dosis, sans-serif; font-size: 16px; letter-spacing: 0.8px; text-align: center; background-color: rgb(255, 255, 255);"><h3 style="box-sizing: border-box; margin-top: 0px; margin-bottom: 0.5rem; font-family: inherit; font-weight: 200; line-height: 1.2; color: inherit; font-size: 1.75rem;">Basic Specifications</h3><ul class="proc3" style="box-sizing: border-box; margin: 0px; padding: 0px; list-style: square inside; text-align: left; min-height: 17.5rem;"><li style="box-sizing: border-box;">Open source IP supporting RV32/64 - IMAC.</li><li style="box-sizing: border-box;">Optional Direct-mapped caches for instruction and data.</li><li style="box-sizing: border-box;">Supports Machine and User-modes only.</li><li style="box-sizing: border-box;">User-mode trap handling is optional.</li><li style="box-sizing: border-box;">Push button flow to generate variants and subsets of ISA.</li><li style="box-sizing: border-box;">Optimized sequential Multiplier and Divider for ASICs and FPGAs</li><li style="box-sizing: border-box;">OpenOCD based SoC debug support through JTAG.</li><li style="box-sizing: border-box;">OS Ports: FreeRTOS, Zephyr</li></ul></div><p dir="ltr">Source code</p><p dir="ltr">https://gitlab.com/shaktiproject/cores/e-class<br></p><p dir="ltr"><br></p>
Kishor M Sonawanehttp://www.blogger.com/profile/12171589855304919032noreply@blogger.com3tag:blogger.com,1999:blog-788103260560462553.post-25217043631544426902018-09-29T12:01:00.001+05:302018-09-29T13:25:00.309+05:301st Seleniumpackage snjb1;<br />
<br />
import java.util.HashMap;<br />
import java.util.concurrent.TimeUnit;<br />
<br />
import org.openqa.selenium.WebDriver;<br />
import org.openqa.selenium.chrome.ChromeDriver;<br />
import org.openqa.selenium.chrome.ChromeOptions;<br />
<br />
import com.gargoylesoftware.htmlunit.javascript.host.Map;<br />
<br />
public class Mac {<br />
<span style="white-space: pre;"> </span><br />
<span style="white-space: pre;"> </span>WebDriver driver;<br />
<span style="white-space: pre;"> </span><br />
<span style="white-space: pre;"> </span>public Mac()<br />
<span style="white-space: pre;"> </span>{<br />
<br />
<span style="white-space: pre;"> </span>//Map<String, Object> prefs = new HashMap<String, Object>();<br />
<br />
// Set the notification setting it will override the default setting<br />
//prefs.put("profile.default_content_setting_values.notifications", 2);<br />
<br />
// Create object of ChromeOption class<br />
ChromeOptions options = new ChromeOptions();<br />
<br />
// Set the experimental option<br />
//options.setExperimentalOption("prefs", prefs);<br />
<br />
<span style="white-space: pre;"> </span>System.setProperty("webdriver.chrome.driver", "D:\\java toolssss\\chromedriver.exe");<br />
<span style="white-space: pre;"> </span>driver = new ChromeDriver();<br />
<span style="white-space: pre;"> </span>//driver=new FirefoxDriver();<br />
<span style="white-space: pre;"> </span>driver.manage().timeouts().implicitlyWait(120, TimeUnit.SECONDS);<br />
<br />
<span style="white-space: pre;"> </span>//"https://www.shiksha.com/tags/symbiosis-institute-of-telecom-management-sitm-tdp-198268"<br />
<span style="white-space: pre;"> </span><br />
<span style="white-space: pre;"> </span><br />
<span style="white-space: pre;"> </span>driver.get("http://facebook.com/");<br />
<span style="white-space: pre;"> </span>//<span style="white-space: pre;"> </span>driver.manage().window().maximize();<br />
<span style="white-space: pre;"> </span><br />
<span style="white-space: pre;"> </span><br />
<span style="white-space: pre;"> </span><br />
<span style="white-space: pre;"> </span>}<br />
<br />
<span style="white-space: pre;"> </span>public static void main(String[] args) {<br />
<span style="white-space: pre;"> </span>// TODO Auto-generated method stub<br />
new Mac();<br />
<span style="white-space: pre;"> </span>}<br />
<br />
}<br />
<br />
<br />
<br />
<br />
<br />
<br />
Crome Driver :<br />
<a href="https://drive.google.com/open?id=1yM9JjspZPKbzsehTjxs06hX84I6kTU9X">https://drive.google.com/open?id=1yM9JjspZPKbzsehTjxs06hX84I6kTU9X</a><br />
<div>
<br /></div>
Kishor M Sonawanehttp://www.blogger.com/profile/12171589855304919032noreply@blogger.com1tag:blogger.com,1999:blog-788103260560462553.post-32599163276749541932018-06-27T23:11:00.005+05:302018-06-27T23:15:40.521+05:30flash One way to do this is add an onclick method to your form to initiate the javascript containing the alert.
<script type="javascript">
function showMessage() {
alert ("Form submitted");
return true;
}
</script>
<br />
<form onclick="return showMessage()">
<input id="add" name="add" type="submit" value="ADD" /> </form>
Kishor M Sonawanehttp://www.blogger.com/profile/12171589855304919032noreply@blogger.com1tag:blogger.com,1999:blog-788103260560462553.post-16772806766572015452018-06-27T20:47:00.000+05:302018-06-27T21:36:36.792+05:30Mouse Over To select radio button or same likeHi fried's normally what happens there some time we create forms for cust. cust required fast fill form fast so only mouse over to select an option.
Code using JavaScript
------------------------------------------<br />
<br />
<br />
<span id="radio-buttons"><input checked="check" class="tryout" name="example" type="radio" />select
<input class="tryout" name="example" type="radio" />MAC
<input class="tryout" name="example" type="radio" />Plus
<input class="tryout" name="example" type="radio" />tech </span><br />
<br />
<br />
<span id="radio-buttons">code >></span><br />
<br />
<br />
<span id="radio-buttons"><span style="color: blue;"><span id="radio-buttons"><br /> <input checked="check" class="tryout" name="example" type="radio" /><br /> </span></span><span id="radio-buttons"><span style="color: blue;"><span id="radio-buttons">select
</span> <input class="tryout" name="example" type="radio" /></span></span><br />
<span id="radio-buttons"><span style="color: blue;"> MAC <input class="tryout" name="example" type="radio" />Plus<br /> <input class="tryout" name="example" type="radio" />tech<br /></span><br /><script><br />document.getElementById("radio-buttons").onmouseover = function (e) {<br /> e.target.checked = true;<br />}<br /></script></span> </span><br />
<br />
<br />
<span id="radio-buttons"> </span>
<script>
document.getElementById("radio-buttons").onmouseover = function (e) {
e.target.checked = true;
}
</script>
- Kishor M SonawaneKishor M Sonawanehttp://www.blogger.com/profile/12171589855304919032noreply@blogger.com1tag:blogger.com,1999:blog-788103260560462553.post-22434771762424178702018-06-21T20:58:00.000+05:302018-06-21T20:58:23.140+05:30Pen-drive or Any Drive Virus Remove Using MAC+ tech tool <div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<h3 style="text-align: left;">
Pen-drive or Any Drive Virus Remove Using MAC+ tech tool </h3>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgmsDe4MjRKuAMDqiM2-g0mkefoCglLFW8Q_5nHwx-XLViS4pOoA3wQGK-us8wlrL6ASlKr7FYsTzdXijzChOXT98ORqf4LfX30iNz4X8j6_iahCG6N2q34ntjUp1d9f3WE7Iv6zUYYoo4/s1600/images.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="177" data-original-width="284" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgmsDe4MjRKuAMDqiM2-g0mkefoCglLFW8Q_5nHwx-XLViS4pOoA3wQGK-us8wlrL6ASlKr7FYsTzdXijzChOXT98ORqf4LfX30iNz4X8j6_iahCG6N2q34ntjUp1d9f3WE7Iv6zUYYoo4/s1600/images.jpg" /></a></div>
<br />
<span style="font-size: large;">MAC+tech Create Small Product For Remove Pen drive Viruses And Worms as well as Drive Viruses / Solve Auto Hidden Files Problem Follow Following steps ...</span><br />
<span style="font-size: large;"><br /></span>
<span style="font-size: large;"><span style="background-color: red;"><a href="https://drive.google.com/open?id=1lf9nR4nTo-Qh73N8J9Qbkk8_GcY7CZsV">DOWNLOAD</a></span></span>
<span style="font-size: large;">-------------------------------------------------------------------------</span><br />
<span style="font-size: large;"><b>Step 1 >> </b>Download the file <span style="background-color: red;"><a href="https://drive.google.com/open?id=1lf9nR4nTo-Qh73N8J9Qbkk8_GcY7CZsV" target="_blank">Click Here.... </a></span><a href="https://drive.google.com/open?id=1lf9nR4nTo-Qh73N8J9Qbkk8_GcY7CZsV">https://drive.google.com/open?id=1lf9nR4nTo-Qh73N8J9Qbkk8_GcY7CZsV</a></span><br />
<span style="font-size: large;"> (h</span><span style="font-size: large;">ere open Drive and Download Option Available)</span><br />
<span style="font-size: large;"><br /></span>
<span style="font-size: large;"><b>Step 2>></b> </span><span style="font-size: large;"> Downloaded file (.zip ) Extract and Save On your Computer </span><br />
<span style="font-size: large;">-----------------------------------------------------------------------</span><br />
<span style="font-size: large;"> <span style="color: #990000;">how to use ??</span></span><br />
<span style="font-size: large;"><br /></span>
<span style="font-size: large;"> just copy <b>MAC+tech.exe (tool) </b>Paste on Affected Drive And Run it (Double Click).</span><br />
<span style="font-size: large;"><br /></span>
<span style="font-size: large;">*<span style="color: red;">Note: Tool Copy On Affected Drive then Run tool... </span></span><br />
<br />
<span style="font-size: large;">*Software is Command line Based GUI Based Software Come Within some Day's......</span><br />
<span style="font-size: large;"><br /></span>
<span style="font-size: large;"><br /></span>
<span style="font-size: large;"><span style="color: #cc0000;"> thank You For Using MAC+tech Services </span></span><br />
<span style="font-size: large;"><span style="color: #cc0000;"><br /></span></span>
<span style="font-size: large;">-Kishor M Sonawane</span><br />
<br />
<br /></div>
Kishor M Sonawanehttp://www.blogger.com/profile/12171589855304919032noreply@blogger.com1tag:blogger.com,1999:blog-788103260560462553.post-7951020520358637702018-06-20T14:05:00.002+05:302018-06-20T14:26:00.682+05:30Arduino Remote LightProgram Def: Create program glow light using wireless media .<br />
Reuredment:<br />
two CKT
two Arduino<br />
one connected LED<br />
another Connected Button<br />
Each Arduino Connecrted Bluetooth HC-05
SETUP<br />
<br />
One as Master Another As Slave :
<b> </b><br />
<br />
<b>Load This Program For Config Bluetooth </b><br />
<b>// note : pin cong: </b><br />
<b> BT Arduino</b><br />
Tx 10<br />
RX 11<b><br /></b><br />
<b> </b>VCC 5v<br />
Gnd Gnd<b><br /></b><br />
EN 3.3v or pin 9 (for program)<br />
<br />
<pre><span style="color: #5e6d03;">#include</span> <span style="color: #434f54;"><</span><b><span style="color: #d35400;">SoftwareSerial</span></b><span style="color: #434f54;">.</span><span style="color: black;">h</span><span style="color: #434f54;">></span>
<b><span style="color: #d35400;">SoftwareSerial</span></b> <span style="color: black;">BTSerial</span><span style="color: black;">(</span><span style="color: black;">10</span><span style="color: #434f54;">,</span> <span style="color: black;">11</span><span style="color: black;">)</span><span style="color: black;">;</span> <span style="color: #434f54;">// RX | TX</span>
<span style="color: #00979c;">void</span> <span style="color: #5e6d03;">setup</span><span style="color: black;">(</span><span style="color: black;">)</span>
<span style="color: black;">{</span>
<span style="color: #d35400;">pinMode</span><span style="color: black;">(</span><span style="color: black;">9</span><span style="color: #434f54;">,</span> <span style="color: #00979c;">OUTPUT</span><span style="color: black;">)</span><span style="color: black;">;</span> <span style="color: #434f54;">// this pin will pull the HC-05 pin 34 (key pin) HIGH to switch module to AT mode</span>
<span style="color: #d35400;">digitalWrite</span><span style="color: black;">(</span><span style="color: black;">9</span><span style="color: #434f54;">,</span> <span style="color: #00979c;">HIGH</span><span style="color: black;">)</span><span style="color: black;">;</span>
<b><span style="color: #d35400;">Serial</span></b><span style="color: #434f54;">.</span><span style="color: #d35400;">begin</span><span style="color: black;">(</span><span style="color: black;">9600</span><span style="color: black;">)</span><span style="color: black;">;</span>
<b><span style="color: #d35400;">Serial</span></b><span style="color: #434f54;">.</span><span style="color: #d35400;">println</span><span style="color: black;">(</span><span style="color: #005c5f;">"Enter AT commands:"</span><span style="color: black;">)</span><span style="color: black;">;</span>
<span style="color: black;">BTSerial</span><span style="color: #434f54;">.</span><span style="color: #d35400;">begin</span><span style="color: black;">(</span><span style="color: black;">38400</span><span style="color: black;">)</span><span style="color: black;">;</span> <span style="color: #434f54;">// HC-05 default speed in AT command more</span>
<span style="color: black;">}</span>
<span style="color: #00979c;">void</span> <span style="color: #5e6d03;">loop</span><span style="color: black;">(</span><span style="color: black;">)</span>
<span style="color: black;">{</span>
<span style="color: #434f54;">// Serial.println("in LOop");</span>
<span style="color: #434f54;">// Keep reading from HC-05 and send to Arduino Serial Monitor</span>
<span style="color: #5e6d03;">if</span> <span style="color: black;">(</span><span style="color: black;">BTSerial</span><span style="color: #434f54;">.</span><span style="color: #d35400;">available</span><span style="color: black;">(</span><span style="color: black;">)</span><span style="color: black;">)</span>
<span style="color: black;">{</span>
<b><span style="color: #d35400;">Serial</span></b><span style="color: #434f54;">.</span><span style="color: #d35400;">write</span><span style="color: black;">(</span><span style="color: black;">BTSerial</span><span style="color: #434f54;">.</span><span style="color: #d35400;">read</span><span style="color: black;">(</span><span style="color: black;">)</span><span style="color: black;">)</span><span style="color: black;">;</span>
<span style="color: #434f54;">// Serial.println(BTSerial.read());</span>
<span style="color: #434f54;">// Serial.println("in avl...");</span>
<span style="color: #434f54;">//delay(1000);</span>
<span style="color: black;">}</span>
<span style="color: #434f54;">// Keep reading from Arduino Serial Monitor and send to HC-05</span>
<span style="color: #5e6d03;">if</span> <span style="color: black;">(</span><b><span style="color: #d35400;">Serial</span></b><span style="color: #434f54;">.</span><span style="color: #d35400;">available</span><span style="color: black;">(</span><span style="color: black;">)</span><span style="color: black;">)</span>
<span style="color: black;">BTSerial</span><span style="color: #434f54;">.</span><span style="color: #d35400;">write</span><span style="color: black;">(</span><b><span style="color: #d35400;">Serial</span></b><span style="color: #434f54;">.</span><span style="color: #d35400;">read</span><span style="color: black;">(</span><span style="color: black;">)</span><span style="color: black;">)</span><span style="color: black;">;</span>
<span style="color: #434f54;">//Serial.println("Write..");</span>
<span style="color: #434f54;">//delay(1000);</span>
<span style="color: black;">}</span>
</pre>
<br />
<br />
<br />
<br />
<b>Salve :</b><br />
Write TTL Command<br />
AT+RMAAD (clear any paired devices)<br />
AT+ROLE=0 (set as slave)<br />
AT+ADDR (Return H/w address remember it)<br />
AT+UART=38400,0,0 (To fix the baud rate at 38400)<br />
<br />
<br />
<b>Master :</b><br />
AT+RMAAD<br />
AT+ROLE=1 (set it as master)<br />
AT+CMODE=0 (To connect the module to the specified Bluetooth address and this Bluetooth address can be specified by the binding command)<br />
AT+BIND=xxxx,xx,xxxxxx ( XXXXXXXXXXXX Contain slave address)<br />
AT+UART=38400,0,0 (To fix the baud rate at 38400)<br />
<br />
CKT DIG:<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiEWsHZPkWuQd0evG9HWeVUt95iqqie8Bk11Qvkh-nPw1m9rmYGYDcD3SiJHWc6_noIdjZFg4DkEcYdz1Qv__L0-vYmktL-QIdQx3E3ngjHCAhndI3CP7V9-LjaEGewRJ5E8Fh5GdtknJo/s1600/Capture.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="605" data-original-width="844" height="457" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiEWsHZPkWuQd0evG9HWeVUt95iqqie8Bk11Qvkh-nPw1m9rmYGYDcD3SiJHWc6_noIdjZFg4DkEcYdz1Qv__L0-vYmktL-QIdQx3E3ngjHCAhndI3CP7V9-LjaEGewRJ5E8Fh5GdtknJo/s640/Capture.PNG" width="640" /></a></div>
<br />
<br />
------------------------------------------------------------------------<br />
<b>// note : pin cong (Both Arduinos): </b><br />
<b> BT Arduino</b><br />
Tx 0<br />
RX 1<b><br /></b><br />
<b> </b>VCC 5v<br />
Gnd Gnd<b><br /></b><br />
<br />
<br />
<br />
<br />
Programs<br />
<br />
Android 1 (Button Site)<br />
<pre><span style="color: #434f54;"> ----------------------------------------------------- </span></pre>
<pre><span style="color: #434f54;">// Button Coding ...</span>
<span style="color: #434f54;">//this is master</span>
<span style="color: #434f54;">//#include <SoftwareSerial.h></span>
<span style="color: #434f54;">//SoftwareSerial BTSerial(10, 11);</span>
<span style="color: #00979c;">const</span> <span style="color: #00979c;">int</span> <span style="color: black;">buttonPin</span> <span style="color: #434f54;">=</span> <span style="color: black;">2</span><span style="color: black;">;</span>
<span style="color: #00979c;">int</span> <span style="color: black;">buttonState</span> <span style="color: #434f54;">=</span> <span style="color: black;">1</span><span style="color: black;">;</span>
<span style="color: #00979c;">void</span> <span style="color: #5e6d03;">setup</span><span style="color: black;">(</span><span style="color: black;">)</span>
<span style="color: black;">{</span>
<b><span style="color: #d35400;">Serial</span></b><span style="color: #434f54;">.</span><span style="color: #d35400;">begin</span><span style="color: black;">(</span><span style="color: black;">9600</span><span style="color: black;">)</span><span style="color: black;">;</span>
<span style="color: #d35400;">pinMode</span><span style="color: black;">(</span><span style="color: black;">buttonPin</span><span style="color: #434f54;">,</span> <span style="color: #00979c;">INPUT</span><span style="color: black;">)</span><span style="color: black;">;</span>
<span style="color: #d35400;">digitalWrite</span><span style="color: black;">(</span><span style="color: black;">buttonPin</span><span style="color: #434f54;">,</span> <span style="color: #00979c;">HIGH</span><span style="color: black;">)</span><span style="color: black;">;</span>
<span style="color: black;">}</span>
<span style="color: #00979c;">void</span> <span style="color: #5e6d03;">loop</span><span style="color: black;">(</span><span style="color: black;">)</span>
<span style="color: black;">{</span>
<span style="color: #434f54;">// send Signal to Second Arduino.... for glow LED</span>
<span style="color: black;">buttonState</span> <span style="color: #434f54;">=</span> <span style="color: #d35400;">digitalRead</span><span style="color: black;">(</span><span style="color: black;">buttonPin</span><span style="color: black;">)</span><span style="color: black;">;</span>
<span style="color: #5e6d03;">if</span> <span style="color: black;">(</span><span style="color: black;">buttonState</span> <span style="color: #434f54;">==</span> <span style="color: #00979c;">LOW</span><span style="color: black;">)</span>
<span style="color: black;">{</span>
<b><span style="color: #d35400;">Serial</span></b><span style="color: #434f54;">.</span><span style="color: #d35400;">write</span><span style="color: black;">(</span><span style="color: #00979c;">'1'</span><span style="color: black;">)</span><span style="color: black;">;</span>
<span style="color: black;">}</span>
<span style="color: #5e6d03;">else</span>
<span style="color: black;">{</span>
<b><span style="color: #d35400;">Serial</span></b><span style="color: #434f54;">.</span><span style="color: #d35400;">write</span><span style="color: black;">(</span><span style="color: #00979c;">'0'</span><span style="color: black;">)</span><span style="color: black;">;</span>
<span style="color: black;">}</span>
<span style="color: black;">}</span>
</pre>
--------------------------------------------------------<br />
<b><br /></b>
<b>LED Site (Arduino 2)</b><br />
<br />
<pre><span style="color: #434f54;">//LED CKT</span>
<span style="color: #5e6d03;">#include</span> <span style="color: #434f54;"><</span><b><span style="color: #d35400;">SoftwareSerial</span></b><span style="color: #434f54;">.</span><span style="color: black;">h</span><span style="color: #434f54;">></span>
<span style="color: #434f54;">//SoftwareSerial BTSerial(2, 3);</span>
<span style="color: #00979c;">int</span> <span style="color: black;">data</span> <span style="color: #434f54;">=</span> <span style="color: black;">0</span><span style="color: black;">;</span>
<span style="color: #00979c;">const</span> <span style="color: #00979c;">int</span> <span style="color: black;">led</span> <span style="color: #434f54;">=</span> <span style="color: black;">8</span><span style="color: black;">;</span>
<span style="color: #00979c;">int</span> <span style="color: black;">flag</span><span style="color: #434f54;">=</span><span style="color: black;">0</span><span style="color: black;">;</span>
<span style="color: #00979c;">void</span> <span style="color: #5e6d03;">setup</span><span style="color: black;">(</span><span style="color: black;">)</span>
<span style="color: black;">{</span>
<span style="color: #434f54;">//BTSerial.begin(38400);</span>
<b><span style="color: #d35400;">Serial</span></b><span style="color: #434f54;">.</span><span style="color: #d35400;">begin</span><span style="color: black;">(</span><span style="color: black;">9600</span><span style="color: black;">)</span><span style="color: black;">;</span>
<span style="color: #d35400;">pinMode</span><span style="color: black;">(</span><span style="color: black;">led</span><span style="color: #434f54;">,</span> <span style="color: #00979c;">OUTPUT</span><span style="color: black;">)</span><span style="color: black;">;</span>
<span style="color: #d35400;">digitalWrite</span><span style="color: black;">(</span><span style="color: black;">led</span><span style="color: #434f54;">,</span> <span style="color: #00979c;">LOW</span><span style="color: black;">)</span><span style="color: black;">;</span>
<span style="color: black;">}</span>
<span style="color: #00979c;">void</span> <span style="color: #5e6d03;">loop</span><span style="color: black;">(</span><span style="color: black;">)</span>
<span style="color: black;">{</span>
<span style="color: #5e6d03;">if</span><span style="color: black;">(</span><b><span style="color: #d35400;">Serial</span></b><span style="color: #434f54;">.</span><span style="color: #d35400;">available</span><span style="color: black;">(</span><span style="color: black;">)</span> <span style="color: #434f54;">></span> <span style="color: black;">0</span><span style="color: black;">)</span>
<span style="color: black;">{</span>
<span style="color: black;">data</span> <span style="color: #434f54;">=</span> <b><span style="color: #d35400;">Serial</span></b><span style="color: #434f54;">.</span><span style="color: #d35400;">read</span><span style="color: black;">(</span><span style="color: black;">)</span><span style="color: black;">;</span> <span style="color: #434f54;">// incoming data i.e 1</span>
<span style="color: #5e6d03;">if</span><span style="color: black;">(</span><span style="color: black;">data</span><span style="color: #434f54;">==</span><span style="color: black;">1</span> <span style="color: #434f54;">&&</span> <span style="color: black;">flag</span><span style="color: #434f54;">==</span><span style="color: black;">0</span><span style="color: black;">)</span>
<span style="color: black;">{</span>
<span style="color: black;">flag</span><span style="color: #434f54;">=</span><span style="color: black;">1</span><span style="color: black;">;</span>
<span style="color: black;">}</span>
<span style="color: #5e6d03;">else</span> <span style="color: #5e6d03;">if</span><span style="color: black;">(</span><span style="color: black;">data</span><span style="color: #434f54;">==</span><span style="color: black;">1</span> <span style="color: #434f54;">&&</span> <span style="color: black;">flag</span><span style="color: #434f54;">==</span><span style="color: black;">1</span><span style="color: black;">)</span>
<span style="color: black;">{</span>
<span style="color: black;">flag</span><span style="color: #434f54;">=</span><span style="color: black;">0</span><span style="color: black;">;</span>
<span style="color: black;">}</span>
<span style="color: black;">}</span>
<span style="color: #5e6d03;">if</span> <span style="color: black;">(</span><span style="color: black;">flag</span> <span style="color: #434f54;">==</span> <span style="color: #00979c;">'1'</span> <span style="color: black;">)</span>
<span style="color: black;">{</span>
<span style="color: #d35400;">digitalWrite</span><span style="color: black;">(</span><span style="color: black;">led</span><span style="color: #434f54;">,</span> <span style="color: #00979c;">HIGH</span><span style="color: black;">)</span><span style="color: black;">;</span> <span style="color: #434f54;">// LED ON</span>
<span style="color: black;">data</span> <span style="color: #434f54;">=</span> <span style="color: black;">0</span><span style="color: black;">;</span>
<span style="color: black;">}</span>
<span style="color: #5e6d03;">else</span> <span style="color: #5e6d03;">if</span> <span style="color: black;">(</span><span style="color: black;">flag</span> <span style="color: #434f54;">==</span> <span style="color: #00979c;">'0'</span><span style="color: black;">)</span>
<span style="color: black;">{</span>
<span style="color: #d35400;">digitalWrite</span><span style="color: black;">(</span><span style="color: black;">led</span><span style="color: #434f54;">,</span> <span style="color: #00979c;">LOW</span><span style="color: black;">)</span><span style="color: black;">;</span> <span style="color: #434f54;">// LED ON</span>
<span style="color: black;">data</span> <span style="color: #434f54;">=</span> <span style="color: black;">0</span><span style="color: black;">;</span>
<span style="color: black;">}</span>
<span style="color: black;">}</span>
</pre>
<br />
<br />
<br />
<br />
<br />
<br />Kishor M Sonawanehttp://www.blogger.com/profile/12171589855304919032noreply@blogger.com1tag:blogger.com,1999:blog-788103260560462553.post-84789455720286368552018-06-12T09:23:00.001+05:302018-06-12T09:23:04.683+05:30Python P2 Python Command line + exit Command<br />
Python P2 Python Command line + exit Command<br />
<br />
<b>Exit Syntax </b><br />
exit Use to Stop Python Program<br />
<br />
<blockquote class="tr_bq">
<blockquote class="tr_bq">
<span style="color: #a64d79;"> exit()
</span></blockquote>
</blockquote>
means When You use Command Line Python At that time use exit() from Command.<br />
<br />
How to <b>Start Command line Python</b> :<br />
<br />
<ol>
<li>Open terminal / CMD</li>
<li>type python</li>
<li> your Command Line Python Open :)</li>
</ol>
<br />
Now type any python on it<br />
<br />
<b>look like ......</b><br />
<br />
<span style="color: #a64d79;">$python</span><br />
<span style="color: #a64d79;">python>> [Your Command Here]</span><br />
<br />
<br />
<b>example :</b><br />
<br />
$ python <br />
<span style="color: #a64d79;">python>> print("hello MAC+tech")</span><br />
<span style="color: #a64d79;">hello MAC+tech</span><br />
<span style="color: #a64d79;"> python>> </span><br />
<br />
<br />
<br />
Kishor M Sonawanehttp://www.blogger.com/profile/12171589855304919032noreply@blogger.com1tag:blogger.com,1999:blog-788103260560462553.post-54642674367874380162018-06-12T09:14:00.001+05:302018-06-12T09:14:21.307+05:30Intro Python P1 + Run Python 1st Program<h2>
Python?</h2>
<h4>
<span style="font-weight: normal;">It was created in 1991 by Guido van Rossum .</span></h4>
<h4>
use :</h4>
<ol>
<li>web development (server-side)</li>
<li>Data Mining And Analytics. </li>
<li>graphics </li>
<li>System S/w</li>
<li>software development </li>
<li>mathematics</li>
<li>system scripting.</li>
<li>AI Application</li>
<li>Embedded Development </li>
</ol>
<b>Some features :</b><br />
<ol>
<li>Python works on <span style="background-color: yellow;"><b>different platforms</b></span> (Windows, Mac, Linux, Raspberry Pi, etc).</li>
<li>Python has a <span style="background-color: yellow;"><b>simple syntax</b></span> similar to the English language.</li>
<li>Python has syntax that allows developers to write programs with <span style="background-color: yellow;"><b>fewer lines</b></span> than some other programming languages.</li>
<li>Python runs on an <span style="background-color: yellow;"><b>interpreter system</b></span>, meaning that code can be
executed as soon as it is written. This means that prototyping can be
very quick.</li>
<li>Python can be treated in a <span style="color: red;"><b>procedural way</b></span>, an <span style="color: blue;"><b>object-orientated</b></span> way or a functional way.</li>
</ol>
<span style="color: #cc0000;"><b> Let's Start...... :) </b></span><br />
<span style="color: #cc0000;"><b><br /></b></span>
<span style="color: #cc0000;"><b><span style="color: black;">Run Program</span></b></span><br />
<br />
<blockquote class="tr_bq">
<span style="color: #cc0000;"><b><span style="color: black;">$python File.py</span></b></span></blockquote>
<br />
<blockquote class="tr_bq">
Here Command Python , file name is the any File Name..</blockquote>
<br />
Run Steps :<br />
open Any Editor And Type :<br />
<span style="color: black;"><span style="color: mediumblue;"> </span></span><br />
<span style="color: black;"><span style="color: mediumblue;"> print</span>(<span style="color: brown;">"Hello, MAC+tech Word!"</span>)</span><br />
<br />
<span style="color: black;">Save any name ex mypro1.py</span><br />
<br />
<span style="color: black;">Type python </span><span style="color: black;">mypro1.py</span><br />
<br />
<span style="color: black;">O/U :</span><br />
Hello, MAC+tech Word! <br />
<br />
<br />
<br />
<br />
<br />
<br />
<h4>
<span style="font-weight: normal;"></span></h4>
Kishor M Sonawanehttp://www.blogger.com/profile/12171589855304919032noreply@blogger.com1tag:blogger.com,1999:blog-788103260560462553.post-42599092289167498742018-03-15T11:11:00.002+05:302018-03-15T11:11:42.370+05:30BE CL3 Programs <br />
Download<br />
<br />
<a href="https://drive.google.com/open?id=1HJaA7SAxvxm0kym4uhttUHZyhhRA32cd">https://drive.google.com/open?id=1HJaA7SAxvxm0kym4uhttUHZyhhRA32cd</a><br />
<br />
<br />
<a href="https://drive.google.com/open?id=1HJaA7SAxvxm0kym4uhttUHZyhhRA32cd" target="_blank"><<Download>></a><br />
<br />
or<br />
<a href="https://drive.google.com/open?id=1lsbMfAV-QRI9uEV4HiDWMzAhqwLPW4UH">https://drive.google.com/open?id=1lsbMfAV-QRI9uEV4HiDWMzAhqwLPW4UH</a><br />
<br />
<a href="https://drive.google.com/open?id=1lsbMfAV-QRI9uEV4HiDWMzAhqwLPW4UH" target="_blank"><<Download>></a>Kishor M Sonawanehttp://www.blogger.com/profile/12171589855304919032noreply@blogger.com1tag:blogger.com,1999:blog-788103260560462553.post-5401852088784167582018-03-01T10:36:00.001+05:302018-03-01T10:36:24.598+05:30BE All INSEM And End Sem Unipune Papers <br />
<h3>
<u><b>Download BE All INSEM And End Sem Unipune Papers :</b></u></h3>
<br />
<<<a href="https://drive.google.com/open?id=1nojjas6fjddjGiTLaBSjzgaGEeQNZ9Qe" target="_blank">Download</a>>><br />
or<br />
<br />
<<<a href="https://drive.google.com/open?id=1nojjas6fjddjGiTLaBSjzgaGEeQNZ9Qe" target="_blank">Download</a>>><br />
or<br />
<br />
<<<a href="https://drive.google.com/open?id=1nojjas6fjddjGiTLaBSjzgaGEeQNZ9Qe" target="_blank">Download</a>>><br />
<br />
<br />
<a href="https://drive.google.com/open?id=1nojjas6fjddjGiTLaBSjzgaGEeQNZ9Qe">https://drive.google.com/open?id=1nojjas6fjddjGiTLaBSjzgaGEeQNZ9Qe</a><br />
<br />
<br />
<<<a href="https://drive.google.com/open?id=1nojjas6fjddjGiTLaBSjzgaGEeQNZ9Qe" target="_blank">Download</a>>>Kishor M Sonawanehttp://www.blogger.com/profile/12171589855304919032noreply@blogger.com2