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 a
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
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
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';
++-+
|
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));
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
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_idMEDIUMINT
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 AUTO_INCREMENT,
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
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
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.
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.
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( expr, 2 ) AS SIGNED )?
PB
--
mos wrote:
At 05:43 PM 12/18/2005, James Harvard wrote:
Maybe I'm missing
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
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,
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( expr, 2 ) AS SIGNED )?
PB
--
PB,
Yes it looks like I'll
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:
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 want
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' ) )
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,
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.
--
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 the
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
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 annoying to
*/-\ /-\
* / \ / \
* / X \
* / / \ \
*/ / \ \
*|A| B | C |
*\ \ / /
* \
*/-\ /-\
* / \ / \
* / X \
* / / \ \
*/ / \ \
*|A| B | C |
*\ \ / /
* \
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 with each
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 filtering
of
- Original Message -
From: [EMAIL PROTECTED]
To: Bruce Carey [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
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
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]
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
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
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
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
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 advice
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
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
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='#*#*#'
q
Any of the field- or
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
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
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
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:
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
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
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).
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
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.g
The expression is an expression based on columns in the table, as in:
select
- Original Message -
From: Tripp Bishop [EMAIL PROTECTED]
To: mysql@lists.mysql.com
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
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
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
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: mysql@lists.mysql.com
Sent: Monday, December 19, 2005 3:45 PM
Subject: Re:
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.id
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
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
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
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
Are there two option?
How to use them?
- Original Message -
From: Andreas Streichardt [EMAIL PROTECTED]
To: mysql@lists.mysql.com
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,
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: mysql@lists.mysql.com
Sent:
export LANG=zh_CN.UTF-8
- Original Message -
From: wangxu [EMAIL PROTECTED]
To: Andreas Streichardt [EMAIL PROTECTED]; mysql@lists.mysql.com
Sent: Tuesday, December 20, 2005 10:10 AM
Subject: Re: (瑞星提示-此邮件可能是垃圾邮件)Re: insert utf8 character in Linux commind-line
tool
Are there two
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 Reply
60 matches
Mail list logo