I am hoping that I can do this with one query, I have a table, Domains
with 3 columns
accountID, domainID, mailname
what I am trying to do is find all accountID's for domainID of 12345 and
see if a second row with domainID of 54321 exists for that
accountID,mailname. If it doesn't exist, I
-Original Message-
From: Jochem van Dieten [mailto:joch...@gmail.com]
Sent: Tuesday, February 10, 2009 5:10 AM
To: mysql@lists.mysql.com
Subject: Re: MySQL View
On Mon, Feb 9, 2009 at 3:41 PM, Steven Buehler wrote:
Ok, I just saw a post about using view's in mysql. I tried
Ok, I just saw a post about using view's in mysql. I tried to look it up
and found how to use it, but my question is: what is a view and why would
you use it? Is it like a temporary table? Does it write a new database to
the disk or use memory?
Thanks
Steve
-Original Message-
From: baron.schwa...@gmail.com [mailto:baron.schwa...@gmail.com] On
Behalf Of Baron Schwartz
Sent: Monday, February 09, 2009 9:19 AM
To: Steven Buehler
Cc: mysql@lists.mysql.com
Subject: Re: MySQL View
On Mon, Feb 9, 2009 at 9:41 AM, Steven Buehler st
correct?
Thanks
Steve
From: Martin Gainty [mailto:mgai...@hotmail.com]
Sent: Monday, February 09, 2009 11:26 AM
To: Steven Buehler; ba...@xaprb.com
Cc: mysql@lists.mysql.com
Subject: RE: MySQL View
My current understanding of the delta between Views and Temporary Tables
Views are read
From: Claudio Nanni [mailto:claudio.na...@gmail.com]
Sent: Monday, February 09, 2009 3:59 PM
To: Steven Buehler
Cc: mysql@lists.mysql.com
Subject: Re: MySQL View
Steven,
I would suggest you the reading of a basic book about SQL and Databases, I
explain you why.
Views are a very fundamental
I have a query that I just can't seem to get working.
insert into games2 (sea_id,date,time,loc_id,hteam,vteam,div_id) (select
'36',game_date,begin_time,loc_id,home_team_id,away_team_id,(select div_id
from team_season where team_id=s1.div_id) from scheduler s1);
Of course, I am getting the
Thank you, but I still get an error and I can't figure it out: Unknown
column 's1.div_id' in 'on clause'
Any other thoughts?
Steve
-Original Message-
From: Andy Shellam [mailto:[EMAIL PROTECTED]
Sent: Saturday, August 16, 2008 9:40 AM
To: Steven Buehler
Cc: mysql@lists.mysql.com
Thank you, but I still get an error and I can't figure it out: Unknown
column 's1.div_id' in 'on clause'
Any other thoughts?
Steve
-Original Message-
From: Martin Gainty [mailto:[EMAIL PROTECTED]
Sent: Saturday, August 16, 2008 9:50 AM
To: Andy Shellam; Steven Buehler
Cc: mysql
-
From: Andy Shellam [mailto:[EMAIL PROTECTED]
Sent: Saturday, August 16, 2008 10:03 AM
To: Martin Gainty
Cc: Steven Buehler; mysql@lists.mysql.com
Subject: Re: Multiple Query/Insert help
Hi Martin,
Good point, I normally do but was just illustrating the join. I would
also normally fully-qualify
I have a column in a table that was turned into an cp1251_general_ci
for a type of encryption. Question is, how do I unencrypt it?
Thanks
Steve
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
-Original Message-
From: Artem Kuchin [mailto:[EMAIL PROTECTED]
Sent: Friday, December 07, 2007 4:35 AM
To: mysql@lists.mysql.com
Subject: How to auto repair db on hosting with quota
I am asking this question as a hosting PROVIDER, not
as a hosting client.
The sitation is like
-A PREROUTING -t nat -p tcp -s client-ip \
-d linux-fw-ip --dport 3306 -j DNAT --to internal-ip:3306
On Wed, May 2, 2007 17:03, Steven Buehler wrote:
I have a client that needs to be able to remotely connect to port 3306
securely. I have tried to suggest an SSH Tunnel, but they do not want
But I also need to make sure that nobody is sniffing between Server-1 and
Server-2.
Steve
-Original Message-
From: Mogens Melander [mailto:[EMAIL PROTECTED]
Sent: Monday, May 07, 2007 1:35 PM
To: Steven Buehler
Cc: mysql@lists.mysql.com
Subject: RE: secure port 3306
On Mon, May 7
# Or whatever the interface that faces internet is called.
iptables -A FORWARD -i $EXTIF -p tcp -s client-ip --dport 3306 -j ACCEPT
iptables -A PREROUTING -t nat -p tcp -s client-ip \
-d linux-fw-ip --dport 3306 -j DNAT --to internal-ip:3306
On Wed, May 2, 2007 17:03, Steven Buehler wrote:
I have
I have a client that needs to be able to remotely connect to port 3306
securely. I have tried to suggest an SSH Tunnel, but they do not want their
clients to have SSH access. Another problem is that even if we do tunnel,
it needs to go thru one server that is connected to the Internet and into
16 matches
Mail list logo