On 8 Feb 2004, at 00:29, [EMAIL PROTECTED] wrote:
Hi,
I have instaled mysql 4.0.17 on a debian server, but i have a big
problem.
I can only connect to mysql at the server and only with -h localhost.
If I try
this:
mysql -h server -u root
from anywhere i receice always the same response:
On 27 Jan 2004, at 00:37, tait sanders wrote:
i've run both 'perl -MCPAN -eshell' and 'make DBI' and both come back
reporting heaps of errors like the following:
"from Perl.xs:1:
/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h:380:
30: sys/types.h: No such file or directory
/
On 13 Jan 2004, at 19:11, Jochem van Dieten wrote:
I most certainly hope this Oracle idiosyncracy will never make it into
MySQL.
The SQL standard defines a different syntax for doing recursive
queries, using WITH RECURSIVE. I see no reason for MySQL to implement
a non-standard way for doing recurs
On 13 Jan 2004, at 19:49, Chris L. White wrote:
Ok I was able to use mysqlcc and as long as I keep the host name
localhost
it will let me in. But the name of the host should be Napmarilu or
the IP
number right? When you change it to either one of those it will not
let you
in. So how would I
On 13 Jan 2004, at 09:19, Victor Reus wrote:
Hi again,
Second: specify what you mean with "all relations". Can you
share some sample data and sample output (that is: what
do you expect the query to return).
Ok my table noms is like
| id | int(11) | | PRI | [NULL] | a
On 10 Jan 2004, at 17:47, Michael Stassen wrote:
Eg. if you've two host entries; one '192.%' and the other '192.168.%'
- and you connect from 192.168.100.12, which row gets chosen?
As I understand it, 192.168.% is more specific than 192.%, so
192.168.100.12 would match 192.168.%
My thoughts ex
On 9 Jan 2004, at 22:43, Michael Stassen wrote:
As [EMAIL PROTECTED] and [EMAIL PROTECTED] are separate entries in the user table,
each with its own password and privileges, they are 2 separate root
accounts from mysql's perspective. You could choose to think of them
as the same accoun
On 8 Jan 2004, at 04:12, Paul F wrote:
Greetings, I am wandering under what circumstances it is
sensible/beneficial
to use multiple databases for a single "project," and why.
The reason I ask is because I am re-developing an existing database
with
MySQL that someone else created with another en
On 7 Jan 2004, at 22:24, Rob Brahier wrote:
I made an online file manager using PHP and MySQL some years ago, and
am
now embedding something similar into my office's database front-end. I
decided to store our files in the file system rather than the database
in order to keep the DB size low. A
On 7 Jan 2004, at 21:51, [EMAIL PROTECTED] wrote:
This article discusses it briefly:
http://php.dreamwerx.net/forums/viewtopic.php?t=6
That's an interesting article. Thanks. A similar table design to what
I had in mind (hmmm... how different can these things be! :)
I like the idea of splitting
Hi,
(disclaimer - this thread could easily go off topic; I'm interested
only in the MySQL aspects of what follows...)
At work we are currently investigating ways of filing all our
electronic documents.
There is commercial software that will do this I know, but I was
wondering whether MySQL wo
On 5 Jan 2004, at 21:10, Sid Lane wrote:
on mysql 4.0.14-standard (x86 Linux) when I try the following:
alter table child_table
add ( foreign key (column1, column2)
references parent_table
on delete cascade)
;
on an existing innodb table I get:
ERROR 1005: Can't create table './dbname/#sql-70f
On 5 Jan 2004, at 19:58, Bing Du wrote:
Greetings,
Say, one database has a lot of tables. How can I drop some of them
all at
once assuming their names follow some pattern like tbl_*?
Thanks in advance for any ideas,
Take a look at a very similar thread here...
http://lists.mysql.com/mysql/15
ert I
receive a message
ERROR: 1062 Duplicate entry '2147483647' for key 1.
Why id (primaty , and auto increment) start from 2147483647 and not
from 0 or 1
Thanks
From: Steve Folly <[EMAIL PROTECTED]>
To: MySQL MySQL <[EMAIL PROTECTED]>
Subject: Re: insert: auto increment field
On 4 Jan 2004, at 15:09, Mike Mapsnac wrote:
I have table with 7 fields. First field is id (auto increment). As I
understand the value should start from 0 and next value will auto
increment.
And I shouldn't add insert the value. So the insert
statemens below gives me an error. ERROR 1136:Colum
I've forwarded this reply to the list so other people may benefit from
the information.
Steve.
Begin forwarded message:
From: Eldon Ziegler <[EMAIL PROTECTED]>
Date: 2 January 2004 18:58:36 GMT
To: Steve Folly <[EMAIL PROTECTED]>
Subject: Re: MySQL and Crystal Repor
On 2 Jan 2004, at 12:26, Eldon Ziegler wrote:
Has anyone used Crystal Reports successfully with MySQL? I tried the
ODBC driver but it was rejected with a message that the "Professional"
version was needed.
The issue might be with Crystal Reports itself and nothing to do with
MySQL. Are you usi
On 30 Dec 2003, at 16:22, Carlos Andre Moura de Amorim wrote:
i have a follow problem, please, help-me
[EMAIL PROTECTED] db]# mysql --user=root --password=xx
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password:
YES)
Wrong password or root does not have a password. (The '
her varchar (5) ,
Date date ,
CreateDate date ,
KEY `ID` (`ID`)
)
Thanks,
Daryl Hansen
On Dec 26, 2003, at 11:54 PM, Steve Folly wrote:
On 27 Dec 2003, at 08:59, daryl hansen wrote:
How do I make "Field3" a calculation, which equals 2 if fields 1 & 2
w
On 27 Dec 2003, at 08:59, daryl hansen wrote:
How do I make "Field3" a calculation, which equals 2 if fields 1 & 2
where values set to "1"? Any pointers in the right direction would be
sincerely appreciated.
Take a look at 6.3.1.3 and 6.3.1.4 in the MySQL documentation for
logical operators a
Hi,
I'm not sure if that subject made any sense!? What I'm looking to do is
take an existing product we have (a software defect tracker) that uses
flat files to store defect entries. Modifications to each defect are
recorded as diffs using the perl module RCSLite (like your standard
RCS, but
21 matches
Mail list logo
