Gary Greenberg schrieb:
I have a table that stores performed transactions and I need to build a
histogram of a number of transactions per day in the requested period.
So, I made a simple query with the group by clause which returns me what
I need:
2008-04-1665456204
2008-04-17190838546
David Perron schrieb:
Hello Users-
I think I have an interesting question with regards to applying a function
to date range, I think half of problem solving is explaining it to an
audience so please, bear with me.
There is a table Orders that has two DATE columns, StartDate and EndDate.
The
Perrin Harkins schrieb:
On Wed, Apr 23, 2008 at 9:22 PM, D Hill [EMAIL PROTECTED] wrote:
Can anyone shed some light if I should index wite_desc to speed things up?
No, since you don't use that column at all. If you're not on MySQL 5,
upgrading to MySQL 5 will help. Otherwise, you're best
D Hill schrieb:
I have something I am trying to resolve with an over abundant number of
slow queries. Perhaps it is because of some additional indexes needed.
As soon as I enabled the option 'log_queries_not_using_indexes = 1' in
the configuration file, I started getting messages relating to
Hi,
The changelogs for MySQL Cluster have been consolidated and can now be found
here: http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-news.html
They're now arranged by NDB version number:
http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-news-6-3.html
Mark,
When you try to log-in to the new instance, are you specifying the new
port number to the client? If you don't give it the new port number,
then it will connect to the default port, which is presumably your
4.0.20 instance.
Mark-E wrote:
I have a Solaris box where MySQL 4.0.20
Hi,
I guessed it was something like it and that is why I wanted to make sure how
it should be done. Using the ALTER TABLE table DISCARD TABLESPACE doesn't
seem to work as expected - I succeeded to crash the test server twice. See
the mysql log details below.
What I did was the following:
-
Hello,
I can connect to a SQL server in the following way from my windows OS machine:
Start -- control Panel -- Administrative tools --- Data Sources(ODBC)
and provide the necessary input. This works for me without problems.
I have installed xamp sw on this window machine. The SW version is
Padiyath Sreekumaran schrieb:
?php
$dsn=asi_qms;
$username=asi_qms_2006;
$password=something;
$server=xxx;
if(!$handle = odbc_connect($dsn, '$username', '$password')) die('Keine
Verbindung möglich!');
?
I got the following error when I execute the previous script:
Warning: odbc_connect()
Padiyath Sreekumaran schrieb:
Hello Sebastian,
Thanks for your mail. But I donot see any difference in my $username and yours
except
'().
what surprise, yes, thats it!
you have to use no quotes at all (or doublequotes) around variables, RTMF is
this case the one from PHP
but what has
Hi All,
Below is the table design on mysql server.
CREATE TABLE `coupon_per_course` (
`coupon_id` int(10) unsigned NOT NULL default '0',
`course_id` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`coupon_id`,`course_id`),
KEY `idx_coupon_per_course` (`coupon_id`),
KEY
I set up a user and entered % for the host. I am not able to connect.
However, if I change the host value to my FQDN it works fine. Shouldn't
the wildcard allow me to connect from any host?
Thanks,
Adam
--
Adam Gerson
Assistant Director of Technology
Apple Certified System Administrator
When using odbc_connect, you don't use the DSN you've previously created.
You use the complete definition of the connection. Here's an example of
connecting to an MS Access database:
define('ODBC_CONNECT',
'DRIVER={Microsoft Access Driver (*.mdb)};
On Thu, Apr 24, 2008 at 2:54 AM, Sebastian Mendel
[EMAIL PROTECTED] wrote:
IMHO not in this case, cause it is just a simple WHERE field IN ()
I'm pretty sure that just looks like a bunch of ORs to MySQL. If it
didn't use the index with OR, it won't use it with IN.
What usually works is to
-Original Message-
From: Jerry Schwartz [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 24, 2008 10:01 AM
To: 'Padiyath Sreekumaran'; mysql@lists.mysql.com
Subject: RE: Php-mssql connection problems on Windows XP
When using odbc_connect, you don't use the DSN you've previously
created.
On Thu, 24 Apr 2008 at 08:58 +0200, [EMAIL PROTECTED] confabulated:
D Hill schrieb:
I have something I am trying to resolve with an over abundant number of
slow queries. Perhaps it is because of some additional indexes needed. As
soon as I enabled the option 'log_queries_not_using_indexes =
Hello,
We recently purchased a Dell PowerEdge 6650 thinking it would be a real fast
server.
Specs are:
OS: Linux Debian 4.0/Etch
RAID 5 on 4x U320 15k rpm drives
(uses a perc-raid 3/DC hardware raid controller)
16GB of RAM
4 3.0 Ghz Xeon processors - I think they're dual core, in /proc/cpuinfo
On Thu, 24 Apr 2008 at 10:16 -0400, [EMAIL PROTECTED] confabulated:
On Thu, Apr 24, 2008 at 2:54 AM, Sebastian Mendel
[EMAIL PROTECTED] wrote:
IMHO not in this case, cause it is just a simple WHERE field IN ()
I'm pretty sure that just looks like a bunch of ORs to MySQL. If it
didn't use
On Thu, Apr 24, 2008 at 6:40 AM, Krishna Chandra Prajapati
[EMAIL PROTECTED] wrote:
Hi All,
Below is the table design on mysql server.
CREATE TABLE `coupon_per_course` (
`coupon_id` int(10) unsigned NOT NULL default '0',
`course_id` int(10) unsigned NOT NULL default '0',
PRIMARY
Hi,
On Wed, Apr 23, 2008 at 11:07 PM, JW [EMAIL PROTECTED] wrote:
Hello,
We recently purchased a Dell PowerEdge 6650 thinking it would be a real fast
server.
Specs are:
OS: Linux Debian 4.0/Etch
RAID 5 on 4x U320 15k rpm drives
(uses a perc-raid 3/DC hardware raid controller)
Hi,
Someone suggested I try the -amd64 kernels which provide 64 bit but when I try
to boot it I get various errors about this CPU does not support long
(something) please use a 32-bit OS - the 64 bit install CD says the same
message. So I assume these are not 64 bit CPUs.
They almost
Hi,
On Thu, Apr 24, 2008 at 12:20 PM, Jeremy Cole [EMAIL PROTECTED] wrote:
Hi,
Someone suggested I try the -amd64 kernels which provide 64 bit but
when I try
to boot it I get various errors about this CPU does not support long
(something) please use a 32-bit OS - the 64 bit
Hi,
May be it's not the right forum i'm posting to.
I have a Mysql Query : Select a.code,b.description,
b.other_details,a.qty,a.price from xyz a, bcd b where a.code=b.code and
a.id='5' order by a.id
This is running fine but when using VB6 to display it in a Msflexgrid, it's a
nightmare! It
I think what we need to know is more stuff about the database itself.
How big is it? I assume if you were able to serve it from a Mac Mini it
can't be all that big.
16GB should be big enough to contain all the data and serve it up quickly.
And while 4-disk RAID 5 isn't all that great, it's
Did you FLUSH PRIVILEGES?
I'd also check that the username and passwords are the same for each
host entry, I've had problems if passwords were different for a shared
username from different hosts.
On Apr 24, 2008, at 8:58 AM, Adam Gerson wrote:
I set up a user and entered % for the host. I
I have been storing points in mysql without use of the spatial
extension. I do not forsee the need to ever store more than points,
and am wondering if the spatial extensions would offer any significant
advantages. I have looked a bit for tutorials, etc... and have not
found much.
One feature that
Velen wrote:
Hi,
May be it's not the right forum i'm posting to.
I have a Mysql Query : Select a.code,b.description,
b.other_details,a.qty,a.price from xyz a, bcd b where a.code=b.code and
a.id='5' order by a.id
This is running fine but when using VB6 to display it in a Msflexgrid, it's a
JW wrote:
Hello,
We recently purchased a Dell PowerEdge 6650 thinking it would be a real fast
server.
Specs are:
OS: Linux Debian 4.0/Etch
RAID 5 on 4x U320 15k rpm drives
(uses a perc-raid 3/DC hardware raid controller)
16GB of RAM
4 3.0 Ghz Xeon processors - I think they're dual core, in
Hi all,
I have one table as following
AccessDetails
DateTimeUserName
SiteName StatusVirus_Category
|2008-04-23 | 14:27:38 | 172.16.1.40|
en.wikipedia.org | A | unclassified |
| 2008-04-23
D Hill schrieb:
On Thu, 24 Apr 2008 at 08:58 +0200, [EMAIL PROTECTED] confabulated:
D Hill schrieb:
I have something I am trying to resolve with an over abundant number
of slow queries. Perhaps it is because of some additional indexes
needed. As soon as I enabled the option
David Perron schrieb:
Hi Sebastian-
Wanted to follow up on this. I figured out the problem. You actually
have to use the LEAST GREATEST operators when comparing multiple
values, this statement works perfectly.
LEAST(EndDays,Q2EndDays) - GREATEST(Q2StartDays,StartDays) as DaysInQ2,
31 matches
Mail list logo