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
>
>
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
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
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
> - 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
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
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
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.
>
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
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.
>
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
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
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
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!
>
> >>&
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
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 =
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
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
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
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 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
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
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
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
24 matches
Mail list logo
