Hi Don,
Have a look at Jasper Reports: http://jasperforge.org/
-NT
Em 30-04-2012 17:53, Don Wieland escreveu:
Hello,
I have a client who needs the ability to do statistical reporting on
their mySQL db data. Is there an app that provides an easy UI that will
allow my client to build a line ite
On 30.04.2012 18:53, Don Wieland wrote:
Hello,
I have a client who needs the ability to do statistical reporting on
their mySQL db data. Is there an app that provides an easy UI that will
allow my client to build a line item query, specify fields to be include
in the result of the query, and the
Hello,
I have a client who needs the ability to do statistical reporting on
their mySQL db data. Is there an app that provides an easy UI that
will allow my client to build a line item query, specify fields to be
include in the result of the query, and then design the way the data
will be
How many rows in each table?
If only one row, why is the schema designed that way?
If multiple rows, why are you changing _all_ rows that way?
I am questioning the schema design that would lead to your question.
Follow on to Ananda's answer: See
information_schema.TABLES WHERE TABLE_SCHEMA =
Did the upgrade actually change the Engine on _existing_ tables?
I thought the setting in my.cnf only applied to _new_ tables that do _not_ have
an engine explicitly specified.
True, it is not totally safe to blindly change Engines; there can be
performance 'surprises'. This document outlines m
Ok, there is another approach if you are using shell script.
Step 1: You may invoke one mysql user who has not password to access the mysql
database.
Step 2: Shell script:
c=0
for i in `mysql -u username -e "use database;show tables;"`
do
if [ $c -ge 1 ]
then
mysql -u username -
Do you just want to replace current value in client column to "NEW".
You can write a stored proc , with a cursor and loop through the cursor,
update each table.
regards
anandkl
On Mon, Apr 30, 2012 at 2:47 PM, Pothanaboyina Trimurthy <
skd.trimur...@gmail.com> wrote:
> Hi all,
> i have one
Hi all,
i have one database with 120 tables and each table contains one
common column that is "client" now i want to update all the tables
column client = "NEW". is it possible to write a single query to
update this one.
please help me.
thanks in advance
Thanks & Kind Regards,
Trimurthy.p