Re: [MySQL] Re: Decimal points

On 7/20/2010 10:07 AM, Chris W wrote: I try to avoid asking why but in this case I have to. I can't imagine wanting to have a list of numbers displayed and not have them all aligned right with the sane number of digits after the decimal point. So why would you even want to do this is?

Re: [MySQL] Re: MySQL select matching

On 7/19/2010 11:08 AM, Shawn Green (MySQL) wrote: Just because someone hands you a set of data to *start* with, does not mean that you must only use that data to *work* with. You should be able create additional tables derived from the original data and work with those as part of your analysis

Re: [MySQL] Re: MySQL select matching

On 7/19/2010 10:48 AM, Michael Dykman wrote: Not quite sure what the question is. from: mysql> select * from table where id='1'; +---+-+-+---+ | 1 | 123 | 0.0 | C | | 1 | 234 | 0.1 | D | | 1 | 345 | 0.0 | D | | 1 | 456 | 0.1 | C | | 1 | 567 | 0.1 | G | +

MySQL select matching

I may be going at this completely wrong but at the moment I'm stuck. I have a DB from a client and need to do several searches on it. This one sentence is important because it's their DB, not mine. So I can't modify the way the DB was created in the first place, I can only work with wh

Decimal points

mysql> select 1+1.0; +---+ | 1+1.0 | +---+ | 2.0 | +---+ 1 row in set (0.00 sec) mysql> select 1+1.1; +---+ | 1+1.1 | +---+ | 2.1 | +---+ 1 row in set (0.00 sec) Is there a way to tell MySql to only return '2' in the first select as opposed to

RE: [MySQL] Re: Variables in stored procedures

Huh? That doesn't make a whole lot of sense. If that is the case, can you explain why? Is the stored procedure mechanism that primitive? From: Ted Yu [mailto:yuzhih...@gmail.com] Sent: Saturday, May 01, 2010 7:11 AM To: Ashley M. Kirchner Subject: Re: [MySQL] Re: Variables in s

RE: [MySQL] Re: Variables in stored procedures

> -Original Message- > From: Shawn Green [mailto:shawn.l.gr...@oracle.com] > Sent: Friday, April 30, 2010 9:49 PM > To: Ashley M. Kirchner > Cc: mysql@lists.mysql.com > Subject: [MySQL] Re: Variables in stored procedures > > Two options > > 1) u

Variables in stored procedures

I have the following procedure: -- CREATE PROCEDURE `geodistance`(IN userid int, IN maxdist int) begin declare userlng double; declare userlat double; declare lng1 float; declare lng2 float; declare lat1 float; declare lat2 float; select lng, lat into userlng, userla

Re: [MySQL] Re: Image Store @ My SQL

There are many ways to skin this cat ... -- H | It's not a bug - it's an undocumented feature. +-------- Ashley M. Kirchner <mailto:ash...@pcraft.com> . 303.442.6410 x130 IT Director / SysAdmin

Help with SELECT clause

I'm stuck again ... and perhaps it's just not designed right, but I inherited this setup, so if anyone has suggestions on how to make it better, I'm all ears. This is all one table ... describe approvals; +---+--+--+-+-++ | Field

Selecting data from multiple tables

Hi folks, I'm trying to, possibly do the impossible here. I have to select data from 4 different tables to come up with the right information and I'm having one heck of time trying to figure it out. This is going to be a long email ... Table_1: +---+--+--+---

Re: [MySQL] Re: REPOST: ON DUPLICATE failure

Michael Dykman wrote: It worked fine as you wrote it on my v5.0.45, although it reported 2 rows affected on each subsequent run of the insert statement. I thought this odd as I only ran the same statement repeatedly leaving me with one row ever, but the value updated just fine. I noticed

REPOST: ON DUPLICATE failure

