This seems like a simple query to me. Correct me if I am wrong but as
I understand it you want to get a list of SwReleases that a user has
access to. Would something like this not work
SELECT s.ID, s.Name
FROM SwRelease as s
WHERE s.ID IN (
SELECT SwID
FROM GroupSwRel-- this table is th
Kemin Zhou wrote:
Hi All,
I have one of the toughest problem to solve now. I have not been able
to sleep well in the last three days.
There is a simple query
insert into table foo (column1, column2, column5)
select $col
from bar
If I run this query by hand whatever the value of $col, it wor
At 6:54 PM -0700 6/9/07, Kemin Zhou wrote:
Hi All,
I have one of the toughest problem to solve now. I have not been
able to sleep well in the last three days.
There is a simple query
insert into table foo (column1, column2, column5)
select $col
from bar
If I run this query by hand whatever
Hi All,
I have one of the toughest problem to solve now. I have not been able
to sleep well in the last three days.
There is a simple query
insert into table foo (column1, column2, column5)
select $col
from bar
If I run this query by hand whatever the value of $col, it works fine.
The ins
Hello all,
I think I saw this on an earlier post but I can't find it now.
What I need to do:
1 - update data nightly into Dev Server
2 - only copy Data do not overwrite structure
3 - only update specific tables
Any advice is greatly appreciated.
David
--
MySQL General Mailing List
For list a
I don't run any master with that many slaves, for reasons that are irrelevant to
this thread, but I know there is a point at which the slaves begin to place too
much load on the master because they are all asking to read the binlog. I don't
know what that point is exactly, but perhaps others ca
Hi David,
David Scott wrote:
I would like to add a column to a table where the column to be added is
in another table. The column entries are to be matched using a
particular column from each table.
I have one table detailing phone calls, indexed by CallID. I have
created another table wit
Hi David,
David T. Ashley wrote:
Hi,
I'm implementing a software release database. Users may aribtrarily be
members of groups (a many-to-many mapping), and each software release may
contain multiple files.
I'd like to allow users the maximum flexibility in deciding who may view
what software
On 04.06.2007 23:44 CE(S)T, Daevid Vincent wrote:
> Thanks for the magazine. I already incorporated a little extra SQL
> injection checking into my db.inc.php wrapper...
>
> //[dv] added to remove all comments (which may help with SQL injections
> as well.
> $sql = preg_replace("/#.*?[\r\n]/s", ''
