Re: mySQL Query and Report Builder

2012-04-30 Thread Nuno Tavares
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

Re: mySQL Query and Report Builder

2012-04-30 Thread Carsten Pedersen
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

mySQL Query and Report Builder

2012-04-30 Thread Don Wieland
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

Re: a lesson in query writing and (maybe) a bug report

2011-08-28 Thread Jigal van Hemert
Hi, On 28-8-2011 4:08, shawn wilson wrote: On Sat, Aug 27, 2011 at 17:33, Arthur Fuller wrote: I agree 110%. It is completely pointless to index a column with that amount of NULLs. In practical fact I would go further: what is the point of a NULLable column? A NULL 'value' is special in most

Re: a lesson in query writing and (maybe) a bug report

2011-08-27 Thread shawn wilson
In practice this is not realistic, but I try to adhere to this > principle whenever I can. For example, it's possible to add a new Hire while > not yet having determined which department s/he will work in, and hence > which manager s/he will report to, but typically I deal with such

Re: a lesson in query writing and (maybe) a bug report

2011-08-27 Thread Michael Dykman
It is a general rule that indexes for columns with low cardinality are not worth it, often making queries more expensive than they would be without said index. binary columns all suffer from this. - michael dykman On Sat, Aug 27, 2011 at 4:52 PM, Dave Dyer wrote: > > The "innocuous change" w

Re: a lesson in query writing and (maybe) a bug report

2011-08-27 Thread Arthur Fuller
whenever I can. For example, it's possible to add a new Hire while not yet having determined which department s/he will work in, and hence which manager s/he will report to, but typically I deal with such scenarios by creating an "Undetermined" value in the corresponding lookup table. Arthur

Re: a lesson in query writing and (maybe) a bug report

2011-08-27 Thread Jigal van Hemert
Hi, On 27-8-2011 22:52, Dave Dyer wrote: The "innocuous change" was to add an index for "is_robot" which is true for 6 out of 20,000 records and null for the rest. Not useful to add an index for that. I also wonder why the value is null (meaning: unknown, not certain) for almost all records.

a lesson in query writing and (maybe) a bug report

2011-08-27 Thread Dave Dyer
The "innocuous change" was to add an index for "is_robot" which is true for 6 out of 20,000 records and null for the rest. My complaint/question/observation is not how to optimize the query that went awry, but to be alarmed that a venerable and perfectly serviceable query, written years ago and

Re: a lesson in query writing and (maybe) a bug report

2011-08-27 Thread Jigal van Hemert
Hi, On 27-8-2011 1:28, Dave Dyer wrote: Can you post the EXPLAIN EXTENDED output for your before and after queries? also, have you recently run an ANALYZE TABLE on the tables? What was the result of ANALYZE TABLE? What is the engine of the tables involved? // before Used keys: p2.NULL,

a lesson in query writing and (maybe) a bug report

2011-08-26 Thread Dave Dyer
BTW, the query on the database with the added index doesn't take forever, it takes a mere 51 minutes (vs. instantaneous). -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

a lesson in query writing and (maybe) a bug report

2011-08-26 Thread Dave Dyer
BTW, the query on the database with the added index doesn't take forever, it takes a mere 51 minutes (vs. instantaneous). -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Re: a lesson in query writing and (maybe) a bug report

2011-08-26 Thread Dave Dyer
> > >Can you post the EXPLAIN EXTENDED output for your before and after queries? >also, have you recently run an ANALYZE TABLE on the tables? // before mysql> explain extended select p1.player_name,g.score1,g.time1,g.color1,p2.player_name,g.score2,g.time2,g.color2,g.gamename,gmtdate -> f

Re: a lesson in query writing and (maybe) a bug report

2011-08-26 Thread Dan Nelson
the query used gmtdate as an index, an excellent choice. When > I added an index to "is_robot" on the players table, the query flipped to > using it, and switched from a brisk report to an infinite slog. > > I realize that selecting an index is an imprecise science, and I th

a lesson in query writing and (maybe) a bug report

