On Sat, 20 Oct 2001, Clyde Jones wrote:
> Did you try that? replace should recursively replace ALL double spaces,
> if it is a problem just run and rerun the query
>
> UPDATED hotel
> set nome_hotel replace(nome_hotel, " ", " ")
>
> until all the double spaces are gone.
Ok. I tried it but
he space (" ") will match if there are two
spaces. I am not sure how may are there.
Adrian
>
>
>
> On Fri, 19 Oct 2001, Adrian D'Costa wrote:
>
> | Date: Fri, 19 Oct 2001 10:43:31 +0530 (IST)
> | From: Adrian D'Costa <[EMAIL PROTECTED]>
&
pear.
Thanks
Adrian
>
> Steve Meyers
>
>
> > -Original Message-
> > From: DL Neil [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, October 18, 2001 4:46 AM
> > To: Adrian D'Costa; Mysql Mailing List
> > Subject: Re: how to get the cor
; Steve Meyers
>
>
> > -Original Message-
> > From: Adrian D'Costa [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, October 18, 2001 11:22 PM
> > To: Steve Meyers
> > Cc: DL Neil; Mysql Mailing List
> > Subject: RE: how to get the correct result --
On Thu, 18 Oct 2001, Jani Tolonen wrote:
> Adrian D'Costa writes:
> > > If you 'office system' is, for example, Sun Solaris, you will see only
> > > 1 mysqld process with 'top'. The fact that in Linux 'top' shows
> > > actu
On Wed, 17 Oct 2001, Jani Tolonen wrote:
> Adrian D'Costa writes:
> > Hi,
> >
> > I have been using Mysql that was provided on my RH7.0 cd. It works on my
> > office system and it shows only one process. The same thing I installed
> > on m
Hi,
I have some records that I need to group by a field. This is easy using
group by in the sql statement. What I happening is that I get some data
in html format that I have written a script that will extract the data I
require an dump it into a table. Everything working fine. The problem is
On Sat, 29 Sep 2001, Benjamin Pflugmann wrote:
> Hi.
>
> On Sat, Sep 29, 2001 at 12:43:25PM +0530, [EMAIL PROTECTED] wrote:
> [...]
> > I am trying the below sql statement:
> > select na.id as naid, na.nid, na.date from newsarticles na, newscodes nc
> > where na.nid=nc.id and na.nid=1 or na.nid=
> -Original Message-
> From: Adrian D'Costa [mailto:[EMAIL PROTECTED]]
> Sent: Friday, September 21, 2001 12:56 AM
> To: Mysql Mailing List
> Subject: last week, this week
>
>
> Hi,
>
> I have a table that hold a lot of information about pricing and da
Hi,
I have a table that hold a lot of information about pricing and dates. I
would like to list the of differnce of prices between last week and this
week.
Adrian
-
Before posting, please check:
http://www.mysql.com/manual
>Hi,
>
>I am trying the below sql statment:
>mysql> select c.city, t.periodo, t.vitofferta from travel t, city c where
>t.cityid=c.id and t.periodo>"2001-07-20" and
>month(t.periodo)=month("2001-07-20") and
>YEAR(t.periodo)=YEAR("2001-07-20") and rand() limit 7;
>
>The result:
>+---+--
Hi,
I am trying the below sql statment:
mysql> select c.city, t.periodo, t.vitofferta from travel t, city c where
t.cityid=c.id and t.periodo>"2001-07-20" and
month(t.periodo)=month("2001-07-20") and
YEAR(t.periodo)=YEAR("2001-07-20") and rand() limit 7;
The result:
+---++---
using
> /etc/init.d/rc.d/mysql stop
>
> I had the same problem on a cobalt raq
> running a variant of red hat and that
> solved it.
>
> Sean
>
> -----Original Message-
> From: Adrian D'Costa [mailto:[EMAIL PROTECTED]]
> Sent: 17 July 2001 08:32
> To:
Hi,
I just installed a new version of mysql (not the latest) 3.23.36 which
came with rh 7.1 cd. I know that it is buggy but I have the following
problems that have been discussed in the list. I search the archives but
did not see how the problem got solved.
The error:
ERROR 2002: Can't connect
On Fri, 22 Jun 2001, Thomas J Keller wrote:
> select zip, city, county from zipcodes where zip between 68400 and 68500;
>
> here is a portion of the garbled output:
>
> |68442 | STELLA | RICHARDSON
> |43 | STERLING | JOHNSON
>|444 | STRANG | FILLMORE
>
Hi,
On Wed, 20 Jun 2001, Benjamin Pflugmann wrote:
> > This is my sql statement:
> > mysql> select count(*),travel.nome_hotel,travel.tour_operator,
> > city.city,travel.vitofferta from travel,city where city.id=travel.cityid
> > group by travel.nome_hotel limit 5;
> >
> > The result:
> > +-
Hi,
Thanks for assisting me in my earlier query. I never had the time to try
it out as my office needs keep changing. In connection to my earlier
question, this is just an extension :) The hotel names repeat in the
travel table.
My travel table's required fields from the hotel table are:
nom
h.hotelname;
This will just display the rows. I need to update the travel table with
the id of hotel table based on the hotel names being the same.
TIA
Adrian
>
> -Original Message-
> From: Adrian D'Costa [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, June 14, 2001 1:49 AM
Hi Benjamin,
On Wed, 13 Jun 2001, Benjamin Pflugmann wrote:
> Sounds as if you have to install a newer MySQL package. Use
Seems like. Which is the stable version now?
>
> rpm -qf /usr/lib/mysql/libmysqlclient.so.9.0.0
The result mysql-3.23.22-6
>
> Or compile it yourself. ;-)
That is my l
Hi,
I have two table:
mysql> select * from hotel limit 10
-> ;
+++
| id | hotelname |
+++
| 1 | Adams Beach|
| 2 | Aegean Village |
| 3 | Angela |
| 4 | App. in Ayja |
| 5 | Apt Alfaga |
| 6
Hi,
My setup
MySQL version : Ver 8.8 Distrib 3.23.22-beta
OS : RH 7.0
I downloaded MyODBC-2.50.37-1.i386.rpm from mysql's site but when I tried
to install it, give this error:
libmysqlclient.so.10 is needed by MyODBC-2.50.37-1
In /usr/lib/mysql I have the following entries
lrwxrwxrwx
database,sql,query
On Fri, 8 Jun 2001, Gabriele Bartolini wrote:
>
> >magic_quotes_gpc = On ; magic quotes for
> >incoming GET/POST/Cookie data
>
> And, what about: magic_quotes_runtime ?
Off.
Adrian
--
On Fri, 8 Jun 2001, Rolf Hopkins wrote:
>
> - Original Message -
> From: "Adrian D'Costa" <[EMAIL PROTECTED]>
> To: "Mysql Mailing List" <[EMAIL PROTECTED]>
> Sent: Friday, June 08, 2001 13:59
> Subject: php/mysql question
>
>
On Fri, 8 Jun 2001, Gabriele Bartolini wrote:
>
> >$tname =urldecode($name);
> >$tname1 = stripslashes($tname1);
> >$updtStmt = "update vusers set orgname='$tname1' where id=$tid";
>
> It all depends on these 2 variables settings:
>
> magic_quotes_gpc= On
> magic_quotes_runtime=
I do the following:
$tname =urldecode($name);
$tname1 = stripslashes($tname1);
$updtStmt = "update vusers set orgname='$tname1' where id=$tid";
This works fine, but suppose in by table I have a name "Adrian D'Costa"
This starts all the problems. I copy the sql
On Wed, 6 Jun 2001, Ian Ford wrote:
> Name your config file config.inc and if any of the below situations
> happen your password and username will not show up in plain text for the
> casual browser.
> (EXAMPLE:
>
> CONFIG.INC
> $DBname = 'test';
> $DBuser
Thanks,
Will try that out.
Adrian
On Thu, 31 May 2001, g_gosho wrote:
> You can try this link: http://www.bonev.com/s
>
> there is PHP session handling librarary and documentation how to use it
>
> - Original Message -
> From: "Adrian D'Costa&quo
Hi,
I am trying to use session instead of cookies as my targeted customers are
either behind a firewall or disable cookies.
My system
php 4.0.1pl2
rh 7.0
What would be the best way to use a session. I a database to store
the session id and then delete it on exit or expiry. I hope someone can
On Wed, 23 May 2001, Don Read wrote:
> >
> >
> >
> >
> >> while($row = mysql_fetch_object($result))
>
> Do you plan on executing a mysql_query() some time before this ?
Actually it is executed before this. This scripts works fine on my local
host running php 4.0.1pl2. Every time I r
On Mon, 21 May 2001, indrek siitan wrote:
> order by rand() didn't work back in 3.22.
>
> if i remember correctly (if this doesn't work, you can try to search
> the list archives), the workaround was:
>
> SELECT col1,col2,RAND() as r FROM table ORDER BY r LIMIT 1;
Thanks. Now I am into anoth
Hi,
I have been trying this on my localhost and this works
select special.contid, special.cityid, special.curr1, special.catalogo,
special.hf, special.curr2, special.vitofferta, special.fh, special.club,
special.stars, city.city from special,city where
DATE_SUB(special.periodo, INTERVAL 3 DAY)
Hi,
I have four table that have common fields like: date, destinazione and
price.
I what to create a temporary table with all four fields from four tables,
what would be the correct sql syntax.
TIA
Adrian
-
Be
On Tue, 17 Apr 2001, B. van Ouwerkerk wrote:
>
> >I am using php for this project. Right now it is related to mysql. What
> >I want is to display the names of the countries and cities from the
> >Special table instead of the ids. What would be the correct syntax for
> >the select statement?
>
Hi,
I have the following tables:
Country:
id | int(5) | | PRI | NULL| auto_increment |
country | varchar(35) | | MUL | ||
contid | int(5)
City:
id| int(5) | | PRI | NULL| auto_increment |
city | varchar(35) | | MU
On Thu, 12 Apr 2001, ilker YILDIZ wrote:
Install MyODBC
Adrian
> Hi,
> I want connect mysql databse with ms front page 200.
> How?
> What do i?
> Thanks.
>
-
Before posting, please check:
http://www.mysql.com/manual.php
In your odbc setup did you give the host name that you defined on the
linux box?
Adrian
On Wed, 11 Apr 2001, Fenn Rider wrote:
> I am trying to get myODBC working on an NT 4.0 ws, sp6a client, connecting
> to a MySQL db running on a linux box. When I try to connect, I get a dialoge
> that says:
I think you need myODBC.
Adrian
On Tue, 10 Apr 2001, Daniel Chase wrote:
> I have just installed version 3.23.36 on an Intel running windows 2000
> Pro.
>
> I am trying to use MS Access as a front end but can not get a connect
> string to recognize the mysqld server.
>
> My event viewer is sh
Usually it is not in the folders that are listed below. It is in one of
the server's folder that you don't usually have access to view.
Since you have only ftp you need to install phpMyAdmin from phpMyAdmin.net
on your server, htdocs.
Export your database using mysqldump dbname > somename.sql
Could you do a ps -aux |grep mysql
This will tell you if mysql is already running.
Adrian
On Fri, 6 Apr 2001, François Grenapin wrote:
> the file error_lod said me that :
> 10406 10:59:50 mysqld started
> 010406 10:59:51 Can't start server : Bind on unix socket: Permission
> non accordée
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
What are the results you expect. There are always workarounds
Adrian
On Fri, 30 Mar 2001, Ramasamy Palaniappan wrote:
> Sir,
>
> created the following tables as primary and secondary
>
> primary : partycode(primary key),partyname
>
> secondary
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
What did you do to get the error
Adrian
On Fri, 30 Mar 2001, Lebrun Jonathan wrote:
> What's error 1062 ?
>
> Thanks.
>
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.2 (GNU/Linux)
Comment: For info see http://www.gnupg.org
iD8DBQE6xYp3/f1mUN
I know this question is not related here, but while on the Oracle
Question, could someone tell me how to install Oracle for Linux of the
list :)
Adrian
On Thu, 29 Mar 2001, Freaked Personality wrote:
> Yea oracle has been ported for a while already, been running it for like 6
> months on SuSE
First of all, since you are not a programmer, it is going to be
difficut. I have done something similar but for a travels site using php
and mysql. I suggest you send me a private mail I will help you if I can
Adrian
I've got mysql and php installed on my server and i was wondering if
anyone c
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Sun, 19 May 2002, Luis wrote:
> #mysqladmin -u root -p password 'newpassword'
>
> or
>
> #mysqladmin -u root password 'newpassword'
>
> i got a error. but when i tried the 2 one it work. But in the manual it says to do
>the top one
I think that you would have got the answer by now, but initally mysql does
not need a password. You can just login without the password, then change
it using mysqladmin newpassword.
Adrian
On Fri, 9 Mar 2001, Luis wrote:
> I read the manual plus look on the site. I been having trouble setti
ble based on the one selected from the country drop down. I do not want
to use a submit button. I use a javascript and using onChange pass the
country.id to the javascript but do not know how to pass it back to the
php script. Any pointers
Adrian
--
===
Adrian D'Costa
have 78 records, when I do insert
|secondly, it dispalys 58th record firstly and others in reverse order.
|Anybody know why? (I use PHP script)
Depends on what way you have set up your script.
--
===
Adrian D'Costa
[EMAIL PROTECTED]
www.p
do this ?!
Depends on what your are using as a program (perl, cgi, php, etc). With a
program you can store the id in a var and insert insert it.
I am not sure whether there is a possiblity from the mysql prompt.
Adrian
--
===
Adrian D'Costa
[EMAIL PROTECTED]
ww
48 matches
Mail list logo
