Is there a way I can filter OUT records referenced in another table?
With Subselects it would be this, but I'm using 3.23:
select
a.*
from
a
where
a.id not in (select id from b)
You get the idea.
-
Before posting, please
u configured/compiled MySQL, did you use the --with-innodb option?
> What version of MySQL are you running?
>
> FWIW, I wasn't real impressed with the Berkeley tables, but the InnoDB
> tables work very well.
>
> --Walt Weaver
> Bozeman, Montana
>
> -Origin
This is getting really annoying. No matter what type of table I create, it
ends up being MyISAM. I _must_ have at least transactions and foreign key
support would be nice. Also, does anyone know how I can have transactions on
create table statements?
Here the interaction with MySQL that is dri
I guess I'm just old fashion. I learned with the terms inner and outer joins,
and I conceptually in struggling with this left/right join stuff -- I thought
the order it joins the tables was simply a matter of optimizer logic.
Can someone give me a rule of thumb in understanding what this left/r
If anyone wants PostgreSQL with support, but isn't interested in Red Hat's
thing, PostgreSQL Inc sells commercial support. There are actually some other
companies doing that too.
On Wednesday 19 December 2001 09:11 am, Christopher R. Jones wrote:
> And it comes with a nifty price tag: $2,300 US
I have a query. It (should) return one row. It normally does, except when I
do something like this:
(query)
(loop through results)
(update table that was in the first query)
When I do this logic in Perl/DBI, it seems to restart the loop, returning the
same row, over and over again. Can this
it on their own.
>
> IMHO,
>
> Mark
>
> -Original Message-
> From: Ken Kinder [mailto:[EMAIL PROTECTED]]
> Sent: Friday, November 16, 2001 10:10 AM
> To: Walter D. Funk; [EMAIL PROTECTED]
> Subject: Re: Subtracting Dates
>
> Well, I really do need the
Although I wouldn't suggest doing this, it seems to work fine for me. I
suggest in moving the directory, do not make ANY changes to the permissions -
any. Just do this as root:
(Assuming you have redhat'ish directory structure)
cd /var/lib/mysql
mv dbname /home/user/database
ln -s /home/user/d
There's probably something wrong with your PHP code. It should look something
like...
$result = mysql_query("select count(*) as cnt from table") or die
(mysql_error());
$row = mysql_fetch_array($result);
$count = $row[cnt];
print $count;
Sounds like you're doing something more like:
$result =
I think a measure of fairness towards
> competitors is always indicated.
>
> Cheers,
> Christian
>
> > -Ursprungliche Nachricht-
> > Von: Neil Zanella [mailto:[EMAIL PROTECTED]]
> > Gesendet: Montag, 26. November 2001 21:00
> > An: Ken Kinder
> > Cc
Oh you're actually from MySQL -- I didn't notice that.
That'll be very cool when you get that finished. Also, having a datatype
specifically for credit card numbers would be cool. :)
On Thursday 22 November 2001 09:52 pm, Michael Widenius wrote:
> Hi!
>
> >>&
Oracle is certainly more full-featured, but if you know very little about
databases, Oracle is not the right choice. Only use Oracle if you have a
full-time fix-figure-salary Oracle expert AND you actually need Oracle's
features.
If you don't specifically know you need Oracle, you don't.
On W
Monty, is this like a product you're selling? I would like more information,
although I haven't gotten to this yet in my security sweep.
On Wednesday 21 November 2001 06:27 am, Michael Widenius wrote:
> Hi!
>
> >>>>> "Ken" == Ken Kinder <[EMAIL PR
I'd say that if your database can fit on the SCSI drive you can afford, there
is no reason for not choosing SCSI. Or, hec, if it's a really small database,
why not ramdist?
In regard to your question about whether it confirms a write before commiting
a transaction. First of all, check to see i
3076 is 2:53 in the morning, not the afternoon.
On Tuesday 20 November 2001 08:46 am, Andy wrote:
> Summary
> If I have a filed of type "DATETIME" in a table and do a query with an
> order on that field than records with a datetime in the afternoon are
> returned before articles in the morning.
>
4.0 does support SSL connections. Note that this isn't an encrypted database,
it's just that the connection between you and the server is encrypted --
which is of course, good. One more thing: you have to specifically use the
SSL feature -- don't assume that your connection is encrypted! I sugg
I can confirm that NuSphere subscribes to mailing lists and spams its
posters, as this has happened to me too, under similar circumstances. Perhaps
the admins of this list should remove NuSphere.
On Monday 19 November 2001 04:55 pm, Michael A. Peters wrote:
> This e-mail address is brand new.
>
So, then even if you make a quote function that's too much work?
On Monday 19 November 2001 03:21 pm, berndt wrote:
> Problem with this unfortunately though is that i have probably 100+ sql
> queries spread over several hundred cfm pages to find and change. Plus if i
> ever want to go back to ms
Diana, in regard to adding and removing users. What I do is just login to the
database 'mysql' which holds the actual mysql information:
connect mysql;
Then, you can insert directly into the user table. Do you know enough about
SQL to understand how the insert statement works? Basicall
> - Original Message -
> From: "Ken Kinder" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, November 15, 2001 8:32 PM
> Subject: Subtracting Dates
>
> > The date addition and subtraction functions in mysql don't seem to quiet
The date addition and subtraction functions in mysql don't seem to quiet do
this. I was wondering if anyone know a way I could do this in the query:
Say you have two fields, start_time, and end_time, representing the start and
end of a period of time. Both are datetime datatypes. What I want is
The mysql-perl had something called the Perl DBI. Go to this url:
http://www.mysql.com/downloads/api-dbi.html
Get the DBI and the Mysql-Perl tarballs. They are funny to install, but
basicly you untar them:
tar zxvf
then, in the directory created by that:
perl Makefile.PL
make
make
I would advice against using temporary tables as views for performance
reasons.
On Thursday 15 November 2001 10:21 am, Alexei V. Alexandrov wrote:
> > There is no support for views -- just hard-code your queries.
>
> It is olso possible to use temporary tables.
> But still the support for views
There is no support for views -- just hard-code your queries.
On Thursday 15 November 2001 09:38 am, Alessio Torino wrote:
> hi all,
> can anyone explain me if mysql support view???
> if yes what is the syntax?
>
> thanks to all
>
> alessio
>
>
24 matches
Mail list logo
