Greetings, sql people!
I'm from Poland, studying on Technical Unversity.
For now I'll stay quiet and hear what's going on ;)
Regards!
Korzon
--
Ile zarabiasz? Wypelnij ankiete,
dowiesz sie jak zarabiac wiecej [ http://listaplac.onet.pl ]
-
Hi!
The [EMAIL PROTECTED] is only meant for full bug reports.
You can find information how to do a correct bug report at:
http://www.mysql.com/documentation/mysql/commented/manual.php?section=Asking_questions
PLEASE read the above before posting your next question, as this will save
us all a
> 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)
Hi,
Thanks for the reply.
The sites (deptsite1 deptsite2) on the department file are the numeric key
to the actual site file.
The query below works fine (in mysql & php) but how do I reference the
sitename for the joins that have happened?
Specifying
$result = mysql_db_query($dbName,$que
> 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.
-
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 th
I'm using MySQL with PHP (just learned MySQL so bear with me).
Here's a two part program:
Test.php:
Common.php:
3000) { $hits = 3000; }
$score = (($arate * 5) + ($urate * 2) + ($inhits / 100));
echo($score);
//$sql = "update sitestats set score=$score where id = $id";
//mysql_query($s
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
(http://www.mysql
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 cgih
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
>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
>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
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
su
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 lo
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.
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 (english
I am getting a error after installing on the Windows 2000 Professional Operating
System.
Everything was going by the 'Manual' until i got to the root user password change
command. I
have checked through a series of posts, self-proclaimed mysql "gurus" and lists and
the
Manual itself, and fo
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:
ht
http://www.mysql.com/doc/F/u/Full_table.html
> 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
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 but
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
> > g
> 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
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
of
I recently read an article at Zend.com, showing that Postgres had better
performance than MySQL... Offcourse, this is a very bad thing to say in the
MySQL mailing list, and I'm not really sure about it either, since so many
praise MySQL...
http://zend.com/zend/art/databases.php
_
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 u
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 opti
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
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: *** [install-rec
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,
>
> > >
hey all!
i have a linux box with sdk2 java, apache,tomcat and
mysql. i am planning to do some servlets/database
development and was wondering what jdbc driver to
utilize for that. mysql.com has several of them
available for download. i also have j2ee distribution
which i am planning to install (d
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
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.
Rega
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 files
hello, I've encountered the following message after I've set
inodb_file_path.
C:\WINDOWS>mysqld
Innobase: Assertion failure in thread 4293055721 in file
M:\mysql-3.23\innobase\
os\os0file.c line 187
Innobase: we intentionally generate a memory trap.
Innobase: Send a bug report to [EMAIL PROTECTED]
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.
>
>
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 s
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" <[EM
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
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:
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
E
Thierry Coopman writes:
> At 14:55 +0300 08-06-2001, Sinisa Milivojevic wrote:
>
> What's the difference between write-through HEAP tables and normal
> HEAP tables ???
> And how to use them??
>
>
>
> --
> Thierry Coopman - [EMAIL PROTECTED]
> My opinions are personal, and have really nothi
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
>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_mys
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 3.
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 use
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
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
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
> 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.
Howeve
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
--
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 on
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
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 human
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>
ADC> T
54 matches
Mail list logo
