Re: BUG in UNION implementation?! Confimation or Explaination please

2007-07-11 Thread Joshua J. Kugler
On Wednesday 11 July 2007 00:34, Anders Karlsson wrote: UNION will only return distinct rows. This is according to spec and to the SQL Standard. And of course, to no one's surprise, this also matches the mathematical definition of union: j -- Joshua Kugler Lead

[OT] Re: General MySQL Question: Ed Reed (CA, United States of America) Medium

2007-01-29 Thread Joshua J. Kugler
On Monday 29 January 2007 12:57, Ed Reed wrote: I just didn't enjoy the location. When it was in Orlando a few years ago, it was great. There were plenty of things to do and see; different places to eat every night. I had a really good time. Then the following year I went to Santa Clara and

Re: Visual Basic 6 + MySQL

2007-01-22 Thread Joshua J. Kugler
On Sunday 21 January 2007 16:41, Nuno Vaz Oliveira wrote: Just FYI: you can get the Express version of the VB.Net portion of Visual Studio for free: http://msdn.microsoft.com/vstudio/express/default.aspx That way, you're much more likely to have a fully supported app. I've not tried

Re: Visual Basic 6 + MySQL

2007-01-21 Thread Joshua J. Kugler
On Sunday 21 January 2007 08:17, Nuno Vaz Oliveira wrote: Hello Miles, At 04:39 PM 1/19/2007, Nuno Vaz Oliveira wrote: Why VB6? This isn't an anti-Microsoft position, but that language has been left to die on the vine. So I'd think about .NET, or RealBASIC, or ... or You will have

Re: making graphs with MySQL data

2007-01-12 Thread Joshua J. Kugler
On Friday 12 January 2007 12:51, C.R.Vegelin wrote: Dear List, I have a MySQL database (V5.0.x) and I need to make graphs. Does anyone know about good utilities to make graphs ? I would appreciate your expertise or links. If you're using Python, matplotlib is an excellent package. If you

Re: Urgent please..

2006-11-15 Thread Joshua J. Kugler
On Wednesday 15 November 2006 18:14, Renish wrote: Can anyone tell me..how to install PHP php-5.2.0-Win32 . i click on php.exe and nothing seems to happen. I have intalled 1) webserver-Apache2 2) MySql-41.1 Please read the documentation before asking questions such as these. Thanks.

Re: Workbench

2006-10-30 Thread Joshua J. Kugler
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

Re: mysqlclient in Apache

2006-10-19 Thread Joshua J. Kugler
On Wednesday 18 October 2006 20:44, Dan Nelson wrote: In the last episode (Oct 18), Danny Swarzman said: I'm developing an Apache module that uses mySQL. It needs to be able to talk to a remote host. I'm doing this in a Mac. I have a simple program in C that calls

Bug in mysqldump or mysql-server 5.0?

2006-07-28 Thread Joshua J. Kugler
[I searched the bug database...please let me know if I missed an already filed or fixed bug.] I am trying to dump a database from MySQL 4.0.24 using the client tools from 5.0. Debian server, Ubutnu 6.06 client. I use this command line (watch for wrap): mysqldump -u jkugler -p -h dbserver

Re: I don't understand why SCSI is preferred.

2006-07-12 Thread Joshua J. Kugler
On Tuesday 11 July 2006 19:26, mos wrote: SCSI drives are also designed to run 24/7 whereas IDE drives are more likely to fail if used on a busy server. This used to be the case. But there are SATA drives out there now being made for enterprise class, 100% duty cycle operations. See, for

Re: DWHS inc.

2006-02-15 Thread Joshua J. Kugler
California mirror (H.E. in San Diego), but they might be willing to take on another. j- k- -- Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295 Every knee shall bow, and every tongue confess, in heaven, on earth, and under the earth, that Jesus Christ is LORD -- Count on it! -- MySQL

Re: this listserv function...?

2005-12-19 Thread Joshua J. Kugler
feature whereby when you press L while reading a message it replies to list. I use that all the time. j- k- -- Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295 Every knee shall bow, and every tongue confess, in heaven, on earth, and under the earth, that Jesus Christ is LORD

Re: MySQL and Mandrake 10.2

2005-07-26 Thread Joshua J. Kugler
. Pascal Francq Université libre de Bruxelles CAD/CAM Department Avenue F.D. Roosevelt, 50 CP 165/14 B-1050 Brussels BELGIUM Tel. +32-2-650 47 65 Fax +32-2-650 47 24 -- Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295 Every knee shall bow, and every tongue confess, in heaven, on earth

