Re: Date interval problem

2001-10-05 Thread Chris Johnson
This should be pretty close to what you need, if I understand your situation: Select * From mytable Where (querydate1 > tabledatelow And querydate1 < tabledatehigh) And (querydate2 > tabledatelow And querydate2 < tabledatehigh); I'm assuming you know which of the two dates in the tab

Re: CPU maxed out when database grew larger than 5 GB

2001-10-05 Thread Chris Johnson
David, I don't know the answers to your biggest problem, but do know the answer to your last question: Yes, it seems perfectly normal to nail one CPU and take 2 minutes to show tables with 80,000 tables. Somewhere on your system is a directory that has 240,000 files (80,000 tables times 3 files

Re: Party!!!

2001-10-05 Thread can
I can't login to your website. Kenneth. - Original Message - From: "Deryck Henson" <[EMAIL PROTECTED]> To: "Maximiliano Lucius" <[EMAIL PROTECTED]> Cc: "MySQL" <[EMAIL PROTECTED]> Sent: Friday, October 05, 2001 4:27 PM Subject: Re: Party!!! > Well, I run a website ( Source Code Cafe

First? or Last?

2001-10-05 Thread bestbiz4u
Dear Friend, Are you looking for your first Internet business...or your last? If it's your first, I bet you'd like it to be your last! Your last would be the one that allows you to achieve your full time income on a part time basis, is stable, will be there for your heirs, and give you the

Re: DBI Background (fork) CGI causes Error 2013

2001-10-05 Thread Alex Menendez
Ok, I updated max_allowed_packet to 16M and the same problem still occurrs. I think the issue is with fork because DBD errors out right after the first db insert that the child process does. Is there a bug for this? I have DBI->trace(3) turned on and the errors it gives are not very descript

Lost connection CRASH!!!!

2001-10-05 Thread Tony Lembke
Hi, MySQL 3.22.32 has worked well on my bsd system until recently when there are frequent crashes. I think this is related to an increase in table size. It happens episodically but can be consistently reproduced with a command such as this - mysql> alter Table KeywordIndex add Index(MessageI

RE: DSN-Less connections using MyODBC?

2001-10-05 Thread Venu
Hi ! > -Original Message- > From: Sylvain Hamel [mailto:[EMAIL PROTECTED]] > Sent: Friday, October 05, 2001 5:34 PM > To: [EMAIL PROTECTED]; MySQL Mailing list > Subject: Re: DSN-Less connections using MyODBC? > > > Hi Venu, > > > It doesn't depend upon OPTION value. Can you change the fo

Re: DSN-Less connections using MyODBC?

2001-10-05 Thread Sylvain Hamel
Hi Venu, > It doesn't depend upon OPTION value. Can you change the following > parameters and try it out. > > 1. UID instead of USER NAME > 2. DATABASE or DB instead of DATABASE NAME > 3. PWD instaed of PASSWORD I assume USER NAME and PASSWORD are right since the parser recognizes them correctly

Change Date

2001-10-05 Thread mickalo
Hello All, I've got a slight delima, and was hoping someone maybe able to help me out. We got a project where a client currently has a table with various dates in it. The problem is, when it was orignial coded, the person formatted the date before it was entered into the table, mm/dd/. There'

Re: MySQL caching.

2001-10-05 Thread Tonu Samuel
On Fri, 2001-10-05 at 21:49, xiaofeng wang wrote: > Hi there, > > Does anybody know where to find documentation about MySQL caching? > Our official policy is to include everything in MySQL manual which is accessible on http://www.mysql.com About caching - depends what you mean. Query/Result ca

Re: InnoDB Tables/Databases

2001-10-05 Thread Tonu Samuel
On Fri, 2001-10-05 at 23:59, Benjamin Pflugmann wrote: > Hi. > > Heikki, please correct me, if I say something stupid. ;-) > > On Fri, Oct 05, 2001 at 10:07:04AM -0700, [EMAIL PROTECTED] wrote: > > Deryck, others: > > > > I'm doing some reading on InnoDB and am pretty ignorant on the subjets. >

