Re: Unexpected Select Output

2011-03-14 Thread Johan De Meersman
Probably not the cause, but you should know that and binds more tightly than or, so what you've written is actually WHERE (table_name = 'hc_categories') OR (table_name = 'hc_master') OR (table_name = 'hc_web' AND table_schema = 'pdc_crawler') What you probably mean is WHERE (table_name = 'h

Unexpected Select Output

2011-03-14 Thread Adarsh Sharma
Dear all, Today I shoot a query to know the size of tables in a particular database, but don't know why it prints only the output of only one table. Here is my query & output : mysql> SELECT table_schema 'database',table_name 'Table', concat( round( sum( data_length + index_length ) / ( 1024

Benetl a free ETL tool using MySQL is out in version 3.7

2011-03-14 Thread Benoît Carpentier
Dear all, Benetl, a free ETL tool for files using MySQL, is out in version 3.7. You can freely download it at: www.benetl.net This version brings new controls and messages in the GUI. This version brings improvements and a bug correction in GUI. You should update. You can learn more about ETL

Re: "IF"

2011-03-14 Thread Johan De Meersman
- Original Message - > From: "Sándor Halász" > > Does the _function_ 'IF' always evaluate its arguments? or only the > two that it is needful to evaluate? I'm afraid I'm not authoritative on this, but it seems to me that it would be very very bad if the third, unused expression were to

"IF"

2011-03-14 Thread S�ndor Hal�sz
Does the _function_ 'IF' always evaluate its arguments? or only the two that it is needful to evaluate? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Table Records Deleted by anonymous user!

2011-03-14 Thread Joerg Bruehe
Hello! Johan De Meersman wrote: >> From: "Vikram A" > >> Thank you for info. Now we enabled the logs. The DB administrator >> itself made a mistake that he restored the back up > > This may be obvious, but keep your logs on separate disks if you can - full > query logs take quite a bit of I/O

How to know Data Size through Scripts

2011-03-14 Thread Adarsh Sharma
Dear all, I am research on several commands through which I can monitor the size of specific data of tables in different . I want to write a script that fetches the data of different database tables & databases too daily and write it into a file . Is there is any way or commands to achieve