Re: SOLVED! (was: Re: What is wrong with this query?)

2002-12-25 Thread Mark
- Original Message - From: Rick Robinson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, December 24, 2002 12:03 PM Subject: RE: SOLVED! (was: Re: What is wrong with this query?) It's not a true daemon ... No. It is only called a zombie if the child was brutally cut off from the

Re: Compile/Install problems, NetBSD 1.6

2002-12-25 Thread Lars Heidieker
Hi, have you tried the mysql-server from the pkg collection of netbsd? Lars On Dienstag, Dezember 24, 2002, at 09:44 Uhr, Bruce Lane wrote: Fellow MySQL'ers, I've been trying to install MySQL ver. 3.23.54a on NetBSD 1.6 on an i386 platform. The difficulty I've been running into is

Re: maximum record size query

2002-12-25 Thread Arun Kumar
--- [EMAIL PROTECTED] wrote: Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query,queries,smallint If you just reply to this message, and include

Ïð½º

2002-12-25 Thread ºÂÑå¶ð
ÄãºÃ£º ÎÒ¹«Ë¾ÊÇÒÔ¾­ÓªÌØÖÖÏ𽺡¢ÏðËÜ¡¢Ä¦²Á²ÄÁÏ¡¢Èó»¬ÓÍÌí¼Ó¼Á¡¢µçÀ²ÄÁÏ¡¢ÂÖÌ¥²ÄÁÏ¡¢Õ³ºÏ¼ÁΪÖ÷£¬ÏàÓ¦¼¼Êõ·þÎñΪ¸¨µÄ¶àÔª»¯¹«Ë¾¡£ÏÖÖ÷Òª¾­ÓªÆ·ÅÆ£¨¶¡ëæ¡¢·ÛÄ©¶¡ëæ¡¢ÒºÌ嶡ëæ¡¢ÈýÔªÒÒ±û¡¢¹è½º¡¢·ú½º¡¢±ûÏ©Ëáõ¥¡¢

mysql xpcom wrapper available for Mozilla

2002-12-25 Thread Dmitry Dorofeev
Hi all. Check out http://mysqlxpcom.mozdev.org/ Quick intro: Allows to write MySQL interfaces in pure JavaScript, XUL or HTML. Multiplatform. Usable right now. Enjoy and Happy Xmas ! -- Deem0N** [EMAIL PROTECTED] ** Natural born YASPer http://www.yasp.com/ Just

Re: multiple database connection

2002-12-25 Thread Georg Richter
On Tuesday 24 December 2002 17:47, Lalit Chandwani wrote: multiple database connection on windows 98 , mysqld running with pws here is some confusion with the multiple database connection variables i am executing the same code in three different ways it gives me diffrent output all the

Re: syntax

2002-12-25 Thread Stefan Hinz, iConnect \(Berlin\)
Samuel, select sld_vlprov,hist_lanc from sld_lanc,lanc where sld_lanc.sld_user *= lanc.user_usuario In MySQL, this could simply be: select sld_vlprov,hist_lanc from sld_lanc,lanc where sld_lanc.sld_user = lanc.user_usuario But you can write it like you did, as well: select * from sld_lanc

Re: entering Chr(13) Chr(10) in insert update

