hi all,
I have a very strange problem with some indexes.
It is a unique index on a column containing null data.
when I do a query like
select * from xxx where yyy is null
I get only one row (the first) but I know there is more.
recentely, this table switched to innodb and we changed the server.
)'14:00:00' AND
HOUR(stop)='02:00:00',150*sessiontime,0)) from YOUR_TABLE WHERE
username='mehdi' AND start BETWEEN '2002-08-12' AND '2002-08-16';
is it possible to define some thing like functions (or something like MS-SQL
Server's Store Procedure) in mysql to do such a work ?
if yes, please let me
Hi,
Suppose there is a sql table with the following fields and values:
+-+
|username|start|stop |sessiontime|
++-+--+---+
|mehdi | 2002-08
.
Sincerely,
Mehdi Zare
-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 06, 2002 1:38 PM
To: [EMAIL PROTECTED]
Subject: Re: RE: support UTF-8
Mehdi,
Thursday, June 06, 2002, 11:27:24 AM, you wrote:
MZ Hi Shahzad,
MZ I also want to know whether mySQL
Hi Shahzad,
I also want to know whether mySQL support Unicode, utf-8 or not.
If you know anything about this please answer me as soon as possible,
Sincerely,
Mehdi Zare
-Original Message-
From: shahzad sarwar [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 03, 2002 8:35 PM
To: [EMAIL
Hi all,
I hava a little problem for developping a windows mysql client program in
C++.
I compile it using cygwin. there is no problem during the compilation but
when I execute it, it seems that when I execute a select query and retrieve
the data, it access memory that it shouldn't. I tested my