[EMAIL PROTECTED] wrote:
I have a curious situation I was hoping someone could shed some light on.
mysql> select count(*) table;
+---+
| table |
+---+
| 0 |
+---+
1 row in set (0.00 sec)
mysql> select count(*) from table;
+--+
| count(*) |
+--+
|25965 |
+
I have a curious situation I was hoping someone could shed some light on.
mysql> select count(*) table;
+---+
| table |
+---+
| 0 |
+---+
1 row in set (0.00 sec)
mysql> select count(*) from table;
+--+
| count(*) |
+--+
|25965 |
+--+
1 row in set (0.00 se
On Friday 13 May 2005 18:21, Gordon wrote:
> If you can add a table structure why not create a SELECTED table with
> REPORT ID and PERSON ID as the 2 field PRIMARY KEY.
>
> Then you could INSERT IGNORE into this table [with no BEGN/COMMIT] and the
> IGNORE would throw away those already selected.
Ware Adams wrote:
On May 13, 2005, at 8:34 PM, Hassan Schroeder wrote:
Ong Khai Chin wrote:
Warning: mysql_connect(): Client does not support authentication
protocol requested by server; consider upgrading MySQL client in C:
\Program Files\Apache Group\Apache2\htdocs\mysqltest.php on line 2
Cou
Terence wrote:
Hi List,
When using EXPLAIN, the key length on an integer column is stated as 4.
However the column is running into 7 digits, and that's affecting our
performance. Anyway to increase the key length?
From the manual I have found that it can be done for varchar cols.
Thanks for any
Hi List,
When using EXPLAIN, the key length on an integer column is stated as 4.
However the column is running into 7 digits, and that's affecting our
performance. Anyway to increase the key length?
From the manual I have found that it can be done for varchar cols.
Thanks for any help.
--
MySQL
On May 13, 2005, at 8:34 PM, Hassan Schroeder wrote:
Ong Khai Chin wrote:
Warning: mysql_connect(): Client does not support authentication
protocol requested by server; consider upgrading MySQL client in C:
\Program Files\Apache Group\Apache2\htdocs\mysqltest.php on line 2
Could not connect: Cl
Ong Khai Chin wrote:
I alread sucessfully install mySQL, Apache and PHP. ...
> The problem is i am unable to connect PHP to MySQL..
Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:\Program Files\Apache Group\Apache2
in() can take millions of arguments. Up to max packet size. Try it :)
Dan Bolser wrote:
On Fri, 13 May 2005, Eric Bergen wrote:
Even better is if you have an integer primary key (think auto_increment)
and use in()
So if you want 10 random rows in your app generate 20 or so random
numbers and
On Fri, 13 May 2005, Eric Bergen wrote:
>Even better is if you have an integer primary key (think auto_increment)
>and use in()
>
>So if you want 10 random rows in your app generate 20 or so random
>numbers and do something like
>select col1, from t where x in (1, 5, 3, 2...) limit 10
>
>check n
Hello.
You have a rather old version and it is built manually. I suggest you
to upgrade to the latest release (4.1.11 or if it is impossible, then
to 4.0.24). And check if problem is solved after that.
kevin korngut <[EMAIL PROTECTED]> wrote:
> [-- text/plain, encoding 7bit, charset:
I alread sucessfully install mySQL, Apache and PHP. and i able to operate on
PHP,MYSQL and Apache. The problem is i am unable to connect PHP to MySQL..
Warning: mysql_connect(): Client does not support authentication protocol
requested by server; consider upgrading MySQL client in C:\P
Hi,
I have just installed mysql-query-browser-1.1.7 on my SuSE v9.1 box. While
trying to run mysql-query-browser, I got the following error message:
./mysql-query-browser-bin: error while loading shared libraries:
./mysql-query-browser-bin: undefined symbol: gdk_threads_lock
I have /opt/gnome/l
Ed Reed wrote:
But if the user happens to put a numeric value within the text
somewhere then UCASE and UPPER both fail to convert the text to upper case.
Can you give an example? I think there's something else going on that you're
overlooking. UPPER() and UCASE() (which are synonyms for the same
Is there anyway to force UCASE and UPPER to convert the alpha characters of a
string even if there's a number in the string somewhere?
I have a field that contains large amounts of user entered text. I want to
convert the whole thing to upper case so I can do a case insensitive compare
against
Wow, that's simply magic!!!
You couldn't imagine how many diferent things I've tried
to solve this problem..
And when I thought it was impossible ...your solution worked
just fine at once!
God bless experienced people!!
The reason for trying to do such a weird thing on col_type
is that a need
I'm attempting to configure mysql with InnoDB tables and I'm running
into problems. And am using the following version of mysqld-max, Ver
4.0.18-Max for suse-linux on i686 (Source distribution)
First I uncommented the following lines in /etc/my.cnf:
# Uncomment the following if you are using
What is the output of the following:
EXPLAIN select * from terms where term like 'Britney Spears' limit 1;
select_type = SIMPLE
table = terms
type = range
possible_keys = term, term_2 (I just created term_2, fulltext)
key = term (this means it's not using the one I just created?)
key_len = 255
ref
Brian,
What is the output of the following:
EXPLAIN select * from terms where term like 'Britney Spears' limit 1;
Running this statement will produce info on what index path is being used in
the query. Also, can you use "=" instead of "like" in your query?
Partha
--
Partha Dutta, Senior Consul
I would like to store the complete database into a WORM device (Write Once Read
Many). I would like to access this database directly from the WORM device and
perform read only SQL statements against this device.
I intend to create the database on a re-writable device (not WORM). At some
point, w
"select * from terms where term like 'Britney Spears' limit 1;"
This is taking anywhere from 35-55 seconds. There are only 350,000
records. Here are the indexes:
Keyname = PRIMARY; Type = PRIMARY; Field = id
Keyname = term; Type = UNIQUE; Field = term
Keyname = category; Type = INDEX; Fi
Hello.
In my previous post I gave you a link to the thread where had
been described how to create the my_global.h. Have you tried that?
>Hi,
> U replied me without any contents. pls help me by giving some tips.
>
> Thanks and Regards,
>Ashok Kumar.P.S.
--
For techni
select count(*) from table is the fastest for myisam because it caches
row count. This will also include any rows that have null values.
select count(col) from table will not count rows where that column is
null and will also be forced to access the index or data file.
-Eric
Brian Dunning wrote
I've been doing the following to get the record count from a db. Is
this the fastest?
select count(id) as `count` from tablename;
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Even better is if you have an integer primary key (think auto_increment)
and use in()
So if you want 10 random rows in your app generate 20 or so random
numbers and do something like
select col1, from t where x in (1, 5, 3, 2...) limit 10
check num rows and if you don't get enough generate more
I have a unique field, varchar(100), that I do most of my searching
on. I have an index that includes this and several other fields.
Would it be more efficient to make this a text field and give it its
own fulltext index? Would it be more efficient to not have the other
fields in the same i
If you can add a table structure why not create a SELECTED table with REPORT
ID and PERSON ID as the 2 field PRIMARY KEY.
Then you could INSERT IGNORE into this table [with no BEGN/COMMIT] and the
IGNORE would throw away those already selected.
-Original Message-
From: Duncan Hill [mailto
I have a db of about 300,000 records and when I try to find one random record
like this:
select * from table order by rand() limit 1;
it can take several minutes. My Sherlock Holmes instincts tell me that what
I'm doing is somehow inefficient. What is the primary culprit here?
The culprit is tha
At 12:54 PM 5/13/05, Brian Dunning wrote:
I have a db of about 300,000 records and when I try to find one
random record like this:
select * from table order by rand() limit 1;
it can take several minutes. My Sherlock Holmes instincts tell me
that what I'm doing is somehow inefficient. What is the p
I have a db of about 300,000 records and when I try to find one
random record like this:
select * from table order by rand() limit 1;
it can take several minutes. My Sherlock Holmes instincts tell me
that what I'm doing is somehow inefficient. What is the primary
culprit here?
--
MySQL Gene
On Friday 13 May 2005 14:54, [EMAIL PROTECTED] wrote:
> To confirm that you would like
>
> [EMAIL PROTECTED]
>
> added to the mysql mailing list, please click on
> the following link:
>
> http://lists.mysql.com/s/mysql/4284b19ec06544bb/santiagocapel=yahoo.es
>
> This confirmation serves two pur
Hi,
i have table which would contain data describing holiday houses. It's it:
idbigint(20) unsigned PRIauto_increment
nametinytext
descriptiontext
webpagetinytext
emailtinytext
whole_cantinyint(1) unsigned
whole_onlytinyint(1) unsigned
typeenu
"Scott Purcell" <[EMAIL PROTECTED]> wrote on 05/13/2005 12:05:05 PM:
> Hello,
> I am accustomed to Oracle query syntax, and I am having trouble with
> this following query which uses the IN. I am running mysql ( Ver 12.
> 21 Distrib 4.0.15, for Win95/Win98 (i32) ) which does not support the
IN.
>
SELECT date1, process, wip, worm FROM table WHERE field=value ORDER BY
otherField DESC LIMIT N
Seena Blace wrote:
Hi,
how to get top N records from table ?
columns of table
id
date1
process
wip
worm
I need output
date1 process wip worm
5/5/05
Sorry, mysql doesn't support sub queries until version 4.1
-Eric
Scott Purcell wrote:
Hello,
I am accustomed to Oracle query syntax, and I am having trouble with this
following query which uses the IN. I am running mysql ( Ver 12.21 Distrib
4.0.15, for Win95/Win98 (i32) ) which does not support t
Hello,
I am accustomed to Oracle query syntax, and I am having trouble with this
following query which uses the IN. I am running mysql ( Ver 12.21 Distrib
4.0.15, for Win95/Win98 (i32) ) which does not support the IN.
How do I rewrite the below query to function?
Basically what I have is three
Hi,
how to get top N records from table ?
columns of table
id
date1
process
wip
worm
I need output
date1 process wip worm
5/5/05
5/6/05
5/7/05
thanks
-
Do you Yahoo!?
Yahoo! Mail - Find
Alvaro Cobo wrote:
Have you checked if in the /etc/mysql/my.cnf the directive "allow
networking" is uncommented?.
This is a quite usual mistake.
Also check the host permissions of the root user.
Hope this helps.
Alvaro.
- Original Message -
From: "Mark Sargent" <[EMAIL PROTECTED]>
To:
Sen
On Friday 13 May 2005 16:19, Eric Bergen typed:
> I agree. It sounds like you could use plain repeatable read isolation
> transactions. If someone else is modifying those rows you get an older
> version from when your transaction was started. No need for skipping
> anything.
In the case of what I
I was a huge fan of 3ware's IDE offerings, but was also disappointed by
their SATA cards. However, I found that the Adaptec 2410SA is a beautiful
card with excellent performance, and it has a small enough profile to fit in
most 1U cases.
- Original Message -
From: "Daniel Whitener" <[
I agree. It sounds like you could use plain repeatable read isolation
transactions. If someone else is modifying those rows you get an older
version from when your transaction was started. No need for skipping
anything.
Martijn Tonies wrote:
I am using InnoDB only.
But, it's not skipping locke
Is there a reason you can't run mysqldump on the server? You could then
gzip it and use any transport method with throttling you want (like wget)
-Eric
Aaron Wohl wrote:
http://www.birdsoft.demon.co.uk/proglib/slowpipe.htm would seem to do
what you want... I havent tried it yet, but noted the URL
I've had this debate with myself a hundred times over the past 5 years
since SATA started becoming more popular. I've come to a few simple
conclusions...
I've also been dissapointed with the performance of some of the SATA
raid controllers (*cough* 3ware *cough*). I've got old dual p3
servers wi
Ok, I've been trying to install that function this morning and no luck
I downloaded 5.0.4beta , compiled it .
everything working fine.
Trying the udf_example function (make udf_example.so) no problem.
Trying to gcc -shared -o item_xmlfunc.so item_xmlfunc.cc
it has been complaining about missing
Tom wrote:
Thank you, Partha.
What I really meant was that the process of creating index was stopped and I
couldn't figure out and search out the log meaning 'Warning: Enabling keys got
errno 116, retrying'. So I am not sure I will run into such problem next time.
perror 116
Error code 116:
http://www.birdsoft.demon.co.uk/proglib/slowpipe.htm would seem to do
what you want... I havent tried it yet, but noted the URL for the next
time I needed that functionality.
- Original message -
From: "Amit M Bhosle" <[EMAIL PROTECTED]>
To: mysql@lists.mysql.com
Date: Fri, 13 May 2005 09
Am Freitag, 13. Mai 2005 10.32 schrieb Marcus Bointon:
> I have a table that represents a tree structure via a self-join. I'd
> like to get hold of all parent records in a single query - is such a
> thing possible? e.g. given
>
> idparentid
> 10
> 21
> 32
> 42
> 51
> 64
On 13 May 2005, at 10:02, [EMAIL PROTECTED] wrote:
if you use php, you can look at
http://www.sitepoint.com/article/hierarchical-data-database
That's just what i needed, great article. Thanks,
Marcus
--
Marcus Bointon
Synchromedia Limited: Putting you in the picture
[EMAIL PROTECTED] | http://www.s
> > I am using InnoDB only.
> > But, it's not skipping locked rows.
>
> Ditto that here.
Actually, I consider that a good thing... What's the point in leaving
out rows that have not been modified yet but are about to be updated?
The transaction that has the rows locked might as well be rolled back
On Friday 13 May 2005 11:34, Ramesh G typed:
> I am using InnoDB only.
> But, it's not skipping locked rows.
Ditto that here.
CREATE TABLE `a` (
`b` int(11) NOT NULL auto_increment,
PRIMARY KEY (`b`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
select * from a;
+---+
| b |
+---+
| 1 |
| 2 |
| 3 |
I am using InnoDB only.
But, it's not skipping locked rows.
regards
Ramesh
On Fri, 13 May 2005 12:11:12 +0200, Martijn Tonies <[EMAIL PROTECTED]>
wrote:
Yes. Martijn is correct.
I am trying to skip locked rows and get the next unlocked
row available. Reading uncommited data will cause unexpect
Hello.
> Is there something else I should be doing to create new users post
> 4.1?
> Is this behavior something I should be worried about? (I am,
> currently.)
Switch to the latest release (4.1.11). See also:
http://dev.mysql.com/doc/mysql/en/user-names.html
Adam Fields
Hello.
See:
http://lists.mysql.com/mysql/180308
Ashok Kumar <[EMAIL PROTECTED]> wrote:
> [-- text/plain, encoding 7bit, charset: us-ascii, 11 lines --]
>
> Hello Friends,
> I wrote one simple pgm to connect and disconnect the database in
> TC(Windows). when compiling the program,
> Yes. Martijn is correct.
> I am trying to skip locked rows and get the next unlocked
> row available. Reading uncommited data will cause unexpected
> problems. I don't want to do that.
> Is there a way to do this?
Use InnoDB and you don't _have_ to skip past locked records :-)
With regards,
Yes. Martijn is correct.
I am trying to skip locked rows and get the next unlocked
row available. Reading uncommited data will cause unexpected
problems. I don't want to do that.
Is there a way to do this?
Regards
Ramesh
On Fri, 13 May 2005 11:54:11 +0200, Martijn Tonies <[EMAIL PROTECTED]>
wrot
> Yes, that's what i said. He is trying to ovverride data consistency, and
read
> uncommitted is so possible. So why not use it if it solves the problem.
> else, read uncommitted sould be droped from mysql.
I don't think he is trying to override data consistency... with MS SQL,
"read past" wil
Yes, that's what i said. He is trying to ovverride data consistency, and read
uncommitted is so possible. So why not use it if it solves the problem.
else, read uncommitted sould be droped from mysql.
But i agree with you
Mathias
Selon Martijn Tonies <[EMAIL PROTECTED]>:
>
>
> > look also using
> look also using READ UNCOMMITTED
>
> http://dev.mysql.com/doc/mysql/en/innodb-transaction-isolation.html
Read UNCOMMITTED is an abomination and should be avoided.
With regards,
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
Ramesh,
> Thanks a lot for your comments. In MS SQL we have something which can
> achieve this very simply:
>
> select Top 1 * from Table1 with (updlock,readpast)
>
> I am looking for something exactly similar to this in MySQL.
This actually is a work-around for that bloody MS SQL locking crap.
In article <[EMAIL PROTECTED]>,
Mauricio Pellegrini <[EMAIL PROTECTED]> writes:
> This is the table I have
> Column Id is primary key and auto_numeric
> -
> Idorder itemvalue col_type
> -
> 1 3
Hi Mathias,
Thanks a lot for your comments. In MS SQL we have something which can
achieve this very simply:
select Top 1 * from Table1 with (updlock,readpast)
I am looking for something exactly similar to this in MySQL. Creating temp
tables will not work for me as the no of users for the s
Hi,
in oracle we have connect by prior for hierachical data traversal.
in mysql, you can use group_concat like this :
mysql> select parentid, group_concat(id) from ids
-> group by parentid;
+--+--+
| parentid | group_concat(id) |
+--+--+
|
Thank you, Partha.
What I really meant was that the process of creating index was stopped and I
couldn't figure out and search out the log meaning 'Warning: Enabling keys got
errno 116, retrying'. So I am not sure I will run into such problem next time.
- Original Message -
From: "Pa
I have a table that represents a tree structure via a self-join. I'd
like to get hold of all parent records in a single query - is such a
thing possible? e.g. given
idparentid
10
21
32
42
51
64
If I was starting with record 4, I would want it to return records 2
a
Hi,
update tbl_products set p10_price=mid(p10_price,2) where p10_price regexp
('[^0-9.]');
Which worked because the mucky characters were always the first two digits but
it's still cludgy.
What I really wanted to do was just "filter out the good any currency numerics of form \d+.\d\d
10.95 but a
On Fri, 13 May 2005 08:29:46 +0200, wrote:
>Hi,
>if the first characters are numerics, no need to use regexp, since mysql does
>implicit conversion if you do calculations :
>
>mysql> select '10.95 tiitti' from dual;
>+--+
>| 10.95 tiitti |
>+--+
>| 10.95 tiitti |
>+---
66 matches
Mail list logo
