Have you tried insertig non-breaking space instead #160 or 0xA0 ...i think so
" " - this shoud be it /taken from here "3,02 KB (3 098 bytes)"-All
NON-Breaking/
HTH ;-)
John Mistler wrote:
> Is there a way to force an invisible "space" character to be stored at the
> END of a string in a column (e
Hi everyone,
If a user 'x' has exhausted all his connections, is there a way to free
up those connections. What command do I use for that?
Deepak
We just had another machine that this weird bug introduced itself onto.
However, I just noticed something interesting; they're both running
mysql-3.23.58. Most of our production servers are 3.23.57 or below. Also,
there was a specific change to 3.23.58 dealing with password handling:
"Fixed buffe
I am having a major issue with a bulletin board I run. We put the site up
and after a week or binaries just start segfaulting. The mysql database
also gets constantly corrupted. The longer the box is up the more
frequent the corruption is. It can be repaired with myisamchk.
We have been on two
At 23:13 +0200 5/2/04, Alessandro Sappia wrote:
When I create a table with InnoDB there is a strange behaviour in it:
mysql> CREATE TABLE prometeo_indirizzi_cliente (
-> indirizzi_cliente_id int(10) unsigned NOT NULL auto_increment,
-> denominazione_indirizzo_id int(10) unsigned default
When I create a table with InnoDB there is a strange behaviour in it:
mysql> CREATE TABLE prometeo_indirizzi_cliente (
-> indirizzi_cliente_id int(10) unsigned NOT NULL auto_increment,
-> denominazione_indirizzo_id int(10) unsigned default NULL,
-> cliente_id int(10) unsigned defa
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Deepak Vishwanathan wrote:
| Hi,
|
|
|
| I am writing a thread safe connection pool class. I want to connect to
| MySQL through jdbc driver. In the initialization method, I write a
| method that makes connections to the database and stores them in a
|
Hello,
Trying to fix this problem "mySQL error 1016"
I found this at the InnoDB site.
Another symptom of an out-of-sync data dictionary is that MySQL prints an error
that it cannot open a file yourtablename.InnoD
Hi,
I am writing a thread safe connection pool class. I want to connect to
MySQL through jdbc driver. In the initialization method, I write a
method that makes connections to the database and stores them in a
vector. When, I try making the 99th connection, MySQL throws an error
that says "java.
In the last episode (May 02), Mailing List Receiver said:
> We weekly rotate the mysqld log. I need to find a way to query the
> server to see how many current connections with clients there are,
> so I can wait to restart the server when the number of connections
> is zero. mysqladmin doesn't se
I'm glad you brought this up, because I am trying to figure out the same
thing. I have created an application for OS 10.3 which stores its data in a
MySQL database. I would like to be able to install the app on other
computers from a CD, without having to set up MySQL separately on each
computer.
We weekly rotate the mysqld log. I need to find a way to query the
server to see how many current connections with clients there are,
so I can wait to restart the server when the number of connections
is zero. mysqladmin doesn't seem to have this capability.
Is there any other way?
Todd Merriman
Hello all,
I have a query about distributing mySQL.
I am a student developer, but have very little experience with
databases, I develop in Cocoa for OS X (as well as a little bit of
Windows stuff).
An application I am writing stands to benefit a lot from having a
server application available.
I do something similar in my PHP applications - using an object wrapper to
the SQL connection. That way, when an error occurs, the object automatically
outputs the query, along with any error which was returned.
Cheers,
Matt
> -Original Message-
> From: Richard Bryson [mailto:[EMAIL PRO
To me, this is entirely a matter of personal choice - and the important
thing is to pick a standard and stick to it. :)
I usually end up with a table called 'People' for arguments sake, which will
have an abstract PK (auto increment int) called PeopleID (I always use the
table name). I also capita
As others have said, you can use 'IN'. You could also use UNION (although I
don't think I would, personally, for quite what you want!):
SELECT word FROM word_table WHERE id = 1
UNION
SELECT word FROM word_table WHERE id = 2
Etc. Assuming your version of MySQL supports the UNION operator!
Another
Howdy --
What I want to do is use Xbasic as a frontend for MySQL. The problem is I'm
mainly a PHP(and a little Perl) person.
It looks like we should be able to make calls to the MySQL libs,dills & headers
from Xbasic. My interest for the mement is with doing it on Windows.
Here's the Xbasic site
I am using 4.0.18. I also checked out the "Bugs Fixed" report--and it kind
of looks like #2295 applies, although I can't be certain. It definitely
returns rows without trailing spaces, even though the SELECT asks for rows
WITH trailing spaces.
Hmmm...
on 5/2/04 2:05 AM, Matt W at [EMAIL PROTECT
John Mistler <[EMAIL PROTECTED]> wrote:
> I know this is an elementary question, but I am getting two sets of
> instructions from different MySQL manuals about setting an index on a prefix
> of a column of a table. One says to use:
>
> KEY indexName (colName(length))
>
> and the other says to us
Hi John,
What version do you use? In 4.0.18, they fixed some bugs that were
introduced in 4.0.17 related to trailing spaces on indexed TEXT-family
columns: http://dev.mysql.com/doc/mysql/en/News-4.0.18.html
I see 3 "Bugs fixed" entries with "trailing spaces" in them. If you're
not using 4.0.17,
Hi, Ivan and all!
Tanks, but create a symlink from... to?
Another question how can see the compatibility of authentification?
I'm not very experiency on Linux and Mysql.
Thanks,
Segismundo
|You can create a symlink.
|Have you tested compatibility between MySQL 5 and 4 concerning
|authentificati
Hi John,
- Original Message -
From: "John Mistler"
Sent: Sunday, May 02, 2004 12:50 AM
Subject: Indexing
> I know this is an elementary question, but I am getting two sets of
> instructions from different MySQL manuals about setting an index on a
prefix
> of a column of a table. One say
22 matches
Mail list logo
