How to handle sum(distinct ) ???

2001-12-25 Thread aravind gorthy
Hai, Could any one tell me how to handle sum(distinct ) concept in MySQL 3.23.40. thanks in advance. Aravind = Aravind Gorthy, VisualSoft Technologies. For Stock Quotes, Finance News, Insurance, Tax Planners, Mutual Fu

Loaddata in file ?

2001-12-25 Thread Rahul Torvi
Hi, Can I insert the data in database that is residing at remote server using loaddata in file query ? If yes then please give me the syntax for same. Kind Regards Rahul Torvi - Before posting, please check: http://www.mysq

RE: we are running MySQL w/php. When trying to connect to thedatabase via mysqlGUI from a win200o work

2001-12-25 Thread Cal Evans
check your permissions on mysql. If you are trying to log in as root then make sure that you either have a record in the mysql.user table where user=root and host=ipaddress or user=root and host=% If you make a change the make sure you flush privileges. Cal -Original Message- From: Way

we are running MySQL w/php. When trying to connect to thedatabase via mysqlGUI from a win200o work

2001-12-25 Thread Wayne McCloud
we are running MySQL w/php. When trying to connect to the database via mysqlGUI from a win200o workstation, we get the following error: access denied for user: 'root@ipaddress' (Using password: Yes) - Before posting, pleas

Re: Stored Procedure

2001-12-25 Thread Cafetechno
Thanks Sinisa, One question again : If mysql will include the stored procedure feature, what kind of langguage to be used for the stored procedure ? regards cafe - Before posting, please check: http://www.mysql.com/manual.

Re: help bad

2001-12-25 Thread Alexander Skwar
So sprach »Webmaster« am 2001-12-25 um 10:30:47 -0500 : > i meant 3.23.. just so you all know Fine... And the problem is...? Filter: sql Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to (english) Homepage: http://www.iso-top.de | Jabber: [EMAI

Jdbc Help

2001-12-25 Thread Hari Yellina
Hi Guys, I am using mm.mysql driver, to connect to mysql. I have placed in lid of tomcat and given classpath as well. But it says driver cannot be found. Can you guys help. Thank you Regards, Hari Yellina. Hari Yellina www.yellina.com Victoria Australia --

problem with mysql

2001-12-25 Thread Юра_К
Hello I install MySQL server from .rpm (as root) On one mashine he work normal without configuration, but on second server didnt work. I show bugreport(created with bug-script) and error file,what writen in /var/lib/mysql/data... (user mysql exist and group exist also...i am check) Tell me ,please

Help Replication: Cleanup after failover

2001-12-25 Thread Steve Rapaport
Please help, I've read through the manual and this case is suggested but not really laid out. I'm using mysql 3.23.37 and can't upgrade to 4.0 yet. Okay, I've got replication on 2 machines with a one-way failover setup: Master fails, slave takes over. Now the slave has been recording updates f

Re: MySQL 4.0.1 released

2001-12-25 Thread Gordan Bobic
On Monday 24 Dec 2001 06:37, Michael Widenius wrote: > - A Query cache to cache results for SELECT statements. This should > give a major speed improvement for queries on read-intensive tables. > More information can be found at: > http://www.mysql.com/doc/Q/u/Query_Cache.html This is a ra

RE: using ASP with MYSQL

