group by _date_

Hello, I have a table bill like when (date), how_much (float), what (varchar). Now I store some bills on it - how_much will get numbers with 2 digits after point. Then I want to know how much money I spent each month. SELECT SUM(how_much), YEAR(when), MONTH(when) FROM bill GROUP BY

Re: group by _date_

Thanks, Roger Baklund wrote: * [EMAIL PROTECTED] Hello, I have a table bill like when (date), how_much (float), what (varchar). Now I store some bills on it - how_much will get numbers with 2 digits after point. Why do you think that? Note that FLOAT is an approximate numeric type. The value

Re: MySql-PHP-Zlib-LIBJPEG-GD

Hi Jumac, Jumac wrote: Greetings all, Special greetings to Nathan,Andrew and Jan for previous help. I have some new problems ( big surprise! ) some of which will seem stupid for sure but i'm using the excuse of being a newbie..so i should be forgiven :-). 1.Like i said before I am

Re: --- MySQL

Very interesting conversation, ... íÙ ÎÅ ÇÏ×ÏÒÉÍ ÐÏ ÒÕÓÓÊÉ :-) Adib. maxim wrote: Hello Victoria, Wednesday, April 10, 2002, 3:07:01 PM, you wrote: VR Hello maxim, VR Wednesday, April 10, 2002, 2:14:54 PM, you wrote: m ñ ÐÉÛÕ ÄÉÐÌÏÍ, É-ÎÅÔ ÍÁÇÁÚÉÎ MySQL+php+Apache .. m

Re: mySQL and innoDB

... but the key NULL does not exist on the table a, but it should!!! Adib. Alain Del Giust wrote: Nope insert into b values ('BBB',null); here: BBB is PK of table b null is FK of table b referencing table a for example insert into b values ('BBB','aaa'); works well Alain

Re: Write query to text file

Hi, RTFM see at INTO OUTFILE Adib. Isak Badenhorst wrote: Hi everyone My problem is as follows. I need a c program to run a query on the mysql database and then write the results into a text file. I am running the mysql on a Linux machine. I am new to mysql and according to another

Re: mysqldump : help needed very urgent

Hi, as far as we are waiting for 3.23.50 this sounds as a stable version to do a backup. :-) But I wonder weather there is also a binary backup for this case? Lets say copy all tables and store in a zip (for ISAM tables ok but InnoDB???), or make a mysqlhotcopy. Adib. Chetan Lavti wrote:

Re: Writing an SQL Parser and Optimizer

Let us know your results ... Adib. Keith C. Ivey wrote: On 19 Mar 2002, at 18:14, Michael Halcrow wrote: Any suggestions as to where to start? There's a Perl module called SQL::Statement that does SQL parsing: http://search.cpan.org/search?dist=SQL-Statement

mysqldump and foreign keys

Hi, I just installed the MySQL max 4.0.1 and created a database with two INNODB and FOREIGN KEY tables as described in the Docs. When I run the mysqldump -a -B -c test I don't get the foreign key information. Any hint? Adib.

[Fwd: Re: query mysql db from a bash script?]

-- WIGE DATA GmbH Wiesenring 11, D-04159 Leipzig, Germany Adib Taraben Electronic Engineer PHONE +49 (0)341 - 46 21 100 FAX +49 (0)341 - 46 21 400 E-MAIL [EMAIL PROTECTED] INTERNETwww.wige-data.de A company of WIGE MEDIA AG

Re: all databases deneid

Hi, I don't about your special problem ... I also run MySQL on Win32 (WIN2000). It seems to me that someone made a GRANT and denied everyone from localhost to your database. You can try from an other PC or use GRANT to give everyone from localhost access to the database. Adib. alan4100