or anything else.
--
Paul Chvostek [EMAIL PROTECTED]
it.canadahttp://www.it.ca/
Free PHP web hosting!http://www.it.ca/web/
--
MySQL General Mailing List
For list archives: http
unavailale (and possibly corrupt)? If
he then created a new directory (and files), could a faulty database
file be put in place that would mysql barf, or just refuse to read the
file?
Too much duct tape.
--
Paul Chvostek [EMAIL PROTECTED]
Operations
home computer stored
in the database within hours of the site going down. ;-)
Ah, those wacky file upload toys
--
Paul Chvostek [EMAIL PROTECTED]
Operations / Abuse / Whatever
it.canada, hosting and development http
(id,value) VALUES ('20030714',15);
then
SELECT SUM(value) FROM table WHERE id='20030713';
In that case, index on id but don't make it PRIMARY or UNIQUE.
--
Paul Chvostek [EMAIL PROTECTED]
Operations / Abuse / Whatever
it.canada, hosting
On Sun, Jul 13, 2003 at 09:52:10AM -0400, Paul Chvostek wrote:
...
$q = UPDATE table SET value=value+$value WHERE id='$id';;
$q .= INSERT INTO table (id,value) VALUES ('$id',$value);
@mysql_query($q);
Woop, I forgot this was the mysql list, not a php- list. ;-)
The basic thing here
tools,
Codd's Rules, yadda), explains *why* you'd use them, and (refreshingly)
doesn't assume you'll take the author's word as gospel. It has examples
which it builds on throughout the book, and seems to advocate simplicity
of design over showing off gadgetry. I recommend it.
--
Paul Chvostek
the pipe than the data I'm
updating, but it's just a pipe, and the run happens at 4AM when nobody
is watching.
My db server is a 400MHz P-I and my disks are slow, but it takes me over
an hour to run the file so I'm not sure how this solution would fare a
hundred or a thousand times a day
--
Paul
Metzger wrote:
Paul,
Did you try using REPLACE instead of UPDATE/INSERT? Could give you some
more speed enhancement.
Cheers
/rudy
-Original Message-
From: Paul Chvostek [mailto:[EMAIL PROTECTED]
Sent: woensdag 9 juli 2003 15:21
To: cmars
Cc: [EMAIL PROTECTED]
Subject: Re
of:
[EMAIL PROTECTED] root]# mysql -u root -ppw R500 command.sql
You probably want to read the man page regarding the -e option.
--
Paul Chvostek [EMAIL PROTECTED]
Operations / Abuse / Whatever
it.canada, hosting and development
constitute a single,
persistent database connection, which would terminate when Apache went
away and be restarted when Apache was re-run?
Any thoughts?
--
Paul Chvostek [EMAIL PROTECTED]
Operations / Abuse / Whatever
it.canada, hosting
=SELECT this,that FROM Bobstable WHERE Name=1
$mysql -u$myuser -p$mypass -e$q $mydb | while read this that; do
echo this is $this, that is $that
done
8 cut here 8
--
Paul Chvostek [EMAIL PROTECTED]
Operations / Abuse
://www.mysql.com/doc/en/Extensions_to_ANSI.html .
All it comes down to is that you can do whatever you want, as long as
you know what you're doing.
--
Paul Chvostek [EMAIL PROTECTED]
Operations / Abuse / Whatever
it.canada, hosting and development
, I sometimes even store IP addresses in unsigned INTs. It all
depends on the requirements of the project.
--
Paul Chvostek [EMAIL PROTECTED]
Operations / Abuse / Whatever
it.canada, hosting and development http://www.it.ca
down.
I just can't seem to figure out an elegant solution. Is there one, or
must I do this the ugly way?
Any advice would be appreciated. :)
p
(And for the list robot: sql,query,queries,smallint)
--
Paul Chvostek [EMAIL PROTECTED]
Operations
wrote:
Looks to my like skuagent should be using the varchar fields instead of
the int fields.
Then you could just insert ignore each line from your test file.
Paul Chvostek wrote:
Hi all.
I need some help figuring out how to update a many-to-many relationship
from a text file
' AND receivable.custid=invoice.custid
ORDER BY date;
I'm obviously on the wrong track. Is UNION what I want to be using here?
Thanks.
--
Paul Chvostek [EMAIL PROTECTED
at this point to upgrade to MySQL v4 on a
production system?
Tnx.
--
Paul Chvostek [EMAIL PROTECTED]
Operations / Development / Abuse / Whatever vox: +1 416 598-
IT Canadahttp://www.it.ca
17 matches
Mail list logo