On Sat, 2 Feb 2002, Dan Nelson wrote:
> In the last episode (Feb 02), Randy Arabie said:
> > On Sat, 2 Feb 2002, Dan Nelson wrote:
> > mysql.
> > > > kern.maxfiles = 1772
> > >
> > > Raise that to (say) 5000. I assume netbsd has an /etc/sysctl.conf you
> > > can use, or you can do it manually v
In the last episode (Feb 02), Randy Arabie said:
> On Sat, 2 Feb 2002, Dan Nelson wrote:
> mysql.
> > > kern.maxfiles = 1772
> >
> > Raise that to (say) 5000. I assume netbsd has an /etc/sysctl.conf you
> > can use, or you can do it manually via "sysctl -w kern.maxfiles=5000" .
>
> How high can
On Sat, 2 Feb 2002, Dan Nelson wrote:
> > kern.maxfiles = 1772
>
> Raise that to (say) 5000. I assume netbsd has an /etc/sysctl.conf you
> can use, or you can do it manually via "sysctl -w kern.maxfiles=5000" .
How high can I go??
Tried 5000, and it still bombs at the same point. I set that
Some manual suggestions:
http://www.mysql.com/doc/T/O/TODO_MySQL_4.0.html
_We have now in the final stages one the development of the MySQL Server
4.0._
We are now in the final stages of development of MySQL Server 4.0
http://www.mysql.com/doc/T/O/TODO_MySQL_4.1.html
Add record_in_range() m
Henry,
Saturday, February 02, 2002, 12:25:16 AM, you wrote:
HH> Hello,
HH> Under mysql 3.22.29, I was able to use isamchk to disable all index keys (-r
HH> -k0), do millions of inserts into the table, then re-enable all the indexes
HH> again with "isamchk -r -k4" (4 indexes). I'm testing out
stscanlan,
Saturday, February 02, 2002, 5:05:38 AM, you wrote:
s> I keep getting a port occupied error after doing a default RPM install for
s> MySQL. I have used it without incident on Windows and was surprised by the
s> problems. I don't have anything running on port 3306, but it won't start,
Amit,
Saturday, February 02, 2002, 3:10:01 PM, you wrote:
ADL> I am trying to fire the following query but it is generating an error:-
ADL> select color from colortable where colorcode = select max(colorcode) from
ADL> colortable where colorcode <= 5
Have a look at: http://www.mysql.com/d
Matt,
Saturday, February 02, 2002, 2:29:48 AM, you wrote:
MR> Hi,
MR> I just finished doing an online database in PhP/MySQL for a client and
MR> they have asked if it is possible to output it to a MS Access database
MR> so they can use it for Mail Merge, etc. Does anyone know how I would go
MR>
HQ,
Saturday, February 02, 2002, 1:46:37 AM, you wrote:
H> Dear all,
H> I am new to MySQL.
H> I have just installed the rpm package of mySQL on my RedHat Linux, but
H> found many problems. First, I can not run the following command:
H> mysqladmin -u root password "Mypasswd"
H> Second
On Sat, 2 Feb 2002, Sinisa Milivojevic wrote:
> Subject: Re: Core dump with mysqld-3.23.47-log
>
> Phillip Porch writes:
> > >Description:
> > The problem I am having is on a SCO Openserver 5.0.6a system. I
> > compiled mysqld-3.23.47-log myself as well as trying a precompiled binary.
> > The
error in mysql_set...
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:Iremar Afonso
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysq
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:Iremar Afonso
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Rele
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:Iremar Afonso
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Rele
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:Iremar Afonso
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Rele
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:Iremar Afonso
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Rele
Dear all,
I am running MySQL 3.22.xx at Mandrake 8.1, how can I grade my MySQL??
Thanks
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
[ database mysql query ]
Sinisa Milivojevic wrote:
>On Fri, 01 Feb 2002 15:21:07 -0800
>Steve Edberg <[EMAIL PROTECTED]> wrote:
>
>>...perhaps a NEAR function could be added; as a config file or
>>compile-time option, you could define an accuracy range. Say,
>> ./config --with-epsilon=0.0001
>
Phillip Porch writes:
> >Description:
> The problem I am having is on a SCO Openserver 5.0.6a system. I
> compiled mysqld-3.23.47-log myself as well as trying a precompiled binary.
> The core file that is created when analyzed indicates that the problem occurs
> in the libgthreads.so libra
>Description:
The problem I am having is on a SCO Openserver 5.0.6a system. I
compiled mysqld-3.23.47-log myself as well as trying a precompiled binary.
The core file that is created when analyzed indicates that the problem occurs
in the libgthreads.so library when pthread_sigprocmask is
On Sat, 2 Feb 2002, Manuel Bouyer wrote:
> On Sat, Feb 02, 2002 at 10:33:21AM -0700, Randy Arabie wrote:
> >
> > > You may also want to ktrace mysqld while trying to load the
> > > database to get more details.
> >
> > Tried this. I'm not much on analyzing a kernel trace, but I could see
> >
On Sat, Feb 02, 2002 at 10:33:21AM -0700, Randy Arabie wrote:
>
> > You may also want to ktrace mysqld while trying to load the
> > database to get more details.
>
> Tried this. I'm not much on analyzing a kernel trace, but I could see
> from the trace that the file was opened. And, it appea
On Sat, 2 Feb 2002, Manuel Bouyer wrote:
> On Sat, Feb 02, 2002 at 08:23:49AM -0700, Randy Arabie wrote:
> > Environment:AlphaStation 255 w/ 64 MB RAM
> > NetBSD 1.5.2 - custom kernel
> > MySQL 3.23.47
> >
> > I'm trying to load data into tables in a mysql databa
>Greets Folks,
>
>Semi-newbie question here.
>
>Is there a way to perform data validation (in the SQL language for
>MySQL) for input I would have coming in off the web (i.e. via
>HTML/CGI)?
>
>I need some tuts, or even just the raw SQL code with some simple
>install directions.
If you're using
Hello,
I have just downloaded mysql 3.xx max. I am trying to figure out how to get
in touch with an dministrator as the manual says. It doesn't tell me how to
get a hhold of an administrator.I want to be able to log in and strt
creating databases to srpen sql skills.
thanks for yor help
Ken
×𾴵Ŀͻ§£º
ÄúºÃ£¡ÏÖÔÚ×âÓÃʱ´´ÍøÂçµÄÐéÄâÖ÷»ú£¬ËÍÉÁËÙÓʾ֣¨Promail
2.0£©,»ù±¾ÐÍ100M¿Õ¼ä+100MÉÁËÙÓʾÖ=300Ôª£¡£¨¸ü¶àÇë¼û£ºwww.todaynic.com£©
»¶ÓÄú·ÃÎÊToday's Network http://www.todaynic.com
Ö麣ʱ´´ÍøÂç
0756--2125583 2125593 2125523 2252872
0756--2236575 2125594 2216376
´«Õ棺0756--2229
On Sat, Feb 02, 2002 at 08:23:49AM -0700, Randy Arabie wrote:
> Environment: AlphaStation 255 w/ 64 MB RAM
> NetBSD 1.5.2 - custom kernel
> MySQL 3.23.47
>
> I'm trying to load data into tables in a mysql database. When I feed the
> load script into the database it
Environment:AlphaStation 255 w/ 64 MB RAM
NetBSD 1.5.2 - custom kernel
MySQL 3.23.47
I'm trying to load data into tables in a mysql database. When I feed the
load script into the database it fails about 3/4 through. Error follows:
ERROR 1105 at line 11: Fi
Serge,
> Is it possible in mySQL to GROUP BY months on a date field?
> For example:
> SELECT invDate,prdCategory,sum(prdPrice)
> GROUP BY left(invDate,6),prdCategory
> If invDate is in the format 20020202
> then group by the first 6 characters
> would return the total
Is it possible in mySQL to GROUP BY months on a date field?
For example:
SELECT invDate,prdCategory,sum(prdPrice)
GROUP BY left(invDate,6),prdCategory
If invDate is in the format 20020202
then group by the first 6 characters
would return the total of sales
by product category and by month.
I
I have two servers and am using Phorm. The scripts are identical with
exception of username/password. MYSQL is proven running 'correctly' on both
servers (I am logged on). The servers are not identical but close.
One server processes the form data perfectly into the MYSQL table, the other
con
Amit Dilip Lonkar a écrit :
>
> I am trying to fire the following query but it is generating an error:-
>
> select color from colortable where colorcode = select max(colorcode) from colortable
>where colorcode <= 5
>
> Please Help
>
> Thanks
> Amit Lonkar
>
>
Greg Bailey writes:
> >Description:
>
> Joining multiple tables together in a select statement with where clauses
> using the "IN (...)" construct generate duplicated output rows.
Hi!
I tested your case with 4.0.2 and got identical results from both
queries.
This was some bug probably fixed l
I am trying to fire the following query but it is generating an error:-
select color from colortable where colorcode = select max(colorcode) from colortable
where colorcode <= 5
Please Help
Thanks
Amit Lonkar
-
Bef
On Fri, 01 Feb 2002 15:21:07 -0800
Steve Edberg <[EMAIL PROTECTED]> wrote:
> ...perhaps a NEAR function could be added; as a config file or
> compile-time option, you could define an accuracy range. Say,
>
> ./config --with-epsilon=0.0001
>
> (if memory of my numerical analysis classes
Greets Folks,
Semi-newbie question here.
Is there a way to perform data validation (in the SQL language for MySQL)
for input I would have coming in off the web (i.e. via HTML/CGI)?
I need some tuts, or even just the raw SQL code with some simple install
directions.
Thanks,
=)
Will
Hello,
I have found a bug( or bad feature? :) ) in 4.0.1
boolean fulltext search
Please help...
Test case with table can be found at http://logo.nino.ru/fulltextbug.tar.gz
Alexander
( "sql database query table" for you, spam protector:)
--
show variables like 'ft%'
-
> >> I have not completely figured out what the problem is and I never got a
> >> response from any one else on the list. I can tell you it looks like a
> >> mutex problem between two threads. We have followed it down into
> >> pthreads
> >> where it seems to be stuck. The external symptom we s
37 matches
Mail list logo
