Hi,
On Thu, 2006-10-19 at 18:02 +0300, [EMAIL PROTECTED] wrote:
From: Peter Gulutzan [EMAIL PROTECTED]
MySQL is looking for an authoritative, official statement which states
all the current Hungarian collation rules.
According to the Reference Level Description of the hungarian
Hi,
I have two tables, both containing a UNIX_TIMESTAMP column. Is it possible
to join the tables on the nearest values of these columns? If no, then
could anybody show me a query to circumvent this limitation?
Thanks
ImRe
--
MySQL General Mailing List
For list archives:
hi all,I need some one to help me with this. I have put many savepoints during
the transaction in mysql andI want to have the list of all the savepoints set
during the current transaction.plz help.regards,Vijay
Kaj Arnö wrote:
So: For client licensing, nothing as changed -- but stay tuned for an
announcement next week!
Did I miss it? It's been almost 2 weeks, and I don't see anything in
the MySQL press release archive or your blog.
--
MySQL General Mailing List
For list archives:
Most likely the UTF8 is still in the data base, but whatever program you are
using to view it is not displaying UTF8 properly. MySQL's command line
program will not, for example, even if you SET NAMES utf8.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington,
On Sunday 29 October 2006 17:43, David Thole wrote:
On Oct 22, 2006, at 11:37 AM, João Cândido de Souza Neto wrote:
Hi everyone.
I´m using mysql workbench to design my database and am heaving a snag.
How can i rename my object? It always gets the name test and i
did not
found where
Ok, we are in the same snag.
Who gets the solution firstly please, share it.
Joshua J. Kugler [EMAIL PROTECTED] escreveu na mensagem
news:[EMAIL PROTECTED]
On Sunday 29 October 2006 17:43, David Thole wrote:
On Oct 22, 2006, at 11:37 AM, João Cândido de Souza Neto wrote:
Hi everyone.
Doesn't that change when you hook up to a database?
On Oct 30, 2006, at 12:56 PM, João Cândido de Souza Neto wrote:
Ok, we are in the same snag.
Who gets the solution firstly please, share it.
Joshua J. Kugler [EMAIL PROTECTED] escreveu na mensagem
news:[EMAIL PROTECTED]
On Sunday 29
Remember that my MySQL skills are at the beginner level; and this whole
Unicode / utf8 business always gives me a headache.
Any Unicode or utf8 characters with diacritical marks will look funky in
DOS.
Normally what I do is take my data, convert it from uft8 to utf8, and see if
the results match
I have a database with several tables that can have up to 100 000 rows
there is ~100 updates every seconds and ~100 select query on the same
table using locks.
The update is always on the same field a varchar(15), I believe it will
be recommended to change it to char(15) to improve performance
distro: suse 10.1 (64-bit)
MySQL server/shared/client: 5.1.11-0 (rpm)
PERL: 5.8.8
DBI: 1.5.2
DBD: 3.0008
I am trying to do some benchmarks w/ w/o prepared statements but if I
enable mysql_server_prepare=1 I get a segfault when I try to execute a query
- the prepare seems to work or at
nevermind: http://bugs.mysql.com/bug.php?id=20559
bummer...
On 10/30/06, Sid Lane [EMAIL PROTECTED] wrote:
distro: suse 10.1 (64-bit)
MySQL server/shared/client: 5.1.11-0 (rpm)
PERL: 5.8.8
DBI: 1.5.2
DBD: 3.0008
I am trying to do some benchmarks w/ w/o prepared statements but if I
I am trying to find records where the value of a filed is NULL. I
know that there are records that have null values but the result is
always an empty set.
eg:
select test_id from tests where test_id=NULL
always returns an empty set when there are in fact records that have
a null value
[snip]
I am trying to find records where the value of a filed is NULL. I
know that there are records that have null values but the result is
always an empty set.
eg:
select test_id from tests where test_id=NULL
always returns an empty set when there are in fact records that have
a null
On Oct 30, 2006, at 3:27 PM, Jay Blanchard wrote:
[snip]
I am trying to find records where the value of a filed is NULL. I
know that there are records that have null values but the result is
always an empty set.
eg:
select test_id from tests where test_id=NULL
always returns an empty set
Alan Nilsson wrote:
On Oct 30, 2006, at 3:27 PM, Jay Blanchard wrote:
[snip]
I am trying to find records where the value of a filed is NULL. I
know that there are records that have null values but the result is
always an empty set.
eg:
select test_id from tests where test_id=NULL
always
[snip]
Alan Nilsson wrote:
On Oct 30, 2006, at 3:27 PM, Jay Blanchard wrote:
[snip]
I am trying to find records where the value of a filed is NULL. I
know that there are records that have null values but the result is
always an empty set.
eg:
select test_id from tests where
Suppose I have table t with fields k1, k2 and k3 that all make up the
primary key. Then I have fields x, y and z. If fields x, y and z all
have the same values in more than one row, there is a good chance they
are duplicate records. What is the best way to list all of the rows
where this
Chris W wrote:
Suppose I have table t with fields k1, k2 and k3 that all make up the
primary key. Then I have fields x, y and z. If fields x, y and z all
have the same values in more than one row, there is a good chance they
are duplicate records. What is the best way to list all of the
Chris wrote:
Chris W wrote:
Suppose I have table t with fields k1, k2 and k3 that all make up the
primary key. Then I have fields x, y and z. If fields x, y and z
all have the same values in more than one row, there is a good chance
they are duplicate records. What is the best way to list
Chris W wrote:
Chris wrote:
Chris W wrote:
Suppose I have table t with fields k1, k2 and k3 that all make up the
primary key. Then I have fields x, y and z. If fields x, y and z
all have the same values in more than one row, there is a good chance
they are duplicate records. What is the
Hi,
From: Peter Gulutzan [mailto:[EMAIL PROTECTED]
MySQL is looking for an authoritative, official statement which
states all the current Hungarian collation rules.
According to the Reference Level Description of the
hungarian language
(ISBN
9634206441 or the hungarian
Hi,
As of our understanding, MySQL can show whether the engines support
Transactions and Savepoints. It does not list out the count or savepoints
that were not deleted.
But the solution for your query can be extracted from
shell show engine innodb status\G
or
shellshow innodb status\G
and
Hi,
To BLOB or not to BLOB | Whether to store string in BLOB, or CHAR, or
VARCHAR
pls play the link:
http://www.volny.cz/iprenosil/interbase/ip_ib_strings.htm
Thanks
ViSolve DB Team.
- Original Message -
From: Chris W. Parker [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent:
Hi,
Just wanted to post this here to see if anyone knows the difference.
In MSSQL, there is a hint which can be used to ask the DB to not lock
the tables during queries and then to read un-commited/dirty data. This
command is like
select count(*) from MyTable nolock
in MySQL, I found that I
25 matches
Mail list logo
