Wednesday, May 6, 2026

How to create java project with spring boot

>Open link start.spring.io

> Select Maven

> Select Language Java

> Click on Add dependencies

> Add dependencies (My SQL driver, Spring Web , Spring boot dev tools, spring data JAP, Thymeleaf)

> And Click on Generate button

Open this project in Intelli J (IDE)

ref:-  https://spring.io/guides/gs/spring-boot

Tuesday, May 5, 2026

How to copy active cell in excel - VBA - How to copy and fill color of row in excel- VBA -Macro

ActiveCell.Copy

or

 Sub Macro1()

ActiveCell.Copy

ActiveCell.EntireRow.Interior.Color = 5296274

End Sub


or

 Sub Macro1()

ActiveCell.Copy

With ActiveCell.Row.Interior

        .Pattern = xlSolid

        .PatternColorIndex = xlAutomatic

        .Color = 5287936

        .TintAndShade = 0

        .PatternTintAndShade = 0

    End With

End Sub


ref:- https://www.mrexcel.com/board/threads/vba-command-for-copying-active-cell-content-only.978747/

https://www.reddit.com/r/excel/comments/axgoth/vba_code_to_color_a_row_whole_up_until_a_certain/



How to import and export database(sql query) in MYSQL

>Open MY sql server

 >Click on Server Menu

>Click on Data Import

> Click on Import from self-contained file

> Click on 3 dot and than select sql file

>Select Default Target Schema(Dropdown) and  select blank database name

> Click on Start Import button

Sunday, May 3, 2026