Hi all,
I have successfully used MySQL 4.1.1-alpha and MySQL 5.0.0a-alpha with jetspeed 1.5.
When I try to use MySQL 4.1.6-gamma with jetspeed 1.5 I get following exception
when I try to login (The first page (anon user) is showing up correctly):
java.sql.SQLException: There were 7 rows updated
Following query does what you want:
SELECT COUNT(*) from (SELECT COUNT(*) as c FROM pet GROUP BY owner
HAVING c>1) as temp
-Yayati
Dave Torr wrote:
Probably simple but I can't figure it out!
THe manual section 3.3.4.8 has the example
SELECT owner, COUNT(*) FROM pet GROUP BY owner
which is fine.
Erich Beyrent wrote:
Hi all,
This is probably a dumb question...
I am in the planning stages for a database project, where I will need to
store a bunch of documents in both PDF and MS Word format. Assuming that
the documents are stored as binary in the database, suppose I want to be
able to sea
Try something like is:
select a.Name as PL_Name,b.Name as PC_Name,c.Name as PA_Name from
(select * from table1,table2 where table1.ID=table2.PL) a,
(select * from table1,table2 where table1.ID=table2.PC) b,
(select * from table1,table2 where table1.ID=table2.PA) c
where a.description=b.description
ice I have?
Thank you,
-Yayati
-Original Message-
From: Mark Matthews [mailto:[EMAIL PROTECTED]
Sent: Friday, December 12, 2003 2:21 PM
To: Yayati Kasralikar
Cc: [EMAIL PROTECTED]
Subject: Re: Multiple languages in the same column
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Yayati Kasral
We are using MySQL 4.1.1 with mysql-connector-java-3.1 JDBC Driver(nightly
snapshot).
The only way we can store and display the Unicode content is by specifying
it in the jdbc connection string(url) like:
jdbc:mysql://localhost/database_name?useUnicode=true&characterEncoding=UTF-8
AND specifying
