try this:
selectwhere WHATEVER LIKE 'whatever%'
notice the '%' at the end not the beginning...hope this is what you
wanted...
lekker dag verder boet.
- Original Message -
From: Chris Knipe [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, August 18, 2002 5:54 AM
Subject: Re:
Hi List!
Hope you can help me with my problem...
I am trying to incorporate commit and rollback in my sql
statements... I have tried it in my web application which runs
on weblogic and it work fine. However, when I migrated my web
app to Tomcat, it failed to rollback when it encountered an
As in your instruction on 4 jul 2002 23:51:13 I added the
SET NO_FOREIGN_KEY_CHECKS=1;
after having installed 3.23.52 for WIN on my win2k system in the first line
of my shema dump (obtained with MYSQLDUMP -opt);
But wheh I lanch the command
mysql database file.dump
I received the following
Hi,
- WHERE CompanyDetails.CompanySuspended='0' AND
- CompanyDNSZones.ZoneName='megalan.co.za' AND
- CompanyDNSZones.ZoneServices LIKE '%HasMail%' OR
- CompanyDNSZones.ZoneServices LIKE '%HasMailingList%';
I explictly tell MySQL in my where clause to only return
As in your instruction on 4 jul 2002 23:51:13 I added the
SET NO_FOREIGN_KEY_CHECKS=1;
after having installed 3.23.52 for WIN on my win2k system in the first
line
of my shema dump (obtained with MYSQLDUMP -opt);
But wheh I lanch the command
mysql database file.dump
I received the
Hello everybody
I'm just getting mad with coldfusion, installed on a redhat platform running
mysql 2.1.0
Well, the problem occures when I try to create a data source, because I
always get this ERROR MESSAGE:
[]java.sql.SQLException: SQLException occurred in JDBCPool while attempting
to
Hi, this is probably a simple query but I tried all I can think of without finding a
solution.
I have three tables,
CREATE TABLE Answer (
AnswerID INTEGER NOT NULL AUTO_INCREMENT,
QuestionID INTEGER NOT NULL,
Value DECIMAL(15,4) NOT NULL,
AccountID INTEGER,
PRIMARY KEY (AnswerID)
)
___
MySQL version 4.0.1-alpha on Win 2000 Server SP2 Rus
___
# mysql config file.
# This will be passed to all mysql clients
[client]
#password=my_password
port=3306
#socket=MySQL
# Here is entries for some
Nicolas,
select a.AnswerID,a.QuestionID,a.Value,a.AccountID,p.FirstName,p.LastName
from Answer a left join Account c on (a.AccountID = c.AccountID), Person p
where c.PersonID = p.PersonID
Best regards,
Mikhail.
- Original Message -
From: Nicolas Ivering [EMAIL PROTECTED]
To: [EMAIL
Thanks for your reply. Unfortunately that query will not select rows
where Answer.AccountID is NULL which is what I wanted.
/Nicolas
Mikhail Entaltsev wrote:
Nicolas,
select a.AnswerID,a.QuestionID,a.Value,a.AccountID,p.FirstName,p.LastName
from Answer a left join Account c on (a.AccountID =
Nicolas,
select a.AnswerID,a.QuestionID,a.Value,a.AccountID,p.FirstName,p.LastName
from Answer a left join Account c on (a.AccountID = c.AccountID), Person p
where c.PersonID = p.PersonID
It won't work. Sorry.
select a.AnswerID,a.QuestionID,a.Value,a.AccountID,p.FirstName,p.LastName
from
Hi marco
In the administration page of coldfusion, usually something like:
http://domainName/CFIDE/administrator/index.cfm?target=/CFIDE/administrator/welcome.cfm
go to your data sources and click the edit button. THen click the show
advance settings button. Make sure that the Allowed sql
It worked! Thank you, you just made my day.
/Nicolas
Mikhail Entaltsev wrote:
Nicolas,
select a.AnswerID,a.QuestionID,a.Value,a.AccountID,p.FirstName,p.LastName
from Answer a left join Account c on (a.AccountID = c.AccountID), Person p
where c.PersonID = p.PersonID
It won't
On Fri, 16 Aug 2002, Frank Shute wrote:
I'm using 3.23.51 and I wondered if the manual was available as
separate pages of html in a tarball.
The manual as shipped is a single page and as this machine's dog slow
and takes an age to jump from one part of the manual to another,
I thought
- Original Message -
From: Heikki Tuuri [EMAIL PROTECTED]
To: Massimo Petrini [EMAIL PROTECTED]
Sent: Monday, August 19, 2002 12:52 PM
Subject: Re: new command in 3.23.52 - innodb database schema dump
Massimo,
it was changed to
SET FOREIGN_KEY_CHECKS = 0;
Please look at
Aleksandr,
thank you for the bug report. Please upgrade to 4.0.2.
From http://www.innodb.com/bugfixes.html:
February 10, 2002:
If one defines a non-latin1 character set as the default character set, then
definition of foreign key constraints may fail in an assertion failure in
dict0crea.c,
Massimo,
Monday, August 19, 2002, 10:40:50 AM, you wrote:
MP As in your instruction on 4 jul 2002 23:51:13 I added the
MP SET NO_FOREIGN_KEY_CHECKS=1;
^^^
Should be:
SET FOREIGN_KEY_CHECKS = 0
MP after having installed 3.23.52 for WIN on my win2k system
Kai,
Sunday, August 18, 2002, 1:53:32 AM, you wrote:
KV Just created a table with a column named client_nr that is a foreign key
KV referencing to my Clients table:
KV CREATE TABLE Contacts (
KV contact_nrint not null auto_increment,
KV first_namechar(30),
KV last_namechar(30),
KV
áÌÅËÓÁÎÄÒ,
Monday, August 19, 2002, 2:49:58 PM, you wrote:
áó ___
áó MySQL version 4.0.1-alpha on Win 2000 Server SP2 Rus
áó ___
áó # The MySQL server
áó [mysqld]
áó port=3306
áó #socket=MySQL
áó skip-locking
áó
Dan,
Saturday, August 17, 2002, 7:55:53 PM, you wrote:
DT I have a table where I have specified several columns which I have specified
DT that NULL values are not allowed.
DT I have created a PHP based create / update / delete page where users can
DT update the table.
DT I have an INSERT
krzychu,
Saturday, August 17, 2002, 5:49:35 PM, you wrote:
k I have a problem when I trying to start mysqld (as a root, under RH 7.2).
k Allegedly I don't have a rights to run this program...
k What I have to do to run mysqld without rebooting system?
You doesn't have permissions to run mysqld
David,
Tuesday, August 13, 2002, 4:48:20 PM, you wrote:
DB I've just a tiny question.
DB I used mysql 3.23.49 linux binary package but i've got some problems with
DB it.
DB I should upgrade quite shortly because 3.23.49 binary package is buggy
DB ... ).
DB We have load problems, memory eating
Hi:
Firstly, I'd like to congratulate both MySQL AB and
Mr. Mathews on making the JDBC driver an officialy
supported download.
I have a query though. Newer versions of the mm.mysql
driver (now called connector/j) will be released *not*
under the LGPL but under the GPL.
Now if I am using the
I'm not from an official source but I would imagine the reason for the
change of license is to be able to charge for a non-GPL version of the
driver. With that in mind it wouldn't make much sence if you could use
the driver with a non-GPL program without making the program GLP also
(and thus
Does anyone know if there is there any work continuing to be done on MyCC or
any other UI for MySQL? There are many things broken in MyCC and MySQL
navigator, such as indexes and foreign keys. While I believe that it can be
done with the command line, I would much rather do it with the GUI.
First thing I would do is update your mysql. That version is very old and
probably does not support a lot of stuff you are looking for. After that I
would go and download the newest JDBC drivers from:
http://www.mysql.com/downloads/api-jdbc.html
-Nick
marco said:
Hello everybody
I'm just
sql,query
Following are two CREATE TABLE statements. The second one fails because of
an error in the last line.
Does anyone know why?
Jim Bailey
STATEMENT #1
CREATE TABLE IIM_InventoryItemMaster(
IIM_InventoryItemMaster_ID MEDIUMINT(8) NOT NULL,
IIM_ItemNm VARCHAR(64),
IIM_ItemDescCD
I Have a problem with logining to MySQL with root. I am runnig Red Hat
Linu 7.3 and I just have installed MySQL 3.23.49 frjm the rpm package,
which I got with Red Hat Linux 7.3.
So I read documentation an made as following:
shell mysql_install_db
I tryed thi one
mysqladmin -u root drop
Hello,
I really hope that Red Hat hasn't changed the root default password to
something else.
Start mysqld with --skip-grant-tables parameter, then try your mysqladmin
command you were trying to execute. If it works then, your grant tables
are screwed up somehow.When you're running with
Hi,
I have tried to upgrade from MySQL 3.23.51 to 4.0.2-alpha (both source
distribution, same environment, same compiler, same configuration file)
and I was puzzled to see that my application became 5 to 10 times slower.
Most queries in my application (at least the critical part) are write
Dan Nelson wrote:
You cannot send signals to individual threads. Signals are delivered
to the process as a whole rather than to a thread. The only way to
kill a thread is from within the application itself. Mysql provides
the kill id command for this.
Thanks for your reply.
What could
Hi Sinisa,
No, this is actually quite correct for Linux, as tested so far.
How would those functions know than which request is being processed?
In multithreaded case argument is the only way.
Don't rely on testing -- bug gets a free ride in this case on i386.
Even if it works -- it may very
Hi,
If you are generating the id yourself a good strategy
is to use UUID that are #34;guaranteed#34; to be
#34;universally#34; unique. If you are developing
for the Microsoft platform, there is an API functions
that returns you a UUID and this number is guaranteed
to be unique.
If you are
Change your query for:
select red,green,blue from colorchanger INNER JOIN
jobattributekit ON colorcode = value where
attributekit = Color and jobnumber =
28200124RB4-001 and scenario=JN75K;
Also remember that MySQL does not allow sub-queries.
--- Amit Lonkar [EMAIL PROTECTED] wrote:
Hi all
how did you install them? rpm pkgs, source?
Scott Dix wrote:
mySQL,
How do I uninstall mySQL?
Scott
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Alex,
Monday, August 19, 2002, 3:38:07 PM, you wrote:
AM I Have a problem with logining to MySQL with root. I am runnig Red Hat
AM Linu 7.3 and I just have installed MySQL 3.23.49 frjm the rpm package,
AM which I got with Red Hat Linux 7.3.
AM So I read documentation an made as following:
AM
Randy,
Sunday, August 18, 2002, 10:57:54 AM, you wrote:
RJ I am using innodb tables via mysql max
RJ if i do a select * for update
RJ and then do an update statement
RJ will this unlock the record for another update or will it wait for me to do
RJ a commit?
It will wait for
Matt,
Monday, August 19, 2002, 3:03:07 PM, you wrote:
MH Does anyone know if there is there any work continuing to be done on MyCC or
MH any other UI for MySQL? There are many things broken in MyCC and MySQL
MH navigator, such as indexes and foreign keys. While I believe that it can be
MH done
Harald,
Friday, August 16, 2002, 5:46:20 PM, you wrote:
HF In article [EMAIL PROTECTED],
HF Victoria Reznichenko [EMAIL PROTECTED] writes:
Harald,
Thursday, August 15, 2002, 4:02:44 PM, you wrote:
[skip]
HF According to the manual, LOAD_FILE returns NULL if the file is too
HF large, but
Excellent info... thanks... (a little late response, but there was no net access in
the woods... :P)
Thanks again!
---
Jason H. Frisvold
Senior ATM Engineer
Engineering Dept.
Penteledata
RedHat Engineer - RHCE # 807302349405893
Cisco Certified - CCNA # CSCO10151622
In the last episode (Aug 19), Reid Sutherland (mysql) said:
Dan Nelson wrote:
You cannot send signals to individual threads. Signals are
delivered to the process as a whole rather than to a thread. The
only way to kill a thread is from within the application itself.
Mysql provides the
Hi, folks!
I would apreciate your opinion on my question:
How to make a MyISAM table (or several tables) to be shared among different
databases served by one MySQL server on Unix (Solaris)? It is OK if this table
appears as a read/write table in one database only, other DBs access it
read-only.
Some ficticious data
ID Data1 Data2 Data3
1 1 141 1
2 5 140 1
3 4 142 1
4 3 141 1
5 2 142 1
6 5 142 1
7 7 140 1
8 2 143 1
9 3 142 1
10 3
Hi,
I tried using the mysqlbinlog from 3.23.52 MAX with no difference in the
output at all from 4.0.2
It seems that whatever happened truely caused the log files to become
corrupted
So my next question would be, is there a way to repair the log files? What
are the formating rules for the log
Is there any way I can do something like this other than
create a little script to do it programatically?
UPDATE interests_shipping_conditions_master SET
interests_master_record_num = interests_master.record_num WHERE
interests_shipping_conditions_master.interest_name =
I suppose I should have specified that I would not be able to filter by Data1
-Original Message-
From: Mary Stickney [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 19, 2002 11:52 AM
To: Luc Foisy
Subject: RE: Query Question
select * from xxx
where data2 141 and data3 = 1
On Sunday 18 August 2002 04:17 pm, Rick Robinson wrote:
Hi all,
I'm testing using a HEAP table to maintain transient state in a high
volume TP environment. So far, it looks promising, and I want to ask
anyone about similar experiences and solicit some input.
Some background:
* I have one
What have you tried?
What did you get?
Why is it not what you expected?
Luc Foisy wrote:
Some ficticious data
ID Data1 Data2 Data3
1 1 141 1
2 5 140 1
3 4 142 1
4 3 141 1
5 2 142 1
6 5 142 1
7
Antoine,
Monday, August 19, 2002, 3:57:50 PM, you wrote:
A I have tried to upgrade from MySQL 3.23.51 to 4.0.2-alpha (both source
A distribution, same environment, same compiler, same configuration file)
A and I was puzzled to see that my application became 5 to 10 times slower.
A Most queries
Chris,
Monday, August 19, 2002, 6:50:29 PM, you wrote:
CB Is there any way I can do something like this other than
CB create a little script to do it programatically?
CB UPDATE interests_shipping_conditions_master SET
CB interests_master_record_num = interests_master.record_num WHERE
CB
Hi,
I have to import some data in Mysql from a Sybase bulk
copy (bcp) text files, and I have some problems with
date type format fields.
The sybase db has datetime fields and in the
dump file the date format is like this:
Mar 3 1999 12:00:00:000AM
I have created a table with the same
Why cant you filter on Data1?
I meant
select * from xxx
where data2 141 and data3 = 1 and (data1 = 7 or data1 = 5
or data1 = 2 or data1 = 4)
groupby data1
-Original Message-
From: Luc Foisy [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 19, 2002 10:51 AM
To: MYSQL-List (E-mail)
On Monday 19 August 2002 07:21 am, Nicolas Ivering wrote:
Several things spring to mind here...
1st of all when you use JDBC, you're coding to the JDBC interface, not to any
proprietary interface (IE, your application could just as well call a
PostgreSQL JDBC driver and it would not need to
sql,query
While working with record level locking on innodb tables we noted some
behavior that has us a bit befuddled.
The problem, in its simple form, is that I have two processes accessing the
same table. Process A does the following:
begin;
select * from table1 for update limit 5;
Now
On 19 Aug 2002, at 11:32, Luc Foisy wrote:
IDData1 Data2 Data3
1 1 141 1
2 5 140 1
3 4 142 1
[snip]
For my return I only want a single instance of Data1, so it will
most likely need be GROUP BY Data1
I would like those records to include
I wrote:
Maybe something like this?
SELECT Data1
FROM table_name
WHERE Data3 = 1
GROUP BY Data1
HAVING SUM(Data2 = 141) = 0;
Actually that doesn't make sense. I was thinking of the case where
there's a left join involved. In your case, it should just be this:
SELECT
That would filter out the records containing 141 before it did the group by
That would mean I could get a group that had 141 in it
4 3 141 1
9 3 142 1
103 143 1
So, here it would not event look at record 4, then it would return me a group that
Because I don't know what Data1 is, thats the result I want to find
-Original Message-
From: Mary Stickney [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 19, 2002 12:10 PM
To: Luc Foisy; MYSQL-List (E-mail)
Subject: RE: Query Question
Why cant you filter on Data1?
I meant
Thanks for your reply, is it documented somewhere?
Randy
- Original Message -
From: Victoria Reznichenko [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, August 19, 2002 10:07 AM
Subject: Re: Transaction Question
Randy,
Sunday, August 18, 2002, 10:57:54 AM, you wrote:
RJ I
Hi,
You can try something like this :
select (CASE WHEN Data2141 THEN Data1 END) from your_table where Data3=1
group by Data1;
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
The mysql datetime will have to be
'1999-03-03 12:00:00'
or
1999030312
Maurizio Danilo wrote:
Hi,
I have to import some data in Mysql from a Sybase bulk
copy (bcp) text files, and I have some problems with
date type format fields.
The sybase db has datetime fields and in the
dump file
I wrote:
Actually that doesn't make sense. I was thinking of the case where
there's a left join involved. In your case, it should just be this:
SELECT DISTINCT Data1
FROM table_name
WHERE Data3 = 1 AND Data2 141;
Ignore that correction. It seems that what you want is indeed
i need help with getting started with mysql
i am a java programmer but have not done any database
stuff. i assume that mysql can be a good db to start
with java database programming ie jdbc stuff.
would you also say that mysql would be a good db to
start and learn with jdbc ? can some one let
Hi.
On Mon 2002-08-19 at 17:29:49 +0200, [EMAIL PROTECTED] wrote:
Hi, folks!
I would apreciate your opinion on my question:
How to make a MyISAM table (or several tables) to be shared among different
databases served by one MySQL server on Unix (Solaris)? It is OK if this table
appears as
Do you use so huge queries that you really need sort_buffer=64M and
record_buffer=32M? Don't forget that record_buffer and sort_buffer are
specified per-thread.
I don't know exactly which values I need, but when I generate statistical
data from the tables it often spans a not-so-small
Hi!
On Aug 19, Benjamin Pflugmann wrote:
Hi.
On Mon 2002-08-19 at 17:29:49 +0200, [EMAIL PROTECTED] wrote:
Hi, folks!
I would apreciate your opinion on my question:
How to make a MyISAM table (or several tables) to be shared among different
databases served by one MySQL server on
Try the sun site - www.javasoft.com
I believe there are tutorials for JDBC.
Cheers,
Michael
-Original Message-
From: john greene [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 19, 2002 10:28 AM
To: [EMAIL PROTECTED]
Subject: getting started
i need help with getting started with
On Mon, Aug 19, 2002 at 10:55:32AM +0200, Thomas Spahni wrote:
On Fri, 16 Aug 2002, Frank Shute wrote:
I'm using 3.23.51 and I wondered if the manual was available as
separate pages of html in a tarball.
The manual as shipped is a single page and as this machine's dog slow
and
You might want to lookup MySQL and RAID. MySQL does support a database
RAID setup. This confused me early on because I kept thinking of disk
based RAID, but this is database based RAID. I haven't used it yet, so
I can't help you any more that that. Hope it helps a little.
On Thursday,
Hi again,
Do you use so huge queries that you really need sort_buffer=64M and
record_buffer=32M? Don't forget that record_buffer and sort_buffer are
specified per-thread.
Well, some further input about this as I've just tried at home
(MySQL 4.0.1-alpha-nt). You seem to be right :
On Mon, Aug 19, 2002 at 02:54:02PM -0400, Brent Baisley wrote:
You might want to lookup MySQL and RAID. MySQL does support a
database RAID setup.
If you change support to provide, I'd agree. We use MySQL on RAID
systems all the time, so it certainly supports it.
Jeremy
--
Jeremy D. Zawodny
The raid function is not useful (that's to get around the 2GB filesize
limit on certain OS). I think it's a misleading function (I think it
should be called RAIF - Redundant Array of Inexpensive Files).
I use RAID 1 (hardware) scsi and my load looks to be processor bound
(believe it or not)
Yes that's it, Thanks!
Ignore that correction. It seems that what you want is indeed this:
SELECT Data1
FROM table_name
WHERE Data3 = 1
GROUP BY Data1
HAVING SUM(Data2 = 141) = 0;
[Filter fodder: SQL]
Luc
Hi all,
I manage a web server having a lot of http connections, using
Apache/PHP/MySQL. When there are too many simultaneous connections (so, many
MySQL requests), MySQL stops working efficiently and makes my load average
increase a LOT (already seen it at 100 !). The only way to make it
red hat linux implementations by default would have
the mysql database ? ie if i install the server
version of redhat linux then i get mysql database as
well. right ?
any tips whemn using/configuring/installing mysql
database with redhat linux.
I wasn't aware of this. I thought the Red Hat database was PostgreSQL.
--Walt Weaver
Bozeman, Montana
-Original Message-
From: john greene [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 19, 2002 2:32 PM
To: [EMAIL PROTECTED]
Subject: mysql comes with linux ?
red hat linux
I have a SQL statement to create a PostgreSQL table that include a line 'id serial'
This line creates a integer field with a sequence atached to it to create an autonumber
Is there a way to create a SQL statement to accomplish this that would work with
both MySQL and PostgreSQL
I don't know if it is installed by default or not (in most distros it is
not), but checking is easy enough: When you get to the point of selecting
packages, click on the choose individual packages button or radio box
(it's been a while since I have done a RH installation) and select MySQL and
I believe it has both. Mandrake I know has both.
-Original Message-
From: Weaver, Walt [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 19, 2002 1:40 PM
To: [EMAIL PROTECTED]
Subject: RE: mysql comes with linux ?
I wasn't aware of this. I thought the Red Hat database was PostgreSQL.
Redhat (at least 7.3) comes with MySQL. If select the default install for
server, it will NOT install MySQL. You must check the box to Select
individual packages, and check off the MySQL binaries. Of course, you can
always install them After the installation from the CD's but you might have
to
The Red Hat Database is PostgreSQL, but I don't think it comes with RH.
Isn't it a seperate (and rather costly) add-on?
-Original Message-
From: Weaver, Walt [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 19, 2002 4:40 PM
To: [EMAIL PROTECTED]
Subject: RE: mysql comes with linux
Assuming intel and putting the CD in /dev/cdrom as root...
On Redhat 7.3... (Install whatever way you want first)
Put in CD#3 (label is Red_Hat_Linux_i3)
mount /dev/cdrom /mnt/cdrom
cd /mnt/cdrom/RedHat/RPMS
rpm -Uvh mysql*
chkconfig mysqld on
/etc/init.d/mysqld start
MySQL 3.23.49 should now
HEAP tables can have more than one index, but indexes only match = and
!= -- so you can't use , , etc... Also, comparisons only match
the entire index, not the left-most prefix like MyISAM tables. There are a
few other quirks, also:
http://www.mysql.com/doc/en/HEAP.html
--jeff
On Sunday 18
HI,
I am just starting out with MySQL, using Tomcat as standalone on a Win2000
machine and java servlets.
Could anybody:
1) Recomend a good book which covers the basics of MySQL, /or any good
tutorials on the web?
2) Tell me how to set up usernames and passwords for MySQL.
3) Recomend an easy
Could anybody:
1) Recomend a good book which covers the basics of MySQL, /or any good
tutorials on the web?
The mysql documentation is very good, I use
http://www.mysql.com/doc/en/index.html as my home page, but you really have
to know what to look for in order to find it. It's been so long
Hi,
I was hoping someone here might know the best way to setup a mySQL replication
environment where master-slave can be flipped to slave-master.
NOTE: I am NOT looking for a master=3Dmaster bi-directional updating solution. This
is a solution for HA, so when the master dies the slave
Hi.
Thanks for the reply...
I curious with what you mean by mysql not supporting commit and
rollback coz I found this in the site :
http://www.mysql.com/documentation/mysql/bychapter/manual_Refere
nce.html#COMMIT
Actually, Ive already tested it in my app under weblogic(and
worked). I was
I need to do a join with a count...but for some reason I can¹t figure out
how to do it using MySQL. I¹m hoping that this pseudo code can help you give
me an answer:
select
f.count(*),
s.name
from
first f, second s
where
f.id = s.id
How do I get a sql result like:
Hi,
Try:
SELECT f.count(*), s.name FROM first f,second s WHERE f.id = s.id GROUP BY
s.name;
Regards,
Jocelyn
- Original Message -
From: Mark S Lowe [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 20, 2002 3:02 AM
Subject: Count(*) using a join?
I need to do a join
Ok I got mysql 4.0.2 installed on Mandrake and its up and running. My
problem is that when I go to connect to it I get the error:
error while loading shared libraries: libmysqlclient.so.11: cannot open
shared object file: No such file or directory
Actually (just fixed it). All I had to do was
Add the mysql lib path on /etc/ld.so.conf
and type ldconfig.
:)
=
Thanks,
Louie Miranda...
WebUrl: http://axis0.endofinternet.org
Email: [EMAIL PROTECTED] - [EMAIL PROTECTED]
- Original Message -
From: Nick Stuart [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 20,
On 2002.08.20 01:09 Ruben Safir wrote:
Of course. Monty would *love* you to get MySQL officially into
OpenOffice, and thereby secure a *huge* automatic userbase for MySQL...
I doubt your installbase is a quarter of Monty's, and Monty doesn't need more users
Everyone with a FS system
Here is an insert from the innodb reference manual
Suppose you use a consistent read to read the table PARENT and indeed see
the parent of the child in the table. Can you now safely add the child row
to table CHILD? No, because it may happen that meanwhile some other user has
deleted the parent
93 matches
Mail list logo