On Sat, Jan 31, 2004 at 10:06:04PM -0500, Michael Stassen <[EMAIL PROTECTED]> wrote:
> Meanwhile, perhaps a simpler workaround would be to change how you build
> the query in Perl so as to avoid the quotes.
Unfortunately, the heuristic that DBD::mysql uses cannot be changed or
forced. Currently,
I just learned that MySql 4 comes installed on OS X server. There is this
little admin app that allows you to enable it, I was not used to this, but
it seemed to work, I was able to login and see the 'test' table.
I then proceeded to set up the password.
/usr/local/mysql/bin/mysqladmin -u root pa
A.J. Millan,
At 01:31 PM 1/31/2004, you wrote:
In respect to ORDER BY ... DESC combined with LIMIT 1:
I´v arrived to this other for my own (thank you anyway), but I suspect that
maybe it is not very efficient from the computation point of view (I suppose
it must travel the whole table to discard
I think the problem has nothing to do with &. Taking the & out of your
examples leaves you with:
mysql> select '9223372036854775809' + 0;
+---+
| '9223372036854775809' + 0 |
+---+
| 9.2233720368548e+18 |
+---+
mysql> s
Hello,
As far as I understand, setting innodb_flush_log_at_trx_commit to 0
could lead to several problems (data loss ?, ...).
Can you tell me more about it ?
Regards.
Geoffrey Dufour
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.
WOW !!
The story goes on:
I wrote the UDF-Functions (and64/or64) and while and it seems
to work:
mysql> select and64('9223372036854775809',127);
+--+
| and64('9223372036854775809',127) |
+--+
|1 |
+--
Hi !
select 129 & 127; -- ok(1)
select '129' & 127; -- ok(1)
select (0+'129') & 127; -- ok(1)
select CAST('129' AS UNSIGNED INTEGER) & 127; -- ok(1)
select CONVERT('129', UNSIGNED INTEGER) & 127;-- ok(1)
Doing the same wi
Got it thanks - "set-variable=old-passwords=1" in the ini file
-Original Message-
From: Randy Chrismon [mailto:[EMAIL PROTECTED]
Sent: 31 January 2004 21:11
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Subject: Re: Passwords and ODBC - what am I missing
Oh, and one other thing, you ha
On Sat, Jan 31, 2004 at 08:31:38PM +0100, A.J.Millan wrote:
> LAST_INSERT_ID() function:
>
> This other one has proven before, but in my case it returns many results (in
> fact, the last one es the desired data).
>
It will return a single result if you just do this:
SELECT LAST_INSERT_ID();
Do
Daniel,
- Original Message -
From: <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Monday, January 26, 2004 5:53 AM
Subject: key constraint error on replace
> Hi there, i am trying to use a replace, when mysql throws an error
> of "Cannot delete or update a parent row: a f
Mauro,
- Original Message -
From: "Mauro Marcellino" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Friday, January 30, 2004 6:51 PM
Subject: Re: InnoDB Backups
> By open file tool I mean software that works concurrently with a backup
> suite such as veritas that would ba
Recently I became aware that MySQL 3.23.58 on my Solaris 8/x86 box was
ignoring my /etc/hosts.allow and /etc/hosts.deny files and permitting
unrestricted connection access to my MySQL daemon.
I use entries such as "mysqld: 127.0.0.1" and "mysqld: ALL" in hosts.allow
and hosts.deny, respectively.
Oh, and one other thing, you have to create the passwords AFTER you use
the switch! That was probably obvious to you but it took me a while to
figure out.
Randy
Randy Chrismon wrote:
Ken Brown wrote:
Just installed 4.1.1 on windows 2000 with current odbc layer
Connects fine with root and no
Hello Alll
Mysql is geting stucked by sleeping process like the table:
+-+-+---+--+-+--+---+---+
| 421 | postfix | localhost | postfix2 | Sleep | 121 | | NULL
|
| 422 | postfix | localhost | postfix2 | Slee
* A.J.Millan
> In respect to SHOW TABLE STATUS LIKE "tablename"
>
> Seemingly it doesn't work.
It would require that you have allready issued "USE dbName", or started the
client with dbName as a parameter, making it the 'current' database.
> The sintax SHOW TABLE STATUS FROM dbName
>
> Work fin
Ken Brown wrote:
Just installed 4.1.1 on windows 2000 with current odbc layer
Connects fine with root and no password
But if I set a password on root or create a user with a password odbc fails
with
"Client does not support authentication protocol requested by the server -
consider upgrading M
* Edouard Lauer
> I would like to query the littlest average salary. I have a table with
> employees and their salary like that:
>
> +---+--+
> | job | sal |
> +---+--+
> | CLERK | 800 |
> | SALESMAN | 1600 |
> | SALESMAN | 1250 |
> | MANAGER | 2975 |
> | S
Anyone managed to get oracle forms 6i to talk to MySQL - if so how?
I've got ODBC working but it will not connect and the ODBC trace is less
than useful
Ken
Roger:
Thank you for your kind answer.
In respect to SHOW TABLE STATUS LIKE "tablename"
Seemingly it doesn't work.
The sintax SHOW TABLE STATUS FROM dbName
Work fine, but it works at database level (can present access problems).
Also must obtain the result for ALL the tables in the database
Hello,
I would like to query the littlest average salary. I have a table with
employees and their salary like that:
+---+--+
| job | sal |
+---+--+
| CLERK | 800 |
| SALESMAN | 1600 |
| SALESMAN | 1250 |
| MANAGER | 2975 |
| SALESMAN | 1250 |
| MANAGER |
My name is Valentin IONESCU,
I download MySQL 4.1.1 and MySQL Control Center.
I issue a subquery that works correctly on server, but
when I try to execute it from MySQL Control Center I
receive the message [MySql_server] ERROR 1235: This
version of MySQL doesn't yet support 'LIMIT &
IN/ALL/ANY/SO
Lawrence,
- Original Message -
From: "Lawrence Smith" <[EMAIL PROTECTED]>
To: "Heikki Tuuri" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, January 31, 2004 6:47 PM
Subject: Re: Shrinking innodb datafiles?
> Heikki,
>
> thanks for the reply, will note.
>
> Just to confirm i
I need to do this to get round password issues as -old-passwords doesn't
work
Anyone any ideas?
Kwn
I've did some more checking - I cannot set passwords anywhere (that is if I
want to connect with the account)
There are no logs as to why its not working.
I can only presume 4.1.1 is in the middle of a security overhaul and that's
why its now working here but perhaps someone could advise otherwis
Heikki,
thanks for the reply, will note.
Just to confirm if I understand the situation
correctly: innodb datafiles cannot be reduced in size
to reclaim spaced freed by deleted data? (That'd
probably explain why I had a hard time finding ISPs
offering innodb-enabled MySQL).
Lawrence Smith
---
Just installed 4.1.1 on windows 2000 with current odbc layer
Connects fine with root and no password
But if I set a password on root or create a user with a password odbc fails
with
"Client does not support authentication protocol requested by the server -
consider upgrading MYSql Client"
* A.J.Millan
> Supposing that fieldName is the a primary numeric auto-increment Key field
> in a table.
> Does exist some direct method to find the biggest fieldName value actually
> stored? (without scan across all the table)
There are several ways to do this, which way to use depends on the
situ
Ronan,
If your queries are only returning fewer than a hundred rows, and
if every join is indexed, I would have expected it to take only a second or
two at most.
Have you put "Explain" in the front of the query to see if it is
using an index on all the joins?
Your "( ( T
Kyle,
Sounds like you've thought of everything.
How much disk space does your largest table take up? Probably too
much for what I'm about to suggest. There are commercial external ram disks
that support gb volumes. You could create a temporary database on the RAM
disk, file copy
Hi all:
Supposing that fieldName is the a primary numeric auto-increment Key field
in a table.
Does exist some direct method to find the biggest fieldName value actually
stored? (without scan across all the table)
Regards
A.J.Millan
ZATOR Systems.
--
MySQL General Mailing List
For list arch
I have more than enough space on the box.
At the beginnig I check table status and got no error messages. Any ideas
what can cause such error.
I use mysql 4-0.13.
The documentation http://www.mysql.com/doc/en/Full_table.html refer to older
version of mysql.
Any ideas how to fix the problem?
_
31 matches
Mail list logo
