I rearranged the query a little: SELECT DISTINCT request.id AS requestid,
request.date, request.type, request.status,
faculty.f_name, faculty.l_name, action.id AS actionid, faculty.id AS
facultyid FROM faculty, request, action WHERE request.id=action.request_id
AND
is it possible to use the '%' in a match .. against statement?
I keep getting resultsets with only whole-word matches, for example
the statement
select * from table_x where match(field_y) against ("%multi%");
does not give back the rows where field_y
(which is a TEXT field with a FULLTEXT
Kilian Looser wrote:
Hi,
i've the following setup:
LoadBalancer - five Webserver with Apache and mysql - Database
Now i got a problem. i've user's they insert records in the database. Now the insert
is going throu, for example, webserver1. Now i'm doing a select throu webserver2 and
Kilian Looser wrote:
Hi,
i've the following setup:
LoadBalancer - five Webserver with Apache and mysql - Database
Now i got a problem. i've user's they insert records in the database. Now the insert
is going throu, for example, webserver1. Now i'm doing a select throu webserver2 and
Your query selects eight fields. Your Display shows five fields. The distinct verb
works on all eight fields and
apparently some of the fields not displayed are different. Limit the query for the
display to the five fields displayed
and the distinct verb should eliminate the duplicates from the
On Wed, Mar 07, 2001 at 05:38:55PM +, Greg Cope wrote:
Paul DuBois wrote:
I've been reading the thread about SHOW DATABASES and SHOW TABLES
returning lists of blank entries or no results. Just out of curiosity,
I upgraded my RedHat 6.2 machine from MySQL 3.23.32 to MySQL 3.23.33
If I may, I'd like to have a brief explanation of how to use max_rows and
avg_row_length.
Of course I have seen them in the manual, but after trying them I just
haven't found the explanations very clear.
Thank you.
-
Before
Can anyone recomend a reliable monitoring/reporting program for mysql.
Im looking for something small, that will at given times, query mysql
and report the results.
Thanks
Jason
-
Before posting, please check:
If I INSERT DELAYED into a table with an auto_increment column and specify a
value of NULL for that column, the query fails. This is to be expected.
After this failure however, normal INSERT queries start piling up in the
'Locked' state and remain there indefinitely. The only way to get things
I have tried the above with 3.23.33 and was not able to reproduce it.
I could be wrong (imagine that!). It crashed again today even with the table
in place.
In order to take one item out of the equation, I stopped the replace delayed
process I had running. It still crashed (about 8 hours
I'm getting this erros sometimes
DBI-connect failed: Can't create a new thread (errno 11). If you are not out of
available memory, you can consult the manual for a possible OS-dependent bug at
/usr/lib/perl5/INOVA/DB/libdb.pm line 113
This beggins to happen after I set max_connections up
on 3/6/01 9:35 PM, Chris Toth at [EMAIL PROTECTED] wrote:
Ok, I've been battling this SELECT statement for the better part of the day.
The SELECT statement is this:
SELECT DISTINCT request.id AS requestid, request.date, request.type,
request.status,
faculty.f_name, faculty.l_name,
Hi,
I was trying to use debugging (creating a trace and log file) in order to
find the crashing problem we have been experiencing. However, I tend to come
up against another problem in the course of things -- mysql not shutting
down.
This time I have a log file and a trace file. When I shut
I forget to give the tail of the error log:
010307 12:33:41 Aborted connection 90714 to db: 'logging' user: 'apache'
host: `neo.f' (Got timeout reading communication pac
kets)
010307 12:33:41 Aborted connection 90722 to db: 'logging' user: 'apache'
host: `morpheus.f' (Got timeout reading
Your clibs are too old.
You need to update.
john1 wrote:
dear Sir :
MySQL 3.22 on my linux 486 PC seems work so good. when I compile
a simple C API program which catched from the MySQL tutorial, it
chokes at the end of compile process . the program is as follows:
#include stdio.h
Hi,
I tried to install the HP-UX Binary Distribution on
my HP-UX B.10.20; according to documentation I should use the command
shell /usr/sbin/swinstall -s /path/to/depot mysql.full
After I tar the Binary file, I still can't find the depot file.
Can someone tell where can I find it?
Thank you
Hi, new to the list.
I'm trying to write a MySQL backend for my website to archive/search news stories, and
other things I have on my site, http://slardy.yi.org/nu-vision/ . I know that my site
is pretty small and I could probably go with using something else but I want to learn
the basics of
Hi all,
Im new to MySQL. I have the following questions that I hope someone can
clarify for me:
(1) I have learned from this list and other users group list that
MySQL is very fast on performance.
How do they measure this performance? Is it the execution time on
the command?
with MySQL 3.23.33 on Linux, shouldn't UNIQUE columns that contain NULL
values still reject rows that are the same? this isn't working (it allows
duplicate rows to be included if one of the columns is NULL). this seems wrong.
here's an example:
mysql create table n (
Hi
I think that kill will only take effect when the server pays attention - if
it is busy (calculating statistics), then it may not respond immediately.
Regards
Quentin
-Original Message-
From: Steve Ruby [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 8 March 2001 5:19 a.m.
To: [EMAIL
Hello john,
Thursday, March 08, 2001, 12:19:22 AM, you wrote:
jrd with MySQL 3.23.33 on Linux, shouldn't UNIQUE columns that contain NULL
jrd values still reject rows that are the same? this isn't working (it allows
jrd duplicate rows to be included if one of the columns is NULL). this seems
Have you ever looked at Big Brother?
Charles Hagen
On Wed, 7 Mar 2001, jason davidson wrote:
Can anyone recomend a reliable monitoring/reporting program for mysql.
Im looking for something small, that will at given times, query mysql
and report the results.
Thanks
Jason
Do a search for an application called One Point.
Works pretty well.
Charles
On Wed, 7 Mar 2001, MikemickaloBlezien wrote:
Hello All,
Apologize for the slightly off topic. but was wondering if any one on list knows
of either a freeware or commercial program for setting up and maintaining
Hi,
We have apache 1.3.19, PHP4.0.2 and mysql installed in
our redhat linux 6.2 system. For some reasons, we got
error message " denied for user: nobody@localhost
(Password :YES)". Database in my local machine.
Code: mysql_pconnect("$localhost","$username",
"$password") or die ("couldnt connect
Hello all, I hope someone can help. I have a fresh install of Red Hat
7.0, I installed mysql-3.23.22-6.i386.rpm and then
mysql-server-3.23.22-6.i386.rpm. Supposedly the daemon is automatically
starts, well it doesn't. I tried the mysql_install_db and it runs, but
I don't think it makes the
Hello all, I hope someone can help. I have a fresh install of Red Hat
7.0, I installed mysql-3.23.22-6.i386.rpm and then
mysql-server-3.23.22-6.i386.rpm. Supposedly the daemon is automatically
starts, well it doesn't. I tried the mysql_install_db and it runs, but
I don't think it makes the
An update:
o I found other queries that were insert delayed into non-existent tables
and others that had wrong column names. Removing these, I thought would fix
things. Nope.
o I tried writing a log and a trace file. Too slow and unworkable. I tried
just log (worked OK -- I got a crash but
Hi,
Without a where clause in your initial query, you will never get to use an
index.
How many rows are there in sessobjs? From the start of the sample output, it
looks like there are several thousand, so asking a complex question may,
indeed, take a long time.
You could create a result table,
How would I copy ONE table from a database over to another?
I used this last time:
mysqldump -h mysql.io.com -u DB1 -p --opt DB1 ! backup-file.sql
mysql -h mysql.io.com -u DB2 -p DB2 backup-file.sql
But it copies the whole shebang (all tables in DB1). The situation I
have now is that I
Hello All. I have some questions / requests for advice that I hope some of you
could help me with.
I have alot of virtual domains that I want to provide MySQL access to. These
virtual domains are spread out across several servers right now and continue
to grow. On each of these servers I
Hi,
Just add your table name to the mysqldump command
Quentin
-Original Message-
From: Cindy [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 8 March 2001 2:40 p.m.
To: [EMAIL PROTECTED]
Subject: mysqldump question
How would I copy ONE table from a database over to another?
I used this
- Original Message -
From: "Joseph Greenawalt" [EMAIL PROTECTED]
To: "Mysql" [EMAIL PROTECTED]
Sent: Thursday, March 08, 2001 8:05
Subject: Ignore the previous read this one: Help! Can't get server running.
Fresh installs RedHat and Mysql RPM
Hello all, I hope someone can help. I
Hi,
I use MySQL version 3.23.33 on Windows NT 4.0 SP6. When I use the command
ALTER TABLE ... RENAME TO ... most of the time my MySQL service stop. I
need to restart it from the service control panel. I don't have any errors
in the logs. When restarted, my rename has been done correctly. Am I
Suggestion only: Tried myisamchk on the table?
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, March 08, 2001 0:10
Subject: ERROR 1030 at line 1: Got error 127 from table handler
I am using version 3.32.23 and I receive these errors frequently when
Description:
Using the pager option in .my.cnf breaks mysqldump
How-To-Repeat:
Enter the following line in your .my.conf file under the [client] group:
[client]
pager=/usr/bin/less
Execute the mysqldump command
See the following output from
mysqld got signal 11;
The manual section 'Debugging a MySQL server' tells you how to use a
stack trace and/or the core file to produce a readable backtrace that may
help in finding out why mysqld died
Attemping backtrace. You can use the following information to find out
where mysqld died. If
One more thing:
In the processlist:
| Delayed_insert | 578 | reschedule | log_day_20010307
After another minute (now over 10 minutes to reschedule) I get a _lot_ of
these:
| Query | 9| waiting for handler insert | insert delayed into
logging.log_day_20010307 ...
Which
- Original Message -
From: "Travis Gant" [EMAIL PROTECTED]
To: "MySQL Mailing List" [EMAIL PROTECTED]
Sent: Thursday, March 08, 2001 5:57
Subject: MySQL backend for website.
Hi, new to the list.
I'm trying to write a MySQL backend for my website to archive/search news
stories, and
Hello,
I've got a field named genres. It's got a bunch of different music genre's
in it. I want to let a user enter a genre to search for. Here's what I'm
using now:
SELECT * FROM $mysql_artist_table WHERE genres like '$search_genre%' ORDER
BY ARTIST ASC
And that only searches at the
Put a % at the beginning of the string "%Classical%", (which will mean that
any index is not used)
-Original Message-
From: Tyler Longren [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 8 March 2001 4:26 p.m.
To: MySQL List
Subject: Searching for string in field
Hello,
I've got a field
I would like to upgrade mysql 3.23.22to 3.23.33, anybody know how to do it?
PIVO
on 3/7/01 6:39 PM, Cindy at [EMAIL PROTECTED] wrote:
How would I copy ONE table from a database over to another?
I used this last time:
mysqldump -h mysql.io.com -u DB1 -p --opt DB1 ! backup-file.sql
mysql -h mysql.io.com -u DB2 -p DB2 backup-file.sql
But it copies the whole
Hello,
I ran some interesting queries on a certain table in my mysql-3.22.32,
solaris 2.6. The queries hanged and I got this error:
Error -1 from table handler.
Now I can only connect to the DB using the 'mysql -A' option and I
cannot access that particular table. All queries on it, even
010307 9:29:44 read_next: Got error 127 when reading table
./perf/webstats_apollo
What causes them and how can I prevent them?
Check to be sure you have enough open file descriptors. Set open-files for
safe_mysqld or hack a ulimit in there yourself.
Sincerely,
Steven Roussey
Network54.com
Hi friends,
I am a beginner for mysql. finally i was able to set it up. now i have
problems to set myodbc upthe error is like
"An error occured while copying C:\WINDOWS\SYSTEM\MFC30.DLL the computer
asks me to restart the computer and try install again. but it does not
work,
so i am looking
Dear Guys,
Is there any API or modules to connect MySQL from Python??
--
Best Regards,
Winson Chang
3F, 2, 150 Lane, Sec. 5, Hsin I Rd., Taipei, Taiwan, R.O.C.
Tel: +886-2-27225333 ext 376
Fax: +886-2-27222330
Email: [EMAIL PROTECTED]
Sir,
I want to know the name of mySQL Driver. I am using the mySQL in
JAVA.
I am waiting your reply.
Thank you.
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the
I'm trying to do a SELECT * INTO OUTFILE and I get an error saying that it
can't create the file and Errcode 2. I've tried searching the archives,
but for some reason it keeps crashing my browser.
Jennifer
~
Looking for books, software, movies,
Hi all,
When having performed a query with a LIMIT, is there any way to get
the total records that would have been retrieved without the LIMIT
being used (other than building and executing a separate COUNT (*)
query) ?
Please CC to this email address as I'm not currently
subscribed to the
hello;
I meet a problem when I wont to install mysql3-23-33.
after I run the command
./configure
a error report to me
the last several line are printed as followed:
"
checking whether stat file-mode macros are broken... no
checking return type of signal handlers... void
checking for
I have mysql 3.23.32 source tarball and Berkely DB 3.2.3h source
tarball.
BDB : configure --enable-static --enable-cxx; make ; make install
MySQL : configure --prefix=/usr/local/mysql --with-mysqld-user=mysql
--enable-thread-safe-client ; make ; make install.
on 3/8/01 12:13 AM, Jennifer at [EMAIL PROTECTED] wrote:
I'm trying to do a SELECT * INTO OUTFILE and I get an error saying that it
can't create the file and Errcode 2. I've tried searching the archives,
but for some reason it keeps crashing my browser.
On my system (Mac OS X) errcode 2 in
101 - 152 of 152 matches
Mail list logo