Hi!
We have that huge query against a mysql 4.1 (myisam) to retrieve rows.
The query is built dynamically using a loop, as we are searching in an
external database built to store a tree with the nested tree model.
When we do this search with a normal world, it's fine: the query is around
4
Hi!
I'm stuck with a join query
2 tables, term and relation, the first one with definition of terms the
second one with the relations between them.
CREATE TABLE `term` (
`term_id` int(11) unsigned NOT NULL auto_increment,
`name` varchar(250) default NULL,
) ENGINE=MyISAM DEFAULT
Perfect!
I tried aliasing the field names but didn't think about the table, and was
just stuck looking at that query without any idea...
Thanks a lot for your help.
melanie
From: Johan Höök [EMAIL PROTECTED]
To: mel list_php [EMAIL PROTECTED]
CC: mysql@lists.mysql.com
Subject: Re: query
the
source,it's a bit long the first time, but you'll get used to it, and if you
ever want to install an other program from the sources you'll know what to
do!
hth,
melanie
From: Dave M G [EMAIL PROTECTED]
To: mel list_php [EMAIL PROTECTED]
CC: mysql@lists.mysql.com
Subject: Re: Unable
Hi,
The precise instructions are here:
http://dev.mysql.com/doc/refman/5.0/en/charset-syntax.html
You can start your server specifying the character set
(http://dev.mysql.com/doc/refman/5.0/en/charset-server.html), and alter the
databases
Hi,
I'm not very good at encoding either, but from what I understood, the client
specifies the encoding expected from the database,if you do a show variables
like '%char%', you will have a line character_set_client. In your case this
is probably set to latin_1.
If this is the case, mysql is
Hi list,
I guess this is a classic problem...!
I found that on the web: http://www.oreillynet.com/pub/wlg/9022?wlg=yes,
where basically the guy did dump data, change the charset in the table
definition and reinsert the records into an utf8 database and ended up with
some problems...
I saw
Hi,
Maybe your problem is linked to phpmyadmin?
I was having issues when trying to use an 'old' version (2.5.7) because the
interface itself of phpmyadmin was set up as iso-8859-1, and that was
causing all my data to be entered as isolatin even if the tables were
declared as utf8.
By updating
Hi,
I was wondering if there is any way to do a global search through all the
tables in mysql? (not taking into account the performance issue)
If for example I want to search ABC in all the columns of one table:
select * from table where [whatever the column] like '%ABC%'
or globally
select *
probably possible to do a small script describing all the columns
then building a query to search in, but I was wondering if there was
an already existing mechanism.
Another approach is not to use external scripts, but rather stored
routines and INFORMATION_SCHEMA databases in MySQL 5.0.
mel
Hi,
This may be a strange question, but I was wondering if it is possible to
have a user starting/stopping the mysql server who wouldn't have access to
the data.
To explain: I want to set up a server as user Groupinstaller for example.
This is a virtual user to allow other people of my group
Hi,
In your query you try to update on the condition column 1 = number2 and
column1 = number3.
I think what you want is column 1 = number2 or column1 = number3 .
If you use and it will try and found a record in column which has a value =
number2 and at the same time = number3.
hth,
melanie
You can use backticks ( ` ) to escape the names:
INSERT INTO `tickets` ( `id` , `from` , `departement` .
hth,
melanie
From: Jeff [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Subject: Insert query problem
Date: Tue, 29 Nov 2005 11:42:34 -0500
All,
I can't get this query to run, it keeps
hi,
i just inherited a mysql server 4.1 and need to run mysql_fix_privileges on
it.
However one of the databases hosted on it is production and I'd rather avoid
it to be down.
I ran the script on an 4.0 server test that I had installed and which was
running when I ran the script. I had no
I think you want that:
When you add an AUTO_INCREMENT column, column values are filled in with
sequence numbers for you automatically. For MyISAM tables, you can set the
first sequence number by executing SET INSERT_ID=value before ALTER TABLE or
by using the AUTO_INCREMENT=value table
For information for other people who would have the same problem:
Warning
Do not issue the query 'set names' with Connector/J, as the driver will not
detect that the character set has changed, and will continue to use the
character set detected during the initial connection setup.
To allow
for your help,
melanie
If you write an hungarian article about your test, maybe you will plan an
english translation?or is hungarian hard to learn? :-)
From: BÁRTHÁZI András [EMAIL PROTECTED]
To: mel list_php [EMAIL PROTECTED]
CC: mysql@lists.mysql.com
Subject: Re: character sets.(missing
Hi guys,
I don't really understand the character set in mysql from the doc.
Tu summarize my problem:
users upload xml files (UTF-8).
part of the data is then inserted into MySQL (CHARSET=latin1)
at that point, when I browse via phpmyadmin (which is isolatin1) or export
to an html page no
if the character_set_client is by default latin1, does that mean that the
java application is sending latin1?or is it changed at runtime?
kind of lost again.
From: mel list_php [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Subject: character sets.
Date: Tue, 08 Nov 2005 17:30:28 +
Hi guys,
I don't
hi!
I'm still trying to organize an hierachical db (I saw the last article on
mysql.com:
http://dev.mysql.com/tech-resources/articles/hierarchical-data.hml).
I began working with what the author calls adjency list model (I think the
nested set model is a bit too complex for what I want to
Hi,
I want to buil a hierarchical database, with different kind of relations.
I have differents elements which are linked between them by different kinds
of relations.
Ex:
element 1 IS A element 72
element 22 IS PART OF element 36
I want to have a table elements,for several reasons: I
Hi,
I downloaded and tried to install from the sources.
./configure, make seem ok, however the make install exit very quickly with
an error code 127 (perror gives record-file is crashed, no idea of what
that means!).
My old 5.0.4 istall is working fine, so I don't think the system is in
, a
native function or a patch?
Is it the same but the format is different depending on the developper's
choice?
Thanks a lot for your help,
Melanie
From: Alexander Barkov [EMAIL PROTECTED]
To: mel list_php [EMAIL PROTECTED]
CC: mysql@lists.mysql.com
Subject: Re: mysqlxml
Date: Mon, 16 May 2005 22
: `MY_XML_NODE_TAG' undeclared (first use this
function)
From: Bastian Balthazar Bux [EMAIL PROTECTED]
To: mel list_php [EMAIL PROTECTED]
CC: mysql@lists.mysql.com
Subject: Re: mysqlxml
Date: Thu, 12 May 2005 11:42:32 +0200
mel list_php wrote:
Hi guys,
I was trying to download the mysqlxml patch for mysql
Hi guys,
I was trying to download the mysqlxml patch for mysql 5.0 but didn't succeed
from the url:
http://d.udm.net/bar/myxml/mysqlxml.tar.g
does anybody know where I could find it?
Did anybody tried to use it or have any link to a doc/tutorial in addition
to the presentation of Alexander
I think that if you explode your words with AND it should work in any order:
SELECT * FROM table WHERE c LIKE '%word1%' AND c LIKE '%word2%' AND c LIKE
'%word3%';
but there's maybe something better to do!
From: Micha Berdichevsky [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Subject: LIKE
: Gordon [EMAIL PROTECTED]
To: 'mel list_php' [EMAIL PROTECTED], mysql@lists.mysql.com
Subject: RE: design: table depending on a column
Date: Tue, 12 Apr 2005 10:32:17 -0500
As long as articles.annotationID can be made distinct from
names.annotationID why not use 2 left joins.
You may have to test
When you mention external databses, I got curious. Do you mean external
as in not on that MySQL server? Or, do you mean external as in same
server, different database?
If you are designing your site correctly, the user should know nothing
about your data storage. That means that the user never
OK, just to make sure: ALL of the data actually resides within MySQL and
on the same server (regardless of it's original source)? That is good as
MySQL does not permit retrieving data from other servers in a query (yet).
So you have a table for the primary Model information, a second table for
Hi list,
I have a design problem, I'd like to know if there is a nice way to solve
it
I have elements that can be annotated, an annotation is basic info and a
link on an other database.
For example: my element id 3, called testElement, is annotated.
the annotation depends on the foreign
Hi list,
I'm using php/mysql, I was updating a table through phpmyadmin then I saw
that to update all the columns which type is declared to float the
developper of phpmyadmin have added a concat.
Something like:
UPDATE `tableInduction` SET `inductionType` = 'screening' AND CONCAT(
`volume` ) =
Hi,
I think you are looking for something like that:
ALTER TABLE auto_increment=1 (or whatever value you want)
melanie
From: Mário Gamito [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Subject: Resetiing indexes
Date: Thu, 24 Mar 2005 11:41:30 +
Hi,
I'm using MySQL on a project, and
Hi list,
I would like to search for something into one or several tables.
My first idea was to retrieve the tables' names, then for each of them
retrieve the columns' name and have a look in each of this column.
Is there a more elegant (fast) way to do that with mysql?
Somebody has some tips/doc
that is quite heavy. Maybe
for that field a fulltext index would be helpful?
Thanks for your help,
Melanie
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
CC: mysql@lists.mysql.com
Subject: Re: search through one/several tables
Date: Wed, 23 Mar 2005 10:44:53 +
mel list_php [EMAIL PROTECTED] wrote
in all the columns, a shortener for select * from dbLab where name
like'%Smith%' or fullName like '%Smith%' or adress like '%Smith%'.
But maybe this is not a good way to do things?
Melanie
From: [EMAIL PROTECTED]
To: mel list_php [EMAIL PROTECTED]
CC: [EMAIL PROTECTED],mysql@lists.mysql.com
(*) AS cnt FROM tbl_name WHERE cnt 0 GROUP BY id;
http://dev.mysql.com/doc/mysql/en/problems-with-alias.html
From: Peter Brawley [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
CC: mel list_php [EMAIL PROTECTED], mysql@lists.mysql.com
Subject: Re: search through one/several tables
Hi,
error 136 = No more room in index file
so I suppose it's a problem with the size needed for your keys, maybe that
will help:
http://dev.mysql.com/doc/mysql/en/key-space.html
HTH,
Melanie
From: CheHax [EMAIL PROTECTED]
Reply-To: CheHax [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Subject:
I wrong?
Anyway, thank you for all your advices, I'm really learning a lot of things
with that case!
Melanie
From: [EMAIL PROTECTED]
To: mel list_php [EMAIL PROTECTED]
CC: mysql@lists.mysql.com
Subject: Re: help on query/group by
Date: Fri, 18 Mar 2005 12:43:06 -0500
mel list_php [EMAIL
for your help, I will give temporary tables
an other chance!!!
Melanie
From: [EMAIL PROTECTED]
To: mel list_php [EMAIL PROTECTED]
CC: mysql@lists.mysql.com
Subject: Re: help on query/group by
Date: Wed, 16 Mar 2005 13:52:44 -0500
I have a favorite technique for improving the results of queries
it was maybe because I have other heavy stuff running, but I tried
a second time now and it's been running for 2 hours now, with almost nothing
else on the desktop.
So apparently the join between matches and the other tables is still too
heavy
Any idea?
From: [EMAIL PROTECTED]
To: mel list_php
Hi,
A friend of mine asked me to have a look at one of his query, and I'm
stuck
Here was his query:
SELECT drugID, protID, COUNT(DISTINCT pmid),
MAX(s1.syn) AS o1, MAX(s2.syn) AS o2
FROM matches
INNER JOIN synonyms AS s1 ON drugID=s1.nameID AND s1.syn LIKE 'a%'
INNER JOIN synonyms AS s2
From: S.Yousaf Shah [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Subject: MySql error...
Date: Tue, 8 Mar 2005 20:01:06 +0500 (PKT)
Hi,
I have installed mysql on my system using tar file. But when i start mysql
it generates following error and shuts down.
Plz help me
Hi,
Have a look in the error file which is in mysql/data and called hostname.err
to have more information on why it is shutting down.
With that info you usually can find more help on the mysql website.
Good luck!
From: S.Yousaf Shah [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To:
|
--
- Original Message - From: mel list_php
[EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Thursday, March 03, 2005 2:25 PM
Subject: mysql crash - innodb not starting
Hi,
I just have a crash of my mysql 4.1.5 .(the machine where it was running
just
[EMAIL PROTECTED]
To: mel list_php [EMAIL PROTECTED], mysql@lists.mysql.com
Subject: Re: mysql crash - innodb not starting
Date: Fri, 4 Mar 2005 15:50:26 +0200
Mel,
do
ps -fA
Do you see more mysqld processes?
If the ibdata1 file stays locked even though there is no mysqld process
Hi,
I just have a crash of my mysql 4.1.5 .(the machine where it was running
just shutdown)
Tried to restart it, and problem with innodb:
050303 11:58:46 [WARNING] Asked for 196608 thread stack, but got 126976
InnoDB: Unable to lock ./ibdata1, error: 11InnoDB: Error in opening
./ibdata1
050303
Hi Sam,
To shutdown mysql I just use mysqladmin shutdown.
http://dev.mysql.com/doc/mysql/en/server-shutdown.html
About you restart problem, have a look in mysql/data/host.err file, it
should give you a reason there.
Last time I had that problem it's because I hadn't kill all the process.
Good
Yeah, I have looked at it, but not sure whether I need to repopulate the
mysql.host db file. If I do that, I may be also need to recreate all db
passwords as well.
The error is:
InnoDB: log sequence number 0 43634.
InnoDB: Doing recovery: scanned up to log sequence number 0 43634
050302
Nobody to explain me that?
From: mel list_php [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Subject: mysql index cardinality
Date: Fri, 25 Feb 2005 16:47:12 +
Hi,
A strange thing with index, I thought the cardinality was automatically
updated (like for a primary key for exemple).
When I use
Hi,
A strange thing with index, I thought the cardinality was automatically
updated (like for a primary key for exemple).
When I use a primary key in a table, insert a row, the cardinality is
increased of 1 as well.
I just tried to do that with an INDEX, and the cardinality is none unless I
Be careful maybe you are mistaking here: the mysql root user as nothing to
see with the mandrake root user.
For exemple I lauch the mysql server as root from command line whereas I'm
just a user on my desktop.
So the mandrake root password and the mysql root password are also completly
If you want to compare the 2 tables you have to join them:
select * from listings, fake where listings.id=fake.id;
If you do your query SELECT * from listings where listings.id = fake.id; it
simply doesn't know where to get fake.id
From: Ed Curtis [EMAIL PROTECTED]
To: mysql@lists.mysql.com
what about your query returning all the users UNION your query returning
user 101?
SELECT U.User_ID,
U.User_Firstname,
U.User_Lastname
FROM Users U, Allocations A
WHERE (U.User_ID = A.User_ID)
AND A.Project_ID = '12'
AND ( U.User_Type = 'Staff'
OR U.User_Type = 'Manager'
OR U.User_Type =
Hi,
I think you can find all the information you are looking for there:
http://dev.mysql.com/doc/mysql/en/c.html
You have a description of all the functions :
http://dev.mysql.com/doc/mysql/en/c-api-functions.html
For example:
http://dev.mysql.com/doc/mysql/en/mysql-fetch-row.html
MYSQL_ROW row;
Would you mind giving me some additional explanation about outer join?
In the mysql reference book I just found one line saying left outer join
syntax exists only for compatibility with odbc.
thanks!
From: Michael Dykman [EMAIL PROTECTED]
To: Albert Padley [EMAIL PROTECTED]
CC: \MySQL List\
Hi,
I have one table tableNames ID,name, new_name. The columns ID and name are
populated. I would like to update the field new_name from an other table
tempName (ID,nameUpdated).
The ID between the 2 tables are the same, but I don't have the info for all
the ID. (so 568 rows in my first table
if anybody has a link to a doc for subqueries?
From: mel list_php [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Subject: subquery help for an update
Date: Wed, 16 Feb 2005 14:32:48 +
Hi,
I have one table tableNames ID,name, new_name. The columns ID and name are
populated. I would like to update
Hi!
I have a database where several users can connect and input data.
I managed to have my insert queries as atomic, but I was wondering about one
special case: I make one insert, and retrieve the last id inserted by mysql
because I need to update an other table with that id.
- if one user
To: mel list_php [EMAIL PROTECTED]
CC: mysql@lists.mysql.com
Subject: Re: last_insert_id
Date: Tue, 15 Feb 2005 10:50:40 +
mel list_php wrote:
Hi!
I have a database where several users can connect and input data.
I managed to have my insert queries as atomic, but I was wondering about
one special
-To: 'mysql@lists.mysql.com ' mysql@lists.mysql.com
To: mel list_php [EMAIL PROTECTED]
CC: mysql@lists.mysql.com
Subject: Re: last_insert_id
Date: Tue, 15 Feb 2005 10:50:40 +
mel list_php wrote:
Hi!
I have a database where several users can connect and input data.
I managed to have my insert queries
Poelvoorde [EMAIL PROTECTED]
Reply-To: 'mysql@lists.mysql.com ' mysql@lists.mysql.com
To: mel list_php [EMAIL PROTECTED]
CC: mysql@lists.mysql.com
Subject: Re: last_insert_id
Date: Tue, 15 Feb 2005 10:50:40 +
mel list_php wrote:
Hi!
I have a database where several users can connect and input data.
I
Hi list,
I have a very strange (and worrying..!!!) problem with my tables.
I'm running a 4.0.9 gamma (no choice for that) adn I had a MyIsam table with
an auto-increment field.
Everything worked fine friday, and today the auto-increment field is just
not working anymore.
When I want to insert a
additional test,
it is always bugging at the key 127...
I put a backup online, with until 106.
Added few test records, from key 127 it just doesn't want to increment the
auto-increment field anymore.
I'm completly lost here, any help would be greatly appreciated..
You should try to do a :
mysql_connect($host, $user, $password) or die(mysql_error());
to have an error message. It will be easier to find an answer from that I
think.As I told you if it's the password problem you will have Client does
not support authentication protocol for example.
From:
I'm not sure if it can be a password problem as you can connect through
command line,but when upgrading to 4.1 I had the classical access deny
error with phpmyadmin whereas everything else was ok.
You can still have a look there:
http://dev.mysql.com/doc/mysql/en/old-client.html
but I think in
65 matches
Mail list logo