Anyone? I'm trying to diagnose this and not having much luck. I can't even figure out where to even begin to look. I have two MySQL servers and getting different results for the same query on both: SERVER 1: mysqladmin Ver 8.41 Distrib 5.0.37, for pc-linux-gnu on i686 S

ON DUPLICATE failure

I'm trying to diagnose this and not having much luck. I can't even figure out where to even begin to look. I have two MySQL servers and getting different results for the same query on both: SERVER 1: mysqladmin Ver 8.41 Distrib 5.0.37, for pc-linux-gnu on i686 SERVER 2:

Restarting/Rebuilding Slave

undocumented feature. +-------- Ashley M. Kirchner <mailto:[EMAIL PROTECTED]> . 303.442.6410 x130 IT Director / SysAdmin / Websmith . 800.441.3873 x130 Photo Craft Imaging . 3550 Arapahoe Ave. #6 http://www.pcraft.com . . .

Re: [MySQL] remove me from this list please

[EMAIL PROTECTED] wrote: Please remove me from this list or tell me how I can do this procedure... Thanks... Have you noticed what the footer of each message says? MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.my

Padding result

's an undocumented feature. +---- Ashley M. Kirchner <mailto:[EMAIL PROTECTED]> . 303.442.6410 x130 IT Director / SysAdmin / Websmith . 800.441.3873 x130 Photo Craft Imaging . 3

Bin logs...

I have a query that's failing and I can't figure it, I can't read the log file. Suggestions anyone? -- W | It's not a bug - it's an undocumented feature. +-------- Ashley M. Kirchner <mailto:[EMAIL PROTE

Re: [MySQL] Re: Can't Bind to Port

x27;s an undocumented feature. +-------- Ashley M. Kirchner <mailto:[EMAIL PROTECTED]> . 303.442.6410 x130 IT Director / SysAdmin / Websmith . 800.441.3873 x130 Photo Craft Imaging . 3550 Arap

Selecting avg()...

This is a continuation of something I started with a few weeks ago. So, here's the previous information again: table: data ++---+--+-+---++ | Field | Type | Null | Key | Default | Ex

Re: [MySQL] Re: Filling blanks on SELECT

(or NULL) or not. The graphing program will do the rest. -- W | It's not a bug - it's an undocumented feature. +-------- Ashley M. Kirchner <mailto:[EMAIL PROTECTED]> . 303.442.6410 x130 IT Director / SysAdmin / W

Re: [MySQL] Re: Filling blanks on SELECT

undocumented feature. +-------- Ashley M. Kirchner <mailto:[EMAIL PROTECTED]> . 303.442.6410 x130 IT Director / SysAdmin / Websmith . 800.441.3873 x130 Photo Craft Imaging . 3550 Arapahoe Ave.

Filling blanks on SELECT

-- W | It's not a bug - it's an undocumented feature. +------------ Ashley M. Kirchner <mailto:[EMAIL PROTECTED]> . 303.442.6410 x130 IT Director / SysAdmin / Websmith . 800.441.3873 x130 Photo Craft Imaging . 3550 Arapahoe A

Re: [MySQL] Re: Question on SELECT

