Ben Wiechman
Network Administrator
Wisper High Speed Internet
Office: 866.394.7737
Direct: 320.256.0184
Cell: 320.247.3224
b...@wisper-wireless.com
> -Original Message-
> From: Gary Smith [mailto:g...@primeexalia.com]
> Sent: Friday, March 27, 2009 12:59 PM
> To: mysql@lis
Awesome... that works. Had to add a where clause to limit it to a specific
host.
The explain for that looks... interesting.
Thanks
-Original Message-
From: ddevaudre...@intellicare.com [mailto:ddevaudre...@intellicare.com]
Sent: Tuesday, February 10, 2009 12:47 PM
To: Ben Wiechman
Cc
| Host | LoginTime | LogoutTime |
+--+--+-+-+
| 0010E70A8004 | 172.17.6.100 | 2009-02-09 09:16:24 | 2009-02-10 04:42:08 |
+--+--+-+-+
1 row in set (0.
he host in question the information is
returned. This produces too many results as some of those users have since
migrated to a different access point.
-Original Message-
From: Andrew Wallo [mailto:theme...@microneil.com]
Sent: Tuesday, February 10, 2009 12:05 PM
To: Ben Wiechman
Subject: Re:
I keep hacking at this but haven't been able to get it right yet.
I have two tables
Userinfo contains a login, User's Name, Group Name
Log contains login, host, datetime of last login
What I need to do is return user information (userinfo.name/groupname) of
users that have logged into
Does anyone have a set of MySQL Visio stencils? Does such a beast exist?
Ben Wiechman
Cisco's Access Registrar supports MySQL 4.x. Does anyone have any experience
trying to make it work with MySQL Cluster?
Ben Wiechman
Network Admin
Wisper High Speed Internet
[EMAIL PROTECTED]
x27;d like to insert a row into the second
with a set value.
I tried this but it is not working. I'm not very familiar with subqueries as
you can see.
insert into table_2 ( id, value ) values ( (select id from table_1), '1' );
Ben Wiechman
[EMAIL PROTECTED]