Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Databases In Networked Information Systems 6th International Workshop Dnis 2010 Aizu Wakamatsu Japan March 2010 Proceedings Lncs 5999

Authors: Shinji Kikuchi ,Shelly Sachdeva ,Subhash Bhalla

2010th Edition

3642120377, 978-3642120374

More Books

Students also viewed these Databases questions

Question

9. System creates a large, diverse talent pool.

Answered: 1 week ago