Chris Comparini wrote: Try something like this: select hour(time) as the_hour, avg(temp_f) as average_temp_f from data where time > now() - interval 24 hour group by the_hour; Thanks Chris. Question though, why is it that when I change that to 48 hours, it only gives me 24 results (s

Question on SELECT

Hi All, I have a table that's described as follows: ++---+--+-+---++ | Field | Type | Null | Key | Default | Extra | ++---+--+-+-

www/dev.mysql.com?

Anyone else having trouble getting to either sites? -- W | It's not a bug - it's an undocumented feature. +---- Ashley M. Kirchner <mailto:[EMAIL PROTECTED]> . 303.442.6410 x130 IT Director / Sys

Re: [MySQL] Testing

Mike Blezien wrote: is the list still working ? Would you believe me if I said, "No."? -- W | It's not a bug - it's an undocumented feature. +-------- Ashley M. Kirchner <mailto:[EMAIL PROTECTED]>

Re:Backing up live MySQL Databases

n doing a dump of the data? (Note the difference, one will copy files, the other dumps the data for backup.) -- W | I haven't lost my mind; it's backed up on tape somewhere. +-------- Ashley M. Kirchner. 303.442.64

Re: [MySQL] mysql/snort/webmin/permissions

up on tape somewhere. +-------- Ashley M. Kirchner <mailto:[EMAIL PROTECTED]> . 303.442.6410 x130 IT Director / SysAdmin / WebSmith . 800.441.3873 x130 Photo Craft Imaging . 3550 Arapahoe Ave.

Re: [MySQL] Re: Reversing DESC|ASC

uot; of the newer version. -- H | I haven't lost my mind; it's backed up on tape somewhere. +------------ Ashley M. Kirchner <mailto:[EMAIL PROTECTED]> . 303.442.6410 x130 IT Director / SysAdmin / WebSmith .

Re: [MySQL] Re: Reversing DESC|ASC

mind; it's backed up on tape somewhere. +------------ Ashley M. Kirchner <mailto:[EMAIL PROTECTED]> . 303.442.6410 x130 IT Director / SysAdmin / WebSmith . 800.441.3873 x130 Photo Craft Imaging .

Reversing DESC|ASC

ven't lost my mind; it's backed up on tape somewhere. +------------ Ashley M. Kirchner <mailto:[EMAIL PROTECTED]> . 303.442.6410 x130 IT Director / SysAdmin / WebSmith . 800.441.3

Re: [MySQL] Duplicate selection with change

aven't lost my mind; it's backed up on tape somewhere. +------------ Ashley M. Kirchner <mailto:[EMAIL PROTECTED]> . 303.442.6410 x130 IT Director / SysAdmin / WebSmith . 800.441.3873 x130 Photo Craft Laboratorie

Re: [MySQL] Can't start server: Bind on TCP/IP port: Address already in use

I haven't lost my mind; it's backed up on tape somewhere. +-------- Ashley M. Kirchner <mailto:[EMAIL PROTECTED]> . 303.442.6410 x130 IT Director / SysAdmin / WebSmith . 800.441.3873 x130 Pho

Re: [MySQL] Re: Stop Scrolling

;t lost my mind; it's backed up on tape somewhere. +-------- Ashley M. Kirchner <mailto:[EMAIL PROTECTED]> . 303.442.6410 x130 IT Director / SysAdmin / WebSmith . 800.441.3873 x130 Photo Craft Laboratories,

Select on datetime

So, if today being 2004-05-16, -> I want to select all entries dated 2003-05-16 -> And I also want entries dated between 2003-05-16 and 2003-05-23 -- H| I haven't lost my mind; it's backed up on tape somewhere. +------

Re: [MySQL] RE: Question: Connecting MySQL with DreamWeaver MX on Windows 2000

d; it's backed up on tape somewhere. +-------- Ashley M. Kirchner <mailto:[EMAIL PROTECTED]> . 303.442.6410 x130 IT Director / SysAdmin / WebSmith . 800.441.3873 x130 Photo Craft Laboratories, Inc..

Re: [MySQL] RE: Question: Connecting MySQL with DreamWeaver MX on Windows 2000

contents, you would've quickly found out which sections specifically you needed to read - it's very short and can be done within 10 minutes. -- H| I haven't lost my mind; it's backed up on tape somewhere. +-------

Re: [MySQL] RE: Question: Connecting MySQL with DreamWeaver MX on Windows 2000

;s backed up on tape somewhere. +-------- Ashley M. Kirchner <mailto:[EMAIL PROTECTED]> . 303.442.6410 x130 IT Director / SysAdmin / WebSmith . 800.441.3873 x130 Photo Craft Laboratories, Inc.. 3550 Arapahoe Ave. #6 http://www.pcraft.com . . .. Boul

Re: [MySQL] RE: Question: Connecting MySQL with DreamWeaver MX on Windows 2000

#x27;s backed up on tape somewhere. +-------- Ashley M. Kirchner <mailto:[EMAIL PROTECTED]> . 303.442.6410 x130 IT Director / SysAdmin / WebSmith . 800.441.3873 x130 Photo Craft Laboratories, Inc.. 3550 Arapahoe Ave. #6 http://www.pcraft.com . . ..

Re: [MySQL] What terminates a query?

o your sql result (say ##END##) and have the perl program check for that string. Once found, it knows the sql command has finished. -- W | I haven't lost my mind; it's backed up on tape somewhere. +-------- Ashley

Re: [MySQL] Problems with 'make install'

g without an eraser." - John Gardner +-------- Ashley M. Kirchner <mailto:[EMAIL PROTECTED]> . 303.442.6410 x130 Director of Internet Operations / SysAdmin. 800.441.3873 x130 Photo Craft Laboratories, Inc..

Re: [MySQL] interesting find

ng really. (though I tend to put 'screwed with by' whenever I change something ) -- W | I haven't lost my mind; it's backed up on tape somewhere. +-------- Ashley M. Kirchner <mailto:[EMAI

Re: [MySQL] re-install on linux

.23.52-1 MySQL-devel-3.23.52-1 [root@serpico ~]# -- H | "Life is the art of drawing without an eraser." - John Gardner +------------ Ashley M. Kirchner <mailto:[EMAIL PROTECTED]> . 303.442.6410 x130 Director

Re: mysql not supporting php.

show databases; -- H | "Life is the art of drawing without an eraser." - John Gardner +------------ Ashley M. Kirchner <mailto:[EMAIL PROTECTED]> . 303.442.6410 x130 Director of Internet Operations / SysAdmin. 8

Re: [MySQL] Re: for You

of blindly quoting the whole thing back to the list. That generates quite a bit of traffic and doesn't make you any better than the spammers themselves. -- H | "Life is the art of drawing without an eraser." - John Gardner +------

Re: [MySQL] RE: 4416 Great Growth Potential 185528 ---Hmmm

h as > research reports, public filings or computer databases and information > provided by management of the profiled company. -- H | "Life is the art of drawing without an eraser." - John Gardner +-------- Ashley M. Ki

Re: [MySQL] can you have a no-default column; error if unspecified?

ng to stop a user from entering -00-00? You'll have to create validation schemes in your code. -- H | "Life is the art of drawing without an eraser." - John Gardner + Ashley M. Kirchner <mailto:[EM

Compile errors...GCC or MySQL?

- H | "Life is the art of drawing without an eraser." - John Gardner +-------- Ashley M. Kirchner <mailto:[EMAIL PROTECTED]> . 303.442.6410 x130 Director of Internet Operations / SysAdmin. 800.441.3873 x130

InnoDB Compiler error (as well)

ife is the art of drawing without an eraser." - John Gardner +-------- Ashley M. Kirchner <mailto:[EMAIL PROTECTED]> . 303.442.6410 x130 Director of Internet Operations / SysAdmin. 800.441.3873 x130 Photo

Gemini compile error

subject, does BDB tables provide the same type of locking that Gemini does? Is there any reason to favor Gemini over BDB? -- H | "Life is the art of drawing without an eraser." - John Gardner +-------- Ashley M

Table Locking...

start the second process (which should re-check for existing information, and not blindly issue another INSERT right after the first one). -- W | I haven't lost my mind; it's backed up on tape somewhere. +-------- Ashley M. Kir

Re: Can't compile 3.23.44 Help

installed. You need those for MySQL. And they are not part of gcc. Look for the termcap, libtermcap and ncurses rpms and install those. -- H | "Life is the art of drawing without an eraser." - John Gardner +------------ Ashl

Re: [MySQL] Re: New Install Problems

l daemon 3 Sep 21 14:33 gems.pid drwx--2 sql daemon 4096 Oct 4 14:25 mysql/ srwxrwxrwx1 sql daemon 0 Sep 21 14:33 mysql.sock= -- W | I haven't lost my mind; it's backed up on tape somewhere. +-

New Install Problems

ow? -- W | I haven't lost my mind; it's backed up on tape somewhere. +---- Ashley M. Kirchner <mailto:[EMAIL PROTECTED]> . 303.442.6410 x130 IT Director / SysAdmin / WebSmith . 800.441.3873

Re: [MySQL] Problems getting into MySQL.com

Philip Daggett wrote: > Is anybody else not able to get onto mysql.com??? Looks like, it'd be down... -- W | I haven't lost my mind; it's backed up on tape somewhere. +-------- Ashley M. Kirchner <ma

Re: [PHP-DB] Order by unix timestamp

ge. BP! +---- Ashley M. Kirchner <mailto:[EMAIL PROTECTED]> . 303.442.6410 x130 Director of Internet Operations / SysAdmin. 800.441.3873 x130 Photo Craft Laboratories, Inc.. 3550 Arapahoe Ave, #6 http://www.pcraft.com . . .

[Fwd: Re: message traffic]

This was sent to me, and it should've gone to the list instead. Original Message Subject: Re: message traffic Date: Fri, 29 Jun 2001 11:17:57 -0700 From: "Michael Tam" <[EMAIL PROTECTED]> To: "Ashley M. Kirchner" <[EMAIL PROTECT

Re: message traffic

ind. Please leave a message. BP! +------------ Ashley M. Kirchner <mailto:[EMAIL PROTECTED]> . 303.442.6410 x130 Director of Internet Operations / SysAdmin. 800.441.3873 x130 Photo Craft Laboratories, Inc..

Re: Strange connect (socket) problem

mind. Please leave a message. BP! | ~~~~~~~~~ Ashley M. Kirchner <mailto:[EMAIL PROTECTED]> . 303.442.6410 x130 Director of Internet Operations / SysAdmin. 800.441.3873 x130 Photo Craft Laboratories, Inc.

Strange connect (socket) problem

in fact)... -- H | Hi, I'm currently out of my mind. Please leave a message. BP! | ~~~~~~~~~ Ashley M. Kirchner <mailto:[EMAIL PROTECTED]> .

Re: RV: A bug ??

I haven't lost my mind; it's backed up on tape somewhere. | ~~~~~~~~~ Ashley M. Kirchner <mailto:[EMAIL PROTECTED]> . 303.442.6410 x130 SysAdmin / Websmith . 800.441.3873 x130 Photo Craft Laborato

Re: names ...

p://www.mysql.com/doc/R/e/Reserved_words.html -- H | Hi, I'm currently out of my mind. Please leave a message. BP! | ~~~~~~~~~ Ashley M. Kirchner <mailto:[EMAIL PR

largest timestamp value

7;t lost my mind; it's backed up on tape somewhere. | ~~~~~~~~~ Ashley M. Kirchner <mailto:[EMAIL PROTECTED]> . 303.442.6410 x130 SysAdmin / Websmith

Re: Security

. AMK4 -- W | | I haven't lost my mind; it's backed up on tape somewhere. |________ ~ Ashley M. Kirchner <mailto:[EMAIL PROTECTED]> . 303.442.6410 x130 SysAdmin / Websmith .

Security

've checked other resources online, and I'm still lost. AMK4 -- W | | I haven't lost my mind; it's backed up on tape somewhere. |____________ ~~~

Re: REPOST: SELECT syntax

nstead of NULLs. Thanks! AMK4 -- H | Hi, I'm currently out of my mind. Please leave a message. BP! | ~~~~~~~~~ Ashley M. Kirchner <mailto:[EMAIL PRO

Re: REPOST: SELECT syntax

ing data in it? -- H | Hi, I'm currently out of my mind. Please leave a message. BP! |________ ~ Ashley M. Kirchner <mailto:[EMAIL PROTECTED]> . 303.442.6410 x130

REPOST: SELECT syntax

UNT() in it instead? AMK4 -- W | | I haven't lost my mind; it's backed up on tape somewhere. | ~~~~~~~~~ Ashley M. Kirchner <ma

SELECT syntax

UNT() in it instead? AMK4 -- W | | I haven't lost my mind; it's backed up on tape somewhere. | ~~~~~~~~~ Ashley M. Kirchner <ma

Db Efficiency

any) did you come up with? AMK4 -- H | Hi, I'm currently out of my mind. Please leave a message. BP! | ~~~~~~~~~ Ashley M. Kirchner <mailto:[EMAIL PR

Re: MySQL 3.23.33 & BerkeleyDB 3.2.9

Please leave a message. BP! | ~~~~~~~~~ Ashley M. Kirchner <mailto:[EMAIL PROTECTED]> . 303.442.6410 x130 Director of Internet Operations / SysAdmin. 800.441.3873 x130 Photo Craft Laboratories, Inc. .eFax 248.671.0909 http://www.pcraft.com

Re: problem with berkeley DB v3.2.9 and mysql v3.2.33 under Solaris 8

nload BDB v3.2.9a from www.mysql.com AMK4 -- W | | I haven't lost my mind; it's backed up on tape somewhere. | ~~~~~~~~~ Ashley M. Kirchner <mailto:[EMAIL

Re: Berkeley DB and mysql

backed up on tape somewhere. | ~~~~~~~~~ Ashley M. Kirchner <mailto:[EMAIL PROTECTED]> . 303.442.6410 x130 SysAdmin / Websmith . 800.441.3873 x130 Photo Craft Laboratories, Inc. .eFax 248.671.0909 http://www.pcraft.com

Re: berkeley db

. AMK4 -- W | | I haven't lost my mind; it's backed up on tape somewhere. | ~~~~~~~~~ Ashley M. Kirchner <mailto:[EMAIL PROTECTED]> . 3

Re: RedHat 7

lf, instead of using RedHat's rpms) AMK4 -- W | | I haven't lost my mind; it's backed up on tape somewhere. | ~~~~~~~~~ Ashley M. Kirc

Virus Alert

r two." AMK4 -- W | | I haven't lost my mind; it's backed up on tape somewhere. | ~~~~~~~~~ Ashley M. Kirchner <mailto:[EMAIL PROTECTED]&g

Re: Out of disk space

. Better free up some space on that drive. AMK4 -- W | | I haven't lost my mind; it's backed up on tape somewhere. |____________ ~~~

Excel->MySQL

d; it's backed up on tape somewhere. | ~~~~~~~~~ Ashley M. Kirchner <mailto:[EMAIL PROTECTED]> . 303.442.6410 x130 SysAdmin / Websmith . 800.441.3873 x130 Photo Craf

Re: Running two "Makes"

he system without messing with the original distribution's version. AMK4 -- H | Hi, I'm currently out of my mind. Please leave a message. BP! | ~~~~~

DB Structures

d; it's backed up on tape somewhere. | ~~~~~~~~~ Ashley M. Kirchner <mailto:[EMAIL PROTECTED]> . 303.442.6410 x130 SysAdmin / Websmith

3.23.21 + DB 3.2.3h

ought 'g' came before 'h'...someone please tell me I'm wrong? AMK4 -- H | Hi, I'm currently out of my mind. Please leave a message. BP! | ~~~~~

Re: Please remove me

p on tape somewhere. | ~~~~~~~~~ Ashley M. Kirchner <mailto:[EMAIL PROTECTED]> . 303.442.6410 x130 SysAdmin / Websmith . 800.441.3873 x130 Photo Craft Laboratories, Inc.