Problem with unique index on InnoDB
Hello group, My table look like this: CREATE TABLE `mda_models` ( `model_id` int(10) NOT NULL auto_increment, `make_id` int(10) NOT NULL default '0', `model_name` varchar(100) NOT NULL default '', `model_phase` varchar(100) default NULL, `model_phase_no` int(4) default NULL, `model_manufacturer_name` text, `model_type` int(10) NOT NULL default '0', `model_wage` int(4) default NULL, `update_date` datetime NOT NULL default '-00-00 00:00:00', `update_user_id` int(10) NOT NULL default '0', `add_date` date NOT NULL default '-00-00', `pricelist_start_date` date NOT NULL default '-00-00', `pricelist_end_date` date NOT NULL default '-12-31', `sales_end_date` date NOT NULL default '-12-31', PRIMARY KEY (`model_id`,`make_id`), UNIQUE KEY `model` (`model_name`,`model_phase`,`model_phase_no`,`model_type`,`make_id`), KEY `make_id` (`make_id`), KEY `model_id` (`model_id`), KEY `model_type` (`model_type`), FOREIGN KEY (`make_id`) REFERENCES `mda_makes` (`make_id`), FOREIGN KEY (`model_type`) REFERENCES `set_mda_car_types` (`type_id`) ) TYPE=InnoDB As you see there is the unique key called model. There are several fields, some of them can be null.. Look at this insert querys: INSERT INTO mda_models (make_id, model_name, model_phase, model_phase_no, model_type) VALUES (42, 'Test model', NULL, NULL, 1); INSERT INTO mda_models (make_id, model_name, model_phase, model_phase_no, model_type) VALUES (42, 'Test model', NULL, NULL, 1); MySQL should send an error before second query, that there is the record which is the same as the inserting one... But NO, you can add as many as you want... Is this a bug or I'm doing something wrong. I would be appreciated for help!! Marek Lewczuk POLAND - 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
IIC¿µ·ðÂ×˹2003ÉϺ£ÑÐÌÖ»á
IIC Conference(mysql): IIC Conferences2003226-2736-732649-10 2003http://www.iicconferences.com/sh200303.htm http://www.iicconferences.com/sh200304.htm http://www.iicconferences.com/sh200305.htm http://www.iicconferences.com/sh200306.htm IIC *086-021-62151515#850, 086-021-62552524 *086-021-62581405 , [EMAIL PROTECTED] * http://www.IICconferences.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: Start MySQL along with a update statement.
On Tue, Feb 25, 2003 at 01:30:52AM -0500, g gnanaraj wrote: I need to start MySQL using a script which does the following: 1. login to MySQL 2. use a specific database 3. run a update statement 4. exit I have been able to achieve 1 2 by doing the following but not the others. mysql -D test mysql -e UPDATE foo SET bar=1 WHERE baz=2; test For more information check the output of mysql -? Cheers! -- Zak Greant [EMAIL PROTECTED] MySQL AB Community Advocate Personal Blog: http://zak.fooassociates.com Debian: Yep, that's GNU/Linux (http://debian.org) - 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: Large table or several tables ?
gregory lefebvre wrote: Hye the list, There is my problem. I have to register about 400 large arrays (~1 lines each) in my MySQL database and I don't know which of the following choices is better. Either create a large tables as a stack, which contains all arrays Either create as many tables as there are arrays and use references to each table. Any advice is welcome. Thank you very much Greg - 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 Thank you. I think I will create my table as a stack and push all my arrays in. Greg - 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 codes
On Mon, Feb 24, 2003 at 07:37:21PM -0800, DiAnNe iRiS aLeRta wrote: i am to make a feature for mysql which is horizontal aggregation for our thesis. is this existing already? if not, is vertical aggregation existing? can you show me the codes for it? i need it to have a basis for developing the horizontal aggregation. horizontal aggregation is collecting values in a ROW based on some grouping criterion and displaying it in horizontal manner. vertical aggregation is collecting values in a COLUMN based on some grouping criterion. thank you so much! Dear Dianne, MySQL supports vertical aggregation. Review http://www.mysql.com/doc/en/Group_by_functions.html As for finding the code that relates to these functions, the best place to start (IMHO :) is by grabbing a copy of cscope and then starting to dig into the code at sql/sql_yacc.yy cscope allows you to interactively browse though C source code (but can also handle C++ well enough) - if you don't have a copy, grab one from http://cscope.sourceforge.net/ Good Luck! -- Zak Greant [EMAIL PROTECTED] MySQL AB Community Advocate Personal Blog: http://zak.fooassociates.com Translucent Databases: An Excellent Guide to Protecting Sensitive Data! Visit http://www.wayner.org/books/td/ for more information - 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
È«ÃæÖ§³ÖJSP/ASP/PHP/ASP.NETÆóÒµ½¨Õ¾¿Õ¼ä³ÏÑû´úÀí.
È«ÃæÖ§³ÖJSP/ASP/PHP/ASP.NETÆóÒµ½¨Õ¾¿Õ¼ä³ÏÑû´úÀí. ÎÒ˾ÍƳöÆóÒµ½¨Õ¾×¨Óÿռ䣬ȫÃæÖ§³ÖJSP¡¢ASP¡¢PHP¡¢ASP.NET£¬ÏÖÕýÃæÏòÈ«¹ú¸÷µØ³ÏÑû´úÀí£¬ÀûÈó¿É´ï40%£¡ * ÉêÇëʱ´´ÍøÂçµÄ´úÀí£¬³ýÁË¿ÉÒÔÏíÊÜÈ«·½Î»µÄ»¥ÁªÍø²úÆ··þÎñ£¬»¹¿ÉÒÔÃâ·Ñ»ñµÃÓòÃû¡¢¿Õ¼ä¡¢ÖÇÄܽ¨Õ¾¡¢¶¯Ì¬IPµÈµÄÔÚÏß×¢²á´úÂ룬·½±ãÄú¼°Ê±¿ªÕ¹ÒµÎñ¡£ * ÌṩÏȽøµÄ´úÀí¹ÜÀíƽ̨£¬È«·½Î»µÄ¹ÜÀíÄúÉêÇëµÄËùÓвúÆ·¼°×ÊÁÏ£¬°üÀ¨ÓòÃû¡¢¿Õ¼äÓÊÏä¡¢¶¯Ì¬IP¡¢ÖÇÄܽ¨Õ¾¡¢ÍøÕ¾ÍƹãµÈµÈ¡£ * ϵͳÖ÷»úλÓÚÖйúµçÐų¬¼¶Êý¾Ý¸Û£¬¹ú¼Ò¼×¼¶»ú·¿£¬Í¨¹ý2XGE¹âÏËÖ±Á¬ChinaNET¹Ç¸ÉÍø£¬ÓÐЧ±£ÕÏÍøÂçµÄÎȶ¨ÐԺ͸ßËÙÐÔ¡£7*24СʱµÄ¼à¿Ø·þÎñ¼°ÏµÍ³ÓÅ»¯Î¬»¤£¬±£Ö¤ÁËÐéÄâÖ÷»úµÄ7*24µÄÔÚÏßÎȶ¨·ÃÎÊ¡£ ÌṩÓòÃû×¢²á¡¢ÐéÄâÖ÷»ú¡¢ÖÇÄܽ¨Õ¾¡¢¶¯Ì¬IP¡¢Í¨ÓÃÍøÕ¾ÔÚÏß×¢²áµÄ¿ìËÙÄ£°å£¬·½±ãÄú¿ªÕ¹ÒµÎñ£¡ ÉêÇ룺 http://www.pro.net.cn ²úÆ·ÓÅÊƼ°ÊÔÓÃÇë²Î¿¼ÒÔϵÄÁ´½Ó¡£ 1¡¢ÓòÃû£º¶ÀÌصÄVDNS¿ÉÊÓ»¯ÓòÃû¹ÜÀíϵͳÈÃÄã³ÉÓòÃûÕæÕýµÄËùÓÐÕߣ¬¿É×ÔÑ¡¹ÜÀíURLת·¢¼°URLÒþ±Îת·¢,A MX IPÖ¸ÏòµÈµÈ£¬²¢¿É²úÉú¶à¸ö´Î¼¶ÓòÃû£¬ÊµÏÖÒ»¸ö¶¥¼¶ÓòÃû½¨Á¢¶à¸öÍøÕ¾¡£¹¦ÄÜÑÝʾ: http://01isp.com/support/vdnsuse.net 2¡¢ÐéÄâÖ÷»ú£ºÈ«ÃæÖ§³ÖJSP¡¢PHP¡¢ASP.NETÐéÄâÖ÷»ú£¬ÖйúµçÐÅ2GÖ±½Ó½ÓÈëCHINANETÖ÷¸É!Ö§³Ö×î¸ß°æ±¾£¬¸ßËÙ¡¢Îȶ¨£¡Êǽ¨Á¢ÆóÒµ¡¢¸öÈËÍøÕ¾µÄ×î¼ÑÑ¡Ôñ¡£Ìṩ100MÊÔÓÿռ䡣 ÉêÇ룺http://01isp.com/host 3¡¢Êý¾Ý¿â£º¶àÖÖÖ§³Ö·½Ê½£Asp+Access¡¢Asp+sql server2000¡¢php/jsp+mysql¡¢php/jsp+sql server 2000£¬»¶ÓÑ¡¹º¡£ 4¡¢Í¨ÓÃÍøÖ·£ºCNNICÈÏÖ¤µÄ×¢²á»ú¹¹£¬Á¢¼´×¢²áÁ¢¿ÌÉúЧ£¬ÌṩȫÃæµÄͨÓÃÍøÖ·ÐÅÏ¢¹ÜÀíºǫ́¡£ÉêÇëÊÔÓÃ10Ì죺 http://01isp.com/CNAddress 5¡¢ËÑË÷ÒýÇ棺ÐÂÀË¡¢ËѺü¡¢ÍøÒס¢°Ù¶ÈÒýÇæµÇ¼£¬²»·Ñ´µ»ÒÖ®Á¦ÈÃÄúµÄ¹Ë¿ÍÕÒµ½Äú¡£ÉêÇ룺 http://01isp.com/promote 6¡¢·±¼òͨ£ºÊµÏÖ·±Ìå¡¢¼òÌåÁ½¸ö°æ±¾ÄÚÈÝ¡¢Êý¾Ý¿â×Ô¶¯»¥»»£¬¿ÉÃâ·ÑÊÔÓã¡ 7¡¢¶¯Ì¬IP:ÅäºÏÎÒÃǵÄVDNS¶¯Ì¬ÓòÃû¼¼Êõ£¬°ÑÍøÕ¾·ÅÔÚ×Ô¼º¼ÒÖС£ ÑÝʾ£ºhttp://01isp.com/support/vdnsusex.net ÉêÇ룺http://01isp.com/cyberip 8¡¢ÖÇÄܽ¨Õ¾£ºÈý·ÖÖÓ½¨Á¢ÄúµÄÍøÕ¾£¬ºÃÓüòµ¥·½±ã¡£¿ÉÃâ·ÑÊÔÓÃ15Ìì¡£ÉêÇëÊÔÓãºhttp://01isp.com/auto ´úÀíÒµÎñƽ̨Çë¼û£º http://www.pro.net.cn¡¡ £ £ ʱ´´ÍøÂç×÷ΪCNNICµÄÈÏÖ¤»ú¹¹£¬ÍƳöÐéÄâÖ÷»ú¡¢ÉÁËÙÓʾ֡¢ÓòÃû×¢²á¡¢ÖÇÄܽ¨Õ¾¡¢Í¨ÓÃÍøÖ·¡¢´úÀíÒµÎñÒ»ÌõÁú·þÎñ£¡ £ £ ÎÒÃÇÌṩµÄ·þÎñרҵ¡¢¿ìËÙ¡¢¿É¿¿£¬Ë«Ö¤ÈÏ¿É£¬¾ø¶Ô¿É¿¿£¬ÊʺϸüרҵµÄÄú£¡ ·þÎñÆ÷×âÓ㬺ÃÅäÖ㬵ͼ۸ñ http://idc.now.net.cn,Ä긶ÃâÁ½¸öÔ¡£ ³ÏÑû¹ã¸æºÏ×÷»ï°é¡£ Ö麣ʱ´´ÍøÂç http://www.01isp.com 0756--2125593 2125523 2125583 2125563 ´«Õ棺 0756--2229669 ÓʼþÖ§³Ö:[EMAIL PROTECTED] OICQ·þÎñ£º153203366¡¢108786612 ¿Í»§·þÎñ£ºÐÇÆÚÒ»µ½ÐÇÆÚÈÕ - 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 unique index on InnoDB
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Harald Fuchs Sent: Tuesday, February 25, 2003 10:52 AM To: [EMAIL PROTECTED] Subject: Re: Problem with unique index on InnoDB The second record is different because it has another model_id. BTW: your index on model_id is useless because it's covered by your primary key. Yes, correct... Primary key is based on model_id, and model_id field is set as autoincrement. But there is also unique index called model, and there is no model_id field inside... So mysql should not add two same records... In article [EMAIL PROTECTED], Marek Lewczuk [EMAIL PROTECTED] writes: Hello group, My table look like this: CREATE TABLE `mda_models` ( `model_id` int(10) NOT NULL auto_increment, `make_id` int(10) NOT NULL default '0', `model_name` varchar(100) NOT NULL default '', `model_phase` varchar(100) default NULL, `model_phase_no` int(4) default NULL, `model_manufacturer_name` text, `model_type` int(10) NOT NULL default '0', `model_wage` int(4) default NULL, `update_date` datetime NOT NULL default '-00-00 00:00:00', `update_user_id` int(10) NOT NULL default '0', `add_date` date NOT NULL default '-00-00', `pricelist_start_date` date NOT NULL default '-00-00', `pricelist_end_date` date NOT NULL default '-12-31', `sales_end_date` date NOT NULL default '-12-31', PRIMARY KEY (`model_id`,`make_id`), UNIQUE KEY `model` (`model_name`,`model_phase`,`model_phase_no`,`model_type`,`make_id`), KEY `make_id` (`make_id`), KEY `model_id` (`model_id`), KEY `model_type` (`model_type`), FOREIGN KEY (`make_id`) REFERENCES `mda_makes` (`make_id`), FOREIGN KEY (`model_type`) REFERENCES `set_mda_car_types` (`type_id`) ) TYPE=InnoDB As you see there is the unique key called model. There are several fields, some of them can be null.. Look at this insert querys: INSERT INTO mda_models (make_id, model_name, model_phase, model_phase_no, model_type) VALUES (42, 'Test model', NULL, NULL, 1); INSERT INTO mda_models (make_id, model_name, model_phase, model_phase_no, model_type) VALUES (42, 'Test model', NULL, NULL, 1); MySQL should send an error before second query, that there is the record which is the same as the inserting one... But NO, you can add as many as you want... Is this a bug or I'm doing something wrong. - 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
error 2003
hi listers i have a c program that connects to a myssql db. for some reason or another, every now and again i get the following error message ERROR in mysql_real_connect() Number: 2003 Message: Can't connect to MySQL server on 'softdistqa' (10048) i find enough info on mysql website about error number 2003, but nothing about 10048. what is error 10048? environment: w2k sp3, mysql 3.23.54-max-nt sql, query tks tom _ Who's your buddy? Win Vespa scooters for yourself and 5 of your buddies! http://www.sweepstakes2003.com/entry.aspx?LocationID=3 - 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
Starting mysqld within SuSE 8.0
Hello, can someone tell me how to start mysqld at boot on a SuSE 8.0 system? Starting it manually with safe_mysqld runs fine. But I didn't find a way in YaST to start the daemon on boot, and manually adding it to the /etc/init.d/boot.d/ lead me into a crash. Thanks in advance, Markus - 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: Starting mysqld within SuSE 8.0
Hi Markus, can someone tell me how to start mysqld at boot on a SuSE 8.0 system? Starting it manually with safe_mysqld runs fine. But I didn't find a way in YaST to start the daemon on boot, and manually adding it to the /etc/init.d/boot.d/ lead me into a crash. The easiest way would be using Yast, then choosing System, Runlevel-Editor. There you find Runlevel-Properties (Runlevel-Eigenschaften if you choose German Language for Yast). In the upcoming window for the services (Dienste) you can set markers, at which runlevels mysql should start. For more infos you should look here - http://sdb.suse.de/de/sdb/html/start_foo80.html Greetings from Hessen/Germany Lutz Maibach EasyCom GmbH - 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
table row result spool to file
Hi I need to create a file from the row of a table. I have done the following but it does not create a file but only display it on screen. What am I missing? Thanks. [EMAIL PROTECTED] godson]$ mysql -e select * from baa; --pager=t.sh test ++ | nam| ++ | mysqldump --lock-tables -ubugs bugs -pfileit /home/godson/backup20030225.sql | ++ _ Get 25MB, POP3, Spam Filtering with LYCOS MAIL PLUS for $19.95/year. http://login.mail.lycos.com/brandPage.shtml?pageId=plusref=lmtplus - 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 MySQL, MyODBC, Access 2002 and Japanese.
Help!, I am developing a multilingual site in English, Spanish and Japanese. I am using MySQL with PHP in the server side, and Access 2002 in the local side, using MyODBC to communicate MySQL with Access 2002. MySQL and PHP works toguether ok in Japanese, English and Spanish (using EUC_JP in both PHP and MySQL), Access 2002 (XP operating system) works ok in japanese (XP use UNICODE). The big problem is MyODBC. When I connect Access 2002 with MySQL (via MyODBC) to view the japanese characters stored in MySQL, in Access 2002 I only see a lot of strange characteres, I view the same characters without problems using phpMyAdmin. I have been several days searching the web without success. Any suggestion to solve this problem (in English or Spanish, no Japanese :-)? ___ Yahoo! Móviles Personaliza tu móvil con tu logo y melodía favorito en http://moviles.yahoo.es - 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 v SAB DB
Hi, My fledgling product is based around a MySQL database, my _first_ customer is asking me to use SAB DB. Obviously this means a bit of re-engineering work and extensive testing. I am looking for peoples experiences of SAP DB, so that I can build a case for continueing with MySQL, (other than that the product works fine with MySQL) Does anyone have such experience. Is the support as good as MySQL? From what I can see, it is a fully featured DB engine. Thanks Richard - 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: How do I select 'all related' in a many-to-many relation?
Harald Fuchs wrote: That's easy: [Excellent MySQL code example snipped] Thanks, that was exactly what I was looking for. /mac - 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
Replication problem (alter table fails)
Dear gurus, Coud you, please, give an advice to solve following problem: I've got two Mysql Servers: * Master: Sparc Solaris 8, MySQL 3.23.32 * Slave: RedHat Linux 7.2, MySQL 3.23.32 Replication of data runs fine, all insert into and delete from made on master successfully change the slave database. Creation and dropping of the whole tables also work fine. But if I add or delete certain column in any table on master DB (e.g. run ALTER TABLE commands), slave ignores is and later on stops replication because it cannot replicate the data appeared or changed on the master afterwards (because these fields not exist on the slave). Is there any way to tell either Master or Slave to replicate ALTER TABLE queries as well? Best Regards, Kirill - 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: Starting mysqld within SuSE 8.0
Hi Lutz, The easiest way would be using Yast, then choosing System, Runlevel-Editor. There you find Runlevel-Properties (Runlevel-Eigenschaften if you choose German Language for Yast). In the upcoming window for the services (Dienste) you can set markers, at which runlevels mysql should start. That did it. :-) Thank you very much! Greetings from Rheinland-Pfalz/Germany Markus -- Markus Gerwinski, IT-Berater An der Brunnenstube 15/3, 55120 Mainz Tel.: 06131-945852, mobil: 0177-3552099 http://www.it-beratung.gerwinski.de - 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 v SAB DB
On Tue, Feb 25, 2003 at 11:29:23AM +, Richard Morton wrote: Hi, My fledgling product is based around a MySQL database, my _first_ customer is asking me to use SAB DB. Obviously this means a bit of re-engineering work and extensive testing. I am looking for peoples experiences of SAP DB, so that I can build a case for continueing with MySQL, (other than that the product works fine with MySQL) Does anyone have such experience. Sorry - I can't offer any real advice here. All of my experience in this area is hearsay. There was a discussion on slashdot that discussed SAPDB - however, there was a pretty high noise-to-signal ratio for the discussion. Is the support as good as MySQL? Who knows? Perhaps ask the same question on the SAPDB community list? :) From what I can see, it is a fully featured DB engine. You can use our crash-me utility to see differences in the feature set implemented between MySQL and SAPDB. This will at least give you some indication. Cheers! -- Zak Greant [EMAIL PROTECTED] MySQL AB Community Advocate Personal Blog: http://zak.fooassociates.com AdBusters: Creative Resistance to Consumerism (http://adbusters.org) - 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: 4.0.10 rpm doesn't include POSTIN script
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Mon, 24 Feb 2003, Christopher Hicks wrote:
The 4.0.10 MySQL-server rpm's don't include the POSTIN script. I'm
guessing this is because of moving the server to a subpackage and the
POSTIN scripts being spec'd for the main package. It's easy to see this
by running:
rpm -qp --qf %{POSTIN}\n MySQL*4.0.9*.i386.rpm
rpm -qp --qf %{POSTIN}\n MySQL*4.0.10*.i386.rpm
The first shows the script is there while the second produces basically
nothing.
You guessed right - I forgot to assign the scripts to the renamed server
subpackage. This will be fixed for 4.0.11, which will be released today.
I ran into this while installing 4.0.10 on a new box today. I'm
guessing that installing 4.0.9 and then upgrading to 4.0.10 will work
around the problem, but I haven't tried that yet.
Yes, that'd be a workaround. It really only bites you on a fresh install.
Sorry for the inconvenience!
Bye,
LenZ
- --
For technical support contracts, visit https://order.mysql.com/?ref=mlgr
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Mr. Lenz Grimmer [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Production Engineer
/_/ /_/\_, /___/\___\_\___/ Hamburg, Germany
___/ www.mysql.com
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.0 (GNU/Linux)
Comment: For info see http://quantumlab.net/pine_privacy_guard/
iD8DBQE+W2abSVDhKrJykfIRAvl8AJ0asxoV8dHNkerkpdEBmkPS21ubbwCdFdRs
47AVS69rZDNEAuEhedi6ErI=
=ogmE
-END PGP SIGNATURE-
-
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: BUG: Format function fails when query ordered
On Monday 24 February 2003 20:22, Karl Stubsjoen wrote: I am reporting a bug. The format number function fails when a query is sorted. I have included an example page to look at (the error is reproduced here): http://www.meetscoresonline.com/test_format.asp You'll see there are 2 result sets, the first is not ordered and the 2nd is ordered. In the first example, the format function indeed works, but not in the 2nd. Is this indeed a bug, or something I am doing wrong? MySQL Version: 4.0.0-alpha I tested and FORMAT() worked as expected. Could you upgrade MySQL server and test it on the latest version? 4.0.0 is a bit outdated. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.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: Replication problem (alter table fails)
On Tuesday 25 February 2003 14:17, Kirill Peskov (WEB-EU) wrote: Coud you, please, give an advice to solve following problem: I've got two Mysql Servers: * Master: Sparc Solaris 8, MySQL 3.23.32 * Slave: RedHat Linux 7.2, MySQL 3.23.32 Replication of data runs fine, all insert into and delete from made on master successfully change the slave database. Creation and dropping of the whole tables also work fine. But if I add or delete certain column in any table on master DB (e.g. run ALTER TABLE commands), slave ignores is and later on stops replication because it cannot replicate the data appeared or changed on the master afterwards (because these fields not exist on the slave). Is there any way to tell either Master or Slave to replicate ALTER TABLE queries as well? Since 3.23.32 there were a lot of bug fixed related to the replication. Please, upgrade servers and test it again. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.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
Newbie question...
Hi ppl!. I'm running Mysql Server 4.0.10 in Win XP. And every time i shutdown the service, i loose all data inside the tables? Is this normal, i've i forget something? Thankz, Nando - 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: Starting mysqld within SuSE 8.0
On Tue, 25 Feb 2003, Markus Gerwinski wrote: Hello, can someone tell me how to start mysqld at boot on a SuSE 8.0 system? Starting it manually with safe_mysqld runs fine. But I didn't find a way in YaST to start the daemon on boot, and manually adding it to the /etc/init.d/boot.d/ lead me into a crash. You may enable the start of mysql with the yast2 runlevel editor. Works fine for me on SuSE 8.0 even after compiling and installing newer versions of MySQL. However make sure to keep the same directory tree as SuSE. Thomas Thanks in advance, Markus - 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: Newbie question...
No this is not right. How are you creating the tables? How are you entering the data? Where are you putting them? e.g. /mysql/var/your_table.frm What type of table are you using? Simon -Original Message- From: Fernando Morais [mailto:[EMAIL PROTECTED] Sent: 25 February 2003 13:29 To: [EMAIL PROTECTED] Subject: Newbie question... Hi ppl!. I'm running Mysql Server 4.0.10 in Win XP. And every time i shutdown the service, i loose all data inside the tables? Is this normal, i've i forget something? Thankz, Nando - 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
Fw: Newbie question...
Well i've created the tables using the MySQL control center. The program that is inserting the data, is a program develop by me in delphi. But it work fines. If i insert some data and go to mySQL Control Center the data is there. All fields with no problem. I installed mySQL server in 2 different pc's, with the same problem. Every time i stop the service, all data is gone. The tables type is HEAP. They're located at /mysql/data/ - Original Message - From: Simon Green [EMAIL PROTECTED] To: 'Fernando Morais' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, February 25, 2003 1:30 PM Subject: RE: Newbie question... No this is not right. How are you creating the tables? How are you entering the data? Where are you putting them? e.g. /mysql/var/your_table.frm What type of table are you using? Simon -Original Message- From: Fernando Morais [mailto:[EMAIL PROTECTED] Sent: 25 February 2003 13:29 To: [EMAIL PROTECTED] Subject: Newbie question... Hi ppl!. I'm running Mysql Server 4.0.10 in Win XP. And every time i shutdown the service, i loose all data inside the tables? Is this normal, i've i forget something? Thankz, Nando - 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: table row result spool to file
Hi Thanks but I'm not getting the expected result. See the following: [quote] [EMAIL PROTECTED] godson]$ cat chk5.sh mysql -e select * from baa into outfile \/home/godson/run.sh\; test [EMAIL PROTECTED] godson]$ ./chk5.sh ERROR 1045 at line 1: Access denied for user: '@localhost' (Using password: NO) [EMAIL PROTECTED] godson]$ [/quote] Any ideas ? -- On 25 Feb 2003 13:24:01 +010 Harald Fuchs wrote: In article [EMAIL PROTECTED], g gnanaraj [EMAIL PROTECTED] writes: Hi I need to create a file from the row of a table. I have done the following but it does not create a file but only display it on screen. What am I missing? Thanks. [EMAIL PROTECTED] godson]$ mysql -e select * from baa; --pager=t.sh test How about using SELECT... INTO OUTFILE...? [Filter fodder: 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 _ Get 25MB, POP3, Spam Filtering with LYCOS MAIL PLUS for $19.95/year. http://login.mail.lycos.com/brandPage.shtml?pageId=plusref=lmtplus - 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
Query from a PHP Form
I have a query that is extracting records from a MySQL DB at the moment the
query is just pulling 'all' records and not the selected records from a drop
down :(
I am using php too.
the query I have is this:
$result=mysql_query('select distinct items.* from items,city,category where
items.CityID=city.CityID and items.Category=category.CategoryID');
if (!$result) echo mysql_error();
else {
}
Table structure is this:
Table structure for table 'category'
CREATE TABLE category (
Category varchar(100) DEFAULT '' NOT NULL ,
CategoryID bigint(20) DEFAULT '' NOT NULL auto_increment,
PRIMARY KEY (CategoryID)
);
Table structure for table 'city'
CREATE TABLE city (
City varchar(100) DEFAULT '' NOT NULL ,
CityID bigint(20) DEFAULT '' NOT NULL auto_increment,
PRIMARY KEY (CityID)
);
Table structure for table 'items'
CREATE TABLE items (
ItemSKU varchar(25) DEFAULT '' NOT NULL ,
ItemName varchar(100) DEFAULT '' NOT NULL ,
ItemDescription mediumtext DEFAULT '' NOT NULL ,
PostCode varchar(100) DEFAULT '' NOT NULL ,
Category bigint(20) DEFAULT '0' NOT NULL ,
CityID bigint(20) DEFAULT '0' NOT NULL ,
CTelephone varchar(100) DEFAULT '' NOT NULL ,
ItemID bigint(20) DEFAULT '' NOT NULL auto_increment,
PRIMARY KEY (ItemID)
);
The form that is sending the request is this:
form action='/companies.php' method='POST' name='CompanySearch'
input type='hidden' name='Search' value='YES' /
input type='hidden' name='CompanySearch' value='Simple' /
input type='text' class='menuForm' name='ANY' value='Keywords'
maxlength='40' size='13' /
?
require(connection.php);
mysql_connect($DBHost, $DBUser, $DBPass) or
die(could not connect);
mysql_select_db($DBName);
echo select name=\CityID\ size=\1\ class='menuForm';
$result=mysql_query(SELECT City, CityID FROM city ORDER BY City);
while ($row = mysql_fetch_array($result)) {
echo option value=\$row[1]\ $row[0] /option;
}
echo /select;
?
?
mysql_connect($DBHost, $DBUser, $DBPass) or
die(could not connect);
mysql_select_db($DBName);
echo select name=\Category\ size=\1\ class='menuForm';
$result=mysql_query(SELECT Category, CategoryID FROM category ORDER BY
Category);
while ($row = mysql_fetch_array($result)) {
echo option value=\$row[1]\ $row[0] /option;
}
echo /select;
?
/td
/tr
tr class=navTable
td class=bgColorMid
table cellpadding=0 cellspacing=0 border=0 width=100%trtd
valign=bottom/td
td align=right
a href=companies.php class=submitButtonSearch/a
a href=companies.php class=submitButton
img src=search.gif border=0 align=absmiddle vspace=1 hspace=1/a
/tr/table
/td
/tr
/form
This is driving me nuts can anyone see what I have missed please?
Andrew
-
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
FW: Newbie question...
The table type HEAP is in MEMORY table so if you turn off or cash you loss your data. The up side is speed. Try table type = MyISAM Simon -Original Message- From: Fernando Morais [mailto:[EMAIL PROTECTED] Sent: 25 February 2003 13:43 To: Simon Green Subject: Re: Newbie question... Well i've created the tables using the MySQL control center. The program that is inserting the data, is a program develop by me in delphi. But it work fines. If i insert some data and go to mySQL Control Center the data is there. All fields with no problem. I installed mySQL server in 2 different pc's, with the same problem. Every time i stop the service, all data is gone. The tables type is HEAP. They're located at /mysql/data/ - Original Message - From: Simon Green [EMAIL PROTECTED] To: 'Fernando Morais' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, February 25, 2003 1:30 PM Subject: RE: Newbie question... No this is not right. How are you creating the tables? How are you entering the data? Where are you putting them? e.g. /mysql/var/your_table.frm What type of table are you using? Simon -Original Message- From: Fernando Morais [mailto:[EMAIL PROTECTED] Sent: 25 February 2003 13:29 To: [EMAIL PROTECTED] Subject: Newbie question... Hi ppl!. I'm running Mysql Server 4.0.10 in Win XP. And every time i shutdown the service, i loose all data inside the tables? Is this normal, i've i forget something? Thankz, Nando - 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: Starting mysqld within SuSE 8.0
Thomas Spahni wrote: Starting it manually with safe_mysqld runs fine. But I didn't find a way in YaST to start the daemon on boot, and manually adding it to the /etc/init.d/boot.d/ lead me into a crash. You may enable the start of mysql with the yast2 runlevel editor. Works fine for me on SuSE 8.0 even after compiling and installing newer versions of MySQL. Yes, it worked fine with the runlevel editor -- i.e., after I removed the remains of a workaround I tried to install a few months ago. ;-) As it seems, this one caused the crash I had. However make sure to keep the same directory tree as SuSE. Thanks, that's good to know when I'm going to upgrade from the SuSE CD version of MySQL to a more recent version. Best, Markus - 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: redirect mysql output to file
echo MYSQL_STATEMENT | mysql -u user_name -p database_name /path/to/file this should work fine on command line . cheers David Ziggy Lubowa Network Engineer One2net (U) web: www.one2net.co.ug Tel: +256 41 345466 --- Every minute is an occasion to change your life -Original Message- From: Mike Doanh Tran [mailto:[EMAIL PROTECTED] Sent: Monday, February 24, 2003 8:51 PM To: [EMAIL PROTECTED] Subject: redirect mysql output to file Hi, How do i redirect a mysql output to a file from the command line? For example, I want to save DESCRIBE test_table test_table.file without doing a MYSQLDUMP. thanks, MT - 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
Nearly solved - Strange Bug with a working table - Silent col-def-change !
OK, I found out, why the table grows that extraordinary. After 'CREATE TABLE new_1 SELECT * FROM output_1'; All columns of new_1 are CHAR(255) instead of VARCHAR(255) like in output_1 ( see below). Now my simple questions are: 1. Why , I saw something about silent changes in the docs, but there it says VARCHAR columns with a length less than four are changed to CHAR. If any column in a table has a variable length, the entire row is variable-length as aresult. Therefore, if a table contains any variable-length columns (VARCHAR, TEXT, or BLOB), all CHAR columns longer than three characters are changed to VARCHAR columns. Which doesn't fit here. Did I miss something in the docs ? 2. Is there a way to prevent a table from being changed that way without 'altering' all Columns aftwerwards. I thought of the dirty thing to insert a BLOB-Type as first column and delete it, which works fine but is there a better way ? And again Did I miss something in the docs ? Just point me there please I am usally a rtfm-freak. nearly happy but not really satisfied Klaus The table output_1 has this structure: Field TypeNullKey af_1int(11) YES MUL af_3varchar(255)YES af_2varchar(255)YES af_23 varchar(255)YES af_10 varchar(255)YES af_11 varchar(255)YES af_10001varchar(255)YES af_16 varchar(255)YES af_9varchar(255)YES af_8varchar(255)YES af_30 varchar(255)YES af_24 varchar(255)YES af_52 varchar(255)YES af_300 varchar(255)YES af_53 varchar(255)YES af_54 varchar(255)YES af_18 varchar(255)YES af_5varchar(255)YES af_25 varchar(255)YES af_26 varchar(255)YES af_27 varchar(255)YES af_28 varchar(255)YES af_55 varchar(255)YES af_56 varchar(255)YES af_57 varchar(255)YES af_58 varchar(255)YES dub_flagint(11) YES MUL dub_kopfint(11) YES dub_purge int(11) YES Type = myisam MySQL = 3.23-41-log OS = SUSE 7.3 Kernel 2.4.10 FS = Reiser This table has about 2,5 million rows and it's file-size 530543 K. When i tried the above statement i got error 27 when the new table reached a size of more then 200 K. I exported the file to csv and everything seemed fine. I imported again into a new table via LOAD DATA INFILE ... and the same error occured. Is there anyone that has a clue, why this table is changing size with this. Could it be that there is a 'forbidden' character inside the data ? I now try to manage with dump-file but I'd like to know how I can fix the problem itself, because if I join this table with another, the same strange behaviour occurs. CHECK TABLE (extended) said the output_1-Table is OK. please help Klaus Topaktuelle Consumer-Adressen anmieten www.consumeradressen.de Diese Mail ist von: Deutsche Post Direkt GmbH Beleglese Center Mannheim Klaus Franz Manager Abgleichsysteme Willy-Brandt-Platz 13 Tel. 06 21.129 56 436 68161 Mannheim - 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: Replication problem (alter table fails)
Egor, I am sorry, my bad. I misrepresented the versions of mysql I am using. Must have been a typo. Here is what I am using. Master: Sparc Solaris 7 MySQL 4.0.9-gamma-log Slave: RedHat Linux 7.2 MySQL 4.0.8-gamma-log. Could you continue to help me with this ? Thanks, floyd -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 25, 2003 8:28 AM To: [EMAIL PROTECTED] Subject: re: Replication problem (alter table fails) On Tuesday 25 February 2003 14:17, Kirill Peskov (WEB-EU) wrote: Coud you, please, give an advice to solve following problem: I've got two Mysql Servers: * Master: Sparc Solaris 8, MySQL 3.23.32 * Slave: RedHat Linux 7.2, MySQL 3.23.32 Replication of data runs fine, all insert into and delete from made on master successfully change the slave database. Creation and dropping of the whole tables also work fine. But if I add or delete certain column in any table on master DB (e.g. run ALTER TABLE commands), slave ignores is and later on stops replication because it cannot replicate the data appeared or changed on the master afterwards (because these fields not exist on the slave). Is there any way to tell either Master or Slave to replicate ALTER TABLE queries as well? Since 3.23.32 there were a lot of bug fixed related to the replication. Please, upgrade servers and test it again. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.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 - 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: Newbie question...
OK! Thankz... It worked. I dudn't realized that issue when i read the mySQL manual. - Original Message - From: Simon Green [EMAIL PROTECTED] To: Mysql (E-mail) [EMAIL PROTECTED] Sent: Tuesday, February 25, 2003 1:45 PM Subject: FW: Newbie question... The table type HEAP is in MEMORY table so if you turn off or cash you loss your data. The up side is speed. Try table type = MyISAM Simon -Original Message- From: Fernando Morais [mailto:[EMAIL PROTECTED] Sent: 25 February 2003 13:43 To: Simon Green Subject: Re: Newbie question... Well i've created the tables using the MySQL control center. The program that is inserting the data, is a program develop by me in delphi. But it work fines. If i insert some data and go to mySQL Control Center the data is there. All fields with no problem. I installed mySQL server in 2 different pc's, with the same problem. Every time i stop the service, all data is gone. The tables type is HEAP. They're located at /mysql/data/ - Original Message - From: Simon Green [EMAIL PROTECTED] To: 'Fernando Morais' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, February 25, 2003 1:30 PM Subject: RE: Newbie question... No this is not right. How are you creating the tables? How are you entering the data? Where are you putting them? e.g. /mysql/var/your_table.frm What type of table are you using? Simon -Original Message- From: Fernando Morais [mailto:[EMAIL PROTECTED] Sent: 25 February 2003 13:29 To: [EMAIL PROTECTED] Subject: Newbie question... Hi ppl!. I'm running Mysql Server 4.0.10 in Win XP. And every time i shutdown the service, i loose all data inside the tables? Is this normal, i've i forget something? Thankz, Nando - 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
Trouble with db ID
Hi guys, I was wondering if you can help me or push me in the right direction with this query. I have two databases; a db of recording_global data and a db of dj_global data. What I want to do is sort the recording_global data by dj_global_name which I will source from the dj_global db with the recording_global_dj_id that is in the recording_global db. I have included the schema of the two tables here: --8-- # # Table structure for table `dj_global` # CREATE TABLE dj_global ( dj_global_id mediumint(8) NOT NULL auto_increment, dj_global_name varchar(50) NOT NULL default '', dj_global_website varchar(255) NOT NULL default '', dj_global_dob date NOT NULL default '-00-00', dj_global_country_id mediumint(8) NOT NULL default '0', dj_global_city_id mediumint(8) NOT NULL default '0', PRIMARY KEY (dj_global_id) ) TYPE=MyISAM; # # Table structure for table `recording_global` # CREATE TABLE recording_global ( recording_global_id mediumint(8) NOT NULL auto_increment, recording_global_dj_id mediumint(8) NOT NULL default '0', recording_global_event_id mediumint(8) NOT NULL default '0', recording_global_venue_id mediumint(8) NOT NULL default '0', recording_global_city_id mediumint(8) NOT NULL default '0', recording_global_link varchar(255) NOT NULL default '0', recording_global_date date NOT NULL default '-00-00', recording_global_expirydate date NOT NULL default '-00-00', recording_global_counter mediumint(8) NOT NULL default '0', PRIMARY KEY (recording_global_id) ) TYPE=MyISAM; Any help much appreciated. Ian Roke Demand Planning American Standard Companies - Hull, UK - 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
CPUUsage
Hi! I have a very intensive traffic MySQL server, with a average usage of cpu of 70%, and i think is time to upgrade this machine, my questions are about will help adding a second processor to this machine?, or mysql will not take the advantage of this second processor. Upgrading from 3.23.43 (current version) to 4.x version will help?, any advice will help. Thanks! -- -- |Juan Enrique Gomez Perez | CEO CTO |Metropoli2000 Networks, S.L. | Phone: +34 914250023 Fax: +34 914250136 | email: [EMAIL PROTECTED] -- PGP Fingerprint: 6B39 3A2B A17B 1E8E CFFD FC14 678E 0A22 BD80 C486 Public Key: http://pgp.mit.edu:11371/pks/lookup?op=getsearch=0xBD80C486 If this message hasn't a correct signature please notify it to [EMAIL PROTECTED] To get the public key please use the above url. Thanks for your help. -- - 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: CPUUsage
On Tuesday 25 Feb 2003 3:27 pm, Juan Enrique Gómez wrote: I have a very intensive traffic MySQL server, with a average usage of cpu of 70%, and i think is time to upgrade this machine, my questions are about will help adding a second processor to this machine?, or mysql will not take the advantage of this second processor. What Operating system are you using? Have you made sure you have indexed all your tables correctly? When I developed my first mysql application it was using 70% of the cpu doing about 10,000 page views a day. Is is now doing about 120,000 a day and is running about 20-30% on the same box. I achevied this by adding proper indexes and also using sessions and cookies to store constantly used data. Upgrading from 3.23.43 (current version) to 4.x version will help?, any advice will help. Query caching may help Cheers John Wards SportNetwork.net - 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 and Configuration
On Saturday 22 February 2003 22:48, Bruce Feist wrote: I'm a newcomer to MySQL, and I'm having trouble. I've installed MySQL under RedHat 7.1 Linux, and I can't actually use it; I get authorization error messages when I try. In particular, I understand that initially a 'root' user is set up without a password. I can't connect to the database as 'root' with: mysql -u root mysql but I get access denied messages. I tried wiping out the security data and recreating it with: mysql_install_db but that didn't seem to improve matters. Any ideas of what I'm doing wrong? Seems 'root' already has a password :) If you already have privilege table mysql_install_db doesn't recreate them. You must remove old privilege table at first and then create new or you can start MySQL server with --skip-grant-tables option: http://www.mysql.com/doc/en/Resetting_permissions.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.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: Newbie question...
On Tuesday 25 February 2003 15:28, Fernando Morais wrote: I'm running Mysql Server 4.0.10 in Win XP. And every time i shutdown the service, i loose all data inside the tables? Is this normal, i've i forget something? What table types do you use? HEAP or any others? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.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: Different User, Different datadir
On Sunday 23 February 2003 02:19, Robert Mark Bram wrote: I would like to create a user that will only access my current project's database. Use GRANT command to give grants to user only for certain database. I would also like to store the data for my current project's database in a particular location. Can I use my.ini to do this? For example, - user = newProject - pwd = newProject - datadir=C:/newProject/MySqlData When newProject user logs in, she automatically USES a database called 'newProject' for example... You can use the following entries user=user_name password=user_password database=database_name and user can connect as user 'user_name' with password 'user_password' to the database 'database_name'. My second question: can this work for InnoDB tables? I am using *only* InnoDB tables.. You can have several innodb table spaces, but they are used by all users. You can't create table space per database or per user. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.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: Re: table row result spool to file
On Tuesday 25 February 2003 15:50, g gnanaraj wrote: Thanks but I'm not getting the expected result. See the following: [quote] [EMAIL PROTECTED] godson]$ cat chk5.sh mysql -e select * from baa into outfile \/home/godson/run.sh\; test [EMAIL PROTECTED] godson]$ ./chk5.sh ERROR 1045 at line 1: Access denied for user: '@localhost' (Using password: NO) [EMAIL PROTECTED] godson]$ [/quote] Any ideas ? You must have FILE privilege to use SELECT ... INTO OUTFILE. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.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: RE: Replication problem (alter table fails)
On Tuesday 25 February 2003 16:36, Floyd Wellershaus wrote: Egor, I am sorry, my bad. I misrepresented the versions of mysql I am using. Must have been a typo. Here is what I am using. Master: Sparc Solaris 7 MySQL 4.0.9-gamma-log Slave: RedHat Linux 7.2 MySQL 4.0.8-gamma-log. Could you continue to help me with this ? I tested on 4.0.10 .. What replication options do you have in my.cnf? Do you use any replicate-* options? Could you provide a test case? -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 25, 2003 8:28 AM To: [EMAIL PROTECTED] Subject: re: Replication problem (alter table fails) On Tuesday 25 February 2003 14:17, Kirill Peskov (WEB-EU) wrote: Coud you, please, give an advice to solve following problem: I've got two Mysql Servers: * Master: Sparc Solaris 8, MySQL 3.23.32 * Slave: RedHat Linux 7.2, MySQL 3.23.32 Replication of data runs fine, all insert into and delete from made on master successfully change the slave database. Creation and dropping of the whole tables also work fine. But if I add or delete certain column in any table on master DB (e.g. run ALTER TABLE commands), slave ignores is and later on stops replication because it cannot replicate the data appeared or changed on the master afterwards (because these fields not exist on the slave). Is there any way to tell either Master or Slave to replicate ALTER TABLE queries as well? Since 3.23.32 there were a lot of bug fixed related to the replication. Please, upgrade servers and test it again. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.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: mysql 4.0.11
On Friday 21 February 2003 19:05, Reetz Wendy wrote: Does anyone know when the release date for the mysql 4.0.11 version? I was just about to rebuild everything (apache,php,etc), but if it's next week, I'd rather wait for it. You can find 4.0.11 at: http://www.mysql.com/downloads/mysql-4.0.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.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
two servers on the same machine
Hi all, I have two servers on the same machine (Windows 2000). In the file my.ini i need to write new group for mysqld2. 1) Do i need to change the name of mysqld itself (to mysqld2)? 2) On Windows, is it enough that the port will be different between the servers, or there is something else need to be different? (beside the basedir, datadir and logs) Thanks _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail - 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.sock
Hi friends, I'm just starting to use MySQL for Linux. I installed it yesterday and it worked, but after restarting the computer it doesn't work anymore. When I type mysql at the linux prompt it says:ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'. I've read in the manual that this socket is sometimes deleted, but what can I do to get it working again. Thanks for your help. NICOLAS - 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
Starting MySQL Server
MySQL List, In Linux, I use: [EMAIL PROTECTED] bin]$ safe_mysqld --user=user to start the MySQL Server where user is a user in the database. When this happens, the terminal that I start it in become unusable. Is this by design? Also, is there a way to make it where anyone that starts the server has to use a password? Thanks, Jeremy Whitlock --- MCP/MCSA IT Manager for Star Precision, Inc. Phone: (970) 535-4795 Metro: (303) 926-0559 Fax: (970) 535-0780 Metro Fax: (303) 926-0559 http://www.starprecision.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
my_error.c
I'm not able to successfully complete make on mysql, I think I'm using mysql version 3.23. I'm using gnu's complier and make, I'm not using the Compaq C++ compilier. Thank you very much. Tru64 v5.1a CC=GCC CXX=GCC gcc version 2.97 GNU Make version 3.79.1 my_error.c: In function `my_error': my_error.c:72: parse error before char my_error.c:72: parse error before char my_error.c:72: parse error before ')' token my_error.c:85: parse error before int my_error.c:85: parse error before int my_error.c:85: parse error before ')' token make[2]: *** [my_error.lo] Error 1 make[2]: Leaving directory `/usr/install/mysql_source/libmysql' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/usr/install/mysql_source' make: *** [all-recursive-am] Error 2 - Get a Room at http://www.lodging.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: Query from a PHP Form
Thanks to al that repsonded and helped out. i dicovered that the form itself
was not quite right and not posting the variables doh anmy way that is now fixed
all but some cosmetics :)
so the problem now returns to the query in companies.php
if someone can have a little look and I am sure this will be running in no time
at all :)
its the submit query button that returns the values the other links are dead :(
http://www.punterspower.co.uk/index.php
here is the query code...
thank you All so much
?
echo PCity $CityID Trade $Category. P\n\n;
?
?
mysql_connect($DBHost, $DBUser, $DBPass) or
die(could not connect);
mysql_select_db($DBName);
$result=mysql_query('select distinct items.* from items,city,category where
items.CityID=city.CityID and items.Category=category.CategoryID');
if (!$result) echo mysql_error();
else {
}
while ($row=mysql_fetch_row($result)) {
$IS=$row['0'];
$IN=$row['1'];
$ID=$row['2'];
$IC=$row['3'];
$Ca=$row['4'];
$City=$row['5'];
$SC=$row['6'];
$II=$row['7'];
Andrew
-
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:Question about definition and index for performance
mysql, tableA, definition: key1 char(17) not null, acct char(12), other char (5) tableB is same definiton like tableA. I add index for both tableA and tableB like: alter table tableA add index(key1, acct) I will do left join with tableA and tableB like : tableA left join on tableB on tableA.acct=tableB.acct where tableB left join on tableA on tableB.acct=tableA.acct where The tableA has 32,000,000 records and tableB has 500,00 records. I feel some thing wrong about how define the table fields, add index or something, because I only use acct field for left join on. I hope I can change some table definition or about add index to improve the performance. Also, I like to know what is difference between: alter table tableA add index(key1, acct) or alter table tableA add index(key1) alter table tableA add index(acct) Any suggestion? Thanks. - 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/InnoDB-4.0.11 is released
Hi! InnoDB is a MySQL table type that supports transactions, foreign key constraints, and a non-free hot backup tool. This is a bugfix release of the branch 4.0 which will soon be declared stable. For InnoDB the only change in 4.0.11 is the following: * Fixed a bug introduced in 4.0.10: SQL query SELECT ... FROM ... ORDER BY ... DESC could hang in an infinite loop. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.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: Starting MySQL Server
Try: safe_mysqld --user=user Bill Jeremy Whitlock wrote: MySQL List, In Linux, I use: [EMAIL PROTECTED] bin]$ safe_mysqld --user=user to start the MySQL Server where user is a user in the database. When this happens, the terminal that I start it in become unusable. Is this by design? Also, is there a way to make it where anyone that starts the server has to use a password? Thanks, Jeremy Whitlock --- MCP/MCSA IT Manager for Star Precision, Inc. Phone: (970) 535-4795 Metro: (303) 926-0559 Fax: (970) 535-0780 Metro Fax: (303) 926-0559 http://www.starprecision.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 - 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: Start MySQL along with a update statement.
Do you know that you can run mysql in batch mode? So you can achieve what you want by this. Read the below: http://www.mysql.com/doc/en/Batch_mode.html Regards, Joseph -Original Message- From: g gnanaraj [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 25, 2003 7:31 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Start MySQL along with a update statement. I need to start MySQL using a script which does the following: 1. login to MySQL 2. use a specific database 3. run a update statement 4. exit I have been able to achieve 1 2 by doing the following but not the others. mysql -D test Can anyone help me please ? Thanks. _ Get 25MB, POP3, Spam Filtering with LYCOS MAIL PLUS for $19.95/year. http://login.mail.lycos.com/brandPage.shtml?pageId=plusref=lmt plus - 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: Continuing problem
Ami, Joseph, I'm running the Windows mysqld application and attempting to connect to it using the CygWin libraries without any success. The mysql and winmysqladmin all connect fine to mysqld. The error I get from my application is 'Error 2002, cannot connect through socket MySQL' or it's about not finding port 3306 or it cannot find /tmp/mysql.sock (which is never created by the mysqld even after specifying it in my c:\my.cnf and ~/.my.cnf files). Apparently, this is a socket problem. You have no Unix socket on your Windows MySQL server through which to connect. Try to use TCP/IP, by connecting with the host specified, where host is something else but 127.0.0.1 or localhost; like this: mysql -h machine_name Where machine machine_name is the host name of your Windows machine. Regards, -- Stefan Hinz [EMAIL PROTECTED] iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 [filter fodder: sql, mysql, 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: mysql 4.0.11
Did I miss the global release message for this version? I got the InnoDB release message but no other... -Original Message- From: Victoria Reznichenko [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 25, 2003 10:53 AM To: [EMAIL PROTECTED] Subject: re: mysql 4.0.11 On Friday 21 February 2003 19:05, Reetz Wendy wrote: Does anyone know when the release date for the mysql 4.0.11 version? I was just about to rebuild everything (apache,php,etc), but if it's next week, I'd rather wait for it. You can find 4.0.11 at: http://www.mysql.com/downloads/mysql-4.0.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.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 - 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.11
Luc, - Original Message - From: Luc Foisy [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Tuesday, February 25, 2003 9:09 PM Subject: RE: mysql 4.0.11 Did I miss the global release message for this version? I got the InnoDB release message but no other... Lenz has not yet posted the general release note. You can look the changelog from: http://www.mysql.com/doc/en/News-4.0.11.html Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, row level locking, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com sql query -Original Message- From: Victoria Reznichenko [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 25, 2003 10:53 AM To: [EMAIL PROTECTED] Subject: re: mysql 4.0.11 =20 =20 On Friday 21 February 2003 19:05, Reetz Wendy wrote: =20 Does anyone know when the release date for the mysql 4.0.11=20 version? I was just about to rebuild everything (apache,php,etc), but=20 if it's next week, I'd rather wait for it. =20 You can find 4.0.11 at: http://www.mysql.com/downloads/mysql-4.0.html =20 =20 --=20 For technical support contracts, goto=20 https://order.mysql.com/?ref=3Densita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com =20 =20 =20 =20 =20 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) =20 To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail=20 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php =20 =20 - 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
Simple C API question
Maybe this is a stupid question but I couldn't find suitable sample code or an answer in the manual. mysql_fetch_row() returns a MYSQL_ROW representation of a row of data. According to the manual, this is an array of counted byte strings. mysql_fetch_field() returns a MYSQL_FIELD with members 'type' and 'length', where 'length' is the width of the field, as specified in the table definition. Question: Can I reliably interpret 'length' as the length in bytes of the corresponding byte string in the MYSQL_ROW, and is there a usual way to extract these data into regular C datatypes? Thanks, Travis - 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 v SAB DB
SAPDB doesn't have collation (i.e. case-sensitivity). Be aware of this before you make a choice. While I was trialing it, the support was exceptional with very quick response from actual SAP engineers, but the lack of case-sensitivity was a show-stopper for me. Greg - Original Message - From: Zak Greant [EMAIL PROTECTED] To: Richard Morton [EMAIL PROTECTED] Cc: MySQL List [EMAIL PROTECTED] Sent: Tuesday, February 25, 2003 11:28 PM Subject: Re: MySQL v SAB DB On Tue, Feb 25, 2003 at 11:29:23AM +, Richard Morton wrote: Hi, My fledgling product is based around a MySQL database, my _first_ customer is asking me to use SAB DB. Obviously this means a bit of re-engineering work and extensive testing. I am looking for peoples experiences of SAP DB, so that I can build a case for continueing with MySQL, (other than that the product works fine with MySQL) Does anyone have such experience. Sorry - I can't offer any real advice here. All of my experience in this area is hearsay. There was a discussion on slashdot that discussed SAPDB - however, there was a pretty high noise-to-signal ratio for the discussion. Is the support as good as MySQL? Who knows? Perhaps ask the same question on the SAPDB community list? :) From what I can see, it is a fully featured DB engine. You can use our crash-me utility to see differences in the feature set implemented between MySQL and SAPDB. This will at least give you some indication. Cheers! -- Zak Greant [EMAIL PROTECTED] MySQL AB Community Advocate Personal Blog: http://zak.fooassociates.com AdBusters: Creative Resistance to Consumerism (http://adbusters.org) - 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:Question about definition and index for performance
alter table tableA add index(key1, acct) creates a single index across the two columns. Trying to visualize the index as a sorted list (of course it is a b-tree), it will look something like: (key, acct:) 1,1 1,2 1,3 1,5 1,8 2,1 2,4 2,5 2,6 3,2 3,9 ... etc. Therefore, this index is not very useful when you are using (only) acct (the second column in the index) for your join. Instead, create the two separate indexes with alter table tableA add index(key1) alter table tableA add index(acct) This will let MySQL determine which index(es) to use for optimizing the queries. If many other queries use both key1 and acct together, you may consider hcreating all three indexes, or the composite index as well as the separate index for acct. HTH, Tore. - Original Message - From: Vivian Wang [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 25, 2003 11:52 AM Subject: mysql:Question about definition and index for performance mysql, tableA, definition: key1 char(17) not null, acct char(12), other char (5) tableB is same definiton like tableA. I add index for both tableA and tableB like: alter table tableA add index(key1, acct) I will do left join with tableA and tableB like : tableA left join on tableB on tableA.acct=tableB.acct where tableB left join on tableA on tableB.acct=tableA.acct where The tableA has 32,000,000 records and tableB has 500,00 records. I feel some thing wrong about how define the table fields, add index or something, because I only use acct field for left join on. I hope I can change some table definition or about add index to improve the performance. Also, I like to know what is difference between: alter table tableA add index(key1, acct) or alter table tableA add index(key1) alter table tableA add index(acct) Any suggestion? Thanks. - 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
Is there a way to time queries?
Folk, Two or three years ago, I was using ASP to access SQL Server 7 and MS Access databases. There was a stopwatch dll made by CapRock Software that allowed me to time various elements of my ASP scripts, particularly the database queries. I found several SQL problems that way, and made my queries much faster as a result. Is there anything similar to that stopwatch dll that I could run in my PHP scripts to check the time on my MySQL queries? I'm seeing some slowdowns, but can't quite nail them down, and would like to determine if it is PHP or MySQL that I need to address. Any help would be appreciated. Make a good day . . . . . . barn ~ Housework is what a woman does that nobody ever notices unless she doesn't do it. -- Anonymous ~ - 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
Question
Dear Sir: Could you recommend me a book for learning MySQL for the beginner. Thanks Jasdeep - 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: Question
http://www.amazon.co.uk/exec/obidos/ASIN/0735712123/qid=1046214226/sr=1-7/re f=sr_1_3_7/202-4962738-0968635 - Original Message - From: Jasdeep Singh [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 25, 2003 11:01 PM Subject: Question Dear Sir: Could you recommend me a book for learning MySQL for the beginner. Thanks Jasdeep - 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: Question
Jasdeep, Could you recommend me a book for learning MySQL for the beginner. Have a look at a variety of books recommended by MySQL AB: http://www.mysql.com/portal/books/index.html Regards, -- Stefan Hinz [EMAIL PROTECTED] iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 [filter fodder: sql, mysql, 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
Full Text Index Performance
I wanted to created a searh engine for our site with indexed content of the pages being stored in MYSQL full text index. I wanted to know how fulltext index scales if I have about 200,000 pages indexed. Is it wise to use MYSQL for this or go with other options like SWISH-e etc. - 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
index questions
I have some basic questions that are driving me nuts, and I can't find answers anywhere. I've been banging my head against the wall for hours and hours. I've searched everywhere on the internet and looked in every book I own. I can't find the information. Here are my questions. In the CREATE TABLE statement, there are options to create keys and indexes, and this is where I'm confused. I'll try to be as clear as possible in my questions because I'm really desperate for help. 1. What is the difference between a KEY and an INDEX? These are two separate options: KEY [index_name] (index_col_name,...) INDEX [index_name] (index_col_name,...) I think the difference can't be uniqueness because UNIQUE is also an option: UNIQUE [INDEX] [index_name] (index_col_name,...) 2. In the UNIQUE option above and in the FULLTEXT option, one of the optional parameters is [INDEX]. What does this mean? How is the option different if the word INDEX is included? 3. Dreamweaver generated some MySQL code that looked like this: PRIMARY KEY (CustID) KEY PRIMARY_KEY (CustID) What is the point of the second option--the KEY statement? Why create two keys on the same column? Is the KEY option necessary if you use the PRIMARY KEY option? 4. How do you use an index or key? If you use the column on which the key/index is based (are these terms interchangeable??), does MySQL use the index?? Using the above example, do I have to use the names PRIMARY or PRIMARY_KEY to use the indexed version of CustID? If I do a join using CustID, is MySQL reading the table sequentially and bypassing the index file? 5. There are two other options in the CREATE TABLE statement that I don't understand at all: [CONSTRAINT symbol] FOREIGN KEY [index_name] (index_col_name, ...) [reference_definition] CHECK (expr) My tables have foreign keys in them. Does that mean I need this FOREIGN KEY statement? If so, then how do I use it? What is the CONSTRAINT parameter? What is symbol? What is reference_definition? And finally, what is CHECK (expr)? The mysql.com manual lists these without any explanation or examples. Thank you hugely and VASTLY in advance if you can clear up these issues for me. - 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: Is there a way to time queries?
On Tue, Feb 25, 2003 at 04:36:23PM -0600, databarn wrote: Folk, Two or three years ago, I was using ASP to access SQL Server 7 and MS Access databases. There was a stopwatch dll made by CapRock Software that allowed me to time various elements of my ASP scripts, particularly the database queries. I found several SQL problems that way, and made my queries much faster as a result. Is there anything similar to that stopwatch dll that I could run in my PHP scripts to check the time on my MySQL queries? I'm seeing some slowdowns, but can't quite nail them down, and would like to determine if it is PHP or MySQL that I need to address. Hello, Check out EXPLAIN and the slow query log in the manual. Cheers! -- Zak Greant [EMAIL PROTECTED] MySQL AB Community Advocate Personal Blog: http://zak.fooassociates.com MySQL Tip: Display the option files read by the server % mysqld --help - 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: decimal type
Stitchin' wrote: Why couldn't you use float(10,2) ... just an example ... where the first number in the parentheses is the total characters for the number and the second number represents how many of those are right of the decimal point?) Computers represent data in binary format at floating point numbers are quite innaccurate. Going into the details on why is for another place and time; feel free to search Google w.r.t. floating point vs. fixed point values. When you're working with money (for example), you don't want that kind of imprecision, so DECIMAL (which doesn't use floating point values) comes into play. For one company I work with, all their values are stored as long integers for pennies. $100 is stored as 1. That way they just drop a decimal before displaying the last two digits of the value and they're all set (not using MySQL). Old versions of Quick Basic, by way of reference had this neat bug: a = 0 for i = 1 to 100 a = a + 0.01 next i print a ... printed 0.99 or 1.01 depending on your platform. -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - 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
View Warnings
Howdy all! mysqlLOAD DATA LOCAL -INFILE /Rob/architecturalScreens/prototype/v1/database/insertPart.dat -INTO TABLE part; Query OK, 496 rows affected (0.08 sec) Records: 496 Deleted: 0 Skipped: 0 Warnings: 1494 I am glad it loaded my file (it took me ages to build it)... but how do I view the warnings? Thanks! Rob :) :- :-} - 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 MySQL, MyODBC, Access 2002 and Japanese.
Don't know, but: Are you using the Japanese Access 2002? What locale is your OS configured for? HTH, Tore. - Original Message - From: Juan [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 25, 2003 6:12 AM Subject: Problem with MySQL, MyODBC, Access 2002 and Japanese. Help!, I am developing a multilingual site in English, Spanish and Japanese. I am using MySQL with PHP in the server side, and Access 2002 in the local side, using MyODBC to communicate MySQL with Access 2002. MySQL and PHP works toguether ok in Japanese, English and Spanish (using EUC_JP in both PHP and MySQL), Access 2002 (XP operating system) works ok in japanese (XP use UNICODE). The big problem is MyODBC. When I connect Access 2002 with MySQL (via MyODBC) to view the japanese characters stored in MySQL, in Access 2002 I only see a lot of strange characteres, I view the same characters without problems using phpMyAdmin. I have been several days searching the web without success. Any suggestion to solve this problem (in English or Spanish, no Japanese :-)? ___ Yahoo! Móviles Personaliza tu móvil con tu logo y melodía favorito en http://moviles.yahoo.es - 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
Build error (v3.23.55) on Solaris 2.8
When I tried to build a client only version (v3.23.55) on a Solaris2.8 machine, I got the following error: ( while doing make install) I did ./configure -without-server. It works fine. This is the error make gives. ... cc -DDEFAULT_CHARSET_HOME=\/usr/local/mysqlc\ -DDATADIR=\/usr/local/mysqlc/var\ -DSHAREDIR=\/usr/local/mysqlc/share/mysql\ -DDONT_USE_RAID -I. -I. -I.. -I./../include -I../include -I./.. -I.. -I.. -O -DDBUG_OFF -DHAVE_CURSES_H -I/usr/mysql-3.23.55/include -DHAVE_RWLOCK_T -c net.c -KPIC -DPIC -o net.o net.c, line 184: syntax error before or at: / net.c, line 184: warning: character constant too long net.c, line 186: undefined symbol: is_blocking cc: acomp failed for net.c *** Error code 1 make: Fatal error: Command failed for target `net.lo' Current working directory /usr/mysql-3.23.55/libmysql_r *** Error code 1 make: Fatal error: Command failed for target `install-recursive' Can someone help? Actually, if someone knows where I can find a client binary for Solaris 2.8, I can use it. Then I don't have to build myself. - 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: Question
If you are a TOTAL newbie and need a little programming background, I bought PHP mySQL for Dummies and it was awesome! Renee :) -Original Message- From: Stefan Hinz [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 25, 2003 6:05 PM To: Jasdeep Singh Cc: [EMAIL PROTECTED] Subject: Re: Question Jasdeep, Could you recommend me a book for learning MySQL for the beginner. Have a look at a variety of books recommended by MySQL AB: http://www.mysql.com/portal/books/index.html Regards, -- Stefan Hinz [EMAIL PROTECTED] iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 [filter fodder: sql, mysql, 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 - 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
Reference to a downloadable file
I am building a web application for my embroidery business which is basically a catalog program within a members only subscription site. On each line item, I want to have a spot for a zip file for members to click on to download the embroidery design file. I have a field in my mySql database to hold the filename of that zip file. The PHP and mySql books I have here don't have any examples of a web page with a download link and how to have it show on the detail lines being brought up with a query on a specific design category. Does anybody know of any resources on the web that may show an example of this for PHP and mySql? Renee Toth Stitchin' Up A Storm www.stitchinupastorm.com -Original Message- From: Stefan Hinz [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 25, 2003 12:37 PM To: Amy Joseph Kormann Cc: [EMAIL PROTECTED] Subject: Re: Continuing problem Ami, Joseph, I'm running the Windows mysqld application and attempting to connect to it using the CygWin libraries without any success. The mysql and winmysqladmin all connect fine to mysqld. The error I get from my application is 'Error 2002, cannot connect through socket MySQL' or it's about not finding port 3306 or it cannot find /tmp/mysql.sock (which is never created by the mysqld even after specifying it in my c:\my.cnf and ~/.my.cnf files). Apparently, this is a socket problem. You have no Unix socket on your Windows MySQL server through which to connect. Try to use TCP/IP, by connecting with the host specified, where host is something else but 127.0.0.1 or localhost; like this: mysql -h machine_name Where machine machine_name is the host name of your Windows machine. Regards, -- Stefan Hinz [EMAIL PROTECTED] iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 [filter fodder: sql, mysql, 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 - 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
Using 3.23 and Delphi 6
Hi I am currently trying to use mysql 3.23 for a database project and connect to it using a Delphi 6 front end. Can anyone tell me how the connect to a MySQL database and any other tips they might have on using Delphi 6 with MySQL. I have never used MySql before and so the information needs to be pretty specific. Hope someone can help Thanks Clive Glasgow --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.456 / Virus Database: 256 - Release Date: 18/02/2003 - 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: Reference to a downloadable file
How do you serve up the other data from the database? Are the ZIP files in a directory that is accessible from the web? In the simple case, all you need to do is create an a href=zipfileURLDownload Design/a construct in your output from the php script. So if the column returned from the MySQL query is called ZIPFile, and you have a rowset object $row, you would use something like: $DownloadURL = $row-ZIPFile; echo a href='$DownloadURL'Download Design/a; for each line item. Of course you can use an img tag instead, but the principle is the same. HTH, Tore. - Original Message - From: Stitchin' [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 25, 2003 9:34 PM Subject: Reference to a downloadable file I am building a web application for my embroidery business which is basically a catalog program within a members only subscription site. On each line item, I want to have a spot for a zip file for members to click on to download the embroidery design file. I have a field in my mySql database to hold the filename of that zip file. The PHP and mySql books I have here don't have any examples of a web page with a download link and how to have it show on the detail lines being brought up with a query on a specific design category. Does anybody know of any resources on the web that may show an example of this for PHP and mySql? Renee Toth Stitchin' Up A Storm www.stitchinupastorm.com -Original Message- From: Stefan Hinz [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 25, 2003 12:37 PM To: Amy Joseph Kormann Cc: [EMAIL PROTECTED] Subject: Re: Continuing problem Ami, Joseph, I'm running the Windows mysqld application and attempting to connect to it using the CygWin libraries without any success. The mysql and winmysqladmin all connect fine to mysqld. The error I get from my application is 'Error 2002, cannot connect through socket MySQL' or it's about not finding port 3306 or it cannot find /tmp/mysql.sock (which is never created by the mysqld even after specifying it in my c:\my.cnf and ~/.my.cnf files). Apparently, this is a socket problem. You have no Unix socket on your Windows MySQL server through which to connect. Try to use TCP/IP, by connecting with the host specified, where host is something else but 127.0.0.1 or localhost; like this: mysql -h machine_name Where machine machine_name is the host name of your Windows machine. Regards, -- Stefan Hinz [EMAIL PROTECTED] iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 [filter fodder: sql, mysql, 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 - 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: index questions
please someone answer! see below - Original Message - From: Sheryl Canter [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 25, 2003 7:07 PM Subject: index questions I have some basic questions that are driving me nuts, and I can't find answers anywhere. I've been banging my head against the wall for hours and hours. I've searched everywhere on the internet and looked in every book I own. I can't find the information. Here are my questions. In the CREATE TABLE statement, there are options to create keys and indexes, and this is where I'm confused. I'll try to be as clear as possible in my questions because I'm really desperate for help. 1. What is the difference between a KEY and an INDEX? These are two separate options: KEY [index_name] (index_col_name,...) INDEX [index_name] (index_col_name,...) I think the difference can't be uniqueness because UNIQUE is also an option: UNIQUE [INDEX] [index_name] (index_col_name,...) 2. In the UNIQUE option above and in the FULLTEXT option, one of the optional parameters is [INDEX]. What does this mean? How is the option different if the word INDEX is included? 3. Dreamweaver generated some MySQL code that looked like this: PRIMARY KEY (CustID) KEY PRIMARY_KEY (CustID) What is the point of the second option--the KEY statement? Why create two keys on the same column? Is the KEY option necessary if you use the PRIMARY KEY option? 4. How do you use an index or key? If you use the column on which the key/index is based (are these terms interchangeable??), does MySQL use the index?? Using the above example, do I have to use the names PRIMARY or PRIMARY_KEY to use the indexed version of CustID? If I do a join using CustID, is MySQL reading the table sequentially and bypassing the index file? 5. There are two other options in the CREATE TABLE statement that I don't understand at all: [CONSTRAINT symbol] FOREIGN KEY [index_name] (index_col_name, ...) [reference_definition] CHECK (expr) My tables have foreign keys in them. Does that mean I need this FOREIGN KEY statement? If so, then how do I use it? What is the CONSTRAINT parameter? What is symbol? What is reference_definition? And finally, what is CHECK (expr)? The mysql.com manual lists these without any explanation or examples. Thank you hugely and VASTLY in advance if you can clear up these issues for me. - 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
Single Quote messing up WHERE ordering
These two work fine: SELECT * FROM ggSubmissions,ggSubEx WHERE ggSubmissions.GGsID != '1673' AND ggSubmissions.GGsID = ggSubEx.GGsID AND ggEID=51 AND WorkTitle Aerial - Manly Beach Surfers 1 - Sydney, Australia, February 2003 ORDER BY WorkTitle ASC LIMIT 1 SELECT * FROM ggSubmissions,ggSubEx WHERE ggSubmissions.GGsID != '1674' AND ggSubmissions.GGsID = ggSubEx.GGsID AND ggEID=51 AND WorkTitle Aerial - Manly Beach Surfers 2 - Sydney, Australia, February 2003 ORDER BY WorkTitle ASC LIMIT 1 But these don't work -- the second passes back to the first instead of continuing in alphabetical order: SELECT * FROM ggSubmissions,ggSubEx WHERE ggSubmissions.GGsID != '1686' AND ggSubmissions.GGsID = ggSubEx.GGsID AND ggEID=51 AND WorkTitle Airborne - Shepherd\'s Warning 1 - Pacific Ocean, December 2002 ORDER BY WorkTitle ASC LIMIT 1 SELECT * FROM ggSubmissions,ggSubEx WHERE ggSubmissions.GGsID != '1687' AND ggSubmissions.GGsID = ggSubEx.GGsID AND ggEID=51 AND WorkTitle Airborne - Shepherd\'s Warning 2 - Pacific Ocean, December 2002 ORDER BY WorkTitle ASC LIMIT 1 == The only difference I could find is the ' in the second WorkTitle -- I tried stripslashes (no \ before the ') but that didn't help. Is this a mySQL bug? mySQL version 3.23.42 Thanks, -- Michael - 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
startingMySQL with InnoDB on Red Hat
Hi All, I'm quite a novice with Mysql and more than a newbee with Linux but I managed to install Red Hat on an x86 and installed MySQl too. Now I need to have InnoDB support. I installed MySQl on my notebook too (winxp) and edited my.cnf to start innodb and set all the required params. I use my notebook for testing... The problem is that using the same my.cnf (at least the same params for InnoDB) in the my.cnf on the linux box doe not start MySQL. The Service fails. whereas on the xp machine it does... very well! Any help GREATLY appreciated. I still cannot understand why it won't work. My only guess is that onnodb does not have the approprioate permissions to read/write or something like that. Below is my my.cnf [mysql] section InnoDB part innodb_data_file_path = ibdata1:10M:autoextend set-variable = innodb_buffer_pool_size=70M set-variable = innodb_additional_mem_pool_size=10M set-variable = innodb_log_file_size=20M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 Thanks for the help. Paul - 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: index questions
If my answers are too basic, please accept my apology. 1: There is no difference: KEY is a synonym for INDEX. 2: In a syntax description, the use of [square] brackets means that the part in brackets is optional. Whether you include it or not doesn't change the semantics. 3: The PRIMARY KEY is a special index that: * Has to be UNIQUE * Can not be NULL * There can only be one PRIMARY KEY on a table (biut multiple columns can be part of the primary key). I don't know why Dreamweaver adds the KEY PRIMARY KEY definition. There are different ways to define the primary key, AFAIK. 4: The query optimizer will determine which index(es) is (are) likely to provide the best results (most efficient query execution) for your query. As a rule of thumb, index columns that are frequently used in joins and/or where clauses. If you use a function on an indexed column in such a clause, do NOT expect the index to be usable - so avoid using functions on columns in those cases. AFAIK, in v.4.x you can specify hints in your query if the optimizer does not select the best index for a particular query. The name of an index does not determine whether it gets used or not. There are several factors that contribute to which index(es) are used for each query. I am not familiar with MySQL's query optimizer algorithm. 5: I'm not sure if any other types of tables implemenrt this in a later version, but AFAIK the FOREIGN KEY in MySQL used to be there only for compatibility, but had no real impact on the database. In MySQL Server 3.23.44 and up, InnoDB tables support checking of foreign key constraints. Theoretically, a FOREIGN KEY is a constraint that is placed on a column/index. It means that the column references a (matching) column (usually the primary key) in another table. The FOREIGN KEY represents the child in a parent/child relationship between two tables. To visualize this, consider a simple Department/Employee table relationship: Departments (DeptID, DeptName) 1, Sales 2, Accounting 3, Personnel 4, RD 5, Manufacturing Employees (EmpID, EmpName, DeptID) 1, Johnny, 3 2, Sammy, 2 3, Terry, 1 4, Sandy, 1 5, Jeannie, 4 6, Billy, 5 7, Stevie, 5 ...etc. You would have the Employees.DeptID defined as a FOREIGN KEY referencing Departments.DeptID. This constraint/restriction means that you will not be allowed to insert or update a row in Employees where the Dept column did not contain a value already existing in the Departments table. It also means you will not be allowed to update the DeptID in the Departments table (or delete a row) if there are dependent rows in the related (Employees) table. The different actions that you can specify with this constraint determine how MySQL will react if you violate the restriction (constraint). Action CASCADE means that a change to the master table will also be applied (CASCADEd) to the child table, i.e. related values will be updated or deleted. AFAIK, action RESTRICT means you'll be denied these actions (error generated and statement not performed). I'm not sure what the SET NULL | NO ACTION | SET DEFAULT actions do, but you can guess... The FORIGN KEY statement is there to implement referential integrity in the database through declarative rules. Of course, you can be sloppy and just not declare the relationships, just construct your queries as if the data is OK... But I won't recommend it. 5b: I'm not sure if this is still true, but AFAIK, the CHECK constraint in MySQL used to be there only for compatibility, but had no real impact on the database. The CHECK (expression) is a constraint on what values are legal in a particular column (or potentially combinations of values in a row). A general description of CHECK Constraints can be fund at http://www.datanamic.com/support/ta001.html. I have been unable to verify whether the CHECK constraint is actually implemented with any table types or in any versions of MySQL. HTH, Tore. - Original Message - From: Sheryl Canter [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 25, 2003 7:07 PM Subject: index questions I have some basic questions that are driving me nuts, and I can't find answers anywhere. I've been banging my head against the wall for hours and hours. I've searched everywhere on the internet and looked in every book I own. I can't find the information. Here are my questions. In the CREATE TABLE statement, there are options to create keys and indexes, and this is where I'm confused. I'll try to be as clear as possible in my questions because I'm really desperate for help. 1. What is the difference between a KEY and an INDEX? These are two separate options: KEY [index_name] (index_col_name,...) INDEX [index_name] (index_col_name,...) I think the difference can't be uniqueness because UNIQUE is also an option: UNIQUE [INDEX] [index_name] (index_col_name,...) 2. In the UNIQUE option above and in the FULLTEXT option, one of the optional parameters is [INDEX]. What
Help needed with SQL...
Hi All, I'm having problems creating a query to return a recordset from the following situation: I have two tables, one which contains member details, and the other which contains details re: the groups to which the member belongs. When a member logs into a particular part of my site, I want to show them the details of the other people who belong to the same groups they do. Let's say my Members table looks like this: memberid, membername, memberemail 1, john doe, [EMAIL PROTECTED] 2, jane doe, [EMAIL PROTECTED] 3, joe bloggs, [EMAIL PROTECTED] 4, inigo montoya, [EMAIL PROTECTED] And my Groups table looks like this: groupname, memberid group1, 1 group1, 2 group2, 1 group2, 4 group3, 3 So, if I passed the query the memberid value of '1', I'd like to return a a unique records recordset of: 1, john doe, [EMAIL PROTECTED] 2, jane doe, [EMAIL PROTECTED] 4, inigo montoya, [EMAIL PROTECTED] Can anyone help me work out how to achieve this? Many thanks in advance! Regards and best wishes, Murray Wells - 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: phpMyadmin
Using PhpMyAdmin for administering MySQL, can this product be installed on a remote system? We currently have it installed on the same server as MySQL, but now the programmer wants it on his Laptop. Or is there another product that can manage a MySQL database from either a Windows or Linux laptop/desktop. Thanks Jon L. Miller, MCNE, CNS Director/Sr Systems Consultant MMT Networks Pty Ltd http://www.mmtnetworks.com.au I don't know the key to success, but the key to failure is trying to please everybody. -Bill Cosby - 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: phpMyadmin
phpMyAdmin can admin. database that is not on the same machine. The only requirement is that machine can access the MySQL database to be admin. Which usually means that a user name and a ip address on the MySQL user table. However, I don't think that it is appropiate to have a notebook to install a phpMyAdmin and admin. a remote database. First of all, the notebook should have a web server installed. Secondly, there may be a security loop holes to have a remote user for a MySQL database. Esp., if the notebook used for the programmer on the move. He may just access the phpMyAdmin on the host by IE. If further security is required (esp. on the move), you may consider to have SSL installed. You may also consider some secure shell such as ssh which can also provide secure connection. Regards, -- Yours, KH Chiu CA Computer Consultants Ltd. Tel: 3104 2070 Fax: 3010 0896 Email: [EMAIL PROTECTED] Website: www.caconsultant.com Using PhpMyAdmin for administering MySQL, can this product be installed on a remote system? We currently have it installed on the same server as MySQL, but now the programmer wants it on his Laptop. Or is there another product that can manage a MySQL database from either a Windows or Linux laptop/desktop. Thanks Jon L. Miller, MCNE, CNS Director/Sr Systems Consultant MMT Networks Pty Ltd http://www.mmtnetworks.com.au I don't know the key to success, but the key to failure is trying to please everybody. -Bill Cosby - 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- [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: Using 3.23 and Delphi 6
Try zeos lib at http://zeoslib.sourceforge.net/ [EMAIL PROTECTED] wrote: Hi I am currently trying to use mysql 3.23 for a database project and connect to it using a Delphi 6 front end. Can anyone tell me how the connect to a MySQL database and any other tips they might have on using Delphi 6 with MySQL. I have never used MySql before and so the information needs to be pretty specific. Hope someone can help Thanks Clive Glasgow --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.456 / Virus Database: 256 - Release Date: 18/02/2003 - 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 -- Veysel Harun Sahin [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
