date:20030105

RE: Question - SELECT

2003-01-05 Thread Terence Ng

No.  Because the WHERE condition would control both:
SUM(lcreceive.amount_us)
SUM(lcopen.unit_price_us*lcopen.order_cbm) * 7.8

 --- Christensen, Dave [EMAIL PROTECTED]
wrote:  SELECT SUM(lcreceive.amount_us), 
   FROM lcopen, lcreceive
  WHERE lcreceive.due_date  current_date
AND lcopen.id=lcreceive.id GROUP BY lcopen.bank;
 
 
 Like this?
 -Original Message-
 From: Terence Ng [mailto:[EMAIL PROTECTED]] 
 Sent: Friday, January 03, 2003 7:09 PM
 To: mysql
 Subject: RE: Question - SELECT
 
 
 Thanks for your help, but I just want
 /* this condition */ lcreceive.due_date 
 current_date
 /* affect to */ SUM(lcreceive.amount_us)
 /* and not */
 
 
 Terence
 
  --- Christensen, Dave [EMAIL PROTECTED]
  SELECT  lcopen.bank, 
  SUM(lcopen.unit_price_us*lcopen.order_cbm) * 7.8
  AS open,
  SUM(lcreceive.amount_us), 
  lcreceive.due_date as receive,
  FROM lcopen, lcreceive
  WHERE lcreceive.due_date  current_date
AND lcopen.id=lcreceive.id GROUP BY lcopen.bank;
  
  
  I think this will work better.
  
  Dave
  -Original Message-
  From: Terence Ng [mailto:[EMAIL PROTECTED]]
  Sent: Friday, January 03, 2003 9:52 AM
  To: mysql
  Subject: Question - SELECT
  
  
  How do I correct this SQL code:
  
  2 tables there, and I want to add one conditon to
  item receive lcopen :
  id, bank, unit_price_us, order_cbm
  lcreceive: id, amount_us, due_date
  
  SELECT
  lcopen.bank,
  SUM(lcopen.unit_price_us*lcopen.order_cbm) * 7.8
 AS
  open,
  #
  SUM(lcreceive.amount_us) where lcreceive.due_date
 
  current_date AS receive,
  # # the above statement is not correct for the #
  additional condition # FROM
  lcopen, lcreceive AND lcopen.id=lcreceive.id GROUP
  BY lcopen.bank;
  
  Terence Ng
  
  
 

_
  Lonely
 

Christmas(?瘏捃)ㄛ餫飴鷂餫(Twins)ㄛ嶲耋(?荌)...
  祫In忒?? 顯斕綎隄毞
  http://ringtone.yahoo.com.hk
  
 

-
  Before posting, please check:
 http://www.mysql.com/manual.php   (the manual)
 http://lists.mysql.com/   (the list
  archive)
  
  To request this thread, e-mail
 [EMAIL PROTECTED]
  To unsubscribe, e-mail
 

[EMAIL PROTECTED]
  Trouble unsubscribing? Try:
 http://lists.mysql.com/php/unsubscribe.php 
 

_
 Lonely

Christmas(陳奕迅)，風箏與風(Twins)，無間道(電影)...
 至In手機鈴聲 陪你過冬天
 http://ringtone.yahoo.com.hk
 

-
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list
 archive)
 
 To request this thread, e-mail
 [EMAIL PROTECTED]
 To unsubscribe, e-mail

[EMAIL PROTECTED]
 Trouble unsubscribing? Try:
http://lists.mysql.com/php/unsubscribe.php 

___
Do You Yahoo!?
Get your free @yahoo.com.hk address at http://mail.english.yahoo.com.hk

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

ÉÏÍø»¨·Ñ¸ßÂð£¿ÊÔÊÔÕâ¸ö

2003-01-05 Thread airspace

ÈçÓÐÐËÈ¤Ò»±ßÉÏÍøÒ»±ß×¬Ç® 
Çë»¨ÉÙÉÙÊ±¼ä¿´¿´ÕâÆªÎÄÕÂ£¬ÕâÖ»»á»¨·ÑÄãºÜÉÙÊ±¼ä¡£ 
1Ð¡Ê±0.6ÃÀÔ²£¬ÔÚ¼ÒÀïÉÏÍø¿ÉÒÔ²¹ÌùÉÏÍø·ÑÓÃ£¡   
ÍøÂç×¬Ç®ÔÚ¹úÍâÒÑ¾Ïàµ±ÆÕ±é£¡ Ó¢ÓïÎÒ¿ÉÎª·Òë.

 

 ×¢²áÃâ·Ñ×¬È¡ÃÀ½ð  
 http://www.cashfiesta.com/php/join.php?ref=airspace
 Ö»ÒªÔÚÏß¾Í¼ÆÊý£¬1Ð¡Ê±0.6ÃÀÔ²£¡¾ø¶ÔÕæÊµ£¡£¡£¡£¡Ï£ÍûÄãÄÜ¹»ÓÐÐ©ÄÍÐÔ
¿´ÏÂÈ¥£¬Ð»Ð»;
 
 ÓÐÌõ¼þ¾Í¿ÉÒÔÊÔÊÔ,·´ÕýÓÖÃ»ÓÐËðÊ§!
 
ÓÐÐ©¶«Î÷ÐèÒª³¢ÊÔ£¬×¬Ç®Ò²ÊÇÒ»Ñù£¬ÓÐÌõ¼þ¾ÍÊÔÊÔ°É£¡¿ªÊ¼×ö±È½ÏÂý,ÎÒµÚÒ»¸öÔÂÃ»ÓÐÊÕµ½»ã¿î,µ«µÚ¶þ¸öÔÂÊÕµ½ÁË53ÃÀ½ð!
 ÓÐµÄ¶àµÄÒ»¸öÔÂ×öµ½ÁË2ÃÀ½ð(Õâ¸öÎÒ¾Í²»ÖªµÀÁË,·´ÕýÎÒµÄ53ÃÀ½ðÒÑ¾µ½ÊÖÁË!)!   
Õâ¸öÊÇ¹úÍâÏÖÔÚÁ÷ÐÐµÄÍø×¬£¡£¡ ¹úÄÚÖªµÀµÄÈË²»¶à£¡£¡×¬µÄ¾ÍÊÇÐÅÏ¢µÄÇ®£¡£¡£¡
  
ÎÒÏÈ´Ó×öÍø×¬µÄÌõ¼þËµÆð°É¡£Ê×ÏÈ£¬¿Í¹ÛÉÏÄãÒªÓÐ½Ï¶àµÄÉÏÍøÊ±¼ä£»µÚ¶þ£¬Äã×îºÃÓÐ×Ô¼ºµÄµçÄÔ²¢×°ÁË¿í´ø£¬µ±È»Ã»ÓÐÒ²ÊÇ¿ÉÒÔ×öµÄ£¬ÉÏ°àÓÐµçÄÔÉÏÍøÒ²ÐÐ£¨ÏñÎÒ£¬ºÇºÇ£©£»µÚÈý£¬ÓÐÒ»¶¨µÄÓ¢ÓïÔÄ¶ÁÄÜÁ¦£¬ÕâÑùÄã²ÅÄÜÃ÷°××Ô¼ºÔÚ×öÊ²Ã´£¬»áµÃµ½Ê²Ã´£¬ºÍÔõÑùµÃµ½£¬·ñÔòÄã¾ÍÖ»ÄÜ×öÒ»Ð©ÖÐÎÄ×¬Ç®ÍøÕ¾£¬Ä¿Ç°ÕâÑùµÄÍøÕ¾ÊýÄ¿´ó´óÉÙÓÚ¹úÍâµÄ£¬¶øÇÒ»Ø±¨ÓÐÏÞ,Äã×¬Ç®µÄÀ´Ô´¾Í´ó´óËõË®ÁË£»×öÃÀ¹úÍøÎÒÃÇºÍÃÀ¹úÈË»Ø±¨Ò»ÑùµÄ.µÚËÄ£¬ÓÐÒ»¸ö»ò¼¸¸öµç×ÓÓÊÏäÊÕÐÅ£¨163£¬yahooºÍhotmail¶¼»¹¿ÉÒÔ£¬µ«ÊÇÒª×¢ÒâÒ»Ð©ÍøÕ¾²»ÄÜÓÃ163×¢²á£¬Ò²ÓÐµÄ²»ÄÜÓÃhotmail£¬×¢²áÊÇÒªÌØ±ðµ±ÐÄÕâÒ»µã.yahoo½ÏºÃ.


 
ÎÒÑÐ¾¿ÁËÒ»ÏÂ£¬¹ã¸æ¹«Ë¾°Ñ¹ã¸æËÍµ½ÄãµÄ»ú×ÓÉÏÀ´ÈÃÄã¿´£¬Ö»Òªµã»÷È»ºó¸Ï¿ì¹Øµô¾Í¿ÉÒÔÁË»òÕßµã»÷ÄÇ¸öÐ¡ÈË¾Í±íÊ¾ÄãÔÚÔÄ¶Á¹ã¸æ£¬¾Í¿ÉÒÔ×¬Ç®,ÈÃËûÎóÈÏÎªÎÒÃÇÒ»Ö±ÔÚ¿´¹ã¸æ!
 
 ²¹ÌùÉÏÍø·ÑµÄºÃ·½·¨£¨ÍÂÑªÍÆ¼ö£¡£¡£©[½¨Òé] 
 Ç¿ÁÒÍÆ¼ö£¡Ö»ÒªÔÚÏß¾Í¼ÆÊý£¬1Ð¡Ê±0.6ÃÀÔ²£¡
 µã»÷Á¬½Óhttp://www.cashfiesta.com/php/join.php?ref=airspace
 ÓÐÐËÈ¤Ò»±ßÉÏÍøÒ»±ß×¬Ç®Âð£¿ 
 ÈçÓÐÐËÈ¤Çë»¨ÉÙÉÙÊ±¼ä¿´¿´ÕâÆªÎÄÕÂ£¬ÕâÖ»»á»¨·ÑÄãºÜÉÙÊ±¼ä¡£ 
 1Ð¡Ê±0.6ÃÀÔ²£¬ÔÚ¼ÒÀïÉÏÍø¿ÉÒÔ²¹ÌùÉÏÍø·ÑÓÃ£¡ 
 
 CashFiesta 
 
 ¹«Ë¾¼ò½é£º¸Ã¹«Ë¾ÊÇÃÀ¹ú¼ÓÀû¸£ÄáÑÇ²®¿ËÀûÊÐµÄÒ»¼ÒÐÂÐËµÄ´ÓÊÂ»¥ÁªÍø¹ã¸æÒµÎñµÄ¹«Ë¾£¬ÏÖ
 ÓëÊµÁ¦ÐÛºñµÄExploreTechnologies¼°Inc¹«Ë¾ºÏ²¢,·þÎñÃ»ÓÐÊ¹ÓÃÊ±¼äÏÞÖÆ£¬¹ú¼ÊÓÃ»§×îÐ¡¸¶
 ·Ñ½ð¶îÎª50ÃÀÔª£¬²»ÊÕÊÖÐø·Ñ£¬Ã¿ÔÂ10ºÅ½áËã¡£½áËãÊ±Ö»ÒªÄãµÄ½ð¶î´ïµ½50ÃÀÔª£¬¸Ã¹«Ë¾±ã»á
 ×Ô¶¯¼Ä·âµØÖ·È·ÈÏÐÅ¸øÄã£¬È·ÈÏºó¹«Ë¾±ã»á°ÑÖ§Æ±¼Ä³ö¡£ÐÅÓþ¾ø¶Ô¿É¿¿£¡ËüÎ»ÁÐÍøÉÏ¹ã¸æ¹«Ë¾
 µÄÈý¼×Ö®ÄÚ£¬ÖÁ½ñ»¹Ã»ÓÐÍøÓÑÍ¶Ëß¹ý£¡
 
 Ò»¡¢ ×î´óºÃ´¦£º 
 1. Ö»ÒªÔÚÏß¾Í¼ÆÊý£¬ÎÞÂÛÄúÔÚ×öÊ²Ã´¡£ 
 
