Autenticación ó acceder a algún directorio web

http://httpd.apache.org/docs/2.0/es/howto/auth.html
http://sendatama.wordpress.com/2008/04/02/how-to-install-mapserver-on-windows/

Importar datos a MySql dende archivos de texto (csv, txt, etc..)

LOAD DATA INFILE "arquivo.txt"
INTO TABLE táboa
FIELDS TERMINATED BY ';' --> Indicamos o separador dos campos
LINES TERMINATED BY '\n' --> Indicamos o salto de línea

Permitir conexións non locais a MySQL

mysql> GRANT ALL ON *.* TO usuario@'202.54.10.20' IDENTIFIED BY 'PASSWORD';

Obter UTM a partir de coordenadas xeográficas en graos, minutos e segundos

select cod_escola,
    AsText(Transform(GeomFromEWKT('SRID=4326;POINT( -'
        || gr_lon + min_lon/60 + seg_lon/3600 || ' '
        || gr_lat + min_lat/60 + seg_lat/3600 || ')'), 23029))   
from (
select cod_escola,
    cast(split_part(lat, ' ', 1)  as numeric)  as gr_lat,
    cast(split_part(lat, ' ', 2)  as numeric)  as min_lat,
    cast(split_part(lat, ' ', 3)  as numeric)  as seg_lat,

    cast(split_part(lon, ' ', 1)  as numeric) as gr_lon,
    cast(split_part(lon, ' ', 2)  as numeric)  as min_lon,
    cast(split_part(lon, ' ', 3)  as numeric) as seg_lon
from (
SELECT cod_escola, corrdenadas,
    split_part(replace(corrdenadas, ',','.'), ';', 1) as lat,    
    split_part(replace(corrdenadas, ',','.'), ';', 2) as lon
  FROM coordenadas
) as vw ) as vw2

Cambio de proxección en PostgreSQL

SELECT AsText(Transform(GeomFromEWKT('SRID=23029;'||'POINT(' ||"Coordenada_X" || ' '    || "Coordenada_Y"  || ')'), 4326))
FROM TaboaConCoordenadas

Fiddler Web Debugger - A free web debugging tool

Fiddler Web Debugger - A free web debugging tool

Table functions en PostgreSQL

CREATE FUNCTION a_concellos(int) RETURNS setof concellos AS '

   SELECT id_con, municipio, id_provincia
  FROM concellos
  where id_provincia = $1
  ;
 
' LANGUAGE SQL;


select * from a_concellos(3);