So, my question is how can multiple values for a single
field get represented in a single row and receive the
benefits of an index? How can this data be represented?
Nice puzzle.
At first I thought it couldn't be done, given all your
constraints.
But there is one way.
You will have to build
lol of course
mysqldump -u username -p databasename databasename.sql
-Original Message-
From: Asif Iqbal [mailto:[EMAIL PROTECTED]
Sent: Saturday, June 28, 2003 3:08 PM
To: [EMAIL PROTECTED]
Subject: mysql database dump
Can I dump a database while the database is running in mysql ?
--
Now I have solved the problem I asked you to help me!
The problem was when to invoke mysql_install_db.
I invoked it before l let the daemon start, following the
instruction of a textbook on MySQL.
I have found in a magazine that I shoulld have run the
script after letting the mysql daemon
Hello,
I am able to start the mysql daemon with:
# [usr/local/mysql/bin] safe_mysqld
Then, on /var/lib/mysql appears the 'mysql.sock'.
But the problem is that I want the server running since I start my computer,
and not having to re-start every time.
And when I start my computer, there is no
6/27/03 6:37:49 PM, Jeremy Zawodny [EMAIL PROTECTED] wrote:
My read/update ratio would be something along the lines of 1:3, 3
updates for every read. So it is highly unusual, and more or less
rules replication out of the picture.
I'm unclear why you can't use replication for this. There must
Xavier Fern?ndez i Mar?n [EMAIL PROTECTED] wrote:
I am able to start the mysql daemon with:
# [usr/local/mysql/bin] safe_mysqld
Then, on /var/lib/mysql appears the 'mysql.sock'.
But the problem is that I want the server running since I start my computer,
and not having to re-start every
Bob Ramsey [EMAIL PROTECTED] wrote:
I'm using 3.23.51 and I'd like to update a field in a certain order. I've
got a table of images for a slide show and the format of the table is:
image varchar(128) not null
order_number integer not null primary key
So we might have something like:
Itoh-
Is the MySQL doc incorrect?
Please advise.
Martin
- Original Message -
From: Itoh Kohji [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, June 28, 2003 4:56 AM
Subject: Now I have solved my problem!
Now I have solved the problem I asked you to help me!
The problem
please don't top-post.
# [EMAIL PROTECTED] / 2003-06-27 14:01:58 -0400:
On Fri, 27 Jun 2003, Roman Neuhauser wrote:
# [EMAIL PROTECTED] / 2003-06-20 11:07:09 -0400:
I am trying to compile MySQL 3.23.57 on NetBSD 1.6.1. I downloadded
pthreads-1_60_beta6-mysql.tar.gz from your site
Hello,
I use mySQL on HP/UX 11.i - unfortunateley I am unable to lookup the
used version. What is the command to do that? (according to mysql.info
it is Version 3.23.42. )
Are foreign keys and referencial integrity supported by MySQL Version
3.23.42. ?
If yes - why is the second insert into
Well, the only thing that matters is that you are returning the same number
of columns with, presumably, the same data types in both queries. Obviously,
UNION wouldn't be helpful if you had 2 columns in the first query and 8
columns in the second.
I'll leave it to you to find the documentation on
Has any of the MySQL gurus here made any amendments to Oscommerce's DB structure
or added any tailored queries? I have custom made 26 shipping modules for
certain shipping specifications and now I have another one to cater for!
product category type. The problem with this is that the product
Hi,
I've three tables that my local MySQL server accepts, but when I try to
create the same three tables on my ISP's server, it doesn't work.
These are the three tables:
CREATE TABLE un_user
(
u_id INT PRIMARY KEY AUTO_INCREMENT NOT NULL,
u_uname VARCHAR(20) NOT NULL UNIQUE,
Hi,
I need to perform a query which deletes the selected
results from the table,
like
SELECT * from data where name='harsh' (here i want something to delete it
as well)
if its possible with single query...
thanks for help..:)
At 1:08 -0400 6/28/03, Asif Iqbal wrote:
Can I dump a database while the database is running in mysql ?
Yes. You can, for example, use the mysqldump program. mysqldump
is a MySQL client program that, like all MySQL clients, requires
the server to be running.
--
Asif Iqbal
Greetings,
I have installed MySQL 4.0.13 in a Windows 2000
machine. I am new to this and originally did the
install on a box that was secure from the internet and
ran some tests. I ran a forum software program and
also created a few databases on my own, all
successfully (although some
At 17:56 +0900 6/28/03, Itoh Kohji wrote:
Now I have solved the problem I asked you to help me!
The problem was when to invoke mysql_install_db.
I invoked it before l let the daemon start, following the
instruction of a textbook on MySQL.
I have found in a magazine that I shoulld have run the
At 18:11 +0200 6/28/03, anders thoresson wrote:
Hi,
I've three tables that my local MySQL server accepts, but when I try
to create the same three tables on my ISP's server, it doesn't work.
These are the three tables:
CREATE TABLE un_user
(
u_id INT PRIMARY KEY AUTO_INCREMENT NOT NULL,
At 21:40 +0530 6/28/03, harsh wrote:
Hi,
I need to perform a query which deletes the selected
results from the table,
like
SELECT * from data where name='harsh' (here i want something to delete it
as well)
if its possible with single query...
thanks for help..:)
It sounds as though you really
At 12:20 -0400 6/28/03, J.A. Jones Tyler III wrote:
Greetings,
I have installed MySQL 4.0.13 in a Windows 2000
machine. I am new to this and originally did the
install on a box that was secure from the internet and
ran some tests. I ran a forum software program and
also created a few databases on
- Original Message -
From: J.A. Jones Tyler III [EMAIL PROTECTED]
I have gone into the user table in mysql db and placed
both 'localhost' and '%' into the host entry. It was
my understanding that '%' would allow access from any
host for that particular username.
Well, I finally
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
Where are these instructions found?
Got em here :
http://www.analysisandsolutions.com/code/mybasic.htm#installation
snip
Yes, unless some other user table matches first, which may be
what is happening in your case.
Cool.
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
I have gone into the user table in mysql db and placed
both 'localhost' and '%' into the host entry. It was
my understanding that '%' would allow access from any
host for that particular username.
Yes, unless some other user
At 12:58 -0400 6/28/03, J.A. Jones Tyler III wrote:
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
Where are these instructions found?
Got em here :
http://www.analysisandsolutions.com/code/mybasic.htm#installation
snip
Yes, unless some other user table matches first, which
On Sat, Jun 28, 2003 at 06:14:07PM +1000, electroteque wrote:
lol of course
mysqldump -u username -p databasename databasename.sql
I am atempting to backup a database remotely. I added something like the
following.
mysql GRANT ALL PRIVILEGES ON db.*
- TO
Hello, I've got a situation I'm hoping someone here can help me out with. We
have a web server serving up data via some PHP programs pulling from MySQL
(3.23.56 currently) in INNODB tables. There are 40+ (active) databases
totalling a bit over 28 Gigabytes at this point. As we add more users speed
Help! I'm trying to do an insert statement where one of the fields sometimes contains
an apostrophe. The field type is a varchar. Everytime that one of these values comes
up with an apostrophe, it tells me there is an error in my SQL statement (obviously
because it thinks there are more
why don't you just insert your values after you escaped some special characters?
specifically, you have to replace all ' by \' (prepend a single backslash character),
and everything works fine!
i guess you do your INSERTs from out of some programming language, like PHP, Perl or
C. just use the
Maybe my question is too obvious but, since you have several databases
instead of only one, have you considered moving some of them to a
separate server ?
Also, have you checked MySQL replication capabilities ?
It is a very efficient way to distribute the load across several
servers unless you do
Well, the easiest thing is to escape any single quotes with a backslash
character (\). PHP includes a function named addslashes() that does this.
http://us4.php.net/manual/en/function.addslashes.php
Same logic applies in other languages.
Hope this helps.
Andrew
Help! I'm trying to do an
On Sat, Jun 28, 2003 at 11:35:54AM -0600, Jerry M. Howell II wrote:
On Sat, Jun 28, 2003 at 06:14:07PM +1000, electroteque wrote:
lol of course
mysqldump -u username -p databasename databasename.sql
I am atempting to backup a database remotely. I added something like the
following.
Recently, and pretty consistently our slave's relay logs have been getting
garbage that is not in the master. The symptom is usually a truncated
query with a few characters of garbage. The solution for now is to change
master to to the errored master bin log and position and have it start
thanks for help..:)
It sounds as though you really want something more like this:
DELETE FROM data WHERE name='harsh';
That will only result in deletion,I want it to be displayed
and simultaneously deleted.more precisely the effect of following
two commands in one
SELECT from data where
At 0:42 +0530 6/29/03, harsh wrote:
thanks for help..:)
It sounds as though you really want something more like this:
DELETE FROM data WHERE name='harsh';
That will only result in deletion,I want it to be displayed
and simultaneously deleted.more precisely the effect of following
two
Anyone know how to perform a left join by more than one field?
I have several tables I'm working with. An example query is like this:
SELECT tbl1.Name, tbl1.Location, tbl1.Case, tbl1.Class, tbl1.Type,
tbl3.Identity, tbl2.FileDate, tbl2.Status
FROM tbl2, tbl1 LEFT JOIN tbl3 ON tbl1.Case =
El Sb 28 Jun 2003 12:24, Zachary Perschall escribi:
Help! I'm trying to do an insert statement where one of the fields
sometimes contains an apostrophe. The field type is a varchar. Everytime
that one of these values comes up with an apostrophe, it tells me there is
an error in my SQL
Hey there everyone,
I'm trying to get a table of computer parts manufacturers populated with a list culled
from my distributor and I'm having a devil of a time getting anything to work. I'm
totally new to MySQL and don't really know my SELECT from a hole in the ground just
yet...which is
Dan Bowkley wrote:
Hey there everyone,
I'm trying to get a table of computer parts manufacturers populated with
a list culled from my distributor and I'm having a devil of a time
getting anything to work. I'm totally new to MySQL and don't really
know my SELECT from a hole in the ground just
Ahh, there's something I could have explained better. Each of the databases
represents a remote office of a different customer. I specifically want/need
to keep the data separate, it doubles as an offsite backup for these offices
as well as would conflict if it were merged. I currently use
hi!
i'm using mysql 4.0.13 from the standard freebsd 5.1 ports distribution,
and i keep getting repeated random table corruptions. the same thing
happens when building both with the native threading lib, and with
linuxthreads.
i figured it would be related to threading as it's always
OK, the picture is now a little bit simpler:
1. Your performance problem is coming mainy from one BIG database.
2. Although your servers have a lot of RAM (at least 4Gb), InnoDB
can only use a small fraction because of addressing limitations of
32 bits CPU.
Some random ideas:
1. Swith to a
I have some simple user quotas set to help balance my server load. I think
I've implemented them properly because people do whine to me when they
reach the query limit.
I have max_connections set to 200, but right now I'm watching connections
for 1 user scroll by at an alarming rate. 7800 in
At 12:29 -0700 6/28/03, Eric Kilgore wrote:
Anyone know how to perform a left join by more than one field?
I have several tables I'm working with. An example query is like this:
SELECT tbl1.Name, tbl1.Location, tbl1.Case, tbl1.Class, tbl1.Type,
tbl3.Identity, tbl2.FileDate, tbl2.Status
FROM
At 17:26 -0400 6/28/03, Gary Huntress wrote:
I have some simple user quotas set to help balance my server load. I think
I've implemented them properly because people do whine to me when they
reach the query limit.
I have max_connections set to 200, but right now I'm watching connections
for 1
Hi,
I am experiencing a problem creating temporary tables within a MySQL
database. When I run the following query:
CREATE TEMPORARY TABLE IF NOT EXISTS rmb AS SELECT * FROM rmmt GROUP BY
rmmtid;
drop table rmb
I get the error
[server] ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to
At 16:47 -0500 6/28/03, Phil Dowson wrote:
Hi,
I am experiencing a problem creating temporary tables within a MySQL
database. When I run the following query:
CREATE TEMPORARY TABLE IF NOT EXISTS rmb AS SELECT * FROM rmmt GROUP BY
rmmtid;
drop table rmb
I get the error
[server] ERROR 1044: Access
Very good question, I believe I do since it does work 90% of the time. Only
occasionally it doesnt work, and thats why I need help
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
To: Phil Dowson [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Saturday, June 28, 2003 4:50 pm
That works perfectly. Thank you.
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Saturday, June 28, 2003 2:42 PM
To: Eric Kilgore; [EMAIL PROTECTED]
Subject: Re: left join on more than one field
At 12:29 -0700 6/28/03, Eric Kilgore wrote:
Anyone know how to perform
Yes, I am referring to MAX_CONNECTIONS_PER_HOUR, poorly worded on my part
sorry.
Users are granted access to only one database (barring errors in my scripts)
and I did verify that his entry in mysql.user is 200 for max_connections.
And the connections in the logfile are for the same user each
At 18:15 -0400 6/28/03, Gary Huntress wrote:
Yes, I am referring to MAX_CONNECTIONS_PER_HOUR, poorly worded on my part
sorry.
Users are granted access to only one database (barring errors in my scripts)
and I did verify that his entry in mysql.user is 200 for max_connections.
And the connections
Thank you!
That gets me halfway there, and not to my surprise, it's not even that
hard! I should've known that it wouldn't be.
So the other part that I truly have no idea how to do the following:
UPDATE this_other_table
SET satus =
WHERE zipcode IN (result set from union query blow);
can
otherguy wrote:
That gets me halfway there
Does it? In your original question, you'd indicated that you only
wanted zips where *both* criteria were met -- enough CIRGs and enough
CILTs. By using a UNION, you'll be getting zips where *either* is met.
Bruce Feist
--
MySQL General Mailing
OK - one more freebie :-)
How about a TEMP table? You can create a temp table, fill it with the
results of your UNION statement and then JOIN it with this new UPDATE
query - that should get you what you need. Note that this is a workaround
for MySQL - in other DBRMS, you can use a sub-SELECT to
- Original Message -
From: Bruce Feist [EMAIL PROTECTED]
To: MySQL List [EMAIL PROTECTED]
Sent: Saturday, June 28, 2003 6:28 PM
Subject: Re: Advanced Query Help (My brain hurts!)
otherguy wrote:
That gets me halfway there
Does it?
Yes, it does.
In your original question, you'd
On Saturday, June 28, 2003, at 03:43 PM, MyLists wrote:
otherguy wrote:
That gets me halfway there
Does it?
Yes, it does.
No, I don't think it does, upon further consideration and testing... I
thought it did b/c I read, and misinterpreted the UNION
documentation
In your original
I regularly have users email me reporting that they've hit the max (usually
begging for me to raise or remove the limit)
An example (from this morning) is:
SQL Error : 1226 User 'algalord' has exceeded the 'max_questions' resource
(current value: 800)
I similarly do get reports of connection
I'm writing here in hopes of finding someone who uses this and might be
able to help me.
I am dealing with a recordset who's query is thus:
SELECT firstName, lastName, deptPOS, workPH, homePH, location, model,
make, propID, addressIP, OS FROM people, make, models, machines
WHERE
On Saturday, June 28, 2003, at 07:15 PM, Bruce Feist wrote:
otherguy wrote:
On Saturday, June 28, 2003, at 03:43 PM, MyLists wrote:
That gets me halfway there
BF: Does it?
No, I don't think it does, upon further consideration and testing...
I thought it did b/c I read, and
From: root [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: [mysql-test-run failure Mac OS X 10.2.6]
Description:
Using OpenJaguar distribution www.openjaguar.fr MySql runs
very slow
How-To-Repeat:
sudo perl mysql-test-run
Fix:
unknown
Submitter-Id: Robert D. Sharp
59 matches
Mail list logo