Joseph Cochran wrote:
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
l
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 the
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)
/usr/lo
--- 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 quer
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
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 server
Does anyone know if there Is there a limit on the number/length of terms using
"match against()"?
Thanks!
-- Avi
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 'TABL
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 yo
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
> o
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.Pro
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.
http://dev.mysql.com
"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 s
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,
cmc_
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 '[EMA
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.
http://dev.mysql.com/doc/mysql/en/group-by-functi
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
pr
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
> tha
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 COUNT(*
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 prop
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 installi
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
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 Ma
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.
> >
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
);
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 <[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
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: http://lists
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
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
> >
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
Ho
[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 q
[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 q
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]> wro
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 Brows
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:
Sent: Monday, August 08, 2005 4:12 PM
Subject: Exporting a dat
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 che
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 archi
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 news
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 COUNT
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 circu
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 Pe
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 comm
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 r
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 https://order.mysql
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
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 Interne
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
behavio
--- 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 wit
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
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 Noti
> > 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 d
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
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 196
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 t
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 co
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 quote
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
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.
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 stil
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
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 dynam
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 f
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 modificatio
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
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 trie
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 i
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
68 matches
Mail list logo
