check the replace syntax:
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#REPLACE
regards
rene
On Thu, 13 Sep 2001 13:40:44 +0200
Torgil Zechel [EMAIL PROTECTED] wrote:
Hi!
I have a counter that is increased each time an event occur. The number of
events should
On Tue, 11 Sep 2001 00:25:20 GMT
Miguel Enriquez Alvarado[EMAIL PROTECTED] wrote:
hi all
this is my first question:
when i try connect since a client windows9x to mysql (in a server linux rh 7.0), say
me the next error:
General Sql Error: [TCX][MyODBC]Access deneied for user [EMAIL
Rudy,
there is an explanation to this behaviour:
on escaped data you could un-escape almost everything, one can escape almost any
character if wanted.. .. so \\ gets \ and \* gets *, \% gets % and \N gets... N.
mysql select \A\B\C\J\N;
+-+
|ABCJN|
+-+
|ABCJN|
+-+
1 row in set
try using inet_ntoa() function.
On Thu, 23 Aug 2001 12:19:54 -0700
Jamil Farshchi [EMAIL PROTECTED] wrote:
Hello,
I am trying to convert a hex number that is stored in a mysql db into an ip
address. Here is my problem: I can convert the original integer into a hex
number like so:
Elizabeth,
Last conversation i recommended tools like ssh (you could also succesfully use stunnel
(http://www.stunnel.org), i tried and it works well).. but.. there is an easier way.
Guess that it depends on the mysql version your ISP is running, elsewise ask them to
upgrade.. Also make sure
Elizabeth,
sorry, 1 mistake: binary seems not to support mysql by default. so at least i'm not
sure, maybe somebody else can clear this out.
However using mysql's built-in ssl support seems like the best and easiest solution to
me, prefered above tunneling.
regards,
rene
On Thu, 23 Aug
Elizabeth,
sorry. misleading information. ssl support is still on the to-do list for mysql
version 4.0, so not available yet as production.. It is documented anyhow and i bumped
into it. try stunnel for the time being... sorry it's late.
regards,
rene
On Thu, 23 Aug 2001 08:44:36 +0100
On Tue, 21 Aug 2001 18:55:15 +0400
Spirit [EMAIL PROTECTED] wrote:
Hello!
I need your suggestions on what keys to build for the table described
below. Currently I have almost all possible keys on the table in order
to see what keys mysql will use.
I have a table here, which consist of
On Fri, 17 Aug 2001 15:13:22 +0200
Liana Wiehahn [EMAIL PROTECTED] wrote:
Hi
I've got the following:
Table: Erf
Column Name : PortionNumber
DataType: varchar(5)
Records: 39000
The values of these records are all numbers that starts at 0 and ends at
200.
I would like to insert
Just use the password() function, which will return a nice 16-byte 1-way encrypted
string.
On Fri, 08 Jun 2001 00:04:18 -0700
Richard Ellerbrock [EMAIL PROTECTED] wrote:
Ok, so you can obtain a random result (thought that was what random()
was for), but still cannot understand how this could
It would help if you located the piece of source code where the bug might get involved
and post this source code.
On Thu, 31 May 2001 02:32:22 -0500
Dawn H [EMAIL PROTECTED] wrote:
Hi, folks,
The quote below -
jonbad.txt is the 'view source' of a page in IE5.0. Just a minute later,
after
You have a concurrent process reading/writing the mysql sock, like the default php
binary distribution which has built-in mysql support. read the php docs on this and
then build your own php with shared mysql support, or trace the other application
reading/writing the mysql.sock
gl
rene
On
On Thu, 10 May 2001 09:43:10 +0200
indrek siitan [EMAIL PROTECTED] wrote:
Hi,
Tried doing isamchk on the .ISM files and got that following error
The Exception Integer division by zero
(0xc094) occured in the application at the location 0x0040224a.
getting such errors usually
200 connections table locks a second is good performance, isn't it?
what you also can do is insert bunches of data, so instead of inserting each record
seperately, you just collect them and insert them at once like:
insert into mytable (field1, field2) values (1,2), (3,4), (5,6), (7,8), ..
depends on your budget :)
We assembled a nice dual pIII server with 512Mb ram and 40Gb ide disk (+40 for backup)
running redhat 7 for less than $3000
You can spend any amount you like, from $30 for an old P133 up to $3 for a compaq,
and choose almost any platform you like.
without
On Mon, 7 May 2001 06:27:08 -0400 (EDT)
Jon Valvatne [EMAIL PROTECTED] wrote:
As you'd expect, the server gets bogged down rather quickly at this
point, serving new requests very slowly if at all. Restarting MySQL helps
right away, buying me another 24 hours of stable uptime.
If this is a
a kernel panic and countless hours of expensive support :)
you always could try if same database/scripts generate same errors on another box..
Thanks again,
Jon
On Mon, 7 May 2001, Rene Tegel wrote:
On Mon, 7 May 2001 06:27:08 -0400 (EDT)
Jon Valvatne [EMAIL PROTECTED] wrote
On Sat, 05 May 2001 16:27:05 +0530
chintanp [EMAIL PROTECTED] wrote:
Hello Everybody,
I want to implement disk quota's for various MySQL databases.
I checked out various books,but did not find the answere.
Can you please help me in achieving my goal ?
buy more diskspace
I am using
On Sat, 05 May 2001 16:27:05 +0530
chintanp [EMAIL PROTECTED] wrote:
Hello Everybody,
I want to implement disk quota's for various MySQL databases.
I checked out various books,but did not find the answere.
Can you please help me in achieving my goal ?
Some more serious this time :)
On Sat, 5 May 2001 13:47:57 -0600
Zak Greant [EMAIL PROTECTED] wrote:
chintanp wrote:
I want to implement disk quota's for various MySQL databases.
I checked out various books,but did not find the answere.
Can you please help me in achieving my goal ?
I am using Red Hat Linux 7.
On Sat, 5 May 2001 14:11:24 -0700
Daniel Goldin \(E-mail\) [EMAIL PROTECTED] wrote:
I'bve been following SAM'S TEACH YOURSELF MYSQL and hit a glitch. Whenn I do
what I'm told to do create passwords here's what happens
prompt insert into user (host, user, password) values('localhost',
do publish any improvements you suggest :)
On Tue, 1 May 2001 10:26:05 -0700 (PDT)
sagar tamhane [EMAIL PROTECTED] wrote:
hi,
I was reading the manual for the full-text search. It
is really interesting to have a search engine embedded
into the database itself!!!.
Mysql uses the
you just did the right thing: you posted an anomaly to the list. that's not bad,
that's good. Thanx for notifying us!
don't worry about possible abuse, as far as i can see you need a normal mysql account
anyhow in the first place, and if any system administrator would notice such a user
i'm just wondering: what hangs first: your scripts or the mysql database?
if (one of your) scripts is in a endless loop, for one reason or the other, the
symptons will be the same...
I would try to figure out if there's one particulair query that hangs, or if it
happens randomly.
For cgi i
,
rene
On Sat, 28 Apr 2001 10:17:26 +
Rene Tegel [EMAIL PROTECTED] wrote:
i'm just wondering: what hangs first: your scripts or the mysql database?
if (one of your) scripts is in a endless loop, for one reason or the other, the
symptons will be the same...
I would try to figure out
supposed you numbered all rows in the table incrementally in field nid:
select mydata from mytable where mod(nid, N)=offset;
fill in N and offset (0..n-1)
On Sat, 28 Apr 2001 14:26:46 +0400
Igor V Yermakov [EMAIL PROTECTED] wrote:
i have 400 rows in my mysql database table
and i wont get
Make sure you don't have concurrent accesses to the mysql.sock, for example the
apache authentication module (we had that). docs say you should build php with shared
mysql support, so i guess you'll still just have to do so...
On Tue, 24 Apr 2001 11:06:33 -0700
Hunter Hillegas [EMAIL
We encountered no real problems when converting a database from Interbase, with some
stored procedures and triggers as well, to mysql.
Most stored procedures were for things like generating a unique key, getting the
server date/time/year, etc.
Triggers are imho just application _unfriendly_,
RTFM=Read The Fucking Manual
now you know.
On Tue, 24 Apr 2001 21:37:44 +0100 (BST)
Peter Skipworth [EMAIL PROTECTED] wrote:
I for one vote to not bother with abbreviations from now on - let's just
spell it out loud and clear ;) *grin*
P
On Tue, 24 Apr 2001, Steve Ruby
wrote:
i just think you're lucky to get a row each time. your query returnes an
undefined number of rows.
Each row.numberhed against rand(), so sometimes a row matches, sometimes
not. rand() is not a constant, but calculated each match!
maybe you're looking for a query like:
select bid, number, title
30 matches
Mail list logo