Thanks Jay, I got the solution.
Thanks for all the members responding.
With warm regards,
VR Venugopal Rao
-Original Message-
From: Jay Blanchard [mailto:jblanch...@pocket.com]
Sent: 28 April 2010 16:58
To: VR Venugopal Rao; MySQL
Subject: RE: Pivot Query in
[snip]
Date, ProjectCode B
I have verified that 5.1.45 does NOT have this problem.
Here is another question: how are the windows MySQL builds produced?
It is not from the instructions provided on mysql.com, otherwise these
problems would be caught.
Thanks
-Zardosht
On Wed, Apr 28, 2010 at 5:59 PM, Zardosht Kasheff wrote:
inlining responses
On Wed, Apr 28, 2010 at 4:58 PM, Michael Dykman wrote:
> I'm not a windows guy and haven't done C in a Microsoft environment
> since XP was just released, so don't take my suggestions as
> authoritative but:
>
> Are you running the batch file from within Visual Studio or are yo
I'm not a windows guy and haven't done C in a Microsoft environment
since XP was just released, so don't take my suggestions as
authoritative but:
Are you running the batch file from within Visual Studio or are you
running the batch file at the command line?
Which version of the MS compiler are y
I was told I should ask this on this list.
Any ideas?
Thanks
-Zardosht
-- Forwarded message --
From: Zardosht Kasheff
Date: Fri, Apr 23, 2010 at 9:01 PM
Subject: compiling errors on mysql 5.1.46 on win64
To: wi...@lists.mysql.com
Hello all,
I know this is a win32 list, but I
Say tables a and b each have their own id column (primary key) and sundry
other columns. Table j has columns aid and bid to join a and b many-to-many.
Now, I want to select the joined a/b rows where the b rows are joined to (a
different set of) rows in a that meet condition x (which refers only to
it's worth a try -- the manual for 4.1 has the same text about ORDER BY in
section 14.7.
On 4/28/10 12:30 PM, "David Florella" wrote:
> Hi,
>
> Thanks to you and everyone.
>
> I will test the same request with the ORDER BY clause.
>
> Regards,
>
> David.
>
> -Message d'origine-
>
Sir,
I will drop the authentication part. If stored in the code, the db password is
subject to change when needed. In this case i can not change my part of the
code. So I will go for the config file for the credentials.
Thank you for the solutions/suggestions.
Vikram
__
I downloaded a MySQL backup script today since I have 3 or 4
relatively small databases. The script can be found here:
http://sourceforge.net/projects/automysqlbackup/
Now I was wondering if I can create a local database user
'backup'@'localhost' & grant him a level of permissions needed to
perfo
Hi,
Thanks to you and everyone.
I will test the same request with the ORDER BY clause.
Regards,
David.
-Message d'origine-
De : Mattia Merzi [mailto:mattia.me...@gmail.com]
Envoyé : mercredi 28 avril 2010 17:54
À : mysql@lists.mysql.com
Objet : Re: Replication : request DELETE is
Rip out the DB authentication part, and store those credentials in-code, in
some config file or the registry, or some remote mechanism like LDAP.
If your users need to access multiple servers, just give them an option for
each server, but don't let them enter DB credentials themselves.
Users are
AFAIR you can use LIMIT with replication only if you use row-based
replication (or mixed), that means that you must use mysql 5.1.
Greetings,
Mattia.
2010/4/28 Tom Worster :
> 16.3.1.9. Replication and LIMIT
> Replication of LIMIT clauses in DELETE, UPDATE, and INSERT ... SELECT
> statements is
16.3.1.9. Replication and LIMIT
Replication of LIMIT clauses in DELETE, UPDATE, and INSERT ... SELECT
statements is not guaranteed, since the order of the rows affected is not
defined. Such statements can be replicated correctly only if they also
contain an ORDER BY clause.
http://dev.mysql.com/d
>-Original Message-
>From: David Florella [mailto:dflore...@legos.fr]
>Sent: Wednesday, April 28, 2010 10:51 AM
>To: mysql@lists.mysql.com
>Cc: 'Krishna Chandra Prajapati'
>Subject: RE: Replication : request DELETE is not executed on slave
>
>Hi,
>
>In the MySQL documentation, it is written
Hi,
In the MySQL documentation, it is written that the two versions are
compatible to make a replication.
It seems that if I make a DELETE without the 'LIMIT 7500', the query is
replicated to the slave.
Regards,
David.
-Message d'origine-
De : Krishna Chandra Prajapati [mailto:praj
Anand,
Thank you for this very valuable information. I created .profile at ~/
as you instructed.
I,m sorry I know so little but your answer makes me wonder why you wrote
/sbin:/usr/sbin:/usr/local/mysql/bin:
while the installation notes said only
/usr/local/mysql/bin
There is an extra /sbin:
Hi
You can use on shell, connect at the client mysq -h (host or IP) -p(password)
and run the query:
SELECT a, b, c INTO OUTFILE '/tmp/result.txt'
FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM test_table
more info see the link
http://dev.mysql.com/doc/r
In MS Access I used to generate one pivot query which gets the following
report from the database which contains the following fields:
See "Pivot tables" at http://www.artfulsoftware.com/queries.php .
PB
-
Jay Blanchard wrote:
[snip]
Date, ProjectCode Building, Number of Copies
I want t
> But I'd prefer not to see the extra sorting field.
You don't need to select a field in order to be able to order by it.
So
select chart_of_accounts.accountname as Account,
concat('$',format(coalesce(sum(sales_journal_entries.debit),0),2)) as
Debit,
concat('$',format(coalesce(sum(sales_journ
Hi all,
posted this in the backup list, but that one seems to be pretty dead, so i'll
try my luck again here:
We're currently looking for a way to backup a pretty big mysql table to
a csv file. However, we don't want to allow the user ssh or file access
to the server, so it'd have to happen
[snip]
Date, ProjectCode Building, Number of Copies
I want to get a Connsolidate Report of
Project Code R&D STP
1007304--04---04
(Group by Project Code)(Sumtotal Building wise).
I have tried to execute the following code :
select pcode, building, sum(ncopies) from request gro
Sir,
We dropped the Idea of getting db user name and passwd during the login;
because we have more than 1000 users and we can not give the user name and the
password.
We will set the connection details in the encrypted format in some config file.
So that the user name, and the password will n
On Wed, 2010-04-28 at 15:24 +0530, VR Venugopal Rao wrote:
> I am working on Java-HTML-MS Access Backend database.
>
> Now office is removing all unlicensed softwares and they are removing
> microsoft applications also and hence the necessity to shift from MS Access
> to MySQL has arised.
>
> In
I am working on Java-HTML-MS Access Backend database.
Now office is removing all unlicensed softwares and they are removing
microsoft applications also and hence the necessity to shift from MS Access
to MySQL has arised.
In MS Access I used to generate one pivot query which gets the following
rep
On Wed, 2010-04-28 at 13:58 +0530, Vikram A wrote:
> Hi all,
> I have some security issues. I would like to have your suggestions/solutions.
>
> I have winserver2003 with mysql 5.1.45. We have client serve application that
> allows multi-login system with various people.
>
> I am getting user na
Hi dflorella,
The important thing about mysql replication is same mysql version for both
master as well as slave should be used. It should be taken as good practice.
You need to check that master and slave are in sync. Is there any error
(replication) on the slave server. Check the mode, strict o
Hi,
I am using MySQL replication :
- The version of the master is 4.1.12-log
- The version of the slave is 5.0.41
When I use the query '' DELETE QUICK FROM [TABLE] WHERE [field] < 'xx'
LIMIT 7500", the query is executed on the master but not on the slave.
D
I'm afraid you can't discern between clients and applications on the MySQL
level. Your application authentication should be separate from the MySQL
one.
On Wed, Apr 28, 2010 at 10:28 AM, Vikram A wrote:
> Hi all,
> I have some security issues. I would like to have your
> suggestions/solutions.
Hi all,
I have some security issues. I would like to have your suggestions/solutions.
I have winserver2003 with mysql 5.1.45. We have client serve application that
allows multi-login system with various people.
I am getting user name, password for database login when the try to use login
[
Hi Baron,
I am too new to mysql internal jargon to understand "Handler:info()". Can
you tell me specific variables you want to get the real issue?
*Regarding OS:* It ubuntu disto. of linux.
dhee...@:~$ uname -a
Linux host0125 2.6.24-16-generic #1 SMP Thu Apr 10 12:47:45 UTC 2008 x86_64
GNU/Li
Hi James,
Assuming your OS is linux ,you can add the mysql bin path in the environment
.By adding the entry in .profile of your home directory.
PATH=$PATH:/sbin:/usr/sbin:/usr/local/mysql/bin:
export PATH
Thanks
Anand
On Wed, Apr 28, 2010 at 11:44 AM, wrote:
> In the ReadMe.pdf that came with
31 matches
Mail list logo
