INSERT INTO new_registration
(
`Ownership_Category`,
`Is_Govt_Org`,
`Title_Category`,
`Nationality`,
`Owner_Name`,
`Owner_Pan_Card`,
`Upload_pan_card_Document`,
`Mobile_No`,
`Email_ID`,
`PinCode`,
`State`,
`District`,
`City`,
Tuesday, March 3, 2026
How to add multiple rows in MySQL with for loop with stored procedure
-- 1. Change the statement delimiter
DELIMITER $$
DROP PROCEDURE IF EXISTS insert_data_loop;
-- 2. Create the stored procedure
CREATE PROCEDURE insert_data_loop()
BEGIN
DECLARE i INT DEFAULT 1; -- Declare a variable for the loop counter
DECLARE max_value INT DEFAULT 50; -- Set the loop limit
-- Start the WHILE loop
WHILE i <= max_value DO
-- 3. The INSERT query inside the loop
SET i = i + 1;
INSERT INTO new_registration
(
`Ownership_Category`,
`Is_Govt_Org`,
`Title_Category`,
`Nationality`,
`Owner_Name`,
`Owner_Pan_Card`,
`Upload_pan_card_Document`,
`Mobile_No`,
`Email_ID`,
`PinCode`,
`State`,
`District`,
`City`,
`Address`,
`DOB`,
`Upload_DOB_Certificate`,
`GST_No`,
`Upload_GST_Certificate`)
VALUES
(
'Individual',
1,
'News Paper',
'Indian',
'Yash Kapoor','45YYH87Y','Documents/test1.jpg',
457851,'test@test.com',
110022,'Haryana',
'Sonepat','Sonepat','Jangpura, Delhi',
' 15/01/1945', 'Documents/test1.jpg' ,
'JHJDFHJDF8787DF',
'Documents/test1.jpg');
-- Increment the counter
END WHILE;
END $$
-- 4. Reset the delimiter
DELIMITER ;
-- 5. Call the procedure to run the insert loop
CALL insert_data_loop();
-- Optional: verify the results
SELECT * FROM new_registration;
Note:- You cannot use for loop without Creating stored procedure.
How to add auto date in column in MySQL
NOW()
CURRENT_DATE
CURRENT_TIMESTAMP
in Default/Expression Column
Insert query in MYSQL - with now() - with update date
INSERT INTO `test`.`new_registration`
(
`Ownership_Category`,
`Is_Govt_Org`,
`Title_Category`,
`Nationality`,
`Owner_Name`,
`Owner_Pan_Card`,
`Upload_pan_card_Document`,
`Mobile_No`,
`Email_ID`,
`PinCode`,
`State`,
`District`,
`City`,
`Address`,
`DOB`,
`Upload_DOB_Certificate`,
`GST_No`,
`Upload_GST_Certificate`)
VALUES
(
'Individual',
1,
'News Paper',
'Indian',
'Yash Kapoor','45YYH87Y','Documents/test1.jpg',
457851,'test@test.com',
110022,'Haryana',
'Sonepat','Sonepat','Jangpura, Delhi',
' 15/01/1945', 'Documents/test1.jpg' ,
'JHJDFHJDF8787DF',
'Documents/test1.jpg');
Monday, March 2, 2026
How to generate Create Query in MYSQL
Right Click on Table(New_Reg_Table)
>Click on Send to SQl Editor
> Click on Create Statement
Friday, February 27, 2026
How to install My SQL
> To install MY SQL, below link to install
https://dev.mysql.com/downloads/workbench/
Click on Go to download page
or click on below link
> Click on https://dev.mysql.com/downloads/windows/installer/8.0.html
Monday, February 16, 2026
Mirror text in CSS
<!DOCTYPE html>
<html>
<head>
<style>
div.ex1 {
direction: rtl;
unicode-bidi: bidi-override;
}
</style>
</head>
<body>
<h1>The unicode-bidi Property</h1>
<div>Some text. Default writing direction.</div>
<div class="ex1">Some text. Right-to-left direction.</div>
</body>
</html>
ref:- https://www.w3schools.com/cssref/tryit.php?filename=trycss_text_unicode-bidi
Snippets in chrome for CSS style
(function() {
let style = `<style>
.p-datatable .p-datatable-tbody>tr>td{
color: black;
}
</style>`;
document.head.insertAdjacentHTML("beforeend", style);
})();
Transform rotate CSS - Fast loader with CSS
<!DOCTYPE html>
<html>
<head>
<meta name="viewport" content="width=device-width, initial-scale=1">
<style>
.loader {
border: 16px solid #f3f3f3;
border-radius: 50%;
border-top: 16px solid blue;
border-bottom: 16px solid blue;
width: 120px;
height: 120px;
-webkit-animation: spin 1s linear infinite;
animation: spin 400ms linear infinite;
}
@-webkit-keyframes spin {
0% { -webkit-transform: rotate(0deg); }
100% { -webkit-transform: rotate(360deg); }
}
@keyframes spin {
0% { transform: rotate(0deg); }
100% { transform: rotate(360deg); }
}
</style>
</head>
<body>
<h2>How To Create A Loader</h2>
<div class="loader"></div>
</body>
</html>
==============================
with image
<img alt="Ashoka Chakra" loading="lazy" width="90" height="90" decoding="async" data-nimg="1" class="tw:animate-[spin_8s_linear_infinite]" style="color:transparent;" src="/home/chakras/ashok-chakra.svg">
.tw\:animate-\[spin_8s_linear_infinite\] {
animation: spin 8s linear infinite;
}
Tuesday, February 10, 2026
How to change text color in Chrome - How to change font color in Chrome extension
Friday, February 6, 2026
Font Sharpness in CSS
-webkit-text-stroke: 0.2px;
text-shadow: #fff 0px 0.5px 0.5px;
and you can use color of font to black in CSS
color: black;
Thursday, February 5, 2026
Vibration of font in chrome - Shaking of font in chrome - transform in css - color change in second - Keyframes in CSS - blinking in CSS - blinking in css
HTML
<img src="https://ik.imagekit.io/ikmedia/css-image-effects/new-york_lbAbZZKZG.jpg" alt="new york" />
</br>
<p class="vibrating-text"> dfdf dfd ddfd df</p>
CSS
img {
width: 300px;
}
img:hover {
/* Start the shake animation and make the animation last for 0.5 seconds */
animation: vibrate 0.1s;
/* When the animation is finished, start again */
animation-iteration-count: infinite;
}
@keyframes vibrate {
0% { transform: rotate(0deg); }
10% { transform: rotate(-1deg); }
20% { transform: rotate(1deg); }
30% { transform: rotate(0deg); }
40% { transform: rotate(1deg); }
50% { transform: rotate(-1deg); }
60% { transform: rotate(0deg); }
70% { transform: rotate(-1deg); }
80% { transform: rotate(1deg); }
90% { transform: rotate(0deg); }
100% { transform: rotate(-1deg); }
}
OR
@keyframes vibratetext {
0% { transform: translate(0, 0); }
20% { transform: translate(-1px, 1px); }
40% { transform: translate(-1px, -1px); }
60% { transform: translate(1px, 1px); }
80% { transform: translate(1px, -1px); }
100% { transform: translate(0, 0); }
}
Wednesday, February 4, 2026
Thursday, January 29, 2026
How to convert any website to black and white or colorless in Chrome - Increase or decrease colors in website of chrome - Saturation in google chrome - Color in chrome - strength radius and sharpness in website of chrome - Greyscale in Chrome
> Go to Inspect element (F12)
> In body tag
> Go to styles
> In element style paste -webkit-filter: grayscale(100%);
and if you use 10%, 20% color will be increase or decrease in Chrome website.
or you can use below extension for chrome to decrease or increase saturation or colors
https://chromewebstore.google.com/detail/web-color-filter/njnaggoebacjnbklkcccmbnpfmeagcmp
https://chromewebstore.google.com/detail/video-image-control-new-g/mdoelcifdkcimkdbfkjjnedabmjlkokc
or you can download video image control source code from below link and add extension to chrome.
How to change cursor in Chrome - Chrome Extension
Friday, January 23, 2026
a to z alphabets copy and paste in Notepad Chrome
#Note This first line is mandatory [void] [System.Reflection.Assembly]::LoadWithPartialName("System.Windows.Forms")
# Start WinWord (if not already running)
Start-Process -FilePath "chrome.exe"
# Wait for WinWord to open and become active
Start-Sleep -Seconds 3
# Activate the WinWord window (adjust the title if necessary)
$wshell = New-Object -ComObject wscript.shell
#$wshell.AppActivate("Document1 - Word") # Or the actual document title
(New-Object -ComObject "wscript.shell").SendKeys('data:text/html, <title>Notepad</title><body contenteditable style="font-size:18px;line-height:1.6;font-family:sans-serif;">')
(New-Object -ComObject "wscript.shell").SendKeys("{ENTER}")
Start-Sleep -Seconds 1
(New-Object -ComObject "wscript.shell").SendKeys("{TAB}")
for ($k = 1; $k -le 10; $k++) {
for ($i = 1; $i -le 50; $i++) {
$j = [char](65 + $i)
(New-Object -ComObject "wscript.shell").SendKeys("$j")
}
[System.Windows.Forms.SendKeys]::SendWait("^{a}")
[System.Windows.Forms.SendKeys]::SendWait("^{c}")
[System.Windows.Forms.SendKeys]::SendWait("{RIGHT}")
[System.Windows.Forms.SendKeys]::SendWait("^{v}")
(New-Object -ComObject "wscript.shell").SendKeys("{Enter}")
}
Thursday, January 22, 2026
Sorting in Excel - Unique records in Excel
For Sorting
> First Select the columns
> Click on Data Menu
> Click on Sort
> Select the Column (Sort By)
> Click on OK
==============================
For Unique Records
> First Select the column
> Click on Data
> Click on Advanced
> Check on Unique Records
> Click on OK
Pin codes from govt sites - PINCODE of india from official sites
https://dac.indiapost.gov.in/mypincode/home
https://dmsouthwest.delhi.gov.in/std-pin-codes/
https://www.data.gov.in/datasets_webservices/datasets/6818292
https://www.pib.gov.in/PressReleasePage.aspx?PRID=2131707®=3&lang=2
Know Your DIGIPIN: https://dac.indiapost.gov.in/mydigipin/home
Know Your PIN Code: https://dac.indiapost.gov.in/mypincode/home
DIGIPIN GitHub Repository: https://github.com/CEPT-VZG/digipin
Georeferenced PIN Code data set: https://www.data.gov.in/catalog/all-india-pincode-boundary-geo-json
Wednesday, January 21, 2026
How to create an image with random number and random alphabets with Javascripts
HTML
<body>
<canvas id="myCanvas" width="200" height="100" style="border:1px solid #d3d3d3;">
Your browser does not support the HTML5 canvas tag.
</canvas>
<script src="script.js"></script>
</body>
JAVASCRIPT
function generateRandomLetters(length) {
let result = '';
const characters = 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz';
for (let i = 0; i < length; i++) {
result += characters.charAt(Math.floor(Math.random() * characters.length));
}
return result;
}
// Example usage to get a 6-letter string:
const randomLetters = generateRandomLetters(6);
// Get the canvas element and its 2D context
const canvas = document.getElementById("myCanvas");
const ctx = canvas.getContext("2d");
// Draw a rectangle
ctx.fillStyle = "#FF0000";
ctx.fillRect(0, 0, 150, 75);
// Draw some text
ctx.font = "30px Arial";
ctx.fillStyle = "#000000";
ctx.fillText(randomLetters, 10, 50);
// Optional: Convert canvas content to an image data URL
const imageDataUrl = canvas.toDataURL("image/png");
console.log(imageDataUrl); // You can use this URL as the src for a new <img> element
document.write(randomLetters);
OR
// Get the canvas element and its 2D context
const canvas = document.getElementById("myCanvas");
const ctx = canvas.getContext("2d");
// Draw a rectangle
ctx.fillStyle = "#FF0000";
ctx.fillRect(0, 0, 150, 75);
// Draw some text
ctx.font = "30px Arial";
ctx.fillStyle = "#000000";
ctx.fillText(Math.random(), 10, 50);
// Optional: Convert canvas content to an image data URL
const imageDataUrl = canvas.toDataURL("image/png");
console.log(imageDataUrl); // You can use this URL as the src for a new <img> element
document.write(Math.random());
ref:- https://codesandbox.io/p/sandbox/random-word-generator-ijlgj?file=%2Fsrc%2Findex.js%3A7%2C44-7%2C50
A to Z alphabets in chrome with notepad with powershell
#Note This first line is mandatory [void] [System.Reflection.Assembly]::LoadWithPartialName("System.Windows.Forms")
# Start WinWord (if not already running)
Start-Process -FilePath "chrome.exe"
# Wait for WinWord to open and become active
Start-Sleep -Seconds 3
# Activate the WinWord window (adjust the title if necessary)
$wshell = New-Object -ComObject wscript.shell
#$wshell.AppActivate("Document1 - Word") # Or the actual document title
(New-Object -ComObject "wscript.shell").SendKeys('data:text/html, <title>Notepad</title><body contenteditable style="font-size:18px;line-height:1.6;font-family:sans-serif;">')
(New-Object -ComObject "wscript.shell").SendKeys("{ENTER}")
Start-Sleep -Seconds 1
(New-Object -ComObject "wscript.shell").SendKeys("{TAB}")
for ($k = 1; $k -le 50; $k++) {
for ($i = 1; $i -le 77; $i++) {
$j = [char](45 + $i)
(New-Object -ComObject "wscript.shell").SendKeys("$j")
}
(New-Object -ComObject "wscript.shell").SendKeys("{Enter}")
}
Tuesday, January 20, 2026
Scroll Button Meaning
> In Excel , Click on Cell, If scroll Lock is OFF than You can left and right the Cell.
> IF scroll Lock is ON than you can scroll Down or up scroll bars.
Thursday, January 15, 2026
How to copy and paste in Powershell from one notepad to another notepad - CTRL + C and CTRL + V in Powershell - CTRL C in Powershell and CTRL V in Powershell
#Note This first line is mandatory
[void] [System.Reflection.Assembly]::LoadWithPartialName("System.Windows.Forms")
# Start WinWord (if not already running)
Start-Process -FilePath "notepad.exe"
# Wait for WinWord to open and become active
Start-Sleep -Seconds 3
Start-Process -FilePath "notepad.exe"
Start-Sleep -Seconds 3
# Activate the WinWord window (adjust the title if necessary)
[System.Windows.Forms.SendKeys]::SendWait("123")
Start-Sleep -Seconds 3
[System.Windows.Forms.SendKeys]::SendWait("^{a}")
Start-Sleep -Seconds 3
[System.Windows.Forms.SendKeys]::SendWait("^{C}")
Start-Sleep -Seconds 3
[System.Windows.Forms.SendKeys]::SendWait("%{TAB}")
Start-Sleep -Seconds 3
[System.Windows.Forms.SendKeys]::SendWait("^{v}")
Note: ctrl C and Ctrl v , c and v are in small letters.
Wednesday, January 14, 2026
Fireworks in JS - Crackers Javascript
https://www.npmjs.com/package/fireworks-js
> https://github.com/crashmax-dev/fireworks-js
https://stackblitz.com/edit/js-ubfdjg?file=style.css,package.json,index.js
https://codepen.io/mr__khushal/pen/yLobQEP
https://stackblitz.com/edit/js-ubfdjg?file=style.css,package.json,index.js
https://www.myprograming.com/how-to-add-crackers-animation-effect-to-my-html-page/
Confirm button in Javascript
if (confirm("Press a button!")) {
txt = "You pressed OK!";
} else {
txt = "You pressed Cancel!";
}
How to view two books in Excel - How to view two books in excel
> In excel, there are books.
> And In books there are sheets
------
> At the top, you have restore option.
> In View Menu, You have arrange all button. You can click on that button.
> You can also used split button
Monday, January 12, 2026
Friday, January 9, 2026
Two filters in excel - Two Columns filters in excel - Multiple Columns filters in excel
> Open Excel
> Click on Data Menu
> Select the columns in sequence, not using CNTL(Column 1,2,3,4) will be used for Multiple columns. (Columns 4,6,9) will not be used for Multiple Columns.
> Click on Filter
>
Thursday, January 8, 2026
How to enable text cursor in Chrome - Highlight on object in Chrome
> In settings of Google Chrome
> Click on Accessibility
> Click on navigate pages with a text cursor
---------
Click on HIGHLIGHT ON FOCUS OBJECT
Friday, January 2, 2026
Powershell a to z alphabets 50 times in notepad
#Note This first line is mandatory [void] [System.Reflection.Assembly]::LoadWithPartialName("System.Windows.Forms")
# Start WinWord (if not already running)
Start-Process -FilePath "notepad.exe"
# Wait for WinWord to open and become active
Start-Sleep -Seconds 3
# Activate the WinWord window (adjust the title if necessary)
$wshell = New-Object -ComObject wscript.shell
#$wshell.AppActivate("Document1 - Word") # Or the actual document title
Start-Sleep -Seconds 1
for ($k = 1; $k -le 25; $k++) {
for ($i = 1; $i -le 55; $i++) {
$j = [char](65 + $i)
(New-Object -ComObject "wscript.shell").SendKeys("$j")
}
(New-Object -ComObject "wscript.shell").SendKeys("{Enter}")
}
Subscribe to:
Comments (Atom)