Hi folks,
I do a considerable amount of queries based on a date, and or date range. I
have not had much luck with optimizing these queries. In some cases I use a
date field and others a datetime field.
The following query searches through 34,000 + records, while specifiying the
exact date
Keith,
The normal way to do a search for a range of dates would be
... WHERE a.submitdate BETWEEN '2003-07-01' AND '2003-07-14';
Is that what you're looking for?
submitdate happens to be a DATETIME field.
Your suggested query doesn't pull any results. Must I convert the field
first?
I'm not sure what errors are being reported to the server. I'm not sure how
to get those. I am not local to the box.
Is there a way to look at the log files without being at the box?
Karl
- Original Message -
From: Victor Pendleton [EMAIL PROTECTED]
To: 'Karl J. Stubsjoen' [EMAIL
Hello,
How can I determin what erros occur from an Insert into select from
statement? Namely, I'm looking for any duplicate record errors. It is
important to inform the user (in a web browser) whether or not a particular
insert would fail.
Must I perform a lookup first, or is there a way to
Hello,
This is my 2nd post, not to sound pushy, just raising the urgency of my
dilemna. My table is crashing way to often (I'd like it to not crash at
all).
I'm not sure what to do, how to trouble shoot, and how to fix my problem. I
will post the structure of the table here, as well as the
Hello,
Is it possible to distribute a MySQL db with a visual basic application - in
other words, use MySQL as the backend DB for a Visual Basic app?
Karl Stubsjoen
www.excelbus.com/info-m
-
Before posting, please check:
Hello,
I need to kill a thread. I've issued a command which has locked a table
(delete from table where id = 9) was the command and it is taking a
very very long time.
Now I'd like to kill that thread. However, I can't read the the thread ID
because the ID scrolls out of view in my little
Wooohooo! that is the first bug i ever found!
Do I get any points : )
Karl
www.excelbus.com
..opportunity knocking..
-Original Message-
From: Sergei Golubchik [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 21, 2001 6:33 AM
To: Karl J. Stubsjoen
Cc: MySql list
Subject: Re
Hello,
I am trying to perform the following delete command:
delete from my_table where match(keywords,title,description)
against('this_word')
When I perform a similar select and count with the above query, I come up
with 47 records found. However, when I issue the above delete command, no
Hello,
I have a fairly active and large DB. I need to create a new index on a
column. It will take (just guessing) 15-30 minutes for the entire creation.
I've got different people hittiing this table all the time, mostly with new
inserts (not really any updates). My question is:
Can I create
Hello,
I need to create a search engine out of a few MySQL tables I should
say: I need to search MySQL records like a search engin might. However, my
first go ended up as a complete failure because it is highly un-optimized to
search for (as an example) %apple% in all of the available
Hello,
Can someone explain hash tables or hash indexes and if we can take advantage
of them in MySQL?
Thanks!
Karl
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Hello,
How could we replicate our MySQL DB from one server to another? As a back
up measure, incase our pages fail to connect to ServerA, it'll then try to
connect to ServerB?
Thanks!
Karl
...and what is the word I am looking for, it isn't replicate but something
else?
Hello,
We have loaded MySQL on an Apache Linux machine, I have recently tried to
connect and am getting the following error:
C:\mysql\binmysql -hdaffy -uroot -p
Enter password:
ERROR 1130: Host 'workstation01.fenzer' is not allowed to connect to this
MySQL
server
Any ideas what we
14 matches
Mail list logo