Sorry for "hijacking" this question, but while we are on this topic:
How can one select unique rows based on a set of fields
select distinct state_ID from financial_master where category_id='1'
only returns rows based on the uniqueness of one field.
what if there is another field that COMBINED w
Hi,
Does InnoDB use any of these variables:
bulk_insert_buffer_size
join_buffer_size
key_buffer_size
read_buffer_size
read_rnd_buffer_size
sort_buffer_size
table_cache
thread_concurrency
Thanks in advance,
Mikhail.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Thanks!
Paul DuBois wrote:
> At 3:29 PM -0400 9/14/03, Jordan Morgan wrote:
> >Hi,
> >
> >Can anyone of you kindly tell me what that error usually means? The
> >line number
> >given is always the last line of the script and I'm sure it means something in
> >particular but I just don't know.
> >
>
Hi Pete,
Thanks for this info
Regards,
Delz
- Original Message -
From: "Peter Vertes" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, September 14, 2003 12:05 AM
Subject: Re: Date computation in MySQL & PHP
> On Sat, 2003-09-13 at 02:50, delz wrote:
>
>
> > I want to know
I don't see a admin email address in the headers of the musql email list
emails, for the past few days, every post I make, I get one of these from
someone...
Return-Path: <>
Received: from fc.jcca.org (204.141.205.3) by hostwizard.com with ESMTP
(Eudora Internet Mail Server 3.2.1) for <[EMAIL PR
At 6:33 PM -0700 9/14/03, Scott Haneda wrote:
on 09/14/2003 06:14 PM, Paul DuBois at [EMAIL PROTECTED] wrote:
ORDER BY IF(sort_order IS NULL,1,0), sort_order, added;
select title, sort_order from resources order by IF(sort_order IS NULL,1,0)
sort_order ASC limit 5;
ERROR 1064: You have an error i
At 6:27 PM -0700 9/14/03, Scott Haneda wrote:
on 09/14/2003 06:14 PM, Paul DuBois at [EMAIL PROTECTED] wrote:
You can force NULL values to be sorted to either end by adding another
sort column:
ORDER BY IF(sort_order IS NULL,1,0), sort_order, added;
That'll sort NULL values at the end. Use I
KINS E-mailHi all,
I plan to make SQL queries in different threads(pthread) maked with mysql C API.
Can I use the same Connection object in all threads for the queries ?
Or should I use a different Connection object for each thread ?
p.s If it is possible, let me get some example code.
on 09/14/2003 06:14 PM, Paul DuBois at [EMAIL PROTECTED] wrote:
> ORDER BY IF(sort_order IS NULL,1,0), sort_order, added;
select title, sort_order from resources order by IF(sort_order IS NULL,1,0)
sort_order ASC limit 5;
ERROR 1064: You have an error in your SQL syntax near 'sort_order ASC limi
on 09/14/2003 06:14 PM, Paul DuBois at [EMAIL PROTECTED] wrote:
> You can force NULL values to be sorted to either end by adding another
> sort column:
>
> ORDER BY IF(sort_order IS NULL,1,0), sort_order, added;
>
> That'll sort NULL values at the end. Use IF(sort_ORDER IS NULL,0,1)
> to sort t
At 5:52 PM -0700 9/14/03, Scott Haneda wrote:
Im having a little trouble getting sorting to do what I want...
describe resources;
+-+---+--+-+-++
| Field | Type | Null | Key | Default | Extra |
+-+-
What would be the best approach to categorizing records in mysql?
I have a text file that contains a \r list of words, such as:
Red
Orange
Yellow
Green
I use that list to generate html checkboxes.
Each record can have none to all of the categories selected.
In a select, I want to find all record
Im having a little trouble getting sorting to do what I want...
describe resources;
+-+---+--+-+-++
| Field | Type | Null | Key | Default | Extra |
+-+---+--+-+-+
>> Using the OS X binary dist of mysql 4.0.14.
>>
>> I put my.cnf in both the data dir and /etc, restarted the server, but it
>> doesn't seem to be reading the config.
>>
>> I added these options to the my-large.cnf under [mysqld]:
>> safe-show-database
>> safe-user-create
>
> H
Using the OS X binary dist of mysql 4.0.14.
I put my.cnf in both the data dir and /etc, restarted the server, but it
doesn't seem to be reading the config.
I added these options to the my-large.cnf under [mysqld]:
safe-show-database
safe-user-create
And tested with a user who had no priv
At 12:04 PM +0200 9/14/03, [EMAIL PROTECTED] wrote:
I have a very strange table.
Its cols are changing dynamicly.
Not all cols are all the time in the list.
Now I'd like to know if "something" is in any of the fields contended.
I'd like to make a "SELECT * FROM table WHERE any field contains 'some
At 3:29 PM -0400 9/14/03, Jordan Morgan wrote:
Hi,
Can anyone of you kindly tell me what that error usually means? The
line number
given is always the last line of the script and I'm sure it means something in
particular but I just don't know.
Parse error: parse error, unexpected $ in XX.php4 on
At 2:58 PM -0400 9/14/03, Randall Perry wrote:
Using the OS X binary dist of mysql 4.0.14.
I put my.cnf in both the data dir and /etc, restarted the server, but it
doesn't seem to be reading the config.
I added these options to the my-large.cnf under [mysqld]:
safe-show-database
safe-user-
WOW! It worked! What's the darn difference? Man, you're the greatest! I'm really
really glad that we have people like you who are so willing and kind enough to
help others!
Your help is greatly appreciated! :)
Jordan
David Sears wrote:
> OK,
>
> The server is complaining about the p
Hi John,
- Original Message -
From: "John May"
Sent: Sunday, September 14, 2003 7:52 AM
Subject: Initial Table Access Slowness
> I'm noticing that if a table hasn't been used in a while, it takes
> MySQL considerably longer than normal to do the first access of it.
> Once that happens, i
Using the OS X binary dist of mysql 4.0.14.
I put my.cnf in both the data dir and /etc, restarted the server, but it
doesn't seem to be reading the config.
I added these options to the my-large.cnf under [mysqld]:
safe-show-database
safe-user-create
And tested with a user who had no priv
shoot, my MySQL is of version 3.23.54. :(( how do I modify mine to make it work
then? Thanks!
** it's hard to be a newbie**
David Sears wrote:
> I see the syntax error output on your search page. I've tested the query
> against empty tables on mysql version 4.0.14 without error. I copied the
>
I see the syntax error output on your search page. I've tested the query
against empty tables on mysql version 4.0.14 without error. I copied the
query from the output of your search page to my client, and it still doesn't
error on 4.0.14.
I guess I should have asked which version of the server yo
I tried the parentheses () first and still it didn't work. :(
David Sears wrote:
> That's parentheses () around the inner join, not braces {}.
>
> -Original Message-
> From: Jordan Morgan [mailto:[EMAIL PROTECTED]
> Sent: Sunday, September 14, 2003 12:56 PM
> To: David Sears
> Cc: [EMAI
That's parentheses () around the inner join, not braces {}.
-Original Message-
From: Jordan Morgan [mailto:[EMAIL PROTECTED]
Sent: Sunday, September 14, 2003 12:56 PM
To: David Sears
Cc: [EMAIL PROTECTED]
Subject: Re: Newbies asking help with LEFT JOIN
Thanks for the prompt response Davi
Hi,
Can anyone of you kindly tell me what that error usually means? The line number
given is always the last line of the script and I'm sure it means something in
particular but I just don't know.
Parse error: parse error, unexpected $ in XX.php4 on line 167
Thanks!
Jordan
--
MySQL General M
Using the OS X binary dist of mysql 4.0.14.
I put my.cnf in both the data dir and /etc, restarted the server, but it
doesn't seem to be reading the config.
I added these options to the my-large.cnf under [mysqld]:
safe-show-database
safe-user-create
And tested with a user who had no priv
Hi, I sent this message once already, but it didn't show up google
groups and I got no replies so I'm sending it again. If it is a dupe I
appologize.
I have a master -> slave setup that's been working for years. Then
yesterday I shutdown the slave with a "shutdown -r now", added some more
ram,
Thanks for the prompt response David. However, it still doesn't work.
The search page is here:
http://www.jordymaeproductions.com/PHP/latest/SearchFaculty.php4
I have a faculty from IT department named Debbie Farmer who is an instructor
with a tenure status of "Not on Tenure Track". So if I typed
--- Begin Message ---
After installing MySQL 4.1 on a Win2K machine, I tried to run the
mysql_fix_privilege_tables.sql script. I got the duplicate column name
errors which the documentation says I can safely ignore. However, I also
got this error:
ERROR 1064 at line 67: You have an error in your S
I didn't have the fortitude to populate the tables with data, so I don't
know if this will work for you, but to use explicit joins try something like
the sample below. (Note that I don't like to type as much as you do:-)
select distinct IE.title, FP.LastName, FP.FirstName
from InstitutionEmploymen
Hi to all,
I am new member here.
I have a question about REPLICATE_IGNORE_DB,
I have two mysql server (4.0.15) with replication A->B->A
All work fine
Now, I want to ignore one database.
I have try this command:
CHANGE MASTER TO REPLICATE_IGNORE_DB = 'PMA';
... but it don't work.
"You have an
Hi all,
I'm trying to setup a failover mysql server, and for that I need
replication. Now here's is how I would do it (3 servers, A and B are
located next to each other, C is off site):
A is master of B
B is master of A
B is master of C
Now I don't think this will cause much problems, as the doc
I'm noticing that if a table hasn't been used in a while, it takes
MySQL considerably longer than normal to do the first access of it.
Once that happens, it's back up to speed.
Any idea on why this happens? I'm assuming maybe the table file gets
closed? Any way to bump up RAM to keep all tabl
I have a very strange table.
Its cols are changing dynamicly.
Not all cols are all the time in the list.
Now I'd like to know if "something" is in any of the fields contended.
I'd like to make a "SELECT * FROM table WHERE any field contains 'something' "
I dont wand a workaround ... I know I cou
Paul DuBois wrote:
At 5:24 PM +0200 9/13/03, karim bernardet wrote:
[EMAIL PROTECTED] wrote:
From mysql manual:
If you want to create the resulting file on some other host than the
server host, you can't use SELECT ... INTO OUTFILE. In this case you
should instead use some client program like
Stephen Tiano wrote:
What I'd like to do is create a textfile and then import the whole thing
into a table. So, naturally, I've a few questions.
Do I need to include the column heads as a line in my textfile, or can I
simply go straight to the data?
No ... you can simply go straight to the data
This version makes the startup and shutdown of MySQL Server on RedHat systems look
prettier. Perhaps the development team would consider using it? 8-D
It is in unified patch format.
Joseph Wagner
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
38 matches
Mail list logo