2.×¢²áÒ»¸öÖ¸¶¨Õ¾µãµÃ1000µã¡£´Ë·½·¨¼ò½ÝÓÐÐ§£¬µ«´ó¶àÊýÅóÓÑÓÉÓÚ²»ÈÏÊ¶Ó¢ÎÄ¶ø´í¹ýÁËÕâ¸öºÃ»ú»á¡£µ±ÓÐSignUp×ÖÑùÊ±£¬²»ÒªÁßÏ§ÄÇ¼¸·ÖÖÓÊ±¼ä£¬¼òµ¥ÌîÒ»Ð©±íµ¥£¬Äú¾Í»á·¢ÏÖ×Ô¼ºµÄµãÊýÒ»ÏÂÉÏÕÇÁËÇ§Óàµã£¡
 3.Çë½«ÏÂÃæÉêÇëµØÖ·ÖÐµÄÓÃ»§Ãû»»³ÉÄú×Ô¼ºµÄ£¬²¢ÔÚ¸÷¸öBBSÉÏÕÅÌù£¬·¢Õ¹×Ô¼ºµÄÏÂÏß¡£
 ¶þ¡¢ÉêÇë·½·¨¼°¹ý³Ì£ºÉêÇëÊ±ÐÕÃû¡¢×¡Ö·¡¢ÓÊ±àµÈÒ»¶¨ÒªÕæÊµ£¬Çå³þ£¬·ñÔòÊÕ²»µ½Ö§Æ±ÁË¡£
 Èý¡¢ ×¢²á·½·¨ÈçÏÂ£º 
 µã»÷Á¬½Óhttp://www.cashfiesta.com/php/join.php?ref=airspace 
½øÈë×¢²áÒ³Ãæ¡£Èç¹û²»ÄÜÖ±½Óµã»÷£¬Çë½«Æä¸´ÖÆµ½ä¯ÀÀÆ÷µÄµØÖ·À¸½øÈë¡£Èç¹ûÄú²»ÄÜ·ÃÎÊ¹úÍâµÄÍøÕ¾£¨Ò²¾ÍÊÇ·ÃÎÊ²»ÁËÉÏÃæµÄÒ³Ãæ£©£¬ÔÚÕâÀïÎÒ¿ÉÒÔÍÆ¼öÒ»¸ö´úÀíÍøÖ·£¬Äã¿ÉÒÔÍ¨¹ýIEä¯ÀÀÆ÷ÖÐµÄ´úÀíÉè¶¨ÊµÏÖÄãÃâ·Ñ·ÃÎÊ£¬¾ßÌå²Ù×÷ÈçÏÂ£º
 1¡¢ ´ÓIEµÄÎÄ¼þÀ¸ÖÐÕÒµ½¹¤¾ß-InternetÑ¡Ïî-Á¬½Ó£» 
 
2¡¢Èç¹ûÄúÊÇ²»ÊÇ²¦ºÅÓÃ»§£¬Äã¿ÉÒÔÑ¡Ôñ´Ó²»½øÐÐ²¦ºÅÁ¬½Ó£¬²¢½øÈë¾ÖÓòÍøÉèÖÃÖÐÐÞ¸Ä´úÀí·þÎñÆ÷£¬ÔÚµØÖ·À¸ÖÐÐ´Èëproxy.smartdot.com.cn£¬¶Ë¿Ú£º5060£¬Ñ¡ÉÏ¶Ô±¾µØµØÖ·²»
Ê¹ÓÃ´úÀí£»
 
3¡¢ÔÙ½øÈë²Ù×÷À¸ÖÐµÄ¸ß¼¶£¬ÔÚÀýÍâÀ¸ÖÐµÄ¿Õ°×´¦Ð´ÉÏ*.cn;Èç¹ûÄÚ²¿ÍøÓÐ¿É·ÃÎÊµÄIPÒ²ÒªÐ´ÉÏÈç£º172.16.0.*£¬ÕâÑù¿ÉÒÔ¹ýÂË³ö±¾µØÍøÖ·²»ÓÃ´úÀí¾ÍÊµÏÖ·ÃÎÊ£»
 £¨ÖÐÎÄÎª×¢ÊÍ£¬ÇëÓÃÓ¢ÎÄ»òÆ´ÒôÌîÐ´£¡Äú¿É±ð°ÑÖÐÎÄÌîÉÏÓ´£© 
 
 Login£º£¨ÓÃ»§Ãû£© 
 password:£¨ÃÜÂë£© 
 Verify password:£¨ÖØ¸´ÃÜÂë£© 
 First name£º£¨ÓÃÀ´ÄÃÖ§Æ±µÄÉí·ÝÖ¤ÉÏµÄÐÕ,ÈçÐÕÍõÌîWang)
 Last name: £¨ÄãÉí·ÝÖ¤ÉÏµÄÃû×Ö,Èç³¤½¾ÍÌîchangjiang) 
 
StreetAddress:£¨ÄúµÄ×¡Ö·£¬¿ÉÒÔÓÃÆ´Òô£¬°´Íâ¹úÈËÏ°¹ß£¬´ÓÐ¡µ½´óÐ´Çå³þ£¬ÖÁÉÙÒªÖÐ¹úµÄÓÊµÝÔ±Ã÷°×£¬ÀýÈç£º¹ã¶«Ê¡¹ãÖÝÖÐÉ½Â·3ºÅ£¬No.3,ZhongShanRoad,Guangzhou,GuangDong£©
 City:£¨¾Ó×¡³ÇÊÐ,ÈçÉîÛÚÌîshenzhen£© 
 Zip/Postal Code:£¨ÓÊ±à£¬Ò»¶¨ÒªÐ´ÕýÈ·Å¶¡££© 
 State:£¨¾Ó×¡µÄÖÝ£¬ÖÐ¹úÑ¡[Not Selected]£© 
 Province£º£¨ÇëÌîÄú¾Ó×¡µÄÊ¡·Ý,Èç¹ã¶«ÌîGuangdong£© 
 Country:£¨¹ú¼®,Ñ¡China£© 
 E-Mail Address£º£¨ÄÜÊÕµ½ÐÅµÄÓÊÏä,yahoo,163½ÏºÃ£© 
 Verify E-Mail Address£º£¨Ð£ÑéÓÊÏä£¬ÔÙÌîÒ»±é£© 
 Age:£¨ÄêÁä£© 
 Gender:£¨ÐÔ±ð£¬MaleÄÐ£¬FemaleÅ®£© 
 Education£ºÊÜ½ÌÓý³Ì¶È 
 Annual household income£ºÐ½Ë® 
 Please tell us why you use Internet: (check all that apply) 
 ÄãÓÃInternet×öÊ²Ã´£¬Ëæ±ãÑ¡¾Í¿ÉÒÔÁË 
 What do you search for or buy online: (check all that apply) 
 ÄãÔÚÍøÉÏÕÒÊ²Ã´»òÕß¹ºÂòÊ²Ã´£¬Ëæ±ãÑ¡¾Í¿ÉÒÔ 
 Preferred check size:£¨Ñ¡Ôñ¶àÉÙÃÀÔªÆð¸¶¿î£© 
 ¿´ÄãÏ²»¶ÁË£¬Ò»°ãÑ¡$50 
 Referred by: airspace 
ÕâÊÇ±íÃ÷ÄúÎÒµÄ¹ØÏµ£¬µÈÄã×¢²áºó¾Í×Ô¶¯³ÉÎªÄú×Ô¼º£¨×¢Òâ×öÍø×¬±ØÐëµÃÓÐÉÏÏÂÏß¹ØÏµ£©£¡£¡
 I have read and understand the Member Agreement. 
 Í¬ÒâÐÒé£¬Ò»¶¨ÒªÑ¡ÉÏ 
 
ÌîÍêºó¼ì²éÒ»±é£¨³ýÁËNameºÍReferrerÍâ£¬ÆäËû¶¼¿ÉÒÔÒÔºóÐÞ¸Ä£©£¬°´Ò»ÏÂSubmitRegistration£¬¾Í½øÐÐ×¢²áÁË¡£
 
ÐÄ¶¯²»ÈçÐÐ¶¯£¬Á¢¼´È¥×¢²á°É£¡»òÐíÄÄÒ»ÌìºöÈ»ÔÝÍ£ÉêÇëÁËÒ²Î´¿ÉÖª¡£ÉêÇëºóÂíÉÏÄÜÊÕµ½×¢²áÐÅ£¬½Ó×Å¾Í¿ÉÏÂÔØ¹ã¸æÌõ¿ªÊ¼×¬Ç®ÁË£¡×¢²áÐÅ°üº¬ÄúµÄÓÃ»§Ãû¡¢ÃÜÂë¡¢¸ÃÐÅÎÞÐè»Ø¸´¡£ÏÂÔØ¹ã¸æÌõµÄ°²×°ÎÄ¼þ´óÔ¼500K¡£
 
 ËÄ£®Ê¹ÓÃ·½·¨£º 
 