Re: Connect to MYSQL server from Wi-Fi enabled Windows CE device

2005-03-03 Thread Joshua J. Kugler
. So what I want to do is move the sync app to the CE Device and connect to MYSQL directly from the mobile device. Hope this gives you a better idea of the problem. Regards Hough Joshua J. Kugler [EMAIL PROTECTED] 03/02/05 9:07 AM On Wednesday 23 February 2005 03:47, Hough Van Wyk said

Re: Connect to MYSQL server from Wi-Fi enabled Windows CE device

2005-03-01 Thread Joshua J. Kugler
a standard ethernet connection, there is no difference than if you were plugged into a wall. What exactly are you looking for in your search? j- k- -- Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295 Every knee shall bow, and every tongue confess, in heaven, on earth, and under

Re: New to MySQL on Linux

2005-02-11 Thread Joshua J. Kugler
will resolve all the dependencies for you. Hope that gets you started a little. If you need more detail, feel free to ask. j- k- -- Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295 Every knee shall bow, and every tongue confess, in heaven, on earth, and under the earth

Re: GRANT can't grant with a password?

2005-01-11 Thread Joshua J. Kugler
not be able to do that. -- Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295 Every knee shall bow, and every tongue confess, in heaven, on earth, and under the earth, that Jesus Christ is LORD -- Count on it! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: GRANT can't grant with a password?

2005-01-10 Thread Joshua J. Kugler
to the mysql db. j- k- On Saturday 08 January 2005 05:55, Gleb Paharenko said something like: Hello. As said at: http://dev.mysql.com/doc/mysql/en/SET_PASSWORD.html Only clients with access to mysql database can set passwords for other accounts. Joshua J. Kugler [EMAIL PROTECTED

Re: Unique IDs

2005-01-07 Thread Joshua J. Kugler
that have a FK pointer. Any ideas? Thanks! -Andy -- Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295 Every knee shall bow, and every tongue confess, in heaven, on earth, and under the earth, that Jesus Christ is LORD -- Count on it! -- MySQL General Mailing List For list archives: http

GRANT can't grant with a password?

2005-01-07 Thread Joshua J. Kugler
in question, worked and created the user, albeit with no password. Is there a way for a user with GRANT privs to create a user *with* a password? j- k- -- Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295 Every knee shall bow, and every tongue confess, in heaven, on earth, and under

Re: Upgrading from 3.23.58 to 4.1

2004-12-07 Thread Joshua J. Kugler
incompatiblities between the two versions, or any gotchas to the upgrade? -- A. Clausen [EMAIL PROTECTED] -- Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295 Every knee shall bow, and every tongue confess, in heaven, on earth, and under the earth, that Jesus Christ is LORD -- Count

Re: MySQL server is taking all my hardrive space

2004-10-21 Thread Joshua J. Kugler
in fact, but the dir where MySQL resides /var/lib/mysql is consuming about 10Gb of my hard drive. What can be going wrong here? I am running 4.0.20-Max-log Thanks, C.F. -- Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295 Every knee shall bow, and every tongue confess, in heaven

Re: MySQL Secure Connection(e.g. SSL) Question

2004-08-25 Thread Joshua J. Kugler
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295 Every knee shall bow, and every tongue confess, in heaven, on earth, and under the earth, that Jesus Christ is LORD -- Count on it! -- MySQL General Mailing List For list archives: http

Re: No Response from Server

2004-07-13 Thread Joshua J. Kugler
tell me what can i do. Should i use MYSQL Clusters or any other thing ... i'll be so gratefull regards, s.ahmad Lahore, Pakistan -- Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295 Every knee shall bow, and every tongue confess, in heaven, on earth, and under the earth, that Jesus Christ

Re: No Response from Server

2004-07-13 Thread Joshua J. Kugler
+ Reservation stations in the country. Where multiple operators are sitting and reserving seats. Indexes are being used in the DB. as i am related to hosting company, i havent seen if they are taking advantage of indexes. regards, s.ahmad On Mon, 12 Jul 2004 22:36:10 -0800, Joshua J. Kugler

Re: table scope

2004-07-13 Thread Joshua J. Kugler
find out whether mysql has that or not. If not, are there any alternatives anyone can suggest? Thanks Alex -- Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295 Every knee shall bow, and every tongue confess, in heaven, on earth, and under the earth, that Jesus Christ is LORD -- Count

Re: mySQL on MAC

