RE: converting numeric to date-time?

SET @tz=@@session.time_zone ; SET SESSION time_zone = '+0:00' ; SELECT DATE_FORMAT( FROM_UNIXTIME(1409304102.153) /*your epoch column here*/ ,'%Y-%m-%d %a %H:%i:%s.%f GMT'); SET SESSION time_zone = @tz ; >> 2014-08-29 Fri 09:21:42.153000 GMT (or) SELECT DATE_FORMAT( FROM_UNIXTIME(1409

Re: replication newbie questions

e 5.5 hour dumps are already done during the least busy times. Regarding snapshots, how long are snapshot locks held? These are ext4 filesystems. Assuming the lock is not held for long, what's the recommended way to do snapshots on ext4? Thanks, Ed On Thursday, August 29, 2013, Ed L

replication newbie questions

action --master-data --all-databases Thank you in advance for any help. Ed

connection issue

This mysql newbie is having trouble connecting to a mysqld instance, hoping someone can offer a clue on troubleshooting. I have 2 mysql 5.0.45 installations on one RHEL server. One live mysqld is setup in what appears to be a relatively standard installation, port 3306, user 'mysql', etc.

How do I use a dynamic filename for an into outfile statement

s it The select concat() works from the command line I can manually add the file name but would like to automate the process Lastly, if it makes a difference, I don't use any graphical tools for DB stuff. Inevitably someone says 'click here' :-) Thanks for any help Ed

Re: how to RE-add innoDB storage? kinda kludgy fix

On 03/04/2011 09:24 PM, ed wrote: On 03/04/2011 10:46 AM, Jerry Schwartz wrote: -Original Message- From: ed [mailto:eth...@earthlink.net] [JS] I guess wordwrap is going to mess this up; mysql> show engines ; [JS] Next time, try SHOW ENGINES\G Regards, I see no differen

Re: how to RE-add innoDB storage?

On 03/04/2011 10:46 AM, Jerry Schwartz wrote: -Original Message- From: ed [mailto:eth...@earthlink.net] [JS] I guess wordwrap is going to mess this up; mysql> show engines ; [JS] Next time, try SHOW ENGINES\G Regards, I see no differences. thanks for

how to RE-add innoDB storage?

I have recently noticed I can not access a PHP application's data files, and the errors I am getting seem to show that a recent update of the distro (mandriva) no longer supports innodb, and this may be a reason (if this is not some sort of "catchall" error). I would like to know how to add inn

find records with only numbers

I hope someone can give me a suggestion on this. I'd like to find records in a table where a specific field only contains a number. For example, Select Field1 as f from table1 as t where lcase(t.f) not like in ('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','

Re: Timestamps replicating inconsistently depending on local timezone of server?

then I have a bag of trouble when I want to figure out the time something happened (as you can see c1 and c2 should be the same in all cases, but not in your example) Can anyone shed some light on the best approach? Thanks Ed W -- MySQL General Mailing List For list archives:

Re: Timestamps replicating inconsistently depending on local timezone of server?

Rob Wultsch wrote: On Tue, May 13, 2008 at 2:07 PM, Ed W <[EMAIL PROTECTED]> wrote: I had naively assumed that dates would always be stored in UTC in the database and the only effect of localtime would be for display purposes? Can anyone shed some light on what's happening

Timestamps replicating inconsistently depending on local timezone of server?

med that dates would always be stored in UTC in the database and the only effect of localtime would be for display purposes? Can anyone shed some light on what's happening here please? Thanks Ed W -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysq

Re: Recent change in behaviour when inserting into NOT NULL fields??

Baron Schwartz wrote: Hi Ed, On Thu, Apr 3, 2008 at 3:32 PM, Ed W <[EMAIL PROTECTED]> wrote: Hi Up until version 5.0.44 (on linux) it appeared that you could do stuff like deliberately insert a NULL into a NOT NULL varchar field and it would be silently converted to an empty

Lost my defaults on varchar columns?

y this has changed? Innodb if this makes a difference.. Thanks Ed W -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Recent change in behaviour when inserting into NOT NULL fields??

ehaviour can be controlled, but as far as I can see I don't have the |STRICT_ALL_TABLES or ||STRICT_TRANS_TABLES options enabled anyway..? How can I return to the old behaviour (at least until I update my app)? Is this change in behaviour defined anywhere? Thanks Ed W | -- MySQL General M

Migrating form 3.23.49 to 5.0.32

I'm doing the above migration as mentioned in the subject line. I figured I would use the MySQL Migration Toolkit to help it along but it won't let me connect to my 3.23.49 server. Is there any other way to migrate all my data easily. Thanks, Ed -- MySQL General Mailing Lis

before insert trigger

Is it possible for a trigger to test the data to be inserted and if it doesn't meet specific criteria not insert the data at all? I have an application that writes a lot of data to my table. I don't have control over this application and it writes a lot more data then I need. So I'd like to ha

ODBC 3.51.22 problem - please help

I've found a glaring problem with the latest ODBC connector. Data types have been changed and data is no longer being read correctly. I'm running MySQL 5.1.16 on Netware. My apps are VB6 and VBA using ADO. The following query produces different data types depending on the version of the ODBC d

I hope I won't be thrown off the list for this

I know it's not 'Mysql help' related, but I hope this gets a smile, and I figure this crowd would appreciate it as much as any crowd; http://xkcd.com/327/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Access denied for GRANT using root yet manual user insertion is fine

l. On 9/2/07, Ed Cradock <[EMAIL PROTECTED]> wrote: > The grant flag is enabled on the root account: > > mysql> SELECT Grant_priv FROM user WHERE User='root' AND Host='localhost'; > > ++ > | Grant_priv | > ++ > | Y

Access denied for GRANT using root yet manual user insertion is fine

This works without a problem! Contents of the my.cnf: # cat /etc/my.cnf [mysqld] set-variable = max_connections=500 safe-show-database log=/var/log/mysql.log old_passwords=0 The server runs on CentOS release 4.5 (Final). Any assistance to rectifying this will be greatly appreciated. Ed -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Access denied for GRANT using root yet manual user insertion is fine

This works without a problem! Contents of the my.cnf: # cat /etc/my.cnf [mysqld] set-variable = max_connections=500 safe-show-database log=/var/log/mysql.log old_passwords=0 The server runs on CentOS release 4.5 (Final). Any assistance to rectifying this will be greatly appreciated. Ed -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

What's up with 5.1x beta

Does anyone have an explanation as to why it's taking so long for an official release of version 5.1? Is it me or does it seem like 5.1 is taking a lot longer to be released. I don't remember previous versions having 20 beta revs before an official release. Is there a real date available for an

Re: Insert Select query problem

JOIN (SELECT Item, SUM(Qty) AS TotQty FROM inventory GROUP BY Item) AS totals ON r.Required = totals.Item WHERE r.Qty > totals.TotQty; >>> On 8/10/07 at 12:33 PM, in message <[EMAIL PROTECTED]>, Jay Pipes <[EMAIL >>> PROTECTED]> wrote:

Insert Select query problem

Hi All, I have an issue that I need to resolve that is difficult to explain. I hope that someone can understand what I*m trying to do and shed some light on a solution. Here goes. I have three tables, inventory, which is a list of transactions with positive and negative values; request, which e

RE: database cache /

Thanks for the leads. I'll double check my indices and check out the following links. > http://dev.mysql.com/doc/refman/5.0/en/server-parameters.html > http://dev.mysql.com/doc/refman/5.0/en/innodb-tuning.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To u

database cache /

speed up. Does this sound right? Is there a way to keep the table in memory? Nothing is changing in the data. Thanks, -Ed -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: select statement with variable for table_reference?

select will very likely have more than one record in the result set. Is there a way to loop through the results to concatenate everything into the set of UNIONS? Ed > > May you want sometimes to search only in fewer tables that you know before > making the query? If yes, then you can cr

RE: select statement with variable for table_reference?

Implementation Group > Virginia Tech Information Technology > 1700 Pratt Drive > Blacksburg, VA 24060 > > Email: [EMAIL PROTECTED] > Phone: (540) 231-4396 > > -Original Message- > From: Ed Lazor [mailto:[EMAIL PROTECTED] > Sent: Tuesday, June 26, 2007 4:37 PM

RE: select statement with variable for table_reference?

Thanks for the info Jerry. =) > -Original Message- > From: Jerry Schwartz [mailto:[EMAIL PROTECTED] > Sent: Tuesday, June 26, 2007 1:59 PM > To: 'Ed Lazor'; 'Octavian Rasnita'; mysql@lists.mysql.com > Subject: RE: select statement with variable for ta

RE: select statement with variable for table_reference?

has something in there or not. Improving on this idea would be finding a way to just query the relevant tables... some sort of conditional union. Any ideas? -Ed > -Original Message- > From: Octavian Rasnita [mailto:[EMAIL PROTECTED] > Sent: Tuesday, June 26, 2007 1:02 PM > To: E

select statement with variable for table_reference?

th id, name That allows me to get the actual name of the database or table. And that leads me why I'm trying to find another way to handle the table_reference. I figure there's a way to specify the value of one table's field as the name of the table when doing a join or something. A

Outer Join with Criteria

E UserId = 10 AND EventID = {$r1['EventTypeID']}"); // ... } This performs with N+1 queries, and I'm sure there is a way to do it with only 1. Thanks for any help. --Ed -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Help with Query

1 and Company 2. I can find out how many records Joe Blow has or list out each Company record grouped by Name but I only want Names with multiple entries shown. Can anyone help? I'm sure this also makes a difference but I'm stuck using MySQL 3.23. Thanks, Ed -- MySQL General Maili

Re: binary into blob

he db as proposed earlier using paths and file names to find the pdf, but I might read the article posted by 'colbey' and give it a go for technical curiosity. Thank you all again for your responses. -Ed -- MySQL General Mailing List For list archives: http://lists.mysql.com/my

Re: binary into blob

mages or any other common binary > format is generally not a good idea. > > Alec Thank you all for your help. I get the gist of things... don't store the binnary, store the path to it and details of it. Thank you all for your quick response. -Ed -- MySQL General Mail

Re: binary into blob

lain what you mean by metadata and how you would do it? Thanks -Ed -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: binary into blob

On Wednesday 07 March 2007 19:28, Jay Pipes wrote: > Ed wrote: > > I guess a pdf file is a binnary file and it will contain characters that > > will mess things up, so my question is: > > Hi, sorry for the late answer. The reason, until I come up with a better one, is

binary into blob

s all, -Ed -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

INSERT IGNORE BUG?

ver. 5.0.27 on Linux. -- Ed Pauley II [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: General MySQL Question: Ed Reed (CA, United States ofAmerica) Medium

ad System Admin -- Senior Programmer http://www.eeinternet.com ( http://www.eeinternet.com/ ) PGP Key: http://pgp.mit.edu/ ID 0xDB26D7CE PO Box 80086 -- Fairbanks, AK 99708 -- Ph: 907-456-5581 Fax: 907-456-3111 >>> "Ed Reed" <[EMAIL PROTECTED]> 1/29/07 1:57 PM >>> I just

Re: General MySQL Question: Ed Reed (CA, United States of America) Medium

place to go and I don't wanna go back. I'd just like to see it held someplace new every year. Thanks for replying to my comment >>> Lenz Grimmer <[EMAIL PROTECTED]> 1/25/07 2:21 AM >>> -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Ed, thank you for you

Re: New DBManager Released

----- Original Message - From: "Ed Reed" <[EMAIL PROTECTED]> To: "MySQL List" ; "PostgreSQL Announce List" ; "SQlite Users Group" ; "Firebird Tools" <[EMAIL PROTECTED]> Sent: Tuesday, January 23, 2007 3:20 PM Subject: Re: New DBManager

Re: New DBManager Released

The free version is crippled. You don't get all the capabilities they say. >>> "COS" <[EMAIL PROTECTED]> 1/23/07 8:16 AM >>> Hi, DBTools Software is proud to announce the availability of the new DBManager Professional Enterprise Edition 3.4.2 and DBManager Standard Edition 3.2.2. For a complete

Re: MySQL Administrator problem

w will accept any correct password combination under ShadowHash or other authorising protocol, but you will still be working in the account you are in with those privileges. HTH Daniel Culver [EMAIL PROTECTED] On Jan 17, 2007, at 4:49 PM, Ed Reed wrote: > Unable to manage user accounts throug

Re: MySQL Administrator problem

I don't have any way of selecting a host. I only have one host on my system and I don't see anything in the program that explicitly shows me where to select the host. >>> Igor Alexandrov <[EMAIL PROTECTED]> 1/17/07 9:30 PM >>> -BEGIN PGP SIGNED MESS

Re: MySQL Administrator problem

There was already a bug report submitted. That's where I found other users that have the same problem. >>> Colin Charles <[EMAIL PROTECTED]> 1/17/07 6:05 PM >>> Ed Reed wrote: > Unable to manage user accounts through MySQL Administrator 1.2.8. I've found

MySQL Administrator problem

Unable to manage user accounts through MySQL Administrator 1.2.8. I've found that I'm not the only one with this problem but no one seems to have an answer for it. The problem is that when you select a user in the user list of the prog the user's detail don't appear on the right side so that t

Re: Insert ... Select troubles

The first to generate you sequence, then second to populate the main table. - Original Message - From: "Ed Reed" <[EMAIL PROTECTED]> To: Sent: Friday, January 12, 2007 8:22 PM Subject: Re: Insert ... Select troubles Thanks for the suggestion Brent. The auto_increment won&#

Re: Insert ... Select troubles

auto increment sequence to be made for each record "group". - Original Message - From: "Ed Reed" <[EMAIL PROTECTED]> To: Sent: Friday, January 12, 2007 12:42 PM Subject: Re: Insert ... Select troubles > ItemCount is essentially a counter of the records fr

Re: Insert ... Select troubles

ykman" <[EMAIL PROTECTED]> 1/12/07 8:13 AM >>> On 1/11/07, Ed Reed <[EMAIL PROTECTED]> wrote: > > I need some help creating an INSERT * SELECT statement that supplies a record counter in the returned items. Here's the task, > > I have t1 and t2. t1 is GroupCount

Insert ... Select troubles

I need some help creating an INSERT * SELECT statement that supplies a record counter in the returned items. Here's the task, I have t1 and t2. t1 is GroupCount, ItemCount, Field1, Field2, Field3. t2 is Field1, Field2, Field3. t1 has a multiple field unique key called Request that has Group

Re: On Duplicate Key Update question

Sorry for the premature question. I think I figured it out. On Duplicate Key Update Qty=Qty+Values(Qty); I haven't tested it yet but it makes sense that it'll work. >>> "Ed Reed" <[EMAIL PROTECTED]> 1/5/07 2:40 PM >>> I use On Duplicate Key

On Duplicate Key Update question

I use On Duplicate Key Update a lot and I usually use it like this, Insert Into tablename (myID, Qty) Values (1034,15), (6,13), (5001,1), (145,20) On Duplicate Key Update Qty=Values(Qty); This works very well but now I'd like to do something a little different. I'd like to have a query like this

Re: Replication Problem? - SOLVED

://dev.mysql.com/doc/refman/5.0/en/binary-log.html -Ed Logan, David (SST - Adelaide) wrote: Hi Ed, You may like to look at this, especially the last statement. If you are not using these options however, I would suspect a bug. Regards --replicate-do-db=db_name Tell the slave to restrict replication

Re: Replication Problem? - SOLVED

://dev.mysql.com/doc/refman/5.0/en/binary-log.html -Ed Logan, David (SST - Adelaide) wrote: Hi Ed, You may like to look at this, especially the last statement. If you are not using these options however, I would suspect a bug. Regards --replicate-do-db=db_name Tell the slave to restrict replication

Netware 5.1 beta binaries

Can someone tell me what happen to the MySQL 5.1.x-beta for Netware binaries? They aren't in the downloads page anymore. Thanks

Replication Problem?

('test','1')" the query replicates. Is this normal behavior? Is there a configuration setting that I can change to make replication accept explicit database naming in the query? Any help would be greatly appreciated! -- Ed Pauley II [EMAIL PROTECTED] -- MySQL General

Re: Number extraction from a string

Is there anyway to use RegExp in a field parameter? What would be great is if I could do this, SELECT Trim(Both RegExp '[a-z]' From value) as value_num, value FROM num_test WHERE value REGEXP 'N[1-999]'; The biggest problem is trying to find the position of where the number starts in the string

Re: Number extraction from a string

:11 PM >>> On Thursday 07 December 2006 14:57, Ed Reed wrote: > Can someone help me with this? quick hack, but it works from what you've stated: mysql> create table num_test (id SERIAL PRIMARY KEY, value VARCHAR(256)); Query OK, 0 rows affected (0.07 sec) mysql> insert int

Number extraction from a string

Can someone help me with this? I have a text field that sometimes contains a number preceded with the letter N. So it might look like this A test N60 or N45 someother text or This happened. N122, Then there was this. I need to come up with a Select statement that can show me all the

Re: character set for French... confused :\

On Thursday 07 December 2006 10:09, Ed wrote: > Hi all, > I need a database that is able to handle french characters. Sorry about that, it's probably due to my OS rather than MySQL. $ echo "Fête" Fête $ touch Fête $ ls -l -rw-r--r-- 1 me me 0 Dec 7 14:20 F?

character set for French... confused :\

LL, c11 TEXTCHARACTER SET latin1 COLLATE latin1_general_ci ); When I insert "'Récré, Vive La Fête!" the best I get is "R?cr?, Vive La F?te!" from "c11". Can anyone advise me on what I need done to get these accents show up? Pointers to more documentation

Create stored procedures with Query Browser

Can someone tell me if it is possible to create stored procedures with Query Browser and if it is can you provide an example the works? Thanks

Re: Stored procedure parameters problem

s <[EMAIL PROTECTED]> 12/2/06 10:38 AM >>> At 11:34 AM -0800 12/1/06, Chris White wrote: >On Friday 01 December 2006 11:22, Ed Reed wrote: >> I have a problem/question I'd like to find someone else to verify/answer >> for me. >> >> I'm using

Re: Stored procedure parameters problem

Got it. Thanks >>> Chris White <[EMAIL PROTECTED]> 12/1/06 11:34 AM >>> On Friday 01 December 2006 11:22, Ed Reed wrote: > I have a problem/question I'd like to find someone else to verify/answer > for me. > > I'm using MySQL 5.1.09 running on Netwa

Stored procedure parameters problem

I have a problem/question I'd like to find someone else to verify/answer for me. I'm using MySQL 5.1.09 running on Netware. I've created a stored procedure that has one parameter, Create Procedure MyTest(strVal VarChar) Begin Select Field1, Field2, Field3 From MyTable Where Field3=strVal; En

Re: date_add function

On Wed, 11 Oct 2006, Rolando Edwards wrote: > Oops, also the $this_date > > UPDATE this_table SET > this_date = '$this_date', > future_date = DATE_ADD('$this_date',INTERVAL 90 DAY); Got it going guys, thanks again Ed -- MySQL General Mailing List For li

Re: date_add function

On Wed, 11 Oct 2006, Rolando Edwards wrote: > Please check your syntax. > It should look like this: > > UPDATE this_table SET > this_date = $this_date, > future_date = DATE_ADD($this_date,INTERVAL 90 DAY); > > Don't forget your WHERE clause or else you populate every row. Tried it, this is what

Re: date_add function

On Wed, 11 Oct 2006, Mark Leith wrote: > Ed Curtis wrote: > > I'm having some trouble setting a future date within a table. I have one > > column 'this_date' which is a DATE field and I'm trying to add 90 days to > > it and set a column named 'fu

date_add function

g to write the value into the 'this_date' and 'future_date' fields in the same query. UPDATE this_table SET this_date = $this_date, future_date = (DATE_ADD(this_date) INTERVAL 90 DAY) Would this work? Thanks, Ed -- MySQL General Mailing List For list archives: http://lis

Help with query

s that the query is returning every record in the table. I only want it to return the records where the keywords (any combination) are contained within 'keyphrase' Any ideas? Thanks, Ed -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

More than 4 CPUs?

It seems like I once read that you don't get any performance gains in MySQL when you go above 4 CPUs per server. Is this correct? I was considering a 4 dual-core CPU machine. Should I go with a 2 dual-core machine instead? Thanks! -- Ed Pauley II -- MySQL General Mailing List For

Re: MySQL Load Balancing

Renato Golin wrote: Ed Pauley II wrote: Continuent's m/cluster will not work for me as it does not allow replication across a WAN. Yeah, known problem... We have an offsite backup that needs to be in the replication (2-way to make switching back and forth easy) chain. Why do you n

Re: MySQL Load Balancing

Peter Zaitsev wrote: On Fri, 2006-08-04 at 15:54 -0400, Ed Pauley II wrote: I am looking into a scale-out solution for MySQL. I have read white papers and searched the web but I can't find a load balancer that claims to work well for MySQL. MySQL's white paper shows NetScaler in

MySQL Load Balancing

yote Point Equalizers. I have thought about LVS. Has anyone had any experience with load balancing MySQL? Any recommendations? Thanks in advance. -Ed -- Ed Pauley II [EMAIL PROTECTED] http://www.brisnet.com http://www.brisbet.com -- MySQL General Mailing List For list archives: http://lists.mysql.co

Re: Show tables replacement

ea on this? >>> "Jochem van Dieten" <[EMAIL PROTECTED]> 7/6/06 9:47:26 AM >>> On 7/6/06, Ed Reed < [EMAIL PROTECTED] > wrote: > Anyone have an idea on this? Upgrade. Or at least stop repeating the question. Jochem -- MySQL General Mailing List For list archive

Re: Show tables replacement

Anyone have an idea on this? Thanks >>> "Ed Reed" <[EMAIL PROTECTED]> 7/5/06 1:54:25 PM >>> Anyone have an idea on this? Thanks >>> "Ed Reed" < [EMAIL PROTECTED] > 6/30/06 2:51:44 PM >>> Opps! Thanks for the quick repl

Re: Show tables replacement

Anyone have an idea on this? Thanks >>> "Ed Reed" <[EMAIL PROTECTED]> 6/30/06 2:51:44 PM >>> Opps! Thanks for the quick reply, Dan. But I forgot to mention I'm running MySQL 4.1.11 Any other suggestions? Thanks again. >>> Dan Nelson < [EM

Re: Show tables replacement

Opps! Thanks for the quick reply, Dan. But I forgot to mention I'm running MySQL 4.1.11 Any other suggestions? Thanks again. >>> Dan Nelson <[EMAIL PROTECTED]> 6/30/06 2:48:57 PM >>> In the last episode (Jun 30), Ed Reed said: > Is there a Select statement

Show tables replacement

Is there a Select statement I can use to get table names so that I could use other Select statement syntax on the results? What I'd like to do is this, SHOW Replace(TABLES, 'tbl','') Like 'tbl%'; But this doesn't work so I need a Select statement that can do the same thing. Thanks in adva

Replacing A Value

I have a column in a table I need to replace a value of certain records in. The current value is /realtors/Value/. I need to change them to /realtors/This_Value/. Is there an easy way to do this. There are way too many records to do it one record at a time. Thanks, Ed -- MySQL General

RE: Return virtual records

once. - Thanks again >>> Shawn Green <[EMAIL PROTECTED]> 4/12/06 12:15:56 PM >>> --- Ed Reed < [EMAIL PROTECTED] > wrote: > Thanks for the response but neither one of the responses I've > received does exactly what I need since they don't return multip

Re: [Fwd: Re: mysqldumps from java program]

Daniel da Veiga wrote: On 4/19/06, Ed Pauley II <[EMAIL PROTECTED]> wrote: out of curiosity, how do you do that? Daniel da Veiga wrote: If I am not mistaken deleting from the production server would delete the data on the slave in a replication environment. Don&#x

Re: [Fwd: Re: mysqldumps from java program]

- RS - Brazil -BEGIN GEEK CODE BLOCK- Version: 3.1 GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V- PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++ --END GEEK CODE BLOCK-- -- Ed Pauley II Internet Software Developer Bloodstock Research

[Fwd: Re: mysqldumps from java program]

-- Ed Pauley II Internet Software Developer Bloodstock Research Information Services 859.223. 800.354.9206 ext. 297 [EMAIL PROTECTED] http://www.brisnet.com http://www.brisbet.com --- Begin Message --- If I am not mistaken deleting from the production server would delete the data on the

Re: Multi Threaded on RedHat ES 4

I think this article explains what I am seeing but I don't know how to determine which threading I am using. I just know it is not user threads in a separate process. http://dev.mysql.com/doc/refman/4.1/en/thread-packages.html Ed Pauley II wrote: I recently changed from SuSE ES 8 to R

Multi Threaded on RedHat ES 4

for a very busy website. Did I miss a compile option? Is this an OS thing? I am putting this thing live and we have a couple of very busy weekends coming up. Any help would be appreciated. Thanks in adv! Ed -- Ed Pauley II Internet Software Developer Bloodstock Research Information Services

RE: Return virtual records

Thanks for the response but neither one of the responses I've received does exactly what I need since they don't return multiple rows. Are there any other ideas out there? Thanks >>> "Jay Blanchard" <[EMAIL PROTECTED]> 4/7/06 12:37:32 PM >>> [snip] Anyone have an idea on this? Can anyone exp

Re: Return virtual records

Anyone have an idea on this? Can anyone explain how I might be able to return a numbers of records based on the sum of a quantity in a field in the same table? (After I read that it sounds even confusing to me). Let me explain. I have records like this, Part#Qty 1254

Return virtual records

Can anyone explain how I might be able to return a numbers of records based on the sum of a quantity in a field in the same table? (After I read that it sounds even confusing to me). Let me explain. I have records like this, Part#Qty 1254 5 1414

Re: very long query for such a simple result

gt;> Peter Brawley <[EMAIL PROTECTED]> 4/5/06 10:28 AM >>> Hi Ed, Count(1) works just as well. Sum(1) just adds 1 for each row so it's logically equivalent. PB - Ed Reed wrote: WOW!!! THAT WAS AWESOME!!! Thanks a lot Peter. Ok, so what is SUM(1)? How is it able to do

Re: very long query for such a simple result

WOW!!! THAT WAS AWESOME!!! Thanks a lot Peter. Ok, so what is SUM(1)? How is it able to do this? And where can I learn more about it? Thanks again. >>> Peter Brawley <[EMAIL PROTECTED]> 4/4/06 10:13:00 PM >>> Ed,e: Thanks for the quick reply Peter. Unfortunately,

Re: very long query for such a simple result

. I'm currently using MySQL 4.1x but most importantly I must be able to run the entire query in a single call. Thanks for the help. >>> Peter Brawley <[EMAIL PROTECTED]> 4/4/06 2:35:49 PM >>> Ed, The big slowdown in your query is likely the join on Proble

Re: very long query for such a simple result

Sorry, here's the results. BTW the query works it just seems overly complex and I'd like to streamline it. CREATE TABLE `employees` ( `EmployeeID` int(11) NOT NULL auto_increment, `FirstName` varchar(50) default NULL, `LastName` varchar(50) default NULL, `DateTerminated` datetime default

very long query for such a simple result

Can someone help me simplify this query please? It's meant to return a single string result that looks something like this, "You have 12 open Problem Reports: Priorities(High=5, Med=6, Low=1)" The relavent columns from the two tables are Table: ProblemReports Fields: PRNo, Status, Priority,

Re: Migration toolkit

le to say. mysql> source full_path_to_oldgrants.sql and do one last FLUSH PRIVILEGES; Your old accounts should now exist on your new server with their old permissions restored. Sorry but you asked for "any" ideas... ;-) Shawn Green Database Administrator Unimin Corporati

Re: Migration toolkit

Does anyone have any idea on this one? - Thanks >>> "Ed Reed" <[EMAIL PROTECTED]> 2/10/06 3:09 PM >>> I'm trying to use the Migration Toolkit to migrate a 4.1 system to a 5.0 system. It doesn't appear that it can successfully migrate my usernames a

Migration toolkit

I'm trying to use the Migration Toolkit to migrate a 4.1 system to a 5.0 system. It doesn't appear that it can successfully migrate my usernames and privileges. Is it supposed to be able to and is there anything special I need to do to make it happen? - Thanks

Re: Database design help

I built my inventory system like this, I have a products table that contains all the information specific to each part, less the quantity, i.e. Part Number, Description, Vendor, Color, Weight, SKU number, etc... Then I have another table that is my Inventory Tranactions Log that is just the

  1   2   3   4   5   6   >