2002-12-25 Thread Stefan Hinz, iConnect \(Berlin\)
Kayamboo, (B (BIs there any way I can insert Chr(13) Chr(10) along with string (B characters in a blob field using *insert* or *update* statements. (B (BYou can insert these values (CR/LF) just like any other character, but (Byou have to make sure they have been escaped properly. If

Is this a MySQL error?

2002-12-25 Thread Octavian Rasnita
Hi all, I gave the following command in the default MySQL client: select from_days(365); The result is -00-00 instead of 0001-00-00. If I gave the following command: select from_days(366); It gives the result 0001-01-01. If I give numbers less than 356, the result is 0 for the year, the

Hiding the password

2002-12-25 Thread Octavian Rasnita
Hi all, I want to make a CGI program in Perl that queries a MySQL database, and the problem is that I need to write the password for the database in the program and this password can be seen by any user that has an account on that server. I need to gave 755 permissions to CGI scripts because

re: MySQL password confusion.

2002-12-25 Thread Egor Egorov
On Sunday 22 December 2002 06:29, William Bradley wrote: At the present time I am using Mandrake 9.0 and installed the MySql programmes that con the three disks: MySQL-3.23.52-1mdk.i586.rpm* MySQL-bench-3.23.52-1mdk.i586.rpm* MySQL-client-3.23.52-1mdk.i586.rpm*

re: Mysql versions, disks, speed, FTS, and EXPLAIN feature request (SELECT [CALC_RESOURCES])

2002-12-25 Thread Victoria Reznichenko
On Saturday 21 December 2002 00:06, Steven Roussey wrote: I wanted to thank the MySQL team for making such a great product! We moved from 3.23 to 4.0.x a couple of months ago and everything works great. Just upgraded to 4.0.6 and glad to see it work out of the box without a rev 4.0.6a. Those

re: connect by clause...

2002-12-25 Thread Victoria Reznichenko
On Tuesday 24 December 2002 16:52, Gabriele Carioli wrote: It's Christmas and I'm sending my wish list to Santa Claus... ;o) 1. hierarchical queries [skip] it is possible to execute a query like: SELECT * FROM data CONNECT BY id PRIOR pnt START WITH id=0; [skip] It's in the TODO for

re: Do I have to modify mysql-bin.index when purging old binary logs?

2002-12-25 Thread Victoria Reznichenko
On Tuesday 24 December 2002 17:12, Christian Hammers wrote: Subject says all, is everything fine when I just flush-logs every morning and remove every logfile that is older than 30 days? Or do I have to delete the corresponding line from the index file as well? Whatfor is it needed, btw? You

re: Starting MySQL with Redhat 8.0

2002-12-25 Thread Egor Egorov
On Tuesday 24 December 2002 19:34, Andrew Schaefer wrote: I had the same problem. I fixed it by realizing that when the program was installed it put the mysql.sock file in the /var/libs/mysql dir however when it starts it looks for the file in /tmp You can either change the folder it looks

Re: SOLVED! (was: Re: What is wrong with this query?)

2002-12-25 Thread Mike Wexler
This is getting a little bit away from mysql but the easy way to do this is: use Proc::Daemon;# Available at a CPAN near you :-) ... Proc::Daemon::Init; which takes care of all the details of daemonizing your program. But this still doesn't explain (at least to me) the lost connection.

Unable to establish database connection via PHP3

2002-12-25 Thread Mohammed Fouwaaz
Hello mysql gurus I am fairly new to mysql and php3. mysql server is running ok and I created a table and inserted a few records. php3 is also working ok and I am able to run a regular 'Hello World' script. BUT when I include a phpinfo() and call that -- I don't see an entry with the

Re: Is this a MySQL error?

2002-12-25 Thread Benjamin Pflugmann
Hello. On Wed 2002-12-25 at 11:47:22 +0200, [EMAIL PROTECTED] wrote: Hi all, I gave the following command in the default MySQL client: select from_days(365); The result is -00-00 instead of 0001-00-00. If I gave the following command: select from_days(366); It gives the

Re: Unable to establish database connection via PHP3

2002-12-25 Thread Gerald R. Jensen
Did you configure your web server (Apache?) for MySQL and PHP? - Original Message - From: Mohammed Fouwaaz [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, December 25, 2002 11:59 AM Subject: Unable to establish database connection via PHP3 Hello mysql gurus I am fairly new to

Re: Unable to establish database connection via PHP3

2002-12-25 Thread Mohammed Fouwaaz
It is Personal Web Server -- but I am not sure whether any special configuration is necessary for MySQL and PHP3. I installed PWS first and then MySQL and lastly PHP3. Thanks Regards Fouwaaz [EMAIL PROTECTED] wrote: Did you configure your web server (Apache?) for MySQL and PHP? -

Re: Hiding the password

2002-12-25 Thread Benjamin Pflugmann
Hello. On Wed 2002-12-25 at 13:15:58 +0200, [EMAIL PROTECTED] wrote: Hi all, I want to make a CGI program in Perl that queries a MySQL database, and the problem is that I need to write the password for the database in the program and this password can be seen by any user that has an account

Re: Unable to establish database connection via PHP3

2002-12-25 Thread Doug Thompson
This is a PHP issue. I don't recall the version when MySQL support became standard, but PHP3 is too old to be of much use. Especially with the new features for security introduced in PHP 4.2.0. Your best bet is to upgrade to a current release of PHP. That way you'll have MySQL support

Re: Unable to establish database connection via PHP3

2002-12-25 Thread Gerald R. Jensen
Don't know anything about PWS ... - Original Message - From: Mohammed Fouwaaz [EMAIL PROTECTED] To: Gerald R. Jensen [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, December 25, 2002 12:36 PM Subject: Re: Unable to establish database connection via PHP3 It is Personal Web

Bug with Connector/J on Linux?

2002-12-25 Thread Christopher Balz
I may have encountered a bug with Connector/J on Linux. Using the latest Connector/J (mysql-connector-java-2.0.14-bin.jar) with MySQL 3.23.41 (all on RedHat Linux 7.3 with upgrades), I have encountered an sql exception. This sql exception is not reproducable under the same conditions on Windows

Re: problem: mysql locks up under freebsd

2002-12-25 Thread Simon K. Grabowski
Hi, [snip] I am having problems with my php+mysql driven site, running on a freebsd box. Mysql tends to lock up once-twice a day (or even more) and stop responding to queries. Standard FreeBSD installation is not the happiest MySQL environment. If your problem is really MySQL related, here

Unable to establish database connection via PHP3

2002-12-25 Thread Mohammed Fouwaaz
Hi Gerald, PWS is the Personal Web Server -- a little web server provided by microsoft supposedly good enough to host pages over an intranet. Thanks to the input of everyone, I managed to make a little progress in my problem. This is what I did: I edited the php3.ini file as follows. 1.

Update NOT NULL Field with NULL!

2002-12-25 Thread jay_r
Hi there, I'm using MySql 3.23.?? with Connector/J on Win32. My Problem is that the database lets me UPDATE NOT NULL Fields with NULL-Values. This is not a special Java Problem! For example: The Field Name in tbl_Names is declared NOT NULL. UPDATE tbl_Names SET Name = NULL WHERE ID = 23;

Re: Update NOT NULL Field with NULL!

2002-12-25 Thread Benjamin Pflugmann
Hello. On Thu 2002-12-26 at 00:09:55 +0100, [EMAIL PROTECTED] wrote: Hi there, I'm using MySql 3.23.?? with Connector/J on Win32. My Problem is that the database lets me UPDATE NOT NULL Fields with NULL-Values. This is not a special Java Problem! For example: The Field Name in

4 billion record + 6 Gigabytes text fie

2002-12-25 Thread yeong Tze En
My company is currently upgrade our company'database from PICK, an old database system to mysql.. Our company database got 1 table where the record is more than 40 million records, and the other table also got about i million record each.. what i found is i only can use the simple sql query

Optimize InnoDB table...

2002-12-25 Thread Chung Ha-nyung
I've heard that I should periodically alter innodb table to MyISAM and back to InnoDB to optimize table structure. I guess only dropping index and recreating it is enough, but should I change table type? query. -- Chung Ha-nyung alita@[neowiz.com|kldp.org] Sayclub http://www.sayclub.com

Problems

2002-12-25 Thread Elegant Systems
To The Mysql Support Team, We are stuck in a problem while installing mysql in linux.This is exactly what the error shows : 021109 12:59:10 mysqld started 021109 12:59:10 /usr/local/src/mysql/bin/mysqld: Can't create/write to file '/usr/local/src/mysql/data/localhost.localdomain.pid' (Errcode:

Problems

2002-12-25 Thread Elegant Systems
To The Mysql Support Team, We are stuck in a problem while installing mysql in linux.This is exactly what the error shows : 021109 12:59:10 mysqld started 021109 12:59:10 /usr/local/src/mysql/bin/mysqld: Can't create/write to file '/usr/local/src/mysql/data/localhost.localdomain.pid' (Errcode: