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 86400

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 or myisamchk -d -v .Thank you sir for your reply. Actually i haven't made the qu

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. > > I would like to allow the users to be able to see where they stand > rank > wise with everyone else. > Right now I bas

RE: if you know please answer immediately

And, by the way the myisamchk command will be myisamchk -dvv 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 mysqlmysql

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

RE: if you know please answer immediately

Dear Sirisha, The command "show table status from " 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 25, 2004 12:30

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 ple

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 partic

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 fi

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 À : mysql

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. Merr

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 t

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)

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 "Sub-T

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 Hel