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 archives
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
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 optimis
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 th
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 200
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: NUL
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 | possibl
I would investigate a partial index perhaps on the date only? You could
index on just the date eg.
ALTER TABLE 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 direction.
Reg
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 Mo
SELECT * FROM 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]
Sent: Mon
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 200
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 file
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 = '';
my $username2 = '';
my $pass
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:http
I'm returning this discussion to 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 t
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 Budiha
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 th
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 tagge
- Original Message -
From: "Eko Budiharto" <[EMAIL PROTECTED]>
To: ; ;
<[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
console, it works. But when I run it from perl, it does
- 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 n
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 = '';
my $username2 = '';
my $password2 = 'connect("dbi:mysql:$db2:$server2", $username2, $
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 s
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 an
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 subnets.cityid=cities.
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
spe
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 of
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
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 s
28 matches
Mail list logo