2011-08-26 Thread Dave Dyer
s table, the query flipped to using it, and switched from a brisk report to an infinite slog. I realize that selecting an index is an imprecise science, and I that can specify what index to use as a hint, but this particular flip was particularly disastrous. It seems odd that the query optimize

Re: join query for sale report

2010-12-26 Thread bharani kumar
any suggestion, for my question plz On Fri, Dec 24, 2010 at 10:57 PM, bharani kumar < bharanikumariyer...@gmail.com> wrote: > I want to take the sale report, > > Group by catID , > > Daily report , > > table name : tblbasket BID Auto Incre, Prim Key > >

join query for sale report

2010-12-24 Thread bharani kumar
I want to take the sale report, Group by catID , Daily report , table name : tblbasket BID Auto Incre, Prim Key BID int(20), BasketSessionID varchar(100),ProductCode varchar(50), CatID int(10), Quantity int(20), AfterDiscount double,purchasedate datetime, Status int(3) table

RE: Crashed Table - How to report/prevent?

2010-09-14 Thread Gavin Towey
--Original Message- From: Steve Staples [mailto:sstap...@mnsi.net] Sent: Monday, September 13, 2010 7:03 AM To: mysql@lists.mysql.com Subject: Crashed Table - How to report/prevent? Good day MySQL! I had a table that crashed last night. There is a cron function that goes out every 6 hours o

Re: Crashed Table - How to report/prevent?

2010-09-13 Thread Johan De Meersman
On Mon, Sep 13, 2010 at 4:32 PM, Steve Staples wrote: > >From what I read, it puts a lock on the tables (read lock). the tables > in one of the databases are continuously being written/read/updated, so > I dont want to lock them if at all possible. > > Are there any other ways? > Well, given t

Re: Crashed Table - How to report/prevent?

2010-09-13 Thread Steve Staples
>From what I read, it puts a lock on the tables (read lock). the tables in one of the databases are continuously being written/read/updated, so I dont want to lock them if at all possible. Are there any other ways? Steve On Mon, 2010-09-13 at 15:11 +0100, a.sm...@ukgrid.net wrote: > Why not use

Re: Crashed Table - How to report/prevent?

2010-09-13 Thread a . smith
Why not use the mysql tool, mysqlcheck: http://dev.mysql.com/doc/refman/5.1/en/mysqlcheck.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Crashed Table - How to report/prevent?

2010-09-13 Thread Steve Staples
a quick routine that goes and 'shows' the tables, and if it fails, then repair it (or report it back to me via email or something). Any ideas on a way to automate something that is efficient and quick? Steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysq

Image - Crystal Report - VB6.0

2010-02-09 Thread Vikram A
Hi experts, I have blob filed, which contains the image. I am using BV6.0 as my front end application. And i have some pre-defined [defined by me] .rpt file. Along with the details, i would like to add the photo on the report. Can you help how to do this? Thank you Regards, VIKRAM A

Engine for Report Server

2008-12-01 Thread Krishna Chandra Prajapati
Hi all, I am setting up a mysql server for running reports. Which engine (innodb or myisam) will be better. Only select will be done on the mysql server. Some of the tables have more than 5 millions records. -- Krishna Chandra Prajapati MySQL DBA, Mob: 9912924044 Email-id: [EMAIL PROTECTED]

mysql performance report

2008-07-23 Thread sulochan acharya
Guys my mysqlreport says : Buffer used 205.00k of 16.00M %Used: 1.25 Current 2.04M%Usage: 12.76 Write hit 100.00% Read hit 97.90% __ Questions ___ Total 5.08k16.6/s * Com_ 2.68k

SQL for Subversion update-report

2007-10-03 Thread Jack Bates
I'm working on a Subversion interface to MediaWiki and am struggling with the SQL to respond to Subversion's update-report: http://www.mediawiki.org/wiki/WebDAV MediaWiki's revision table contains unique revision ids and the corresponding page id. The page table contains unique p

REPORT

