I am trying to read a file and see if the contents of it exists in the DB
or not and am trying to do it via a Select.
I try to do a select * into outfile /tmp/result.txt from table where field
like %$var%; but it always goes through the first two lines of the input
file and then says the file
Hi all,
I have a table with a field full of urls.. what I need to do is to append
to those urls with a new url, so for example, if the field had
http://www.yahoo.com i want to make it
http://www.myserver.com/login?url=http://www.yahoo.com ..
I have tried the following which I thought should
-
From: Ashwin Kutty [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, October 16, 2001 8:48 PM
Subject: MySQL 4.0 - Order By Limit
Hi,
I thought version 4.0 was supposed to do a Order By first and then a
Limit after that on the results returned on a SELECT.. I have just
installed the new
-Original Message-
From: Ashwin Kutty [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 18, 2001 5:58 AM
To: [EMAIL PROTECTED]
Subject: Re: MySQL 4.0 - Order By Limit
I just saw the mistake I made in my original post.. I want to Order By
letter, but when I do
)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Wise men talk because they have something to say; fools talk
because they have to say something. - Plato
Ashwin Kutty
Systems
because they have to say something. - Plato
Ashwin Kutty
Systems Administrator
Dalhousie University Libraries
(902) 494-2694
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
Hi,
I have been using the ORDER By clause in one of my sql queries and it works
fine; however when I combine it with a LIMIT it still order's the
results by it doesn't do it the way its supposed to, for example:-
Order By clause without Limit returns:-
A
B
C
C
C
C
C
C
M
N
T
W
Order By clause
Is there any way to select insert at the same time? What I want to do
is select say 10 out 13 field values from one table and dump it into
another table. Would it be possible to do this via a select and an
insert at the same time and how exactly would the sql statement look? OR
do I have
Hi,
I have the following entries in a table:-
http://www2.mysite.com/location1/sublocation2
http://www2.mysite.com
http://www2.mysite.com/location1
All I want to do is try for a global change from www2 to www, is it
possible and how would I go about it?
Thanks for the help..
Hi,
I was wondering if someone knew of a way to keep stats of records that
were being used from a Table in a DB.. i.e. I have a table with URL's in
them and when a search is done, it returns a certain number of records..
I want to know, which exact record the user click's on and uses, not the
10 matches
Mail list logo