Question
cannot form my shape with polygon data type in mysql. Please help SET @g =ST_geometryFromText( 'POLYGON((9 8,9 3,4 1,2 2,1 3,3 5,3 6,2 6,2 9,5
cannot form my shape with polygon data type in mysql. Please help
SET @g =ST_geometryFromText( 'POLYGON((9 8,9 3,4 1,2 2,1 3,3 5,3 6,2 6,2 9,5 9,5 10,6 11,7 11,7 10,6 9,7 8,7 9,8 9,8 8,9 8))'); INSERT INTO `homework2cst325`.`boundary` (`Boundary_path`) VALUES (ST_geometryfromtext(@g),SHAPE);
ERROR 3037: 3037: Invalid GIS data provided to function st_geometryfromtext. SQL Statement: INSERT INTO `homework2cst325`.`boundary` (`Boundary_path`) VALUES (ST_geometryfromtext('@g'))
ERROR 1136: 1136: Column count doesn't match value count at row 1 SQL Statement: INSERT INTO `homework2cst325`.`boundary` (`Boundary_path`) VALUES (ST_geometryfromtext('@g'),SHAPE)
ERROR 1136: 1136: Column count doesn't match value count at row 1 SQL Statement: INSERT INTO `homework2cst325`.`boundary` (`Boundary_path`) VALUES (ST_geometryfromtext(@g),SHAPE)
ERROR 1136: 1136: Column count doesn't match value count at row 1 SQL Statement: INSERT INTO `homework2cst325`.`boundary` (`Boundary_path`) VALUES (ST_geometryfromtext(@g),SHAPE)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started