Re: Bizarre query performance

2001-10-05 Thread Boyd Lynn Gerber
On Fri, 5 Oct 2001, Dan Nelson wrote: > This rules out mysql as the cause for the delay. I agree. > > > I'd say start dumping packets on the network. > > > > I'd agree, but I'm confused as to why a different query (that > > requests more data; 33 rows vs 1) can reliably execute and fetch in > >

RE: DSN-Less connections using MyODBC?

2001-10-05 Thread Venu
Hi !!! > -Original Message- > From: Sylvain Hamel [mailto:[EMAIL PROTECTED]] > Sent: Friday, October 05, 2001 2:26 PM > To: MySQL Mailing list > Subject: Re: DSN-Less connections using MyODBC? > > > Thx for the quick response... > > Here's my connection parameters. I always get invalid pa

Re: Bizarre query performance

2001-10-05 Thread Dan Nelson
In the last episode (Oct 05), Philip Brown said: > > What are your timings if you run your client on the SCO box? mysql > simply reports a query time of 10ms or less (0.01s). Of course, this > doesn't have any network overhead. This rules out mysql as the cause for the delay. > > I'd say star

RE: Bizarre query performance

2001-10-05 Thread Boyd Lynn Gerber
On Fri, 5 Oct 2001, Philip Brown wrote: > > How is your DNS, WINS,... setup? SCO/Caldera UNIX can use DNS when you do > > not think it will. Most SCO/Caldera tcp what ever will do a forward and > > reverse DNS look-up. I can add entries in the MS machines in the hosts > > file location MS OS/in

Re: InnoDB Tables/Databases

2001-10-05 Thread Benjamin Pflugmann
Hi. Heikki, please correct me, if I say something stupid. ;-) On Fri, Oct 05, 2001 at 10:07:04AM -0700, [EMAIL PROTECTED] wrote: > Deryck, others: > > I'm doing some reading on InnoDB and am pretty ignorant on the subjets. > Can someone explain why would InnoDB be faster than MySQL? Please not

Re: your mail

2001-10-05 Thread Benjamin Pflugmann
Hi. On Thu, Oct 04, 2001 at 02:43:34PM +, [EMAIL PROTECTED] wrote: > how can i to work with mysql without transactions > and foreign keys with same security, keeping the > integrity of data ? MySQL has transaction support. You can find a try to answer your questions at: http://www

create temporary table if not exists problem

2001-10-05 Thread Ron Bickers
I use the following for creating a temporary table: CREATE TEMPORARY TABLE IF NOT EXISTS tbl SELECT ... This query may be run multiple times by the same client connection since it's part of a Web application. The problem is that if 'tbl' *does* exist, the select command is executed again and

Re: DSN-Less connections using MyODBC?

2001-10-05 Thread Sylvain Hamel
Thx for the quick response... Here's my connection parameters. I always get invalid parameter. DRIVER={MySQL}; USER NAME=myusername; PASSWORD=mypassword; SERVER=10.10.10.45; DATABASE NAME=DatabaseName; PORT=3306; I am pretty sure of the driver name since "MySQL" is the exact string Windows98 OD

RE: DSN-Less connections using MyODBC?

2001-10-05 Thread Venu
Hi !!! > -Original Message- > From: Sylvain Hamel [mailto:[EMAIL PROTECTED]] > Sent: Friday, October 05, 2001 1:36 PM > To: MySQL Mailing list > Subject: DSN-Less connections using MyODBC? > > > Anyone ever tried a MySQL dsn-less connection (I am working > in Borland C++ > Builder)? >

RE: Bizarre query performance

2001-10-05 Thread Philip Brown
> I suppose your test program connects, and loops the same query multiple > times in the same session? (Just to rule out connect/disconnect > overhead) Of course. I also run the same query multiple times, to eliminate caching issues. Performance on successive iterations is the same as on the fir

RE: Bizarre query performance