2007-09-21 Thread waya . stefanakakis
‹ûµû­5ߓƒá:9jÃ`)›”c¹Ôæº|Õ¨åóûªéS{>­]²¥e˜Ñ Ü qá8Œ'´?²—|ïðC° ¹v{°MÀqþ”ò®o÷Qnùc¦2JB§¶5Aw¿{YÕÑízG™Ô™þHìÒb;•Šâƒ©ür¾†øï²„!,”lsR”Â|MNµ4⦠±0„¨?Û¬Š<:98ñÛMn9°Z5te®HÇô3ö‡Ð;;õa„“ö{Pi‚癓7.kÃâÀßÇLšÆ’ŒÈVéÛÛ²(C,z¾‚sï^wŸøÝ]snE2L§aüÁ„gtÚ{ üMñ‰k£[,&9²ò‡F%ݛNU“6ºçÜnS0¨K d4Þ]Ïby‚¯C—;E‘ÜRÞÞttꊛqû›ß MÄýøçƯiêŽÉ|K

report

2007-07-16 Thread susan . butts
Message could not be delivered -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Bug-reporting bug report

2006-11-18 Thread der Mouse
Bit of a problem with MySQL and bug reports. The README in the source distribution says to use http://bugs.mysql.com, with no alternatives given. On http://dev.mysql.com/doc/refman/5.0/en/bug-reports.html (which I had to find with google), I see If you have no Web access and cannot report a

Re: Using MySQL to log and report transactions

2006-11-10 Thread Dan Nelson
In the last episode (Nov 10), James Tu said: > I'm going use MySQL to log transactions so that I can report on them > later. > Ex: > > CREATE TABLE statistics ( >id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT > , user_id BIGINT UNSIGNED >

Using MySQL to log and report transactions

2006-11-10 Thread James Tu
Hi: I'm going use MySQL to log transactions so that I can report on them later. Ex: CREATE TABLE statistics ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT , user_id BIGINT UNSIGNED , entity_id INT UNSIGNED , transaction_type INTEGER(2) UNSIGNED , datetime_l

Re: report of last transaction?

2006-05-31 Thread sheeri kritzer
: (Excuse the beginner's question, but I couldn't find an answer in the documentation or in searching online. Please cc me on replies if possible.) Does mysql have a way to report on the last committed change to the database? I gather there is no undo in databases, in the sense of an e

report of last transaction?

2006-05-30 Thread Karl Berry
(Excuse the beginner's question, but I couldn't find an answer in the documentation or in searching online. Please cc me on replies if possible.) Does mysql have a way to report on the last committed change to the database? I gather there is no undo in databases, in the sense of an ed

Re: ugly SQL for a report...

2006-05-29 Thread Cory Robin
Slightly new query.. Here's the new query and results of an explain.. I'm thinking that some indexing would help.. However, I don't really know where to start. --- EXPLAIN SELECT pnr.ID ID_pnr, pnr.reservationdatetime, pnr.conf_number, pnr.created_by, (

Re: ugly SQL for a report...

2006-05-29 Thread Peter Brawley
Cory, One way to lose the duplicate queries is to assign the count per pnr.id to a user var, and calculate via that value: SELECT pnr.ID AS ID_pnr, pnr.reservationdatetime, pnr.conf_number, pnr.created_by, ( SELECT @pp_cnt := COUNT(1) FROM pnr_passengers pp WHERE pp.ID_pnr = pnr.ID

Re: ugly SQL for a report...

2006-05-29 Thread Jochem van Dieten
On 5/29/06, Cory Robin wrote: SELECT pnr.ID ID_pnr, pnr.reservationdatetime, pnr.conf_number, pnr.created_by, GROUP_CONCAT(pp.name_last,', ',pp.name_first ORDER BY name_last DESC SEPARATOR '') names, (SELECT SUM(pf.base_fare*(SELECT COUNT(1) FROM pnr_passengers pp WHERE pp.ID_pnr

Re: ugly SQL for a report...

2006-05-29 Thread Cory Robin
SELECT pnr.ID ID_pnr, pnr.reservationdatetime, pnr.conf_number, pnr.created_by, GROUP_CONCAT(pp.name_last,', ',pp.name_first ORDER BY name_last DESC SEPARATOR '') names, (SELECT SUM(pf.base_fare*(SELECT COUNT(1) FROM pnr_passengers pp WHERE pp.ID_pnr=pnr.ID )) FROM pnr_fares pf

Re: ugly SQL for a report...

2006-05-29 Thread Jochem van Dieten
On 5/29/06, Cory wrote: I have the following query that is running VERY slowly. Anyone have any suggestions? --- SELECT pnr.ID ID_pnr, pnr.reservationdatetime, pnr.conf_number, pnr.created_by, GROUP_CONCAT(pp.name_last,', ',pp.name_first ORDER BY name_last DESC SEPARATOR '') names, (SELECT SUM

ugly SQL for a report...

2006-05-28 Thread Cory
I have the following query that is running VERY slowly. Anyone have any suggestions? --- SELECT pnr.ID ID_pnr, pnr.reservationdatetime, pnr.conf_number, pnr.created_by, GROUP_CONCAT(pp.name_last,', ',pp.name_first ORDER BY name_last DESC SEPARATOR '') names, (SELECT SUM(pf.base_fare*(SELECT

RE: Report Generator

2006-02-06 Thread George Law
Sent: Saturday, February 04, 2006 10:23 AM > To: MySQL-General > Subject: Report Generator > > Hi, I'm new to the list and not sure whether my question > belongs here or not. I'm looking for an open source program, > that runs on JSP, to generate reports on data in MySQL

Re: Report Generator

2006-02-06 Thread Gleb Paharenko
Hello. I'm not sure, but have a look here: http://dev.mysql.com/tech-resources/articles/dba-dashboard.html Chuck Craig wrote: > Hi, I'm new to the list and not sure whether my question belongs here or > not. I'm looking for an open source program, that runs on JSP, to > generate reports on d

Report Generator

2006-02-04 Thread Chuck Craig
Hi, I'm new to the list and not sure whether my question belongs here or not. I'm looking for an open source program, that runs on JSP, to generate reports on data in MySQL databases. I've found a few myself but they run on PHP. Any thoughts or advice would be very appreciated. -Chuck Craig -

Re: Report tool - Mysql

2005-12-18 Thread Daniel Kasak
Darryl Hoar wrote: Greetings, I need to get a tool to create reports using mysql databases. It would be great if the resultant reports could be run by themselves (not inside the report development environment). Anybody have any recommendations ? Yes. One of my open-source projects is PDF

RE: Report tool - Mysql

2005-12-16 Thread Jimmy Guerrero
om: Darryl Hoar [mailto:[EMAIL PROTECTED] Sent: Friday, December 16, 2005 2:59 PM To: mysql@lists.mysql.com Subject: Report tool - Mysql Greetings, I need to get a tool to create reports using mysql databases. It would be great if the resultant reports could be run by themselves (not inside the rep

Report tool - Mysql

2005-12-16 Thread Darryl Hoar
Greetings, I need to get a tool to create reports using mysql databases. It would be great if the resultant reports could be run by themselves (not inside the report development environment). Anybody have any recommendations ? thanks, Darryl -- MySQL General Mailing List For list archives

Re: report from two tables

2005-11-03 Thread [EMAIL PROTECTED]
s_No DESC LIMIT 100 It works for me. Regards! -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Enviado el: Jueves, 03 de Noviembre de 2005 03:55 p.m. Para: MySQL List Asunto: report from two tables Hi, I have two table for orders and I have to create a Report with list

RE: report from two tables

2005-11-03 Thread ISC Edwin Cruz
ROTECTED] Enviado el: Jueves, 03 de Noviembre de 2005 03:55 p.m. Para: MySQL List Asunto: report from two tables Hi, I have two table for orders and I have to create a Report with list of orders from both tables for specific day. I made Reports for each table and they work just fine, but don&

report from two tables

2005-11-03 Thread [EMAIL PROTECTED]
Hi, I have two table for orders and I have to create a Report with list of orders from both tables for specific day. I made Reports for each table and they work just fine, but don't know how to "put them together": Query for Order Table 1: SELECT o.Trans_No, o.SoldBy, sm.

Re: bug report

2005-10-05 Thread Gleb Paharenko
Hello. Please, could you send a more detailed report. Include information about MySQL and operating system versions. See: http://dev.mysql.com/doc/mysql/en/Bug_reports.html You may want to force a recovery. See: http://dev.mysql.com/doc/mysql/en/forcing-recovery.html Pierre-Henry

bug report

2005-10-04 Thread Pierre-Henry Perret
. InnoDB: Send a detailed bug report to mysql@lists.mysql.com mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning

Re: A Complicated Report

2005-09-26 Thread Shaun
k on Projects and each project will have various Work_Types, > days > >taken off are not related to projects and are held in > >Unavailability_Descriptions. I need to produce a capacity report to show > >days worked vs time taken off per staff member per month for a particular >

Re: A Complicated Report

2005-09-24 Thread Peter Brawley
are held in >Unavailability_Descriptions. I need to produce a capacity report to show >days worked vs time taken off per staff member per month for a particular >project i.e. >January February >John Smith >Work Type 1 12 ... >Work Type 2 5 ... >Work Type 3 5 ... >Sickn

A Complicated Report

2005-09-24 Thread Shaun
Unavailability_Descriptions. I need to produce a capacity report to show days worked vs time taken off per staff member per month for a particular project i.e. January February John Smith Work Type 1 12 ... Work Type 2 5 ... Work Type 3 5 ... Sickness 1 ... Holiday 2 ... Total Days 19

Re: how to link to crystal report

2005-08-09 Thread SGreen
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? > > > > If all you need is to query the database and create an > Excel Spread

Re: how to link to crystal report

2005-08-08 Thread Daniel Kasak
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 inv

Re: how to link to crystal report

2005-08-08 Thread Enrique Sanchez Vela
--- 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

how to link to crystal report

2005-08-08 Thread Elizabeth Bonifacio
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 s

Re: mySQL Bug Report

2005-08-02 Thread Gleb Paharenko
Hello. I don't know the relationships between program articlebot and MySQL. But error message tells me to ask you to check if you have MyODBC properly configured and whether your MySQL server is running. See: http://dev.mysql.com/doc/mysql/en/can-not-connect-to-server.html There is

mySQL Bug Report

2005-08-02 Thread Kari White
After installing mySQL along with a program called articlebot, I tried to run the application and I keep getting this message: "An unhandled exception has occurred in a component in your application. Click continue and application will ignore this error and attempt to continue. ERROR [HY000

Kindly help me in generating optimal report in Nessus through MYSQL

2005-07-30 Thread Arumugam K
hi I have a requirement in generating a report in Nessus, Can you kindly help me on this.I am using nessus in my office.I generated a report through nessusWX in windows HTML format.In the report a column named description having description,solution and warning indicated as *** for each

Report tools

2005-07-20 Thread Nestor Florez
Any report tools that can be use with Mysql that you guys can recommend? Any free mysql report generators? Thanks, Nestor :-) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Make a report like this...

2005-07-20 Thread Greg Fortune
||| 1pxa-1,1pxb-1,1pxc-1,2phh-1 | > > +--+---+++-+ > > | 1793 |10 | 1 | 1 | 1jdx-1,2jdw-1,2jdx-1,3jdw-1,4jdw-1, | > | > | | ||| 5jdw-1,6jdw-1,7jdw-1,8jdw-1,9jdw-1 | > > +--+---+++-----+ > >

Re: Make a report like this...

2005-07-20 Thread Dan Bolser
On Wed, 20 Jul 2005, Peter Brawley wrote: >Dan > >/>Hello, I made the above report by hand after using a GROUP_CONCAT > >query. Is there any way to make this kind of format automatically in > >MySQL?/ > >How about HTML output (mysql ... -H)? Yeah, I found tha

Re: Make a report like this...

2005-07-20 Thread Peter Brawley
Dan >Hello, I made the above report by hand after using a GROUP_CONCAT >query. Is there any way to make this kind of format automatically in >MySQL? How about HTML output (mysql ... -H)? PB -- Dan Bolser wrote: +--+---+++

Make a report like this...

2005-07-20 Thread Dan Bolser
| +--+---+++-+ | 1793 |10 | 1 | 1 | 1jdx-1,2jdw-1,2jdx-1,3jdw-1,4jdw-1, | | | ||| 5jdw-1,6jdw-1,7jdw-1,8jdw-1,9jdw-1 | +--+---+++-+ Hello, I made the above report by hand after using

Report

2005-07-10 Thread heidi16
The original message was received at Thu, 7 Jul 2005 09:34:11 +0200 from 35.120.172.60 - The following addresses had permanent fatal errors - - Transcript of session follows - ... while talking to server 92.244.150.42: 554 5.0.0 Service unavailable; [129.158.164.155] blocked usi

Fwd: Problem report (could not start MySQL 4.1.12)

2005-06-11 Thread Tan Chung
Tan Chung <[EMAIL PROTECTED]> wrote: Date: Fri, 10 Jun 2005 21:13:37 -0700 (PDT)From: Tan Chung <[EMAIL PROTECTED]>Subject: Problem report (could not start MySQL 4.1.12)To: mysql@lists.mysql.comHi there,Attached is my problem report.Please help.Thanks,Tan.-- MySQL General Mailing L

Problem report (could not start MySQL 4.1.12)

2005-06-10 Thread Tan Chung
Hi there, Attached is my problem report. Please help. Thanks, Tan. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Bug Report (LOAD DATA FROM MASTER on MERGE Tables)

2005-06-07 Thread Gordan Bobic
It would appear that LOAD DATA FROM MASTER processes databases and tables alphabetically. When a merge table is being copied, and it's name is alphabetically before some/any/all of it's components, the process fails with a 1017 couldn't find file error. Has this been fixed? If so, as of which

Re: Report(query)

2005-05-12 Thread Eamon Daly
lt;[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; Sent: Thursday, May 12, 2005 12:54 PM Subject: Re: Report(query) ROLLUP is not working with current version.IS any way i can do? I have 1 column names time with data type datetime.I want to get report like -mm-dd format. Can I get by using

Re: Report(query)

2005-05-12 Thread Seena Blace
ROLLUP is not working with current version.IS any way i can do? I have 1 column names time with data type datetime.I want to get report like -mm-dd format. Can I get by using date_format(nameofcolumn,'%Y-%m-%d')? Harald Fuchs <[EMAIL PROTECTED]> wrote: In article <[EMAIL

Re: Report(query)

2005-05-12 Thread Harald Fuchs
In article <[EMAIL PROTECTED]>, Seena Blace <[EMAIL PROTECTED]> writes: > Hi, > I want report like this > date process pending wip > 5/10/051030 40 > 5/11/05 09

Report(query)

2005-05-11 Thread Seena Blace
Hi, I want report like this Table description is like as follows Field | Type | Null | Key | Default | Extra | +-+--+--+-+-++ | id | int

Re: Total Counts, Multi-Report Questions

2005-02-13 Thread Sue Cram
Thanks for the ideas, Dan. I'm making progress! - Original Message - From: "Dan Nelson" <[EMAIL PROTECTED]> To: "Sue Cram" <[EMAIL PROTECTED]> Cc: Sent: Sunday, February 13, 2005 12:34 AM Subject: Re: Total Counts, Multi-Report Questions In the la

Re: Total Counts, Multi-Report Questions

2005-02-13 Thread Dan Nelson
In the last episode (Feb 12), Sue Cram said: > I have a request for a list of database entries "Select x,y,z, etc" > that is now working OK. I have several questions, however. Here > they are: > > 1.. Can I add a "total" line at the bottom of the report (ex

Total Counts, Multi-Report Questions

2005-02-12 Thread Sue Cram
I have a request for a list of database entries "Select x,y,z, etc" that is now working OK. I have several questions, however. Here they are: 1.. Can I add a "total" line at the bottom of the report (ex: "Total Selected: 23") for the total number of entries

RE: How do I Put a 'Literal' Value in a Report Column?

2005-02-07 Thread Artem Koltsov
see 12.2 Control Flow functions of MySQL manual select name, if(adopted=0,'N','Y') from animal; > -Original Message- > From: Sue Cram [mailto:[EMAIL PROTECTED] > Sent: Monday, February 07, 2005 2:58 AM > To: mysql@lists.mysql.com > Subject: How do

Re: How do I Put a 'Literal' Value in a Report Column?

2005-02-07 Thread SGreen
"Sue Cram" <[EMAIL PROTECTED]> wrote on 02/07/2005 02:57:59 AM: > This is a pretty basic question, but I'm learning SQL from a book > and it's very very frustrating! > > I'm writing a report listing animals from our shelter and whether > they have

Re: How do I Put a 'Literal' Value in a Report Column?

2005-02-07 Thread Duncan Hill
On Monday 07 February 2005 07:57, Sue Cram might have typed: > I'm writing a report listing animals from our shelter and whether they have > been adopted. I am selecting the animal name field and a field called > 'adopted' from a table called 'animal'. The va

How do I Put a 'Literal' Value in a Report Column?

2005-02-07 Thread Sue Cram
This is a pretty basic question, but I'm learning SQL from a book and it's very very frustrating! I'm writing a report listing animals from our shelter and whether they have been adopted. I am selecting the animal name field and a field called 'adopted' from a ta

Re: err-report help me

2005-02-03 Thread Gleb Paharenko
Hello. See: http://dev.mysql.com/doc/mysql/en/can-not-connect-to-server.html http://dev.mysql.com/doc/mysql/en/windows-troubleshooting.html " ???" <[EMAIL PROTECTED]> wrote: > mysql=A3=AC=C4=FA=BA=C3=A3=A1 > > =09 when click mysql.exe on $home\bin

err-report help me

2005-02-02 Thread 张海军
mysql,您好! when click mysql.exe on $home\bin ,the report err is "D:\Program Files\mysql\bin>mysql ERROR 2003: Can't connect to MySQL server on 'localhost' (10061) " please help me 致 礼! zhanghjun [EMAIL

Getting monthly download report

2004-12-13 Thread Karam Chand
al version I keep his info in the table. I also send a mail to the user with the download instrcutions. When the user clicks on the link - i increment dn_from_email by one to know that he actually downloaded the app by cliciking on the link. I get report for my downloads by executing multiple queri

Re: Report Designer

2004-11-13 Thread Andy Davidson
On 12 Nov 2004, at 20:04, Ron Thomas wrote: What do most people use for a report designer for linux? I need to design a report similar to a phone book directory, ie, multi-column with page breaks when the first letter of the field changes. use perl; Something like DBI will talk to the MySQL

Re: Report Designer

2004-11-12 Thread Warren Young
Ron Thomas wrote: What do most people use for a report designer for linux? Perl. :) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Report Designer

2004-11-12 Thread Ron Thomas
What do most people use for a report designer for linux? I need to design a report similar to a phone book directory, ie, multi-column with page breaks when the first letter of the field changes. Thanks, Ron. "To really screw up Linux you have to work at it...To really screw up Wi

Help to write a report

2004-11-12 Thread Laercio Xisto Braga Cavalcanti
ta_codigo_dentista = d.dent_codigo and c.consulta_codigo_paciente = p.pac_codigo and cons_codigo = 1 and consulta_ano = 2004 and consulta_mes = 09 order by cons_codigo, dent_codigo, consulta_ano, consulta_mes, consulta_dia, Consulta_hora, consulta_minuto into outfil

Help to write a report

2004-11-12 Thread Laercio Xisto Braga Cavalcanti
IGUES S 169180 15/9/2004 17:0CLINICA Itálica Paulista Dentista 2 ALINE OLIVIA SILVA OLIVEIRA S 142403 22/9/2004 10:0ORTO Itálica Paulista Dentista 2 FABIANA SANCHES OCANHA S 152810 22/9/2004 1:0ORTO and so on... I need th

Help with report

2004-11-11 Thread Laercio Xisto Braga Cavalcanti
AMANDA GONCALVES RODRIGUES S 169180 15/9/2004 17:0CLINICA Itálica Paulista Dentista 2 ALINE OLIVIA SILVA OLIVEIRA S 142403 22/9/2004 10:0ORTO Itálica Paulista Dentista 2 FABIANA SANCHES OCANHA S 152810 22/9/2004 1:0

mysqlbug report

2004-10-25 Thread Louis R. Profit
From: lrpbfd To: [EMAIL PROTECTED] Subject: [50 character or so descriptive subject here (for reference)] >Description: >How-To-Repeat: >Fix:

bug report!!

2004-08-27 Thread IT Arabesque Piatra Neamt
server not starting beginnig two-three days ago. All went well until then, when i had some large queries on server, and i think that was the moment when it crashed. I tried increasing the amount of innodb_buffer_pool_size from 8 to 16M , it started now, but the same list of errors appears in the

Re: Bug-Report: mysqld 4.1.3 crashes on startup

2004-08-01 Thread Sergei Golubchik
Hi! On Aug 01, Helge Jung wrote: > >Description: > When I start up my fresh compiled mysqld it crashes immediately, the > error log file says: It was reported just a few hours ago at bugs.mysql.com (which is the recommended way to report bugs, by the way :) you may follow the pr

Bug-Report: mysqld 4.1.3 crashes on startup

2004-07-31 Thread Helge Jung
>Description: When I start up my fresh compiled mysqld it crashes immediately, the error log file says: 040801 00:07:28 mysqld restarted 040801 0:07:29 Warning: Can't open time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them mysqld got signal 11;

Report query problem

2004-07-04 Thread wally . randall
Coming from an Oracle background I am struggling with the following report generation. This is a report which needs to be created using mySQL: Week of mm/dd/yy mm/dd/yy mm/dd/yy mm/dd/yy mm/dd/yy Total All Groups nn nn nn nn

Weekly activity report

2004-03-07 Thread miguel
Response -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Weekly activity report

2004-03-01 Thread miguel
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: [mysql 5.0, connection loss, procedure-related, easy to reproduce, detailed report] what you ever wanted to know about trees

2004-01-20 Thread Victoria Reznichenko
Stefan Traby <[EMAIL PROTECTED]> wrote: > Hi ! > > mysql 5.0 is _really_ cool. > > this bug should be reproducable: Thank you for bug report! It was entered to the bug database as http://bugs.mysql.com/2460 > > > ( cat table.sql ; ./populate.pl ; ./per

[mysql 5.0, connection loss, procedure-related, easy to reproduce, detailed report] what you ever wanted to know about trees

2004-01-16 Thread Stefan Traby
Hi ! mysql 5.0 is _really_ cool. this bug should be reproducable: ( cat table.sql ; ./populate.pl ; ./perfect_game.pl 32 ) | mysql test after that executing the same procedure with same parameter again, the connection is lost: --

Re: Free software to design forms and report

2004-01-09 Thread Shawn
I am a new to MySQL. Would like to find out if there is any free software out in the market to design forms and report that links to MySQL. I am looking at a local database, forms and report. How about DBForms? http://jdbforms.sourceforge.net/ DbForms enables developers to build sophisticated

Re: Free software to design forms and report

2004-01-08 Thread robert_rowe
That depends on what programming languages that you know how to use. You could use PHP, Perl, Python, Java, C++, ASP (if you're on Windows) or many others. All of these are available for free but you need to know how to use them. If you're looking for a GUI driven program and you are already fa

  1   2   3   4   >