[License: do I need one ?]

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

[SQL question. Is it possible to....]

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;

[SQL question. Is it possible to....]

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!

[Scheduled queries]

This crontab is part of the OS or part of mysql ?

Could you please giveme some more detail ? I\'m new to this

[Scheduled queries]

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 ?