"Chris Boget" <[EMAIL PROTECTED]> wrote:
>> > What's going on with the MAX() function? Why did it return NULL
>> > in the first query above. There were no adding/deleting data between
>> > the above queries and yet MySQL didn't pull the MAX from the table
>> > until I added the "AND assets IS NOT
At 16:09 -0500 6/12/03, Chris Boget wrote:
> CREATE TABLE do_deductibles (
currency varchar(10) NOT NULL default '',
assets int(20) NOT NULL default '0',
deductible int(10) NOT NULL default '0',
do_deductibles_id int(5) NOT NULL auto_increment,
PRIMARY KEY (do_deductibles_id),
U
> CREATE TABLE do_deductibles (
> currency varchar(10) NOT NULL default '',
> assets int(20) NOT NULL default '0',
> deductible int(10) NOT NULL default '0',
> do_deductibles_id int(5) NOT NULL auto_increment,
> PRIMARY KEY (do_deductibles_id),
> UNIQUE KEY do_deductibles_idx (currency
> > What's going on with the MAX() function? Why did it return NULL
> > in the first query above. There were no adding/deleting data between
> > the above queries and yet MySQL didn't pull the MAX from the table
> > until I added the "AND assets IS NOT NULL" to the query. And yet
> > after I ran
"Chris Boget" <[EMAIL PROTECTED]> wrote:
> We are running v4.0.12.
>
> Consider the following:
>
> mysql> SELECT MAX(assets) as assets
>-> FROM do_deductibles
>-> WHERE currency = 'usd';
> ++
> | assets |
> ++
> | NULL |
> ++
> 1 row in set (0.00 sec)
>
> mysql>
We are running v4.0.12.
Consider the following:
mysql> SELECT MAX(assets) as assets
-> FROM do_deductibles
-> WHERE currency = 'usd';
++
| assets |
++
| NULL |
++
1 row in set (0.00 sec)
mysql> SELECT MAX(assets) as assets
-> FROM do_deductibles
-> WHERE
hello
in delphi the type for max(date) if tstring.
the only problem is there is no CAST in mysql 3.23.49
bye
- Original Message -
From: "Johnny Withers" <[EMAIL PROTECTED]>
To: "'Jean Bernard'" <[EMAIL PROTECTED]>
Sent: Thursday, April 25,
i write a program using MyIsam,and i want uses Innodb.
the query:
select max(date_comp) as mdate from pieces
on MyIsam mdate is a date.
on InnoDB mdate is string.
win2000
delphi6
zeosdbo
it's normal?
-
Before posting, plea
On Friday 17 August 2001 07:13, Jim Lynn wrote:
> I have a database of bids on auctions that I keep separate from the auction
> information. The problem comes when I attempt to generate a list of
> auctions with highest bid information. I set the database for bids like
> this:
>
> ANum, varchar(
I have a database of bids on auctions that I keep separate from the auction
information. The problem comes when I attempt to generate a list of
auctions with highest bid information. I set the database for bids like this:
ANum, varchar(20), the auction number
Bidders, int(4), number of bidder
Guenther Pewny writes:
> It's a miracle.
>
> Which version of the BDB patch do you use?
> I'm using 3.2.9a.
> (Previously, there has been a version 3.2.3g...)
>
> Thanks...
>
> Günther Pewny
>
Hi!
I used latest source tarball from our 3.23 page.
Regards,
Sinisa
__
It's a miracle.
Which version of the BDB patch do you use?
I'm using 3.2.9a.
(Previously, there has been a version 3.2.3g...)
Thanks...
Günther Pewny
Sinisa Milivojevic wrote:
> Guenther Pewny writes:
> > Hi folks,
> >
> > I have a problem with BDB tables. Please look at this short mysql s
Guenther Pewny writes:
> Hi folks,
>
> I have a problem with BDB tables. Please look at this short mysql session:
>
> mysql> create table sample (
> id1 int(8) not null,
> id2 int(8) not null,
> primary key (id1,id2))
> type=BDB;
> Query OK, 0 rows affected (0.67 sec)
Hi folks,
I have a problem with BDB tables. Please look at this short mysql session:
mysql> create table sample (
id1 int(8) not null,
id2 int(8) not null,
primary key (id1,id2))
type=BDB;
Query OK, 0 rows affected (0.67 sec)
mysql> insert into sample values (1, 2);
Query OK, 1
14 matches
Mail list logo