How to change max_allowed_packet size in SQL

-

 SQL query is :

SET GLOBAL max_allowed_packet = 6250000;

this is for 50MB


How to Convert 6.25e+6 to Real Number?

6.25e+6 = 6.25 x 106 = 6,250,000


Comments

Post a Comment

Popular posts from this blog

Springboot important annotation

-
Image
  Spring Boot Annotations Spring Boot’s annotations are key to getting up to speed with the framework. They allow you to direct the framework to do your bidding, taking control and overriding its defaults when needed. Annotations are quick, easy to use, and orders of magnitude faster than building the equivalent functionality yourself. You can learn more in Spring’s documentation. The  PDF  or  web  versions are essential reading if you plan on working with Spring Boot. Knowing how to use annotations can level up your game and help you get the most out of the framework. Listed below are several common annotations, some of them with sample code. Spring Boot works with  Java ,  Kotlin , and Groovy. I’ll use Java for the examples in this article. Basic Setup @SpringBootApplication @Configuration @ComponentScan @EnableAutoConfiguration Request Responses @GetMapping @RequestMapping @RequestParam Component Types @Component @Service @Repository @Controller @R...
Read more

image work in springboot

-
 Bean file :         @Lob @Column(length = Integer.MAX_VALUE) private byte[] images;          public byte[] getImages() {           return images;            }          public void setImages(byte[] images) {           this.images = images;            } save image controller :       @PostMapping("/") public String saveHolidayPackage(@ModelAttribute CreateHolidayPackageOne createHolidayPackageOne,               @RequestParam("image") MultipartFile file,HttpSession httpSession) throws IOException { createHolidayPackageOne.setImages(file.getBytes()); createHolidayPackageOneRepo.save(createHolidayPackageOne); return "Admin/CreateHolidayPackageDetails"; } retrieve image from database controller :         ...
Read more