Stuck with a huge ibdata1 file

2004-09-26 Thread Wouter van Vliet
Howdy Folks, Got a bit of a hassle. After some broken tries (got impatient) to change the type of large table's column I found that, when I finally got the patience, my disk went full and cancelled the operation again. Since MySQL copies the table before such operation, my ibdata1 file (using Inno

encoding & decoding

2004-09-26 Thread php mysql
I use mysql version 3.23.58. I want to use 'decode' and 'encode' functions: http://dev.mysql.com/doc/mysql/en/E..._functions.html Using password I can decode and encode data in mysql. Below is my queries that return nothing: #1 create table. #2 insert data using encode function #3 trying to selec

update data according to value in other table

2004-09-26 Thread Kerry Frater
Can someone tell me if this is possible using the UPDATE command I have a table MASTER and a table called MASTERNOTES. Masternotes contains the blobs of data linked to MASTER that is stored separately for efficiency. Not all rows in MASTER has a note and therefore MASTERNOTES is a subset of MASTER

Trying to remove co-dependiencies

2004-09-26 Thread Kevin_karigna
I've run into a problem building 4.0.21 mysql install. On executing an install from rpm I get the following: [EMAIL PROTECTED] i386]# rpm -Uvh mysql-server-4.0.21-0.i386.rpm error: Failed dependencies: libmysqlclient.so.10 is needed by (installed) perl-DBD-MySQL-2.9003-4 libmysqlcl

Old and new clients with MySQL 4.1.3

2004-09-26 Thread Ville Mattila
Hi there, We have a following situation. Our MySQL server is version 4.1.3 and therefore it doesn't accept "old clients" as a default. I would like to use (and I do) the new client authentication system in most of the clients connected to the server. Anyway, now there is a situation that I shou

Re: Adding hypertext data element into record ...

2004-09-26 Thread Hassan Schroeder
Andrew Lietzow wrote: RE: 1) Is there no field type/data element type/column type that will allow a string to be treated as a hypertext link directly from MySQL? No, there is no URL/URI datatype, but your *application* can treat any data you like as a URL. So, are you saying that if I am using p

Re: Adding hypertext data element into record ...

2004-09-26 Thread Peter Brawley
>I can store the data, but obviously, since the display of records >following a query simply displays the text, which is not hypertext >enabled, there is no means to click on the data and have anything >happen. IOW, is there a way to hypertext enable data in a mysql data >record? There's not a hy

Re: Adding hypertext data element into record ...

2004-09-26 Thread Andrew Lietzow
Thank you for your replies, Mos (and Sol): So, is there there a way to store the following in a data record? http://mydomain.com/photos/acoolpic.jpg";>My Cool Photo <>Mos Wrote: RE:>>The code only becomes clickable when viewed from a browser so you need to retrieve the html string from the datab