XMLType, queries to XML

2003-09-19 Thread Enrique Andreu
I would like to do queries to a field TEXT that contains an XML text. If for example I have an entry with the text: titleMyTitle/title When i do the query to search words containing the word title I would like to obtain MyTitle and not title /title because these are tags of the XMLType I think

Scripts with arguments

2003-08-29 Thread Enrique Andreu
Hello. I have to do an script to create MySQL users, the name of the new user have to be a parameter of the script. I have no idea, someone can helps me. I'm an NT user. Thanks: Enrique Andreu ___ Yahoo! Messenger - Nueva versión GRATIS Super

RE: Scripts with arguments

2003-08-29 Thread Enrique Andreu
myscript.sql argument But I don´t know how to do it. Thanks: Enrique Andreu ___ Yahoo! Messenger - Nueva versión GRATIS Super Webcam, voz, caritas animadas, y más... http://messenger.yahoo.es -- MySQL General Mailing List For list archives: http

RE: Problems with spatial extensions

2003-08-14 Thread Enrique Andreu
Firstable thanks for all, now I have two more questions: The first, I would like to know if the JDBC driver supports the spatial extensions, and the second question is how much stable is version alpha 4.1 of MySQL? Thanks: Enrique ___ Yahoo!

Problems with spatial extensions

2003-08-05 Thread Enrique Andreu
Hi, I would like to have a column of a table of the type GeometryCollection, but when I try to type a simple example like the ones in the manual, I get this: mysql CREATE TABLE geom (g GEOMETRY); ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL