On Monday 19 December 2005 08:21, Rhino said something like:
> While "Reply to all" has the desired effect, I've always found it a
> pain-in-the-ass. I subscribe to a handful of other mailing lists and
> I always forget when my replies should be sent with "Reply" and when
> they should be sent with
export LANG=zh_CN.UTF-8
- Original Message -
From: "wangxu" <[EMAIL PROTECTED]>
To: "Andreas Streichardt" <[EMAIL PROTECTED]>;
Sent: Tuesday, December 20, 2005 10:10 AM
Subject: Re: (瑞星提示-此邮件可能是垃圾邮件)Re: insert utf8 character in Linux commind-line
tool
> Are there two option?
> How to u
I import utf8 character in terminal commind-line is well.So in my
word,there aren't error in my terminal settings.
I can't import utf8 character when mysql commind-ling tool start only.
- Original Message -
From: "Gleb Paharenko" <[EMAIL PROTECTED]>
To:
Sent: Monday, December 19
Are there two option?
How to use them?
- Original Message -
From: "Andreas Streichardt" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, December 20, 2005 3:55 AM
Subject: (瑞星提示-此邮件可能是垃圾邮件)Re: insert utf8 character in Linux commind-line tool
On Monday 19 December 2005 08:47, wangxu wrote:
> I c
Hi Mike,
If you only want the squares displayed, you could then do
select pow(((col1+col2+col3)/col4),2), pow(((col5+col6+col7)/col8),2)
... table1
Regards
David Logan
Database Administrator
HP Managed Services
148 Frome Street,
Adelaide 5000
Australia
+61 8 8408 4273 - Work
+61 417 268 665
At 03:30 PM 12/19/2005, Logan, David (SST - Adelaide) wrote:
Why not then use user variables? eg.
select @a:=((col1+col2+col3)/col4), @b:=((col5+col6+col7)/col8),
pow(@a,2), pow(@b,2) ... table1
Regards
David Logan
Database Administrator
HP Managed Services
148 Frome Street,
Adelaide 5000
Aus
Hi,
Could anyone explain what might be the possible reasons that in the slow
query log(running read-only queries) the most very slow queries(taking
200-300sec) were the queries:
1. create table ... type = MyISAM
2. show slave status
Thanks,
Jenny
OK, I spoke a little too soon. Users can no longer list all
databases, which is great. Unfortunately, they also can't list their
own, resulting in errors when they log into phpMyAdmin:
SQL-query: SHOW DATABASES ;
MySQL said: #1045 - Access denied for user:
'[EMAIL PROTECTED]' (Using passwor
Ryan Allbaugh <[EMAIL PROTECTED]> wrote on 12/19/2005 04:41:39 PM:
> I am using MySQL 5.0.15 on windows and cannot run this query:
>
> SELECT a.*,b.name, c.fullname,d.fullname
> FROM access_authorization a, building b
> LEFT JOIN users c ON a.createdby=c.id
> LEFT JOIN users d ON a.modifiedby=d.i
Rhino,
Sorry about that. I'm running 5.0.15. I'll explore the
prepared statement angle.
Cheers,
Tripp
--- Rhino <[EMAIL PROTECTED]> wrote:
>
> - Original Message -
> From: "Tripp Bishop" <[EMAIL PROTECTED]>
> To:
> Sent: Monday, December 19, 2005 3:45 PM
> Subject: Re: Declare Curso
I am using MySQL 5.0.15 on windows and cannot run this query:
SELECT a.*,b.name, c.fullname,d.fullname
FROM access_authorization a, building b
LEFT JOIN users c ON a.createdby=c.id
LEFT JOIN users d ON a.modifiedby=d.id
WHERE a.sortcode=b.sortcode AND
a.sortcode like '1,2,1,6%' LIMIT 0, 25
I re
Why not then use user variables? eg.
select @a:=((col1+col2+col3)/col4), @b:=((col5+col6+col7)/col8),
pow(@a,2), pow(@b,2) ... table1
Regards
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 8
- Original Message -
From: "Tripp Bishop" <[EMAIL PROTECTED]>
To:
Sent: Monday, December 19, 2005 3:45 PM
Subject: Re: Declare Cursor Question
Howdy all,
I've got a question about declaring cursors. In
particular is there a way to allow the select
statement used to populate the cur
At 02:32 PM 12/19/2005, Elmar von Muralt wrote:
Mike,
How about:
temp1 = [Expression]
temp2 = temp1 * temp1
This should be quick enough, assuming tempN are cast as integers
Elmar
Nope, not quite.
The expression is an expression based on columns in the table, as in:
select ((col1+col2+col3)
Hallo!
To Gleb Paharenko:
Thank you for your answer!
When I am upgrading from MySql 4.0 to 5.0 it is recommanded to dump in
4.0 and restore in 5.0. Therefore I can not use mysqldump of 5.0,
because if I can simply open the databases with 5.0 I do not have to
dump and restore. And of course
Hi Shawn,
>
> I have never tried any of the NATURAL joins so your results were very
> interesting to me. The order in which the rows were joined provides you
> with some insight about how the engine actually performs the joins (which
> table is in the outer loop and which is in the inner loop). *w
Howdy all,
I've got a question about declaring cursors. In
particular is there a way to allow the select
statement used to populate the cursor be variable?
I've tried a couple of the obvious approaches with no
luck. Failing that, is there a way to have a cursor be
an input parameter to a stored pr
Mike,
How about:
temp1 = [Expression]
temp2 = temp1 * temp1
This should be quick enough, assuming tempN are cast as integers
Elmar
mos wrote:
At 08:30 AM 12/19/2005, Peter Brawley wrote:
>Yes, it's a bit more complicated than that. I'm using an
expression
>so I don't want to have
Hello.
Check your terminal settings. Have a look here:
http://dev.mysql.com/doc/refman/5.0/en/charset.html
http://dev.mysql.com/doc/refman/5.0/en/charset-unicode.html
>I can't operate utf8 characters within command-line in linux operating
>system. Mysql doesn't support?
wangxu wrote
Great, that's further than I was before...
SO, about the problem of enclosing the fields:
- if I am going to have " and \r and \n in fields, what
should I enclose them with?
- my problem is that when a text field, with html in it,
it makes it into several hundred recs
- maybe a different line/r
Great, that's further than I was before...
SO, about the problem of enclosing the fields:
- if I am going to have " and \r and \n in fields, what
should I enclose them with?
- my problem is that when a text field, with html in it,
it makes it into several hundred recs
- maybe a different lin/re
On Monday 19 December 2005 08:47, wangxu wrote:
> I can't operate utf8 characters within command-line in linux operating
> system. Mysql doesn't support?
--without-libedit –with-readline=/usr/include/readline
that fixed it for me
Kind Regards,
Andreas Streichardt
--
MySQL Gener
Bruce Carey wrote:
> I posted this earlier, could someone take a look at it?
In the time since you first posted, you could have at least glanced
at the Fine Manual :-) which shows that:
>> mysqldump --opt --fields-terminated-by='\t'
>> --fields-optionally-enclosed-by='#*#*#'
Any of the field-
Hi,
MySQL 5.0.17, a new version of the popular Open Source Database
Management System, has been released. The Community Edition is now
available in source and binary form for a number of platforms from our
download pages at
http://dev.mysql.com/downloads/
and mirror sites.
Note that not all
Sorry, never mind. I found that I had "misspelled" the user name when I
added it back into the database. I had a dash (-) in there when there
shouldn't have been. I removed the dash from the user name and everything
is working great now.
But, I would have expected that MySQL (or the connect
I posted this earlier, could someone take a look at it?
TIA,
Bruce.
On Mon, 19 Dec 2005 02:15:54 -0500
"Bruce Carey" <[EMAIL PROTECTED]> wrote:
Hi List,
I have recently had a crash coursh in the fineer points
of db recovery due to a mis-managed server.
Could someone help me out with advi
I have finished my ASP.Net/MySQL 5.0 application on my development machine. I
am now ready to move it to our server. We do not currently have MySQL
installed on our web server, so I figured I'd go through the motions of getting
everything installed and running on my laptop. That way I would kn
Yes, I think it's a good design for the type of data you are trying to
describe and the application I think you are trying to build. That
opinion is qualified because I do not know all of the details to your
particular project so I cannot say for certain that this design is
absolutely better
Thanks ALOT!
So you would say that this is good database design and that this method and
query is the best way to store and retrive product specifications?
Quoting [EMAIL PROTECTED]:
> Is this good enough?
>
> SELECT prodid, count(1) matches
> FROM PRODUCT_SPECS
> WHERE (where SPEC_ID=1 and VA
Hi I need some optimization help.
I currently have this query "SELECT COUNT(*) as count,sum(p.amt) as
total,p.batch,m.username,m.id,p.method,DATE_FORMAT(p.occur, '%M %d, %Y') as
dateBought FROM pay p LEFT JOIN members m ON m.id=p.mid WHERE
p.method!='none' AND p.method!='' GROUP BY p.batch ORDE
This is addressed in the FAQ for the mailing lists.
http://lists.mysql.com/faq.php#replyto
Jim Winstead
MySQL Inc.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Bruce Carey" <[EMAIL PROTECTED]>
Cc:
Sent: Monday, December 19, 2005 11:56 AM
Subject: Re: this listserv function...?
"Bruce Carey" <[EMAIL PROTECTED]> wrote on 12/19/2005 11:29:56 AM:
I am experiencig an odd thing when usig thi
news <[EMAIL PROTECTED]> wrote on 12/19/2005 11:37:41 AM:
> Hi Shawn,
>
> > That means that MySQL supports the means to determine what rows are in
> > each area of our diagram based on the direction of the join (INNER,
LEFT,
> > or RIGHT), the conditions declared in the ON clause, and any filter
news <[EMAIL PROTECTED]> wrote on 12/19/2005 11:28:36 AM:
> Hi Shawn,
>
>
> It's beginning to build a lot of information in a single message. So I
cut
> it in parts.
>
>
> > In order to compute the intermediate table, each row on the left side
of
> > the predicate is evaluated in combination
> >
> > */-\ /-\
> > * / \ / \
> > * / X \
> > * / / \ \
> > */ / \ \
> > *|A| B | C |
> > *\ \ / /
> >
> > */-\ /-\
> > * / \ / \
> > * / X \
> > * / / \ \
> > */ / \ \
> > *|A| B | C |
> > *\ \ / /
> > *
"Bruce Carey" <[EMAIL PROTECTED]> wrote on 12/19/2005 11:29:56 AM:
>
> I am experiencig an odd thing when usig this listserv.
> When replying to posts, my replies are being addressed to
> the sender, not going back to the list. Does this list not
> have the reply-to enabled?
>
> Going to be a
Hi Shawn,
It's beginning to build a lot of information in a single message. So I cut
it in parts.
> In order to compute the intermediate table, each row on the left side of
> the predicate is evaluated in combination with each and every row from the
> right side of the predicate. If the ON cla
> What kind of values do you want charted? Have you looked at the binlogs to
> see what is available? What you want to chart may not be part of the
> actual data so you may want to expand your search to the general log file
> as well. If you want database statistics, those are available through
I am experiencig an odd thing when usig this listserv.
When replying to posts, my replies are being addressed to
the sender, not going back to the list. Does this list not
have the reply-to enabled?
Going to be annoying to have to watch that all the time.
Let me know, thanks,
Bruce.
--
My
nm ... I found the problem ... I need to use BINARY(LPAD ...)
-Original Message-
From: Rob Brooks [mailto:[EMAIL PROTECTED]
Sent: Monday, December 19, 2005 10:04 AM
To: mysql@lists.mysql.com
Subject: Query Error Help
Hello, I have this query:
SELECT FL3_PatientControlNumber, claims.R
Hello, I have this query:
SELECT FL3_PatientControlNumber, claims.RecordKey as reckey,
FL1_ProviderName, CalcFlag
FROM claims INNER JOIN service_line ON service_line.ClaimKey =
claims.RecordKey
WHERE ( service_line.FL42_ServiceLineRevCode BETWEEN LPAD('110',4,'0') AND
LPAD('210',4,'0' ) ) OR
Christian Meisinger <[EMAIL PROTECTED]> wrote on 12/19/2005
10:46:39 AM:
> Does anyone know a script/program to create statistics or graphs
> from a binary mysql logfile?
>
> A graph view daily, monthly data andsoon would be great.
>
>
>best regards chris
>
What kind of values do you wan
Does anyone know a script/program to create statistics or graphs
from a binary mysql logfile?
A graph view daily, monthly data andsoon would be great.
best regards chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.
At 08:30 AM 12/19/2005, Peter Brawley wrote:
>Yes, it's a bit more complicated than that. I'm using an expression
>so I don't want to have to repeat the whole expression all over again.
What's wrong with CAST( POWER( , 2 ) AS SIGNED )?
PB
--
PB,
Yes it looks like I'll hav
This did the trick. Many thanks. I had found that option, but
misinterpreted what I read; I thought it was only available in 4.x.
Thanks again!
-Bill
On Dec 14, 2005, at 6:59 PM, Michael Stassen wrote:
William R. Dickson wrote:
OK, I strongly suspect I've just done something stupid here, bu
Hello,
I want to synchronise read and write access to a MySQL database in a
cluster. Advisory locking would be fine, but I want to lock out writes
during reads while still being able to do multiple reads at the same time.
I can't see how to do this with GET_LOCK, and table locks have annoying
>Yes, it's a bit more complicated than that. I'm using an
expression
>so I don't want to have to repeat the whole expression all over again.
What's wrong with CAST( POWER( , 2 ) AS SIGNED )?
PB
--
mos wrote:
At 05:43 PM 12/18/2005, James Harvard wrote:
Maybe I'm missing somethi
Hello.
>From the manual we have that innodb_data_file_path contains paths to
individual data files and their sizes. The full directory path to each
data file is acquired by concatenating innodb_data_home_dir to each path
specified here. Many other ibd files are result of per-file tablespace.
Hello.
Increase the innodb_buffer_pool_size. See:
http://dev.mysql.com/doc/refman/5.0/en/innodb-tuning.html
>I create index is too slow in a large innodb table.The same thing
>happened in drop index.
>Can i optimize these operations?wangxu wrote:
--
For technical support contracts,
Hello.
At least, some notes we have at:
http://dev.mysql.com/doc/refman/5.0/en/create-procedure.html
"Currently, the DETERMINISTIC characteristic is accepted, but not yet
used by the optimizer. However, if binary logging is enabled, this
characteristic affects whether MySQL accepts routi
Is this good enough?
SELECT prodid, count(1) matches
FROM PRODUCT_SPECS
WHERE (where SPEC_ID=1 and VALUE=YES)
OR(and SPEC_ID=5 and VALUE>=28)
GROUP BY prodid
HAVING matches=2;
This query form is flexible enough so that if, for instance, you just
wanted to rank products based on how well they ma
On Monday 19 December 2005 14:09, [EMAIL PROTECTED] wrote:
> > CREATE TABLE category (
> > category_id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT,
> > nameCHAR(15) NOT NULL,
> > PRIMARY KEY (category_id)
> > );
> > CREATE TABLE albums (
> > album_idMEDIUMINT UNSIGNED NOT NULL AU
Jørn Dahl-Stamnes <[EMAIL PROTECTED]> wrote on 12/19/2005 06:10:55
AM:
> I have two tables;
>
> CREATE TABLE category (
> category_id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT,
> nameCHAR(15) NOT NULL,
> PRIMARY KEY (category_id)
> );
> CREATE TABLE albums (
> album_idMEDIUM
Great, :)
But do you know how to write a good select query using this design?
For example if i want to select all TV with widescreen and inch greater than 28?
select * from PRODUCT_SPECS (where SPEC_ID=1 and VALUE=YES)
(and SPEC_ID=5 and VALUE>=28)
this doesnt feel right...
From: SGreen at uni
On Sun, 18 Dec 2005, mos wrote:
> How do I square a number in MySQL 4.1? I thought it would be something simple
> like:
>
> select 3**2
>
> but that produces a syntax error. I can use Pow(3,2) but that produces a
> float. Is there a Square function? TIA
mysql> select floor(pow(3,2));
+-
Thanks James,
I looked at http://dev.mysql.com/doc/refman/5.0/en/tables-table.html
for the table properties in the Information_Schema.Tables. I tried:
SELECT table_name, update_time FROM Information_Schema.Tables
WHERE table_name LIKE 'section05';
++-+
| table_name
I have two tables;
CREATE TABLE category (
category_id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT,
nameCHAR(15) NOT NULL,
PRIMARY KEY (category_id)
);
CREATE TABLE albums (
album_idMEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT,
category_id MEDIUMINT UNSIGNED NOT NULL,
PRIMARY
I suppose you could parse out and compare the update_time value from SHOW TABLE
STATUS
http://dev.mysql.com/doc/refman/4.1/en/show-table-status.html (or maybe there's
a simpler way with MySQL 5's new schema database
http://dev.mysql.com/doc/refman/5.0/en/information-schema.html ) and compare it
On Sun, 18 Dec 2005, Octavian Rasnita wrote:
> Hi,
>
> Please tell me how can I configure MySQL 5 in order to be able to search
> (using fulltext indexes) for combined words like "s-au".
>
> This is a single word and not 2 words but I think MySQL thinks that there
> are 2 words, one of them having
60 matches
Mail list logo