2004-07-13 Thread Joshua J. Kugler
? Any helpful insights? -- Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295 Every knee shall bow, and every tongue confess, in heaven, on earth, and under the earth, that Jesus Christ is LORD -- Count on it! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: DBF to MySQL

2004-07-08 Thread Joshua J. Kugler
. I don't know if I can even implement those classes. SNIP LOAD DATA INFILE 'myfile.cdf' INTO TABLE mytable FIELDS TERMINATED BY ',' ENCLOSED BY '' LINES TERMINATED BY '\n'; -- Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295 Every knee shall bow, and every tongue confess, in heaven

Re: problem importing .csv (excel format) into mysql

2004-07-08 Thread Joshua J. Kugler
is in that field in the Excel file? What kind of numbers? j- k- -- Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295 Every knee shall bow, and every tongue confess, in heaven, on earth, and under the earth, that Jesus Christ is LORD -- Count on it! -- MySQL General Mailing List For list

Re: INSERT DISTINCT?

2004-07-07 Thread Joshua J. Kugler
or more of the columns as the row to be inserted? That is, without using a method outside SQL? Thanks, John -- Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295 Every knee shall bow, and every tongue confess, in heaven, on earth, and under the earth, that Jesus Christ is LORD -- Count

Re: DBF to MySQL

2004-07-07 Thread Joshua J. Kugler
be very welcome! For what it is worth, I am a Mac OSX.3 user. Thanks, John -- Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295 Every knee shall bow, and every tongue confess, in heaven, on earth, and under the earth, that Jesus Christ is LORD -- Count on it! -- MySQL General

Re: BLOB's - General Guidance

2004-05-27 Thread Joshua J. Kugler
in the db if necessary, and use your middleware to display the images. Its faster, easier to maintain, and easier to backup. IMO, storing images in the db just bloats the file and complicates all the backup issues. -- greg willits -- Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295 Every

Re: Last inserted ID

2004-05-05 Thread Joshua J. Kugler
sec) However, when I run this from my PHP script, I get a value of 0. Any clues as to how to resolve this? Thanks! -Erich- -- Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295 Every knee shall bow, and every tongue confess, in heaven, on earth, and under the earth, that Jesus Christ

Re: Plz help quick - mysql/php/web server undefined function all of a sudden

2004-05-03 Thread Joshua J. Kugler
Services Simrad, Inc www.simradusa.com [EMAIL PROTECTED] There is no reason anyone would want a computer in their home. --Ken Olson, president, chairman and founder of Digital Equipment Corporation, 1977 (Then why do I have 8? Somebody help me!) -- Joshua J. Kugler -- Fairbanks

Re: Connect string for ASP

2004-05-01 Thread Joshua J. Kugler
E-mail: [EMAIL PROTECTED] Web: www.bpenet.net BPEnet Offices in ~ Sussex, London Dublin -- Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295 Every knee shall bow, and every tongue confess, in heaven, on earth, and under the earth, that Jesus Christ is LORD -- Count on it! -- MySQL

Re: libmysql setting it's own signal handlers?

2004-05-01 Thread Joshua J. Kugler
OK...thanks for the clarification. It helps. And it's good to know that what I'm doing won't break anything. j- k- On Thursday 29 April 2004 07:16 pm, Sasha Pachev said something like: Joshua J. Kugler wrote: I have a program that is using (via a front end library) libmysql. If I

Re: triggers (or too-many-crappy-questions)

2004-05-01 Thread Joshua J. Kugler
- k- -- Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295 Every knee shall bow, and every tongue confess, in heaven, on earth, and under the earth, that Jesus Christ is LORD -- Count on it! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

libmysql setting it's own signal handlers?

2004-04-29 Thread Joshua J. Kugler
libmysql, my signal handler works fine. What does libmysql do to the signal handlers when it initializes? I don't have the source for it in front of my, or I would probably go digging my self. Running up against a deadline as it is. :) Thanks! j- k- -- Joshua J. Kugler Fairbanks

Re: What is your mysql debugging strategy?

2004-04-27 Thread Joshua J. Kugler
in there, and see what error it gives me. As in 'You have an error near' type messages. j- k- -- Joshua J. Kugler Fairbanks, Alaska Computer Consultant--Systems Designer .--- --- ... ..- .--.- ..- --. .-.. . .-. [EMAIL PROTECTED] ICQ#:13706295 Every knee shall bow, and every tongue

Re: SELECT duplicate rows

