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 you

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 (YEAR(when)*1

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

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+Apach

Re: MyODBC on win98

Hello, You wrote you use BDE urg, I jumped to the ADO-components. I feel they are much faster. Currently I use mysql 4.0.1 and the myODBC 3.51 without an error. Before this I used mysql 3.23 and myODBC 2.50 without error. Adib. [EMAIL PROTECTED] wrote: > hi, > i'd like to know which ODBC driv

Re: database -> er diagram

There was a former posting here: At 09:19 AM 4/4/2002, you wrote: Can someone please recommend CASE tools that function well with MySQL databases? Need to do some reverse engineering ... create the ERD, data dictionary, etc Regards, Michelle Smith Michelle, CaseStudio 2 is quite g

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 >

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 a

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: > t

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

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 wrote:

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

Hi, If you can't read that output, try the select * from mytable INTO OUTFILE "absolutepath/myfile.txt" FIELDS TERMINATED BY "," LINES TERMINATED BY "\r\n" statement. I do somthing with this :-) Adib. chad kellerman wrote: > Takacs, > >I think you can use > > mysql --execute= databas

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