I am trying to give MySQL a string and then compare it to a column.
For example, say I have the string: helloworld, and I have a
table with one column (keyword), and three records: low, 324, kda.
I want to select the records that are found in the string (in this
case, I want it to return low).
Hello Adrian,
Friday, June 08, 2001, 8:59:51 AM, you wrote:
ADC Hi,
ADC I am not sure whether this relates to this list or the (not working) php
ADC list.
ADC For simplicity: I have a form that displays data from a table. I will
ADC take just one field that displays a name
ADC input
Hello Leon,
Friday, June 08, 2001, 9:28:05 PM, you wrote:
LM Hello all,
LM I have some questions about password encryption. I want to make some sort of
encryption method that disables a human to read the password, but does allow my (php)
script to convert the encoded
LM password to a
Hello Marshall,
Saturday, June 09, 2001, 9:05:18 AM, you wrote:
MB I'm a new user, working through the tutorial provided in the MySQL documentation
(chapter 9). I'm trying to load the data from the pet.txt file into the pet table
using the specified command:
MB mysql load data local infile
Hi Folks,
I am running a webserver with around 100.000 hits per day running mostly on
PHP / MySQL.
In the mysql-data-directory (for my home /var/lib/mysql) I find a some
files named:
./server-bin.009
./server-bin.010
./server-bin.011
./server-bin.012
./server-bin.013
./server-bin.014
and so
Hi
I am new to this list, so foregive me if this have been asked before. Can
anybody inform me and maybe point me in a direction (faq, etc.) for
connecting mysql and StarOffice (Sparc, Solaris).
Thanks and best regards
Jan Birk
I've used a rule of thumb that I was told ages ago when working on other
databases that inserting records into a non-indexed table is faster
generally than inserting records into an identical but indexed table.
Makes sense to me, since it has to update the indexes in the latter case.
However
They are mysql binary logs of updates to your databases, and are usually
only needed for replication across multiple servers. If you don't need this,
remove or comment out the log-bin line from /etc/my.cnf and restart mysqld,
then you can delete them.
Hi Folks,
I am running a webserver with
Running two copies of mysqld in one single machine *HAS* its purpose.
What if, for whatever reason, mysqld died?
I personally havent seen mysqld died on me, but on a rare occasion,
the database got corrupted and it made mysql useless.
but if I made my application to be a bit more intelligent
Wow 300 MB logs ;-).
Thanks a lot!
Thomas
At 11:35 09.06.2001, you wrote:
They are mysql binary logs of updates to your databases, and are usually
only needed for replication across multiple servers. If you don't need this,
remove or comment out the log-bin line from /etc/my.cnf and restart
Basil Hussain writes:
Hi all,
Is there any reason why I can't do something like any of the following?
SET @blah := SHOW VARIABLES LIKE 'server_id';
SHOW @blah := VARIABLES LIKE 'server_id';
It doesn't seem to work no matter which combinations of syntax I try.
Is setting user
Hello,
I tried to make a query to MySQL, the version is: mysql Ver 9.38 Distrib
3.22.32, for pc-linux-gnu (i686). The result should be about 4843 rows,
but I got this message instead of the result:
ERROR 1114: The table 'SQL22e0b00_0' is full
When I tried on version: mysql Ver 11.12 Distrib
From: root [EMAIL PROTECTED]
Lookks like your mailer is misconfigured...
At 11:38 PM -0400 6/8/01, root wrote:
Description:
I was installing MySQL on my Red Hat 7.1 server; I tried both
the RPM and the tar.gz format. No matter what, though, I don't have
mysqladmin or safe_mysqld
Jan:
Go to http://lists.mysql.com/ open the General Discussion archive, and
search for 'StarOffice'.
G. Jensen
- Original Message -
From: Jan Birk [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, June 09, 2001 4:17 AM
Subject: StarOffice
Hi
I am new to this list, so
We supply targeted databases on CD, price £150 each.
Do you sell to any of these markets?
Computing 22,159UK companies
Construction238,685 UK companies
Education 39,416UK organisations
Hello Antonio.
On Fri, Jun 08, 2001 at 11:50:25PM -0700, [EMAIL PROTECTED] wrote:
[...]
select * from [table] where ([string] like %[keyword]$)
SELECT * FROM table1 WHERE (helloworld like CONCAT(%,keyword,%)
should work, IMHO.
Another possibility is to use string functions like this:
SELECT
Hi, we had exactly the same problem here.
We solved it by applying some patches in the operating system. Unfortunately.I
don't have in this momente the relation of patches applied but I can't get them on
next monday. Let me know if you were interested and we can send them.
{}S
Jose
Anyone has any idea how much this encryption method sucks up server load?
_
Leon Mergen
[EMAIL PROTECTED]
President of Operations
BlazeBox, Inc.
ICQ: 55677353
- Original Message -
From: Joshua J. Kugler [EMAIL PROTECTED]
To: Leon Mergen [EMAIL
Hi!
Are there any production systems out there using BDB (transactions) ?
(I guess so.)
I would like to have some examples of MySQL transaction support being
used in production environments.
(I need some proof of BDB being stable enough to use it for mission
critical data.)
Do you know of such
Neil Zanella wrote:
Sorry about this questions but why would you want to run two copies of
mysqld when it is capable of hosting as many different databases as
you need? Even if you needed two databases with the same name you
could still just create two different MySQL users for it.
Gabriele,
Thank you for your interest. I am using /usr/bin/ because this is where my
mysql file is, and my libmysqlclient.* files are in /usr/lib/. I tried
using just /usr (i.e. --with-mysql=/usr) as you suggest, but get the same
results.
In fact the file mysql.h is not anywhere in my
At 00:13 10/06/2001 +0900, atsushi wrote:
Hi,
The problem reported happens on Win9x and ME platform because
mysqld.exe was compiled accidentally with a __NT__ define for
the InnoDB library.
Use instead the mysqld-max.exe server on these OSs.
This issue is already fixed for the next release.
Hello,
I'm a database administrator for a hosting provider, and we have currently 2 SMP
MySQL-database servers. The one that is causing me problems, has at least 900
databases running on it. That's an dual PIII-550, with 1024MB memory, running RedHat
6.2, with Linux 2.4.5-ac4.
During working
For passwords it is good to use the sql function password(). This is done
like this:
to insert:
insert into users ('username1234', password('userspassword') );
to load
select * from users where username='username1234' AND
password=password('userspassword')
Hope this helps.
ryan
Hi,
So
Hello mysql,
I have FreeBSD 4.3, gcc 2.95.3
I do:
./configure
gmake install
I have error when I try to compile mysql:
gmake[1]: *** No rule to make target `my_init.c', needed by `my_init.lo'. Stop.
gmake[1]: Leaving directory `/c/mysql-3.23.38/libmysql'
gmake: ***
At 1:05 AM -0500 6/9/01, Marshall Bohlin wrote:
I'm a new user, working through the tutorial provided in the MySQL
documentation (chapter 9). I'm trying to load the data from the
pet.txt file into the pet table using the specified command: mysql
load data local infile pet.txt into table pet;
Hi All,
Im running some benchmarking tests on mysql, postgres and interbase
database servers.
does anyone know the reasons why or know where i can find out some
technical reasons why the mysql database server is particularly good in
relation to the others or just by itself e.g. use of query
There are really only two. mm.mysql (varisous version)
and the twz one.
I suggest the mm.mysql one. They are both type 4 I believe there
is no reason to choose the twz one over the mm one.
I would use the latest 2.0 version unless you have code that
would have a problem with it then you can
I'll have to pipe up and say that, empirically, mysql far outperforms
postgres on a non-state-of-the-art server. I have seen 10 simultaneous
connections to mysql and a system load of 0.1 versus 1 instance of postgres
(postmaster) and a load of over 2 (and with 3 instances of postmaster a load
Re: How many Mysql PIDs ?
Date:
Thu, 7 Jun 2001 15:42:15 -0700
From:
Jeremy Zawodny [EMAIL PROTECTED]
Reply-To:
[EMAIL PROTECTED]
To:
R Talbot [EMAIL PROTECTED]
CC:
[EMAIL PROTECTED]
On Thu, Jun 07, 2001 at
Jeremy.. Apoligies
I shot off an email to you 3 seconds before I saw this one.
Please read both..this email and that email..
Jeremy Zawodny wrote:
On Thu, Jun 07, 2001 at 07:36:54PM -0400, R Talbot wrote:
Jeremy
So what your pointing out is I am seeing several threads
generated
Hi Bob,
thas just a difference in the apache-config from caldera.
That has nothing to do with mysql!
Thomas
- Original Message -
Jeremy,
Yeah I follow you and as a LInux user of 5 years I am accustomed to
seeing
multiple processes launched for the same executable
Where can I get MySQL authentication module for Apache?
Thanks.
--
Bolek,
URL: http://www.bolek.com
URL: http://slash.bolek.com
e-mail: [EMAIL PROTECTED]
ICQ: 4086197, Address: 402905326
-
Before posting, please check:
So sprach --==[bMan]==-- am Sat, Jun 09, 2001 at 06:35:31PM -0400:
Where can I get MySQL authentication module for Apache?
try google.com - the first hit for the exact quesion you asked will tell you
Alexander Skwar
--
How to quote: http://learn.to/quote (german) http://quote.6x.to
On Sat, 9 Jun 2001, --==[bMan]==-- wrote:
Where can I get MySQL authentication module for Apache?
www.mysql.com, Downloads, Contrib, Web Tools.. right where one would
expect it to be.
--
Sapere aude
My mind not only wanders, it sometimes leaves completely.
Hi All,
I know this is not completely a mysql question, but it is related. I am trying to
do all my authentication based out of a mysql database. Works great for radius, and
ftp. Problem is, I can't figure out how to get apache to read where a users homeridr
is out of mysql. It still
Hello, everyone. Some of you may be aware that MySQL source and binary
distribution comes with a public test suite. Some documentation on it is
available at http://www.mysql.com/doc/M/y/MySQL_test_suite.html. But it is
terribly lacking, as evidenced by the fact that we have not had one user
Ok, I've answered my own question but now have another.
How do I reference the sitename for the 3 sites?
sitename returns the last sitename for all 3 I tried S1.sitename etc. but it
doesn't work.
Sir, in what way does it fail to work?
$query = SELECT * FROM department LEFT JOIN sites S1 ON
I tried this query:
Update phone inner join tmpphone on phone.empno = tmpphone.empno
set
phone.lname = tmpphone.lname,
phone.fname = tmpphone.fname
and it didn't work.
This works in MSAccess.
Is this syntax (or something like it) supported by MySQL??
No sir. Updating a table based on data in
I'm having a lot of difficulty trying to figure this out. I have a table
with a list of projects that I would like to arrange and view as a tree.
This is my table:
++--+--+-+-++
| Field | Type | Null | Key | Default | Extra
Hi all,
My ISP provides me with MySql version 3.23.36 on Red Hat Linux 5.2 box,
gcc version is 2.7.2.1
When I try to compile my C application I get lots of errors. What is
wrong ?
Since this is not my own server, what should I ask my ISP to do in order
to correct this?
gcc -o test.cgi test.c
I don't think it's possible purely with SQL using MySQL. I tried researching
it just a few days ago, and found Oracle supports a clause CONNECT BY ...
PRIOR (more info at http://www.arsdigita.com/books/sql/trees.html) which
does this for you, but it's still in the MySQL todo list
I'm using MySQL with PHP (just learned MySQL so bear with me).
Here's a two part program:
Test.php:
html
body
?php
require(common.php);
CalculateScore(1);
?
/body
/html
Common.php:
?php
//Global variables
$Sitename=Toplist;
$Siteurl=;
$Links_per_page=50;
$Base_site_url=localhost;
//MySQL
On Sat, Jun 09, 2001 at 12:14:54PM +0200, Thomas Seifert wrote:
Wow 300 MB logs ;-).
I once accumulated 30GB of binary logs on a server before thinking
hard about resetting things. :-)
It made for a great way to throw real queries at a test server. I'd
just make the test server a slave of the
I thought using the result identifier returned by mysql_query in
mysql_fetch_array was perfectly legal.
mysql_query() doesn't always return a valid result identifier if an error
occurs (echo mysql_error()) or if no rows are returned.
When I run test.php I get this:
Warning: Supplied argument is not a valid MySQL result resource in common.php on
line 27
0
Here are lines 25-27:
25: $sql = select urate, arate, inhits from sitestats where id = $id;
26: $r = mysql_query($sql);
27: $row = mysql_fetch_array($r);
I
On Fri, 8 Jun 2001, Peter Kok wrote:
Hi,
Your mail is misleading
I know it how to do it now
First remove all rpm eg: php, apache and mysql
You need not remove all rpms - just remove php
then download tarball from php, apache and mysql
download just php sources
php4.0.5
47 matches
Mail list logo