1.ÏÂÔØ¹ã¸æÌõhttp://www.cashfiesta.com/download/Cashfiesta.exe;ÏÂÔØºóµã»÷Í¼±ê±ã»á×Ô¶¯°²×°£¬ÄãÉÏÍøºó¿É´ò¿ª¡£¾³£ÒªÏÂÔØºÜ³¤Ê±¼ä

Re: mysqldump ERROR 1064

2003-01-05 Thread Bruce MacDonald

- Original Message -
From: David  Angela Ehmer [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, January 04, 2003 11:00 PM
Subject: mysqldump ERROR 1064

 Hi

 I am having problems generating the mysqldump file.  I have tried a range
of
 options and carefully studied several tutorials I have on using this
 command.  Each time I get the following errror.

 ERROR 1064 you have an error in your SQL syntax near 'mysqldump -u root -p
 adrienne netno_db sql.dump' at line 1.

 I appear to have other problems with some commands. For example if I type;

 mysqladmin --help

 at the command line I get the 1064 ERROR

 Appreciate any suggestions about what may be the problem here

 David

It looks like you're trying to run the mysqldump and mysqladmin commands
from within the mysql client rather than from the shell's command line.

Quit out of the mysql client and try running them from the command line.

And when you specify the -p password on the command line, do not include a
space between the -p and the password.

Try instead: mysqldump -u root -padrienne netno_db sql.dump

Best regards,

Bruce

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: PHP and MySQL bug

2003-01-05 Thread Nuno Lopes

Here is the source code:

?
@MYSQL_CONNECT(localhost, nlopes, testing) or die(Erro 1);
@mysql_select_db(be);
$r=MYSQL_QUERY(SELECT n,u,m,h FROM d WHERE id='$id');
if (mysql_num_rows($r)==0) {
die (Erro);
} else {
$re=mysql_fetch_array($r, MYSQL_NUM);
$nome=$re[0];
$url=$re[1];
$mirrors=$re[2];
$h=$re[3];
$h++;
@MYSQL_QUERY(UPDATE d SET h='$h' WHERE id='$id'); // this query doesn't
work
echo h2Seleccione a localização para o download:/h2pa
href=\$url\Localização Principal/a/p;
if ($mirrors) {
echo pnbsp;/ph2Mirrors/h2p;
$m=explode(»,$mirrors);
foreach ($m as $v) {
$m2=explode(!,$v);
echo a href=\$m2[1]\$m2[0]/abr;
}
echo /ppNota: Deve escolher o mirror mais próximo da sua localização,
para acelerar o dowload. No caso de um mirror estar indisponível, utilize
outro./p;
}
}
@MYSQL_CLOSE();
?/body/html



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Full text search

2003-01-05 Thread Salam Baker Shanawa

Hi,


As of Version 4.0.1 you can use the truncation operator * in boolean mode:

select firstname from contacts where match(firstname,lastname) against
('steff*' in boolean mode);

This will match steff , steffa, steffan, steffane, steffans 
But of course not stef unless you use 'stef*' .

Regards
Salam

Steffan A. Cline wrote:

Am I missing something on mysql full text search?


I was using a simple statement like
select firstname from contacts where match(firstname,lastname) against
('steffa');

I am actually looking for steffan but wanted to see what it would return.
Now, if I search for the full name steffan it finds it ok. Is there
something I am missing for it to return any matches containing steff or
steffa or even stef 


Thanks

Steffan

---
T E L  6 0 2 . 5 7 9 . 4 2 3 0 | F A X  6 0 2 . 9 7 1 . 1 6 9 4
Steffan A. Cline
[EMAIL PROTECTED] Phoenix, Az
http://www.ExecuChoice.net  USA
AIM : SteffanC  ICQ : 57234309
The Executive's Choice in Lasso driven Internet Applications
---



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php







-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

InnoDB vs. MySQL performance Issue

2003-01-05 Thread Sameh Attia

Hi,
   I have a system running MySQL 3.23.41. I read many times about 
InnoDB performance and that it is superior to the MyISAM one. I have a 
table 'sessions' in a MyISAM format with about 20 milion records. Its 
size is 2.5 GB; the index file is 1.1 GB. In mysql client I entered the 
following command 'alter table sessions type=innodb' while these 
settings were in my.cnf
innodb_data_home_dir=/path/to/the/database/dir
innodb_data_file_path=backup/ibdata:3072M:autoextend
set-variable = innodb_buffer_pool_size=128M
set-variable = innodb_additional_mem_pool_size=64M
set-variable = innodb_log_file_size=32M
set-variable = innodb_log_buffer_size=16M

The command took about 10 hours to complete. Is this normal?
Also when it finished I issued the follwoing statement on another copy 
of the table in MyISAM format; it took about 5 mins
SELECT ip,no,count(*) AS term,SUM(CEILING(session_time/60)*60) AS 
total,AVG(CEILING(session_time/60)*60) AS average FROM sessions GROUP BY ip;

while when it was issued on the InnoDB one it took me 30 mins to give up 
and shutdown the server with no luck.
Whats wrong? could anyone help? Im sure that InnoDB is good so it seems 
I missed something could anyone point me?
Regards

--
Sameh Attia
Senior System Engineer
T.E. Data
--
  __  __  _
  _ _/ /_/ /_(_)___ _
 / ___/ __ `/ __/ __/ / __ `/
(__  ) /_/ / /_/ /_/ / /_/ /
//\__,_/\__/\__/_/\__,_/

She who is in my mind and mouth, I love her with all my heart and blood
We'll restore OUR Palestine



-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

mod_perl and mySql

2003-01-05 Thread Chris Faust

Hello Group,

Due to ever increasing traffic I'm converting my site into mod_perl and
quite honestly I'm confused about persistent DB connection and DB connection
pooling.. I know there is tons of info out there on the goggle groups and on
perl.apache.com, I also picked up Mod_Perl Developers cookbook and I also
have the awesome Mysql and MySql and Perl for the web. (BTW so far the
little mod_perl section in MySql and Perl for the web has proven more
useful then anything I've found in the whole Mod_Perl dev cookbook).

I've seen so many example and different ways to do it, that I have no idea
if I'm doing things the safest and most optimized way. For example I've read
a bunch of posts where people said to do pooling its only a matter of doing
your connect like $db || DBI-CONNECT, which just gives me a syntax error.
I also hear in one place that Apache::DBI takes care of making sure the
connection stays alive but then I hear in another that is something that I
will need to take care of.

Below is how I've set things up, hopefully someone out there that really
knows can tell me if I'm doing something wrong or if it could be done
better!!
Right now as it stands everything is running perfect under mod_perl, again
I'm just not sure  I'm doing everything the correct way.

Thanks in Advance!
-Chris

***
Relevant httpd.conf:

PerlRequire /home/httpd/perl/startup.pl
PerlModule Apache::DBI
Location /perl
SetHandler perl-script
PerlHandler Apache::Registry
Options ExecCGI
allow from all
PerlSendHeader On
/Location


Startup.pl

use strict;
use lib qw(/websites/perl/modules);
use DBI ();
use DBD::mysql ();
use CGI ();
use CGI::Cookie ();
CGI-compile (':all');
use Data::Pageset ();
use HTML::Template ();
use Mail::Sendmail ();
use File::Find ();

# Cache all of our HTML::Templates
my @tmpl_dir = qw(/websites/html/templates/);
print STDERR Pre-loading HTML Templates...\n;
  File::Find::find (
   sub {
   return unless /\.tmpl$/;
   HTML::Template-new(
  filename = $File::Find::dir/$_,
  cache = 1,
  );
   },
@tmpl_dir
   );
1;


***
Database Connection Package:
(This .pm file lives in the use lib dir from above and is what I use in
all my
scripts to make a connection to the DB).

package connect_db;
require Exporter;

our @ISA = qw(Exporter);
our @EXPORT = qw(connect_to_db $db);
our $VERSION = 1.00;

#
sub connect_to_db {

# DBI-trace(3, /websites/web_files/display.log);
my $dbpassfile = '/websites/web_files/dbroot.pass';
my ($db_username,$db_password,$db_location,$db_name,$db);
open (DBPASSFILE, $dbpassfile) or die Couldn't open $dbpassfile: $!\n;
while (DBPASSFILE) {
 ($db_username,$db_password,$db_location,$db_name) = split;
 }
my $database = DBI:mysql:database=$db_name:host=$db_location;
$db = DBI-connect($database,$db_username,$db_password) or die Cannot
Connect:  . $db-errstr();
close DBPASSFILE;
return $db;
}
1;


***

In My Scripts:
I should point out that I do no forking or anything of that nature, for
example before mod_perl the DB connect package was just something that was
in MAIN in all my scripts, all subs and everything made use of that single
connection ($db) for all DB connections.

My mod_perl scripts go something like this:

use connect_db qw(connect_to_db $db);
use vars qw($CGI $db);

##
# Main
#
# Setup a working environment
init_global_vals();
display_page()
#done

#
sub init_global_vals {

# Global Vars
$CGI = new CGI();
$db = connect_db-connect_to_db;

.
} # end of sub
##




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

. cn

2003-01-05 Thread mike

mysqlÄúºÃ:
È«¹ú¶À¼ÒÃâ·ÑÇÀ×¢. cn¶¥¼¶ÓòÃû £¡
±¶ÊÜ¹Ø×¢µÄÖÐ¹ú¹ú¼Ò¶¥¼¶ÓòÃû(.CN), CNNIC½«ÔÚ2003Äê3ÔÂ17ÈÕ¿ª·ÅÖ±½ÓÒÔ.CN½áÎ²µÄ¹úÄÚÓòÃû
Äþ²¨Íø»ùÈí¼þÓÐÏÞ¹«Ë¾ÏÖÔÚÍÆ³öÈ«¹ú¶À¼ÒÃâ·ÑÇÀ×¢»î¶¯,¸Ï¿ìÇÀ×¢ÄãÐÄÒÇÒÑ¾ÃµÄÓòÃû. 

.CN¶¥¼¶ÓòÃûµÄÕýÊ½×¢²á¼Û¸ñÎª260Ôª/¸öÃ¿Äê¡£


  Äþ²¨Íø»ùÈí¼þÓÐÏÞ¹«Ë¾
  http://www.xushiqi.com/
  Email:  [EMAIL PROTECTED]
  [EMAIL PROTECTED]
  0574-87707034
  0574-63133687

ÇëÄúÌîºÃÒÔÏÂÐÅÏ¢:

ÓòÃûÃû³Æ£º.cn  *  
×¢²áÄêÊý£º  *  
ÓòÃûËùÓÐÕß((ÖÐÎÄ)£º  * 
ÓòÃûËùÓÐÕß((Ó¢ÎÄ)£º  * 
ÁªÏµÈË(ÖÐÎÄ)£º  * 
Ê¡·Ý(ÖÐÎÄ)£º   
³ÇÊÐ(ÖÐÎÄ)£º  * 
Í¨ÐÅµØÖ·(ÖÐÎÄ)£º  *  
Í¨ÐÅµØÖ·(Ó¢ÎÄ)£º   
µç»°£º  * £¨Çë¼ÓÇøºÅ£¡£©  
´«Õæ£º  * £¨Çë¼ÓÇøºÅ£¡£©  
ÓÊÕþ±àÂë£º  * 
µç×ÓÐÅÏä£º  * 

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

problem with drop table

2003-01-05 Thread Francesco

Hello,
I tried to drop a table with Mysql 4.0.1 alpha nt and I have encountered 
the following problem:
ERROR : Error on delete of .'\camcomm.tmpge.MYI'
The problem persists. I don't know the reason of this error.
I ask if a new version of Mysql (the version 4.0.7 i s released) is better.


-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

LOCK problem with SELECT table alias

2003-01-05 Thread ck

Description:
A SELECT statement fails if you have table aliases and use
table locking with the LOCK command
How-To-Repeat:
DROP TABLE IF EXISTS CK1;
CREATE TABLE CK1 (
  ID INT UNSIGNED NOT NULL,
  PRIMARY KEY(ID)
);
LOCK TABLES CK1 READ; # you must have locking privileges
SELECT * FROM CK1; # works
SELECT * FROM CK1 AS SOME_ALIAS; # fails, error 1100: Table 'SOME_ALIAS' was 
not locked with LOCK TABLES
UNLOCK TABLES;
Fix:
Do not check for aliases, but for table names.

Submitter-Id:  submitter ID
Originator:Christian Kohlschuetter
Organization:  NewsClub.de
 
MySQL support: none
Synopsis:  Locking problem with SELECT-aliases
Severity:  serious
Priority:  high
Category:  mysql
Class: sw-bug
Release:   mysql-4.0.7-gamma (Official MySQL RPM)
Server: /usr//bin/mysqladmin  Ver 8.38 Distrib 4.0.7-gamma, for pc-linux on i686
Copyright (C) 2000 MySQL AB  MySQL Finland AB  TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version  4.0.7-gamma-Max
Protocol version10
Connection  Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 1 hour 1 min 51 sec

Threads: 2  Questions: 1870  Slow queries: 0  Opens: 93  Flush tables: 1  Open tables: 
7  Queries per second avg: 0.504
C compiler:2.95.3
C++ compiler:  2.95.3
Environment:

System: Linux x1.localnet 2.4.19-16mdk #1 Fri Sep 20 18:15:05 CEST 2002 i686 unknown 
unknown GNU/Linux
Architecture: i686

Some paths:  /usr//bin/perl /usr//bin/make /usr//bin/gmake /usr//bin/gcc /usr//bin/cc
GCC: Reading specs from /usr//bin/../lib/gcc-lib/i586-mandrake-linux-gnu/3.2.1/specs
Configured with: ../configure --prefix=/usr --libdir=/usr/lib --with-slibdir=/lib 
--mandir=/usr/share/man --infodir=/usr/share/info --enable-shared 
--enable-threads=posix --disable-checking --enable-long-long --enable-__cxa_atexit 
--enable-languages=c,c++,ada,f77,objc,java --host=i586-mandrake-linux-gnu 
--with-system-zlib
Thread model: posix
gcc version 3.2.1 (Mandrake Linux 9.1 3.2.1-2mdk)
Compilation info: CC='gcc'  CFLAGS='-O6 -fno-omit-frame-pointer -mpentium'  CXX='gcc'  
CXXFLAGS='-O6 -fno-omit-frame-pointer  -felide-constructors 
-fno-exceptions -fno-rtti -mpentium'  LDFLAGS=''  ASFLAGS=''
LIBC: 
lrwxrwxrwx1 root root   13 Jan  1 13:43 /lib/libc.so.6 - libc-2.3.1.so
-rwxr-xr-x1 root root  1224712 Dez 24 10:57 /lib/libc-2.3.1.so
-rw-r--r--1 root root  204 Dez 24 10:45 /usr/lib/libc.so
Configure command: ./configure '--disable-shared' '--with-mysqld-ldflags=-all-static' 
'--with-client-ldflags=-all-static' '--without-berkeley-db' '--with-innodb' 
'--without-vio' '--without-openssl' '--enable-assembler' '--enable-local-infile' 
'--with-mysqld-user=mysql' '--with-unix-socket-path=/var/lib/mysql/mysql.sock' 
'--prefix=/' '--with-extra-charsets=complex' '--exec-prefix=/usr' 
'--libexecdir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share' 
'--localstatedir=/var/lib/mysql' '--infodir=/usr/share/info' 
'--includedir=/usr/include' '--mandir=/usr/share/man' '--with-embedded-server' 
'--enable-thread-safe-client' '--with-comment=Official MySQL RPM' 'CC=gcc' 'CFLAGS=-O6 
-fno-omit-frame-pointer -mpentium' 'CXXFLAGS=-O6 -fno-omit-frame-pointer   
-felide-constructors -fno-exceptions -fno-rtti -mpentium' 'CXX=gcc'


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

MySQL 4.0.7-gamma: Bugs affecting the privilege system

2003-01-05 Thread Alexander M. Turek

Hi MySQL team,


I'm not sure, if this is the right place for bug reports, so, if it
isn't, please forward this to those who are resposible. Running MySQL
4.0.7 on a Windows NT 5.2 RC2 machine and on a Windows NT 5.1 one as
well, I encoutered some bugs:


- After having set up both machines completely, I installed the Win32
binary distribution of MySQL 4.0.7-gamma. Although I did not upgrade
from an earlier version, the privileges tables still have the old
structure without the new columns introduced with MySQL 4.0.2-beta!
Furthermore, the script menioned in the documentation
(mysql_fix_privilege_tables) is obiously not included in the
distribution. Because of this, there is no way to use the new privilege
system but fixing the tables manually...


- If I create a user by

GRANT USAGE ON *.* TO 'foo'@'foohost';

and try to get the GRANT query by

SHOW GRANTS FOR 'foo'@'foohost';

afterwards, MySQL returns an empty result set.
If I add a query like

SET PASSWORD FOR 'foo'@'foohost' = PASSWORD('foobar');

and try the SHOW GRANTS query menitioned above again, MySQL correctly
returns:

+---
--+
| Grants for foo@foohost
|
+---
--+
| GRANT USAGE ON *.* TO 'foo'@'foohost' IDENTIFIED BY PASSWORD
'4655c05b05f11fab' |
+---
--+


- If I create a user by

GRANT USAGE ON `footable`.* TO 'foo'@'foohost' IDENTIFIED BY 'foobar'
WITH GRANT OPTION;

and try to get the GRANT query again, MySQL returns this:

+---
--+
| Grants for foo@foohost
|
+---
--+
| GRANT USAGE ON *.* TO 'foo'@'foohost' IDENTIFIED BY PASSWORD
'4655c05b05f11fab' |
| GRANT  ON `footable`.* TO 'foo'@'foohost' WITH GRANT OPTION
|
+---
--+

While the first query is completly correct, the second one would result
in an error...


Happy fixing,

Alexander M. Turek
[EMAIL PROTECTED]




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re:PHP and MySQL bug

2003-01-05 Thread Larry Brown

Try replacing the following line...

@MYSQL_QUERY(UPDATE d SET h='$h' WHERE id='$id'); // this query doesn't
work

With...

$query = UPDATE d SET h='$h' WERE id='$id';
$queryr = mysql_query($query) or die(The sql statement does not execute);

if(mysql_affected_rows() !== 1)
{
   die(The sql statement is successfully run however either h did not
change or there is an internal error.  Try executing the sql from the
command line to make sure it otherwise works.);
}

and see which is coming back.


Larry S. Brown
Dimension Networks, Inc.
(727) 723-8388




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Multiple SQL files

2003-01-05 Thread Frank Peavy

I have multiple SQL files that create different tables.
Is there a way for me to create a single SQL file that will call these 
other files?

Since I am using phpMyAdmin, I am assuming that call this file from 
phpMyAdmin?!



-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: mod_perl and mySql

2003-01-05 Thread Michael Bacarella

Are you sure it would help? MySQL is damn fast at taking connections.

When we converted to mod_perl I made a mental note to switch
to persistent connections.  It turns out that it still
ran fast enough even though every hit results in an RDBMS
connection. And at this point we're doing 5M of them per day.

It has never been a bottleneck for us.

-M

 Due to ever increasing traffic I'm converting my site into mod_perl and
 quite honestly I'm confused about persistent DB connection and DB connection
 pooling.. I know there is tons of info out there on the goggle groups and on
 perl.apache.com, I also picked up Mod_Perl Developers cookbook and I also
 have the awesome Mysql and MySql and Perl for the web. (BTW so far the
 little mod_perl section in MySql and Perl for the web has proven more
 useful then anything I've found in the whole Mod_Perl dev cookbook).

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: mod_perl and mySql

2003-01-05 Thread Mark

- Original Message -
From: Chris Faust [EMAIL PROTECTED]
To: MySql Mailing List [EMAIL PROTECTED]
Sent: Sunday, January 05, 2003 1:55 PM
Subject: mod_perl and mySql

 For example I've read
 a bunch of posts where people said to do pooling its only a matter of
 doing your connect like $db || DBI-CONNECT, which just gives me
 a syntax error.

That looks odd. Perhaps you meant:

$db ||= DBI-connect ( ... ?

That will connect if $db is no longer defined (or when $db eq ): in other
words, when you lost the connection.

Sorry, that is all the usefulness I have to contribute, if at all. :)

- Mark

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: mod_perl and mySql

2003-01-05 Thread Chris Faust

You mean overall? The move to mod_perl is more because the site is so perl
heavy, its perl that is driving the change more then anything else.

I just figure If I'm going to do it, I want to do as much of it as I can
:)..

Thanks
-Chris


 -Original Message-
 From: Michael Bacarella [mailto:[EMAIL PROTECTED]]
 Sent: Sunday, January 05, 2003 11:40 AM
 To: Chris Faust
 Cc: MySql Mailing List
 Subject: Re: mod_perl and mySql


 Are you sure it would help? MySQL is damn fast at taking connections.

 When we converted to mod_perl I made a mental note to switch
 to persistent connections.  It turns out that it still
 ran fast enough even though every hit results in an RDBMS
 connection. And at this point we're doing 5M of them per day.

 It has never been a bottleneck for us.

 -M

  Due to ever increasing traffic I'm converting my site into mod_perl and
  quite honestly I'm confused about persistent DB connection and
 DB connection
  pooling.. I know there is tons of info out there on the goggle
 groups and on
  perl.apache.com, I also picked up Mod_Perl Developers
 cookbook and I also
  have the awesome Mysql and MySql and Perl for the web.
 (BTW so far the
  little mod_perl section in MySql and Perl for the web has proven more
  useful then anything I've found in the whole Mod_Perl dev cookbook).



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: mod_perl and mySql

2003-01-05 Thread Haapanen, Tom

We don't cache connections, either, and the connection overhead appears to
be trivial, connecting to a remote MySQL server over the local Ethernet.

50,000 to 100,000 Apache::ASP pages served per day, some with many rather
complex queries.

Tom Haapanen
[EMAIL PROTECTED]

-Original Message-
From: Michael Bacarella [mailto:[EMAIL PROTECTED]]
Sent: Sunday, 05 January, 2003 11:40
To: Chris Faust
Cc: MySql Mailing List
Subject: Re: mod_perl and mySql


Are you sure it would help? MySQL is damn fast at taking connections.

When we converted to mod_perl I made a mental note to switch
to persistent connections.  It turns out that it still
ran fast enough even though every hit results in an RDBMS
connection. And at this point we're doing 5M of them per day.

It has never been a bottleneck for us.

-M

 Due to ever increasing traffic I'm converting my site into mod_perl and
 quite honestly I'm confused about persistent DB connection and DB
connection
 pooling.. I know there is tons of info out there on the goggle groups and
on
 perl.apache.com, I also picked up Mod_Perl Developers cookbook and I
also
 have the awesome Mysql and MySql and Perl for the web. (BTW so far the
 little mod_perl section in MySql and Perl for the web has proven more
 useful then anything I've found in the whole Mod_Perl dev cookbook).

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: mod_perl and mySql

2003-01-05 Thread Paul DuBois

At 7:55 -0500 1/5/03, Chris Faust wrote:

Hello Group,

Due to ever increasing traffic I'm converting my site into mod_perl and
quite honestly I'm confused about persistent DB connection and DB connection
pooling.. I know there is tons of info out there on the goggle groups and on
perl.apache.com, I also picked up Mod_Perl Developers cookbook and I also
have the awesome Mysql and MySql and Perl for the web. (BTW so far the
little mod_perl section in MySql and Perl for the web has proven more
useful then anything I've found in the whole Mod_Perl dev cookbook).


Glad to hear that about MPW; thanks.  Gee, maybe I should quote your
paragraph on the book's companion web site! :-)

Regarding use of persistent connections, I wonder if you really need
them. To give an example from another language, PHP offers mysql_connect()
and mysql_pconnect() connections, which set up regular or persistent
connections.  But it turns out that the difference in overhead between
the two call is minimal because MySQL's client/server protocol is so
efficient for connection establishment.

Also, persistent connections can have certain negative effects.  For one
thing, because a connection remains open for a longer time, even when no
script is actively using it, you can more easily end up bumping up against
your server's max-simultaneous-connection limit.  With non-persistent
connections, this is less of an issue.



I've seen so many example and different ways to do it, that I have no idea
if I'm doing things the safest and most optimized way. For example I've read
a bunch of posts where people said to do pooling its only a matter of doing
your connect like $db || DBI-CONNECT, which just gives me a syntax error.
I also hear in one place that Apache::DBI takes care of making sure the
connection stays alive but then I hear in another that is something that I
will need to take care of.

Below is how I've set things up, hopefully someone out there that really
knows can tell me if I'm doing something wrong or if it could be done
better!!
Right now as it stands everything is running perfect under mod_perl, again
I'm just not sure  I'm doing everything the correct way.

Thanks in Advance!
-Chris



-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Re: LOCK problem with SELECT table alias

2003-01-05 Thread Paul DuBois

At 14:45 +0100 1/5/03, [EMAIL PROTECTED] wrote:

  Description:
	A SELECT statement fails if you have table aliases and use
	table locking with the LOCK command


This is not a bug.  It's documented in the manual that you must lock
all the tables at once that you intend to use, *including* locking
any aliases for those tables that you'll use.


  How-To-Repeat:
	DROP TABLE IF EXISTS CK1;
 CREATE TABLE CK1 (
   ID INT UNSIGNED NOT NULL,
   PRIMARY KEY(ID)
 );
 LOCK TABLES CK1 READ; # you must have locking privileges
 SELECT * FROM CK1; # works
 SELECT * FROM CK1 AS SOME_ALIAS; # fails, error 1100: Table
'SOME_ALIAS' was not locked with LOCK TABLES
 UNLOCK TABLES;

Fix:

	Do not check for aliases, but for table names.


sql, query

-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: user's updates trace

2003-01-05 Thread Frank Peavy

Natale,
It looks like you are looking for some kind of audit trail..
It would show all the changes to the table data, right?

Sorry, I don't have an answer, but I am looking for some thing similar.
If I find something that falls into this category, I will try to post.

What I have seen in some companies using other databases is, they trap all 
the transactions in a single table but you need to build it in

Need to keep looking there must be a better answer.


At 02:54 PM 1/3/03 +0100, Natale Babbo wrote:
#  S.O.S.  #

hi all,

anyone knows how to get the history of updates of a
user?
... i mean ... in my database i have a lot of users
with different privileges.
what i need is to reach all the insert, update and
delete queries executed by one user.
is it possible?

i check the bin logs but they seems not to trace the
user that execute the query. is it true?

thanks in advance.
natale babbo

P.S.: plase help me ... any tips are appreciated!!

__
Yahoo! Cellulari: scarica i loghi e le suonerie per le tue feste!
http://it.yahoo.com/mail_it/foot/?http://it.mobile.yahoo.com/index2002.html

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: LOCK problem with SELECT table alias

2003-01-05 Thread Christian Kohlschuetter

Am Sonntag, 5. Januar 2003 19:29 schrieb Paul DuBois:
 At 14:45 +0100 1/5/03, [EMAIL PROTECTED] wrote:
Description:
 
  A SELECT statement fails if you have table aliases and use
  table locking with the LOCK command

 This is not a bug.  It's documented in the manual that you must lock
 all the tables at once that you intend to use, *including* locking
 any aliases for those tables that you'll use.

Right, I also just found that paragraph in the LOCK TABLES documentation...
Though, I do not see a reason for this :-)

As you cannot have nested LOCK TABLES commands, one table statement does 
suffice for locking the table. Of course, mysql should not throw an error if 
you lock tables with and without aliases, but if the table is already locked 
without alias, there should not be a need to lock the table explicitly with 
the alias.

So this might be a feature request.
-- 
Christian Kohlschütter
[EMAIL PROTECTED]

http://www.newsclub.de - Der Meta-Nachrichten-Dienst


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Multiple SQL files

2003-01-05 Thread Frank Peavy

I have multiple SQL files that create different tables.
Is there a way for me to create a single SQL file that will call these 
other files?

Since I am using phpMyAdmin, I am assuming that call this file from 
phpMyAdmin?!


-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Multiple SQL files

2003-01-05 Thread wcb

Hi!

I have php files and perl files that create multiple databases and move data
around as needed. . .  is this what you mean?  You could have many such
files if you wanted (as you mention below) but it would seem easier to set
up some sort of program flow so that under different conditions different
databases could be created or dropped or whatever automatically. . .  If
this is what you mean, then yes, it is being done even as we speak!  I could
send you one of my inept examples if you want.

I believe that phpMyAdmin will allow you to enter SQL commands (say, by
copying them from a file and pasting into the SQL code window).  Unless you
modified phpMyAdmin (which ought to be pretty easy) I think that you'd have
to set up an external file to create multiple databases and do your
bidding with the data. . .

Cheers!

-warren

Filter: mysql, query, queries, bigint

- Original Message -
From: Frank Peavy [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Sunday, January 05, 2003 11:39 AM
Subject: Multiple SQL files


 I have multiple SQL files that create different tables.
 Is there a way for me to create a single SQL file that will call these
 other files?

 Since I am using phpMyAdmin, I am assuming that call this file from
 phpMyAdmin?!


 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Second thought

2003-01-05 Thread wcb

Hi!

A second thought is you could issue an SQL command from phpMyAdmin's command
window such as Load Data or Load Data Infile (if you have the privs to do
so).

Cheers!

-warren


- Original Message -
From: Frank Peavy [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Sunday, January 05, 2003 11:39 AM
Subject: Multiple SQL files


 I have multiple SQL files that create different tables.
 Is there a way for me to create a single SQL file that will call these
 other files?

 Since I am using phpMyAdmin, I am assuming that call this file from
 phpMyAdmin?!


 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Multiple SQL files

2003-01-05 Thread Frank Peavy

Warren,
Thank you for your prompt reply.

Actually, I have various ??.sql files that I can execute thru phpMyAdmin 
and they all work, but on occasion, there is a need to run all the files at 
once. So, I was wondering if I could create a file the would call these 
other files and execute them in sequence, i.e.

Aggregate_file.sql
  call first.sql
  call second.sql
  call third.sql
  etc.

If you have an example of something like this, it would be nice to see.
Thanks.


At 11:48 AM 1/5/03 -0800, wcb wrote:
Hi!

I have php files and perl files that create multiple databases and move data
around as needed. . .  is this what you mean?  You could have many such
files if you wanted (as you mention below) but it would seem easier to set
up some sort of program flow so that under different conditions different
databases could be created or dropped or whatever automatically. . .  If
this is what you mean, then yes, it is being done even as we speak!  I could
send you one of my inept examples if you want.

I believe that phpMyAdmin will allow you to enter SQL commands (say, by
copying them from a file and pasting into the SQL code window).  Unless you
modified phpMyAdmin (which ought to be pretty easy) I think that you'd have
to set up an external file to create multiple databases and do your
bidding with the data. . .

Cheers!

-warren

Filter: mysql, query, queries, bigint

- Original Message -
From: Frank Peavy [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Sunday, January 05, 2003 11:39 AM
Subject: Multiple SQL files


 I have multiple SQL files that create different tables.
 Is there a way for me to create a single SQL file that will call these
 other files?

 Since I am using phpMyAdmin, I am assuming that call this file from
 phpMyAdmin?!


 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: problem with drop table

2003-01-05 Thread Stefan Hinz, iConnect \(Berlin\)

Francesco,

 ERROR : Error on delete of .'\camcomm.tmpge.MYI'
 The problem persists. I don't know the reason of this error.
 I ask if a new version of Mysql (the version 4.0.7 i s released) is
better.

Most probably. I had problems like that with 4.0.3 and 4.0.4, but not
yet with 4.0.7 (all under Win2K).

Regards,
--
  Stefan Hinz [EMAIL PROTECTED]
  Geschäftsführer / CEO iConnect GmbH http://iConnect.de
  Heesestr. 6, 12169 Berlin (Germany)
  Tel: +49 30 7970948-0  Fax: +49 30 7970948-3

- Original Message -
From: Francesco [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Sunday, January 05, 2003 3:10 PM
Subject: problem with drop table


 Hello,
 I tried to drop a table with Mysql 4.0.1 alpha nt and I have
encountered
 the following problem:
 ERROR : Error on delete of .'\camcomm.tmpge.MYI'
 The problem persists. I don't know the reason of this error.
 I ask if a new version of Mysql (the version 4.0.7 i s released) is
better.


 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: MySQL Help Needed Please

2003-01-05 Thread Stefan Hinz, iConnect \(Berlin\)

Anton,

 # Starting mysqld daemon with databases from /usr/local/var
 030104 23:01:55  mysqld ended

This symptom shows when the privilege tables (i.e. the mysql database)
has not been installed. Under Unix/Linux, there's a script for this. You
can find details here:

http://www.mysql.com/doc/en/Post-installation.html

Regards,
--
  Stefan Hinz [EMAIL PROTECTED]
  Geschäftsführer / CEO iConnect GmbH http://iConnect.de
  Heesestr. 6, 12169 Berlin (Germany)
  Tel: +49 30 7970948-0  Fax: +49 30 7970948-3

- Original Message -
From: Anton Zavrin [EMAIL PROTECTED]
To: 'Stefan Hinz, iConnect (Berlin)' [EMAIL PROTECTED]; 'Thomas
Spahni' [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Sunday, January 05, 2003 8:08 AM
Subject: RE: MySQL Help Needed Please


Well, I read, played around and updated it (I guess)
Now, when I try to start mysql with this command (same as before), it
gives me that:
# /usr/local/bin/safe_mysqld --user=mysql 
[1] 71491
# Starting mysqld daemon with databases from /usr/local/var
030104 23:01:55  mysqld ended


[1]Done  /usr/local/bin/safe_mysqld
--user=mysql

How do I re-point mysql to look for my old database, I guess that's the
problem right?

Thank you Stefan

Best Regards, Anton


-Original Message-
From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]]
Sent: Saturday, January 04, 2003 2:14 PM
To: Anton Zavrin; 'Thomas Spahni'
Cc: [EMAIL PROTECTED]
Subject: Re: MySQL Help Needed Please

Anton,

ps -ef | grep mysqld
got nothing

Because the MySQL SERVER isn't running!

Though I can do:
# mysql -u root -p

With this command, you start the MySQL Monitor (that's the SQL command
line CLIENT tool that comes along with MySQL) and tell it to connect to
a MySQL SERVER running on localhost, as user root and willing to enter a
password.

Enter password:
ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (61)

Can't connect - this means the CLIENT tool cannot connect because there
is no server running!

Start the server using the mysql_safe script (more info here:
http://www.mysql.com/doc/en/safe_mysqld.html).

For a test, you can simply start the server like this:

# mysqld 

AFTER THAT you connect to the SERVER using the CLIENT tool mysql.

Hope this gets you running,
--
  Stefan Hinz [EMAIL PROTECTED]
  Geschäftsführer / CEO iConnect GmbH http://iConnect.de
  Heesestr. 6, 12169 Berlin (Germany)
  Tel: +49 30 7970948-0  Fax: +49 30 7970948-3

- Original Message -
From: Anton Zavrin [EMAIL PROTECTED]
To: 'Stefan Hinz, iConnect (Berlin)' [EMAIL PROTECTED]; 'Thomas
Spahni' [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Saturday, January 04, 2003 9:59 PM
Subject: RE: MySQL Help Needed Please


Did:
ps -ef | grep mysqld

got nothing
Though I can do:
# mysql -u root -p
Enter password:
ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (61)
#

Anything else I should try :( ?

Best Regards, Anton


-Original Message-
From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]]
Sent: Saturday, January 04, 2003 8:01 AM
To: Anton Zavrin; 'Thomas Spahni'
Cc: [EMAIL PROTECTED]
Subject: Re: MySQL Help Needed Please

Anton,

first thing, try:

ps [whatever options] | grep mysqld

The daemon (database server) is called mysqld, not mysql.

Regards,
--
  Stefan Hinz [EMAIL PROTECTED]
  Geschäftsführer / CEO iConnect GmbH http://iConnect.de
  Heesestr. 6, 12169 Berlin (Germany)
  Tel: +49 30 7970948-0  Fax: +49 30 7970948-3

- Original Message -
From: Anton Zavrin [EMAIL PROTECTED]
To: 'Thomas Spahni' [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Saturday, January 04, 2003 9:01 AM
Subject: RE: MySQL Help Needed Please


 I have this file:
 srwxrwxrwx  1 mysql  wheel0 Jan  2 16:45 mysql.sock

 I have two of .err files and non of the log files

 I also can't find my *.cnf file(s)

 Did: ps -ef | grep mysql
 Got nothing

 What should I do?

 Best Regards, Anton


 -Original Message-
 From: Thomas Spahni [mailto:[EMAIL PROTECTED]]
 Sent: Friday, January 03, 2003 7:01 AM
 To: Anton Zavrin
 Cc: [EMAIL PROTECTED]
 Subject: Re: MySQL Help Needed Please

 Anton,

 check the hostname.err and hostname.log files in your data
 directory.
 Then check permissions. My sock file looks like:

 srwxrwxrwx1 mysqldaemon  0 Dez 30 19:12 mysql.sock

 and finally check for your

 socket= /tmp/mysql.sock

 entries in /etc/my.cnf and ~/.my.cnf

 Thomas Spahni

 On Fri, 3 Jan 2003, Anton Zavrin wrote:

  Hi guys,
  I'm new here and need help.
  I'm installing MySQL on FreeBSD 4.7. I actually had/have MySQL
 installed
  but when I'm trying to run it says:
  error: 'Can't connect to local MySQL server through socket
  '/tmp/mysql.sock' (61)' Check that mysqld is running and that the
  socket: '/tmp/mysql.sock' exists!
 
  I checked /tmp/mysql.sock' and the file exists.
  But I don't see any process that would show me mysqld is running.
 
  Then I tried to

Re: Multiple SQL files

2003-01-05 Thread wcb

Hi!

Sorry Frank, I don't have an example of this. . .  however you might try
http://phpmyadmin.sourceforge.net/documentation/ and click on developers
where there are email addresses for the developers.  You may find someone
who will have nice suggestions that will advance your project!

Cheers!

-warren

filter: queries, mysql, bigint


- Original Message -
From: Frank Peavy [EMAIL PROTECTED]
To: wcb [EMAIL PROTECTED]; MySQL [EMAIL PROTECTED]
Sent: Sunday, January 05, 2003 12:00 PM
Subject: Re: Multiple SQL files


 Warren,
 Thank you for your prompt reply.

 Actually, I have various ??.sql files that I can execute thru phpMyAdmin
 and they all work, but on occasion, there is a need to run all the files
at
 once. So, I was wondering if I could create a file the would call these
 other files and execute them in sequence, i.e.

 Aggregate_file.sql
call first.sql
call second.sql
call third.sql
etc.

 If you have an example of something like this, it would be nice to see.
 Thanks.


 At 11:48 AM 1/5/03 -0800, wcb wrote:
 Hi!
 
 I have php files and perl files that create multiple databases and move
data
 around as needed. . .  is this what you mean?  You could have many such
 files if you wanted (as you mention below) but it would seem easier to
set
 up some sort of program flow so that under different conditions different
 databases could be created or dropped or whatever automatically. . .  If
 this is what you mean, then yes, it is being done even as we speak!  I
could
 send you one of my inept examples if you want.
 
 I believe that phpMyAdmin will allow you to enter SQL commands (say, by
 copying them from a file and pasting into the SQL code window).  Unless
you
 modified phpMyAdmin (which ought to be pretty easy) I think that you'd
have
 to set up an external file to create multiple databases and do your
 bidding with the data. . .
 
 Cheers!
 
 -warren
 
 Filter: mysql, query, queries, bigint
 
 - Original Message -
 From: Frank Peavy [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Cc: [EMAIL PROTECTED]
 Sent: Sunday, January 05, 2003 11:39 AM
 Subject: Multiple SQL files
 
 
   I have multiple SQL files that create different tables.
   Is there a way for me to create a single SQL file that will call these
   other files?
  
   Since I am using phpMyAdmin, I am assuming that call this file from
   phpMyAdmin?!
  
  
   -
   Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)
  
   To request this thread, e-mail [EMAIL PROTECTED]
   To unsubscribe, e-mail [EMAIL PROTECTED]
   Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
  
 
 
 -
 Before posting, please check:
 http://www.mysql.com/manual.php   (the manual)
 http://lists.mysql.com/   (the list archive)
 
 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: MySQL 4.0.7-gamma: Bugs affecting the privilege system

2003-01-05 Thread Stefan Hinz, iConnect \(Berlin\)

Alexander,

 - After having set up both machines completely, I installed the Win32
 binary distribution of MySQL 4.0.7-gamma. Although I did not upgrade
 from an earlier version, the privileges tables still have the old
 structure without the new columns introduced with MySQL 4.0.2-beta!
 Furthermore, the script menioned in the documentation
 (mysql_fix_privilege_tables) is obiously not included in the
 distribution. Because of this, there is no way to use the new
privilege
 system but fixing the tables manually...

I encountered the same issue, and Miguel Solórzano from MySQL AB replied
that it was his fault, simply forgetting the new privilege tables in the
Win32 dist.

mysql_fix_privilege_tables is nowhere to find, but a list member who had
pulled the 4.1 source found it in there and sent it to me. I extracted
the SQL statements, ran the script, and now my 4.0.7 has all the new
privileges. You'll find it at the bottom of this mail.

Maybe this can fix the other bugs you reported, too.

Regards,
--
  Stefan Hinz [EMAIL PROTECTED]
  Geschäftsführer / CEO iConnect GmbH http://iConnect.de
  Heesestr. 6, 12169 Berlin (Germany)
  Tel: +49 30 7970948-0  Fax: +49 30 7970948-3

- Original Message -
From: Alexander M. Turek [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, January 05, 2003 4:23 PM
Subject: MySQL 4.0.7-gamma: Bugs affecting the privilege system


 Hi MySQL team,


 I'm not sure, if this is the right place for bug reports, so, if it
 isn't, please forward this to those who are resposible. Running MySQL
 4.0.7 on a Windows NT 5.2 RC2 machine and on a Windows NT 5.1 one as
 well, I encoutered some bugs:


 - After having set up both machines completely, I installed the Win32
 binary distribution of MySQL 4.0.7-gamma. Although I did not upgrade
 from an earlier version, the privileges tables still have the old
 structure without the new columns introduced with MySQL 4.0.2-beta!
 Furthermore, the script menioned in the documentation
 (mysql_fix_privilege_tables) is obiously not included in the
 distribution. Because of this, there is no way to use the new
privilege
 system but fixing the tables manually...


 - If I create a user by

 GRANT USAGE ON *.* TO 'foo'@'foohost';

 and try to get the GRANT query by

 SHOW GRANTS FOR 'foo'@'foohost';

 afterwards, MySQL returns an empty result set.
 If I add a query like

 SET PASSWORD FOR 'foo'@'foohost' = PASSWORD('foobar');

 and try the SHOW GRANTS query menitioned above again, MySQL correctly
 returns:


+---
 --+
 | Grants for foo@foohost
 |

+---
 --+
 | GRANT USAGE ON *.* TO 'foo'@'foohost' IDENTIFIED BY PASSWORD
 '4655c05b05f11fab' |

+---
 --+


 - If I create a user by

 GRANT USAGE ON `footable`.* TO 'foo'@'foohost' IDENTIFIED BY 'foobar'
 WITH GRANT OPTION;

 and try to get the GRANT query again, MySQL returns this:


+---
 --+
 | Grants for foo@foohost
 |

+---
 --+
 | GRANT USAGE ON *.* TO 'foo'@'foohost' IDENTIFIED BY PASSWORD
 '4655c05b05f11fab' |
 | GRANT  ON `footable`.* TO 'foo'@'foohost' WITH GRANT OPTION
 |

+---
 --+

 While the first query is completly correct, the second one would
result
 in an error...


 Happy fixing,

 Alexander M. Turek
 [EMAIL PROTECTED]




 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-- ATTACHMENT: mysql_fix_privilege_tables --

/* THIS IS AN UNOFFICIAL EXTRACT FROM THE
   mysql_fix_privilege_tables SHELL SCRIPT.
   MADE TO WORK (well, at least for me ;-)
   WHEN UPDATING FROM MySQL 4.0.3 TO 4.0.7
   BY Stefan Hinz, [EMAIL PROTECTED], 2002-12-31
   (yes, right, New Year's Eve :)

   Copy this file to: c:\mysql\bin
   (or whereever you installed MySQL)
   and run it like follows (example is on Win2K):

   c:\mysql\bin mysql -f  mysql_fix_privilege_tables.sql mysql

   (The -f option will make it continue even if there are errors.)
*/

# Fix old password format, add File_priv and func table
ALTER TABLE user CHANGE password password CHAR(16) NOT NULL;
ALTER TABLE user ADD File_priv ENUM('N','Y') NOT NULL;
CREATE TABLE IF NOT EXISTS func (
  name CHAR(64) DEFAULT '' NOT NULL,
  ret TINYINT(1) DEFAULT '0' NOT NULL,
  dl CHAR(128) DEFAULT '' NOT NULL,
  type ENUM ('function','aggregate') NOT NULL,
  PRIMARY KEY (name)
);

# Add the

Mysql.sock gets deleated

2003-01-05 Thread Smart Guy

I installed mysql from rpm package on redhat linux 8.0
and it works fine, but next time i reboot the machine
/var/lib/mysql.sock gets deleated and mysql stops
working  

PLEASE HELP ITS URGENT.. 

__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

BUG: InnoDB combined log size must be 2 GB in a 32-bit computer

2003-01-05 Thread Heikki Tuuri

Hi!

A user of InnoDB Hot Backup just reported a bug. He has 3 InnoDB log files,
each 1 GB in size.

A 32-bit integer overflow can cause InnoDB to write log in a wrong offset.
That can spoil InnoDB recovery.

If you have too big log files, please follow the instructions at

http://www.innodb.com/ibman.html#Adding_and_removing

to make them smaller. Or wait for 3.23.55 or 4.0.8/9 and upgrade.

Regards,

Heikki
Innobase Oy

sql query




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

âÍ¡ÒÈ·Ò§¸ØÃÐ¡Ô¨ 6/1/2003 4:28:58

2003-01-05 Thread esoiewfffrl

Dear mysql ,

á¹Ð¹Ó¸ØÃ¡Ô¨ International e-Business !
àÃÕÂ¹ÃÙéÇÔ¸Õ¡ÒÃ·Ó§Ò¹ ¸ØÃ¡Ô¨¹Ò¹ÒªÒµÔ º¹ Internet
àÃÕÂ¹ÃÙéá¼¹¡ÒÃ·Ó§Ò¹à¾ÔèÁÃÒÂä´é¾ÔàÈÉã¹áµèÅÐà´×Í¹

á¼¹·ÓÃÒÂä´éÍÂèÒ§¨ÃÔ§¨Ñ§áºº·Ó§Ò¹¹Í¡àÇÅÒ
17,000 ¶Ö§ 100,000 ºÒ·/à´×Í¹
àÇÅÒ·ÕèµéÍ§ãªé : 7-14 ªÁ./ÊÑ»´ÒËì

á¼¹·ÓÃÒÂä´éÍÂèÒ§¨ÃÔ§¨Ñ§áºº·Ó§Ò¹àµçÁàÇÅÒ
50,000 ¶Ö§ 170,000 ºÒ·/à´×Í¹
àÇÅÒ·ÕèµéÍ§ãªé : 20-40 ªÁ./ÊÑ»´ÒËì

á¼¹·ÓÃÒÂä´éàÃè§¡ÓÅÑ§àµçÁ·Õèáºº·Ó§Ò¹àµçÁàÇÅÒ
¤Ø³ÊÒÁÒÃ¶·ÓÃÒÂä´é 100,000 ºÒ·ã¹à´×Í¹áÃ¡
¤Ø³ÊÒÁÒÃ¶·ÓÃÒÂä´é 350,000 ºÒ·/à´×Í¹ ÀÒÂã¹ 6 à´×Í¹áÃ¡
´ÙÃÒÂÅÐàÍÕÂ´ä´é·Õè www.geocities.com/thaigetrich1/tgr076

$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $

á¹Ð¹Ó¸ØÃ¡Ô¨ International e-Business !
Ready Made International e-Business !
Learn how to make extra money each month

Part-Time Serious Income Plan.
ß17,000 to ß100,000 a month.
Time Needed: 7 to 14 hours a week.

Full-Time Serious Income Plan.
ß50,000 to ß170,000 a month.
Time Needed: 20 to 40 hours a week.

Full-Time Accelerated Plan.
You could earn: ß100,000 in your first month.
You could earn: ß350,000 a month within first 180 days.

By doing a real ready-made business on net.
Click now www.geocities.com/thaigetrich1/tgr076 
http://www.geocities.com/thaigetrich1/tgr076


$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $


¢ÍÍÀÑÂ ËÒ¡¢éÍ¤ÇÒÁ¹Õé¶Ù¡Êè§ä»ÂÑ§¤Ø³â´ÂºÑ§àÍÔ
ËÒ¡¤Ø³µéÍ§¡ÒÃãËéÃÒÂª×èÍ¶Ù¡ÅºÍÍ¡¡ÃØ³ÒÊè§ email ¢Í§¤Ø³ÁÒ·Õè
[EMAIL PROTECTED]  â´Âà¢ÕÂ¹ËÑÇ¢éÍÇèÒUnsubscribe



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Batch Queries

2003-01-05 Thread Frank Peavy

Anyone know how to run batch queries in phpMyAdmin?
How is it done?


-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Mysql.sock gets deleated

2003-01-05 Thread Dan Nelson

In the last episode (Jan 05), Smart Guy said:
 I installed mysql from rpm package on redhat linux 8.0
 and it works fine, but next time i reboot the machine
 /var/lib/mysql.sock gets deleated and mysql stops
 working  

Mysql creates /var/lib/mysql.sock when it starts up.  Are you sure you
have the mysql service set to start on bootup?

-- 
Dan Nelson
[EMAIL PROTECTED]

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Multiple SQL files

2003-01-05 Thread Adolfo Bello

 I have multiple SQL files that create different tables.
 Is there a way for me to create a single SQL file that will 
 call these 
 other files?
 
 Since I am using phpMyAdmin, I am assuming that call this file from 
 phpMyAdmin?!

Since phpMyAdmin is a HTTP interfase, I don't think it is possible to do
this.
The server (Apache, IIS, etc) would have to know the location of the files
in the client machine, which is not possible in a stateless connection.

What I do is to have a script (bat for DOS or bash for Linux) making the
calls to the sql scripts. Something like:

mysql -h yourhost -u root -pqwerty  script1.sql
...
mysql -h yourhost -u root -pqwerty  scriptN.sql

HTH

Adolfo


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Compiling MySQL

2003-01-05 Thread Tyler

This is wierd.  When I run make on mysql 3.23.54 (Source Distro), using
./configure --prefix=/usr/local/mysql, --oh, and I'm running Mandrake Linux
9.0--I always get this:

libmysql.c:1340: warning: passing arg 5 of 'gethostbyname_r' from
incompatible pointer type

libmysql.c:1340: to few arguments to function 'gethostbyname_r'

libmysql.c:1340: warning: assignment makes pointer from integer without a
cast

make[2]: *** [libmysql.lo] Error 1

make[2]: Leaving directory '/usr/local/mysql-3.23.54a/libmysql'

make[1]: *** [all-recursive] Error 1

make[1] Leaving directory '/usr/local/mysql-3.23.54a'

make: *** [all] Error 2

Then the script closes and i get my command prompt.

Thanks in advance,
Tyler

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: mod_perl and mySql

2003-01-05 Thread Chris Faust


 Glad to hear that about MPW; thanks.

Its the truth, those 2 books have really saved my butt more then once - so
it should be me thanking you!!.

 Regarding use of persistent connections, I wonder if you really need
 them. To give an example from another language, PHP offers
 mysql_connect()
 and mysql_pconnect() connections, which set up regular or persistent
 connections.  But it turns out that the difference in overhead between
 the two call is minimal because MySQL's client/server protocol is so
 efficient for connection establishment.

 Also, persistent connections can have certain negative effects.  For one
 thing, because a connection remains open for a longer time, even when no
 script is actively using it, you can more easily end up bumping
 up against
 your server's max-simultaneous-connection limit.  With non-persistent
 connections, this is less of an issue.


Thanks Paul, that tells me to stop going crazy over it at least :)..
The difference in performance between now and before mod_perl is just so
amazing I was trying to squeeze everything I could out of it.

-Chris




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

perl, MySQL, and Lost Connection while executing error!

2003-01-05 Thread Alan

Hey everyone I just joined this group today with an error that has been
plaguing me for the past 2 weeks and I can't figure out what's wrong!!
What's happening is I'll start up my perl program and sometimes, for no
apparent reason, I will get the Lost Connection to MySQL Server while
executing query, followed by a fetch() without execute() error.  Again,
the error isn't constant and if I restart my programs a few times,
sometimes it will work just fine.  I tried $DBH-trace(2) but that
didn't seem to help me.  I noticed this however:
- prepare('SELECT sendmsg FROM regnicks WHERE nick=?')=
DBI::st=HASH(0x840379c) at Nickserv.pm line 141
!! ERROR: 2013 'Lost connection to MySQL server during query'

I'm not sure what error 2013 is or if this could help me solve my error.
I was also looking to see if there was some type of error log that I
could reference to check for more information? 

Thanks for any and all help!!  If you need any more information, I would
be more than happy to answer any questions!

Alan





-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Installation on NT using a drive C

2003-01-05 Thread oceanare pte ltd

Hi,

I do not know if this is a bug or feature.

We installed MySQL on a test machine with many partitions. The
start of the service crashed with error 1067 if Windows was not
installed on drive C.

The only way to get it up and running was to place the file
'my.cnf' in the root of drive C.

It is no problem to use 'my.ini' in the Windows directory if
Windows is installed on drive C. The installation of Windows on
any other drive will force you to switch to 'C:\my.cnf' as the
only way to configure MySQL.

It would be helpfull to the users if the manual would state that
MySQL only allows the use of 'my.ini' in the Windows directory if
Windows is installed on drive C. The documentation uses drive C
only as an example at the moment.

Erich


-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Installation on NT using a drive C

2003-01-05 Thread Paul DuBois

At 9:52 +0800 1/6/03, oceanare pte ltd wrote:

Hi,

I do not know if this is a bug or feature.


One of the screens that the installer presents tells you that if you
want to use a different location than the default of the C: drive,
you'll need to put something like this in your my.cnf or my.ini file:

[mysqld]
basedir=path-to-installation-basedir



We installed MySQL on a test machine with many partitions. The
start of the service crashed with error 1067 if Windows was not
installed on drive C.

The only way to get it up and running was to place the file
'my.cnf' in the root of drive C.


If you use the my.cnf file, yes, it must be C:\my.cnf.  The MySQL
distribution itself can be installed anywhere.



It is no problem to use 'my.ini' in the Windows directory if
Windows is installed on drive C. The installation of Windows on
any other drive will force you to switch to 'C:\my.cnf' as the
only way to configure MySQL.

It would be helpfull to the users if the manual would state that
MySQL only allows the use of 'my.ini' in the Windows directory if
Windows is installed on drive C. The documentation uses drive C
only as an example at the moment.

Erich



-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Update Year of Date Field using sql statement

2003-01-05 Thread Hakkan Lui

Dear all,

How can I change the year of the date field using sql statement?

It means something like:
update table1 set year(f1) = '2002' where year(f1) = '2003';


Thanks for anyone's help.



Regards,
Hakkan Lui


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Optimize Table usage

2003-01-05 Thread Dan Cumpian

Hello,

I am trying to write a process to optimize several tables in a database
by using the OPTIMIZE TABLE command in a query. I have a couple of
questions that I can't get an answer to in the documentation:

1) Do I: Query.ExecSQL or Query.Open to execute the OPTIMIZE TABLE
TableName command?

2) The queries are returning instantly and when the program tries to run
OPTIMIZE TABLE on the next table, I am getting a commands out of sync
error. How can I tell when the optimization process is complete? (Please
note that I am using Delphi and Query objects to interface with the
tables).

3) Should I do a CHECK TABLE before I do an OPTIMIZE TABLE?

Thanks,
Dan Cumpian



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Upgrading from MySQL 3.23.52 to 3.23.54

2003-01-05 Thread Peter Teo

Good day,

I have read on http://www.mysql.com about the press releases asking all
3.23 users to upgrade to the latest stable version.

How can I do this without uninstalling my current version? I tried to
look for some documentation regarding this or patches but was unable to
find any.

I would appreciate your help.

Thanks! 

Peter Teo
Clickhere2 Network Pte Ltd




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Update Year of Date Field using sql statement

2003-01-05 Thread Bhavin Vyas

I don't think there is a way to do that. Unless some one says there is(and
tells us how to do it), I guess your only option is to write a script to do
that.

Regards,
Bhavin.
- Original Message -
From: Hakkan Lui [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, January 05, 2003 10:12 PM
Subject: Update Year of Date Field using sql statement

 Dear all,

 How can I change the year of the date field using sql statement?

 It means something like:
 update table1 set year(f1) = '2002' where year(f1) = '2003';

 Thanks for anyone's help.

 Regards,
 Hakkan Lui

 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Update Year of Date Field using sql statement

2003-01-05 Thread Paul DuBois

At 22:56 -0500 1/5/03, Bhavin Vyas wrote:

I don't think there is a way to do that. Unless some one says there is(and
tells us how to do it), I guess your only option is to write a script to do
that.


Here's one way:

UPDATE table1
SET f1 = CONCAT('2002','-',MONTH(f1),'-',DAYOFMONTH(f1))
WHERE YEAR(f1) = 2003;

That is, synthesize the new date using the desire year, plus the
other parts of the existing date.

If you just want to subtract a year, do this:

UPDATE table1
SET f1 = DATE_SUB(f1,INTERVAL 1 YEAR)
WHERE YEAR(f1) = 2003;



Regards,
Bhavin.
- Original Message -
From: Hakkan Lui [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, January 05, 2003 10:12 PM
Subject: Update Year of Date Field using sql statement



 Dear all,

 How can I change the year of the date field using sql statement?

 It means something like:
 update table1 set year(f1) = '2002' where year(f1) = '2003';


 Thanks for anyone's help.



 Regards,

  Hakkan Lui



-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Upgrading from MySQL 3.23.52 to 3.23.54

2003-01-05 Thread Peter Teo

Good day,

I have read on http://www.mysql.com about the press releases asking all
3.23 users to upgrade to the latest stable version.

How can I do this without uninstalling my current version? I tried to
look for some documentation regarding this or patches but was unable to
find any.
 
I would appreciate any help.

Thanks! 

Peter Teo
Clickhere2 Network Pte Ltd




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Upgrading from MySQL 3.23.52 to 3.23.54

2003-01-05 Thread Anton Zavrin

I don't' know if it was right to do, but I just downloaded version
3.23.54a and compiled/installed it

Best Regards, Anton

-Original Message-
From: Peter Teo [mailto:[EMAIL PROTECTED]] 
Sent: Sunday, January 05, 2003 8:08 PM
To: [EMAIL PROTECTED]
Subject: Upgrading from MySQL 3.23.52 to 3.23.54

Good day,

I have read on http://www.mysql.com about the press releases asking all
3.23 users to upgrade to the latest stable version.

How can I do this without uninstalling my current version? I tried to
look for some documentation regarding this or patches but was unable to
find any.

I would appreciate any help.

Thanks! 

Peter Teo
Clickhere2 Network Pte Ltd

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Update Year of Date Field using sql statement

2003-01-05 Thread Daniel Kasak

Hakkan Lui wrote:

Dear all,

How can I change the year of the date field using sql statement?

It means something like:
update table1 set year(f1) = '2002' where year(f1) = '2003';
  

If you have a field for _just_ the year, you can use the above statement.
If you have the year embedded in a date field which has other data (eg
days and months) then you'll have to use the substring function (or you
could get fancy with some of mysql's date functions, but I wouldn't in
this case).

MySQL stores dates in the format -mm-dd, so you just have to do
something like:

update table1 set year(f1) = concat('2003' , '-',
substring(year(f1),6,5)) where substring(year(f1),1,4)='2002';

Or something. I haven't checked the above, so beware...
Read up on concat.

Also I would reconsider using those brackets in the year field:
year(f1). I don't know whether brackets in a field name are supported,
but brackets usually indicate a function.

-- 
Daniel Kasak
IT Developer
* NUS Consulting Group*
Level 18, 168 Walker Street
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: www.nusconsulting.com


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Upgrading from MySQL 3.23.52 to 3.23.54

2003-01-05 Thread Mark

- Original Message -
From: Peter Teo [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, January 06, 2003 5:08 AM
Subject: Upgrading from MySQL 3.23.52 to 3.23.54

 Good day,

 I have read on http://www.mysql.com about the press releases
 asking all 3.23 users to upgrade to the latest stable version.

 How can I do this without uninstalling my current version?
 I tried to look for some documentation regarding this or patches
 but was unable to find any.

On my FreeBSD 4.7R box, I recently upgraded too, from 3.23.49 to 3.23.54a. I
was lazy this time, and (oh mother of all shames) used the precompiled
binary from the MySQL site. :) Worked like a charm though. Cool thing about
the binary is, that it runs as is; so you could just use that one binary
next to your existing distro.

- Mark

System Administrator Asarian-host.org

---
If you were supposed to understand it,
we wouldn't call it code. - FedEx

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

osx source doe not complie

2003-01-05 Thread ing . conti



when I try to compile the source distro, i get:



sql_udf.cc:57:19: dlfcn.h: No such file or directory
sql_udf.cc: In function `void init_syms(udf_func*)':
sql_udf.cc:88: `dlsym' undeclared (first use this function)
sql_udf.cc:88: (Each undeclared identifier is reported only once for
each
function it appears in.)
sql_udf.cc: In function `void udf_init()':
sql_udf.cc:182: `dlopen' undeclared (first use this function)
sql_udf.cc:185: `dlerror' undeclared (first use this function)
sql_udf.cc:198: `dlclose' undeclared (first use this function)
make[4]: *** [sql_udf.o] Error 1
make[3]: *** [all-recursive] Error 1
make[2]: *** [all] Error 2
make[1]: *** [all-recursive] Error 1
make: *** [all] Error 2


and make stops

ANY IDEA?



Ing. Conti
via s. Gottardo 76
20052 MONZA MI ITALY
0039-39-324723
www.ingconti.com


-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

50 matches

Mail list logo