Hi,
I was finally able to compile version 1.7.4 for
Solaris 2.6 but during startup if I enter a password
it coredumps. Do you have 1.7.4 compiled for solaris 2.6?
Thanks,
Naci.
Here is the coredump:
nishakbe-u5:/users/nishakbe/local/mysqlgui-1.7.4> gdb mysqlgui core
This version of gdb is for
Dear All,
Can someone recommend a PHP/MySQL script for managing membership forms using
PHP and MySQL?
I need something like a dbmanager which was available by Selena, but it was
in perl with flat text database.
Individual data is viewed only by the person having his own ID, He is not
allowed to
Dear all i need help
i have mysql-3.22.26a over unix solairs 7
when i try to apply query from the console to retrieve some information
i got that error
ERROR 1030: Got error 127 from table handler
please help ..
Thanks
Sorry for bad english!
--
Name : Mohamed Abd El-Samei Mohamed
Company :
On Wed, Mar 14, 2001 at 03:51:18PM +0900, Tatsuhiko Miyagawa wrote:
> Oops, really :-)
Yes, he posted it in the message with
Message-ID: <[EMAIL PROTECTED]>
Jeremy
> On Tue, 13 Mar 2001 22:48:58 -0800
> "Jeremy D. Zawodny" <[EMAIL PROTECTED]> wrote:
>
> > > I can produce a core/backtrace if
Oops, really :-)
On Tue, 13 Mar 2001 22:48:58 -0800
"Jeremy D. Zawodny" <[EMAIL PROTECTED]> wrote:
> > I can produce a core/backtrace if necessary, but it sounds like this
> > easy to reproduce.
>
> Damn. Monty has already patched it. :-)
--
Tatsuhiko Miyagawa Livin' On The EDGE, Co.
On Tue, Mar 13, 2001 at 09:48:22PM -0800, Jeremy D. Zawodny wrote:
> On Wed, Mar 14, 2001 at 02:42:30PM +0900, Tatsuhiko Miyagawa wrote:
> >
> > On Mon, 12 Mar 2001 10:02:51 -0500
> > [EMAIL PROTECTED] wrote:
> >
> > >
> > > I just upgraded from Mysql 3.23.28 to 3.23.34 and I'm now seeing mysql
On Wed, Mar 14, 2001 at 05:36:00PM +1100, Leonard Coonan wrote:
>
> Further to your comment, I have had considerable benefits by
> creating an index of both keys as well. So I define 3 indexes
> userid, usernum, userid&usernum.
One of those is redundant.
If you index (userid, usernum) and then
Further to your comment, I have had considerable benefits by creating an
index of both keys as well. So I define 3 indexes userid, usernum,
userid&usernum.
hope this helps.
len
-Original Message-
From: Dan Nelson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 14 March 2001 16:06
To: Bob
On Wed, Mar 14, 2001 at 02:42:30PM +0900, Tatsuhiko Miyagawa wrote:
>
> On Mon, 12 Mar 2001 10:02:51 -0500
> [EMAIL PROTECTED] wrote:
>
> >
> > I just upgraded from Mysql 3.23.28 to 3.23.34 and I'm now seeing mysql
> > errors from my scripts that say "mysqld has gone away". The
> > /var/lib/my
On Mon, 12 Mar 2001 10:02:51 -0500
[EMAIL PROTECTED] wrote:
>
> I just upgraded from Mysql 3.23.28 to 3.23.34 and I'm now seeing mysql
> errors from my scripts that say "mysqld has gone away". The
> /var/lib/mysql/host.err log says this repeatedly:
same here.
Compiling with Innobase, and d
yup,
thanks, this is what I was looking for!
(just didn't know it)
Cheers,
Maxim Maletsky
-Original Message-
From: Thalis A. Kalfigopoulos [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 14, 2001 1:25 PM
To: Maxim Maletsky
Cc: [EMAIL PROTECTED]
Subject: Re: summarizing rows. an sql
In the last episode (Mar 13), Bob Silva said:
> Hope this isnt a dupe post...I mailed before confirmation was
> received so I think my post died.
>
> Here is the issue I run the query below and it takes forever ( 1+
> minutes ). It uses 2 keys (one unique) in the where clause but still
> does a f
On 14-Mar-01 Bob Silva wrote:
>
> mysql> explain SELECT usernum FROM client WHERE usernum=4158774796;
> +-+
>| Comment |
> +-+
>| Impossible WHERE n
Hope this isnt a dupe post...I mailed before confirmation was received so I
think my post died.
Here is the issue I run the query below and it takes forever ( 1+ minutes ).
It uses 2 keys (one unique) in the where clause but still does a full table
scan.
mysql> SELECT usernum FROM client WHERE u
What's wrong with SUM?
select sum(count)
from table;
Does it get any simpler than that?
regards,
thalis
On Wed, 14 Mar 2001, Maxim Maletsky wrote:
>
> Hello everyone,
>
> I have a quick question:
>
> the following table keeps a track of logged in users.
>
>
> CREATE TABLE auth_lost_in_s
Heres the query Im trying to run: takes about 2 minutes...both userid and usernum
columns have indexes...usernum is unique. Show keys follows.
mysql> explain SELECT usernum FROM client WHERE userid='Salty3' OR usernum =
4158774796;
++--+---+--+-+--+--
Hello everyone,
I have a quick question:
the following table keeps a track of logged in users.
CREATE TABLE auth_lost_in_space (
sid varchar(32) NOT NULL,
count smallint(5) unsigned zerofill DEFAULT '1' NOT NULL,
date datetime DEFAULT '-00-00 00:00:00' NOT NULL,
PRIMARY K
It actually does support foreign keys but for compatibility only. It is
data integrity of foreign keys that's not supported. In any case, if you
program properly and test your work thoroughly test your work then there is
no need for foreign keys. This is also one reason why mysql is the fastes
Hello,
I didn't receive any responses, so I thought I would try
resending this.
I just installed mysql (from source) on three machines,
and I have encountered the same problem on all of them.
Everything appears to work fine (including the benchmark
tests), but when I attempt to run the test suit
Well, really it matters on hardware
Some OS's have limits to file sizes, check your OS documentation on that.
Other than that, it's all a matter of how much hardware you put behind
mysql.
- Original Message -
From: "Jason Hurst" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesd
Almost, and sorry for the ambiguity. I have two tables, Product Group and
Product.
The product group only contains the 'Product Hierarchy' and the Product
table contains all the product information.
eg
Product Group
-
Prdgrp_idPrdprn_idName
1
Or you can fix your php by turning off the magic_quotes_gpc flag. You then
won't need to change your code.
Check out http://www.php.net/manual/en/configuration.php on how to do this.
I have provided an example on how to do this with apache running on a linux
machine.
- Original Message
Ok i know I've seen this somewhere but i can't find the specifications on
how much mysql can handle. I'm going to be developing a program for my
company which may require a rather large amount of records and i just need
to know the maximum capacity of mysql. Thanks for pointing me in the write
d
Dave Hewlett wrote:
> To...
>
> I previously placed this as a comment on a seemingly similar situation.
> However no one noticed it. As it is a possible bug in mysql i have re-entered it.
>
> >
> > I had an experience the other day in a controlled test environment that appears
> > to be similar
Very situational
Let me lay out what I *think* your saying your, tell me if I'm right/wrong.
You have a table with 3 (or more, but irelevent) columns. A sample of the
data is as such:
Product | Group | Name
1 | 1 | Full product listing
2 | 1 | Computers
3 | 2 | Motherboards
4 | 2 | Monitor
Hi, I was wondering if anyone could help me with some SQL. I have a product
group table that has a link to itself to allow me to build a hierarchy of
products. Each Product has a link/relationship to its parent, so I have
PRODUCT GROUP
PRDGRP_TK Primary Key
P
OS: Solaris 7, Sparc
MySQL Version: 3.23.29a
Problem:
Sometimes when I do a mysqladmin shutdown on the command line mysql restarts
itself instead of shutting down.
>From the CLI:
elvis~ >mysqladmin -uadmin -pdevsqladmin shutdown
Terminated
010313 18:17:40 mysqld
I'm using MySQL 3.23.29-1 on a Red Hat Linux 7.0 platform.
I've all patched the mysql-related bug fixes from Red Hat.
I'm using a pentiumiii 800mhz dual processor system.
I'm using mysql++ c++ api.
My program links well with the sqlplus library and
the mysqlclient library, but when I run the linke
Thank you for this, I missed the information in the manual.
It would seem that I need to install gcc-2.95, this is prooving to be a bit
problematic, there seem to be all kinds of dependancies and conflicts
occuring while trying to remove 2.96 and install 2.95 packages using RPM, my
distribution
I can also verify that the data seems to be stored properly (from mysql's
command line tool). The problem seems most likely to occur with larger text
strings
Anyone else?
-Scott
-Original Message-
From: Stephen Faustino [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 2:
> "JSB" == Jamie S Buchanan <[EMAIL PROTECTED]> writes:
JSB> More specifically, I have two DateTime fields (A and B), in my creation
JSB> script I want to set the default value of B to the value of A so that
JSB> when I write a new record to the table the position of B can be left
what's wro
Please drop the stick and back away from the dead horse, it has been beaten
enough. :)
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, March 13, 2001 12:35 PM
Subject: XML
> I've done some rudimentary snooping around on both MySQL's site and on
> go
Dear gentleman,
I am running mysql over FreeBSD and when i issue a "show logs" query to
mysql, my connection is droped (cause the process is killed).
Take a closer look:
mysql> show logs;
ERROR 2013: Lost connection to MySQL server during query
mysql> select user();
ERROR 2006: MySQL server has
Check the archives, we had this argument 2 weeks ago.
Cal
http://www.calevans.com
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 2:36 PM
To: [EMAIL PROTECTED]
Subject: XML
I've done some rudimentary snooping around on both MySQL's
I've done some rudimentary snooping around on both MySQL's site and on
google, trying to find out what status (if there is a status) on MySQL and
XML support.
If anyone could point me in the right direction, I'd really appreciate it.
I'd like to stay away from Oracle if I can manage, but it's XM
How exactly does the BEGIN/COMMIT/ROLLBACK transaction process work? The
examples I have seen are like:
BEGIN;
statement 1;
statement 2;
statement n;
COMMIT;
Does this imply that if any of the statements fail then a ROLLBACK will be
called, otherwise it will COMMIT?
--
I'm using 3.23.26-beta on FreeBSD 4.1.1-STABLE. I'm getting corruption in
the dump files in the form of "^A"'s showing up in strange places (they
mostly appear in table definitions, but also in the data that is close to
these definitions). The dump file cannot be used to restore if they are not
The following causes the mysql server to crash.
It works fine with 3.23.25-beta.
create table t ( a integer)
insert into t (a) values (0),(1),(2),(3),(4)
select * from t order by a limit 3
--Darrell Gallion
This Report was made using the WinMySQLadmin 1.0 Tool
3/13/2001 3:24:01 PM
Description :
show tables;
Duncan Hudson wrote:
> What's the SQL command to issue to list all of the tables that are contained
> in a given MySQL database?
>
> C. Duncan Hudson
> Dynax Solutions, Inc.
>
> Tel 216.292.8203
> FAX 216.292.8273
> EMail [EMAIL PROTECTED]
>
>
On Tue, Mar 13, 2001 at 08:40:20PM +0200, Heikki Tuuri wrote:
> I looked at the pthread header file which is, by the way, 52000 lines long :).
When I sent it, it was a tar file with /usr/include/pthread.h and the
complete subdir /usr/include/dce. The orverall length of all files may
match the numb
show tables;
Is your manual broken ?
Duncan Hudson wrote:
>
> What's the SQL command to issue to list all of the tables that are contained
> in a given MySQL database?
>
> C. Duncan Hudson
> Dynax Solutions, Inc.
>
> Tel 216.292.8203
> FAX 216.292.8273
> EMail [EMAIL PROTECTED]
>
> ---
We have also experienced the same exact behavior, also using the mm.mysql
driver, on Linux. However, our problem is intermittent. There are times
(though these times cannot be accurately predicted) where the data is
retrieved correctly, which implies that the data is stored correclty. We
have v
What's the SQL command to issue to list all of the tables that are contained
in a given MySQL database?
C. Duncan Hudson
Dynax Solutions, Inc.
Tel 216.292.8203
FAX 216.292.8273
EMail [EMAIL PROTECTED]
-
Before posting, p
select describe mytable ;
will return parseable data.
Mark Worsdall wrote:
>
> Hi,
>
> When reading field names (or a row of data) how does one read the
> possible enum values, so I can put them in a drop down menu?
>
> M.
>
> --
> He came from Econet - Oh no, I've run out of underpants :(
>
Actually, I think it could work the other way around.
(Oops, this is off topic now.)
Informix (in version 9.2.something) has
what they call "virtual table interface"
and they provide an ODBC wrapper, I think.
So you might send your queries to Informix
and Informix could pass (parts of) them furt
> gnanas wrote:
>
> Dear Sir,
>
> We are from Chennai, India.
> We are holding one site constructed using JSP pages. We couldn't connect to the
>mysql database using myodbc driver! The
> specified driver is not installed in the virtual server the hosting company!
> Do we have any otehr alternat
I'm getting a very strange results all of the sudden when dealing with BLOBs
in a mysql 3.23.32 on a Solaris 7 (SPARC) machine (inserts/deletes handled
with the JDBC driver from http://mmmysql.sourceforge.net/)
If I do the following:
1) Create a BDB table with a blob column:
CREATE TABLE test4(
this was true on php 4.01 but not on php 4.04pl1, i have to escape my
strings again. or it's some switch or conf setting i never
seen/heard/thought of...
i now use $var=addslashes($var) on php4.0.4pl1 redhat 7 where i do not have
to on a other system running php4.0.1 redhat 6.2 !
especially php
Hi
I'm newbie in MySql. I'm trying to import an access MDB into MySql and access it with
PHP. Also have instaled MyODBC. When calling MySQLAdmin cant find a data
transformation service like MS SQL.
Any clue?
P.D. Be patient with my English.
Thanks
javier
[EMAIL PROTECTED]
Try this.
http://www.microsoft.com/data/odbc/
- Original Message -
From: satish <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, March 12, 2001 8:02 AM
Subject: ODBC driver doumentation !!!
> Hello ,
>
> I am developing front end applications with backend mysql server in
>
Title: Untitled
Dear Sir,
We are from Chennai, India.
We are holding one site constructed using JSP pages. We couldn't connect to
the mysql database using myodbc driver! The specified driver is not installed in
the virtual server the hosting company!
Do we have any otehr alternative?
Pleas
Lutz,
I looked at the pthread header file which is, by the way, 52000 lines long :).
It seems that pthread_attr_t and pthread_t are not pointers like in some
other Unixes, but structs of three fields:
struct {
field1; /* this is a pointer */
field2; /* a short int */
Remove unsubscribe
neither one of the 2 methods listed below for name remove seem to function
please remove me from this list ASAP...
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://
Hi!
> "Andrew" == Andrew Sitnikov <[EMAIL PROTECTED]> writes:
Andrew> Hello Michael,
Andrew> Crash with 'show variables;'
Andrew> configure:
Andrew> CC=gcc \
Andrew> CFLAGS="-O6 -fomit-frame-pointer" \
Andrew> CXX=gcc \
Andrew> CXXFLAGS="-O6 -march=i686 -fomit-frame-pointer -fno-exceptions
Hi,
When reading field names (or a row of data) how does one read the
possible enum values, so I can put them in a drop down menu?
M.
--
He came from Econet - Oh no, I've run out of underpants :(
Home:- [EMAIL PROTECTED] http://www.wizdom.org.uk
Shadow:- [EMAIL PROTECTED] http://www
Two things here.
First off, we had this problem spring up on us, and I think I may know why
it's doing it to you. If your using PHP, the more recent version
automatically escape out variables sent to the mysql driver. Thus randy's
is converted to randy's. HOWEVER, if you still have old code wh
Hi,
I am trying to read the field types (as well as 1 row of data and the
field names), but I cannot seem to manage it. Any ideas on how?
M.
$sth = $dbh->prepare("SELECT * FROM $sqlTable WHERE id = $id");
$sth->execute;
my $hash_ref= $sth->fetchrow_hashref;
my @staffFields = keys(%{$hash_
Just realized, the query I sent you will remove ALL instances of \ inside
the field you specify, if that isn't your intent, and you only want to
remove \' then do this:
UPDATE tablename SET fieldname = REPLACE(fieldname,'\\\'','\'');
-
Friends.
people out in here are very afraid , when they hear Mysql does not support foreign
keys.
It really become difficult , why foreign keys are not enforced by mysql.
I wish , there was another way.
Anyways, can u please tell me does our favourite database support composite foreign
key..
I'm not sure if anyone cares but... here's my final post on this topic.
I believe my signal 11 problem was due to me installing the 3.23.34 rpms
from mysql.com on top of my Redhat 7.0 system. I had heard that the RPMs
on mysql.com are Redhat 6.2 based and thus may be expecting different
dynam
Randy Johnson wrote:
>
> When a text with an apostrophe in it has a \' in it. How can I fix this?
>
> example
>
> randy's is stored in the DB as randy\'s
>
> thanks
>
> Randy
If you just want to fix that one instance just do
update set = 'randy\'s' where
-
When a text with an apostrophe in it has a \' in it. How can I fix this?
example
randy's is stored in the DB as randy\'s
thanks
Randy
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
I noticed that 'EXPLAIN TABLE' no longer shows the Privileges column, which
I think is a good thing as I'm never interested in it and it makes my
screen hard to read because it causes wrapping.
...but, mysqlshow still shows the Privileges column.
Is there any plan to make these two very simila
Since upgrading to mysql 3.23 and using MYIAM tables, I'm experiencing a
problem which is becoming more and more common. When conducting queries
which take more than about 15 seconds to run (ie mass deletes, mysqldumps,
check table etc), I end up with corrupt tables. The database server is the
bac
If you block user access during the recovery, would it be faster w/o the
indexes and then add the indexes through alter table and then let the
user's in. This is the recommended solution for recovery for DB2. If you
have to do a recovery, its normally assumed that the database is locked
for s
Hi,
> I read on Paul DuBois' excellent book that longblob are 2^32-1 wide,
> but actually the communication _protocol_ between clients and server
> limits to 24Mb the dimension of a single record.
>
> What workarounds could I use ?
A simple workaround is that you store the binary data as files o
On Tue, Mar 13, 2001 at 06:42:19PM +0200, Heikki Tuuri wrote:
> >Ok, let's try to narrow things down: I have switched to GCC for the time
> >being and got a similar compile error:
> >gcc -DHAVE_CONFIG_H -I. -I. -I.. -I../../include -I../include-O6 -DDBUG_OFF
> >-DHPUX -I/opt/dce/include -DHAV
Lutz,
I think you have found the problem.
>Ok, let's try to narrow things down: I have switched to GCC for the time
>being and got a similar compile error:
>gcc -DHAVE_CONFIG_H -I. -I. -I.. -I../../include -I../include-O6 -DDBUG_OFF
>-DHPUX -I/opt/dce/include -DHAVE_BROKEN_SNPRINTF -c os0th
If I pull the hostname, I don't get 'myserver.com', but this server never
was called 'myserver.com' to begin with.
The 'myserver.com' domain was expired for the last year or so, but I never
removed it from the DNS records until recently. So really, for the last
year, 'myserver.com' never refered
>Description:
After completing the configure step, which went fine (using
the options recommended in the guide), the installation stopped when
using gnumake.
>How-To-Repeat:
The problem was traced to making the client components,
in particular mysql. The problem was that c++ com
when you enter the unix command
hostname
what do you get ?
This had better be resolvable with your DNS.
Maybe you forgot to fix your hostname when the domain was changed.
"Weber, Jeff" wrote:
>
> I've gathered more data on my problem here. We have recently made a few DNS
> changes that I thin
I've gathered more data on my problem here. We have recently made a few DNS
changes that I think have hosed mysql. See the error message below:
DBI->connect failed: Unknown MySQL Server Host 'myserver.com' (2) at
/home/httpd/test/stage2/cgi-bin/send_requests.cgi line 28
Can't call method "prepare
In the last episode (Mar 13), Peter Zaitsev said:
> Well guys mysqldump have one serious problem - the speed.
>
> The backup speed is quite upsetting and loads system much, but the
> worst thing is recovery speed.
> In my case the data is added in realtime - most queries are inserts
> which utili
Does your query exceed the maximum packet size?
Xinkun Wang wrote:
>
> I do a mysql query as below
>
> update table set something = something where onecolumn in ("a","b",etc);
>
> It works well when the array ("a","b",etc) after in is less than 1000, but
> when the array ("a","b",etc) contains
Hello!
I'm a beginner of the wonderful world of MySQL :-)
I'm planning to deploy MySQL for a project of my company but I've some
concern about real size limit of BLOBs.
situation: MySQL 3.23.33 on FreeBSD 4.2-stable, clients are near always
Win machines with MyODBC and proprietary software.
I do a mysql query as below
update table set something = something where onecolumn in ("a","b",etc);
It works well when the array ("a","b",etc) after in is less than 1000, but
when the array ("a","b",etc) contains more than 1000 element, it seem the
command doesn't work. I am not sure whether th
on 3/13/01 12:41 AM, Gilles Dumangin at [EMAIL PROTECTED] wrote:
> I would like to extract the contents of a database to use it in a ASCII
> format. It is a addresses database and I want to use it in Excel. I have
> tried Mysqldump but it gives me the CREATE and INSERT statements all the
> time.
The valid range for an 'int' data type (your "id" column) is -2147483648 to
2147483647. The value you are attempting to set (37647438380) is not within this
range.
--Greg Johnson
-Original Message-
From: Andreas Gietl [mailto:[EMAIL PROTECTED]]
I've got a nasty problem with my mysql-database.
On the following INSERT (and on others too and on some SELECTs) i get
the following error.
mysql> INSERT INTO hyperseek_keys SET
keyword='meiner_asiatinne',id='37647438380',price='0.01',xfactor='7.50';
ERROR 1030: Got error -1 from table handler
I
On Tue, Mar 13, 2001 at 12:00:57AM +0200, Heikki Tuuri wrote:
> >om scalar to scalar or to void type.
> >cc: "os0thread.c", line 69: error 1554: Indirection must be through a pointer.
> >cc: "os0thread.c", line 69: warning 563: Argument #2 is not the correct type.
> >cc: "os0thread.c", line 69: er
No, Daniel. This operation is atomic ( can not be separated into smaller
parts ).
This is the correct way to do updates without user locking.
The update thread will automatically lock the file during the update
so no other process can modify the data.
Daniel B I wrote:
>
> Hello,
> if there is
Hi,
PS> If you're looking for PAM modules that authenticate from a mySQL
PS> database, I know they exist - although I can't comment on them as I
PS> haven't used them before.
Nop. I'd like MySQL to authenticate their users through PAM.
I want to put userids and passwds on my LDAP server. It w
You can NOT use gcc-2.96.
The manual is clear on this, as are dozens of posts in the archives.
Kevin Price-Ward wrote:
>
> Hi,
>
> I trying to install mysql from source on a RedHat 7 box,
>
> mysql version 3.23.34a
>
> output from uname -a: Linux webserver.tmxnm.cxm 2.2.16-22smp #1 SMP Tue A
No.
MArk Williams wrote:
>
> This is not what I meant.
> I have a mysql DB running. I have a remote informix DB running.
> I have DBI/DBD informix/mysql all setup and working.
> I can access the remote informix database through perl scripts.
> BUT what I want is my scripts to ONLY access the mys
I've got a nasty problem with my mysql-database.
On the following INSERT (and on others too and on some SELECTs) i get
the following error.
mysql> INSERT INTO hyperseek_keys SET
keyword='meiner_asiatinne',id='37647438380',price='0.01',xfactor='7.50';
ERROR 1030: Got error -1 from table handler
I
Maybe you FTPed the file in text mode instead of binary?
[EMAIL PROTECTED] wrote:
>
> Dear all,
> I have downloaded the package mysql-3.23.34-pc-linux-gnu-i686.tar.gz
> from www.mysql.com,but I can't gunzip it on linux , the following is error
> message:
> [test@linux owen]$ gunzip -c my
"P.Peti" wrote:
>
> Hello,
>
> Thanx for the answers, I think I've got the point now. I
> have one more doubt though. You described me that this
> whole thing with the comparison not working with NULL
> values is obvious. Why did it work in 3.22.25 then?
>
> Thank you for the answers so far.
>
If you're looking for PAM modules that authenticate from a mySQL
database, I know they exist - although I can't comment on them as I
haven't used them before.
regards,
P
On Tue, 13 Mar 2001, Roberto Meyer wrote:
> Hi,
>
> We're trying to "unify" the authentication system in our Linux.
>
> PA
Hi,
We're trying to "unify" the authentication system in our Linux.
PAM is the obvious solution and we thought LDAP will do well in
storing users attributes (including userids and passwds)
The only annoyance is that MySQL doesn't support PAM but Radius
instead... why Radius? Is there any other
Hi!
Which table formats would you advise (Berkley DB, Gemini or Innobase) for
medium size web project. Need to add transactions over multiple tables in 2
places.
Thanks.
-- Oleh Khoma
[Email: [EMAIL PROTECTED]] [ICQ: 55191139]
[FIDO: 2:462/90.80][BrainBench: 504369]
-
Daren Cotter writes:
> Sorry to post AGAIN, but I have new info. I was monitoring the Error Log,
> and when I run the query that crashes MySQL, I get the following error:
>
>
> mysqld got signal 11;
> The manual section 'Debugging a MySQL server' tells you how to use a
> stack trace and/o
Select * from table order by age, name, surname
Select * from table order by age, name, surname where age>11
Cal
http://www.calevans.com
-Original Message-
From: Rino Nucara [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 5:18 AM
To: MySQL mailing list
Subject: Help for a quit
That's what mysqldump does. Try using a SELECT statement with an outfile.
Check the manual, chapter 7, the part about SELECT for details.
Cal
http://www.calevans.com
-Original Message-
From: Gilles Dumangin [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 1:42 AM
To: [EMAIL PRO
I have tree columns: name,surname,age.
how can I order this columns first by age, then by name , at the and by
surname. like that:
NAMESURNAME AGE
zanna bond10
barbara astic 15
barbara bard40
barbara zard
>Description:
We are trying to run some fairly complex joins over large tables. The queries
can take up to a day or more to finish. We feel that there must be something
wrong with either the table structure, or the join query itself. There are two
tables involved, and the join requires each of the
Hello Heikki,
Monday, March 12, 2001, 11:51:54 PM, you wrote:
HT> Hi Peter,
HT> and sorry that this response to your Big Mail comes some 12 days late.
HT> We have put together the release 3.23.34a and that has occupied
HT> my mind.
No Problem. At least the progress is going :) I'll try to test
Hello,
Synopsis: Impossible to install DBD::mysql perl driver
Release: MySQL-3.22.32-5mdk.i386.rpm
Environment: Standard Linux Mandrake 7.0 distrib.
Description :
I have fully installed DBI.pm perl package with cpan command : "perl -MCPAN -e shell"
No problem.
When i connect manual
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of
> Martin Moss
> Sent: Wednesday 07 June 2000 16:03
> To: Perl-Win32-Users Mailing List; [EMAIL PROTECTED]
> Subject: Corruption of Database
>
>
> All,
>
> I have a problem with a mysql database.
>
Hello,
if there is a MYSQL developer member (or guru), I would
like to ask if there is possible that another query modify
a field between the detection of a target row and the changes
made to it, by an update query.
Let me explain myself a little: suppose we have an update query, like
this:
UP
Hi,
I trying to install mysql from source on a RedHat 7 box,
mysql version 3.23.34a
output from uname -a: Linux webserver.tmxnm.cxm 2.2.16-22smp #1 SMP Tue Aug
22 16:39:21 EDT 2000 i686 unknown
Hardware is Compaq 5000 professional workstation
Compiler is gcc-2.96-54
When I run ./configure --
1 - 100 of 107 matches
Mail list logo