2004-04-21 Thread Joshua J. Kugler
columns are duplicated in at least one other row in any of the tables? Essentially, a command to find duplicate entries in the database . -- Joshua J. Kugler Fairbanks, Alaska Computer Consultant--Systems Designer .--- --- ... ..- .--.- ..- --. .-.. . .-. [EMAIL PROTECTED] ICQ#:13706295

Re: SELECT duplicate rows

2004-04-21 Thread Joshua J. Kugler
, etc. However, I need it to match columns on all of the tables in the database (of which there are many), rather than just two. Any ideas? Thanks, John on 4/21/04 12:57 AM, Joshua J. Kugler at [EMAIL PROTECTED] wrote: Yes, there is a way. It's called joins. :) I don't remember

Re: Learning curve

2004-04-15 Thread Joshua J. Kugler
T. Caskey -- Joshua J. Kugler Fairbanks, Alaska Computer Consultant--Systems Designer .--- --- ... ..- .--.- ..- --. .-.. . .-. [EMAIL PROTECTED] ICQ#:13706295 Every knee shall bow, and every tongue confess, in heaven, on earth, and under the earth, that Jesus Christ is LORD -- Count

Re: Multi-User Issues

2004-04-15 Thread Joshua J. Kugler
and by your name with no luck. If you don't feel like going into detail, could you point out some good links to learn more about the subject. Regards, Justin Palmer -Original Message- From: Joshua J. Kugler [mailto:[EMAIL PROTECTED] Sent: Thursday, April 15, 2004 3:27 PM

Re: Too many server instances

2004-04-12 Thread Joshua J. Kugler
concurrently on the box. Each one of them allocates 512M for the buffer pool and the box grinds to a halt, completely out of RAM to do anything! I've included a snippet of the top command display (I hope that you can read it easily). -- Joshua J. Kugler Fairbanks, Alaska Computer Consultant

Re: disabling backslash as an escape character in strings

2004-04-08 Thread Joshua J. Kugler
to upgrade to the latest 4.0x if it can solve this problem. -- Joshua J. Kugler Fairbanks, Alaska Computer Consultant--Systems Designer .--- --- ... ..- .--.- ..- --. .-.. . .-. [EMAIL PROTECTED] ICQ#:13706295 Every knee shall bow, and every tongue confess, in heaven, on earth, and under

Re: MSSQL Server to MYSQL migration problems

2004-04-06 Thread Joshua J. Kugler
postulantes ALL /NULL/ /NULL/ /NULL/ /NULL/ 4499 Thanks for your help, im still confused :( Joshua J. Kugler wrote: MySQL is very stable on large databases...I would suspect inefficient indexes. What does your query look like? What is the output when you put EXPLAIN in front of your

Re: MSSQL Server to MYSQL migration problems

2004-04-05 Thread Joshua J. Kugler
migrated data base, ... it just don't display anything. Any ideas ? Is there any issue problem when migrating MSSQL image column types to MYSQL ? Thanks in advance, cheers from Argentina, -- Joshua J. Kugler Fairbanks, Alaska Computer Consultant--Systems Designer

Re: MSSQL Server to MYSQL migration problems

2004-04-05 Thread Joshua J. Kugler
pm, Rodrigo Galindez said something like: Im using SQLYog to display results. It lets me to display blob data types. By the way, i was trying to do some queries with phpmyadmin ... but, it hungs ... hmmm ... inestability with large databases in mysql maybe ? :S Joshua J. Kugler wrote: You

Re: Transaction Not supported

2004-03-31 Thread Joshua J. Kugler
;) What I did was trying to use something like this which to my knowledge doesnt work on MySQL servers. $dbh-commit(); $dbh-rollback(); /Jonas - Original Message - From: Joshua J. Kugler [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 31, 2004 9:02 AM Subject

Re: Transaction Not supported

2004-03-30 Thread Joshua J. Kugler
('BEGIN'); . . . . $dbh-do('COMMIT'); What does your code look like? j- k- -- Joshua J. Kugler Fairbanks, Alaska Computer Consultant--Systems Designer .--- --- ... ..- .--.- ..- --. .-.. . .-. [EMAIL PROTECTED] ICQ#:13706295 Every knee shall bow, and every tongue confess

Re: High resolution timestamps

2004-03-23 Thread Joshua J. Kugler
I've been needing high-resolution timestamps (year/month/day/hour/minute/seconds/microseconds) in MySQL (to store network packets, mmm). Is this a planned feature for MySQL in the future? -- Joshua J. Kugler Fairbanks, Alaska Computer Consultant--Systems Designer

Re: Security

2004-03-11 Thread Joshua J. Kugler
(for example address change) and add transactions to the transaction table. What I do not want to happen is that customer A is able to modify customer B's record. In short how would you restrict customer a to see transactions that pertain to him/her. Many thanks. -- Joshua J. Kugler Fairbanks, Alaska

Re: https access to phpmyadmin - mysql

2004-03-11 Thread Joshua J. Kugler
time for other applications. What I am looking for are phpmyadmin specific instructions as to how to configure phpmyadmin to use mod_ssl and and DISALLOW http logins and only allow https logins and use of phpmyadmin. Thanks anyone. -- Joshua J. Kugler Fairbanks, Alaska Computer Consultant

Re: Span a database transaction across multiple CGI scripts

2004-03-10 Thread Joshua J. Kugler
be implemented in MySQL? Could somebody please at least give me a hint how to implement this? Many thanks in advance. Regards Sagara __ Do you Yahoo!? Yahoo! Search - Find what you’re looking for faster http://search.yahoo.com -- Joshua J. Kugler Fairbanks

Re: Mysql timed actions... Confused

2004-03-10 Thread Joshua J. Kugler
seconds 2004/03/09 06:45:00OK, 77526 bytes26 seconds 2004/03/09 06:50:01OK, 77526 bytes29 seconds 2004/03/09 06:55:00OK, 77526 bytes28 seconds 2004/03/09 07:00:00OK, 77532 bytes28 seconds 2004/03/09 07:05:00OK, 77526 bytes1 seconds -- Joshua J. Kugler

Re: Security

2004-03-10 Thread Joshua J. Kugler
details, etc) in say abc database what will I have to do to make sure when customer A logs in to the database can only see his/her account, orders, order details without getting access to other customer accounts. -- Joshua J. Kugler Fairbanks, Alaska Computer Consultant--Systems Designer

