At 03:11 PM 6/8/2002 +0200, Benjamin Pflugmann wrote:
>Hi.
>
>As far as I can see is that you use a condition in your WHERE clause
>which MySQL will not (yet?) use indexes for. See
>
> http://www.mysql.com/doc/M/y/MySQL_indexes.html
> (seems to be mainly about MyISAM tables)
>
>to see how inde
Ah...give up not for we have been using mysql for quite a long time and it
is pretty stable. Try this...
instead of trouble shooting this install and getting it work...
go to www.mysql.com, download an rpm if you are on Red hat linux (or
Mandrake) and do an
rpm -i mysql...rpm and
rpm -i mysq..clie
Thanks Bhavin,
I tried your suggestion ("safe_mysqld start") and get a lot of "Permission
denied" errors. So, I "su" to root and try it, and it appears that it does
start ("Starting mysqld daemon with databases from /usr/local/mysql/data").
However, when I try to connect, either as root (which
Have you tried .../bin/safe_mysqld start to start the DB first? This is what
will create /tmp/mysql.sock socket file & start the DB server. Then you can
use the 'mysql' client for connecting to the DB. Also, if you don't want to
use transactional database, meaning, if you don't want support for ro
Buying Paul DuBois' most excellent book "MySQL" has made me more comfortable
with Mysql and Unix, so I thought I would try to use Mysql/PHP combo as the
web database for a redesigneed site at Right Moves For Youth (trying to keep
"at risk" kids in school).
After running his "cleanup instructions"
Hello.
On Sun 2002-06-09 at 16:50:44 -0500, [EMAIL PROTECTED] wrote:
> I have a mysql table that has the primary key set to auto-increment. For
> a
> very strange reason we have a row with the primary key value of 0. This
> is like a default value for the application. I didn't want to do it this
Alter tablemodfiy column command should do it.
Regards,
Bhavin.
- Original Message -
From: "Jason Lane" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, June 09, 2002 2:50 PM
Subject: RE: Can I override the auto-increment setting?
> I have a mysql table that has the pri
I think I'm in need of a little bit of database design guidance.
I have a website that will be selling photos. I want to store all the
information about the photo and any comments about it, and give a list of
sizes it's available in, plus a price depending on which price scale the
photo falls int
Hello Jason,
I think you have to ALTER this field, insert what you want and then
ALTER it back.
Another way is to insert the record, detect the value of
auto-increment field it got (there is a function mysql_insert_id /
LAST_INSERT_ID) and update it.
JL> I have a mysql table tha
Hello.
On Sun 2002-06-09 at 11:55:29 -0400, [EMAIL PROTECTED] wrote:
> Dear Sir or Ms.
>
> Is there a stable version of MySQL that runs on Apache 2.0?
MySQL and Apache are two different applications which don't use each
other directly. So any versions (of both) should be fine. Just pick
the lat
I have a mysql table that has the primary key set to auto-increment. For
a
very strange reason we have a row with the primary key value of 0. This
is like a default value for the application. I didn't want to do it this
way, but it's too late now.
If the 0 value doesn't exist we have to create it
THANKS IT WORKS.
-Hoa
>From: Bhavin Vyas <[EMAIL PROTECTED]>
>To: Hoa Doan <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
>Subject: Re: LOAD DATA LOCAl
>Date: Sun, 09 Jun 2002 09:57:35 -0700
>
>You can put it in any directory and then provide the FULL path to the file
>in the LOAD command.
>
In the last episode (Jun 09), Bruno Batarelo said:
> Greetings
>
> In the comments section (delete speed) somebody wrote that that it is
> much faster to delete results of previously executed select query.
> How can I do that when delete from..where in(select query); is not
> possible?
You manua
Greetings
In the comments section (delete speed) somebody wrote that that it is much
faster to delete results of previously executed select query. How can I do
that when delete from..where in(select query); is not possible?
Regards
Bruno
On Sun, Jun 09, 2002 at 11:55:29AM -0400, Jeff Whitman wrote:
> Dear Sir or Ms.
>
> Is there a stable version of MySQL that runs on Apache 2.0?
>
> Thanks for your time.
>
Question is is httpd-2.0.X stable??
>
> Jeff Whitman
> Managing Member
> JW NetSource, LLC
>
>
Since 020606 mysql has been crashing and then I have to manually
restart.
The error log is below:
020607 00:46:27 mysqld started
/usr/contrib/libexec/mysqld: ready for connections
020607 19:30:58 mysqld restarted
/usr/contrib/libexec/mysqld: ready for connections
A mysqld process already exis
We use the current stable version of MySQL on a server running Apache 2.0
with no problem.
- Original Message -
From: "Jeff Whitman" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, June 09, 2002 10:55 AM
Subject: Apache 2.0
Dear Sir or Ms.
Is there a stable version of MySQL t
Dear Sir or Ms.
Is there a stable version of MySQL that runs on Apache 2.0?
Thanks for your time.
Jeff Whitman
Managing Member
JW NetSource, LLC
Contact Information:
Jeff Whitman
JW NetSource, LLC
PO Box 702
115 East Main
Manch
Hello,
I change the max_connections to 200, and I am not sure it works, when I
use mysqladmin to check the variables, I find the value is still displayed
as 100, but trough checking the log file, I am sure the max_connections have
changed to 200, so, is it a bug of mysqladmin?
BTW, Who ca
You can put it in any directory and then provide the FULL path to the file
in the LOAD command.
Regards,
Bhavin.
- Original Message -
From: "Hoa Doan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, June 09, 2002 12:26 AM
Subject: Re: LOAD DATA LOCAl
> Hi,
>
> I've created a m
* p shah
> Hi,
> I am looking for help on writing stored procedures
> for Mysql 4.0 and above.
>
> Any examples or pointing to advanced tutorials
> covering stored procedures for Mysql will be highly
> appreciated.
Stored procedures are planned "around version 4.1":
http://www.mysql.com
Hi,
I am looking for help on writing stored procedures
for
Mysql 4.0 and above.
Any examples or pointing to advanced tutorials
covering stored procedures for Mysql will be highly
appreciated.
Thanks in advance.
__
Do You Yahoo!?
Yahoo!
Hi,
I am looking for help on writing stored procedures for
Mysql 4.0 and above.
Any examples or pointing to advanced tutorials
covering stored procedures for Mysql will be highly
appreciated.
Thanks in advance.
__
Do You Yahoo!?
Yahoo! - Officia
Hi!
> "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
Sinisa> Victoria Reznichenko writes:
>> Hi!
>> Sinisa, i tested the following example on 4.0.1 and got the same
>> result. If I don't use ORDER BY in the SELECT statement all worked
>> fine:
mysql> SELECT u.gender AS gende
Hi,
I've created a mysql database named clients with a client table. I want to
load a text file using the LOAD DATA LOCAL command, but I don't know where I
have to place the text file. I know that using the LOCAL keyword the text
file will be read from the client host, but in what directory?
25 matches
Mail list logo
