hi, i have created / imported a table to mysql thru mysqlgisimport libraries and it has created a table with the following field / table structure Field name Type Allow nulls? Key Default value Extras id int(10) unsigned No Primary NULL auto_increment NAME varchar(100) No None TYPE varchar(100) No None SPEED_LIMI int(11) No None 0 ONE_WAY int(11) No None 0 geo geometry No Indexed
now i need to write a sample query to demostrate the gis / spatial capabalities of mysql... i have gone thru all the web but didnt find an example for buffer(g,d) or Distance() functions.. please help out in writing these type of mysql queries thanks & regards prashant _______________________________________________________________ Share diaries and photos with your friends and family. http://www.homemaster.net - Homemaster. Come Together. Online. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]