Re: Security

2004-03-10 Thread Joshua J. Kugler
: Joshua J. Kugler [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 10, 2004 5:34 PM To: Mulugeta Maru; MySQL Subject: Re: Security Only being able to see certain rows is not a function of MySQL, it is a function of the application you write for the user to access the database. If a user has

Re: Saving file into database

2004-03-09 Thread Joshua J. Kugler
a perl interafce. Is this at all possible??? And would it be possible to then read that file from a c++ interface? -- Joshua J. Kugler Fairbanks, Alaska Computer Consultant--Systems Designer .--- --- ... ..- .--.- ..- --. .-.. . .-. [EMAIL PROTECTED] ICQ#:13706295 Every knee shall bow

Re: Selectinmg most recent dates from multiple table items

2004-03-07 Thread Joshua J. Kugler
on queries and I've been searching and reading through messages without success yet. I suspect a big part of the problem is I'm fairly new to sql queries and am not exactly sure what terms to search for. Tim -- Joshua J. Kugler Fairbanks, Alaska Computer Consultant--Systems Designer

Re: Information request

2004-03-04 Thread Joshua J. Kugler
the protocol and the operations possible via the protocol? Best regards Søren -- Joshua J. Kugler Fairbanks, Alaska Computer Consultant--Systems Designer .--- --- ... ..- .--.- ..- --. .-.. . .-. [EMAIL PROTECTED] ICQ#:13706295 Every knee shall bow, and every tongue confess, in heaven

Re: mysql import problem

2004-03-04 Thread Joshua J. Kugler
import such a file. How do you want to import this file? Do you want to load the whole file into specific field? -- Joshua J. Kugler Fairbanks, Alaska Computer Consultant--Systems Designer .--- --- ... ..- .--.- ..- --. .-.. . .-. [EMAIL PROTECTED] ICQ#:13706295 Every knee shall bow

Microseconds in the 4.0.x series...

2004-03-03 Thread Joshua J. Kugler
announcement or the 4.0.17 documentation? Is there a way to get sub-second resolution in 4.0.17, or must I rely on my application? Thanks! j- k- -- Joshua J. Kugler Fairbanks, Alaska Computer Consultant--Systems Designer .--- --- ... ..- .--.- ..- --. .-.. . .-. [EMAIL PROTECTED

Re: Dream MySQL Server?

2004-03-03 Thread Joshua J. Kugler
on Windows, Mac, or *nix can talk to a MySQL server on a Windows, Mac, or *nix server, and will never know the difference. All it knows it that it is connecting to port 3306 and it's talking to a MySQL server. There is no difference among operating systems. j- k- -- Joshua J. Kugler

Re: locking

2004-03-03 Thread Joshua J. Kugler
(changing row status from 'waiting' to 'processing'), how do I prevent another process from grabbing the same row? Thanks for any help or advice -TO -- Joshua J. Kugler Fairbanks, Alaska Computer Consultant--Systems Designer .--- --- ... ..- .--.- ..- --. .-.. . .-. [EMAIL PROTECTED

Re: FW: query

2004-03-03 Thread Joshua J. Kugler
. Example : table customer with field customer_id, address, DOB, Services I need to know that customer data in my table have more than 1 record for 1 customer. So he/she has more then 1 customer_id. I need to query the double record, not the DISTINCT one. ~Elle~ -- Joshua J. Kugler Fairbanks

Re: FW: query

2004-03-03 Thread Joshua J. Kugler
. ~Elle~ -Original Message- From: Joshua J. Kugler [mailto:[EMAIL PROTECTED] Sent: Thursday, March 04, 2004 11:08 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: FW: query Oh, so what you're looking for a a find duplicates query (as MS Access calls it). That's something

Re: Microseconds in the 4.0.x series...

2004-03-03 Thread Joshua J. Kugler
On Wednesday 03 March 2004 08:04 pm, Sasha Pachev wrote: Joshua J. Kugler wrote: In the manual that came with MySQL 4.0.17 (at least in the Mandrake packages of such) it says I can use %f to get the microseconds in a DATE_FORMAT call. This does not work, however, and searching the archives

Re: Microseconds in the 4.0.x series...

2004-03-03 Thread Joshua J. Kugler
a look at the paragraph that follows the table that lists the formatting specifiers. -- Joshua J. Kugler Fairbanks, Alaska Computer Consultant--Systems Designer .--- --- ... ..- .--.- ..- --. .-.. . .-. [EMAIL PROTECTED] ICQ#:13706295 Every knee shall bow, and every tongue confess

Re: Using mod_auth_mysql with Apache 2

2004-03-01 Thread Joshua J. Kugler
this be placed. Any help would be great! Thanks, James -- Joshua J. Kugler Fairbanks, Alaska Computer Consultant--Systems Designer .--- --- ... ..- .--.- ..- --. .-.. . .-. [EMAIL PROTECTED] ICQ#:13706295 Every knee shall bow, and every tongue confess, in heaven, on earth, and under

Re: Xserve G5

2004-03-01 Thread Joshua J. Kugler
hardware to run our MySQL server. The 64-bit architecture is something we would like to take advantage of. Is this good, bad, otherwise? Any comments would be appreciated. Thanks TOM -- Joshua J. Kugler Fairbanks, Alaska Computer Consultant--Systems Designer

Re: A problem with access to data source, please help!!!!

2004-03-01 Thread Joshua J. Kugler
'*F65E684A09D85F1DD4574279566B9E738DD597E7' WITH GRANT OPTION + + 1 row in set (0.00 sec) I need a help, thanks in advance Rafael -- Joshua J

Re: WHERE clauses across rows...

2004-02-27 Thread Joshua J. Kugler
table_name as t1, table_name as t2 where t1.rownumber = t2.rownumber+1 and ( (t1.col1='strt' and t1.col2='word') OR (t1.col2='strt' and t1.col3='word') OR (t1.col3='strt' and t1.col4='word') OR (t1.col4='strt' and t2.col1='word') ) Good luck. Eric Joshua J. Kugler [EMAIL PROTECTED

WHERE clauses across rows...

2004-02-26 Thread Joshua J. Kugler
if 'word' is in col1 on the next row (via another query)? Ideas? Tips? Suggestions? Thanks much! j- k- -- Joshua J. Kugler Fairbanks, Alaska Computer Consultant--Systems Designer .--- --- ... ..- .--.- ..- --. .-.. . .-. [EMAIL PROTECTED] ICQ#:13706295 Every knee shall bow

Re: Is there any way to search a whole database for a value?

2003-03-11 Thread Joshua J . Kugler
A request such as this make me think the database is not properly normalized. If there is one value that can be in several columns, it is very likely those columns need to be broken into their own table, so that they can be queried with a SELECT statement that has only one column in its WHERE

Re: what is wrong with this perl mysql code?

2003-03-04 Thread Joshua J . Kugler
You need quotes around $username in your SQL query, unless you've already run $username thorough $dbh-quote(); j- k- On Tuesday 04 March 2003 13:11, Jianping Zhu wrote: I am writing a simple login system by using perl( this is almost my first program in perl), After user pick a

Re: problem: Loosing .MYD Files

2003-02-26 Thread Joshua J . Kugler
Daniel - This might be a long shot, but since I've actually run into this problem before, here goes: Check your partitions. I had a server on which this very thing happened, and it turned out there were overlapping partitions. This was all fine and dandy until data was written to those

Re: Different value from same function

2003-02-18 Thread Joshua J . Kugler
Your INT in your table is a signed INT, which is going to have a maximum value of 2^31, thus your IP address is causing the field to roll over. You need to change your IP column to UNSIGNED INT. That should solve your problem. j- k- On Tuesday 18 February 2003 12:33, Aaron Conaway

Re: Applications for creating reports for MySQL

2003-02-06 Thread Joshua J . Kugler
How much work do you want done for you? Perl and Python are great apps for writing MySQL reports, and you can output all the report to a text file, which would be great for a reader. But as report applications, can't help you there. Sorry. j- k- On Tuesday 04 February 2003 09:10,

/usr/bin/safe_mysqld: 5: command not found (WAS: Re: 3.23.54 compile error)

2002-12-14 Thread Joshua J . Kugler
I got that as well., and like the case below, MySQL is up and running just fine. I tried looking in safe_mysqld for a spurious '5' but couldn't find anything. Does anyone know what's up with the most recent safe_mysqld? j-- k- On Thursday 12 December 2002 17:16, Gabriele Carioli

Re: Now() and Timestamp

2002-11-21 Thread Joshua J . Kugler
INSERT INTO $tablename (sender, recipient, whenread, whensent, subject, messagetext, folder, priority, condition) VALUES ('$directorid', '$SendTo', '00', NOW(), '$SetSubject', '$MessageText', 'Inbox', '$SetPriority', 'TO') Easy as that! j- k- mysql, sql -- Joshua

Re: last_insert_id()

2002-11-12 Thread Joshua J . Kugler
This looks like the same problem I have with MS Access. It seems MS Access uses the SELECT id FROM table_name WHERE is IS NULL, and this syntax clears the last insert ID field. My solution is here: --- One Line URL, might wrap ---

Re: AutoNumber Question

2002-11-11 Thread Joshua J . Kugler
The correct behavior is the number starting at the last number used. If you are using MyISAM tables, you should see this behavior. If you are using the old style ISAM tables, it will restart at 1 every time. j- k- On Monday 11 November 2002 11:41, Jessee Parker wrote: I have a

Re: Dual processors and mysql

2002-10-14 Thread Joshua J . Kugler
MySQL is multithreaded, so your OS will send separate threads to different processors. So, yes, MySQL will automatically take advantage of multiple processors, no need to tell it explicitly. j- k- On Monday 14 October 2002 08:49, Dyego Souza do Carmo wrote: Hello all... I´m

Re: MySQl db as filesystem.

2002-10-12 Thread Joshua J . Kugler
There has been such a project for quite a while. Take a look at http://no.spam.ee/~tonu/ and find the link about SQLFS. j- k- On Thursday 10 October 2002 02:58, Alex Polite wrote: Is there any way I could display a MySQL database as a filesystem under Linux? alex -- Joshua

Re: resetting mysql server gently

2002-10-10 Thread Joshua J . Kugler
I agree completely with Egor! You should not be killing your processes to solve load problems. If there is a load problem 1) You need to write your applications better, 2) you need to have a better database structure, 3) you need to analyze where indexes would help you, or 4) you need a more

Re: Mixing Linux and Windows and paying for it

2002-09-30 Thread Joshua J . Kugler
On Monday 30 September 2002 10:13, Drulli B wrote: Hi, I have a grand total of two very important but possibly humiliatingly daft questions, that I hope some kind soul will patiently solve: 1. Can I run a mySQL server on a Linux computer, and query it through myODBC running on a Windows

Re: Bitten by a strange bug...

2002-09-03 Thread Joshua J . Kugler
Tom - I'll address what I can I had the same problem with fields being truncated on direct connections (the problem does not manifest on ODBC table attaches in Access). IIRC, the way to solve this problem is to make sure the optimize columns widths (option 1) in the ODBC properties.

Re: MD5

2002-06-20 Thread Joshua J . Kugler
If you are running Linix, at the prompt type: md5sum filename I'm sure you can get md5sum for other Unices as well. j- k- On Thursday 20 June 2002 13:00, Kiss Dániel wrote: Hi everyone, Can anyone tell me how to create an MD5 checksum on a file. I tried to do this by using the

Re: Problems with UPDATE in v3.23.49 (is this a bug)

2002-04-05 Thread Joshua J . Kugler
It's not illogical at all. You often want (sometimes need) that field to make sure a record has not changed when you go back to update the row. MS Access (and others) uses this so as not to overwrite changes made since the record was retrieved. You can't always rely on the client to set

Re: MyODBC for Core Business, followup...

2002-03-06 Thread Joshua J . Kugler
To all: This is in response to a request for more information. I thought others may find it useful. Thanks so much for your reply. It's good news to hear that someone is relying on MyODBC for an important purpose, much of the usage I've seen seemed rather small. Like I said, we

Re: How compressable is a typical MySQL database?

2002-02-17 Thread Joshua J . Kugler
Oh. OK. Didn't know that. Thanks. j- k- On Saturday 16 February 2002 22:26, Jeremy Zawodny wrote: On Sat, Feb 16, 2002 at 03:56:42PM -0900, Joshua J.Kugler wrote: In that case, i would highly recommend using mysqldump to backup your databases. Simply compressing the actual DB's

Re: How compressable is a typical MySQL database?

2002-02-16 Thread Joshua J . Kugler
In that case, i would highly recommend using mysqldump to backup your databases. Simply compressing the actual DB's could give you tables in inconsistent states, UNLESS you first shut down your DB server, then run the backup. Something to think about. j- k- On Saturday 16 February

Re: forms?

2002-02-12 Thread Joshua J . Kugler
Using Perl/CGI and DBI::MySQL would work for forms. You could take the input from the browser, and print the results back to the browser. Would that work? j- k- On Monday 11 February 2002 05:20, Jim Hatridge wrote: Hi all... First of all, I think that MySQL is really great. The

Re: LIKE work around??

2002-02-11 Thread Joshua J . Kugler
Umm, I take it you haven't read the documentation? MySQL fully supports LIKE. Can you tell us the error you are getting? Along with the full query? j- k- On Thursday 07 February 2002 11:11, Rutledge, Aaron wrote: MySQL doesn't support LIKE does it? I got an error when I tried. --

Re: LIKE work around??

2002-02-07 Thread Joshua J . Kugler
Umm, I take it you haven't read the documentation? MySQL fully supports LIKE. Can you tell us the error you are getting? Along with the full query? j- k- On Thursday 07 February 2002 11:11, Rutledge, Aaron wrote: MySQL doesn't support LIKE does it? I got an error when I tried. --

Re: i686 Binary on i586 OK?

2002-02-01 Thread Joshua J . Kugler
You can try...but, an i686 binary may use machine code instructions that are not present in the i586 chip. Thus, the program will crash with an illegal instruction message. j- k- On Friday 01 February 2002 16:11, Steve wrote: I'm wanting to install mysql on an older i586 machine

Re: Problem with MySQL and SMP?

2002-01-11 Thread Joshua J . Kugler
We are having the same problem. Mandrake 8.1, kernel 2.4.17, MySQL 3.23.47. Dual PIII-500, 512MB of RAM, Mylex DAC960 RAID 5. After being up for a few days, the system completely froze. No ssh, no console, nothing. Had to hard reset the server. Yes, we compiled MySQL: we have to. Our

Re: Problem with MySQL and SMP?

2002-01-11 Thread Joshua J . Kugler
Yes, this had occured to me. I am thinking about downgrading to kernel 2.4.8, or such. Not sure I really want to do that, but I'd rather do that than face system lock ups. j- k- On Friday 11 January 2002 08:55, Sinisa Milivojevic wrote: If nothing works as you said, no ssh, no

What kind of crashes with GCC 2.96?

2002-01-07 Thread Joshua J . Kugler
On the MySQL download page, there is a warning for GCC 2.96/x86/Linux that reads thus: Several of our users have reported random crashes and table corruption with MySQL binaries compiled with gcc 2.96 on the x86 Linux platform. I was wondering what kind of crashes users had experienced.

Re: Are there any openly-accessible MySQL server [I can use for testing]?

2001-12-27 Thread Joshua J. Kugler
Umm, why not just install a copy locally? You can get a binary for just about any OS. And a local copy would be much faster than working over the internet. j- k- On Thursday 27 December 2001 06:31, David Ayliffe wrote: I am writing a conversion tool for MySQL and I could do with

  1   2   >