Hi!
The REPLACE + FOREIGN KEY behavior indeed changed between 4.0.17 - 4.0.18,
because the old behavior was wrong, according to the MySQL manual:
Fixed a bug: MySQL should not let REPLACE to perform internally an UPDATE if
the table is referenced by a FOREIGN KEY. The MySQL manual states that
I am running mysql 4.1.1 on windows using VC++ version 6. I am trying to
use the parameterized queries and so I need to call mysql_prepare. This
symbol seems to be in mysqlclient.lib but there are other symbols in
libmysql.lib that I need. Using both yields many multiply defined symbols.
Is
Hi
I am using mysql 3.23 have a table 'scores' with following structure
compint(11)
scoreint(11)
I have total 1 lakh rows
consider following sample data
compscore
~
10.25
22.5
2.1.7
10.1
30.9
10.3
I
Hi,
Can someone tell me why this query doesn't work?
SELECT IF(ISNULL(network.level), 4, network.level) AS level,
member.photo_level
FROM member
LEFT JOIN network ON (network.from_id=101 AND network.to_id=member.id)
ORDER BY member.last_login DESC
LIMIT 0,3
+---+-+
| level |
Dear ladies and gentlemen,
Upscene Productions is happy to announce a new beta of
the database developer tool:
Advanced Data Generator (public beta 3)
A fast test-data generator tool that comes with a library
of real-life data, presets and much more.
This new release consists of four versions:
Mulugeta Maru [EMAIL PROTECTED] wrote:
Can a field in one table be a foreign key of another table's field which is
also a foreign key of a third table?
Sure.
For example:
mysql CREATE TABLE t1 (
- id int NOT NULL default '0',
- PRIMARY KEY (id)
- ) TYPE=InnoDB;
Query OK, 0
Batara Kesuma [EMAIL PROTECTED] wrote:
Can someone tell me why this query doesn't work?
SELECT IF(ISNULL(network.level), 4, network.level) AS level,
member.photo_level
FROM member
LEFT JOIN network ON (network.from_id=101 AND network.to_id=member.id)
ORDER BY member.last_login DESC
Hi.
I haven't mysql enabled in php. How may I do it? I have php 4.0.4, mysql 3.23.36, both
installed on linux RH 7.3.
Thanks
Mic.
Hi.
I haven't mysql enabled in php. How may I do it? I have php 4.0.4, mysql
3.23.36, both installed on linux RH 7.3.
Install the php-mysql RPM.
-- Alex
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Please, reply to the mailing list, not to me directly.
Date: Sat, 14 Feb 2004 09:11:14 -0500
From: Rhino [EMAIL PROTECTED]
To: Egor Egorov [EMAIL PROTECTED]
Subject: Re: Newbie Question
Thanks Egor! I ran the query you suggested and it said 'NO' so the server
was apparently configured without
Hullos,
Am Montag, 16. Februar 2004 12:08 schrieb michele digioia:
Hi.
I haven't mysql enabled in php. How may I do it? I have php 4.0.4,
mysql 3.23.36, both installed on linux RH 7.3.
If u compiled php urself u may wanna do it again with:
--with-mysql=/PATH to mysql
If its a finished packet
Heikki,
Thank you greatly for answering my questions. Your obvious dedication to
the open source world and high-quality of software cannot be
understated.
Upon reading some of the InnoDB source code, I've noticed that C seems
to be your language of choice. That said, it seems more and more of
Hi all,
I have installed the MySQL 5.0.0a-aplha for Windows
Previously I have some Database in 4.0.17-max, to access
those database now from current version MySQL Server, I have
just Copy the C:\mysql\Data\myDB folder into current server's
Data file path. Is this enough to integrate thoes
php-mysql RPM is already installed. In any case, I downloaded last php
version. Now configuration requires both mysql and apache path to specify
in --with-mysql and --with-apache options. But what are these paths? Mysql
and Apache files are everywhere.
Thanks a lot.
Mic.
- Original Message
hi,
Thanks for prompt reply...
I have installed MySQL 5.0.0a-alpha for windows, the purpose
of my installation is to use the C API for prepared statements
I have searched it on 4.1.1 also, it don't have some API what i
have needed.
i.e, mysql_prepare,
mysql_bind_param,
How is 'next-key' locking correctly advertised as 'row-level' locking? I
don't actually see that InnoDB has row-level locking at all. Am I totally
wrong on that?
-James
Hi!
Next-key locking essentially doesn't work on rows - it works on indexes.
It ensures that phantom reads can't happen.
InnoDB does indeed do row-locking. In fact, it has one of the most
efficient representations of locks of any relational database.
Regards,
Chris
On Mon, 2004-02-16 at
Hi List,
Can someone explain the results below? It seems that MySQL has a hard
time choosing keys for 'or' searches. The example here is very simple
but reflects the more complex cases where lots of rows or joins are
used perfectly:
1) That's the table I have:
artikelnummer varchar(13) not null
Hi!
MySQL's optimizer has a slight problem. OR queries cause it to get very
confused.
Try the following to get the best performance:
Rewrite SELECT FROM table WHERE (condition1) OR (condition2);
As:
(SELECT FROM table WHERE condition1) UNION (SELECT FROM table WHERE
condition2);
Hope this
* Andre MATOS
Is it possible to allow one user to access MySQL using for
example PHP but stop him when he tried to access MySQL directly?
Yes, but only if the user does _not_ have shell access to your web/mysql
server or if you create a application-specific user table.
When you set up mysql
Hi,
I need to manage Innodb Tablespace very effectively from my application. To do that I
require clear picture of Innodb tablespace file and its organization. My application
needs to do the following
1. backup/restore of databases
While doing so should calculate the size of source
On 2004-02-16, at 14.13, Chris Nolan wrote:
MySQL's optimizer has a slight problem. OR queries cause it to get very
confused.
Try the following to get the best performance:
Rewrite SELECT FROM table WHERE (condition1) OR (condition2);
As:
(SELECT FROM table WHERE condition1) UNION (SELECT FROM
I've just inherited a mySQL server. It has 13
databases, 5-50 tables per database. The largest
table may have 10,000 records, but most tables are
much smaller.
What began as a test database server for a web
developer in one department, has now become a tangled
web of production databases, test
Michael D Schleif [EMAIL PROTECTED] wrote:
I have inherited several mysql v4x servers. All but one of them works
as expected with /root/.my.cnf files.
That last server is driving me nuts ; I have RTFM, and I do not find
this particular problem anywhere. Pointers to TFM are welcome.
#
On Feb 16, 2004, at 6:18 AM, Egor Egorov wrote:
Please, reply to the mailing list, not to me directly.
How many times do we have to see this sort of comment before the list
administrators realize that not setting the Reply-to: header to the
list address is doing the community a great
I'm confused. According to your note and to a passage I found in the manual,
InnoDB support is installed in all 4.0.x versions of MySQL, which should
obviously include my 4.0.11 install. Yet SHOW_VARIABLES LIKE 'have_innodb'
returned NO. Why? It would appear that I need to do something besides
Hello,
I am running two instances of mysql. They both run on different boxes, not networked.
Anyway, I have been developing on one machine, and trying to do a dump and keep the
other box updated with Database changes.
I have ran this from the dev box.
mysqldump --add-drop-table -u dbusername
To quote the words of an old song I second that emotion.
As the latest poster to fall into this trap, I just assumed that this list
worked like others to which I subscribe: the user simply hits Reply on the
post to which he is replying and the note goes to everyone on the list, not
just the
Michael D Schleif wrote:
I have inherited several mysql v4x servers. All but one of them works
as expected with /root/.my.cnf files.
Make sure /root/.my.cnf is owned by root, and mode 600.
That last server is driving me nuts ; I have RTFM, and I do not find
this particular problem anywhere.
Hello,
I am running two instances of mysql. They both run on different boxes, not
networked.
Anyway, I have been developing on one machine, and trying to do a dump and
keep the other box updated with Database changes.
I have ran this from the dev box.
mysqldump --add-drop-table -u
Hello again!
Andreas Pardeike wrote:
On 2004-02-16, at 14.13, Chris Nolan wrote:
MySQL's optimizer has a slight problem. OR queries cause it to get very
confused.
Try the following to get the best performance:
Rewrite SELECT FROM table WHERE (condition1) OR (condition2);
As:
(SELECT FROM
Rhino wrote:
To quote the words of an old song I second that emotion.
As the latest poster to fall into this trap, I just assumed that this list
worked like others to which I subscribe: the user simply hits Reply on the
post to which he is replying and the note goes to everyone on the list,
On Monday 16 February 2004 14:18, gerald_clark wrote:
Rhino wrote:
To quote the words of an old song I second that emotion.
As the latest poster to fall into this trap, I just assumed that this list
worked like others to which I subscribe: the user simply hits Reply on the
post to which he
Hi,
I like to use bit fields for status flag information, using a simple
attributes unsigned NOT NULL default '0'
column.
I used to use the set datatype for this, but
- there is no simple set a bit or turn off a bit function for the
set datatype (one has to use bitwise operations,
Mark Russell [EMAIL PROTECTED] wrote on 16/02/2004 13:41:52:
What began as a test database server for a web
developer in one department, has now become a tangled
web of production databases, test databases, and
abandoned databases for multiple departments. Of
course, the only
Dear Sir or Madam,
So far ( for my existing applications in Java ) I was using MySQL as my
primary DBMS.
I would appreciate if you could guide / advice me about the New MaxDB.
What is better to do ( for my New Programs ) ; keep using MySQL ?
Thanks
Christos
On Mon, 2004-02-16 at 09:07, Batara Kesuma wrote:
Hi,
Can someone tell me why this query doesn't work?
SELECT IF(ISNULL(network.level), 4, network.level) AS level,
member.photo_level
FROM member
LEFT JOIN network ON (network.from_id=101 AND network.to_id=member.id)
ORDER BY
Funny you should mention the totally excellent DBMail - I've deployed it
for quite a few of my clients.
The project I am working on is more of a sod off in the direction of
Exchange. I'm aiming for something collaborative, with a proper backing
store that's easily deployable and an original
Mark Russell wrote:
What began as a test database server for a web
developer in one department, has now become a tangled
web of production databases, test databases, and
abandoned databases for multiple departments. Of
course, the only documentation I have is a Post-It
note with the root password
its possible it was never installed for some reason. did you install the
mysql binary? you may simply be running on defaults. at any rate, i'm
willing to bet the farm that when you get your system configured right,
it will behave as you expect.
is there a permission problem that is not
Hi Diana,
SELECT IF(ISNULL(network.level), 4, network.level) AS level,
member.photo_level
FROM member
LEFT JOIN network ON (network.from_id=101 AND network.to_id=member.id)
ORDER BY member.last_login DESC
LIMIT 0,3
+---+-+
| level | photo_level |
Hi List,
why are subqueries so slow? Is this because their implementation is
still not optimized? Take for example the following queries and have
a look at the timing:
mysql select wordid from words where val = 'henning';
++
| wordid |
++
| 144005 |
++
1 row in set (0.00
When will Levenshtein algorithm be availble in mySQL? I know that there are some UDF's
but I find them awkward to install.
Is there a special reason that this isn't included in MySQL? Are there license fees or
what?
At least the algorithm seems most simple.
..Hakon
checkout http://www.dbmail.org
On Sun, 15 Feb 2004, Chris Nolan wrote:
Hi all,
I'm currently designing an open-source messaging server that will use
MySQL as the data store (in embedded form).
High performance is one of the goals of this project, so I have been
examining possible I/O
Hi List,
should I report the following as a bug?
mysql select count(*) from words as w1 where w1.val in (select w2.val
from words as w2 where w2.val like 'm%');
+--+
| count(*) |
+--+
| 3552 |
+--+
1 row in set (0.78 sec)
mysql select
Does it have exclusive and shared?
-James
-Original Message-
From: Chris Nolan [mailto:[EMAIL PROTECTED]
Sent: Monday, February 16, 2004 4:52 AM
To: James Kelty
Cc: [EMAIL PROTECTED]
Subject: Re: Locking
Hi!
Next-key locking essentially doesn't work on rows - it works on indexes.
It
Hi All,
A short question:
If I have a slave MySQL Server (updating via logs).
Supposing the master MySQL (for any reason) goes down.
The users start using (and updating) the slave database.
When the master MySQL goes up. Does it will update it´s data
from the slave database?
Thank´s
Ronan
Is there a way to set PACK_KEYS=1 on existing tables without doing a dump
and load?
I didn't find it in the ALTER TABLE syntax.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I noticed these files in my mysql data directory:
-rw-rw1 mysqlmysql 5242880 Feb 15 20:54 ib_logfile0
-rw-rw1 mysqlmysql10485760 Feb 15 20:54 ibdata1
-rw-rw1 mysqlmysql 25088 Jun 3 2003 ib_arch_log_00
-rw-rw1 mysqlmysql
On 16 Feb 2004 at 12:46, Bill Marrs wrote:
Is there a way to set PACK_KEYS=1 on existing tables without doing a
dump and load?
I didn't find it in the ALTER TABLE syntax.
It's there. alter_specification can be table_options, and
(looking at the CREATE TABLE syntax) table_options can be a
In the last episode (Feb 16), Bill Marrs said:
Is there a way to set PACK_KEYS=1 on existing tables without doing a dump
and load?
I didn't find it in the ALTER TABLE syntax.
It's there:
ALTER [IGNORE] TABLE tbl_name alter_specification [, alter_specification ...]
I am using MySQL (4.0.17) and am getting errors with the following SQL
statement originally writen for MS products.
SELECT
survey_questions.Question_ID,
First(survey_questions.Question_Text) AS FirstOfQuestion_Text, == this line
returns errors i believe it is the AS
Avg(survey_responses.Response)
well, somewhere the documentation for mysql indicates that you need
mysql-max in order to get InnoDB support. we made a special point of
making sure we got the mysql-max binary specifically because of InnoDB.
as far as upgrades on your platform, thats now out of my league. I don't
think I'm
I'm looking for the Cygwin-compiled ports of the Mysql tools mysql and
mysqldump. There is an old version on the Mysql site, but being that it
was compiled back in 1998, it does not function with the current versions of
Cygwin.
--
A.Clausen
--
MySQL General Mailing List
For list archives:
By it (in your first sentence), I assume you mean InnoDB as opposed to
MySQL. We've been using MySQL without difficulty for several months.
I just checked with the system admin and he says that he installed the
binary from an RPM. We are running Mandrake 9.1 - I thought we were using
RedHat
Greetings,
This is how the entry looks like in the mysql.user table. So basically,
root has all the global privileges.
| Host | User | Password | Select_priv |
Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv |
Reload_priv |
In a message dated 2/15/2004 4:39:00 PM Eastern Standard Time,
[EMAIL PROTECTED] writes:
I've got an iBook running gentoo and MySQL version 4.0.17 and it's on the
same router with my desktop running gentoo and MySQL version 4.0.17. I would
simply like to use the iBook as a mysql client and have
Hi,
I have an address table, and employee and customer
tables. I am thinking of adding an address_owner field
to the address table and use it as a foreign key
referencing both the customer_no and the employee_no
number. I have just done that on mysql, but I do not
feel that confident about it - is
here it is:
http://www.mysql.com/news/article-111.html
its also all over the mysql reference manual, especially in the InnoDB
tables section.
Rhino wrote:
- Original Message -
From: Jeff Mathis [EMAIL PROTECTED]
To: Rhino [EMAIL PROTECTED]; mysql [EMAIL PROTECTED]
Sent: Monday,
Are the binary logs in the same format? Are data types the same?
Thanks in advance,
David
I have spent some time in the past with mysql but am far from an
experienced database head. A while back I received a some mysql data
for a research project. The files are:
$ cd /usr/local/mysql/research1data
$ ls -lh
-rw-rw 1 mysql mysql 21G Jun 20 2003 oldreport_2002_12_08.MYD
hi, all.
i'm looking into the possibility of mounting my /var/lib/mysql directory
(or only some databases therein) on a AES128-encrypted loop partitition.
could anyone share his/her experience with that? is the performace-drain
tolerable (i'd reallt hate to switch to XOR 'encryption')? is this
Have you tried creating a table called 'oldreport_2002_12_08' following
the instructions on http://www.mysql.com/doc/en/CREATE_TABLE.html?
Bing
I have spent some time in the past with mysql but am far from an
experienced database head. A while back I received a some mysql data
for a research
Hi!
On Feb 13, Heath, Brad wrote:
Is this a legitimate variable? It seems like it'd be useful, but when
I tried it (on 4.0.12-nt and 4.0.17-nt) it didn't work. Anybody know
what's going on?
When it was added there was not possible to have a --server_variable that takes a
string as a value.
Thanks for the quick reply!
As root, I tried:
mysql use research1data;
mysql show tables;
+-+
| Tables_in_research1data |
+-+
| oldreports |
+-+
1 row in set (0.00 sec)
mysql CREATE TABLE oldreport_2002_12_08
Hi
I am not familiar with the syntax
mysql CREATE TABLE oldreport_2002_12_08 LIKE oldreports;
try
mysql CREATE TABLE oldreport_2002_12_08 as select * from oldreports;
to create populated copy
or
mysql CREATE TABLE oldreport_2002_12_08 as select * from oldreports where
1=2;
to create an
I would like to update a mysql database using mysqlimport, from a text file. Of
course new rows will be added, and I assume modified rows will be modified, but I
would also like to Delete rows in the DB that are somehow flagged for deleteion in the
text file.
I notice that in the
Thanks for the response. The syntax:
mysql CREATE TABLE oldreport_2002_12_08 as select * from oldreports
where 1=2;
wouldn't that just create an empty file? I need to get access to the
data in oldreport_2002_12_08.MYD using oldreports.frm.
$ ls -lh
-rw-rw 1 mysql mysql 21G Jun
Yes, that would create a new table (only the oldreport_2002_12_08.MYD file
will be zero, the MYI and frm files are not) which has exactly the same
definition of the table oldreports but without any data in it.
So make sure you have a good copy of both oldreport_2002_12_08.MYD and
It would be good as spaces between words are taking OR as the default, i
ave devised a system where the user selects the AND in the dropdown and if
they select that is will add a + to every word.
Hi!
On Feb 13, Heath, Brad wrote:
Is this a legitimate variable? It seems like it'd be useful,
O.k. I renamed oldreport_2002_12_08.MYD and oldreport_2002_12_08.MYI to
tempo.MYI and tempo.MYD.
Then I ran:
CREATE TABLE oldreport_2002_12_08 as select * from oldreports where 1=2;
And now I have:
$ls -lh
-rw-rw 1 mysql mysql 12G Jun 20 2003 tempo.MYI
-rw-rw 1 mysql mysql 8K Feb
Yes, it does. Both of the following statements give you the locks you'd
expect:
SELECT * FROM table WHERE id BETWEEN 4 AND 20 FOR UPDATE;
SELECT * FROM table WHERE id BETWEEN 40 AND 50 LOCK IN SHARE MODE;
Regards,
Chris
James Kelty wrote:
Does it have exclusive and shared?
-James
Hi Heikki, everyone,
Other than changing all my REPLACE INTO codes to UPDATE, does anyone have
a quick solution to this?
I have quite alot of code that makes use of what I thought REPLACE INTO
was supposed to be doing... so was hoping that someone has managed to come
up with some neat trick that
Where do I find information on how to move data from one table format to
another?
I have a phpnuke site that uses a certain Journal program, and we'd like
to use a new Journal program. Unfortunately, the tables and resulting
structure are not the same. And, since they don't use the same
I'm afraid this is a completly application-related question and not
MySQL one.
Migrating data from old table format to the new one should be done using
a specially made software for that (PHP, Perl, etc etc). You should read all
data from old tables and insert them in the new ones.
Yes, it is a new version, but unfortunately, there is no 'upgrade' script, yet. I was
just being a bit impatient. :)
Hopefully, it will pay off to be patient.
Thanks!
eric
-Original Message-
From: Leonardo Rodrigues Magalhães [mailto:[EMAIL PROTECTED]
Sent: Monday, February 16,
Hi there. I am trying to create a table using the
mysql control center but i am taking the error. Unable
to locate syntax.txt Please locate the file.
Any sugestion?
__
Do you Yahoo!?
Yahoo! Finance: Get your refund fast by filing online.
Hi,
If this possible in MYSQL (capability of procedure with
parameterized parameters).
Assume a procedure with parameters a1,a2,a3
test(a1,a2,a3)
begin
.
.
end
Can I call the procedure test by following way
call test(a2 = 5, a1 = 4, a3 = 7);
i.e changing the
Is it possible to query one server from another even if those servers are
in diferent machines at diferent locations?
for example:
select * from localtable left join remoteserver.remotedatabase.remotetable
where localtable.key = remoteserver.remotedatabase.remotetable.key
FBR
On Mon, Feb 16, 2004 at 11:54:43PM -0700, [EMAIL PROTECTED] wrote:
Is it possible to query one server from another even if those servers are
in diferent machines at diferent locations?
for example:
select * from localtable left join remoteserver.remotedatabase.remotetable
where
I dont think so :(
Karam
--- [EMAIL PROTECTED] wrote:
Is it possible to query one server from another even
if those servers are
in diferent machines at diferent locations?
for example:
select * from localtable left join
remoteserver.remotedatabase.remotetable
where localtable.key =
On Mon, Feb 16, 2004 at 02:41:30PM -0300, Ronan Lucio wrote:
Hi All,
A short question:
If I have a slave MySQL Server (updating via logs).
Supposing the master MySQL (for any reason) goes down.
The users start using (and updating) the slave database.
When the master MySQL goes up. Does
you'll need to create temporary tables in one of the servers based on the
results of the other and then join.
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, February 17, 2004 2:54 PM
Subject: Query to another server
Is it possible to query one server
You might be able to cheat and replicate the required database to the
local machine.
Regards,
Chris
Terence wrote:
you'll need to create temporary tables in one of the servers based on the
results of the other and then join.
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL
Prasad Budim Ram [EMAIL PROTECTED] wrote:
Hi,
If this possible in MYSQL (capability of procedure with
parameterized parameters).
Assume a procedure with parameters a1,a2,a3
test(a1,a2,a3)
begin
.
.
end
Can I call the procedure test by following way
call
To make it simple, is it possible to make function having many undecided parameters
with MySQL 5.0 stored procedure/function?
For example,
add(3)
add(3,5)
add(3,5,1,4,9)
add(3,5,1,4,9,8,6,7,2)
In C, we use pointer to handle this,
but I don't know how to code this at stored function CREATE
86 matches
Mail list logo
