r storage. I tuned out a bit during the
discussion and did not track what happened with it since but I guess that
any developments of that sort would be of interest to the Postgres community.
Some of these wish lists still need polish but could potentially be
discussed further at LSF/MM with a wider
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
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.mysq
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 CHARSET
s really worth spending the time on the installation form 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]>
T
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 (http://dev.mysql.com/doc/refman/5.0/en/charset-databa
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 s
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 t
ON_SCHEMA databases in MySQL 5.0.
mel list_php wrote:
> 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
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
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,
mela
You can use backticks ( ` ) to escape the names:
INSERT INTO `tickets` ( `id` , `from` , `departement` .
hth,
melanie
From: "Jeff" <[EMAIL PROTECTED]>
To:
Subject: Insert query problem
Date: Tue, 29 Nov 2005 11:42:34 -0500
All,
I can't get this query to run, it keeps compaining that the
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 pr
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 option
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 mu
'm doing
thanks 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.
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 +
H
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 proble
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 do.
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
DF, 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
viously defined
here
item_xmlfunc.cc:2523: error: `nodeset_func' undeclared (first use this
function)
item_xmlfunc.cc:2524: error: `args' undeclared (first use this function)
item_xmlfunc.cc:2525: error: `tmp_value3' undeclared (first use this
function)
item_xmlfunc.cc:2526: error: `pxml' unde
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 Bark
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 questi
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
the
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"
will be ok for the display of information?
Thank you very much for your time,
Melanie
From: "Gordon" <[EMAIL PROTECTED]>
To: "'mel list_php'" <[EMAIL PROTECTED]>,
Subject: RE: design: table depending on a column
Date: Tue, 12 Apr 2005 10:32:17 -0500
As
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 data
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 duri
id, COUNT(*) 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: s
th, the address or city containing Smithbasically look for the word
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
F
at 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 +0000
"mel list_php" <[EMAIL
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
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:
e columns in once, because that will automatically index each of
them?or am 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
n matches and the other tables is still too
heavy
Any idea?
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 09:14:02 -0500
Responses embedded below
"mel list_php"
n thank you very much 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 techn
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
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: mysql@list
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 m
From: "Heikki Tuuri" <[EMAIL PROTECTED]>
To: "mel list_php" <[EMAIL PROTECTED]>,
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
atopi.net/treeoctopus.html |
--
- 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 .(t
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
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 16:36:4
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 luc
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 e
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
up
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
Su
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
different
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 = 'Adminis
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;
un
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 Lis
e.
So 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
popul
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 on
me
advice...
From: Philippe Poelvoorde <[EMAIL PROTECTED]>
Reply-To: "'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 whe
ply-To: "'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
Yes that's what I mean I arranged to have single queries for the inserts.
For example I avoid doing a select on criteria to retrieve that id an then
an update of this id.
thanks for help!!!
From: Philippe Poelvoorde <[EMAIL PROTECTED]>
Reply-To: "'mysql@lists.mysql.com
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 inser
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..
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
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: Je
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
n
bind-ip=127.0.0.1 mentioned a few times as well, but I'm not sure if
this is needed if skip-networking is set, or if one over-rides the
other?
As you can probably tell, I'm on the new side to this, so any help or
advice is appreciated.
TIA!
Mel
--
MySQL General Mailing List
For list ar
67 matches
Mail list logo