2001-10-05 Thread Philip Brown
> It doesn't look like you are using an index. Have you tried creating one > and seeing what the effect on execution time is? What makes you think the index isn't being used? EXPLAIN SELECT * FROM X WHERE (PRIMARY KEY) = N looks like it is using the primary key. However, just to check I created

RE: Bizarre query performance

2001-10-05 Thread Philip Brown
> How is your DNS, WINS,... setup? SCO/Caldera UNIX can use DNS when you do > not think it will. Most SCO/Caldera tcp what ever will do a forward and > reverse DNS look-up. I can add entries in the MS machines in the hosts > file location MS OS/install dependent and very times. All machines ha

DSN-Less connections using MyODBC?

2001-10-05 Thread Sylvain Hamel
Anyone ever tried a MySQL dsn-less connection (I am working in Borland C++ Builder)? I can do it with a dsn but can't seem to make connection in dsn less. - Before posting, please check: http://www.mysql.com/manual.php

killing mysql query after Apache(PHP) stops.

2001-10-05 Thread Johannes B. Ullrich
For a web site with a relatively large database, I have a very anoying problem. At times, the response time is getting quite slow. As a result, the pages either time out, or even worse the user presses 'stop/reload'. However, the queries will continue to run even after the user pressed stop.

Re: Party!!!

2001-10-05 Thread Deryck Henson
Well, I run a website ( Source Code Cafe ) and I guess on the night of the release, we could all meet there! I have a chat set up as well as message boards and I might even decorate a bit. If anyone would like to help by offering a backup server, please email. We might have too many people

MySQL caching.

2001-10-05 Thread xiaofeng wang
Hi there, Does anybody know where to find documentation about MySQL caching? Thanks. Xiaofeng Wang - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the l

Re: DBI Background (fork) CGI causes Error 2013

2001-10-05 Thread Alex Menendez
To this matter even if the actual insert text for this message is under 16M? I actually did increase it to 10M but according to your suggestion...this is not enough. thanx again, -amen On Fri, 5 Oct 2001, Jani Tolonen wrote: > Alex Menendez writes: > > Hello, All > > Hi Alex, > > > I bu

Re: Bizarre query performance

2001-10-05 Thread Dan Nelson
In the last episode (Oct 05), Philip Brown said: > Server: SCO OpenServer V3.2 R5.0.5, AMD K6-2 350Mhz CPU, 128Mb RAM > mySQL: 3.23.39, compiled by me to avoid use of libraries, using latest > available pthreads > > Clients: Win32 machines (more detail later). > > There are 2 times I am interest

Replication Retries

2001-10-05 Thread Dave Greco
I have setup replication between two 3.23.43 servers. Replication is working properly during normal circumstances, but when I shutdown mysql on the master, the slave never reconnects. An entry is made in the slave's error log stating that it will reconnect in 60 seconds, but then if I bring th

RE: parse error near ???

2001-10-05 Thread Carsten H. Pedersen
> Ok, so I can't get the FAQ to load. It gives forth lots of PHP errors. > Meanwhile, I have not been able to get very far in the tutorial due to > these parse errors on the examples. I am entering them correctly, I > think. Case should not matter, and here is what I get: > > mysql> select versio

Re: Bizarre query performance

2001-10-05 Thread Russell Miller
It doesn't look like you are using an index. Have you tried creating one and seeing what the effect on execution time is? --Russell - Original Message - From: "Philip Brown" <[EMAIL PROTECTED]> To: "Russell Miller" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, October 05, 2001

Re: Bizarre query performance

2001-10-05 Thread Boyd Lynn Gerber
On Fri, 5 Oct 2001, Philip Brown wrote: > Environment: > > Server: SCO OpenServer V3.2 R5.0.5, AMD K6-2 350Mhz CPU, 128Mb RAM > mySQL: 3.23.39, compiled by me to avoid use of libraries, using latest > available pthreads ... much deleted... > Can anyone give me some assistance with this bizarre b

RE: Bizarre query performance

2001-10-05 Thread Philip Brown
> Have you tried "explain"ing the two select to see where all the time is > being spent and how the queries are optimized? Sorry, I should have included that in my detail. +---+---+---+-+-+---+--+---+ | table | type | possible_keys | key | key

