The quick way to answer this question is to go to the directory where you have
the rpm (if you still have it) and run the following command:
rpm -qpi -l MySQL-3.23.49a-1.i386.rpm
This will give ytou the details on where everything has been installed.
On Thursday 23 May 2002 11:46 am, Carl Carp
On Wednesday 22 May 2002 07:27 am, Jacob Friis Larsen wrote:
> If I install MySQL on the same server as Apache & Php and only use MySQL
> in Php, do I then have to install the MySQL client?
Technically, you don't need it. But when I am debugging PHP, I often turn to
mysql client just for a sanit
On Tuesday 21 May 2002 10:54 am, Info_Best-IT wrote:
> Any suggestions on how to load images from a web site into a MySQL db? I
> would like to set up a page that allows you to select an image from the
> local machine and load it to my MySQL DB on my web server.
>
> I'm not sure if it would just
You need awk. It is tailor-made for this kind of task. There is a Windows
version if that's what you're running. It can easily go through the records
and insert a delimiter at a certain character position. It shouldn't take
more than one line of code to accomplish the task.
On Wednesday 01 May
It's been awhile since I've done this, but couldn't you build a pivot table in
Excel that would bring the data through ODBC? I did this before for a report
I needed. You can get very granular about what data goes where in Excel and
avoid the need for a bloated macro. Once the data sources and t
If the final goal of this is a visual display, maybe it would make more sense
to display relevance as a horizontal bar graph that is longer or shorter
based on the relevance number. There is no reason to get hung up on
percentages.
On Monday 29 April 2002 02:21 pm, Paul DuBois wrote:
> At 17:5
Should we assume that your tables have an existing column of type timestamp or
date?
On Sunday 28 April 2002 11:47 am, Dra. Silvia Andreasi wrote:
> Hi,
>
> How can I get the columns between a given time interval? Something like: "
> The patients admitted between january 25, 2000 and january 3
Thanks for inspiring me to create a new mail filter!
On Thursday 25 April 2002 01:50 pm, Clay Loveless wrote:
> Erik, et. al.--
>
> Thanks for all the helpful advice.
>
> I'll make a note that the MySQL mailing list welcomes messages from people
> shrieking "HELP!!!" even though they clearly have
If you can't do it within MySQL (I don't know the answer to that one) you
might be able to dump the information to a text file and process it using awk
and then reload it. Awk is perfect for this kind of thing. There is a Windows
version, if that is your OS.
On Wednesday 24 April 2002 08:49 am
;, curdate());
Only "FL" shows up after the insert. All of the other fields come out as I
expect. The field with state abbreviations is the only one that is a data
type of set. I am using MySQL 3.23.47.
On Tuesday 23 April 2002 04:31 pm, Gerald Clark wrote:
> insert into mytable ( id
Yes. I found that page earlier. I still don't see how it answers my question.
What is the proper syntax for an insert statement?
On Tuesday 23 April 2002 03:54 pm, Christopher Thompson wrote:
> http://www.mysql.com/doc/S/E/SET.html
>
> On Tuesday 23 April 2002 1:45 pm, Jim Philip
I couldn't find this in the documentation. What is the propoer sql to insert
into a field with a data type of set? My field has the following set of
acceptable values:
GA, TN, SC, NC, AL
Assume I am inserting multiple values, such GA, TN, SC. If I separate them
with commas, mysql will assume
It isn't generally a good idea to install one piece by rpm and another by
compiling and installing. A straight compile and install will put things in
different directories from an rpm install. You will have a hard time making
it all work. You can go with rpm or compiling from source, but be con
How you uninstall depends on how you installed. Did you install the binary? an
rpm? or compile the source and then install? If you installed by rpm, then
all you need to do is:
rpm -e mysql
If you used some other method to install, then you can just delete all od the
directories. But you will
keywords: sql, query
Is it possible to load a file from a remote host as data type blob? This
needs to be done from within the C API.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http:/
Ditto here. If you have a support contract, then this is not the channel
for seeking support, since it's a free mailing list. And anybody would
need more information than you provided to solve the problem. Did you
try to install a binary version? Did you try to build from source? MySQL
is installe
There is no support for sub-queroes in MySQL, so your second select is
getting kicked out. You probably want a left join for this.
On Tue, 2002-04-02 at 06:54, jim and lois flaherty wrote:
> I have a table that recieves raw data form results for an online quiz. The
> boss wants to analyse the da
There is also PHP-GTK, which uses PHP to implement bindings to GTK. So,
within PHP you could build a GUI that could be used for accessing a
MySQL database. But I am wondering why some of the existing GUI tools
for MySQL won't do the trick.
On Fri, 2002-03-29 at 06:24, DL Neil wrote:
> Anoop,
>
It shows me:
>
>
>
> and not result of the phpinfo() function. When I run "php phpinfo()" at the
> shell command, it out puts the html result. What is problem, my Apache not
> understand the php script? Thanks
>
>
> >From: Jim Philips <[EMAIL PROTECTED]>
&
I'm assuming you're on a UNIX box? If so, you might first check to see
if the data files exist and then look at the permissions on them. My
data files are in:
/usr/local/var/
Let the list know what you find.
On Sat, 2002-03-23 at 06:10, Andy wrote:
>
>
> When trying to execute a simple "Sele
What kind of box are you on? UNIX? Windows? What happens when you try to
access the page? Provide some details.
On Thu, 2002-03-21 at 08:52, Mike Yrabedra wrote:
>
>
>
> I am having a heck of a time trying to get phpMyAdmin to work with 'http or
> cookie' authentication.
>
> I have created t
It looks like you don't have a path to that library. Once you find the
true location of libpthread.so, add that directory path to the file
/etc/ld.conf. After that is done, run:
ldconfig -v
as root and try again.
On Wed, 2002-03-20 at 09:13, Amrita Basu wrote:
> Hi, I am using Redhat 6.2 kern
Well, what are the permissions on safe_mysqld? And if this is a Linux
box, where is this Irix/SGI stuff coming from in the error message?
On Mon, 2002-03-18 at 13:58, Amrita Basu wrote:
> Hi,
> I wanted to know what the error possibly could be.
> I am using RedHat 6.0 Kernel 2.2.20 on i686 and
There is a tool that will automate the installation process, if you
like. It can be found at:
http://www.apachetoolbox.com/
You tell it what you want and with what features. Then it proceeds to
download the files, configure, make and install them. It works quite
well in my experience.
On Mon,
To select the rows you are looking for, you can use:
select * from messages
left join topics on topics.topic_id=messages.topic_id
where topics.topic_id is null;
This works fine for selecting. But for some reason the corresponding SQL
for a delete fails:
mysql> delete from messages
-> left j
It looks like you hit some C++ code on the first line. There are still
major problems in using gcc 3.x for compiling C++ on Linux. On my own
box, I had to downgrade to gcc 2.9.6. MySQL compiles flawlessly now.
On Thu, 2002-03-14 at 01:19, MWP wrote:
> Hi all...
>
> I get:
> c++-303 -DUNDEF_THRE
. wrote:
> I work with Linux Cobalt (like to RedHat)
> My gcc version is gcc-2.7.2
> - Original Message -
> From: Jim Philips
> To: Roberto C. Salazar M.
> Cc: [EMAIL PROTECTED]
> Sent: Wednesday, March 13, 2002 11:18 AM
> Subject: Re: Problem in instala
You could probably save yourself some trouble by installing binaries.
But what version of Linux? And what version of gcc? There are many
problems associated with using gcc 3.x that I won't get into here. But
it helps to pass along these details.
On Wed, 2002-03-13 at 11:04, Roberto C. Salazar M.
On Mon, 2002-03-11 at 23:39, Joel Rees wrote:
> Sort of off topic, but here goes:
>
> Jim Philips wrote:
>
> > I am trying to understand how to store both Latin and Cyrillc characters
> > in a database. I built in support for koi-8 and win1251, but I don't
> &
I am trying to understand how to store both Latin and Cyrillc characters
in a database. I built in support for koi-8 and win1251, but I don't
seem to be getting real support for Cyrillic. Cyrillic characters are
stored as ASCII and are echoed back on the Web page that way. Will MySQL
support stori
30 matches
Mail list logo