2001-12-25 Thread Venu
> -Original Message- > From: Milder Lisondra [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 24, 2001 3:48 PM > To: '[EMAIL PROTECTED]' > Subject: using ASP with MYSQL > > > Has anyone used or tried to use Activer Server Pages with MYSQL. > I am currently working on a project current

Re: GUI for Windows

2001-12-25 Thread Curtis Maurand
Microsoft Access or Visual Basic. Use the ODBC connectors. Curtis On Mon, 24 Dec 2001, John Mayson wrote: > Eventually my databases will be on my Linux system. In the meantime, is there a > Windows program that builds a quick and dirty GUI interface for my SQL databases? > > Thanks, > John

Re: help bad

2001-12-25 Thread Webmaster
i meant 3.23.. just so you all know -- Original Message -- From: "Webmaster" <[EMAIL PROTECTED]> Reply-To: <[EMAIL PROTECTED]> Date: Tue, 25 Dec 2001 10:26:50 -0500 >i went through my code 20 times.. hit the help sites and all to see if it was a linux >pr

help bad

2001-12-25 Thread Webmaster
i went through my code 20 times.. hit the help sites and all to see if it was a linux problem or what.. i am running 4.05 php 2.23.37 mysql (i believe, been awhile sine i touched it *l*) its definately 2.23 i can say i even got the 2.1 gd installed with it thought took a week still shows as 1.6 t

help please!-- i -hate imail! *l* which is why ask a cc to my reg account

2001-12-25 Thread Webmaster
Back | Next | Reply | Reply All | Forward | Delete | Move To database / sql/ mysql Message: 1 of 11122 Printable Version From: [EMAIL PROTECTED] Save Address Date: 25 Dec 2001 15:14:07 - To: "Webmaster" <[EMAIL PROTECTED]> Subject: Re: Re: Need Help bad!.. today.. of a

Re: Need Help bad!.. today.. of all days!

2001-12-25 Thread Brad Beaubien
>Hello.. of all days i have a project thats to be shown tomorrow. > >i cannot get the dam thing to work >it should be simple i'd think > >i would post code and all and if asked will [snip] Is the performance of your code "data independent"? That is to say, if you remove (from the database) the se

I can't think....

2001-12-25 Thread Sherzod Ruzmetov aka sherzodR
I have a column with a date in the future. Trying to figure out a query that would tell me how many days, mins left till that date. I'm realy tired, and can't think right now :( - Before posting, please check: http://www.my

Re: Need Help bad!.. today.. of all days!

2001-12-25 Thread Webmaster
hope you version came out better thn mine.. in my mail it was all out of shape.. maybe could attach a text file.. doubt the list allows that thoough "alot dont" -- Original Message -- From: "Webmaster" <[EMAIL PROTECTED]> Reply-To: <[EMAIL PROTECTED]> Dat

Re: Need Help bad!.. today.. of all days!

2001-12-25 Thread Webmaster
the code is huge i'll post whats relevant. there may be a few irrelevant things in there... but hell... if your willing to look i'm willing to post i know what works so will skip down lower to prevent wasting your time and if ya could please cc your responce to [EMAIL PROTECTED], though if t

Re: mysql hangs on ANALYZE, open

2001-12-25 Thread Sinisa Milivojevic
David Birnbaum writes: > >Description: > mysqld still seems to hang when nightly table checks are running. > Formerly, this seemed to be due to a race condition that was > hopefully fixed in 3.23.46. Server is up, but all queries are stuck > in "opening tables". mysqld

Re: Need Help bad!.. today.. of all days!

2001-12-25 Thread Justin Farnsworth
I think you need to post the code. The description of the problem is a bit ambiguous. _justin Webmaster wrote: > > Hello.. of all days i have a project thats to be shown tomorrow. > > i cannot get the dam thing to work > it should be simple i'd think > > i would post code and all and if aske

mysql hangs on ANALYZE, open

2001-12-25 Thread David Birnbaum
>Description: mysqld still seems to hang when nightly table checks are running. Formerly, this seemed to be due to a race condition that was hopefully fixed in 3.23.46. Server is up, but all queries are stuck in "opening tables". mysqld is taking 100% of one CP

Need Help bad!.. today.. of all days!

2001-12-25 Thread Webmaster
Hello.. of all days i have a project thats to be shown tomorrow. i cannot get the dam thing to work it should be simple i'd think i would post code and all and if asked will but it comes down to this.. i am using php 4 and mysql.. and doing math i have say 40 entries in the database, 20 for two

Re: How to make use of mysql++ with gcc 2.96

2001-12-25 Thread Sinisa Milivojevic
Fournier Jocelyn [Presence-PC] writes: > Hi, > > I have a question about gcc 3.0.3 : since I have installed it, it refuses to > compile because it detect c++ as a crosscompiler : > > checking whether the C++ compiler > (c++ -Wimplicit -Wreturn-type -Wid-clash-51 -Wswitch -Wtrigraphs -Wcomment -

Re: How to make use of mysql++ with gcc 2.96

2001-12-25 Thread Sinisa Milivojevic
Fournier Jocelyn [Presence-PC] writes: > Hi, > > I have a question about gcc 3.0.3 : since I have installed it, it refuses to > compile because it detect c++ as a crosscompiler : > > checking whether the C++ compiler > (c++ -Wimplicit -Wreturn-type -Wid-clash-51 -Wswitch -Wtrigraphs -Wcomment -

Re: How to make use of mysql++ with gcc 2.96

2001-12-25 Thread Fournier Jocelyn [Presence-PC]
Hi, I have a question about gcc 3.0.3 : since I have installed it, it refuses to compile because it detect c++ as a crosscompiler : checking whether the C++ compiler (c++ -Wimplicit -Wreturn-type -Wid-clash-51 -Wswitch -Wtrigraphs -Wcomment - W -Wchar-subscripts -Wformat -Wimplicit-function-dec

Re: How to make use of mysql++ with gcc 2.96

2001-12-25 Thread Sinisa Milivojevic
luhar-123 writes: > Hi guys, >i have installed red hat linux 7.2 and mysql server version 3.23.42. but i need >mysql++ also.but it seems that gcc version 2.96 will give lot of problems for >mysql++. can any one pls give me a solution to use mysql++ on linux 7.2. > Get Your Private, Free E-m

Re: Bug Report

2001-12-25 Thread Sinisa Milivojevic
Michael Cook writes: > Hi folks, > Here is a bug report using the bug tool... > [skip] > > Thanks!!! > Michael > == CigarPool == > http://www.cigarpool.com > > Hi! You should check why your configure is broken. Instead of lines : configure:1592: checking whether the C++ compi