Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. comadreja

    Help with UDFs

    Hello, i´m using the MySQL 3.23.57 version and Suse 7.1, and i´m having problems implementing UDFs (User Definable Function) and native function. I really, really need it in order to add my own function named Get_Update, can anybody help me?
  2. comadreja

    Adding functions

    Hello, anybody knows how to add more functions to the Mysql 3.23.57 version? I read about native functions, but i´m not able to make it work. Thanks
  3. comadreja

    Native functions

    Hello, i want to add a native function to my Mysql. I have de 3.23.57 version (the source code) and i follow the steps in the manual, but in the very first one i get a compilation problem. I add a line (similar to the ABS function) to the lex.h file, but it says it isn´t declared in the scope...
  4. comadreja

    Stored procedures?

    Hi, I would like to add a function to my MySQL which can be called as a command, something like this: BEGIN; INSERT INTO table1 VALUES (...); INSERT INTO table2 VALUES (...); DELETE FROM table1, table2 WHERE ...; GET_UPDATE(); COMMIT; where GET_UPDATE is my function. Anybody can help me...
  5. comadreja

    Using the DEBUG option to get traces

    I´ve tried the debug option (./safe_mysqld --user=mysql --debug &) and it seems to do fine, but when i look for the trace file and i can`t find it anywhere, even using the linux´s search engine. I´ve also tried --debug=/tmp/ and --#, as it is said in the tutorial, but i´m not able to make the...
  6. comadreja

    Using the DEBUG option to get traces

    But what i need is to get the Mysql trace, i mean, the list of functions that were used and the values of the variables. I know there is an option that you can use when you launch the mysqld, then you star working with the mysql prompt and when you finish there should be a file with the...
  7. comadreja

    Using the DEBUG option to get traces

    Hello, im using the Mysql-3.23.57 and i have a big problem. I want to get the trace of a query, but i don´t know how to use the debug command. When i launch the server i do this: shell>./safe_mysqld --user=mysql & and then shell>./mysql -p always working as root. I´ve tried adding the...
  8. comadreja

    Need help with the Update command

    Hi, i recently started using mysql and have a problem. How can i run a multi-table update? I mean, update one table regarding the results of a search in another table, like this: UPDATE software,hardware SET software.name = 'example' WHERE sofwtare.company IN (SELECT hardware.company FROM...

Part and Inventory Search

Back
Top