mysql,您好!
i use myodbc to connect to a big table, to my surprise, myodbc araise full
table scan and crash. could anybody help me with that?
致
礼!
chenwei
[EMAIL PROTECTED]
2005-08-08
Hello All,
I am having some trouble getting a good compile of mysql on a Itanium2
based system using the Intel 9.0 compilers.
I can get it to compile ok. But when I run make test it will eventually
fail with an error about being unable to contact the server. This happens
pretty far in, when it
Hi all,
I'm hosting my web on a provider with MySQL 4.0.25-standard.
I've got this situation when I open my database using phpMyadmin, one of my
table has status is in use.
And then when I try to repair the database, MySQL just hung there while
consumed around 50% of CPU. And then when I tried
Hi there,
I'm a bit puzzled about the DELIMITER statement.
Is this a command-line SQL statement only, or is this actually processed
on the server?
And if it's a command-line thingy only, shouldn't I be able to execute
something
like:
CREATE PROCEDURE P_AA()
MODIFIES SQL DATA
begin
delete from
Hello.
http://dev.mysql.com/doc/mysql/en/alter-table.html document, but I
don't see any examples of altering table types, just a lot of other
The syntax for many of the allowable alterations is similar
to clauses of the CREATE TABLE statement. This includes
table_options
Hello.
What about this:
UPDATE news
SET comments =
(
SELECT COUNT(id)
FROM comments
WHERE newsid = news.id
GROUP BY newsid
);
Sebastian [EMAIL PROTECTED] wrote:
I have two tables: news and comments.
i want to count the number of comments for
Hello.
I can't make guessing about Hebrew code page, but MySQL support of
character sets was very helpful with my Russian cp1251 encoding.
Because windows console supports input on my system only in cp866,
while other applications - cp1251. So in mysql command line client
I was able to
Hello.
Please, provide more information about your software and oprating
system. Include versions of MySQL and MyODBC. See:
http://dev.mysql.com/doc/mysql/en/bug-reports.html
http://dev.mysql.com/doc/mysql/en/myodbc-bug-report.html
chenwei [EMAIL PROTECTED] wrote:
i use
Hello.
I think that mysqld zombies appear due to death of some MySQL threads,
but we don't see any sensible records about it in the error log. I suggest
you to switch to official binaries of the latest release from:
http://dev.mysql.com/downloads
and check if the weird behavior
Hello.
Have a look here:
http://dev.mysql.com/doc/mysql/en/mysqldump.html
JM [EMAIL PROTECTED] wrote:
Hi,
Im still new to mysql and Im the processes of reading the manual.
Since I
need a quick answer I need inputs on things to do to maintain the DB. Is
Hello.
Use SHOW PROCESSLIST to see what's going on in your database.
Fajar Priyanto [EMAIL PROTECTED] wrote:
Hi all,
I'm hosting my web on a provider with MySQL 4.0.25-standard.
I've got this situation when I open my database using phpMyadmin, one of my
table has status is in
Knowing not too much from perl, I would like to remember the last
paragraph of Jeremiah:
Keep in mind that interpolation is work, so using one of the
single quotes
strings which does not search your string for variables to
replace is going
to be higher performance than the double quoted
Hi,
There is a request from mgmt, when user browse the request (web), the
database will return the requested timestamp at their timezone that
previously posted. How do i do that? Do I need store whole country codes
together timezones in database mysql ? Is there any way to find full
country
Hello.
Comments from:
http://bugs.mysql.com/bug.php?id=12344
might be helpful.
Martijn Tonies [EMAIL PROTECTED] wrote:
Hi there,
I'm a bit puzzled about the DELIMITER statement.
Is this a command-line SQL statement only, or is this actually processed
on the
Hello,
Can help me someone with the installation.
I tried to install the MySQL-server-4.1.13-0.i386.rpm on Suse Linux 9.3.
logged in as root in Linux with
rpm -i MySQL-server-4.1.13-0.i386.rpm
I got messages
chown: 'mysql:mysql': invalid user
chown: 'mysql': invalid user
[Warning] Asked for
Hello Gleb,
Hello.
Comments from:
http://bugs.mysql.com/bug.php?id=12344
might be helpful.
Thanks. So it seems that it's only a command line statement.
Any idea why I get the error when executing the full CREATE
from a Delphi VCL component? Weird thing is, the procedure
is saved to the
Comments from:
http://bugs.mysql.com/bug.php?id=12344
might be helpful.
Thanks. So it seems that it's only a command line statement.
Any idea why I get the error when executing the full CREATE
from a Delphi VCL component? Weird thing is, the procedure
is saved to the database.
Trevor Tregoweth wrote:
Hi There
I am trying to run a simple password /php / mysql script for a web page
and get the following errors, it works fine on a earlier versions of php
/ mysql
PHP Notice: Undefined variable: help_out_uid in
/var/www/html/lcc/secure/secure.php on line 87,
PHP
Where can I put in my suggestion (I'm sure others suggested the same) for
MySQL Query Browser?
Scott
--
Please avoid sending me Word or PowerPoint attachments.
See http://www.gnu.org/philosophy/no-word-attachments.html
--- Gleb Paharenko [EMAIL PROTECTED] wrote:
Hello.
What about this:
UPDATE news
SET comments =
(
SELECT COUNT(id)
FROM comments
WHERE newsid = news.id
GROUP BY newsid
);
Isn't the previous query going to update the
news.comments with the last
On Mon, 1 Aug 2005, Joerg Bruehe wrote:
As a result, the allocation succeeds, but some process gets killed when
the paging space cannot take such an additional page. To the affected
process, this looks like a crash.
Linux 2.4 and 2.6 kernels have a setting for their overcommitment
behaviour
Hi,
I am currently a student learning SQL. I have MySQL 5.0 installed at home
and on my Laptop. How can I take a database that I have updated on my laptop
and transfer it to my home PC so that they are both synchronized ?
I tried looking on the forums for this info, but forums locks-up my
I used mysqldump with the -t option to only dump the raw data. I'm in the
process of importing the dump to a new database with seed data loaded. I'm
attempting to override the existing dataset but continue to get the
following message when the import encounters a duplicate entry: Duplicate
entry
Hello.
Probably you want to make a feature request at:
http://bugs.mysql.com
Where can I put in my suggestion (I'm sure others suggested the same)
for
MySQL Query Browser?
Scott Hamm [EMAIL PROTECTED] wrote:
--
For technical support contracts, goto
Hello.
For a pity I'm not familiar with Deplhi.
Thanks. So it seems that it's only a command line statement.
Any idea why I get the error when executing the full CREATE
from a Delphi VCL component? Weird thing is, the procedure
is saved to the database.
With regards,
Hello.
No, it isn't. Here is the test case:
create table comments(id int auto_increment,newsid int,primary key(id));
create table news(id int,comments int);
insert into news(id) values('1'),(2),(3),(4),(5);
insert into comments(newsid) values(1),(1),(2),(4),(4),(4);
update news set
I think this should work:
Update int_contxtd_details a, int.contxtd_details b
Set a.params = b.params
Where B.id=25
And a.id!=25
This will work in a php script where we cannot use more than one sql at the
same time or also will work y a front end manager
-Original Message-
From: Nuno
Funny you should bring up this subject, as it was recently rehashed
(more like re-re-re-re-hashed!) on perlmonks.org in this discussion
thread:
http://perlmonks.org/?node_id=481652
The conclusion of the discussion(s) is that there are valid reasons to
use single and double quotes in various
Gleb Paharenko wrote:
Hello.
What about this:
UPDATE news
SET comments =
(
SELECT COUNT(id)
FROM comments
WHERE newsid = news.id
GROUP BY newsid
);
Hi. i came up with a similar query last night, but i didnt use group by.
I have question, it it better to use
Sebastian [EMAIL PROTECTED] wrote on 08/08/2005 10:53:55 AM:
Gleb Paharenko wrote:
Hello.
What about this:
UPDATE news
SET comments =
(
SELECT COUNT(id)
FROM comments
WHERE newsid = news.id
GROUP BY newsid
);
Hi. i came up with a similar
Scott Hamm [EMAIL PROTECTED] wrote on 08/08/2005 08:11:18 AM:
Where can I put in my suggestion (I'm sure others suggested the same)
for
MySQL Query Browser?
Scott
ROFLMAO -- you really DON'T check the website before asking the group do
you (or read the manual, or check the archives,
On 8/8/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Scott Hamm [EMAIL PROTECTED] wrote on 08/08/2005 08:11:18 AM:
Where can I put in my suggestion (I'm sure others suggested the same)
for
MySQL Query Browser?
Scott
ROFLMAO -- you really DON'T check the website before
Hi Eric,
you can setup replication on your laptop (master) and your PC (slave).
http://dev.mysql.com/doc/mysql/en/replication.html
Best regards,
Mikhail.
- Original Message -
From: Eric Dahlenburg [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Monday, August 08, 2005 4:12 PM
Scott Hamm [EMAIL PROTECTED] wrote on 08/08/2005 11:24:22 AM:
On 8/8/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Scott Hamm [EMAIL PROTECTED] wrote on 08/08/2005 08:11:18 AM:
Where can I put in my suggestion (I'm sure others suggested the same)
for
MySQL Query Browser?
Shawn,
Apology accepted. :) No hard feeling.
Scott
On 8/8/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Scott Hamm [EMAIL PROTECTED] wrote on 08/08/2005 11:24:22 AM:
On 8/8/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Scott Hamm [EMAIL PROTECTED] wrote on 08/08/2005
[EMAIL PROTECTED] wrote:
Sebastian [EMAIL PROTECTED] wrote on 08/08/2005 10:53:55 AM:
Gleb Paharenko wrote:
Hello.
What about this:
UPDATE news
SET comments =
(
SELECT COUNT(id)
FROM comments
WHERE newsid = news.id
GROUP BY newsid
);
Hi. i came up with a similar
[EMAIL PROTECTED] wrote:
Sebastian [EMAIL PROTECTED] wrote on 08/08/2005 10:53:55 AM:
Gleb Paharenko wrote:
Hello.
What about this:
UPDATE news
SET comments =
(
SELECT COUNT(id)
FROM comments
WHERE newsid = news.id
GROUP BY newsid
);
Hi. i came up with a similar
Hi all!
Gleb Paharenko wrote:
Hello.
I have a query that is taking days to complete (not good). If I change
Really, not good. What does SHOW PROCESSLIST report about the thread of
this query?
The query has been running for ~5 days now:
Id: 27977
User: root
Host:
David Sparks [EMAIL PROTECTED] wrote on 08/08/2005 12:20:41 PM:
Hi all!
Gleb Paharenko wrote:
Hello.
I have a query that is taking days to complete (not good). If I
change
Really, not good. What does SHOW PROCESSLIST report about the thread
of
this query?
The
Nuno Pereira wrote:
[EMAIL PROTECTED] wrote:
Sebastian [EMAIL PROTECTED] wrote on 08/08/2005
10:53:55 AM:
Gleb Paharenko wrote:
Hello.
What about this:
UPDATE news
SET comments =
(
SELECT COUNT(id)
FROM comments
WHERE newsid = news.id
GROUP BY newsid
);
Hi. i came up
SET CHARACTER SET ut8; won't work.
My server admin said UTF8 has not been mentioned in 4.0 thus I am
unable to use it.
So is there any solution on how I can properly use foreign characters
and store them in a MySQL 4.0 database?
--
MySQL General Mailing List
For list archives:
Sebastian [EMAIL PROTECTED] wrote on 08/08/2005 01:19:32 PM:
Nuno Pereira wrote:
[EMAIL PROTECTED] wrote:
Sebastian [EMAIL PROTECTED] wrote on 08/08/2005
10:53:55 AM:
Gleb Paharenko wrote:
Hello.
What about this:
UPDATE news
SET comments =
(
On an InnoDB table for 70k records the update action is taking so much
time.(More than 30minutes). We got the innodb_buffer_pool_size as 4gigs. IS
there anything more to add up to get the processes kick its speed.
- javabuddy.
Sebastian wrote:
Nuno Pereira wrote:
[EMAIL PROTECTED] wrote:
Sebastian [EMAIL PROTECTED] wrote on 08/08/2005
10:53:55 AM:
Gleb Paharenko wrote:
Hello.
What about this:
UPDATE news
SET comments =
(
SELECT COUNT(id)
FROM comments
WHERE newsid = news.id
GROUP BY newsid
);
Nuno Pereira [EMAIL PROTECTED] wrote on 08/08/2005 01:49:44 PM:
Sebastian wrote:
Nuno Pereira wrote:
[EMAIL PROTECTED] wrote:
Sebastian [EMAIL PROTECTED] wrote on 08/08/2005
10:53:55 AM:
Gleb Paharenko wrote:
Hello.
What about this:
UPDATE news
SET
I installed Mysql on windows and found out that the documentation does not
talk about installing the database in another directory or partition of the
disk.
Is it possible in Windows?
I have little space left on the partition where progrxxxFiles/mysql/ is.
THanks
Laurie
--
MySQL General
Yes, using symbolic links.
http://dev.mysql.com/doc/mysql/en/windows-symbolic-links.html
On 8/8/05, l'[EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
I installed Mysql on windows and found out that the documentation does not
talk about installing the database in another directory or partition of the
Hi Laurie
You can put the DB data on any disk or directory as long as it's
location is in the .ini file
#Path to the database root
datadir=C:/MySQL/Data/
HTH
Steve
l'[EMAIL PROTECTED] wrote:
I installed Mysql on windows and found out that the documentation does
not talk about
Hi,
IS the following query counting cumulative (see below **) pHITS or is
it counting individual counts for each user for a particular day. Im
not skilled enough to answer this question myself. My instinct says
that its counting cumulative values and NOT individual counts for
each
Sebastian wrote:
Gleb Paharenko wrote:
Hello.
What about this:
UPDATE news
SET comments =
( SELECT COUNT(id)
FROM comments
WHERE newsid = news.id
GROUP BY newsid
);
Hi. i came up with a similar query last night, but i didnt use group by.
I have question, is it better to use
m i l e s [EMAIL PROTECTED] wrote on 08/08/2005 03:10:21 PM:
Hi,
IS the following query counting cumulative (see below **) pHITS or is
it counting individual counts for each user for a particular day. Im
not skilled enough to answer this question myself. My instinct says
that its
Miles,
IS the following query counting cumulative (see below **) pHITS or is
it counting individual counts for each user for a particular day. Im
not skilled enough to answer this question myself. My instinct says
that its counting cumulative values and NOT individual counts for each
Michael Stassen wrote:
Not exactly. They aren't the same. COUNT(id) counts distinct values of
id, while COUNT(*) simply counts rows. [snip]
Actually, COUNT(id) counts non-NULL values of id. COUNT(DISTINCT id)
would count distinct values.
I am having inconsistent behavior maintaining a remote connection with MySql
Administrator/Browser. Brand new installations of clients on Windows XP and
MySql server on Windows 2003 server. It worked fine at first then suddenly I
could no longer connect (Error #1045. Access denied for user
Shawn,
Took me a bit to digest what you were sayin but if I get it the way
you splain'd it
then the following should work:
++
SELECT
cmc_search_members.PropertyName AS pNAME,
cmc_search_members.PropertyEmail AS pEMAIL,
Kent Roberts [EMAIL PROTECTED] wrote on 08/08/2005 04:50:15 PM:
I am having inconsistent behavior maintaining a remote connection
with MySql Administrator/Browser. Brand new installations of clients
on Windows XP and MySql server on Windows 2003 server. It worked
fine at first then suddenly
Jasper Bryant-Greene wrote:
Michael Stassen wrote:
Not exactly. They aren't the same. COUNT(id) counts distinct values
of id, while COUNT(*) simply counts rows. [snip]
Actually, COUNT(id) counts non-NULL values of id. COUNT(DISTINCT id)
would count distinct values.
m i l e s [EMAIL PROTECTED] wrote on 08/08/2005 05:05:46 PM:
Shawn,
Took me a bit to digest what you were sayin but if I get it the way
you splain'd it
then the following should work:
++
SELECT
cmc_search_members.PropertyName
Thanks Shawn. It seems to be just that.
[EMAIL PROTECTED] 08/08/05 03:02PM
Kent Roberts [EMAIL PROTECTED] wrote on 08/08/2005 04:50:15
PM:
I am having inconsistent behavior maintaining a remote connection
with MySql Administrator/Browser. Brand new installations of clients
on Windows XP
Some countries have multiple timezones, so it is not sufficient to
know the country code in order to get the timezone. If they have
previously posted the timezone, however, then it should be possible to
store that information in a cookie on the client machine that your web
layer can retrieve. If
Hi all.
I've been testing out mysql-5.0.10 on my Powerbook ( Gentoo Linux PPC ),
and I've hit an incredibly unfortunate bug. It is demonstrated
adequately with the following:
mysql use entropy;
Database changed
mysql show tables;
ERROR 1052 (23000): Column
Does anyone know if there Is there a limit on the number/length of terms using
match against(terms)?
Thanks!
-- Avi
Hi guys,
I'm new in database development, and has been wondering if anyone can
suggest a good reporting tool that will help me generate graphical
report for my database queries using visual c++? Can I use excell to
format my queries into graph?
My project involves the developement of syslog
First I have to Thank you for creating such a wonderful backend.
Problem Statment : My Operating System is Windows 98. I have set password for
my MySql database. Its working fine.
Following are the databases that i am using in My Data Folder
Employee
Sales
Marketing
--- Elizabeth Bonifacio [EMAIL PROTECTED] wrote:
Hi guys,
I'm new in database development, and has been
wondering if anyone can
suggest a good reporting tool that will help me
generate graphical
report for my database queries using visual c++? Can
I use excell to
format my queries into
Hi,
I'm trying to compile an apache module that uses
mysql, but I keep getting this weird error message:
ld: common symbols not allowed with MH_DYLIB output
format with the -multi_module option
/usr/local/mysql/lib/libmysqlclient.a(charset.o)
definition of common _all_charsets (size 1024)
Elizabeth Bonifacio wrote:
Hi guys,
I'm new in database development, and has been wondering if anyone can
suggest a good reporting tool that will help me generate graphical
report for my database queries using visual c++? Can I use excell to
format my queries into graph?
My project involves
67 matches
Mail list logo