parse error near ???

2001-10-05 Thread Christopher Jay Manders
Hi, Ok, so I can't get the FAQ to load. It gives forth lots of PHP errors. Meanwhile, I have not been able to get very far in the tutorial due to these parse errors on the examples. I am entering them correctly, I think. Case should not matter, and here is what I get: mysql> select version(); E

Re: Bizarre query performance

2001-10-05 Thread Russell Miller
Have you tried "explain"ing the two select to see where all the time is being spent and how the queries are optimized? --Russell - Original Message - From: "Philip Brown" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, October 05, 2001 1:18 PM Subject: Bizarre query performance

Bizarre query performance

2001-10-05 Thread Philip Brown
I have been testing an application that uses mysql on SCO OpenServer and I have discovered some strange query performance. To investigate the matter further, I have written a client program that uses the mysql C API directly so that I can time things exactly. Environment: Server: SCO OpenServer

ERROR COMPILING MYSQL IN DEBIAN

2001-10-05 Thread =EvilNet=
this is the error when y run "make" ar cru libmerge.a open.o extra.o info.o _locking.o rrnd.o update.o delete.o rsame.o panic.o close.o create.o static.o ranlib libmerge.a make[2]: Leaving directory `/root/mysql-3.23.42/merge' Making all in myisam make[2]: Entering directory `/root/mysql-3.23.42/

RE: Service not starting properly

2001-10-05 Thread Woolsey, Fred
Andres, I have precisely the same problem. The problem persists even after installing a newer version of MySQL. Also, the service appears to be running just fine according to the Services MMC applet, but any attempts to access the server result in program freeze-up. Restarting the service fixe

Service not starting properly

2001-10-05 Thread Andres Adamoli
Hello people, here's my problem. I've been using mysql for a while on a win2000pro computer, and everything was working fine. A couple of days ago, the service was not responding after turning on my computer, and I have been restarting the service manually since then every time I boot in order

Error installing mysql on Aix

2001-10-05 Thread Hamid Amjadi
I am getting the following errors when i am trying to install Mysql in my AIX ver 4.3.3. please advise. thanks #!/bin/sh # Create a bug report and mail it to the mysql mailing list # Based on glibc bug reporting script. echo "Finding system information for a MySQL bug report" VERSION="3.23.42"

Re: InnoDB Tables/Databases

2001-10-05 Thread another oracle dba
Deryck, others: I'm doing some reading on InnoDB and am pretty ignorant on the subjets. Can someone explain why would InnoDB be faster than MySQL? From what I read it looks like it will have more overhead to support the transactions and that should decrease the performance rather than improve it.

Basic Install - Server crashes during startup

2001-10-05 Thread Pacheco, Michael F.
Hi, Got my RHLinux box running MySQL at home was a snap - come to work and it will not keep the deamon running. Environment: SuSe Linux 6.4 on an HP Intel server gcc 2.95.2 All installs done off the MySQL site using the Linux i386 packages rpm's Installed - Server, shared libraries, client The

RE: InnoDB Tables/Databases

