Re: Mysql-4.1.8 library name bug

. Yes, this has been reported on this list a couple times already. Really baffling how this one made it out of QA. Thank you for your answer. Are there any plans to release snapshort bugfix? Josh On Thu, 23 Dec 2004 21:43:27 +0200 (EET) Andrey Kotrekhov [EMAIL PROTECTED] wrote: SQL Hello, All!

Sum on Float type

Hi, I created a Transaction table with a field Cost which is a Float type with only 2 precision eg. 123.01. When I use the following sql statement to make a sum of this field, it returned a Float number with more than 2 precision numbers eg. 456.92384933 select t.custcode, sum(t.cost) as

Re: Query Help, Two Tables...

Jason Caldwell wrote: Hi I have two tables; tbl_Headers and tbl_SubItems. tbl_Headers contain my Header Items such as (fields: ID HEADER) ID HEADER --- 1.00 TOPIC ONE 2.00 TOPIC TWO 3.00 TOPIC THREE tbl_SubItems contain Sub Header Items such as (fields: ID SUBITEM)

Out of memory

Hi, mysqldump returns with this error on one of my nightly batch : mysqldump: Out of memory (Needed 8164 bytes) mysqldump: Got error: 2008: MySQL client run out of memory when retrieving data from server Fri Dec 24 00:00:22 CET 2004 Is there any way to avoid this particular error ? (bear I mind

Re: Optimising a query on a large table.

Thanks to all that replied, it turns out that the great delay was due to the use of the like opperator, I did have an index on person_id + session_start, just a thought though, using this will mysql pull out data ordered as per the index? Yes, sql is VERY limited, thanks for the pointers. Merry

RE: Sum on Float type

You can use the format() function: select t.custcode, format(sum(t.cost),2) as Sub-Total from customer c, transaction t where c.custcode = t.custcode group by t.custcode Marc. -Message d'origine- De : sam wun [mailto:[EMAIL PROTECTED] Envoyé : vendredi 24 décembre 2004 11:23 À :

Re: Sum on Float type

sam wun wrote: I created a Transaction table with a field Cost which is a Float type with only 2 precision eg. 123.01. When I use the following sql statement to make a sum of this field, it returned a Float number with more than 2 precision numbers If I should not use Float type for the Cost

Re: Out of memory

Philippe Poelvoorde wrote: Hi, mysqldump returns with this error on one of my nightly batch : mysqldump: Out of memory (Needed 8164 bytes) mysqldump: Got error: 2008: MySQL client run out of memory when retrieving data from server Fri Dec 24 00:00:22 CET 2004 Is there any way to avoid this

if you know please answer immediately

I am a student and we are doing a project in mysql database monitoring. 1 . we found that the memory used and free memory available for tables in individual database is given by myisamchk -d -v command.But we don't have any information about the tables or files myisamchk works on.so please

RE: if you know please answer immediately

Dear Sirisha, The command show table status from Database_Name will give you the details pertaining to the type of the table(MyISAM/InnoDB) and also the memory used. Hope this helps you. -Harish -Original Message- From: sirisha gnvg [mailto:[EMAIL PROTECTED] Sent: Saturday, December

Re: Data conversion question

Thanks Konrad, Yves On Thu, 23 Dec 2004 23:28:31 +0100, Konrad Kieling [EMAIL PROTECTED] wrote: Does MySQL have commands that would allow me to convert Base64 data to Binary and then convert that Binary to a string format? have a look at the attached file (hope the attachment did not get

RE: if you know please answer immediately

And, by the way the myisamchk command will be myisamchk -dvv table_name Eg: $ cd /home/mysql-data/data/test Considering the mysql data path is set in /home/mysql-data/ Here test is the database name. $ll -rw-rw1 mysqlmysql8660 May 17 2004 abc.frm -rw-rw1 mysql

Re: Calculating User Ranks (SQL Query Question)

On 22-Dec-2004 Michael J. Pawlowsky wrote: I’m trying to come up with a more efficient method to do this. I have a table where people enter some info into the table. snip I would like to allow the users to be able to see where they stand rank wise with everyone else. Right now I

if you know the answer,please answer immediately contd

I am a student and we are doing project in mysql database monitoring.Yesterday I posted my doubts regarding that project to this forum. I got reply from Mr.Harish, his suggestion is to use show table status database name or myisamchk -d -v table_name .Thank you sir for your reply.

how to get Previous date

I have a price table entered more than once every day, In the report for spesific day, I must show also the last entered price for the day before The problem is that the day before sometimes varies not fixed (if it is fixed I could just round down the required date substract the date with