First: please don't hijack threads... And don't quote them completely
if you do.
I am new to MySql. Could you please let me know the different
migration tools avialable for the migration of oracle 7.3 database to mysql
4.0 classic version.
You could try the Schema Migrator tool in
hi!
how can i get all the foreign keys from a database? i used SHOW INNODB
STATUS; but i get an unknown error!
thanks!
--
G H Softwareentwicklung GmbH Tel.: +49(0)7451/53706-20
Robert-Bosch-Str. 23 Fax: +49(0)7451/53706-90
D-72160 Horb a.N.
Oropeza Querejeta, Alejandro wrote:
Hi,
I have one table that is presenting strange behaviour, we set the
varchar field for not allow nulls so, on 5% of the records the
application is inserting blanks but when we select the value and we set
the condition = it returns the same asand.
Hi,
Thank you for your response. Could any one give more clarification on the
alternatives for Views, Stored procedures, triggers and contraints of oracle in Mysql
4.0 classic, as MySql 4.0 classic wonot support the InnoDB storage engine.
Thanks,
Narasimha
-Original
Thank you for your response. Could any one give more
clarification on the alternatives for Views, Stored procedures, triggers and
contraints of oracle in Mysql 4.0 classic, as MySql 4.0 classic wonot
support the InnoDB storage engine.
Well, what other alternative do you have but
Hi,
how can i get all the foreign keys from a database? i used SHOW INNODB
STATUS; but i get an unknown error!
You can only get them on a per-table basis with a
SHOW CREATE TABLE tablename statement.
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird,
Re: Migration tools/plan from oracle 7.3 to Mysql 4.0With application code, I meant
that you:
- have to change your queries so that they include the full VIEW sql, because MySQL
doesn't have an alternative
- have to recreate your stored procedures in application code and do you work at the
Re: Migration tools/plan from oracle 7.3 to Mysql 4.0Hi Narasimha,
Please reply to the MySQL list instead of me personally only.
How we can write the equivalent code for triggers of
oracle in Mysql?. Shall we do it by using User Defined
Functions?. Can we use database queries inside the user
and how is a foreign key displayed? as KEY or FOREIGN KEY???
Martijn Tonies schrieb am 17.08.2004 12:24:
Hi,
how can i get all the foreign keys from a database? i used SHOW INNODB
STATUS; but i get an unknown error!
You can only get them on a per-table basis with a
SHOW CREATE TABLE
I had a similar problem, but my criteria for selecting the
value of f1 was different; it's a date field and I wanted
only the rows with the most recent date value in that field,
so only the latest of otherwise identical entries got inserted.
I ended up doing something like this:
create temporary
Still no solution on this
anybody have any ideas?
It's not network, or hard drive, it's got to be some type of bug in my
config files, attached in original email
The master is on 4.0.20a and the slave is on 4.0.20a
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
and how is a foreign key displayed? as KEY or FOREIGN KEY???
No, not at all - it's shown in the CREATE TABLE statement - have
a try at it yourself.
You need to parse the info from the text. You can also not create a
FK by name, InnoDB will assign a name to it. Changing an attribute
on your
If you are using MyISAM tables you can create a fulltext index. This index
should give you better performance over a wildcarded like search provided
that no more than fifty percent of your rows do not contain the word or
words you will be searching for.
-Original Message-
From: Eve Atley
I can't tell you how to combine these results into one long list but you
can use MS query to link an Excel worksheet (through an ODBC or OLEDB
driver) to a database. After you set up all of your links (each link is
database-specific and requires a query from you), all you would have to do
is
Hi everyone,
I have recently downloaded mysql version 4.0.20 for Windows and I'm trying
to develop a client application in c++ using Microsoft Visual Studio 6.0. I
am having a few issues. Note, neither of these problems occur if I install
on RedHat Linux 7.3:
1) My client will not compile
How about
INSERT INTO original_table
SELECT MAX(f1), f2, f3 FROM new_table GROUP BY f2, f3;
Michael
Stephen E. Bacher wrote:
I had a similar problem, but my criteria for selecting the
value of f1 was different; it's a date field and I wanted
only the rows with the most recent date value in
Hi,
I found out if I set query_cache_size = 32M to enable Query Cache,
interactive_timeout and wait_timeout will not be effected. It makes the connections
too many if the connections never timeout. How can I fix it?
Linda
Why did you quote an unrelated message?
Both GROUP BYs will produce one row for each unique combination of the
chosen columns. That is, the contents of the results will be identical.
MySQL automatically orders results by the grouped columns, so the ordering
of the resulting rows will differ
Martijn Tonies wrote:
Re: Migration tools/plan from oracle 7.3 to Mysql 4.0With application code, I meant
that you:
- have to change your queries so that they include the full VIEW sql,
because MySQL doesn't have an alternative
- have to recreate your stored procedures in application code and
We have successfully (and easily) installed multiple versions of MySQL on
Windows and are now trying to do the same on Linux.
We have a Fedora machine successfully running 4.1, but we want to add 5.0 to
it as well. We installed 4.1 with RPM, so it put a bunch of MySQL files all
over the place.
You'll probably want to have a look at section 5.10 in the manual:
http://dev.mysql.com/doc/mysql/en/Multiple_servers.html
Also, the mysqld_multi documentation may come in handy:
http://dev.mysql.com/doc/mysql/en/mysqld_multi.html
Cheers,
--V
Lou Olsten wrote:
We have successfully (and easily)
Paul,
Interesting: I just tested your DSN-Less connection info. (including
port 3307) from my web server to another machine running mysql and it
connected fine - but only the first time. I used the IP address for my
SERVER variable. Then I changed it to the FQDN and it failed with the
same
I don't know for sure, but I think I may have something wrong with
permissions in MySQL. I have some web forms from which I can add new data
and delete data. But when I try to do an update of existing data the data
is not actually changed. Is it possible that the permissions are not set
up
I think this is an easy question...I've set up a SQL statement like so:
SELECT resume.Section_Value, candidate.Location FROM resume, candidate WHERE
resume.Section_ID = '1' AND MATCH (resume.Section_Value) AGAINST ('html')
AND candidate.Location LIKE '%CA%' OR 'California'
--
The following behavior occurs in MySQL 4.0.20 with both InnoDB and
MyISAM tables. It happens on the prmary-key index as well as other
indexed columns. The behavior does NOT occur in 3.23.56 and 3.23.58.
This is just setup...
mysql select @x := 1;
mysql explain SELECT @x := IF(MAX(id) @x,
Are there any errors being caught by the web form or being logged to the
MySQL error log?
-Original Message-
From: Chip Wiegand
To: [EMAIL PROTECTED]
Sent: 8/17/04 11:29 AM
Subject: I can delete, add, but not update
I don't know for sure, but I think I may have something wrong with
Hi,
MySQL 4.0.16 running on Red Hat Linux release 8.0
with 4 Intel XEON 2.40 GHz with InnoDB tables.
This is the stack trace :
0x81077c6 handle_segfault + 474
0x4002a929 _end + 935891041
0x8272ff8 sync_array_print_long_waits + 580
0x81a7328 srv_error_monitor_thread + 96
0x40024ada _end +
You are joining two tables, resume and candidate. Without a join condition,
you get a Cartesian product, each row of the first table paired with each
and every row of the second table. (Some on this list would go so far as to
say that's not even a join.) You need to specify how rows in
These server settings are independent of one another. Query cache size
should not effect your *_timeout values. Can you post the my.cnf section
where these values are intialized?
-Original Message-
From: Linda
To: [EMAIL PROTECTED]
Sent: 8/17/04 10:10 AM
Subject: query_cache_size will
You have a cartesian join because you do not have join criteria between the
resume and candidate tables.
-Original Message-
From: Eve Atley
To: [EMAIL PROTECTED]
Sent: 8/17/04 12:22 PM
Subject: Assistance with SQL syntax: pulling duplicates back
I think this is an easy question...I've
Hi Eve,
You have made a very common mistake while using the comma-join method. I
think if I translate your implicit inner join to an explicit inner join
you will spot your own mistake:
SELECT resume.Section_Value, candidate.Location
FROM resume
INNER JOIN candidate
WHERE resume.Section_ID =
- Original Message -
From: Chip Wiegand [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 17, 2004 12:29 PM
Subject: I can delete, add, but not update
I don't know for sure, but I think I may have something wrong with
permissions in MySQL. I have some web forms from which
I am trying to run this query...
select distinct E.Title, E.ID, C.DateAdded from
Entries E, Comments C
where C.EntryID = E.ID
order by C.DateAdded desc
limit 10
...to get the last 10 entries that had comments added to them, but the
DISTINCT is not returning distinct results. What I get is 10
Eve,
From your earlier post, I see it should be
resume.Candidate_ID = candidate.Candidate_ID
===
I should also point out that there are several problems with your Location
matching. You have
candidate.Location LIKE '%CA%' OR 'California'
First, this evaluates as
Im having some difficulty with the perl DBI/DBD in conjunction with a MySQL
upgrade. Here's the situation:
On the DB server machine, i have MySQL 4.1.3beta running for testing
upgrading, but MySQL 4.0.2 is also running (production).
I can connect locally on the DB server through various
Ron Gilbert wrote:
I am trying to run this query...
select distinct E.Title, E.ID, C.DateAdded from
Entries E, Comments C
where C.EntryID = E.ID
order by C.DateAdded desc
limit 10
...to get the last 10 entries that had comments added to them, but the
DISTINCT is not returning distinct results.
I don't think the engine is messing up here. I think you are getting
exactly what you asked for and I will explain why I think that.
You are asking for 3 things from 2 tables:
Entries.ID
, Entries.Title
, Comments.DateAdded.
If Entry #1 was called My First Thread and
oops! - typing too fast for my own good. The fixed query should have been:
SELECT DISTINCT E.Title, E.ID, max(C.DateAdded) as maxdate
FROM Entries E, Comments C
WHERE C.EntryID = E.ID
GROUP BY E.Title, E.ID
ORDER BY maxdate desc
LIMIT 10
8-D
Shawn
[EMAIL PROTECTED] wrote on 08/17/2004 03:26:53
Hello, guys!
I'm just migrating to the new Quad AMD64 machine with Gentoo 2.6 kernel,
so I installed the standard 4.0.20 distribution for AMD64.
Everything is fine except /proc/stat shows that all threads use just
cpu0.
The server is under a valuable load - 'mysqladmin status' says 800
Sean,
Your diagnosis (paragraph 4) is correct, despite your efforts to talk
yourself out of it. DBI is independent, but DBD::mysql needs the mysql
client library. While you have upgraded to the latest DBI/DBD, you are
still using the mysql 4.0.2 client library which can't authenticate to your
Hi list, I am still very much a newbie so here goesI am still a bit
shaky on how to connect to dbs and general concepts so please excuse any
glaringly wrong statements..
If an application is developed in Oracle is there a special language for
development with Oracle dbs?
I understand
I have the same problem. I have an open bug report here:
http://bugs.mysql.com/?id=4761
I can't figure out why my management server can not see my ndb
servers. Perhaps I should try to down the secondary interface on all
the servers?
On Tue, 17 Aug 2004 15:54:29 -0400, Wheeler, Alex [EMAIL
Thanks, that did the trick.
On Aug 17, 2004, at 12:34 PM, [EMAIL PROTECTED] wrote:
mime-attachment
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Fri, Jul 23, 2004 at 05:37:08PM +0200, crandler wrote:
Hello,
the following problem occurs when I want to configure MySQL 4.1:
Building aclocal.m4
Running autoheader to build config.hin
Running autoconf to build configure
645046
644916
Building RPC client/server files
Building tags
Eve,
Best to keep threads on the list. Others may have better ideas, and future
readers may benefit.
The comparison
candidate.Location IN ('CA', 'California')
will match 'CA' and 'California', but will not match 'Cupertino, CA' because
it isn't either of those strings. To match that row as
Just a minor quibble: You don't need DISTINCT here, because the GROUP BY
will ensure distinct results. Probably just another fast-typing symptom.
Michael
[EMAIL PROTECTED] wrote:
oops! - typing too fast for my own good. The fixed query should have been:
SELECT DISTINCT E.Title, E.ID,
ROFLMAO -- Yep! It's been one of _those_ days!!!
Shawn
Michael Stassen [EMAIL PROTECTED] wrote on 08/17/2004 05:10:46
PM:
Just a minor quibble: You don't need DISTINCT here, because the GROUP
BY
will ensure distinct results. Probably just another fast-typing
symptom.
Michael
Just been using mysql for a couple of days, so this is possibly old ground,
but i have searched and can't find any solution. i'm sure it must have come
up before.
The project is to allow resources to be shared amongst community groups
throughout uk. there are a number of attributes that can be
G'day,
Trying to get a dump of a production database in mysql 3.23.54, mysqldump
version 8.22.
This is what I'm getting:
rack002:~# mysqldump -u root -p rt2 rt2.dump
Enter password:
mysqldump: Error 2020: Got packet bigger than 'max_allowed_packet' when dumping
G'day,
A different tack on my problem.
mysqldump is giving me the following error:
rack002:~# mysqldump -u root -p rt2 rt2.dump
Enter password:
mysqldump: Error 2020: Got packet bigger than 'max_allowed_packet' when dumping
table 'Attachments' at row: 36763
Hi Victor,
My server's connections seem never time out. Please tell me how to fix it.
The following is my.cnf:
# The following options will be passed to all MySQL clients
[client]
#password = your_password
port= 3306
socket = /var/lib/mysql/mysql.sock
# Here follows
Mike Blazer wrote:
In addition to my previous posting - on this machine I have glibc.2.3.2
which was installed using the Gentoo emerge native installer. Dunno, the
mysql manual says a lot about various bugs and patches for glibc (that
influence the threads behavior) but it is all up to 2.2.2. Not
At 12:14 +1000 8/18/04, Jens Porup wrote:
G'day,
Trying to get a dump of a production database in mysql 3.23.54, mysqldump
version 8.22.
This is what I'm getting:
rack002:~# mysqldump -u root -p rt2 rt2.dump
Enter password:
mysqldump: Error 2020: Got packet bigger than
'max_allowed_packet'
53 matches
Mail list logo
