Greetings All,
Please have a look at the following query:
SELECT abm.mem_number, abm.first_name, abm.last_name,
abm.area_represented, abm.age, abm.sex, abm.cup,
ablb.*, ablb.jp + ablb.rc + ablb.fsmgp + ablb.gmc + ablb.saly +
ablb.nwgp + ablb.ecgp + ablb.sams + ablb.wcc + ablb.kzngp + ablb.emc
Schalk ,
You need to specify the unifying column between your ablb and abm tables.
ie - in your where, and ablb.id=abm.id
Once you get this so it returns expected results, you can run the query,
prefaced with
explain and it will give you an idea on the way mysql is running the
query. This
Hi Rithish,
I'm all out of ideas with this one, sorry I can't be of more help.
Perhaps Mr Tuuri or others with more nouse than myself can help.
Regards
---
** _/ ** David Logan
*** _/ *** ITO
Try to help
Please give us the ls -l result of this file, also make sure that the
owner of mysql process could read this file
how to test?
Try to su to mysql user, and try to open the file, using cat or
other command
If you can't, maybe parent directory is not permitted this user to read
,
When 5.0 came out, I saw an article or white paper or something with an
example of a stored procedure (I think, maybe a trigger) that allowed
you to transparently encrypt a column so that even if a database backup
was stolen, that column wouldn't be exposed to the thieves. I believe
that the
ls -l results for the file.
-rwxrwxrwx1 mysqlmysql5863636992 Feb 19 05:20
TBL_FORUM_MSG_BODY.ibd
Tried su to mysql user. able to cat the above file.
lsattr results for the file.
- TBL_FORUM_MSG_BODY.ibd
Hope that helps.
Regards,
Rithish.
-Original Message-
George Law wrote:
Schalk ,
You need to specify the unifying column between your ablb and abm tables.
ie - in your where, and ablb.id=abm.id
Once you get this so it returns expected results, you can run the
query, prefaced with
explain and it will give you an idea on the way mysql is running
If I compile mysql from sources with gcc 3.3.4 on linux 2.4 with glibc
2.3.2, how stable will mysqld be with lots (more than 500) of
simultaneous connections?
Does the issue described in the documentation for glibc 2.2 (big default
STACK_SIZE causes mysqld instablity) affect glibc
I'm in doubt. What binary (not RPM) should I choose for linux 2.4 with
glibc 2.3.2?
Actually, I believe that 'Linux (x86, glibc-2.2, standard is static,
gcc)' (mysql-standard-5.0.18-linux-i686.tar.gz)and 'Linux (x86)'
(mysql-standard-5.0.18-linux-i686-glibc23.tar.gz) will both
Rithish,
the table definition does not exist in the ibdata file. You have the
.frm file and the .ibd file, but that does not help if the table
definition is not stored in the ibdata file.
How did you end up in this situation? Did you move .frm and .ibd files
around? Did you recreate the
After some problem on the index of a tables defined therefore:
CREATE TABLE `artmain` (
`art_codice` varchar(22) character set latin1 collate latin1_bin NOT
NULL default '',
`art_descr` varchar(60) NOT NULL default '',
`art_suppl` int(8) NOT NULL default '0',
`art_origi` char(1) NOT NULL
Yoed Anis wrote:
Hi all,
I'm trying to do the following.
I have three table:
Table a has address information:
address_id | City | State | Zip
1Austin TX 78758
2 Dallas TX 77000
3 Galveston TX 77550
Table b has information about the location:
address_id | Location_id |
James Harvard [EMAIL PROTECTED] wrote on 02/22/2006
08:53:56 PM:
At 5:08 pm -0800 22/2/06, Scott Haneda wrote:
I think we are close, thanks
ERROR 1120: Cross dependency found in OUTER JOIN. Examine your ON
conditions
SELECT p.id, p.prod_name, sum(oi.quantity) as qty
FROM Products p
Schalk [EMAIL PROTECTED] wrote on 02/23/2006 08:55:01 AM:
George Law wrote:
Schalk ,
You need to specify the unifying column between your ablb and abm
tables.
ie - in your where, and ablb.id=abm.id
Once you get this so it returns expected results, you can run the
query,
Again, I implore all SQL coders to use the explicit JOIN syntax on all
platforms that support it (Oracle being a well-known exception). It makes
Oracle supports the ANSI JOIN syntax from v9 and up.
Shawn Green
As for the rest, I fully agree.
Martijn Tonies
Database Workbench - development
I am a novice when it come to queries such as this and was hoping someone
could help me write a query that tells me how many records have the same ID and
vendor number.
|ID | vendor_no | date|
|2354 | 578 | 2005-12-23|
|2355 | 334 | 2005-12-24|
Probably the problem is in php, or, more probably, in how you store first and
then look for the IP address in your query. You should try your query in the
mysql console; varchars work almost with anything and I put this example where
I look for an IP address with your table, and it finds it
I am a novice when it come to queries such as this and was hoping
someone could help me write a query that tells me how many records
have the same ID and vendor number.
|ID| vendor_no| date|
|2354 | 578 | 2005-12-23|
|2355 | 334 |
Richard,
If you mean with _both_ the same id _and_ vendor id, try this:
Select id, vendor_id, count(*) from tablename group by id, vendor_id;
If you just want separate counts for id and vendor_id, use:
Select id, count(*) from tablename group by id;
Select vendor_id, count(*) from tablename
Let's say I have a query that performs
select * from Account
one of the columns from Account (city) is actually a key which may
be either numeric or character.
There is a table called City which contains keys and names of cities.
and I want the City.Name value where Account.city matches
Where are the client libraries and such for the FreeBSD 4.x Build of MySQL
4.1.18? I downloaded the MAX binary yesterday, and tried to install it, but
none of the libmysqlclient files are present in the distribution.
Do I need to download the sources and build it, or are the client files
located
On Thu, 2006-02-23 at 10:49 -0600, Ariel Sánchez Mora wrote:
Probably the problem is in php, or, more probably, in how you store first and
then look for the IP address in your query. You should try your query in the
mysql console; varchars work almost with anything and I put this example
On Thu, 2006-02-23 at 09:28 -0800, Don O'Neil wrote:
Where are the client libraries and such for the FreeBSD 4.x Build of MySQL
4.1.18? I downloaded the MAX binary yesterday, and tried to install it, but
none of the libmysqlclient files are present in the distribution.
Do I need to
Yeah, I know about that... But the 4.1.18 client/server isn't there.. Only
4.0.7 or some such older version.
Thanks!
-Original Message-
From: Julian C. Dunn [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 23, 2006 9:39 AM
To: Don O'Neil
Cc: mysql@lists.mysql.com
Subject: Re: MySQL
You're right. It was a dumb cut-and-paste mistake.
LEFT JOIN orders as o
on o.product_id = p.id
If fixing this doesn't give the correct results: What's missing? What's
incorrect? Please help us to help you.
Orders does not have a product_id column.
Let me see if I can explain
Tim Johnson [EMAIL PROTECTED] wrote on 02/23/2006 12:26:35 PM:
Let's say I have a query that performs
select * from Account
one of the columns from Account (city) is actually a key which may
be either numeric or character.
There is a table called City which contains keys and names of
I's so sorry. You are very correct. The sample data is bad. ID should be
unique. Here it is corrected.
|ID| vendor_no| date|
|2354 | 578 | 2005-12-23|
|2355 | 334 | 2005-12-24|
|2356 | 339 | 2005-12-26|
|2357 | 339
Sorry - I am trying to cut back to just 2 pots of coffee per day and I the
lack of caffeine can make me a little fuzzy :-) Thank you for being
patient with me.
You have a working query, we just need to convert your INNER JOINs to
LEFT JOINs and move your join-specific WHERE conditions into
If you are looking just for duplicate (ID,vendort_no) combinations, this
will find them:
SELECT ID, vendor_no, count(1) as dupes
FROM table_name_here
GROUP BY ID, vendor_no
HAVING dupes 1;
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Richard Reina [EMAIL PROTECTED]
I hate remembering crap like this AFTER I hit send...
Because we want to limit our sum() to only those rows that match the ORDER
conditionals, we have to change our formula to recognized when to count
and when to not count an order_item.
SELECT p.id, p.prod_name, sum(if(o.id is
Actually I am looking for duplicates (vedor_no, date), but I think I can
hopefully adapt the solution you have given me.
[EMAIL PROTECTED] wrote:
If you are looking just for duplicate (ID,vendort_no) combinations, this will
find them:
SELECT ID, vendor_no, count(1) as dupes
FROM
* [EMAIL PROTECTED] [EMAIL PROTECTED] [060223 09:09]:
Tim Johnson [EMAIL PROTECTED] wrote on 02/23/2006 12:26:35 PM:
I need the most efficient way to do this: examples, keywords, and
URLs to relevant documentation are all welcome.
First off, columns can either be numeric or
Scott,
If you Left Join to o and oi, and add 'OR oi.product_id IS NULL) to the
WHere clause, I think you have it.
SELECT p.id, oi.prod_name, sum(oi.quantity) as qty
FROM products as p
LEFT JOIN order_items as oi
ON (p.id = oi.product_id)
LEFT JOIN orders as o
ON (o.id = oi.order_id)
WHERE (
Denis Solovyov wrote:
If I compile mysql from sources with gcc 3.3.4 on linux 2.4 with glibc
2.3.2, how stable will mysqld be with lots (more than 500) of
simultaneous connections?
Does the issue described in the documentation for glibc 2.2 (big default
STACK_SIZE causes mysqld
What are the permissions on the files? Which user runs mysql? If
you're not on Windows, is the case the same? When you type mysqld
--print-defaults (or whatever your mysql server binary is), what
directory shows up under datadir? Is it the same directory?
Sincerely,
Sheeri
On 2/23/06,
A simple search on google for
mysql fulltext indexing
provided many links, including:
http://jeremy.zawodny.com/blog/archives/000576.html
http://epsilondelta.wordpress.com/2006/02/08/dissecting-mysql-fulltext-indexing/
(overviews of how it works)
and
This is probably a simple question. I installed MySQL about a month ago
on Mac OS X and I am new to this. During the installation (as root) I
created a directory /var/mysql-data. Then, following the installation
instructions:
#chown mysql:mysql /var/mysql-data
#chmod 770 /var/mysql-data
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Walter Johnson wrote:
This is probably a simple question. I installed MySQL about a month ago
on Mac OS X and I am new to this. During the installation (as root) I
created a directory /var/mysql-data. Then, following the installation
Hi all...
I have some OLD programs I don't have the source for that were built with
the MySQL 3.23.55 client libraries. They still work great, even when using
those libraries to connect to 4.1.18 Mysql (I have a copy of the old lib in
the new lib dir)
However, is there some way I can build a
CodeHeads a écrit :
On Wed, 2006-02-22 at 16:49 -0600, Ariel Sánchez Mora wrote:
So far i've been able to store ip addresses as strings like you would
type them in DOS, for ex, '192.168.0.1'. This serves me great since my
application uses IP addresses as strings in all cases. I've done
Hi, there,
I am new to Mysql world, please forgive me if the question sounds dumb.
I am looking for if it is possible, that upon a record operation at the
database table, a event/notification is sent to a client process. The
database we are currently using implement this feature by post a
Dan Trainor wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Walter Johnson wrote:
This is probably a simple question. I installed MySQL about a month ago
on Mac OS X and I am new to this. During the installation (as root) I
created a directory /var/mysql-data. Then, following the
On Thu, 2006-02-23 at 22:04 -0500, Mathieu Bruneau wrote:
Ok I got 2 informations for you:
1) IPv4 address are actually 32 bit integer, easily store in 32 bits
fast search etc etc etc (You can google for more on this storage
format). Normally you could find a way to goes from the string
On Thu, 2006-02-23 at 21:46 -0600, Walter Johnson wrote:
#chown mysql:mysql /var/mysql-data
#chmod 770 /var/mysql-data
Try this, assuming the files are in there for the database.
$chown -R mysql:mysql /var/mysql-data/*
$chmod -R 770 /var/mysql-data/*
Hope that helps.
--
Best regards,
I have tried giving 777 permissions on the files. Nothing happens.
All mysql processes run as 'mysql' except mysqld-safe, runs as root.
I am not on Windows. All the table names are in upper case. I don't have the
lower case setting in my.cnf also.
The 'datadir' is /var/lib/mysql/ This is where
Hi,
How can I keep the account of MySQL independent in replication?
We have two MySQL 4.1.18 nodes: A and B. B replicate A. We want that the
account in A is independent. That is to said, it would not affect the
account in B when we add or delete the account in A.
We add the following option in
Hello.
The tables were working perfectly fine a week back. The database was created
from a sql file generated through the mysqldump utility. So there was
nothing wrong with the database. This irregularity happened this week
onwards.
Our system admins tell us that the server was restarted last
Now this query is run over two tables and the ab_members table
contains
around 302 rows. Around 1/3 of these will be where cup=kids.
However,
when this query is run it returns 20,700 results
That's because your ...
FROM ab_leader_board ablb, ab_members abm
calls for a cross join--it
Hello,
I read the manual(http://dev.mysql.com/doc/refman/5.0/en/mysqlhotcopy.html)
and especially:
Back up tables in the given database that match a regular expression:
shell mysqlhotcopy db_name./regex/
The regular expression for the table name can be negated by prefixing it
with a tilde
solved :)
Thanks :-)
Peter wrote:
Hello,
I read the manual(http://dev.mysql.com/doc/refman/5.0/en/mysqlhotcopy.html)
and especially:
Back up tables in the given database that match a regular expression:
shell mysqlhotcopy db_name./regex/
The regular expression for the table name can be
Sounds like you have any empty database, from the messages
below.
Try adding a new dummy database, and some test data.
See if you can do some selects on that test data.
Keith
In theory, theory and practice are the same;
In practice they are not.
On Fri, 24 Feb 2006, Rithish Saralaya wrote:
51 matches
Mail list logo