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
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 sanity
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 be a
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
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
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
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 30,
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 haven't
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
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
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 Philips wrote:
I
2002 04:31 pm, Gerald Clark wrote:
insert into mytable ( id , myset) values ('1', 'GA,SC') , ( '2',
'TN,NC,AL') ;
Jim Philips wrote:
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
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
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
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)
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
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
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,
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/database name
Let the list know what you find.
On Sat, 2002-03-23 at 06:10, Andy wrote:
When trying to execute a
phpinfo(); ?
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]
To: Andy Cheng [EMAIL PROTECTED]
Subject: RE: mysql/php
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 the
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,
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
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
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
. 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 instalation
You could probably save
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
seem to be getting real support for Cyrillic
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
28 matches
Mail list logo