2001-10-05 Thread Daniel Ouellet
Thanks you for the URL. (:> I just added to my collections. Daniel > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Ilya > Martynov > Sent: Friday, October 05, 2001 04:06 > To: Daniel Ouellet > Cc: Deryck Henson; MySQL > Subject: Re: InnoDB Tables/D

Re: MySQL performance and limit

2001-10-05 Thread David Turner
No problem, MYSQL is great and I know far less about it than I do Oracle. Dave On Fri, Oct 05, 2001 at 06:08:07PM +0200, Tonu Samuel wrote: > On Fri, 2001-10-05 at 17:06, David Turner wrote: > > > > > > BTW, this is unique in MySQL - you can have tables mixed to be > > > transactional (InnoDB) a

Re: MySQL performance and limit

2001-10-05 Thread Tonu Samuel
On Fri, 2001-10-05 at 17:06, David Turner wrote: > > > > BTW, this is unique in MySQL - you can have tables mixed to be > > transactional (InnoDB) and nontransactional (MyISAM) and use them mixed > > in same query. All other SQL-s (as much I know) have transactions on > > Oracle's Global Tempora

Access Denied when using MySQL can I fix or is my host supose to fix

2001-10-05 Thread Emailit2
Problem: I get "Access Denied" when I'm trying to use MySQL. Relevant Error Message: Error: -2147418113 Description: Chili!ASP ADO control - build 3.6.0 SQLState: S1000 Native Error Code: 1045 [TCX][MyODBC]Access denied for user: 'webmaster@localhost' (Using password: YES) My website host said t

SV: privileges for SHOW PROCESSLIST

2001-10-05 Thread Jacob Friis Larsen
>> What privileges should I give my user so that I can do the >> SHOW PROCESSLIST on all databases ? > Process_priv Should I then do : GRANT PROCESS ON mysql.* to shark@'123.123.123.123' identified by 'sharkpassword'; - Befor

privileges for SHOW PROCESSLIST

2001-10-05 Thread Jani Tolonen
Jacob Friis Larsen writes: > What privileges should I give my user so that I can do the SHOW PROCESSLIST > on all databases ? > > Please also reply to my E-mail address. > > :) Jacob Process_priv Regards, - Jani For technical support contracts, visit https://order.mysql.com/ __ ___

mysqld dumps core

2001-10-05 Thread Jani Tolonen
G. Mike Keeney writes: > From: root > To: [EMAIL PROTECTED] > Subject: mysqld dumps core on startup. > > >Description: > The mysqld server dumps core on startup. > >How-To-Repeat: > shell> LIBEXEC/mysqld & > >Fix: > None. > > >Submitter-Id: > >Originator: Mi

Re: MySQL performance and limit

2001-10-05 Thread David Turner
> > BTW, this is unique in MySQL - you can have tables mixed to be > transactional (InnoDB) and nontransactional (MyISAM) and use them mixed > in same query. All other SQL-s (as much I know) have transactions on Oracle's Global Temporary Tables don't write to redo or rollback, and on normal tab

R: InnoDB

2001-10-05 Thread Riccardi Moreno
Thanks Heikki --- - Moreno --- -Messaggio originale- Da: Heikki Tuuri [mailto:[EMAIL PROTECTED]] Inviato: venerdì 5 ottobre 2001 15.08 A: [EMAIL PROTECTED]; [EMAIL PROTECTED] Oggetto: Re:InnoDB Riccardi, your innodb_log_arch_dir is C:\In

Re: Auto Increment Fields

2001-10-05 Thread Kyle Hayes
On Thursday 04 October 2001 13:37, Paul DuBois wrote: > At 4:08 PM -0400 10/4/01, Jason Frisvold wrote: > >Is there a way to have DBI return the value of the auto-incremented field > >upon insert? Or do I have to insert and then do a select afterwards? > > $dbh->do ("your insert statement"); > $a

Re: privileges for SHOW PROCESSLIST

2001-10-05 Thread Carl Troein
Jacob Friis Larsen writes: > What privileges should I give my user so that I can do the SHOW PROCESSLIST > on all databases ? PROCESS, I think, although it's somewhat of a guess. I wish someone with more knowledge about these things could add a clarification to that section of the manual, seein

Get started quickly with MySQL++ under Borland C++ Builder 5

2001-10-05 Thread Sylvain Hamel
I need help in how to use MsSQL++ under Borland C++ Builder 5. I managed to install MySQL and tests seem to indicate that it works fine. I tried to read the manuals but I find the learning curve a bit steep. I am not very experienced in terms of linker options. I'm sure if I examine all the libr

privileges for SHOW PROCESSLIST

2001-10-05 Thread Jacob Friis Larsen
What privileges should I give my user so that I can do the SHOW PROCESSLIST on all databases ? Please also reply to my E-mail address. :) Jacob - Before posting, please check: http://www.mysql.com/manual.php (the manual)

