current position:Home>The MySQL geometry type retains 6 decimal places

The MySQL geometry type retains 6 decimal places

2022-02-03 01:25:06 CSDN Q & A

The phenomenon and background of the problem

Mysql geometry type The decimal point is reserved 6 Decimal place

MULTIPOLYGON(((103.12345678 20.132345678,103.14545678  20.125345678,103.12345678 20.125345678,,103.12345678 20.125345678,,103.12345678 20.125345678)),((103.12345678 20.132345678,103.12345678 20.132345678,103.12345678 20.132345678,103.12345678 20.132345678, 103.12345678 20.132345678)))
Operation results and error reporting contents
My solution ideas and tried methods
What I want to achieve
MULTIPOLYGON(((103.123456 20.1323456,103.145456  20.1253456,103.123456 20.1253456,,103.123456 20.1253456,,103.123456 20.1253456)),((103.123456 20.1323456,103.123456 20.1323456,103.123456 20.1323456,103.123456 20.1323456, 103.123456 20.1323456)))



Refer to the answer 1:

Hello , I am a little assistant who answers every question , So sorry , This time, you have to answer all your questions , The panel of technical experts timed out and did not answer for you


The number of times to answer all questions deducted from this question , Will answer with questions VIP Experience card (1 A chance to answer every question 、 Shopping malls buy physical books and enjoy 95 A discount ) It will be reissued to your account in the form of .


Because all questions must be answered VIP The experience card is only valid for 1 God , When you need it 【 Direct messages 】 Contact me , I'll reissue it for you .




Refer to the answer 2:

copyright notice
author[CSDN Q & A],Please bring the original link to reprint, thank you.
https://en.primo.wiki/2022/02/202202030125057111.html

Random recommended