On Donnerstag 28 April 2005 07:39, Wolfgang Rohdewald wrote:
the manual states at
http://dev.mysql.com/doc/mysql/en/mysql-get-client-version.html
that this function has been introduced in 4.0.16.
But it seems that the embedded library does not yet have it as of 4.0.24.
4.1.11 has it.
From: Frank Bax
At 11:07 AM 4/27/05, Jigal van Hemert wrote:
So, if we would define that the key entry 0-NULL-Whatever equals
0-NULL-Whatever (which MySQL is capable of if you look at the
definition
of UNIQUE indexes with BDB tables) then allowing NULLs as part of a key
entry would not
From: Scott Gifford
SELECT COUNT(*) FROM firebase_content;
to get the count. That's very fast; it comes from the table summary
information, IIRC. I use a similar solution for a similar problem,
and have had great luck with it.
This is true for MyISAM tables, but e.g. InnoDB does *not*
mysql 4.0.18-standard
I am running this select:
SELECT a, b, c, from table where zip IN (94949, 94945, 94947)
How can I get back a result set in the order of the `IN` part of the
statement?
--
-
Scott Haneda
Hi Scott,
you can do:
SELECT a, b, c, from table where zip IN (94949, 94945, 94947)
ORDER BY FIELD(zip,94949, 94945, 94947)
/Johan
Scott Haneda wrote:
mysql 4.0.18-standard
I am running this select:
SELECT a, b, c, from table where zip IN (94949, 94945, 94947)
How can I get back a result set in
Michael Stassen wrote:
zzapper wrote:
Hi,
Final whinge: I wish the mysql website made it a little clearer
which features are recent additions, I suggested color coding.
Philippe Poelvoorde wrote:
snip
I reckon, it's a bit hidden in the middle :
Starting with MySQL 4.0.4, you can also
on 4/28/05 1:41 AM, Johan Höök at [EMAIL PROTECTED] wrote:
Hi Scott,
you can do:
SELECT a, b, c, from table where zip IN (94949, 94945, 94947)
ORDER BY FIELD(zip,94949, 94945, 94947)
That is too handy, thanks for the tip.
--
-
Hello.
Somebody with the sniffer on the transit
router could get enough information about MySQL credentials. Try
to use SSL connection.
Nikola Skoric [EMAIL PROTECTED] wrote:
Hello,
I'm wondering whether there is a way to hack into my database if I'm=
connecting with PHP
from
Hello.
SHOW STATUS and a piece of SHOW PROCESSLIST
with slow queries could give additional information,
so the probability of the helpful answer grows.
matt_lists [EMAIL PROTECTED] wrote:
Anybody have any suggested settings for our my.ini ?
4 gig box, running windows 2003
peak
Hello.
The good support of timezones is on TODO list. See:
http://dev.mysql.com/doc/mysql/en/todo-future.html
Monty Harris [EMAIL PROTECTED] wrote:
How does one cope with time zones? For example, if I want to timestamp a
record it will timestanp using the local time of my
Hello.
The output of INNODB MONITOR is not clear for me (I hope only
for me, and someone more skilled could correct me). At:
http://dev.mysql.com/doc/mysql/en/innodb-locks-set.html
it is said that, SELECT ... FROM is a consistent read, reading a snapshot
of the database and setting no
Hello.
That's not good:
DBD::mysql::db do failed: Lost connection to MySQL server during query
at /vrmd/admin/cron/apps/purge_logs/purge_logs.pl line 15.
MySQL could die during your query. What is in error log?
Marten Lehmann [EMAIL PROTECTED] wrote:
Hello,
the current
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
Iam looking to migrate an Oracle database to MySQL and
trying to write a simple stored procedure in MySQL 4.1
.I reffered few examples posted and used the
statements from them but I get errors while creating
procedures
create procedure helloworld (out p_text VARCHAR(30))
BEGIN
set p_text =
Hi!
madderla sreedhar wrote:
Hi,
Iam looking to migrate an Oracle database to MySQL and
trying to write a simple stored procedure in MySQL 4.1
The manual states clearly:
Stored procedures and functions are a new feature in MySQL version 5.0.
(At the proper place: 19 Stored Procedures and
I have field varchar(20) that stores phone numbers. Phone number can
be in different format. So I need only digits from the field. How I
can do such replacement?
TH
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
If I understand your problem, MySQL allows you to use regular
expressions - so you could use the REGEXP function to remove the
spaces. Check out the mysql site...
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
I have MySQL the downloaded ODBC drivers.
I am looking to use Crystal Reports to design run my own reports on my
tables.
Can anyone tell me if the V11 Standard will happily work with MySQL or do I
need a different version?
Kerry
There are several binaries for linux and I picked
following for my Redhat Linux 2.1AS (32 bit) from
MYSQL site.
mysql-standard-4.1.11-pc-linux-gnu-i686.tar.gz
I installed by unzipping/untarring and started the
daemon as per instructions.
I also added mysql bin directory to my PATH variable.
I'm more concerned with mysql only using 1.5 gig, wouldnt it be faster
to maximize memory usage? The only thing these box's do is mysql
I do have slow queries, but they are big joins across all the big
tables, and users doing querys on tables without using a key, the
contract requires dynamic
You mention that MySQL is only using 1.5 gig..
Out of interest, are you aware that Windows by default when using
large amounts of memory, will split the memory allocation down the
middle - between applications and system? So given your 4Gb of
memory, applications with be getting 2Gb..
You can
Way ahead of you, that switch was turned on during initial load before
we went live with the new servers.
Mark Leith wrote:
You mention that MySQL is only using 1.5 gig..
Out of interest, are you aware that Windows by default when using
large amounts of memory, will split the memory allocation
Dear Sir/Madam,
I'm new to mysql
Does any body know following program written in which language? is that C++
or Java
Thank you for your support.
Sincerely
Nazrul
Ideally you would want to encrypt the connection, if only to add
another layer of security. But regardless, there are other steps you
can and should take even before implementing a secure connection
between PHP and MySQL. It's actually a smart idea to separate your
database from the front end
mdnazrul [EMAIL PROTECTED] wrote on 04/28/2005 08:41:16 AM:
Dear Sir/Madam,
I'm new to mysql
Does any body know following program written in which language? is that
C++
or Java
Thank you for your support.
Sincerely
Nazrul
If you download MySQL you will also get a copy of it's
You should be shure that the old client is not in the PATH... because seems
to me that when you're not int the mysql bin directory the old client is
called... withc does not know about the new auth methods...
Or else... start the server with the --old-password param.
Gabriel
- Original
I haven't tested it but I am using version 10 with no problems. See the
announcement made by business objects at the MySQL users conference:
http://www.mysql.com/news-and-events/press-release/release_2005_10.html
I hope this helps.
Scott Pippin
[EMAIL PROTECTED]
Kerry Frater [EMAIL
Hi,
I am promoting this E-mail to larger list in hope to find people who can
help me.
Regards,
Mikhail Berman
-Original Message-
From: Berman, Mikhail [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 27, 2005 9:57 AM
To: [EMAIL PROTECTED]
Subject: Does anyone have experience?
Hi
Hello.
But I've been told that the support for Unicode is not yet good in MySQL. Is
it possible to find whether this is true?
I don't think so, as most bugs related to utf8 are reported about the fifth
version
while utf8 support in fourth seems very stable.
Raul Mauri [EMAIL
Sadly, the REGEXP function is only for string comparison,
not substitution. You'll either have to handle the
replacement on the client side or string together an
unwieldy series of REPLACE functions, like so:
SET @phone = '(123) 456-7890';
SELECT
REPLACE(
REPLACE(
REPLACE(
REPLACE(@phone,
' ',
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I have a table with session information, with a start and stop time.
I can aggregate the information, grouping it by hour or weekday.
But, when I group it by hour and weekday, I need to also show the
average usage, so I need to figure out how many
Berman, Mikhail [EMAIL PROTECTED] wrote on 04/28/2005 10:32:53 AM:
Hi,
I am promoting this E-mail to larger list in hope to find people who can
help me.
Regards,
Mikhail Berman
-Original Message-
From: Berman, Mikhail [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 27,
Yes,
I do test DSN connection itself. It returns Success. Connection was
made. I am creating User DSN.
The only tool able to connect to my UNIX databases via ODBC driver is
MS-Access, not Excel.
Regards,
Mikhail Berman
From: [EMAIL PROTECTED]
I'm an idiot. I completely forgot about USER():
mysql select user(), SUBSTRING_INDEX(user(), '@', -1);
+-+--+
| user() | SUBSTRING_INDEX(user(), '@', -1) |
+-+--+
| [EMAIL PROTECTED] |
How does one cope with time zones? For example, if I want to timestamp a
record it will timestanp using the local time of my server. I thought
that, e.g if my server was in New York and my customer_location was the
UK, I
can just add 5 hours to the time and it would be correct.
While that
I have run out of disk space in the directory where I have a mySQL database.
How do I go about moving it and reconfiguring mySQL to see the new location.
Thanks
Andy
This e-mail is private and may be confidential and is for the intended
recipient only. If misdirected, please notify us by
Andy Ford ha scritto:
I have run out of disk space in the directory where I have a mySQL database.
How do I go about moving it and reconfiguring mySQL to see the new location.
Thanks
Andy
Symple... move to a different directory the data and edit the my file at:
...
#Path to the database root
Berman, Mikhail [EMAIL PROTECTED] wrote on 04/28/2005 10:50:17 AM:
Yes,
I do test DSN connection itself. It returns Success. Connection was
made. I am creating User DSN.
That's a good sign.
The only tool able to connect to my UNIX databases via ODBC driver is
MS-Access, not Excel.
If
Hi,
I do use Data Sources(ODBC) manager to create DSNs.
Either User or System DSN failed to connect from SysPlot to UNIX
databases, with the same error message Cannot connect to data source
Sorry I was not precise in description, I have mentioned MS-Access vs.
Excel only to raised a point
Does anyone how to interpret the output of 'SHOW INNODB STATUS' ?
It prints quite a bit of stuff but I haven't been able to find any
documentation
explaining what everything means. Specifically:
Total memory allocated 462835256; in additional pool allocated 1385472
Buffer pool size 24576
Free
Hi, there,
I am using MySQL 4.1.10. I have a table which has a LONGBLOB field.
Some length of the blob field of the records varies from a few hundred
bytes to more than 64 MB. I've set max_allowed _packet to 128M on the
server side. I first created the table in MyISAM and the data was added
OK, I am still confused. Let's run down the list of what's working and
what isn't:
a) In the ODBC manager, create a System DSN and click on the TEST
CONNECTION button. What happens?
b) In SigmaPlot, tell the software to use the connection you just created
and tested. What happens?
If we
Hi,
If you want to move just one (or some) database and keep your datadir as defined
:
* stop the server
* move your database (say world) to a new directory (c:\newdir)
* in the datadir, create world.sym and write in a line containing c:\newdir
* restart
on Unix, you have symbolic links.
Mathias
James,
I need to figure out how many Tuesdays are contained
within 1/1/2004 - 5/1/2004, and I need to come up with
a result where I know how many of each day of the week
is within that date range.
Supposing a table named tbl and datetime columns named d1 and d2,
something like this (not
See inserts below
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 28, 2005 12:36 PM
To: Berman, Mikhail
Cc: mysql@lists.mysql.com
Subject: RE: Does anyone have experience?
OK, I am still confused. Let's run down the list of what's
Thank you for being so patient with me. What options does SigmaPlot give
you when selecting an ODBC data source? Have you verified that you are
either using the default settings (as you defined when you set up the
connection) or that you are using the same credentials you used to test
your
Shawn,
I would like to thank you for your great help, no apologies needed. I
have gone through most of the steps describe by you myself in the search
for the answers.
I am going to take this up with Systat Software people, now.
Thank you again,
Mikhail Berman
Hi,
Had you read http://dev.mysql.com/doc/mysql/en/odbc-connector.html
One can't see the mysql ODBC driver in your snapshot.
Best Regards
Mathias FATENE
Hope that helps
*This not an official mysql support answer
-Original Message-
From: [EMAIL PROTECTED]
MySQL is not listed in the screenshot because that is a sample screenshot
provided by the **manufacturer**, not a screen shot from his installation.
I was trying to use it to get a sense of how many connection-specific
options he may have had control over from within SigmaPlot. Basically, it
MySQL could die during your query. What is in error log?
Oh my god, it's really dieing. I haven't looked in the error log before,
because I though, it's just this connection that got lost. This is the
error-log output:
mysqld got signal 11;
This could be because you hit a bug. It is also
I do believe that a problem is with SigmaPlot itself, because of all
research we have done. And, an additional fact that SigmaPlot ODBC
connection works properly with DSN created for MS-Access, but not with
DSN to MySQL.
Best
Mikhail Berman
From: [EMAIL
I have question about how I can get top 2 rows for each group.
like I have table test
| seqno |
+---+
| 00122 |
| 00123 |
| 00123 |
| 00123 |
| 00336 |
| 00346 |
| 00349 |
| 00427 |
| 00427 |
| 00427 |
+---+--+
I like have
[snip]
I have question about how I can get top 2 rows for each group.
like I have table test
| seqno |
+---+
| 00122 |
| 00123 |
| 00123 |
| 00123 |
| 00336 |
| 00346 |
| 00349 |
| 00427 |
| 00427 |
| 00427 |
+---+--+
I like have
Hi ,
The table must be myisam. Innodb refused my solution which is here :
Beatifull
auto_increment
mysql create table seqs(seqno varchar(10) NOT NULL , id int
auto_increment, primary key (seqno,id)) engine=myisam;
Query OK, 0 rows affected (0.03
Jay Blanchard [EMAIL PROTECTED] wrote on 04/28/2005
04:24:23 PM:
[snip]
I have question about how I can get top 2 rows for each group.
like I have table test
| seqno |
+---+
| 00122 |
| 00123 |
| 00123 |
| 00123 |
| 00336 |
| 00346 |
| 00349
Thanks for the reply Scott. I found the press release interesting.
I have V9 Dev version and need runtime version for another site. I can buy
V11 but wasn't sure if the STD version was enough to set a report and run it
with MySQL.
Kerry
-Original Message-
From: Scott Pippin
Should be. You should be able to download a trial and try it out.
Kerry Frater [EMAIL PROTECTED] 04/28/05 3:26 PM
Thanks for the reply Scott. I found the press release interesting.
I have V9 Dev version and need runtime version for another site. I can buy
V11 but wasn't sure if the STD
For your query, just a where clause :
mysql select * from seqs where id 3;
+---++
| seqno | id |
+---++
| 00122 | 1 |
| 00123 | 1 |
| 00123 | 2 |
| 00336 | 1 |
| 00346 | 1 |
| 00349 | 1 |
| 00427 | 1 |
| 00427 | 2 |
Hmmm, they repeated several times...
Under the agreement, Business Objects will embed MySQL database technology
into BusinessObjects XI for use on the Linux and UNIX
Linux and UNIX how can they determine the server is not running on Win32???
Strange. Crystal Reports is a Win32 app.
-
We've got a customer whose system has been experiencing corruption in
their InnoDB tables. They have returned the system to us and after
testing we've determined that the server has bad RAM.
This is the same system I had posted about in
http://lists.mysql.com/mysql/180785
Memtest86+ v1.55
Hi,
known as covering indexes. The advantage to a covering index is that if
your data is numeric and in the index, the engine can read the data
All correct, except that the data does not have to be numeric. It must,
however, be completely indexed, not indexed by prefix. That requirement
In MySQL 4.0, is it possible to find all records that don't exist in one
query. I managed to do it in Access by referencing a query that I had
previously created, but I was wondering if it was possible to do this in one
step.
SELECT C.CustomerID, ([JobStatus]=0 And [JobTypeID]=2) AS KountNA,
I am using MySQL and SQL server with Tomcat.
Our application writes into both databases (mysql and ms sql server) at once
based on some data collected from an end user. Now if the end user enters
more data (characters) than the column can hold, the data obviously gets
truncated.
But the
Hi,
I think you shoul dcatch the show warnings command cause in mysql
client you see the number of warnings.
Data are even truncated according to the limit of the type (tinyint, int
...).
Example :
mysql create table toto(a tinyint,b char(5));
Query OK, 0 rows affected (0.06 sec)
mysql insert
Andrew Hargreaves wrote:
In MySQL 4.0, is it possible to find all records that don't exist in one
query. I managed to do it in Access by referencing a query that I had
previously created, but I was wondering if it was possible to do this in one
step.
Not in one step, no. If you're still
Thank you,
But the show warnings does not seem to work on my prompt. I am using
mysql SELECT VERSION();
+---+
| VERSION() |
+---+
| 4.0.23-nt |
+---+
And even if it did and does how will that reflect in my tomcat logs?? I mean
I want a way where without user interaction
I mean:
Should I enable something like 'strict checking' / verbose so that
MYSQLcomplains and refrains from inserting truncated data in the
tables??
Thanks,
Anoop
On 4/28/05, Anoop kumar V [EMAIL PROTECTED] wrote:
Thank you,
But the show warnings does not seem to work on my prompt. I am
At 19:39 -0400 4/28/05, Anoop kumar V wrote:
I mean:
Should I enable something like 'strict checking' / verbose so that
MYSQLcomplains and refrains from inserting truncated data in the
tables??
Yes, but you'll need MySQL 5.0 to do it.
http://dev.mysql.com/doc/mysql/en/server-sql-mode.html
Thanks,
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
My boss and I were playing with using select statements, and we can
actually execute subqueries as an option if the result is true or false.
Is this expected behavior, or is it something that may be fixed in a
revision, before I begin to depend on it
We have been using MyISAM tables with MySQL merrily for about 18 months.
Recently we upgraded to MySQL 4.1, and even more recently, we converted some
of our MyISAM tables (which needed transactional support) to InnoDB.
After some configuration issues - the worst of which was the need to use a
Hi All,
I can start mysql with the following cmd,
/etc/rc.d/init.d/mysql start
although, I had to change
bindir=./bin
to
bindir=/usr/local/mysql/bin
to get it to work. I can access the DB with,
mysql -h localhost -u root -p
successfully, but, when trying to access via phpmyadmin or webmin it
71 matches
Mail list logo