harmonic mean in SQL

Hi, The mathematical way to add two partial harmonic means to generate new harmonic mean is: Let X1 , X2 be two harmonic means on different rollup rows, generated using n1 and n2 # of facts respectively. The combined harmonic mean would be: (n1 + n2)/( n1/x1 + n2/x2) If you have experience

possible curdate() issue

worked OK. Today ... not so much. Since this behavior is the same on MySQL 4.1.22, 5.0.77 and 5.1.36 I must be doing something wrong. Any Ideas? Ted Maas Research Programmer Systems Group Academic Computing and Communications Center University of Illinois at Chicago -- MySQL General

mysql and tomcat

Hi, In our deployment, mysql needs to be started before tomcat automatically after server restart. If you know how this order can be specified, please share. We use tomcat6 on Linux tyu-linux 2.6.18-128.2.1.el5 #1 SMP Tue Jul 14 06:36:37 EDT 2009 x86_64 x86_64 x86_64 GNU/Linux Thanks

tuning stored procedures

Hi, We currently use SQL statements embedded in Java code. I believe stored procedures would give us better performance. I found http://lists.mysql.com/maxdb/16680 which is very old. Can someone share stored procedures tuning practices ? Thanks

Re: unable to create function in MySQL 5.0

Yes. MySQL was upgraded. What's the name of upgrade script and where is it ? --- Martijn Tonies [EMAIL PROTECTED] wrote: Hello Ted, I got an error that I don't understand: Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3080

Can't initialize function

Hi, My initialization for UDF is quite simple: my_bool do_system_init(UDF_INIT *initid, UDF_ARGS *args, char *message) { initid-max_length = 256; initid-maybe_null=1; args-arg_type[0]=STRING_RESULT; initid-ptr = NULL; return 0; } But I got: Welcome to the

unable to create function in MySQL 5.0

I got an error that I don't understand: Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3080 to server version: 5.0.18-log mysql create function do_system returns integer soname 'raptor_udf.so'// ERROR 1146 (42S02): Table 'mysql.proc' doesn't

username audit column

Has any MySQL user established triggers to fill out the audit columns (such as CREATED_BY - username that performs the underlying operation) ? Thanks Want to start your own business? Learn how on Yahoo!

Re: username audit column

By username I mean Linux login. Is there a way to call Perl/Shell script to obtain this information ? --- Ted Yu [EMAIL PROTECTED] wrote: Has any MySQL user established triggers to fill out the audit columns (such as CREATED_BY - username that performs the underlying operation) ? Thanks

before update trigger syntax

Can someone tell me what's wrong with my before update trigger syntax ? Thanks Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 19 to server version: 5.0.18-log mysql use eventtracker; Reading table information for completion of table and column names You

Re: Re: Re: Re: Readind a Dump W/o Expanding It

8080The data field's a text field, not a blob! That's the problem, there are no blobs, and I just wanted a second set of eyes on this to confirm what simply makes no sense at all! I'd love to know where the dickens those images went!! Thanks anyway, Ted - Original Message From: Dan

Re: Re: Readind a Dump W/o Expanding It

