sbayeta

Hi, I have an app that needs a DBMS in order to work. It can be any ANSI SQL compliant DBMS. The app is working fine with MySQL, and this is my preferred database. I distribute my app without a database, and my customer is supposed to install any supported DBMS and create an ODBC connection. Does anyone know if my customer needs to buy a license if he/she chooses MySQL ? I asked this question to the comercial department of MySQL AB, but they didn\'t answer. Thanks

Thanks biopv. I found that yesterday, and it works fine. But doing some further researching, I discovered that there are ANSI SQL ways to do this: SELECT CASE value WHEN 0 THEN offnick ELSE onnick END AS val;

Hi, I have a table with the fields \"id\", \"value\", \"value_on_nick\" and \"value_of_nick\", and some rows that look like: | id | value | value_on_nick | value_off_nick | |-------|-------|---------------|----------------| | item1 | 0 | abnormal | normal | | item2 | 1 | cold | hot | Is it possible to create a query that will return the item id and the nick corresponding to the value ? Like | id | nick | |-------|--------| | item1 | normal | | item2 | cold | Thanks!

This crontab is part of the OS or part of mysql ? Could you please giveme some more detail ? I\'m new to this

Hi, Is it possible to schedule batch processing on a mysql server ? I need to execute some queries periodically and store the results on a table. Is that possible ?