XMLType, queries to XML
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 this is similar to XMLType in Oracle. Someone knows how can i do it, if there is some software or utility. Thanks: Enrique Excuseme by my english ___ 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://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Scripts with arguments
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 Webcam, voz, caritas animadas, y más... http://messenger.yahoo.es -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Scripts with arguments
Hello, I think I have explained bad. I want to pass the arguments to the sql script. The argument is for the sql script. For example: myscript.sql should be: GRANT ALL PRIVILEGES ON *.* TO 1@'%' where 1 would be parameter 1 I want to do something like that: dosmysql mysql -u root -p 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://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Problems with spatial extensions
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! 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://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problems with spatial extensions
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 server version for the right syntax to use near 'GEOMETRY)' at line 1 I'm running server mysqld-nt version 4.0.13 on a windows NT, the mysql client is the same version. Have I to install some plug-in or change some option in the configuration file? I need help. Thanks and excuse me by the english (I'm spanish). Enrique ___ 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://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]