Can you give us the output of `uname -a` from your mysql hosts?
There's a difference if you are running a 2.4 kernel vs. 2.6 kernel
(Linux).
In 2.4 kernel, try "ps -ef", and in 2.6 kernel, "ps -Lef". You may
notice that PPID is the same for all PIDs except one, usually.
-Paul
On Thu, 2008-08-14
It can depend on the version. Earlier versions of MySQL had problems
with protocols like shared memory on Vista. Use a recent build of 5.0
or 5.1 and you should be ok.
Jesse wrote:
.NET connector is fine. ODBC should be ok but I'm not 100% sure.
How about MySQL itself?
Thanks,
Jesse
--
.NET connector is fine. ODBC should be ok but I'm not 100% sure.
How about MySQL itself?
Thanks,
Jesse
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
.NET connector is fine. ODBC should be ok but I'm not 100% sure.
Jesse wrote:
We will be purchasing a server pretty soon with Windows Server 2008 on
it. I have heard that MySQL is not compatible with WS2008. Is that
true? I've also seen instructions for installing MySQL 5.1 on WS2008.
Is 5
Hi Dusan,
Thank you so much. It works!
Kandy
> Hi Kandy,
>
> this could be the query you are looking for. It should return record
> with the closest timestamp to your required time:
>
> (SELECT TIMEDIFF('20080815091907', timestamp_column) AS diff, t.* FROM
> table1 t
> WHERE timestamp_column <=
HOORAY!!! Thanks for all of yours and Tony's hard work!
CheersFish
-
~~Second Life addict~~
-Original Message-
>From: Stefan Hinz <[EMAIL PROTECTED]>
>Sent: Aug 15, 2008 11:09 AM
>To: mysql@lists.mysql.com
>Subject: PHP Documentation in the MySQL Manual
>
>PHP Do
We will be purchasing a server pretty soon with Windows Server 2008 on it.
I have heard that MySQL is not compatible with WS2008. Is that true? I've
also seen instructions for installing MySQL 5.1 on WS2008. Is 5.1
compatible, but earlier versions are not?
We run ASP and ASP.Net application
It looks like "LIKE" is only slightly faster(on my XP), hardly worth
mentioning. Go with what is easier for you to read or for portability if
you need it. IMHO
set @a='gfdueruie baz hdhrh';select BENCHMARK(500, (select 1 from
dual WHERE @a LIKE '%foo%' OR @a LIKE '%bar%' OR @a LIKE '%baz%')) a
PHP Documentation in the MySQL Manual
-
MySQL can be used with a multitude of programming languages, but PHP is
probably the most popular choice. For that reason, we always felt a bit
bad about our PHP-related documentation being somewhat sparse, mostly
consisti
>Maybe what I am seeing in the Query Browser area is in fact a Warning
>message and not an error!!
Ahhh...yes maybe that's it. Just fyi, here is the detail of the warning:
mysql> drop table if exists recipes;
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> SHOW WARNINGS;
+---+--+
I am certain the SQLBrowser program authors want to hear about this error
It may be due to the fact that MYSQL procedures need to have a different
delimiter
(//) instead of ;
e.g.
use DBNAME;
DROP PROCEDURE IF EXISTS TABLE_NAME;
delimiter //;
Anyone?
Martin
___
I am getting this problem when I am calling this from within a stored
procedure and from the command line area but from MySQLQueryBrowser
Windows package.
I have tried the DROP TABLE IF EXISTS from the mysql "DOS-type" command
line and it doesn't error - I do notice that (also in your example) tha
I'm puzzled by the layout of your table, if that's what you're showing us. Is
the timestamp in the table truly associated with the time at which the user
put in his approximate time?
If, for example, the user types in 04:05:07 at 04:03:02, and then types in
04:02:59 at 04:03:03, what is it that
Kandy Wong wrote:
And what is the good connector (C++ to MySQL) to use?
MySQL++ (http://tangentsoft.net/mysql++/) has native Date, Time, and
DateTime data types. You can convert to these types implicitly:
mysqlpp::DateTime dt = row["my_column"];
Row::operator[] doesn't return Date
Hi,
One of our previous developers decided to obfuscate some columns via the mysql
encode and decode functions. This was done on a 4.x server. Recently, we
converted to a 5.x server, and some of the fields in the rows will not decode
correctly, and I cannot figure out why.
My first thought w
Kandy Wong wrote:
> Hi Saul,
>
> I need to use C++ and I'm not writing a web application.
> Thanks anyway.
you can do something like:
select min(abs(timediff("",timestamp))) from where
;
if you use the libmysql you can get the result as strings back (the method i
prefer) and convert the
Hmmm. It works okay for me, without an error when the tabel doesn't exist.
I'm using mysql Server version 5.0.51a-3ubuntu5.1
For example:
*
mysql> use lsldatabase;
Reading table information for completion of table and column names
You can turn off
Hi,
I want to retrieve all records where the field "value" contains either
"foo", "bar" or "baz". Like so:
SELECT id FROM table WHERE value LIKE '%foo%' OR value LIKE '%bar%' OR
value LIKE '%baz%';
But then I stumbled upon REGEXP, and can do the same this way:
SELECT id FROM table WHERE
I am finding that
DROP TABLE IF EXISTS mytable;
Works fine if the table exists - but if it doesn't exist I get an error?
Surely it should not error and just not try to drop the table.
Is it me?
if you switch the default engine type any new tables would be created
with that new engine type. it does not convert existing tables to
your new format.
if you have existing innodb tables you need to have the innodb
settings active, in my.cnf
On 15 Aug 2008, at 06:01, [EMAIL PROTECTED]
Hi Kandy,
this could be the query you are looking for. It should return record
with the closest timestamp to your required time:
(SELECT TIMEDIFF('20080815091907', timestamp_column) AS diff, t.* FROM
table1 t
WHERE timestamp_column <= '20080815091907'
ORDER BY timestamp_column DESC LIMIT 1
)
21 matches
Mail list logo
