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"
>
>
> 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:\>ip
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 c
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
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 po
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
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 mon
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:http:/
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) |
> +-
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
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
11 matches
Mail list logo
