Hi,
I'm just wondering is there a function instead of update to overwrite data
that has expired??
Or can mysql automatically deletes records or rows that has expires just
like cookies delete themselves after expiring.
Thanx for the info
Anthony
--
MySQL General Mailing List
For list archives
Hi,
I saw the error.
For interested it is in the place.latitude BETWEEN section
Anthony
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
I think this is an error, anyways i'm trying to join 6 tables together.
and when i do EXPLAIN SELECT i get the message in comments
""Impossible WHERE noticed after reading const tables""
this is my statment basically
SELECT table1.id
FROM table1,table2,table3,table4,table5,place
WHERE
table1.
Where/how can I get a copy of 4.1?
Thanks,
Anthony
sql,query,queries,smallint
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list ar
Any thoughts with regards to the problem outlined below would be
appreciated!
Thank You,
Anthony
Original Message
Subject: 2nd Attempt: Fwd: Access Denied (1045)]
Date: Fri, 18 Oct 2002 06:59:21 -0400
From: "Anthony W. Marino" <[EMAIL PROTECTED]>
To: [EMAIL PR
I'm boxed in a corner and would appreciate some suggestions, please!
Thank You,
Anthony
Original Message
Subject: Access Denied (1045)
Date: Tue, 15 Oct 2002 08:47:05 -0400
From: "Anthony W. Marino" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
I"v
I"ve searched about and still haven't been able to resolve my problem.
Scenario:
1) OS is RH 7.3.
2) Installing MySQL 4.04-Pro binary tarball.
3) Ordinary user, "userX.grpX", is installing tarball themselves on a
shared server accessed via telnet.
4) This installation will be userX's instance
Here's something:
http://no.spam.ee/~tonu/modules.php?name=News&new_topic=2
Anthony
Jayce^ wrote:
>-BEGIN PGP SIGNED MESSAGE-
>Hash: SHA1
>
>Actually, I remember reading about a mysqlfs system, like that, cd to a table,
>ls for records.. rm to remove and such. that was over a year ago
Pretty interesting stuff:
http://www.osnews.com/story.php?news_id=836
http://newsforge.com/article.pl?sid=02/03/22/204220&tid=9
Anthony
Anthony W. Marino
Pres./CTO, AWM Objects
David Garamond wrote:
> Jan Steinman wrote:
>
>> Today's "modern" operating sys
Victoria Reznichenko wrote:
>Anthony,
>Friday, October 11, 2002, 5:26:39 AM, you wrote:
>
>AWM> There is non-root user implementation of MySQL-Pro 4.0.4 linux binary in
>AWM> this users environment (RH 7.3).
>AWM> "my.cnf" has been modified to include individual "user", "port" ,
>AWM> "bind-
t user and is
passed as "--defaults-file" through "mysqld_safe" script. Data
directories are already available with this user/group's ownership.
All attempts to run "mysql -u root file" and other privledged commands
(also tried --skip-grant-tables) end up with Error
What are the issues if I were to remove the following snippets from
"mysql.server" on a RH 7.2 system running multiple instances of MySQL
under multiple users?:
# Make lock for RedHat / SuSE
if test -w /var/lock/subsys
then
touch /var/lock/subsys/mysql
fi
Thanks alot!!!
Anthony
> In the last episode (May 30), Anthony W. Marino said:
> > Where/how can I access the most recently updated code for MySQL Max
> > 4.x.
>
> http://www.mysql.com/doc/I/n/Instal
Where/how can I access the most recently updated code for MySQL Max 4.x.
Thanks,
Anthony
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
e)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]> Trouble
> unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Anthony W. Marino
Pres./CTO, AWM Objects
email: [EMAIL PROTECTED]
phone: (732) 610-2441
---------
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsub
>
> We have 10 of the 3ware cards, and while the drive is GPLd and in
> the kernel, we have not been satisfied with the stability of the
> system
Is there anything that I can avoid while still using the card (ie; specific
RAID config)?
>
> We haven't had a chance yet to qual th
On Wednesday 06 March 2002 02:40 pm, Petro wrote:
> On Wed, Mar 06, 2002 at 11:52:30AM -0500, Anthony W. Marino wrote:
> > Could someone, please, provide me with a link and/or facilitate some
> > suggestons for configuration of the following components for a new DB
> >
Original Message -
> From: "Anthony W. Marino" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, March 06, 2002 12:12 PM
> Subject: MySQL Availability
>
> > Where can I find most recent (ie
Where can I find most recent (ie; 4.0.2 builds ;Nightly/CVS) at?
Thank You,
Anthony
sql
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (t
Could someone, please, provide me with a link and/or facilitate some
suggestons for configuration of the following components for a new DB server
hosting MySQL 4.01MAX? I'm only looking to get a start and don't expect
"THE" answer since all things are relative and I will have to further test
On Monday 04 March 2002 03:21 pm, Heikki Tuuri wrote:
> Erik,
>
> this is probably not a bug.
>
> Your log files probably are not the ones which belong together with the
> current data file(s).
>
> When you start the database it tries to use the obsolete log files in
> recovery.
>
> From the manua
On Wednesday 27 February 2002 05:16 pm, you wrote:
> At 17:09 -0500 2/27/02, Anthony W. Marino wrote:
> >On Wednesday 27 February 2002 04:59 pm, Paul DuBois wrote:
> > > >Does MySQL 4.01 support Views? And if so, how?
> > >
> > > Ask the person who to
On Wednesday 27 February 2002 04:59 pm, Paul DuBois wrote:
> At 16:31 -0500 2/27/02, Stephen Cox wrote:
> >Does MySQL 4.01 support Views? And if so, how?
>
> Ask the person who told you that it does to substantiate the assertion.
>
> >Stephen Cox
> >Web Development, Webmaster
> >[EMAIL PROTECTED]
Would anyone like to share their experiences with MySQL 4 on XFS and kernel
2.4.16? I'm getting prepared to create a system with the above and would
appreciate any thoughts.
Thank You In Advance!
Anthony
-
Before posting, ple
On Sunday 24 February 2002 06:26 pm, Arjen Lentz wrote:
> Hi Anthony,
>
> On Fri, 2002-02-22 at 23:43, Anthony W. Marino wrote:
> > > On Fri, 2002-02-22 at 18:59, [EMAIL PROTECTED] wrote:
> > > > > Is there a timeline/status for 4.x functionality available?
> &
Can anyone point me to a comparison of +'s and -'s with each Transaction
enhanced formats (ie; InnoDb, SleepyCat and others) for MySQL.
Thanks,
Anthony
-
Before posting, please check:
http://www.mysql.com/manual.php (the m
On Friday 22 February 2002 06:26 am, Arjen Lentz wrote:
> Hi Alec,
>
> On Fri, 2002-02-22 at 18:59, [EMAIL PROTECTED] wrote:
> > > Is there a timeline/status for 4.x functionality available?
> > > I would like to use MySQL 4.x, however, I'm looking for some of the
> > > highly requested functional
On Friday 22 February 2002 05:48 am, Simon Green wrote:
> It would be nice to see some thing for V4.
>
> PS Paul...its only because we liked the first one so much.
>
> -Original Message-
> From: D Bamud [mailto:[EMAIL PROTECTED]]
> Sent: 22 February 2002 10:47
> To: [EMAIL PROTECTED]
> Sub
On Friday 22 February 2002 02:15 am, Jeremy Zawodny wrote:
> On Thu, Feb 21, 2002 at 08:07:39PM -0500, Anthony W. Marino wrote:
> > Is there a timeline/status for 4.x functionality available?
>
> No. It'll be ready when it's ready. :-)
>
> There are folks using 4.0
Is there a timeline/status for 4.x functionality available?
I would like to use MySQL 4.x, however, I'm looking for some of the highly
requested functionality (ie; subselects, SP's, triggers and Views) and would
like to know where/when in the sequence of things todo does everything fall
into pl
Isn't this something that RAID O does for you on a larger scale anyway?
I would expect that most would have some sort of raid on their mutliple drive
system.
On Monday 18 June 2001 01:52 am, you wrote:
> On Sun, Jun 17, 2001 at 11:48:04PM -0700, Jamie Krasnoo wrote:
> > Is there a way to tell My
Any thoughts on the best support of transactional/ACID attributes for db
tables in MySQL?
Thank You,
Anthony
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
33 matches
Mail list logo
