Hi there,
I am wondering if it is possible to find words inside words with the
help of fulltext search.
For example:
Search for: Antenne
Schould also find Stabantenne
Is this possible? Google does that, so somehow there should be a way.
Another thing is, how do I exclude popular words like
Heikki Tuuri wrote:
Deva,
please post the complete output except the transaction data.
Regards,
Heikki
Please let me know if there is any additional data I can provide to help
resolve this.
=
051005 7:18:17 INNODB MONITOR OUTPUT
2005/10/6, Ed Reed [EMAIL PROTECTED]:
I'm trying to group some sub categories with a concatenated result. I'm
trying to get the max sub for each item per month. I think it should be
fairly easy but it is kicking my butt. My data looks like this,
+++--+
| month | item
On Wed, Oct 05, 2005 at 11:23:00AM -0700, Mike Wexler wrote:
Jim Seymour wrote:
I have researched repeatedly and cannot find an answer to the following. I
need to do something like the following (There is probably an easier
way).
end_date - start_date = diff / start_date = return for
Incoming from s. keeling:
Incoming from Pooly:
2005/10/3, s. keeling [EMAIL PROTECTED]:
I'd like to add a bit of history data to a table (who changed a record
last, and when it was last changed). Is this the way to do it?
[snip]
alter table MEMBERS
alter CHG_DATE set
s. keeling wrote:
Incoming from s. keeling:
Incoming from Pooly:
2005/10/3, s. keeling [EMAIL PROTECTED]:
I'd like to add a bit of history data to a table (who changed a record
last, and when it was last changed). Is this the way to do it?
[snip]
alter table MEMBERS
Incoming from Arno Coetzee:
s. keeling wrote:
Grr. Please, what's wrong with this?!?
alter table MEMBERS
alter MEMBER_INFO varchar(160);
ERROR 1064: You have an error in your SQL syntax. Check the manual \
that corresponds to your MySQL server version for the right \
syntax
On 06/10/2005, s. keeling wrote:
Incoming from Arno Coetzee:
s. keeling wrote:
alter table MEMBERS
alter MEMBER_INFO varchar(160);
ERROR 1064: You have an error in your SQL syntax.
http://dev.mysql.com/doc/mysql/en/alter-table.html
Yes, I've read it. Your point?
Merlin wrote:
I am wondering if it is possible to find words inside words with the
help of fulltext search.
Is this possible? Google does that, so somehow there should be a way.
Somehow I don't think that Google runs on a single MySQL database. Full
text indexes in MySQL mean that words
s. keeling wrote:
Incoming from Arno Coetzee:
s. keeling wrote:
Grr. Please, what's wrong with this?!?
alter table MEMBERS
alter MEMBER_INFO varchar(160);
ERROR 1064: You have an error in your SQL syntax. Check the manual \
that corresponds to your MySQL server version for the
Hi again,
The query cache finally works after I've reverted to
mm.mysql-2.0.12-bin.jar.
The problem was that the query cache somehow wouldn't work within
transactions with mysql-connector-java-3.1.10-bin.jar. Anyone care to dig
further?
Here is one working combination:
Jboss 3.2.2 with
On Wednesday 05 Oct 2005 15:29, Jeff Smelser wrote:
On Wednesday 05 October 2005 04:05 am, Rob Hall wrote:
Having a few problems using cursors in 5.0.13 and I don't know wether
it's an 'operator error' :)
Should this work?
when loading a procedure, do show warnings after it.. It tells
Dear Michael,
thank you for your response.
If a duplicate unique key is found when importing with LOAD DATA INFILE,
How does that happen? I take it you are adding the imported data into an
already populated table.
True, that's what I meant to say.
Don't alter the keys for the existing
I download MySql Query Browser 1.1.15 and he is leaving me nervous...
This is the problem:
1. I have 2 tabsheet result set.
2. I the first i make a query , like select * from table1.
3. In the second i am in the middle of a query, like select * from table1
where id = (What's is the id ??? Fuck,
Hello All!
left(),right(),mid(),etc functions
+
with fixed point return value for function (or out parameter for sp)
---
result has been truncated
How to repeat:
mysql drop function if exists test;
mysql drop function if exists test1;
mysql delimiter //
mysql
We are having slowness issues with MySQL on Mac OS X 10.4. Here is what has been done...1) Tiger's native version of mysql was installed.2) A delete was attempted on 1.5 million records Note: These records are heavily referenced to other tables3) 8+ hours later the delete was cancelled and it
I am converting some code from MSSQL to MySQL. In one place I need to
have a conditional query depending on if a table exists or not. There
are different versions of this application and the table only exists in
some of them. Here is how it was done in MSSQL:
IF OBJECT_ID('cfgbiz') IS NOT NULL
Ryan,
I am converting some code from MSSQL to MySQL. In one place I need to
have a conditional query depending on if a table exists or not. There
are different versions of this application and the table only exists in
some of them. Here is how it was done in MSSQL:
If 'SHOW COLUMNS FROM
Hi all,
I am wondering if I can construct a query string inside a stored
procedure and then execute it. I mean, what I want to do is given a set of
IN parameters, be able to construct a huge where statement out of them an
then complete the query string to execute. Is that possible? because if
If 'SHOW COLUMNS FROM tablename' returns error 1146 (42S02), the
table doesn't exist.
This causes my application (ColdFusion) to throw an exception.
If I have to, I could resort to doing another query in my application
(SHOW TABLES) and seeing if my table was returned in that list. But I
was
Yes you can do this using prepared statements inside stored proc.
Guess this helps.
http://forums.mysql.com/read.php?98,22770,31459
sujay
-Original Message-
From: Leonardo Javier Belén [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 06, 2005 9:47 PM
To: Ryan Stille;
Incoming from Arno Coetzee:
sorry ... bit busy on this side... had a quick look...
give this a go...
alter table MEMBERS
MODIFY MEMBER_INFO varchar(160);
hope this works
It did. Much appreciated.
--
Any technology distinguishable from magic is insufficiently advanced.
(*)
Ryan Stille wrote:
If I have to, I could resort to doing another query in my application
(SHOW TABLES) and seeing if my table was returned in that list. But I
was hoping for a more elegant way to do it, within the single query.
Maybe you could use
SHOW TABLES LIKE 'your_table';
--
Keith
On Thursday 06 October 2005 10:57 am, Ryan Stille wrote:
I am converting some code from MSSQL to MySQL. In one place I need to
have a conditional query depending on if a table exists or not. There
are different versions of this application and the table only exists in
some of them. Here is
Maybe you could use
SHOW TABLES LIKE 'your_table';
That's a great idea, I just tried it in several ways, like:
IF EXISTS (SHOW TABLES LIKE 'cfgbiz') THEN
SELECT siacnotifyto FROM cfgbiz
ELSE
SELECT '' as siacnotifyto
END IF;
-and-
select IF((SHOW TABLES LIKE
There is a product that will do the job. It is MYdbPAL (www.it-map.com)
which is a free license to MySQL users. You can extract all or partial
datasets from 2 databases, compare them and produce a 'differences' dataset.
This can, be viewed, edited, and if needed be applied to the target database
Hello everyone:
I have two tables that store a blob.
They both have Id fields.
What I would like to do is, given an id, copy the blob stored on table
one to table two.
I could do that in my java program by selecting and retrieving the blob
from table 1 and then issuing
a insert/replace
C.F. Scheidecker Antunes wrote:
I want to insert the blob file from table1 where id = 1 to table2.
To select the blob I would issue: select file from table1 where id = 1
To insert I would do: insert into table2 (blob) values(?)
INSERT INTO table2 (blob) SELECT file FROM table1 WHERE id=1
--
Deva,
please post those transactions which have been active more than 800 seconds.
The thread holding the RW-latch at 0x448286bc should be among those.
Regards,
Heikki
- Original Message -
From: Devananda [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Thursday,
Heikki Tuuri wrote:
Deva,
please post those transactions which have been active more than 800
seconds. The thread holding the RW-latch at 0x448286bc should be among
those.
Regards,
Heikki
The thread holding that RW-latch is the first of these. I've removed any
sensitive information but
I understand what you're saying.
The problem is that if mysql attempted to do a query like you suggest:
Select Count(*) From myTable Where a=1 And b=1 And c=1 And d=1 And e=1 And f=1;
It can only use one index for the query, and hopefully, the optimizer
will pick one of the six indexes with the
Hi,
I'm pretty much an SQL newbie, so apologies in advance if this is
basic stuff. That'll teach me for skipping the databases class in
college...
I just created an app using a table that has entries like this
simplified version:
name datevalue
Fred
Thanks for the reply,
Sorry; I'm using 4.1.11
Thanks again.
Pooly [EMAIL PROTECTED] 10/6/05 1:51 AM
2005/10/6, Ed Reed [EMAIL PROTECTED] :
I'm trying to group some sub categories with a concatenated result. I'm
trying to get the max sub for each item per month. I think it should be
Senior Database Kernel Developer
ANTs software inc. has developed a high-speed relational database, the
ANTs Data Server, which is based on our patent-pending lock-free
datastructure technology.
We are looking for a Senior Database Engine Developer with experience in
developing online
SELECT DISTINCT(name), date, value FROM table_name ORDER BY date DESC;
On Thu, 2005-10-06 at 17:33 -0400, Donnie Lynch wrote:
Hi,
I'm pretty much an SQL newbie, so apologies in advance if this is
basic stuff. That'll teach me for skipping the databases class in
college...
I just created
Manish Marathe wrote:
SELECT DISTINCT(name), date, value FROM table_name ORDER BY date DESC;
DISTINCT is not a function. The above (if it even works) is exactly
equivalent to:
SELECT DISTINCT name, date, value FROM table_name ORDER BY date DESC;
and will match distinct rows (that is,
of course, although DISTINCT(name) works
On Fri, 2005-10-07 at 12:29 +1300, Jasper Bryant-Greene wrote:
Manish Marathe wrote:
SELECT DISTINCT(name), date, value FROM table_name ORDER BY date DESC;
DISTINCT is not a function. The above (if it even works) is exactly
equivalent to:
SELECT
Something like this ought to work (untested). If you're using 4.1 you
will need a temporary table as a sub-query will not work.
SELECT
name,
date,
value
FROM yourtable
WHERE date = (
SELECT
MAX(date)
FROM yourtable yourtable2
WHERE yourtable.name = yourtable2.name
)
Off the top of my
Manish Marathe wrote:
of course, although DISTINCT(name) works
Yes, but writing it that way gives the impression that you are somehow
applying DISTINCT only to the name column, which you're not. You're
applying it to entire rows.
Oh, and can you please stop top-posting.
Jasper
On Fri,
Hi,
I am running an application using the C-API against mysql 4.0.20 on a
redhat AS 3 server.
The users using this application are getting numerous (and seemingly
random) query errors.
Has anyone seen these before? The frm files do exist.
It's not from just this table.
mysql_real_query
I've used msyqldump to retrieve the structure and data of my db, but
can I use it to only spit out the structure, ie, the Create Table
statements, but none of the inserts.
Thanks.
Scott.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hi,
I too have a server whose log file is full of these errors.
This server is also running MySQL 4.0.20. It is on Red Hat Enterprise
Linux AS release 3 (Taroon).
The errors are: (many thousands of them)...
051004 15:39:34 Aborted connection 349 to db: 'sqllive' user: 'sqllive'
host:
Hi,
I am running an application using the C-API against mysql 4.0.20 on a
redhat AS 3 server.
The users using this application are getting numerous (and seemingly
random) query errors.
Has anyone seen these before? The frm files do exist.
It's not from just this table.
mysql_real_query
Hi Scott,
This is covered in the MySQL manual at
http://dev.mysql.com/doc/mysql/en/mysqldump.html
The option you need is -
--no-data, -d
Do not write any row information for the table. This is very useful if
you want to get a dump of only the structure for a table
Regards
David Logan
Hi Ian,
Have you checked the NIC? If your ethernet card or switch port is
failing, this may be causing the issues that you have in the logs.
The other issues with the tables, have you run mysqlcheck or myisamcheck
against these tables to ensure they are not corrupt?
Hi,
I am running an application using the C-API against mysql 4.0.20 on a
redhat AS 3 server.
The users using this application are getting numerous (and seemingly
random) query errors.
Has anyone seen these before? The frm files do exist.
It's not from just this table.
mysql_real_query
Donnie Lynch [EMAIL PROTECTED] wrote on 10/06/2005 05:33:01 PM:
Hi,
I'm pretty much an SQL newbie, so apologies in advance if this is
basic stuff. That'll teach me for skipping the databases class in
college...
I just created an app using a table that has entries like this
simplified
47 matches
Mail list logo