Hi Martin,
Sorry, I am not able to understand this. Can you explain in detail
please?
-Karthik
From: Martin Gainty [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 15, 2008 6:56 PM
To: Krishna Chandra Prajapati; Karthik Pattabhiraman
Cc: mysql@lists.mysql.com
Subject: RE: Trouble
Hi Simon,
There are many products running on different mysql production server. In
order to generate daily, weekly, monthly, half-yearly reports. I need all
the data on one mysql server called report server. But, I haven't make it
possible. As slave can have only one master.
I believe that
hi list,
i need some options from outfile (exspecialy:FIELDS TERMINATED BY) and would
like
to send the output to stdout to further processing.
unfortunately i found no proper way to force the output to stdout. for now i use
the redirection of the mysql -NB output but the interface lacks the
I have two tables, one is a list of users and the other is a list of
events for each user. It is a one to many relationship. The event
table is pretty simple just an event type and a the date and time of the
event in a datetime field.
I need a query that shows all events of a certain type
No, not unique to PostgreSQL. Microsoft SQL Server has the OUTPUT
Clause. The major difference is MS has an extra feature that allows the
OUTPUT or some form of the output to be reused in yet another INSERT.
This would allow you to DELETE a block rows from table and insert them
into a work table
Chris W wrote:
I have two tables, one is a list of users and the other is a list of
events for each user. It is a one to many relationship. The event
table is pretty simple just an event type and a the date and time of the
event in a datetime field.
I need a query that shows all events of a
I have no idea what I was thinking. For some reason I was thinking
Distinct wouldn't work, must have been temporarily brain dead. Thanks
for the wake up call.
Gerald L. Clark wrote:
Chris W wrote:
I have two tables, one is a list of users and the other is a list of
events for each user.
Try mysqldump !!!
On this web page, http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html
It says the following:
--fields-terminated-by=..., --fields-enclosed-by=...,
--fields-optionally-enclosed-by=..., --fields-escaped-by=...
These options are used with the -T option and have the same
Hello,
Running Environment:
MySQL Server version: 5.0.45
OS is Red-Hat 64-bit
A test using mysql -e LOAD table ... was ran to see
if LOAD' will give an error when loading a record with
the same primary-key of an existing record in the table.
LOAD acted as an UPDATE statement and it didn't
Hi all,
I am running into some issues with what I am trying to do in a stored proc.
Basically I am trying to find records related to certain individuals in
other tables in the databases and if there are any, tell me how many.
Instead of doing this for each of these tables individually I use a
The tablename in the cursor cannot be dynamic...
I am just seeing that it should say:
DECLARE adi CURSOR FOR select count(*) from tablename a join individual i on
a.ident=i.ident where fid=agpfid;
In the full proc below where tablename is a variable...
Olaf
On 10/16/08 4:07 PM, Martin
On Thu, Oct 16, 2008 at 12:31 PM, Olaf Stein
[EMAIL PROTECTED] wrote:
Hi all,
I am running into some issues with what I am trying to do in a stored proc.
Basically I am trying to find records related to certain individuals in
other tables in the databases and if there are any, tell me how
I found a post suggesting to use the cursor to select from a temporary table
that is created dynamically each time
This seems to work...
DECLARE adi CURSOR FOR select count(*) from t;
SET @stmt_text=CONCAT(drop temporary table if exists t);
PREPARE stmt FROM @stmt_text;
On Thu, Oct 16, 2008 at 3:40 PM, Reyna.Sabina [EMAIL PROTECTED] wrote:
A test using mysql -e LOAD table ... was ran to see
if LOAD' will give an error when loading a record with
the same primary-key of an existing record in the table.
Do you mean LOAD DATA INFILE? It will give an error
Thanks,
The INTO clause I had totally disregarded...
And I could do this outside the database I just have the cmd line client
connected at all times anyway and like to quickly look up certain things...
On 10/16/08 4:14 PM, Rob Wultsch [EMAIL PROTECTED] wrote:
On Thu, Oct 16, 2008 at 12:31
The only one that comes to mind is that I do not see the tmp table at any
time, which is nice...
The view would show up in a show tables
On 10/16/08 4:45 PM, Martin Gainty [EMAIL PROTECTED] wrote:
any reason for going with Temp Tables over materialized View which can be
periodically
on this machine there are libs from solaris package...
bash-3.00# pkginfo | grep mysql
system SUNWmysqlr mysql - MySQL Database
Management System (root component)
system SUNWmysqlt mysql - MySQL Database
Management System (test component)
Kindly check with the below commands, u will get the details of the package.
pkginfo SUNWmysqlu
system SUNWmysqlu mysql - MySQL Database Management System (usr
component)
[EMAIL PROTECTED] # pkginfo -l SUNWmysqlu
PKGINST: SUNWmysqlu
NAME: mysql - MySQL Database Management System
18 matches
Mail list logo