Re: Web Farm Design

ing facts about the problem leads to a better solution. Hope this helps. Eldon Ziegler Atlantic Database Systems, Inc. www.atlanticdb.com At 10:20 am 4/8/2006, Elias wrote: We are currently building a webfarm to replace our all in one box solution. We are experiencing problems when we get l

Peer to Peer Replication?

efore. How can peer to peer replication be done? Eldon Ziegler -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RPM install fails

install to work? Thanks Eldon Ziegler -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Generating ticket/file numbers

. Then select "AUD_", SeqItem from the table. However, only one field can be auto_increment. Eldon Ziegler MySQL Database Systems and Support www.atlanticdb.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Barcode

A description of bar codes can be found at http://electronics.howstuffworks.com/upc.htm/printable At 05:36 am 2/5/2005, you wrote: Hello mysql, Scanned Barcodes I will be scanning barcodes and putting them into a innoDb table Does anybbody have knowledge re: the best columnType, length or

Re: MySQL/PHP Tunneling

Karam, A much more secure way is to use OpenSSH (www.openssh.org) to create an encrypted connection between the local machine and the MySQL server and to use the -L option to forward MySQL commands from the localhost to the MySQL server. For example, ssh -l -L 3306::3306 Once the ssh connect

Re: Do I specify a primary key to be primary, unique and index ?

From the MySQL documentation: * A PRIMARY KEY is a unique KEY where all key columns must be defined as NOT NULL. KEY is a synonym for INDEX. So, specifying PRIMARY KEY implies UNIQUE and INDEX.. You don't have to specify them yourself. At 01:11 am 4/11/2004, you wrote: I learned that there ar

How to select and set enum by string value

I've been unable to select or set an enum field by using the string values. Numeric values work correctly. SHOW CREATE TABLE gives the following: CREATE TABLE `Organizations` ( `OrgID` int(11) NOT NULL auto_increment, `Organization` varchar(50) NOT NULL default '', `

Re: Wish List of Features

e and to move fields around to make the structure make sense for sometime down the road when I try to remember what I did. It's handy when first creating a table. I haven't released it but if someone wants to take a look, let me know. Eldon Ziegler At 10:38 am 3/16/2004, you wrot

Re: firewall ports to open

s 3306 and 3307, but that sounded kind of weird to me. Thanks Steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] Eldon Ziegler President ProAtion Systems, Inc. www.proation.com -- MySQL General Mailing Lis

RE: MIN with negative numbers in VARCHAR

this will work) do a min(cast(Value * 100 as signed integer) / 100 2- or min(Value + 0.0) and see what happens. > -----Original Message- > From: Eldon Ziegler [mailto:[EMAIL PROTECTED] > Sent: Tuesday, January 13, 2004 11:24 AM > To: [EMAIL PROTECTED] > Subject: RE: MIN

RE: MIN with negative numbers in VARCHAR

DOUBLE doesn't seem to be an option with CAST At 10:31 am 1/13/2004, you wrote: Could you CAST them first, then apply MIN? > -Original Message- > From: Eldon Ziegler [mailto:[EMAIL PROTECTED] > Sent: Tuesday, January 13, 2004 9:56 AM > To: [EMAIL PROTECTED] > Subjec

MIN with negative numbers in VARCHAR

We have a table with floating point measurement values stored in VARCHAR's. How can I get MIN in SELECT to evaluate these as numbers instead of strings so negative value sort correctly? Right now I've kludged it as MIN(SIGN(Value) * ABS(Value)). Is there a more straight forward way? -- MySQL Ge

MySQL and Crystal Reports?

Has anyone used Crystal Reports successfully with MySQL? I tried the ODBC driver but it was rejected with a message that the "Professional" version was needed. Eldon Ziegler Atlantic Software, Inc. [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql

RE: password not working from command line

esses running now: 1 mysqld process hanging, pid 843 - killed 030402 09:02:24 mysqld restarted Is this distribution any good? Eldon Ziegler President ProAtion Systems, Inc. www.proation.comlocalhost rootY Y Y Y Y Y Y Y Y Y

password not working from command line

The password I entered in a GRANT statement isn't being accepted from the command line after entering mysql -u username -p and then entering the password from the GRANT statement. Is there something else I need to do? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Updating a column from a second table

Table2.PersonPhone = Table1.DonorPhone. Does UPDATE do this? Eldon Ziegler ProAtion Systems, Inc. [EMAIL PROTECTED] http://www.proation.com - Before posting, please check: http://www.mysql.com/manual.php (the manual

Select slow with ORDER BY ... DESC

ibute) "Explain" shows the query using the DateTime index instead of the dtSrcTarAttr that contains all items in the WHERE clause. How can I speed up this query? Eldon Ziegler ProAtion Systems, Inc. www.proation.com --

Select results to new table?

Is there a way to put the results of a SELECT into a table without going through an export file? For example, something like SELECT * FROM table_1 WHERE condition INTO table_2 Eldon Ziegler ProAtion Systems [EMAIL PROTECTED] http://www.proation.com

SELECT to get last entry

I have a table that includes a device ID (indexed) and the name of the device with multiple records ordered over time. How can I retrieve the last record for each device ID without retrieving them all to find the most recent name? Eldon Ziegler ProAtion Systems [EMAIL PROTECTED] http

Problem installing mysql++1.7.9

Running ./configure fails check for MySQL include directory. The library directory is found and the include directory is there when I list it. What is it looking for? Eldon Ziegler ProAtion Systems [EMAIL PROTECTED] http://www.proation.com