mysqld dumps core

2001-10-05 Thread G. Mike Keeney
From: root To: [EMAIL PROTECTED] Subject: mysqld dumps core on startup. >Description: The mysqld server dumps core on startup. >How-To-Repeat: shell> LIBEXEC/mysqld & >Fix: None. >Submitter-Id: >Originator:Mike Keeney >Organization: Scott & White Hos

RE: Auto Increment Fields

2001-10-05 Thread Jason Frisvold
Thanks everyone.. That's exactly what I needed :) --- Jason H. Frisvold Senior ATM Engineer Engineering Dept. Penteledata CCNA Certified - CSCO10151622 [EMAIL PROTECTED] --- "Only two things are infinite, the universe and human stupidity, and I'm no

Re: Windows Threads Support

2001-10-05 Thread Tonu Samuel
On Fri, 2001-10-05 at 13:24, Jared Richardson wrote: > > > > Yes, you can change any variables shown with SHOW VARIABLES. MySQL reads > > default values from my.cnf file > > > > Actually, on Windows, it seems to read the c:\winnt\my.ini file, not the > my.cnf file. My.cnf is used on the *nix ve

Re: MySQL performance and limit

2001-10-05 Thread Tonu Samuel
On Fri, 2001-10-05 at 12:13, Carl Troein wrote: > It seems to be pretty popular to have a large number of databases, > but I guess it's mostly due to having a large number of users. > In pthe project I'm working on now we have 3 databases, 2 of which > are mysql and test. However, some of our tab

Re: PostgreSQL to MySQL

2001-10-05 Thread Ken Menzel
Hi Jani and Owen, Owen if you are dumping the data using pg_dump, I think I may be able to help. First suggestion is to dump the data and the data schema separetly. use, for schema: pg_dump -sxnc -f/tmp/schema.dump databasename for data: pg_dump -qxnd -f/tmp/data.dump databasename The data

Linux mysql problems....

2001-10-05 Thread Christian Andersson
Hi there.. I'm not sure if anyone can help me with this, but I have just experienced a very disturbing situation with mysql. Today when coming to work, one of our databases in mysql seems to have lost a lot of data, it was as if the database was restored from a backup several days ago.. but only

RE: Party!!!

2001-10-05 Thread Maximiliano Lucius
Tell us more about it. M. - Original Message - From: Riccardi Moreno <[EMAIL PROTECTED]> To: Andrew Murphy <[EMAIL PROTECTED]>; MySQL <[EMAIL PROTECTED]> Sent: Friday, October 05, 2001 3:47 AM Subject: R: Party!!! > It's a great idea > Free your Mind > > -Messaggio originale-

Re:InnoDB

2001-10-05 Thread Heikki Tuuri
Riccardi, your innodb_log_arch_dir is C:\InnoDB\iblogs but innodb_log_group_home_dir is C:\iblogs These should be the same. Your MySQL error log should contain an error message of this: C:\trybuild\client_debug>mysqld --console InnoDB: Error: you must set the log group home dir in my.cnf the

Re: AW: Date interval problem

2001-10-05 Thread Carl Troein
Michael Thygs writes: > Hello Bruno, > > its a little bit complicated. You have to put a little bit of brain in it! > > The situation you ask for is: > > tab2.interval <> > possible intervals of table 1, which should be displayed are: > 1. <---> >

RE: Date interval problem

2001-10-05 Thread Tichawa Anton
hello list, Michael Thygs is right, but the expression can be simplified. We have to assume that all dates are in correct order, i. e. for each date pair the following relation is true: from date <= to date When a date range from tab1 does NOT overlap a date range from tab2, then the tab1 ran

Re: AW: Order By & Limit; Count

