In article [EMAIL PROTECTED],
Jeremy Zawodny [EMAIL PROTECTED] writes:
Using the query cache at all?
Not sure... I'm using the values for caches and whatnot from the
my-large.cnf in the distribution.
The my-large.cnf I'm looking at has a 16M query cache, but doesn't
explicitly turn it
Hi,
| BT-1034.02
mysql SELECT * FROM balloon_txt WHERE access_no = 'BT-1034.2';
I think you have a type .. instead of
SELECT * FROM balloon_txt WHERE access_no = 'BT-1034.2'
try
SELECT * FROM balloon_txt WHERE access_no = 'BT-1034.02'
HTH, Markus
- Original Message -
From: leegold
Hi everybody.
I generally try to parametrize out my queries as much as possible with
user-variables. So, say you have a general query for all users:
---
SELECT ...
FROM users
---
It's nice to do this:
SET @USER_ID:= NULL;
SELECT ...
FROM users
WHERE IF(@USER_ID IS NOT NULL,[EMAIL
Hi,
My old mysql is 3.23.56 on RedHat9(Intel). After moving mySQL to Solaris 9 (Sun
F280R/2GB Memory) and upgrading mySQL to 4.0.20, I got a lot of complaints about the
performance for select and update. Have anyone can tell me if there is anything I
should tune for Solaris or MySQL to improve
I know that I should use mysqlbug tool but it doesn't work.
Description:
MySQL C API mysql_next_result stalls in my program.
I'm using pthread and MYSQL handle is using in just
one thread.
I hacked into the source and found this call is
just same as mysql_real_query except it doesn't
send query
Hi,
Using the following query I am attampting to insert the Work_Type_IDs from
Work_Types WHERE Project_ID = 'x'. However I also wan to insert the
Project_ID into the table, how would this syntax work - apperently the
column count is incorrect...
INSERT INTO Letter_Templates (Work_Type_ID,
Shaun,
You need two columns for the insert, but you're only selecting one.
Try this:
INSERT INTO Letter_Templates (Work_Type_ID, Project_ID) SELECT
Work_Types.Work_Type_ID, Work_Types.Project_ID FROM Work_Types WHERE
Work_Types.Project_ID = 'x';
Andy
-Original Message-
From: shaun
Elmar and Madeleine von Muralt wrote:
Hi,
I'm completely new to MySQL and some of its concepts, therefore, these
questions may be very basic.
To connect to another database format I need the ODBC driver for that
other format - right?
I've built a repair job entry database on my Palm with
Good morning,
I need a MySQL database to be able to query a table in an Oracle database of
a remote host.
Is this possible? Could anybody tell me how to do it or where to find this
information?
Thanks in advance,
--Claudio
..
Hi All
My mysql data dir is filled up to 95% and only 345M left.
Here is the dir looks like
1.9Gibdata1
3.1Gibdata2
3.0Kib_arch_log_02
3.0Kib_arch_log_04
25K ib_arch_log_00
65M rt3
67K webrt.err
70K mysql
101Mib_logfile0
101M
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
( I apologize for duplicate message. Just for make sure the anti-spam
process)
To MySQL staff and developer's team:
At
http://www.ngn.euro6ix.org/IPv6/mysql
you will find a patch to make the last stable version on MySQL, (4.0.8)
ready to run
John:
I´m new to MySQL but I hope this could help.
Please read below.
Regards from Costa Rica
-Mensaje original-
De: John Mistler [mailto:[EMAIL PROTECTED]
Enviado el: Martes, 06 de Julio de 2004 09:55 p.m.
Para: [EMAIL PROTECTED]
Asunto: Re: DBF to MySQL
For some reason, the imported
I'm working with maxDB 7.5 and trying to figure out whether mySQL 4.0.x database files
can be read by it. I'm getting the impression we will need to run a sqlimport from a
mysql dump to get the data. Is this the case? Has anyone been successful in
migrating to maxDB from mySQL 4.0.x?
You may want to look into using a programming language such as C or Java
that communicates between both databases.
-Original Message-
From: Alonso, Claudio Fabian
To: '[EMAIL PROTECTED]'
Sent: 7/7/04 8:14 AM
Subject: How to query an oracle table from a mysql database
Importance: High
Hello:
This is my first time posting so bear with me. I have a Debian (woody)
server running a good sized database (7.2GB), Mysql 4.0.18. I am
running Apache 1.3.29 + perl and using mysql as the backend. Here's the
problem. I had the site up for weeks, with everything running
perfectly.
Good morning to all.
I have a very strange problem in my database and am trying to track down
whether it is a JAVA problem or a mySQL problem.
I have a table that is supposed to accept only unique data, however, at this
time, the PK for that information is set to the auto incrementing ID field.
Hi all,
I have 2 tables...one for keeping active items while the other is for older
records.
A housekeep program will come in every night to move some records (matching
several criteria from the active table to the history one.
I am currently doing SELECT, INSERT and then DELETE. i.e. a select
Try PHP, it has built in functions to access both DBs
HTH
Steve
Victor Pendleton wrote:
You may want to look into using a programming language such as C or Java
that communicates between both databases.
-Original Message-
From: Alonso, Claudio Fabian
To: '[EMAIL PROTECTED]'
Sent: 7/7/04
Are you saying that you are not receiving an Unique key violation when you
enter in duplicate data or you are relying on a value being present? If you
are using the later, do you have query caching turned on?
-Original Message-
From: Paul McNeil
To: MySQL General
Sent: 7/7/04 10:43 AM
At 20:55 -0700 7/6/04, John Mistler wrote:
For some reason, the imported information showed up as garbled nonsense.
The file I was importing was an .xls file. Do you know if there is another
TERMINATED BY I should be using? If not, I wonder how I can find out?
LOAD DATA will not, I think, read
Jeremy Zawodny [EMAIL PROTECTED] wrote:
So I haven't really done much to optimize things, as this seems like a
fairly light load. I'm running 4.0.20 on FreeBSD 4.8 (port build w/Linux
Threads).
Reliability and performance is not what you should expect to find in
FreeBSD 4.x. MySQL
Charles Sprickman [EMAIL PROTECTED] wrote:
The hardware is a dual Athlon MP-1600 smp box with 1GB of RAM.
BTW, user-level threads don't scale on more than one CPU. I.e. different
threads cannot run on different CPUs on FreeBSD 4.
--
For technical support contracts, goto
Thanks for the response.
There is currently no primary key on the field so I am relying on the data
being there, or not being there, to decide whether it is safe to insert the
new data.
Through MySQLCC, have_query_cache = YES. Is this the variable I am looking
for? What affect would this have?
michael johnson [EMAIL PROTECTED] wrote:
When trying to start mysql on a lx50 I get the following message:
Error 2002 Cannot connect to local MySQL server through socket
/var/lib/mysql/mysql.sock (111).
What can I do to resolve this problem pls?
Start MySQL or change the correct path to
C.F. Scheidecker Antunes [EMAIL PROTECTED] wrote:
Can anyone point me out what is going on wrong in this scenario?
The .err file in the datadir can give you a clue. Take a look at the end of it.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is
Steve et al:
If you want to do it right select a programming language such as Java or C++
There are enough good OOA/OOD folks out there that you will be able to pick
a good Java or C++
Engineer for the same price as PHP
Otherwise you will be adding on Disk Storage when your single threaded app
Hello Steve, hello Victor,
Thanks for your answers.
My PHP application needs to see this Oracle table, but as far as I could see
PHP has problems with Oracle 9.2.0. I got a conection problem and found in
the PHP's bug database that it isn't currently working.
As I'm familiar with PHP/MySQL, I'm
Robert Canary [EMAIL PROTECTED] wrote:
I am getting an error on my radius server asking
me to increase the number of sockets on mysql.
Probably you mean connections. Enlarge the value of max_connections variable.
You can write it in the /etc/my.cnf in [mysqld] section:
[mysqld]
I am using VB6 and ADO in conjunction with ODBC inorder to connect to a
MySQL database.
This is seems to be considerably slowing down my application.
Is there anyother mode of connecting besides ODBC - does anybody have any
experience with MyVBQL.dll or MYOLEDB - if so, please share your
Thanks to all who posted help. I found my error, in my code.
Sad sad pumpkin.
God Bless
Paul C. McNeil
Developer in Java, MS-SQL, MySQL, and web technologies.
GOD BLESS AMERICA!
To God Be The Glory!
--
MySQL General Mailing List
For list archives:
Q1: GROUP BY is the command that requests the SQL engine to aggregate
sets of rows based on values in common between those rows. Those columns
participating in the query that are NOT part of the aggregation key (the
key is composed of the columns specified in the GROUP BY clause) must have
some
Bruce,
It also depends on where the data is coming FROM as to what your options
are. Is the source data coming from another table (like, maybe from a bulk
import?) or from some kind of user input?
You CAN write it in one statement but I need to know your data source.
Yours,
Shawn Green
I am using Mysql on RH Linux 9. I am getting the following error.
Command and result are given below alongwith \s output for diagnostic
purposes.
I have created a dns database and am trying to create a user mysql user
dns with all privileges on it.
mysql use mysql
Reading table information for
Do the following commands, when run from an already-established
connection, actually have any bearing on anything?
SET SESSION wait_timeout=10;
SET SESSION interactive_timeout=10;
I am working on an application using the C API that needs to lock
tables while doing updates. This works fine
Hi,
I would like write a script to purge every nigth the master log with a cron
process. I need do it every nigth after load a lot of data into the master.
I know if i do 'show master status' i can see the file_name of the last log
file and then do -purge master logs to 'file_name'-. Is
darren wrote:
Hi all,
I have 2 tables...one for keeping active items while the other is for older
records.
A housekeep program will come in every night to move some records (matching
several criteria from the active table to the history one.
I am currently doing SELECT, INSERT and then DELETE.
Elmar,
The reason you could not find any documentation about how MySQL connects to
other databases is because MySQL does not connect to other databases
(except in the special case of replication between MySQL servers). What
you have is a program, Excel, contacting a database through an ODBC
Sanjay Arora mailto:[EMAIL PROTECTED]
on Wednesday, July 07, 2004 10:04 AM said:
I am using Mysql on RH Linux 9. I am getting the following error.
[snip]
Database changed
mysql GRANT ALL PRIVILEGES ON dns.* TO [EMAIL PROTECTED] IDENTIFIED BY
PASSWORD dns;
ERROR 1133: Password hash
What about getting a bigger drive?
Asif Iqbal wrote:
Hi All
My mysql data dir is filled up to 95% and only 345M left.
Here is the dir looks like
1.9Gibdata1
3.1Gibdata2
3.0Kib_arch_log_02
3.0Kib_arch_log_04
25K ib_arch_log_00
65M rt3
67K
We delete all binlogs over 7 days old.
We figure that if a slave gets that far behind, it is easier and faster to
restore last nights master backup and edit the master.info file on the
slave to
point to todays log file.
Luis Mediero wrote:
Hi,
I would like write a script to purge every
On Wed, Jul 07, 2004 at 07:42:46PM +0200, Luis Mediero wrote:
Hi,
I would like write a script to purge every nigth the master log with a cron
process. I need do it every nigth after load a lot of data into the master.
I know if i do 'show master status' i can see the file_name of the
gerald_clark wrote:
What about getting a bigger drive?
I guess that would be my only option eh?
Asif Iqbal wrote:
Hi All
My mysql data dir is filled up to 95% and only 345M left.
Here is the dir looks like
1.9Gibdata1
3.1Gibdata2
3.0Kib_arch_log_02
3.0K
Have you tried this other way of making an inner join?
UPDATE products_categories AS pc INNER JOIN products AS p ON pc.prod_id =
p.id
SET pc.prod_sequential_id = p.id
But that does not seem right our you could say:
UPDATE products_categories AS pc
SET pc.prod_sequential_id = pc.prod_id
and
No, that isn't possible using mySQL.
Try linking PHP with older client libraries (9.0.1,
8.1.5, etc) instead of the newer 9.2 libraries and see
if that fixes your problem with PHP. You can download
them from otn.oracle.com
swany
--- Alonso, Claudio Fabian
[EMAIL PROTECTED] wrote:
Hello
I got back from vacation today and I didn't see that anyone else has
responded yet so I figure that later is better than never ;-)
Your INSERT speed will be directly related to how fast all of your JOINS
can be accomplished. Your JOIN speed is related to two things: the size of
your tables
At 13:18 -0300 7/7/04, Alonso, Claudio Fabian wrote:
Hello Steve, hello Victor,
Thanks for your answers.
My PHP application needs to see this Oracle table, but as far as I could see
PHP has problems with Oracle 9.2.0. I got a conection problem and found in
the PHP's bug database that it isn't
This sounds like a shortcut optimization in the JOIN processor. Whenever
you write FROM tableA, tableB ... WHERE tableA.keyfield =
tableB.foreignkeyfield it has the same effect as writing FROM tableA
INNER JOIN tableB ON tableA.keyfield = tableB.foreignkeyfield. The engine
handles the comma
If you database contains time-based data you could age out old records. I
only need to keep data for 6 months so I run a nightly script to delete any
records more than 6 months old. And before anyone asks...yes, I also run
another script to ANALYZE/OPTIMIZE my tables.
Jack
-Original
On Wed, Jul 07, 2004 at 07:11:17PM +0300, Egor Egorov wrote:
Jeremy Zawodny [EMAIL PROTECTED] wrote:
So I haven't really done much to optimize things, as this seems like a
fairly light load. I'm running 4.0.20 on FreeBSD 4.8 (port build w/Linux
Threads).
Reliability and
Gee, how about just a little more coffee... ;-)
I meant, {long version}...
It could be the radius error is reflecting its
failure to connect to the database because the
database has no connections available. I found
the max_connection variable (default is 90) and
applied it to the safe_mysqld
LOCK TABLE active_table WRITE, history_table WRITE;
#assuming the columns in the tables are exactly
#the same
insert into history_table
select * from active_table;
delete from active_table;
UNLOCK TABLES;
if the columns aren't the same between the tables then
you need to do something like
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
on Wednesday, July 07, 2004 11:08 AM said:
Have you tried this other way of making an inner join?
no i did not because i did know you could do a JOIN on an UPDATE. thanks
for your suggestions i will try them out.
chris.
--
MySQL General Mailing
A custom MySQL UDF is one solution if you are comfortable with C.
Off list question:
What sort of `problem` does PHP have with Oracle 9i that is prohibiting you?
-Original Message-
From: Alonso, Claudio Fabian
To: 'Steve Davies'
Cc: ''[EMAIL PROTECTED]' '
Sent: 7/7/04 11:18 AM
Subject:
Are you using a DSN or DSN-less? Have you checked out mysqlvb.com?
-Original Message-
From: Greg Zimmermack
To: [EMAIL PROTECTED]
Sent: 7/7/04 11:27 AM
Subject: Drivers to use with VB6
I am using VB6 and ADO in conjunction with ODBC inorder to connect to a
MySQL database.
This is seems
At 22:34 +0530 7/7/04, Sanjay Arora wrote:
I am using Mysql on RH Linux 9. I am getting the following error.
Command and result are given below alongwith \s output for diagnostic
purposes.
I have created a dns database and am trying to create a user mysql user
dns with all privileges on it.
mysql
--- Asif Iqbal [EMAIL PROTECTED] wrote:
gerald_clark wrote:
What about getting a bigger drive?
I guess that would be my only option eh?
If any of your data can be considered history data
that is never modified, you could create compressed
myISAM tables for that data, removing it from the
Hello Victor,
For your off-topic question, my problem is the same as the one described
here:
http://bugs.php.net/bug.php?id=28680
I can't access using 9.2. They say 9.2 is too new for current PHP versions.
I'll install an older version of the Oracle client and try again.
If I can't do it I'll be
At 13:41 -0500 7/7/04, Robert Canary wrote:
Gee, how about just a little more coffee... ;-)
I meant, {long version}...
It could be the radius error is reflecting its failure to connect to
the database because the database has no connections available. I
found the max_connection variable
Is there a way to do an INSERT on a table only if no row already exists with
the same info for one or more of the columns as the row to be inserted?
That is, without using a method outside SQL?
Thanks,
John
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Hi all,
Please, do NOT send messages to a public mailinglist
as high priority by flagging the email itself. You're
sending this message to hundreds/thousands of people.
It might be important to you, but not for each
recipient. If someone has filters/triggers for important
email, he will get
Jack Coxen wrote:
If you database contains time-based data you could age out old
records. I only need to keep data for 6 months so I run a nightly
script to delete any records more than 6 months old. And before
anyone asks...yes, I also run another script to ANALYZE/OPTIMIZE my
tables.
But
Certainly, it's called making a unique index on the field(s) you want to keep
unique.
Hope that helps.
j- k-
On Wednesday 07 July 2004 12:48 pm, John Mistler said something like:
Is there a way to do an INSERT on a table only if no row already exists
with the same info for one or
Create a unique index on each column that you don't
want to be duplicated.
create UNIQUE index table_u1 on table(some_column)
--- John Mistler [EMAIL PROTECTED] wrote:
Is there a way to do an INSERT on a table only if no
row already exists with
the same info for one or more of the columns as
This is certainly the first step.
Also, if you want to insert only those rows which are not already present,
you can use something akin to:
INSERT INTO table1
SELECT * FROM table2 t2
LEFT JOIN table1 t1 ON (unique row identifiers -- whatever these are for
your data)
WHERE t1.XYZ IS NULL
Try insert ignore. Check the manual page for insert syntax.
On Wednesday, July 7, 2004, at 05:22 PM, Matt Chatterley wrote:
This is certainly the first step.
Also, if you want to insert only those rows which are not already
present,
you can use something akin to:
INSERT INTO table1
SELECT *
A week ago I posted that we were having horrible problems with MySQL's
replication failing and reconnecting (after years of reliable
operation). I still haven't come up with a solution to the problems, it
just looks like the master keeps tearing down the replication
connection, and the slave
I'm sure it did...DBF and XLS files are not plain text. What Chincilla gave
your was a bit of code for importing CSV files, after they had been exported
from Excel. I'm not sure *why* he gave you that code.
You can do one of two things. 1) Open up those files in Excel (it will also
open DBF
I am trying to figure out what my select statement should be to combine
both of these into one:
SELECT userid FROM Answers WHERE answer like Education%;
SELECT userid FROM Answers WHERE answer=Student;
Table Answers looks like:
-id int
-userid int
-answer text
for each row there would be
Paul,
Has this class worked properly in the past? Have you tried executing
the queries your class executes manually via the mysql client or a
similar application removing your Java code from the equation? Have
you run 'check table' if the table is either MyISAM or InnoDB?
On Jul 7, 2004, at
Jonathan,
I'm going to assume you want to match the answer fields in the way those 2
query examples do and that the qid field refers to the Question number.
SELECT
userid
FROM
Answers a1 JOIN Answers a2 ON
a1.userid = a2.userid
WHERE
a1.qid = 5 AND
You can do it one of two ways.. Either you can do a
self join like the following:
select t1.userid
from answers t1,
answers t2
where t1.qid = 5
and lower(t1.answer)='student'
and t2.qid = 6
and lower(t2.answer) like 'edu%'
and t1.userid = t2.userid
or you can use a union
Hi.
an OPS$ account in oracle lets a given user log in automatically to a
OPS$user-id account from the local machine without a password.
but not from another user-id on the same machine.
ie
[EMAIL PROTECTED] $ mysql -u ianh
would work
but
[EMAIL PROTECTED] $ mysql -u ianh
would not.
Does mysql
I am not certain from the documentation whether it is advisable to create a
unique multi-column index on two columns that are already individually
indexed. The individual indexes I assume I need for when I do a SELECT on
those particular columns. The multi-column one I need for the reasons
John,
As far as I'm aware there is no problem creating a multi-column unique index
on fields that have already been indexed seperately. The multi column index
will be used in situations where you are trying to find unique
_combinations_ of the two fields and the individual indexes in situations
Mitch,
the answer is the same as the last time: send me the FULL .err log gzipped.
Regards,
Heikki
- Original Message -
From: Mitch Pirtle [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Tuesday, July 06, 2004 3:50 PM
Subject: More semaphore mystery
Hi gang,
Back in
At 11:17 +1000 7/8/04, Ian Holsman wrote:
Hi.
an OPS$ account in oracle lets a given user log in automatically to
a OPS$user-id account from the local machine without a password.
but not from another user-id on the same machine.
ie
[EMAIL PROTECTED] $ mysql -u ianh
would work
but
[EMAIL
John,
Here is an example which should clarify for you:
INSERT INTO testTable (a,b) VALUES ('AVAL', 'BVAL');
Let's say testTable looks like this:
+-+
| a | b |
--|
| AVAL | EVAL |
| FVAL | BVAL |
+-+
You have your unique index over (a,b). The insert
At 19:26 -0700 7/7/04, John Mistler wrote:
I am not certain from the documentation whether it is advisable to create a
unique multi-column index on two columns that are already individually
indexed. The individual indexes I assume I need for when I do a SELECT on
those particular columns. The
Hello:
We are using mysql 4.0.17 on Linux
We have installed a mysql database on our our server. The data and log
files are stored on an external SCSI disk array which is connected to
our server using FC cable connected to SCSI port. The mysql process is
running on the local machine but the
Paul,
What about the case where column A is a foreign key?
In that case would you be forced to keep the index on
column A or could you use the A,B index since A is the
left most prefix?
Tripp
--- Paul DuBois [EMAIL PROTECTED] wrote:
At 19:26 -0700 7/7/04, John Mistler wrote:
I am not
Hello,
May I specify a column to auto increment in the Control Center UI,
either on or after creation?
thanks
Paul.
On Thu, 8 Jul 2004 [EMAIL PROTECTED] wrote:
When there is an accidental communication breakdown between disk array
and server on which mysql process is running (e.g, pulling out FC
cable), this is being detected by our scripts and then we are trying to
shutdown the mysql process by using
Charles,
Sometimes, the connection to disk array will not be available to this
server for long time and in such a case, we want another server to
connect to the disk array and run mysql processes. Unfortunately, from
our design, this cannot happen until the existing server shuts down.
I am
Hello,
May I specify a column to auto increment from within the Control
Center UI, either on or after creation?
thanks
Paul.
Is it possible to delete only a specific field on a table?
lets say i have.
table: dump
field:
- countid
- random
- name
countid, is an auto increment field
random, is a random words, etc
name, is a field for specifiying where they belong.
Now, how can i delete a specific data on each field?
From the manual
http://dev.mysql.com/doc/mysql/en/InnoDB_foreign_key_constraints.html:
In the referencing table, there must be an index where the foreign key
columns are listed as the first columns in the same order. In the
referenced table, there must be an index where the referenced columns
86 matches
Mail list logo