Hi there,
I have a problem connecting to the mysql server. I installed a new server with
mysql 4.1.9, apache2, php4 on freebsd5.3 and have some websites running on it
using the mysql server. Last friday I had a crash of one off my other servers
and I copied the websites and db's to this new
Hello.
I am running the Postfix+Courier on MySQL setup found on:
http://www.high5.net/howto
I am wondering how to add and delete users, as well as adding
and deleting aliases -- and managing my virtual e-mail database
in general -- using a pure, clean and efficient approach,
rather than having
Hey!
I am running this non-profit organization working together with
various charity organizations across the world.
We would like to setup an efficient member database using MySQL
rather than having some ugly formatted MS Word document listing
them.
What would be the purest and cleanest way
Seems like there should be a simple solution to my
problem but I have been unable to find it.
Suppose you have a phone book of names, addresses,
etc. You are looking at page 100 and want to now see page 99. (The
person data is, of course, dynamic so a specific name is not tagged to a
Graham Anderson wrote:
My server has mysql: version 3.23.58
// Performing SQL query
SELECT cities.city, regions.region, countries.country
FROM cities
JOIN subnets on subnets.cityid=subnets.cityid
^^^
Shouldn't that be
JOIN subnets on
Fafa,
I am running this non-profit organization working together with
various charity organizations across the world.
We would like to setup an efficient member database using MySQL
rather than having some ugly formatted MS Word document listing
them.
What would be the purest and
Hi,
I have a problem connecting to the mysql server. I installed a new
server with mysql 4.1.9, apache2, php4 on freebsd5.3 and have some
websites running on it using the mysql server. Last friday I had a
crash of one off my other servers and I copied the websites and db's
to this new
Hi,
I am having problem with update command. I run it directy in the mysql console,
it works. But when I run it from perl, it does not work.
here is the perl script
my $server2 = 'localhost';
my $db2 = 'database';
my $username2 = 'username';
my $password2 = 'password';
my $dbh2 =
- Original Message -
From:
Carl
To: mysql@lists.mysql.com
Sent: Sunday, March 20, 2005 8:38
AM
Subject: Select previous group
Seems like there should be a simple solution to
my problem but I have been unable to find it.
Suppose you have a phone book of
- Original Message -
From: Eko Budiharto [EMAIL PROTECTED]
To: ActivePerl@listserv.ActiveState.com; mysql@lists.mysql.com;
[EMAIL PROTECTED]
Sent: Sunday, March 20, 2005 10:04 AM
Subject: update command
Hi,
I am having problem with update command. I run it directy in the mysql
Carl,
Seems like there should be a
simple solution to my problem but I have been unable to find it.
Suppose you have a phone book of
names, addresses, etc. You are looking at page
100 and want to now see page 99. (The person data is, of course,
dynamic so a specific
name is not tagged to a
David Lloyd wrote ..
Hi,
I have a problem connecting to the mysql server. I installed a new
server with mysql 4.1.9, apache2, php4 on freebsd5.3 and have some
websites running on it using the mysql server. Last friday I had a
crash of one off my other servers and I copied the websites
Hi all,
I just found the error. The error was I did not include the execute statement
in my perl script.
Thank you very much for whom reply my email. Thank you very much. I really
appreciate it.
Eko Budiharto [EMAIL PROTECTED] wrote:
Date: Sun, 20 Mar 2005 07:04:27 -0800 (PST)
From: Eko
I'm returning this discussionto the
list where it belongs
Are you sure that the query you do on the
command line is the same as the one you do in the program? Obviously, they can't
be precisely identical because the program needs additional punctuation to work
but is it functionally
I update mysql to 4 in my fedora, but when i put mysqld says me that
other service is in this port, before when i put ps shows me a myql_safe
but whe i updated no shows
Why don´t star mysql?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Presumably you remembered to include
Eko Budiharto wrote:
Hi,
I am having problem with update command. I run it directy in the mysql console, it works. But when I run it from perl, it does not work.
here is the perl script
my $server2 = 'localhost';
my $db2 = 'database';
my $username2 =
I tried to answer this directory to your email address but the address bounced;
1. disable selinux
2. change the ownership rights to /var/lib/mysql to mysql:mysql
3. run mysql_install_db
4. add your users to the mysql group
5. restart the machine
If mysqld is still not running, check the error
Hi All,
Is there a simpler way of doing a select for a given date, for instance if I
have a datetime field called date
And so its populated with a load of values such as
2005-01-07 09:00
2005-01-07 10:00
2005-01-07 11:00
2005-01-07 12:00
If I wanted all records which fall on
SELECT * FROM table WHERE date LIKE '2005-01-07%';
David Logan
Database Administrator
HP Managed Services
148 Frome Street,
Adelaide 5000
Australia
+61 8 8408 4273 - Work
+61 417 268 665 - Mobile
+61 8 8408 4259 - Fax
-Original Message-
From: Pete Moran [mailto:[EMAIL PROTECTED]
The table is indexed on the date field, doing a 'like' results in a table
scan, is there another way similar principal but would allow the indexes to
be used ?
-Original Message-
From: Logan, David (SST - Adelaide) [mailto:[EMAIL PROTECTED]
Sent: Monday, 21 March 2005 11:24 AM
To: Pete
I would investigate a partial index perhaps on the date only? You could
index on just the date eg.
ALTER TABLE thing ADD INDEX (date(10));
I don't have to time to check it out now and I'm not sure it will
automatically use it but an EXPLAIN on the statement would point you in
the right
Will try with the partial index,
Comparing the two without it is as follows
Using Like
mysql explain select count(*) from trip where pick_up_date like
'2005-01-01%';
+---+---+---+--+-+--+-+-
-+
| table | type |
Hi Paul,
On my installation I get
mysql explain select * from mytest where date_thing like
2005-03-21%\G
*** 1. row ***
table: mytest
type: ALL
possible_keys: date_thing
key: NULL
key_len: NULL
ref: NULL
Pete Moran wrote:
Hi All,
Is there a simpler way of doing a select for a given date, for instance if I
have a datetime field called date
And so its populated with a load of values such as
2005-01-07 09:00
2005-01-07 10:00
2005-01-07 11:00
2005-01-07 12:00
If I wanted all records which fall on
LIKE is a string comparison. Using date LIKE '2005-01-07%' forces mysql
to convert each datetime value in column date into a string in order to make
the comparison. When your comparison is based on a function of a column
(the implicitly called cast as string, in this case), the index on the
Thanks Michael,
This way works fine anyway was just interested if there was a better way of
doing it.
Pete
-Original Message-
From: Michael Stassen [mailto:[EMAIL PROTECTED]
Sent: Monday, 21 March 2005 4:07 PM
To: Pete Moran
Cc: mysql@lists.mysql.com
Subject: Re: DateTime Select
Mark Sargent wrote:
Ashley M. Kirchner wrote:
Mark Sargent wrote:
[EMAIL PROTECTED] pcre-5.0]# mysql -h mysql -p
-bash: mysql: command not found
You don't have mysql in root's path. Once you fix that little
problem, you should be all set.
Hi All,
heck, how exactly do I do that..? Move the whole
Dear friends,
I cannot locat the odbc driver for mysql in mandrake.
Does anyone have an idea about the whereabouts of the thing?
thanks in advance
--
symbulos partners
-.-
symbulos - ethical services for your organisation
http://www.symbulos.com
--
MySQL General Mailing List
For list
28 matches
Mail list logo