2001-10-05 Thread Ashwin Kutty
As much as I would think it would be.. Could you think of any reason why it wouldnt work then for me with the following:- The version of MySQL is:- 3.23.41 on Linux kernel version 2.4.7-2 on a Redhat 8 server. The table (table1) has the following fields:- author varchar(128) category varchar(64

Re: AW: Order By & Limit; Count

2001-10-05 Thread karel pitra
it's not true, order by is performed before limit. if it was the other way round , limit would be almost useless > Hadn't thought about this before, but what it means (I guess) is that LIMIT > works on the selection, not on the presentation. > > What I'm trying to say is that when you consider

InnoDB

2001-10-05 Thread Riccardi Moreno
-Messaggio originale- Hi All, I want to install Mysql and InnoDb on a W2K machine. I configure mi.ini file as it follows: [WinMySQLAdmin] Server=C:/mysql/bin/mysqld.exe [mysqld] port=3306 socket=/tmp/mysql.sock set-variable = key_buffer_size=16M set-variable = max_allowed_packet=1M inn

Re: Windows Threads Support

2001-10-05 Thread Jared Richardson
- Original Message - From: "Tonu Samuel" <[EMAIL PROTECTED]> To: "Manish Mehta" <[EMAIL PROTECTED]> Cc: "mysql" <[EMAIL PROTECTED]> Sent: Friday, October 05, 2001 6:00 AM Subject: Re: Windows Threads Support > On Fri, 2001-10-05 at 08:35, Manish Mehta wrote: > > Hello, > > > > Windows su

AW: Date interval problem

2001-10-05 Thread Michael Thygs
Hello Bruno, its a little bit complicated. You have to put a little bit of brain in it! The situation you ask for is: tab2.interval <---> possible intervals of table 1, which should be displayed are: 1. <---> 2.

Re: select * where [whatever column] LIKE '%something%'

2001-10-05 Thread Ladopoulos Theodoros
yes that gives the right results but i ask if i can do the same thing without enumerating all fields like this: SELECT * FROM [tablename] WHERE Field1 LIKE '%text%' OR Field2 LIKE '%text%' OR ... What i want is to do the same thing without knowing what are the field names or how many fields thi

Re: select * where [whatever column] LIKE '%something%'

2001-10-05 Thread snehalata
Hi, I don't think it is possible with out specifing the field names. But we can get the soultion in the following way If we have tabel calles 'test' with fields namely field1 and field2 then you can get all the records that conatin 'c' with the following query select * from tes

Date interval problem

2001-10-05 Thread Bruno Grampa
Hello, i have a table with two dates, that define an interval. In the query i have two more dates, and i want to select all the records that overlap that period. Any hint to solve this problem? Thanks, Bruno - Before posting,

select * where [whatever column] LIKE '%something%'

2001-10-05 Thread Ladopoulos Theodoros
hello, I would like to ask if it is possible with mysql to do soomething like this: SELECT * FROM [specific table name] WHERE [WHATEVER FIELD(not specified)] LIKE '%sometext%' Is there a variable lets say to refer to the column name? What I actually want to do is to find all records that field

RE: Troubles with cutting a row(solved)

2001-10-05 Thread pascal
If somebody interested I've got a solution: SELECT count(*) as quan, SUBSTRING(r_js, 1, locate('/', r_js, 8)) as a FROM main where length(r_js) group by a order by quan desc; On 04-Oct-2001 [EMAIL PROTECTED] wrote: > Hi there! > I have a varchar(255) row in a table, that contains some URL f.e. >

Re: MySQL performance and limit

2001-10-05 Thread Carl Troein
Tonu Samuel writes: > > I want to setup a machine with 3000 databases, each database will have > > 41 tables. > This should be no problem for MySQL. Everything is depending how to you > use MySQL. It seems to be pretty popular to have a large number of databases, but I guess it's mostly du

Re: Max Database

2001-10-05 Thread Tonu Samuel
On Fri, 2001-10-05 at 06:21, Manish Mehta wrote: > Hello Everyone, > > We are using MySQL as backend. > > What is Maximum size of MySQL Database? There is not limit on database size. Meanwhile there is a lot of limits which come from operating system you use. You have to read more: http://www

Re: Encryption

2001-10-05 Thread Tonu Samuel
On Fri, 2001-10-05 at 06:48, Manish Mehta wrote: > hello, > > Is MySQL Support Encryption ? > Depends what yo mean. Database encryption? No. Use crypted filesystem for this. Encryption functions? Partially yes. We have ENCRYPT() and MD5() functions. Encrypted communication? Yes, from 4.0.0 MySQ

Re: Windows Threads Support

2001-10-05 Thread Tonu Samuel
On Fri, 2001-10-05 at 08:35, Manish Mehta wrote: > Hello, > > Windows support 2000 threads by default (with the help of thread library). > Then what a mean of max_connection = 100 because MySQL One each connection > on differente thread. > Is i able to increase the max_connection limit. Yes, you

Re: MySQL performance and limit

2001-10-05 Thread Tonu Samuel
On Fri, 2001-10-05 at 09:52, José León Serna wrote: > Hello: > I want to setup a machine with 3000 databases, each database will have > 41 tables. Does MySQL support this configuration? What machine do you think > will support this configuration? The purpose is to create a website with > PHP+M

Re: InnoDB Tables/Databases

2001-10-05 Thread Tonu Samuel
On Mon, 2010-10-04 at 19:32, Deryck Henson wrote: > The original query is as follows: > > SELECT * FROM websites WHERE category LIKE '%"&search&"%' OR keywords LIKE > '%"&search&"%' OR description LIKE '%"&search&"%' > > The "&search&" instances are from an ASP page. 'search' is a variable that

Re: Using InnoDB

2001-10-05 Thread Heikki Tuuri
Deryck, in MySQL -Max the only thing that differs from MySQL is the binary mysqld. To install MySQL -Max in place of MySQL you only need to replace the binary. You do not need to uninstall MySQL-3.23.41. If you have defined InnoDB options in my.cnf like explained in the manual http://www.innodb.

Using InnoDB

2001-10-05 Thread Deryck Henson
Yes, I know, go look at the web site, but it's too confusing :(. I have found out how to setup and start with MySQL and InnoDB but I have no clue how to make my tables/databases InnoDB type. Oh, and, I just upgraded to MySQL Max 3.23.42 for Win32 but all of the previous stuff from MySQL 3.23.41

R: Party!!!

2001-10-05 Thread Riccardi Moreno
It's a great idea Free your Mind -Messaggio originale- Da: Andrew Murphy [mailto:[EMAIL PROTECTED]] Inviato: venerdì 5 ottobre 2001 10.37 A: 'Deryck Henson'; MySQL Oggetto: RE: Party!!! Sounds good, as the (altered) saying goes: Life begins at 4.0! -Original Message- From

RE: Party!!!

2001-10-05 Thread Andrew Murphy
Sounds good, as the (altered) saying goes: Life begins at 4.0! -Original Message- From: Deryck Henson [mailto:[EMAIL PROTECTED]] Sent: 04 October 2001 4:00 pm To: MySQL Subject: Party!!! Hey everyone! As most of you know the official (as in, not using a BASH shell) release of MySQL

Re: InnoDB Tables/Databases

2001-10-05 Thread Ilya Martynov
DO> Here is two thing for you. DO> First, GREAT source for search of pass problem on any thing really. DO> http://marc.theaimsgroup.com/ DO> Then, information on the InnoDB. Not hard to find really. DO> http://www.mysql.com/documentation/mysql/bychapter/manual_Table_types.html#I DO> nnoDB I w

Great work on the MySQL drivers... There is a problem with the driver

2001-10-05 Thread Elliot Gage
I was having a problem with the RecordSet class in jdbc2... upon inspection, the class file is older than the java file. I recompiled and re-jar'd. This fixed my problem. The version is 2.0.4 The mm.mysql-2.0.4-bin.jar just needs to be recompiled as it is out of sync with the source code in 2-0-

MySQL performance and limit

2001-10-05 Thread José León Serna
Hello: I want to setup a machine with 3000 databases, each database will have 41 tables. Does MySQL support this configuration? What machine do you think will support this configuration? The purpose is to create a website with PHP+MySQL, is this possible? Best Regards. ---