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 (either
Hi List,
Is it possible to change data and log files (ibdata and iblogfiles copied for backup
purpose) on the fly?
Will something like this work??
1. Close all client connections
2. Flush and disable further client connections.
3. Copy ibdata and iblogfiles from backup dir
4. SIGHUP mysqld.
Hallo !
Strange problem with maxdb odbc connections.
I installed maxdb, databasemanager and sqlstudio on my local windows xp
pc and did some testing.
My application connects via system-dsn MAXDBLOKAL
STORE
SQLSTRINGCONNECT('dsn=maxdblokal;port=7210;uid=DBA;pwd=DBA;DATABASE=BWNE
U') TO
Hi,
Ok. This is good!! Thank you!
Zoli
Egor Egorov [EMAIL PROTECTED]
2004-04-30 03:30 PM
To: [EMAIL PROTECTED]
cc: (bcc: Zoltan Gyurasits/GYO/COMP/PHILIPS)
Subject:Re: SQL SELECT HELP
Classification:
[EMAIL PROTECTED]
Bonjour, je ne sais pas si vous allez pouvoir me répondre mais j'ai un problème avec
le FULL TEXT.
Comment faire pour ke la fonction de recherche des mots ne prennent pas en compte
l'appostrophe?
MySQL utilise un filtre très simple pour séparer le texte en mots. Un mot est
n'importe quelle
Hi,
I am using phpMyAdmin for last several years. I don't
like it's framed design.
Recently I read that I can query the database using my
Yahoo IM.
http://www.duncanlamb.com/sdba/?Projects/SQL+Admin
I wonder if this software really works. Has anyone
tried it before?
What type of server will I need
Hi Fred,
Some of our customers have remote offices. I was wondering if it'd be safe
to have a DBMS running at their central office, and have our client
application running on hosts in the branches connect to it through a VPN
via the Net?
If the connection is reasonably stable, and you cache
Deepak Vishwanathan [EMAIL PROTECTED] wrote:
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?
Do you mean that user exceeds max_connections value?
http://dev.mysql.com/doc/mysql/en/User_resources.html
If so,
Shantanu Oak wrote:
Hi,
I am using phpMyAdmin for last several years. I don't
like it's framed design.
Recently I read that I can query the database using my
Yahoo IM.
http://www.duncanlamb.com/sdba/?Projects/SQL+Admin
I wonder if this software really works. Has anyone
tried it before?
What type
MySQL Listers,
I already asked this question on phpBB's own forums, but no one
seems inclined to answer me. I'm hoping there might be more charitable
souls here on this list.
My question is that I want use phpBB because I am satisfied with
it's overall functionality and usability.
yeah, isn't it cute! Cute enough to gag a maggot, maybe.
You can turn that off, you know..click 'login', 'preferences', and open the
'Messages' menu. You will see a checkbox under 'misc' for 'Enable
Emoticons'. Uncheck it, and it'll quit turning things like :) and * into
silly graphics.
Matt Tucker [EMAIL PROTECTED] wrote:
I'm moving a JavaServlet app over from Tomcat on Win2K with a MS SQL 7 DB to Tomcat
on Red
Hat Linux with mySQL. Of course, there's about a hundred queries that use dates and
of
course, they're all in the format mm-dd-. is there a way to format the
Hi,
I recently tried MySQL 4.1.1-alpha in order to get proper UTF-8 support. I
need to be able to order on a utf8 text field. Accented characters
should (broadly) be treated as though they were not accented for ordering
purposes.
Many of the european charsets (eg German) seem to have special
Hi Dave,
I thought one thing I could do is try and find the table that
stores phpBB's usernames and passwords, and extend those to include the
user data that I have already. But I know enough to know that it is
unlikely to be as simple as that. For example, I thought I read
somewhere that
Boris Mueller [EMAIL PROTECTED] wrote:
I need to do a LOCATE(substr,str,pos) request where pos must be taken from a
column.
for unknown reason (bug?) it does not work.
I made the following example to ilustrate the problem:
select ERW, locate('xyz', A, 3000) as loc1, locate('xyz', A, ERW)
At 12:39 +0530 5/3/04, Sp.Raja wrote:
Hi List,
Is it possible to change data and log files (ibdata and iblogfiles
copied for backup purpose) on the fly?
No, you must shut down the server cleanly.
Will something like this work??
1. Close all client connections
2. Flush and disable further client
I have a problem with a character
for example : in my databas i have a word like : papier d'emballage and if
i try this request :
$requete = SELECT * FROM `produit` WHERE MATCH (nom) AGAINST ('emballage*'
IN BOOLEAN MODE);;
---it doesnt't work, because of this character : ' and there is
Sorry, it's an error
- Original Message -
From: mickael
To: [EMAIL PROTECTED]
Sent: Monday, May 03, 2004 4:07 PM
Subject: Problem
I have a problem with a character
for example : in my databas i have a word like : papier d'emballage and if
i try this request :
How can I go about getting information about lock information? I looked
at the InnoDB status screen but it doesnt say a whole lot. Im getting
alot of problems with lock wait timeouts. What I want to know is, what
is obtaining the locks, what user is obtaining the locks and with what
This is my table:
mysql desc testing;
+---+--+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
+---+--+--+-+-+---+
| date | date | YES | | NULL| |
+---+--+--+-+-+---+
Here are the values:
--
Searchable archives for this list are available at
http://www.listsearch.com/mysql.lasso
--
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
| Another question how can see the compatibility of authentification?
|
I don't know. It should be written in docs...
Anyway, try the next thing...
Try to create a symlink for every db except for mysql.
create a symlink /var/lib/mysql/db1 -
Try using
IN(Month(Now()), Month(Now()) -1)
-Original Message-
From: mayuran
To: [EMAIL PROTECTED]
Sent: 5/3/04 10:15 AM
Subject: WHERE clause problem
This is my table:
mysql desc testing;
+---+--+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
Hmm.
Bit Odd. However, I suspect the problem is that your 'where' isn't explicit
enough:
Where ( month(date) = month(now()) ) or ( month(date) = month(now())-1 )
Bear in mind that if month(now()) = 1 you will be looking for records in
month 0!
A better way to do this might be:
WHERE
From: mayuran [mailto:[EMAIL PROTECTED]
Here is my question:
The following query returns incorrect rows and I dont understand why.
mysql SELECT * FROM testing WHERE MONTH(date) = (MONTH(NOW()) OR
MONTH(NOW())-1);
++
| date |
++
| 2004-01-01 |
Phpbb uses an md5 hash to store the passwords. You can use the mysql md5
function or php's to encrypt them. To verify md5 the supplied password
and match against the table.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
mayuran wrote:
This is my table:
mysql desc testing;
+---+--+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
+---+--+--+-+-+---+
| date | date | YES | | NULL| |
+---+--+--+-+-+---+
Hi,
I think there is
1) a problem with FLOAT recommendations in PROCEDURE ANALYSE
2) a minor problem with CREATE TABLE(f FLOAT(negative_value,...))
Please correct me if I'm wrong.
With MySQL 4.0.17, the query
SELECT * FROM my_table PROCEDURE ANALYSE();
gives me the following result for a
At 11:15 -0400 5/3/04, mayuran wrote:
This is my table:
mysql desc testing;
+---+--+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
+---+--+--+-+-+---+
| date | date | YES | | NULL| |
Thanks, Paul.
The machines are running RH 9 (one instance) and Fedora Core 1 (multiple
instances). It's not really a problem, so much as a curiosity about whether
the one with more processes showing was using more resources.
Jim
On Friday 30 April 2004 07:36 pm, Paul DuBois wrote:
At 18:02
I have a web server that uses mysql-4.1.0/apache-2.4.6/php-4.3.4 on
freebsd-5.1.
It has been working fine for the past few years, now all of a sudden today
I get an undefined function error. This is from httpd-error.log -
PHP Fatal error: Call to undefined function: mysql_connect() in
My boss says that if you do a select statement against a table the
result set always comes back in the same order. I say that this is a
myth and that the result is random, except when some ordering is
specified in the SQL statement.
Who is right? Is this behavior specified by ANSI or ISO?
Best
Does the database not return it in the order that the entries are
submitted?
I've done some log parsing/caching in databases, and the order had always
been the same whether
I use an order by date or not. One thing logs to the db, the other grabs.
Had no problem without an
order.
P
Boyd
From: Boyd E. Hemphill [mailto:[EMAIL PROTECTED]
My boss says that if you do a select statement against a table the
result set always comes back in the same order. I say that this is a
myth and that the result is random, except when some ordering is
specified in the SQL statement.
Who is
Yes it is a myth.
The records will come back in the same order IF there have been not
inserts and deletes. Depends on the database product to.
My boss says that if you do a select statement against a table the
result set always comes back in the same order. I say that this is a
myth and
On Mon, 2004-05-03 at 10:39, Boyd E. Hemphill wrote:
My boss says that if you do a select statement against a table the
result set always comes back in the same order. I say that this is a
myth and that the result is random, except when some ordering is
specified in the SQL statement.
Who
On Mon, 3 May 2004 12:39:48 -0500
Boyd E. Hemphill [EMAIL PROTECTED] wrote:
My boss says that if you do a select statement against a table the
result set always comes back in the same order. I say that this is
a myth and that the result is random, except when some ordering is
specified in
On Mon, May 03, 2004 at 12:39:48PM -0500, Boyd E. Hemphill wrote:
My boss says that if you do a select statement against a table the
result set always comes back in the same order. I say that this is a
myth and that the result is random, except when some ordering is
specified in the SQL
As everyone has mentioned - you should always assume the data comes back randomly -
even if the table is completely static and there have been no inserts or updates, but
it's even more subtle than that.
When you port your application to a database than allows your queries to run
multi-threaded
Ah, but the ordering is not random. As your example has it, the results
are in the order that the entries were inserted into the table. There is
an explanation for the order of the returned data.
bob
At 12:55 PM 5/3/2004, Garth Webb wrote:
On Mon, 2004-05-03 at 10:39, Boyd E. Hemphill wrote:
On Mon, 03 May 2004 13:21:56 -0500
Bob Ramsey [EMAIL PROTECTED] wrote:
Ah, but the ordering is not random. As your example has it, the
results are in the order that the entries were inserted into the
table. There is an explanation for the order of the returned data.
Conceptually, row order
It's also not in the order it was entered ( as suggested ).
Bob Ramsey wrote:
Ah, but the ordering is not random. As your example has it, the
results are in the order that the entries were inserted into the
table. There is an explanation for the order of the returned data.
bob
At 12:55 PM
John W. Holmes [EMAIL PROTECTED] wrote on 05/03/2004 10:59:15
AM:
From: Chip Wiegand [EMAIL PROTECTED]
I have a web server that uses mysql-4.1.0/apache-2.4.6/php-4.3.4 on
freebsd-5.1.
It has been working fine for the past few years, now all of a sudden
today
I get an undefined
On Mon, 2004-05-03 at 11:21, Bob Ramsey wrote:
Ah, but the ordering is not random. As your example has it, the results
are in the order that the entries were inserted into the table. There is
an explanation for the order of the returned data.
I don't think the point of the original
Hi!
I'm using AIX 4.3.3 and I'm still not able to get the MySQLDaemons
to start automatically at every bootup. AIX use the inittab, not the
init.d Can anyone show me the way?
Thanks,
FletchSOD
Bob Ramsey wrote:
Ah, but the ordering is not random. As your example has it, the results
are in the order that the entries were inserted into the table. There
is an explanation for the order of the returned data.
snip
Apparently not random, but not in the order inserted either. Consider:
Gerald-
In my experience, I have inserted and retrieved from a decent sized db
(a few million records per day), and have gotten
them out in the same order. There were no other operations on the db
except for cronological ones, i.e. delete the
first hundred rows, insert a hundred rows. The
Hi,
I'm implementing a search on fields some using the latin character set and
others the Japanese character set; however because its virtually hosted I'm
limited to using mysql 4.015
Is the documentation for this version online. I tried to find but could
only get for the latest version which
To all who answered thank you. This answer below is the one that I can
use to convince him what he proposes is not necessarily safe.
Now I just need to decide how to convince him it was his idea :-)
Best Regards,
Boyd E. Hemphill
[EMAIL PROTECTED]
Triand, Inc.
www.triand.com
O: (512)
It sounds like someone upgraded your PHP libraries, and forget to include
MySQL support. Do you admin this server, or does someone else?
j- k-
On Monday 03 May 2004 09:20 am, Chip Wiegand said something like:
I have a web server that uses mysql-4.1.0/apache-2.4.6/php-4.3.4 on
I am having problems with installing the DBD::MySQL Perl module. My system is:
RedHat 8 (patched current)
Perl 5.8.4 (installed from RPM but upgraded manually)
Apache 2.0.40
Modperl 1.99
I am heading toward being able to install Best Practicals request
tracker. Currently this is a clean system.
Joshua J. Kugler [EMAIL PROTECTED] wrote on 05/03/2004 12:23:16 PM:
It sounds like someone upgraded your PHP libraries, and forget to
include
MySQL support. Do you admin this server, or does someone else?
j- k-
Yep, I ran phpinfo.php and verified that it no longer shows support
Also, I'd say that it depends on what you mean by row. If you mean the
same physical data as
was previously displayed, then they probably WILL come back in the same
order, but there
are no guarantees (a dataset is always unordered, unless something else
is specified).
But on the other hand, if
On Mon, May 03, 2004 at 05:56:03PM +0200, Hans-Peter Grimm wrote:
Hi,
I think there is
1) a problem with FLOAT recommendations in PROCEDURE ANALYSE
2) a minor problem with CREATE TABLE(f FLOAT(negative_value,...))
I think that there is maybe:
3) a bug in PROCEDURE ANALYSE that you should
On Sat, May 01, 2004 at 09:50:14PM -0700, Max Clark wrote:
Hi all,
I have a db that is connection heavy running on FreeBSD 4.9. The server
was compiled with Linux Threads enabled.
I am searching for performance tuning information. Outside of enabling
Linux Threads I haven't been able to
Hi. I had a MySQL DB set up and recently added a field 'order' to allow for
exceptions in a web site menu heirarchy. Fields should be ordered by 'order'
field first where it does not contain 'NULL', and then by field 'title'. I
had this previously:
select * from navigation WHERE id =
select * from navigation WHERE id = '.$category.' AND active='y'
AND order IS NOT null
ORDER BY order, title
Hi. I had a MySQL DB set up and recently added a field 'order' to allow
for
exceptions in a web site menu heirarchy. Fields should be ordered by
'order'
field first where it does not
At 17:02 -0700 5/3/04, Haitao Jiang wrote:
I have a complex query which took 4 seconds, I set the
query cache size to 512MB. BUt the query is not
cached, it only returns 7 rows, so the cache size is
not a problem here. Anyway I can find out why MySQL
4.1 is not caching my queries?
The criteria for
WHERE id = id = '$category.' AND active ='y' AND order is not NULL ORDER
by order,title
-Original Message-
From: Eve Atley [mailto:[EMAIL PROTECTED]
Sent: Monday, May 03, 2004 2:24 PM
To: [EMAIL PROTECTED]
Subject: Need correct 'order by' syntax where field does not contain
NULL
I have a complex query which took 4 seconds, I set the
query cache size to 512MB. BUt the query is not
cached, it only returns 7 rows, so the cache size is
not a problem here. Anyway I can find out why MySQL
4.1 is not caching my queries?
Thanks a lot
Haitao
I'm pretty sure that the answer to this is No, you cannot but I figured I'd check
anyway...
As I go back through my query log, I'd like to know the user that issued the
statement. If the user is still connected, I can cross reference it with the SHOW
PROCESSLIST ID, but if they have signed
Hello,
This is partially off-topic as I am looking at reading Access tables
from either Perl (preferred) or MySQL, but if anyone has any suggestions,
I will be most grateful.
My first thoughts were to write a Perl script which will read 2 columns
from an MS Access table and load them into MySQL.
Jigal,
I know that phpBB has a few converter scripts
I think the converter scripts are for a different issue. I don't have a
previous BBS system that I want to convert from. All I have is user
profile information stored in a simple MySQL database that I built
myself. The users are subscribed to
Nik Belajcic wrote:
Hello,
This is partially off-topic as I am looking at reading Access tables
from either Perl (preferred) or MySQL, but if anyone has any suggestions,
I will be most grateful.
My first thoughts were to write a Perl script which will read 2 columns
from an MS Access table and
Thanks for that tip. It helped me find a page which explains it properly.
In case anyone else might be interested, here is the link.
http://www.awilcox.com/geek_stuff/perl/proxy.html
--
Nik Belajcic [EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives:
Hi,
I got the 4.0.17 documentation but when it discusses character sets it
discusses this topic wrt 4.1
Where can I find documentation specifically in regards to the production
version on how to work with, store, and search asian character sets
specifically Japanese.
Thank-you
David Jrt;
66 matches
Mail list logo