That worked! Thanks! However, when I restored the database, it seemed to have trashed all the images. What do? TIA, Ted - Original Message From: Dan Buettner [EMAIL PROTECTED] To: Ted Johnson [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Saturday, October 14, 2006 9:59:31 PM

Re: Re: Re: Readind a Dump W/o Expanding It

74- Original Message From: Dan Buettner [EMAIL PROTECTED] To: Ted Johnson [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Sunday, October 15, 2006 9:22:04 AM Subject: Re: Re: Re: Readind a Dump W/o Expanding It How were they stored in the database? You got me on that. I just took

Readind a Dump W/o Expanding It

107Hi; Is there a command by which I can read the names of databases in a mysqldump without expanding the dump into my mysql instance (and thus overwriting databases already extant)? TIA, Ted

Re: Readind a Dump W/o Expanding It

That worked! It's there! Now...how can I rebuild *just* that database (which was removed from my MySQL server) without affecting the other databases? TIA, Ted - Original Message From: Dan Buettner [EMAIL PROTECTED] To: Ted Johnson [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent

old_passwords

Hi, Newb question... ok just a dumb question: If I have never created or edited a 'my.cnf' file and yet I have a working MySQL, what conf file is being used and where is it (OS X Server)? Also, where does the my.cnf go once created? Thanks, TR -- MySQL General Mailing List For list

Re: could a Trigger execute a outside command?

of stuff to do this. ted On Jun 24, 2005, at 2:42 PM, [EMAIL PROTECTED] wrote: Isn't this what a User Defined Function would be used for? Your trigger would call the UDF which would do a system(). Or is this not possible under Mac OS? -Lee Gleb Paharenko [EMAIL PROTECTED] I don't know any

Re: could a Trigger execute a outside command?

a trigger on this table. When the trigger is triggered, it will call the same perl script through UDF. Not sure whether I get it right. ted On Jun 27, 2005, at 12:19 PM, Michael Kruckenberg wrote: On Jun 27, 2005, at 1:32 PM, Ted Zeng wrote: I don't know if it is possible under Mac OS. But I

Re: could a Trigger execute a outside command?

Jeremy, Thanks. I used Perl's cron module to execute my script. So I assume only the cron mdoule is active all the time, but not my perl script. Your approach looks interesting to me. I will think about it. ted zeng On Jun 27, 2005, at 1:14 PM, Jeremy Cole wrote: Hi Ted, When a new record

could a Trigger execute a outside command?

Hi, I am using MySql on Mac OS X. I am wondering if I could execute a command (shell, perl) by a Trigger. I read the manual and it seems this is impossible. ted -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

need opinion on FmPro Migrator

Hi, all, I need to convert databases from FileMaker to MySQL. I searched the web and found this product FmPro Migrator I am wondering if people here have used it and know how well it works. Or are there any other way to do the conversion out there? Ted Zeng Adobe Systems Inc.

temporary tables

this be accomplished with temporary tables, or should i just create static tables and then use a cron job to delete unused ones? What is the best way to approach this? Ted Toporkov [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Select from two tables not returning the expected number of rows

query should have been what I expected. Please correct me if that is not the case. Thanks for the feedback, Ted -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Select from two tables not returning the expected number of rows

. The combination should be unique for each of the tables, and there should be one record in table_b having the same combination as the each record in table_a. It is looking like there are duplicated rows, and I'm going to have to get them cleaned out. Thanks for your assistance, Ted -- MySQL General

Select from two tables not returning the expected number of rows

, the server version is 4.0.13, running on Windows 2K. Thanks, Ted mysqlselect count(*) from x.table_a,y.table_b WHERE x.table_a.svr = y.table_b.svr and x.table_a.started = y.table_b.started and x.table_a.ended = y.table_b.ended and x.table_a.volume = y.table_b.volume and x.table_a.who

Storing SQL in a column? - looking for advice

throughout the day). I was contemplating storing the queries in a column, which would be read and then executed by the script, but wanted to see if anyone had any recommendations for a better approach. Thanks, Ted -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: Long Running Queries

Is the table indexed in any way? At 03:40 PM 10/6/2004, you wrote: Hello, I recently began experiencing issues that I would like some assistance with. Server Details: - Windows 2003 - MySQL Max 4.0.20a I have a table with 450,000+ records in it. When I try to run a single query, such as

Re: 2 questions: hostname variable and exit if slave

| +---+-+ | pid_file | /var/lib/mysql/tatooine.xyzcorp.com.pid | +---+-+ Regarding number 2 (as well as #1), my inclination is to reach for perl, but I don't know if that's an option for you. HTH, Ted At 11:01 PM 10/6/2004

Unknown table ... in where clause

, it would be helpful to be able to do this without writing a script. Thanks, Ted mysql UPDATE dp_populate_vals - SET dp_populate_vals.tbl_id=dp_populate_tables.tbl_id - WHERE dp_populate_tables.tgt_tbl=dp_populate_vals.tgt_tbl; ERROR 1109: Unknown table 'dp_populate_tables' in where clause

Re: Unknown table ... in where clause

At 04:05 PM 10/4/2004, [EMAIL PROTECTED] wrote: I guess the docs aren't totally clear on this as you are not the first person to have problems forming a multiple-table UPDATE statement. Thanks for the quick response. It's somewhat gratifying to hear that I'm not alone in my confusion... Ted

Re: Does anyone has the experience on migrating mysql server from 32bit sysem to a 64bit system?

of your data, with and without the -C switch. It might also be possible to pipe the mysqldump output to gzip so that the size of your resultant disk file(s) would be minimized. Ted At 11:20 PM 10/4/2004, alex ye wrote: Thanks Eric. But our data is very big(about 400G), server don't have enough

Re: Newbie question - Input limitations on mysql client?

for pointing out the mysqlimport tool - that sounds like what I should really be using instead of cut-n-paste... Ted At 08:08 PM 9/29/2004, Andrew Kreps wrote: On Wed, 29 Sep 2004 10:05:29 -0400, Ted Byrne [EMAIL PROTECTED] wrote: Is the apparent line length limit a restriction imposed

Newbie question - Input limitations on mysql client?

imposed by the client? (And does it apply if you are piping or redirecting output from another process or a file?) Thanks in advance, Ted -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Large ResultSets/TYPE_SCROLL_INSENSITIVE

Ted

RE: Design Advice?

a foreign key field for each invoice line item type: PO_EntryID, SO_EntryID, Adj_EntryID, etc. This will help in enforcing referential integrity. Ted -Original Message- From: Ed Lazor [mailto:[EMAIL PROTECTED] Sent: Thursday, February 26, 2004 12:16 PM To: 'Zhao, Charles'; [EMAIL

RE: Help with a query

and t2mgr.manager_type = 2 Does that fit the bill? Ted Gifford -Original Message- From: Gregory A. Swarthout [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 24, 2004 9:09 AM To: [EMAIL PROTECTED] Subject: Help with a query Suppose I have two tables like this: keystone_stores

RE: Help with a query

I think you may have introduced the From typo, but it is one regardless. I don't think the parens are necessary. Try it out. Ted Gifford -Original Message- From: Gregory A. Swarthout [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 24, 2004 9:44 AM To: [EMAIL PROTECTED] Cc: [EMAIL

RE: Improving seek/access times -- does RAID help?

Run everything off a ramdisk ;-) Ted Gifford -Original Message- From: Matt W [mailto:[EMAIL PROTECTED] Sent: Friday, February 20, 2004 5:21 PM To: [EMAIL PROTECTED] Subject: Improving seek/access times -- does RAID help? Hi all, Can anyone tell me whether or not some kind of RAID

RE: Stumped on a query

Why not: SELECT * FROM table1, table2 WHERE table2.columnB = 'this' AND FIND_IN_SET(table2.columnA, REPLACE(table1.columnA,';',',') ) 0 Documented here: http://www.mysql.com/doc/en/String_functions.html Ted Gifford -Original Message- From: Tobias Asplund [mailto:[EMAIL PROTECTED

Removing old records

and delete them? Ted Toporkov [EMAIL PROTECTED]

Re: os X install mySQL help

A good reference, may help (or not): http://www.entropy.ch/software/macosx/mysql/ Ted Rogers On Thursday, June 5, 2003, at 03:18 PM, gerald jones - Sun Microsystems - Broomfield United States wrote: This is a mac os X installation problem: When I download/install the pkg version of mysql

Re: database newbie

don't know. I do know, or think I do, that MySQL does NOT have/handle Foreign Keys. So what do I do? Thanks Ted On Friday, May 30, 2003, at 04:58 AM, Becoming Digital wrote: that is, that if the values for the field 'table1.people_id' rows is 1 - 50, then the field values for 'table2

Re: establishing relationship

corresponding data; put another way, after establishing a Foreign Key field it cannot be populated automagically, right? Thanks, Ted I think it's fair to say that most end-users don't work with data by typing out SQL statements. Data is usually entered and retrieved via a front end of sorts, often

upgrading to v 4.1

Is it recommended that I upgrade MySQL 3.23.53 to 4.1.x? Are then any special notes I might remember when doing so? (Mac OS X Server 10.2.6) Ted -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

bad exe file in win32 download

Hi: I have tried several times to download the win32 zip file. When I try to unzip it, winzip says that the exe file is invalid. Any thoughts? Thanks for your help. Ted Chila

re: accessing MySQL using msqry32.exe

hello all, thanks for the replies regarding why problems using msqry32.exe. ultimately, my flaw was that i had created a GRANT for the database "cat" while the ODBC DSN connection was trying to use the database "CAT". uppercase got me, a common problem of mine. thanks again.

howto: telnet shell

i have a MySQL server running in my office. i need to be able to telnet into the MySQL server remotely. can anyone point me at documentation that will tell me how? right now (from a dos window) when i issue: TELNET server.name 3306 - it reports "BAD HANDSHAKE" i think that somehow i