Re: mysql_get_client_version() in embedded library

2005-04-28 Thread Wolfgang Rohdewald
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.

Re: why NOT NULL in PRIMARY key??

2005-04-28 Thread Jigal van Hemert
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

Re: Get a Random Row on a HUGE db

2005-04-28 Thread Jigal van Hemert
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*

returning results in the order they were selected

2005-04-28 Thread Scott Haneda
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

Re: returning results in the order they were selected

2005-04-28 Thread Johan Höök
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

Re: Multi Table Delete in 3.23.47

2005-04-28 Thread Philippe Poelvoorde
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

Re: returning results in the order they were selected

2005-04-28 Thread Scott Haneda
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. -- -

Re: connecting with PHP from remote server - security breach?

2005-04-28 Thread Gleb Paharenko
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

Re: Maximize mysql ini for 4gig big query win 2003 box

2005-04-28 Thread Gleb Paharenko
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

Re: time zones

2005-04-28 Thread Gleb Paharenko
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

Re: Avoiding deadlock: beyond the basics

2005-04-28 Thread Gleb Paharenko
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

Re: purge log fails

2005-04-28 Thread Gleb Paharenko
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

Need help with stored procedures in mysql

2005-04-28 Thread madderla sreedhar
__ 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]

Need help with stored procedures in MySQL

2005-04-28 Thread madderla sreedhar
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 =

Re: Need help with stored procedures in MySQL

2005-04-28 Thread Joerg Bruehe
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

REPLACE function

2005-04-28 Thread Jerry Swanson
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

Re: REPLACE function

2005-04-28 Thread Chris Ramsay
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

Crystal Reports MySQL

2005-04-28 Thread Kerry Frater
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

mysql install on Redhat Linux 2.1AS (32 bit)

2005-04-28 Thread V. Agarwal
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.

Re: Maximize mysql ini for 4gig big query win 2003 box

2005-04-28 Thread matt_lists
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

RE: Maximize mysql ini for 4gig big query win 2003 box

2005-04-28 Thread Mark Leith
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

Re: Maximize mysql ini for 4gig big query win 2003 box

2005-04-28 Thread matt_lists
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

4Knowledge

2005-04-28 Thread mdnazrul
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

Re: connecting with PHP from remote server - security breach?

2005-04-28 Thread Brent Baisley
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

Re: 4Knowledge

2005-04-28 Thread SGreen
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

Re: mysql install on Redhat Linux 2.1AS (32 bit)

2005-04-28 Thread Gabriel PREDA
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

Re: Crystal Reports MySQL

2005-04-28 Thread Scott Pippin
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

Does anyone have experience?

2005-04-28 Thread Berman, Mikhail
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

Re: Problems with character sets and Unicode in MySQL

2005-04-28 Thread Gleb Paharenko
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

Re: REPLACE function

2005-04-28 Thread Eamon Daly
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, ' ',

re: determing number of Tuesdays within a date range

2005-04-28 Thread James Black
-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

Re: Does anyone have experience?

2005-04-28 Thread SGreen
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,

RE: Does anyone have experience?

2005-04-28 Thread Berman, Mikhail
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]

Re: host info

2005-04-28 Thread Eamon Daly
I'm an idiot. I completely forgot about USER(): mysql select user(), SUBSTRING_INDEX(user(), '@', -1); +-+--+ | user() | SUBSTRING_INDEX(user(), '@', -1) | +-+--+ | [EMAIL PROTECTED] |

Re: time zones

2005-04-28 Thread Monty Harris
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

How to move a database to a new directory

2005-04-28 Thread Andy Ford
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

Re: How to move a database to a new directory

2005-04-28 Thread Dixie
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

RE: Does anyone have experience?

2005-04-28 Thread SGreen
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

RE: Does anyone have experience?

2005-04-28 Thread Berman, Mikhail
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

show innodb status

2005-04-28 Thread Mayuran Yogarajah
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

extra bytes added to large BLOB by mysqldump

2005-04-28 Thread Zhe Wang
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

RE: Does anyone have experience?

2005-04-28 Thread SGreen
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

Re: How to move a database to a new directory

2005-04-28 Thread mfatene
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

Re: determing number of Tuesdays within a date range

2005-04-28 Thread Peter Brawley
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

RE: Does anyone have experience?

2005-04-28 Thread Berman, Mikhail
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

RE: Does anyone have experience?

2005-04-28 Thread SGreen
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

RE: Does anyone have experience?

2005-04-28 Thread Berman, Mikhail
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

RE: Does anyone have experience?

2005-04-28 Thread mathias fatene
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]

RE: Does anyone have experience?

2005-04-28 Thread SGreen
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

Re: purge log fails

2005-04-28 Thread Marten Lehmann
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

RE: Does anyone have experience?

2005-04-28 Thread Berman, Mikhail
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

mysql top 2 rows for each group

2005-04-28 Thread Vivian Wang
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

RE: mysql top 2 rows for each group

2005-04-28 Thread Jay Blanchard
[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

RE: mysql top 2 rows for each group

2005-04-28 Thread mathias fatene
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

RE: mysql top 2 rows for each group

2005-04-28 Thread SGreen
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

RE: Crystal Reports MySQL

2005-04-28 Thread Kerry Frater
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

RE: Crystal Reports MySQL

2005-04-28 Thread 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

RE: mysql top 2 rows for each group

2005-04-28 Thread mathias fatene
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 |

Re: Crystal Reports MySQL

2005-04-28 Thread Fredrick Bartlett
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. -

memory error innodb backup

2005-04-28 Thread Baba Buehler
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

Re: zip code search within x miles

2005-04-28 Thread Jeremy Cole
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

Find records that don't exist in MySQl 4.0

2005-04-28 Thread Andrew Hargreaves
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,

No error / warning when data is truncated on insertion into mysql

2005-04-28 Thread Anoop kumar V
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

RE: No error / warning when data is truncated on insertion into mysql

2005-04-28 Thread mathias fatene
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

Re: Find records that don't exist in MySQl 4.0

2005-04-28 Thread Daniel Kasak
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

Re: No error / warning when data is truncated on insertion into mysql

2005-04-28 Thread Anoop kumar V
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

Re: No error / warning when data is truncated on insertion into mysql

2005-04-28 Thread Anoop kumar V
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

Re: No error / warning when data is truncated on insertion into mysql

2005-04-28 Thread Paul DuBois
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,

re: using if in select statement

2005-04-28 Thread James Black
-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

InnoDB .frm files disappearing?

2005-04-28 Thread Geoffrey R. Thompson
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

Can't Access Via Webmin or PhpMyAdmin.

2005-04-28 Thread Mark Sargent
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