Thanks!
2010/2/16 Peter Brawley peter.braw...@earthlink.net
David,
I need count the messages don'tread in a thread.
Have a look at the edge list examples at
http://www.artfulsoftware.com/mysqlbook/sampler/mysqled1ch20.html.
PB
-
David Arroyo Menendez wrote:
Hello,
I've the
Ted, all,
Ted Yu wrote:
Hi,
In our deployment, mysql needs to be started before tomcat automatically
after server restart.
If you know how this order can be specified, please share.
We use tomcat6 on Linux tyu-linux 2.6.18-128.2.1.el5 #1 SMP Tue Jul 14
06:36:37 EDT 2009 x86_64 x86_64
There is a file called /etc/rc.local. You can set the mysql start here,
before starting tomcat during system or server reboot.
regards
anandkl
On Wed, Feb 17, 2010 at 6:25 AM, Joerg Bruehe joerg.bru...@sun.com wrote:
Ted, all,
Ted Yu wrote:
Hi,
In our deployment, mysql needs to be
HI All
Maybe you can assist.
We are looking at upgrading a clients' MySQL 5.0 to version
5.1.
They are running the following version: mysql Ver 14.12
Distrib 5.0.72sp1, for unknown-linux-gnu (x86_64) using readline 5.1
On 02/16/2010 17:30, Zakai Kinan wrote:
I am getting this error - mysqldump: Got error: 1044: Access denied for user
'root'@'localhost' to database 'information_schema' when using LOCK TABLES. I
am using 5.1.45. I don't understand what is causing this problem. Does anyone
have a clue?
Hi there,
I have a WEIRD question, that I can't find an answer too...
Here is my stored function:
DELIMITER $$
USE `mydatabase`$$
DROP FUNCTION IF EXISTS `SPLIT_STR`$$
CREATE definer=`thisus...@`%` FUNCTION `SPLIT_STR`(
X VARCHAR(255),
delim VARCHAR(12),
pos INT
) RETURNS VARCHAR(255)
Hi,
The problem of BLOB storage with MySQL is not the actual storage of the BLOB
data, it is the getting BLOBs to and from the client. Traditionally MySQL
treats the BLOB data as any other data and as a result there can be major
memory usage and performance issues as the BLOB is passed back to
Thanks for the answer.
ZK
--- On Wed, 2/17/10, Mikhail Berman mikhail...@gmail.com wrote:
From: Mikhail Berman mikhail...@gmail.com
Subject: Re: Information_schema permission error
To: Zakai Kinan titanyen2...@yahoo.com
Cc: mysql@lists.mysql.com
Date: Wednesday, February 17, 2010, 5:49 AM
Is there a simple function or method to compare a value in a column to one or
more items in a comma separated list?
select * from table where value contains one of ('apple','orange','banana');
and say value may = something like 'produce(grape,orange,pear,apple,lettuce)'
--
MySQL General Mailing
A simple IN would not match if the actual value of the values column is
litterally ''produce(grape,orange,pear,apple,lettuce)' and you want to see if
any one of ('apple','orange','banana') is in there
From: dryd...@optonline.net [dryd...@optonline.net]
On Wed, February 17, 2010 09:24, Cantwell, Bryan wrote:
Is there a simple function or method to compare a value in a column to one
or more items in a comma separated list?
select * from table where value contains one of
('apple','orange','banana');
and say value may = something like
[snip]
IN('value1','value2') should work for exact matches, also works for
integer values.
[/snip]
IN will not open and read his CSV file...
[snip]
Is there a simple function or method to compare a value in a column to
one or more items in a comma separated list?
[/snip]
In order to do this you
I have a function built that will get me X percentile from my history table for
last X days. It works fine as long as I hard code the certain values in where
they go... what I really need to know is how can I make dynamic sql still do a
select into a variable? simply replacing the '31' below
Hi Machiel, all!
Machiel Richards wrote:
[[...]]
We are looking at upgrading a clients' MySQL 5.0 to version
5.1.
Good.
They are running the following version: mysql Ver 14.12
Distrib 5.0.72sp1, for unknown-linux-gnu (x86_64) using readline 5.1
Which
Hi, for some reason, I have an auto_increment field that's magically
bumped up to the next biggest power of 2 after a big INSERT...SELECT
that inserts a bunch of tuples (into an empty table). Is this expected
behavior? I couldn't find any mention of this from the docs (using the
MySQL 5.4.3 beta).
Dear Jerry Schwartz
We have applications for colleges in India. The same idea of having single
table for manipulating students records. but we are not following archiving
concept.
Ex stupersonal. and stuclass these tables are playing wide role in our
application. After 7 years now there are
Hi All,I want to find out number of lines are there in
all stored procedure written.Is it possible to get the
number of lines using a SQL query.Thanks in advance.
--
Regards,
Manasi Save
17 matches
Mail list logo