sum of time?

I have a table doing time tracking. I don't use timestamps, I use datetime fields to record punch in times and punch out times. I have this query that computes the amount of time between a punch in and punch out: select SEC_to_time(unix_timestamp(TTendTime) - unix_timestamp(TTstartTime)) as e

Re: Not operator in Select statements

On Mon, 2005-10-24 at 06:09 +0200, Dotan Cohen wrote: > How do I use a not operator in the WHERE clause? The obvious != and > NOT didn't work for me. Something along the lines of: > $query = "SELECT album, year FROM albums WHERE year!=1990 ORDER BY year ASC"; The above query is syntactically corre

Not operator in Select statements

How do I use a not operator in the WHERE clause? The obvious != and NOT didn't work for me. Something along the lines of: $query = "SELECT album, year FROM albums WHERE year!=1990 ORDER BY year ASC"; $query = "SELECT album, year FROM albums WHERE year NOT 1990 ORDER BY year ASC"; Thanks in advance

Re: implicit cast forces table scan?

Gleb Paharenko wrote: Dear, Michael! Did you read my earlier reply? This is neither an optimizer nor > > version issue. I've sent my e-mail before I've read your. The problem is that I was testing my guessing on the table with a bit different structure than your (mine didn't have a primary k

RE: Should I buy commercial license?

Hi Jasper and Kenji, There used to be a commercial license that was about $149.00 (USD) AFAIK without support as this was available separately. I would presume that the numbers of people buying this as opposed to a complete package with support was probably rather small hence a replacement by the

Re: Should I buy commercial license?

Well, actually they did sell "only" commercial licence bofore starting to sell MySQL Network. And, we cannot find anything this "commercial" license purchase process any more. However, still it's not impossible to buy them directlly, so I would like to clarify my understanding. MySQL Network conce

Re: Should I buy commercial license?

On Mon, 2005-10-24 at 09:29 +0900, Kenji HIROHAMA wrote: > On 10/24/05, Jasper Bryant-Greene <[EMAIL PROTECTED]> wrote: > > That's not necessarily true. Many people need to buy a license because > > they need the support that comes with paying for the software, or they > > need to support the devel

Re: Should I buy commercial license?

On 10/24/05, Jasper Bryant-Greene <[EMAIL PROTECTED]> wrote: > That's not necessarily true. Many people need to buy a license because > they need the support that comes with paying for the software, or they > need to support the development of a product that they are likely to > rely on for their b

Re: Problem Upgrading

Thanks for pointing me in that direction. The client from the binary distro works fine. I guess I should just stick with the binaries ;-) Ed Gleb Paharenko wrote: >If you want to debug this issue, have a look here: > http://dev.my

Re: Should I buy commercial license?

On Sun, 2005-10-23 at 18:05 +0400, Alexey Polyakov wrote: > Basically, you don't need to purchase license unless you distribute > your software. (And even if you do, it doesn't automatically mean that > you should buy commercial license). That's not necessarily true. Many people need to buy a lice

Re: implicit cast forces table scan?

Dear, Michael! > Did you read my earlier reply? This is neither an optimizer nor > > > version issue. I've sent my e-mail before I've read your. The problem is that I was testing my guessing on the table with a bit different structure than your (mine didn't have a primary key field 'id').

Re: Temp table doesn't seem to work

Brian Dunning <[EMAIL PROTECTED]> wrote on 10/23/2005 03:00:26 PM: > If I say this, I get all my data: > > $sql = "select * from myTable;"; > $result = mysql_query($sql); > ?> > > But if I say this, I get no results at all: > > $sql = "create temporary table xxx select * from myTable;"; > $re

Temp table doesn't seem to work

If I say this, I get all my data: But if I say this, I get no results at all: Seems pretty straightforward. What am I missing? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Should I buy commercial license?

Hi! There'a a great article about MySQL licensing: http://entwickler.com/itr/online_artikel/psecom,id,618,nodeid,114.html Basically, you don't need to purchase license unless you distribute your software. (And even if you do, it doesn't automatically mean that you should buy commercial license).

Re: Need help with fulltext search and left join

For me, it looks as if you confused the order of join and where. It should be: select ... from ... join ... where ... order by ... Stefan Am Sunday 23 October 2005 13:21 schrieb Grant Giddens: > Hi, > > I keep getting errors on this query and I'm not sure > why. I'm using mysql version 4.0.22.

Need help with fulltext search and left join

Hi, I keep getting errors on this query and I'm not sure why. I'm using mysql version 4.0.22. Any ideas? SELECT pn_coupons_store.store_name, pn_coupons_store.store_name_short, pn_coupons_coupons.store_id, pn_coupons_coupons.coupon_id, pn_coupons_dealtype.dealtype_name, pn_coupons_coupons.co