RE: Select via Perl

inal Message----- > From: Ashwin Kutty [mailto:[EMAIL PROTECTED] > Sent: donderdag 17 juli 2003 17:12 > To: [EMAIL PROTECTED] > Subject: Select via Perl > > 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 Sele

Select via Perl

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 al

Concat() Syntax..

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 wor

RE: MySQL 4.0 - Order By & Limit

lts of it. > > Steve Meyers > > > > -----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 > > >

Re: MySQL 4.0 - Order By & Limit

get only >>the rows that interest you :) (I assume you are using language like PHP, >>C++, etc... to execute this query ?) >> >>Regards, >> >>Jocelyn Fournier >>Presence-PC >> >>- Original Message - >>From: "Ashwin Kutty" <

Re: AW: Order By & Limit; Count

C | >>| C | >>| M | >>| N | >> >>++ >>10 rows in set (0.37 sec) >> >>--< cut >> >>Surprise, surprise, turns out MySQL behaves not the way I thought it would, >>but rather the way you thought it should

Re: AW: Order By & Limit; Count

You're right, I just forgot to put it in here, as I said the query works, however, not the way I thought it was supposed to.. >>The query I tried is:- >>SELECT * from table1 WHERE title LIKE %keyword% ORDER BY title LIMIT 0,10; >> > >The quotes are missing around the string constant. > --

Re: AW: Order By & Limit; Count

rows in set (0.37 sec) > >--< cut > >Surprise, surprise, turns out MySQL behaves not the way I thought it would, >but rather the way you thought it should. Are you perhaps running a >different version? And could you perhaps show us your table structure(s) and >query so that we can fin

Order By & Limit; Count

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

Select & Insert

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 t

Editing Web Links in DB

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.. ---

Logging/Stats individual entries..

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 que

CPU Usage...

Anyone notice any high CPU Usage with the following versions of the Linux Kernel and MySQL mysql-3.23.32-1.7 Linux 2.2.16-22smp Other info.. Distro:- Redhat 7 Machine:- Pentium III 450 256 MB Ram.. I have gone through and edited my.cnf to see if that makes a difference, but no go on

Data Replace.. ughhh..

I have a database with tables containing file names with a .sgm extension.. Any ideas as to how I could traverse the database through the different tables and change all the .sgm extensions to .htm? Any easy way? -- Ashwin Kutty Systems Administrator Dalhousie University Libraries (902) 494