On Monday 12 Jan 2004 22:23, you wrote:
> Richard Davies wrote:
> > Does anyone have any ideas on how to round a number in the form
> > float(3,4) to the nearest sixteenth of an inch.
>
> Multiply by 16, round, divide by 16.
Obvious really,
upd
Does anyone have any ideas on how to round a number in the form float(3,4) to
the nearest sixteenth of an inch.
eg ending in
.0625,
.125
.1875
.25
.3125
etc
I haven't found anything in the manual about this, maybe normal people don't
want to do this.
--
Regards
Richard
--
MySQL General
On Monday 12 Jan 2004 13:20, Richard Davies wrote:
Thank you to everyone who offered advice on this problem I knew it was easy
but couldn't see how to do it.
Thanks again.
> I receive measurements for a product sometimes in inches, sometimes in
> centimeter
I recieve measurements for a product sometimes in inches, sometimes in
centimeters.
These are stored in table1
int not null primary key, measurement1 int, measurement2 int, type
varchar(255)
I need to extract data from this table and store it in another table with all
measurements converted to
On Thursday 08 Jan 2004 16:50, you wrote:
> On Thu, Jan 08, 2004 at 02:47:51PM +0000, Richard Davies wrote:
> > On Thursday 08 Jan 2004 12:33, Harald Fuchs wrote:
> > > In article <[EMAIL PROTECTED]>,
> > >
> > > Richard Davies <[E
On Thursday 08 Jan 2004 12:33, Harald Fuchs wrote:
> In article <[EMAIL PROTECTED]>,
> Richard Davies <[EMAIL PROTECTED]> writes:
> > I find at present from reasons I can't work out if the image to be stored
> > is a jpg then there is no problem b
On Wednesday 07 Jan 2004 21:06, Ian O'Rourke wrote:
> Original Message -
> From: "Steve Folly" <[EMAIL PROTECTED]>
>
> > At work we are currently investigating ways of filing all our
> > electronic documents.
>
> I don't know the answer, but it's an interesting questio
I have a small single user database into which I wish to insert and extract
images.
From the manual this seems to work to insert the image
insert into images values(LOAD_FILE("/home/richard/scan.tiff"));
but how do I get it back again?
I thought this might work but it doesn't
select * into ou
