I cannot seem to get SSL connections working using the REQUIRE ISSUER or
REQUIRE SUBJECT clauses.
I have a mysql working with ssl. I can connect from the client host to
the server using ssl, where the user has been setup using:
GRANT ALL PRIVILEGES ON x.* TO ''@'ipaddress' IDENTIFIED
From: Mauricio Pellegrini
Hi,
I've tryed that after reading this message,
But couldn't get the route correctly established.
I'm giving some more details in this example
Server (SuSE 8.2) IP 192.168.10.34
Win2k IP 192.168.10. 5 Gets slow when adsl is down
From: Mauricio Pellegrini On Tue, 2004-06-08 at 12:57, John Fawcett
wrote:
From: Mauricio Pellegrini
Hi,
I've tryed that after reading this message,
But couldn't get the route correctly established.
I'm giving some more details in this example
Server (SuSE 8.2) IP
From: Mauricio Pellegrini
Oh no.. The reason is I've changed my seat. All IP's are static.
Sorry :)
It generally helps to keep the problem conditions the same while
investigating. :)
I forgot that Here is the result of Ipconfig /all on the same machine
(192.168.10.2)
C:\ipconfig /all
From: Paul DuBois
At 17:50 -0500 5/16/04, Paul DuBois wrote:
Not a huge difference, I guess. But I suppose if a query that
uses one or the other of these expressions processes a large number
of rows, it might pay to run some comparative testing.
Another interesting point is whether one
From: Gustavo Andrade
select count(distinct membros.ID) as total_membros, count(distinct
replays.ID) as total_replays, count(distinct downloads.ID) as
total_downloads from membros,replays,downloads;
Why join three tables to count the records in each one? I'm sure the
performance will be poor
From: T. H. Grejc
Hello,
I'm trying to select all distinct years from a unixtimestamp field in
MySQL database (3.23.56). I have a query:
SELECT DISTINCT YEAR(date_field) As theYear FROM table
but PHP gives me an empty array. What am I doing wrong?
TNX
I think you need this
From: T. H. Grejc
How can I add more fields to query. If I write:
SELECT DISTINCT FROM_UNIXTIME(created, '%Y %M'), other_field FROM
table_name ORDER BY created DESC
I loose distinction (all dates are displayed).
TNX
I don't think distinction is lost. All the rows should still be distinct
From: Paul DuBois At 22:27 +0200 5/16/04,
John Fawcett wrote:
Year does not operate on a unix timestamp.
Sure it does:
mysql select t, year(t) from tsdemo1;
++-+
| t | year(t) |
++-+
| 20010822133241 |2001
From: Paul DuBois
You're right. You'd have to apply YEAR() to
FROM_UNIXTIME(UNIX_TIMESTAMP(arg)).
and you can avoid YEAR() altogether by using a
format string. in FROM_UNIXTIME()
John
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
From: T. H. Grejc
I'm creating news archive and it should be sorted by months:
January 2004 (news count is 56)
February 2004 (48)
...
So you need to use GROUP BY and COUNT.
The format is like this:
select monthandyear,count(othercolumn) from t
group by monthandyear
in your case
11 matches
Mail list logo
