Re: Accessing multiple indexes
Orr, Friday, July 26, 2002, 12:13:17 AM, you wrote: O It's my understanding that MySQL will only use one index per table on a O given query. For example... O SELECT * FROM HUGE_TABLE O WHERE col1 = val1 O AND col2 val2 O AND col3 val3 ; O If col1, col2, and col3 are indexed the query can only use one index, right? O Single index access is a problem when you very large tables. What if you O have a query with a result set of just 10 rows but there are no indexed O columns that can limit the result set to 1 million rows? I really need to O be able to use multiple indexes in a single table query and I don't want to O have to perform self joins or create temp tables. Create index on several columns: http://www.mysql.com/doc/M/u/Multiple-column_indexes.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: Czech complex character set
Hi, I would like to get the Chech complex character set. Where can I find it? Thanks, Daniel SQL If you need a Windows ASCII dump, is little lower. http://pisma.webz.cz/ is link for download some czech fonts - (I think, that is already needed too for right mapping) MrQuinn 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 ! 34 35 # 36 $ 37 % 38 39 40 ( 41 ) 42 * 43 + 44 , 45 - 46 . 47 / 48 0 49 1 50 2 51 3 52 4 53 5 54 6 55 7 56 8 57 9 58 : 59 ; 60 61 = 62 63 ? 64 @ 65 A 66 B 67 C 68 D 69 E 70 F 71 G 72 H 73 I 74 J 75 K 76 L 77 M 78 N 79 O 80 P 81 Q 82 R 83 S 84 T 85 U 86 V 87 W 88 X 89 Y 90 Z 91 [ 92 \ 93 ] 94 ^ 95 _ 96 ` 97 a 98 b 99 c 100 d 101 e 102 f 103 g 104 h 105 i 106 j 107 k 108 l 109 m 110 n 111 o 112 p 113 q 114 r 115 s 116 t 117 u 118 v 119 w 120 x 121 y 122 z 123 { 124 | 125 } 126 ~ 127 128 ? 129 130 , 131 f 132 133 . 134 ? 135 ? 136 ^ 137 ? 138 S 139 140 S 141 T 142 Z 143 Z 144 145 ' 146 ' 147 148 149 . 150 - 151 - 152 ~ 153 T 154 s 155 156 s 157 t 158 z 159 z 160 161 ? 162 ? 163 L 164 ¤ 165 A 166 ¦ 167 § 168 ¨ 169 © 170 S 171 « 172 ¬ 173 174 ® 175 Z 176 ° 177 ± 178 ? 179 l 180 ´ 181 µ 182 ¶ 183 · 184 ¸ 185 a 186 s 187 » 188 L 189 ? 190 l 191 z 192 R 193 Á 194 Â 195 A 196 Ä 197 L 198 C 199 Ç 200 C 201 É 202 E 203 Ë 204 E 205 Í 206 Î 207 D 208 D 209 N 210 N 211 Ó 212 Ô 213 O 214 Ö 215 × 216 R 217 U 218 Ú 219 U 220 Ü 221 Ý 222 T 223 ß 224 r 225 á 226 â 227 a 228 ä 229 l 230 c 231 ç 232 c 233 é 234 e 235 ë 236 e 237 í 238 î 239 d 240 d 241 n 242 n 243 ó 244 ô 245 o 246 ö 247 ÷ 248 r 249 u 250 ú 251 u 252 ü 253 ý 254 t 255 ? - 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: ALTER TABLE and REFERENCES
Chris, Thursday, July 25, 2002, 11:52:44 PM, you wrote: CD Is there any plane to implement the REFERENCES function for foreign keys CD on the alter table command.or is it implemented? If it is what CD version of mysql? If you mean problem with ALTER TABLE and CREATE INDEX wich removed all foreign key constraints, it was fixed in 3.23.50 http://www.mysql.com/doc/S/E/SEC447.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
String collating support
Hi, I've read in the MySQL manual that If the sorting rules for your language are too complex to be handled with the simple sort_order[] table, you need to use the string collating functions I also read that the best documentations about how to use this feature are the already implemented character sets. (czech, gib5, gbk, sjis, tis160) So, my native language is in this category. Can somebody help me, how to create character sets using this feature? Thanks, Daniel SQL - 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: MySQL Client Mac OS X 10.2 (Jaguar: Build 6C106)
At 13:24 +0100 7/26/02, Ian Fieldhouse wrote: Hi, Is anybody else having a problem using the MySQL client with Mac OS X 10.2 (Jaguar: Build 6C106)? When I try to connect to the server on 'localhost' I get the following: dyld: ./bin/mysql Undefined symbols: ./bin/mysql undefined reference to _BC expected to be defined in /usr/lib/libSystem.B.dylib ./bin/mysql undefined reference to _PC expected to be defined in /usr/lib/libSystem.B.dylib ./bin/mysql undefined reference to _UP expected to be defined in /usr/lib/libSystem.B.dylib Trace/BPT trap If I then try to connect to the same server from another machine I get the following: ERROR 2003: Can't connect to MySQL server on server ip address (61) A socket problem of some sort??? The strange thing is I can connect using 'phpMyAdmin' without a problem from both machines. Just for the record I'm using binary of MySQL 3.23.51 obtained from http://www.entropy.ch. Binary builds often break when tried with a newer version of Mac OS X than the one they were built on. Can you try building from source? Any ideas? Cheers, Ian - 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 type of datetime timestamp same??
btw folks, not wanting but already hijaking the thread: I have a table with one timestamp(14) column and several other varchar(5) columns. How do I select rows from that table using two strings formated as MMDDhhmmss and using SQLBindParameter? I´m more interested in how setup the SQLBindParameter function for it. I´ve tried this many different ways already, with no sucess, so any help would be greatly appreciated. - Mateus Begossi - Original Message - From: Peter [EMAIL PROTECTED] To: Jenny Christy [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, July 25, 2002 2:44 AM Subject: Re: Is type of datetime timestamp same?? Hi Jenny, The formatting are the same -MM-DD HH: - The timestamp field is set automatic by the system when updating a record. The date/time fields are for Your control and usage. Take a look in the manual 6.2.2.2 The DATETIME, DATE, and TIMESTAMP Types Best regards Peter - Original Message - From: Jenny Christy [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, July 25, 2002 6:22 AM Subject: Is type of datetime timestamp same?? Hello All, I m using mysql 3.23.42 and myodbc 3.51 on linux7.2. I use SQLDescribeCol API to get type of column(field). When i call above functuon it returns type of datetime and timestamp is 93 for both. but the format of inserting datetime value uses ( )and timesstamp value is different. I m having a problem how can I distinguish them so that I can insert the data in correct format.or is there any bug in myodbc driver. Thanx in advance for ur kind help. Rgds, Jenny __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com - Please check http://www.mysql.com/Manual_chapter/manual_toc.html; before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. - Please check http://www.mysql.com/Manual_chapter/manual_toc.html; before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. - 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: Do you run multiple servers on WIndows?
What about running multiple mysql in console mode instead of service? Another concern would be how to tell each mysql to read a specified config file instead of having them all read the same one in the window\winnt folder. Regards, Michael - Original Message - From: Bhavin Vyas [EMAIL PROTECTED] To: Paul DuBois [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, July 25, 2002 7:08 PM Subject: Re: Do you run multiple servers on WIndows? clarification: can't run multiple instances of the same service on Windows. - Original Message - From: Bhavin Vyas [EMAIL PROTECTED] To: Paul DuBois [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, July 25, 2002 7:07 PM Subject: Re: Do you run multiple servers on WIndows? From what little I know of MySql on Windows, it runs as a service and you can't run multiple services on the same Win Server. Bhavin. - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 25, 2002 9:35 AM Subject: Do you run multiple servers on WIndows? It's not uncommon to run multiple MySQL servers on a given Unix system. I'm wondering: Does anyone do this on Windows, and if so, what particular configuration issues did you have to solve to keep them from interfering with each other? - 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
Is there an older version of MySQL for DOS (or Win 3.x)?
Does anyone know of an older version of MySQL that runs on DOS (or on Windows 3.x)? ... - 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
Odd Question on automatic start of Mysql upon boot
I automated the MYSQL start up process using the setup command. Everything works fine except that I noticed safe_mysql is the daemon running, shouldnt this be mysqld or mysql.server? Im completely lost here, and I feel running Safe_mysql is a major security issue? Anyone's thoughts on this? Thx, DK David Kramer Software Developer Reflect.com Direct: 415.369.4856 Cell: 650.302.7889 - 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: Need help with Tables/Attributes
Hello! Nitesh Divecha wrote: Hello All, I need help with tables. I have created my table with some attributes in it. I need to modify my table attributes, can any one help me with the modify command or can give me the short cut to the web. Example: Mysql create table test(ID int(4), Name varchar(20), Sex varchar(1)); Now I need to change the attribute NAME TO Full name, HOW? Please help, Thanking in Advance. As far as I understood the ALTER TABLE syntax, this cannot be done that easily, try: ALTER TABLE test ADD COLUMN Full_name int AFTER ID; UPDATE test SET Full_name = Name; ALTER TABLE test DROP COLUMN Name; Greetings Ralf sql query -- Ralf Narozny SPLENDID Internet GmbH Co KG Skandinaviendamm 212, 24109 Kiel, Germany fon: +49 431 660 97 0, fax: +49 431 660 97 20 mailto:[EMAIL PROTECTED], http://www.splendid.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: Mysqld crash
Diana Soares wrote: Hi, just sending a reply in case that someone else has the same problem. I solved the problem by decreasing the key-buffer from 320M to 288M. We tried that among many other things. It turns out that their is some kind of problem related to temporary tables. MySQL AB is investigating. On Wed, 2002-07-03 at 12:24, Diana Soares wrote: Hi, I have 2 machine dual-processor Pentium III, with 1G of memory. They have the same software, same architecture, with one-way replication beetween. Versions: [root@localhost tmp]# mysql -V mysql Ver 11.18 Distrib 3.23.51, for pc-linux-gnu (i686) [root@localhost tmp]# cat /etc/redhat-release Red Hat Linux release 7.3 (Valhalla) Since i've installed mysql 3.23.51 (mysql binaries) that i'm having some problems, the worst is the slave's mysqld crashes all days. What happens: Every day, a cron job in the slave starts at 3:30AM to generate some reports. The maximum load is about 2.0. Mysqld daemon crashes and restarts itself. All queries in this cron job are done in the master. The slave only replicates... I don't understand why the slave keeps crashing. The master logs are clean, with no error at all, the reports are ok. * The log error at the slave: mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked agaist is corrupt, improperly built,or misconfigured. This error can also be caused by malfunctioning hardware.We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail key_buffer_size=335540224 record_buffer=2093056 sort_buffer=2097144 max_used_connections=1 max_connections=150 threads_connected=0 It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer)*max_connections = 941474 K bytes of memory Hope that's ok, if not, decrease some variables in the equation Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Stack range sanity check OK, backtrace follows: 0x806edf4 0x811fd28 0x81050f3 0x810410f 0x8103df9 0x80b5f04 0x809524c 0x80943b7 0x80940c3 0x808cf67 0x80760ce 0x8079a8c 0x80cfb31 0x80d1249 Stack trace seems successful - bottom reached ... Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0x8287e59 = CREATE TEMPORARY TABLE IF NOT EXISTS tmp_uv SELECT campaign_id , user, count(user) as views FROM Log_Impr_all WHERE campaign_id IN (9) GROUP BY campaign_id , user HAVING views0 thd-thread_id=18 ... * Stack resolved: 0x806edf4 handle_segfault__Fi + 428 0x811fd28 pthread_sighandler + 184 0x81050f3 _hp_movelink + 11 0x810410f _hp_write_key + 595 0x8103df9 heap_write + 73 0x80b5f04 write_row__7ha_heapPc + 72 0x809524c end_update__FP4JOINP13st_join_tableb + 440 0x80943b7 sub_select__FP4JOINP13st_join_tableb + 255 0x80940c3 do_select__FP4JOINPt4List1Z4ItemP8st_tableP9Procedure + 415 0x808cf67 mysql_select__FP3THDP13st_table_listRt4List1Z4ItemP4ItemP8st_orderT4T3T4UiP13select_result + 4055 0x80760ce mysql_execute_command__Fv + 2570 0x8079a8c mysql_parse__FP3THDPcUi + 216 0x80cfb31 exec_event__FP3THDP6st_netP14st_master_infoi + 1133 0x80d1249 handle_slave__FPv + 2309 (i don't understand what this means..) Thank you for reading this, i hope someone can give me a light. - 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 importing null values in mysql 3.23.49 Win32
There appears to be a bug in the Win32 version of Mysql 2.23.49. When I try to read data in (using the load data infile syntax) that contains null values they are converted to 0s. The fields in question are numeric, nulls allowed, default value is NULL. I tried coding them blank, \N and NULL (with and without quotes) and the result seems to be the same. Identical procedure (using \N) in the unix version 3.23.41 seems to work fine. This is a serious problem, as it is necessary to get the database working properly, with automated updates, on a Windoze system. I am surprised not to see any notes or bug reports on this issue. Any suggestions? Karen - 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: Mysqld crash
Hi, just sending a reply in case that someone else has the same problem. I solved the problem by decreasing the key-buffer from 320M to 288M. On Wed, 2002-07-03 at 12:24, Diana Soares wrote: Hi, I have 2 machine dual-processor Pentium III, with 1G of memory. They have the same software, same architecture, with one-way replication beetween. Versions: [root@localhost tmp]# mysql -V mysql Ver 11.18 Distrib 3.23.51, for pc-linux-gnu (i686) [root@localhost tmp]# cat /etc/redhat-release Red Hat Linux release 7.3 (Valhalla) Since i've installed mysql 3.23.51 (mysql binaries) that i'm having some problems, the worst is the slave's mysqld crashes all days. What happens: Every day, a cron job in the slave starts at 3:30AM to generate some reports. The maximum load is about 2.0. Mysqld daemon crashes and restarts itself. All queries in this cron job are done in the master. The slave only replicates... I don't understand why the slave keeps crashing. The master logs are clean, with no error at all, the reports are ok. * The log error at the slave: mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked agaist is corrupt, improperly built,or misconfigured. This error can also be caused by malfunctioning hardware.We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail key_buffer_size=335540224 record_buffer=2093056 sort_buffer=2097144 max_used_connections=1 max_connections=150 threads_connected=0 It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer)*max_connections = 941474 K bytes of memory Hope that's ok, if not, decrease some variables in the equation Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Stack range sanity check OK, backtrace follows: 0x806edf4 0x811fd28 0x81050f3 0x810410f 0x8103df9 0x80b5f04 0x809524c 0x80943b7 0x80940c3 0x808cf67 0x80760ce 0x8079a8c 0x80cfb31 0x80d1249 Stack trace seems successful - bottom reached ... Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0x8287e59 = CREATE TEMPORARY TABLE IF NOT EXISTS tmp_uv SELECT campaign_id , user, count(user) as views FROM Log_Impr_all WHERE campaign_id IN (9) GROUP BY campaign_id , user HAVING views0 thd-thread_id=18 ... * Stack resolved: 0x806edf4 handle_segfault__Fi + 428 0x811fd28 pthread_sighandler + 184 0x81050f3 _hp_movelink + 11 0x810410f _hp_write_key + 595 0x8103df9 heap_write + 73 0x80b5f04 write_row__7ha_heapPc + 72 0x809524c end_update__FP4JOINP13st_join_tableb + 440 0x80943b7 sub_select__FP4JOINP13st_join_tableb + 255 0x80940c3 do_select__FP4JOINPt4List1Z4ItemP8st_tableP9Procedure + 415 0x808cf67 mysql_select__FP3THDP13st_table_listRt4List1Z4ItemP4ItemP8st_orderT4T3T4UiP13select_result + 4055 0x80760ce mysql_execute_command__Fv + 2570 0x8079a8c mysql_parse__FP3THDPcUi + 216 0x80cfb31 exec_event__FP3THDP6st_netP14st_master_infoi + 1133 0x80d1249 handle_slave__FPv + 2309 (i don't understand what this means..) Thank you for reading this, i hope someone can give me a light. -- Diana Soares - 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
Îȶ¨Ñ¹µ¹Ò»ÇÐ---ÖÐСÆóÒµÉÏÍøµÄ¾ø¼Ñ·½°¸!
Ç×°®µÄÅóÓÑ£º ÄúºÃ£¡ ÕâÊÇÀ´×ÔÏÃÃÅÍòά¿Æ¼¼·¢Õ¹ÓÐÏÞ¹«Ë¾µÄÎʺò£¬¸ÐлÄúÊÕ¿´Õâ·âÓʼþ¡£Èç¹ûÄúÒÑÓС¢»òÕý×¼±¸½¨ÉèÍøÕ¾£¬ ÄÇôÇëÄú²Î¹ÛÒ»ÏÂÎÒÃǵÄÍøÕ¾http://www.onway.net£¬ÏàÐÅÄܶÔÄúÓÐËù°ïÖú¡£ ÎÒÃÇΪÄúÌṩµÄÒÔÏÂÍøÕ¾¿Õ¼ä¶¼¿ÉÖ§³ÖÊý¾Ý¿â£¨CGI¡¢PHP¡¢MYSQL¡¢SQL¡¢ACCESS¡¢ASP¡¢JSP£©£¬È«Ãæ Âú×ãÄúµÄÐèÇó¡£Õ⽫»áÊÇÄú³¬ÖµµÄÑ¡Ôñ¡£ 1¡¢30M¿Õ¼ä£«30MÆóÒµÓʾ֣«1¸ö¹ú¼ÊÓòÃû£¬¹¦ÄÜÈ«Ã棬½öÊÛ240Ôª/Äꣻ 2¡¢60M¿Õ¼ä£«60MÆóÒµÓʾ֣«1¸ö¹ú¼ÊÓòÃû£¬¹¦ÄÜÈ«Ã棬½öÊÛ280Ôª/Äꣻ 3¡¢120M¿Õ¼ä£«120MÆóÒµÓʾ֣«1¸ö¹ú¼ÊÓòÃû£¬¹¦ÄÜÈ«Ã棬½öÊÛ330Ôª/Äꣻ 4¡¢200M¿Õ¼ä£¨ÃÀ¹ú£©£«50¸öÓÊÏ䣫1¸ö¹ú¼ÊÓòÃû£¬¹¦ÄÜÈ«Ã棬½öÊÛ880Ôª/Äê¡£ ¡°Îȶ¨Ñ¹µ¹Ò»ÇС±ÊÇÈ«ÌåÍòάÈ˵ķþÎñ×ÚÖ¼£¬ÎÒÃÇÖ£ÖسÐŵ£º 1¡¢ÍòάÖ÷»úÈ«²¿²ÉÓÃÔ×°Dell PowerApp»¥ÁªÍøÓ¦Ó÷þÎñÆ÷£» 2¡¢ÍòάÖ÷»úÈ«²¿°²×°Õý°æTurbolinux»òMicrosoft²Ù×÷ϵͳ£» 3¡¢²ÉÓÃÊÀ½ç±ê×¼µÄSNMP½øÐÐ24x7x365 ϵͳ¼à²â£» 4¡¢ÍòάÖ÷»ú¿Í»§Ò»¸öÔÂÄÚ¿ÉÎÞÌõ¼þÈ«¶îÍ˿ÆäËü°´Êµ¼ÊÓà¶îÍË¿î¡£ ÏêÇéÇëä¯ÀÀ£ºhttp://www.onway.net ÁªÏµemail:[EMAIL PROTECTED] лл£¡ ×££º¿ªÐÄ£¡Ë³Àû£¡ ÏÃÃÅÍòά¿Æ¼¼·¢Õ¹ÓÐÏÞ¹«Ë¾ µØÖ·£ºÏÃÃÅÊйúó´óÏÃ40²ã µç»°:0592-5819328¡¢5815780¡¢5814120 ´«Õæ:0592-5888462 --- ·ÐµãȺ·¢Óʼþ,À´×ÔÈí¼þ¹¤³Ìר¼ÒÍø(http://www.21cmm.com) ½øCMMÍøУ(http://www.21cmm.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: Do you run multiple servers on WIndows?
True, MySQL server does not support several instances on the same windows machine. For comparison, It is possible to install multiple instances of MS SQL Server 2000 !! Xavier -Message d'origine- De : Bhavin Vyas [mailto:[EMAIL PROTECTED]] Envoyé : vendredi 26 juillet 2002 04:09 À : Paul DuBois; [EMAIL PROTECTED] Objet : Re: Do you run multiple servers on WIndows? clarification: can't run multiple instances of the same service on Windows. - Original Message - From: Bhavin Vyas [EMAIL PROTECTED] To: Paul DuBois [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, July 25, 2002 7:07 PM Subject: Re: Do you run multiple servers on WIndows? From what little I know of MySql on Windows, it runs as a service and you can't run multiple services on the same Win Server. Bhavin. - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 25, 2002 9:35 AM Subject: Do you run multiple servers on WIndows? It's not uncommon to run multiple MySQL servers on a given Unix system. I'm wondering: Does anyone do this on Windows, and if so, what particular configuration issues did you have to solve to keep them from interfering with each other? - 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: max_connections recovery
ok, i turns out I have lots of sleeping connections. This is because I'm using PHP's mysql_pconnect which opens persistent connections so the next connect (on the same process) will reuse the connection. this does appear to improve performance overall, which is good. but it seems to leave lots of sleeping processes on the SQL server. so my question is this: do sleeping connections ever get reused by MySQL? or do they just timeout eventually and waste resources while they're sleeping? Thanks! On Thursday, July 25, 2002, at 04:07 PM, Dicky Wahyu Purnomo wrote: Pada Thu, 25 Jul 2002 09:48:40 -0700 Troy Hakala [EMAIL PROTECTED] menulis : I've been running MySQL for 2 years with no problems. Yesterday, I increased the max_connections because I was getting too many connections error. This morning, the server again reached its limit but it never seemed to recover from it and constantly gave the too many connections error. I was forced to kill restart the server. you should check the running processes on your mysqld from show processlist. you might have a lot of sleep/idle connection. my suggestion : first, you have to make sure there is no problem with your tables, run mysqlcheck -or -p -A after that you check is there any changes on too many connection problem. check also from system : netstat -an | grep 3306 -- Look, I'm about to buy me a double barreled sawed off shotgun and show Linus what I think about backspace and delete not working. -- some anonymous .signature MySQL 3.23.51 : up 34 days, Queries : 355.208 per second (avg). -- Dicky Wahyu Purnomo - System Administrator PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790) Phone : +62 21 79199577 - Web : http://1rstwap.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 mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Troy Hakala Recipezaar.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: 4.0.2 libmysqlclient.so.10 not found
In the last episode (Jul 25), Darren Young said: I am in the process of testing out the 4.0 series of MySQL and am having some problems when I try to install the php-mysql RPM. The machine is a RedHat 7.2 i386 box with all current patches. I pulled down the source RPM for 4.0.2-2 and rebuilt the RPM's with debug enabled then installed all the necessary RPM's. Everything seems to be working ok on the MySQL side except that php is asking for libmysqlclient.so.10 and the only library installed with MySQL-shared is libmysqlclient.so.11. I tried a manual symlink from libmysqlclient.so.10 to libmysqlclient.so.11 and the php-mysql still complains that the library isn't present. I installed the php-mysql RPM with --nodeps just to test it out and sure enough I get 'Call to undefined function: mysql_pconnect' which is the same message you receive if you don't install the MySQL-shared RPM in the 3.0 series. I tried adding /usr/lib /usr/lib/mysql /etc/ld.so.conf and ran ldconfig which yielded the same results. Any thoughts on how I could get this library in place with 4.0.2? The php you installed is linked to the mysql 3.23 shlibs. Rebuild php so it gets linked to the new lilbrary. -- Dan Nelson [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysqld crash
On Fri, 2002-07-26 at 18:43, Mike Wexler wrote: Diana Soares wrote: Hi, just sending a reply in case that someone else has the same problem. I solved the problem by decreasing the key-buffer from 320M to 288M. We tried that among many other things. It turns out that their is some kind of problem related to temporary tables. MySQL AB is investigating. Yes, it could be that. I use many temporary tables to generate my final reports. I'll wait... Until there, i'll keep the key-buffer as is and pray for good luck! :-) Thank you for reply, On Wed, 2002-07-03 at 12:24, Diana Soares wrote: Hi, I have 2 machine dual-processor Pentium III, with 1G of memory. They have the same software, same architecture, with one-way replication beetween. Versions: [root@localhost tmp]# mysql -V mysql Ver 11.18 Distrib 3.23.51, for pc-linux-gnu (i686) [root@localhost tmp]# cat /etc/redhat-release Red Hat Linux release 7.3 (Valhalla) Since i've installed mysql 3.23.51 (mysql binaries) that i'm having some problems, the worst is the slave's mysqld crashes all days. What happens: Every day, a cron job in the slave starts at 3:30AM to generate some reports. The maximum load is about 2.0. Mysqld daemon crashes and restarts itself. All queries in this cron job are done in the master. The slave only replicates... I don't understand why the slave keeps crashing. The master logs are clean, with no error at all, the reports are ok. * The log error at the slave: mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked agaist is corrupt, improperly built,or misconfigured. This error can also be caused by malfunctioning hardware.We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail key_buffer_size=335540224 record_buffer=2093056 sort_buffer=2097144 max_used_connections=1 max_connections=150 threads_connected=0 It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer)*max_connections = 941474 K bytes of memory Hope that's ok, if not, decrease some variables in the equation Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Stack range sanity check OK, backtrace follows: 0x806edf4 0x811fd28 0x81050f3 0x810410f 0x8103df9 0x80b5f04 0x809524c 0x80943b7 0x80940c3 0x808cf67 0x80760ce 0x8079a8c 0x80cfb31 0x80d1249 Stack trace seems successful - bottom reached ... Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0x8287e59 = CREATE TEMPORARY TABLE IF NOT EXISTS tmp_uv SELECT campaign_id , user, count(user) as views FROM Log_Impr_all WHERE campaign_id IN (9) GROUP BY campaign_id , user HAVING views0 thd-thread_id=18 ... * Stack resolved: 0x806edf4 handle_segfault__Fi + 428 0x811fd28 pthread_sighandler + 184 0x81050f3 _hp_movelink + 11 0x810410f _hp_write_key + 595 0x8103df9 heap_write + 73 0x80b5f04 write_row__7ha_heapPc + 72 0x809524c end_update__FP4JOINP13st_join_tableb + 440 0x80943b7 sub_select__FP4JOINP13st_join_tableb + 255 0x80940c3 do_select__FP4JOINPt4List1Z4ItemP8st_tableP9Procedure + 415 0x808cf67 mysql_select__FP3THDP13st_table_listRt4List1Z4ItemP4ItemP8st_orderT4T3T4UiP13select_result + 4055 0x80760ce mysql_execute_command__Fv + 2570 0x8079a8c mysql_parse__FP3THDPcUi + 216 0x80cfb31 exec_event__FP3THDP6st_netP14st_master_infoi + 1133 0x80d1249 handle_slave__FPv + 2309 (i don't understand what this means..) Thank you for reading this, i hope someone can give me a light. -- Diana Soares Websolut - Soluções Internet Email: [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
security
Why should I close port 3306 used by mysql? What would happen if a hacker use this port? Anderson Pereira Ataides - 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: Facing some problem in installation
Hi, I am not a root. Our server is at ISP and I am trying to install mysql on our shared server. They have provided one user id and password with which I can access it. I also do not know whether mysql previously exists or not as mysql.sock is existing. (how to find that ?) I checked the mysql.sock file permissions it is as follows: srwxrwxrwx 1 mysql wheel .mysql.sock and as it is a special file, I am unable to delete it. shell rm mysql.sock command gives - permission denied Actually I tried to vi mysql.sock - but ended with something else only now how to proceed ? What shall I check ? Thanks and regards Manisha At 11:22 AM 7/25/02 +0200, you wrote: Hello! Barnali wrote: If you are NOT installing as root, you are trying to create mysql.sock in an area where you don't have write permission. what is the --prefix you supplied to ./configure ? I'd say install as root, change owner and group of the mysql directories, remove /tmp/mysql.sock and start mysql as user mysql. It is ALWAYS a bad idea to start databases as root user. Greetings Ralf -Original Message- From: Manisha [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 25, 2002 12:18 PM To: [EMAIL PROTECTED] Subject: Facing some problem in installation I am trying to install the mySQL on our remote server thr putty (SSH). Following are the set of commands given by me, I have downloaded mysql-3.23 for BSDi. 1)put into /usr/home/mysql-src directory and given following 2 commands going into shellcd /usr/home/mysql-src shellgunzip mysql-.tar.gz shelltar xvf mysql-.tar This is creating the directory mysql- 2)Config - shellcd /usr/home/mysql-src/mysql- shell./configure -basedir=/usr/home/mysql -with-low-memory This command is giving me problem - saying - at the end shellStarting mysqld daemon with database from /usr/home/mysql-src/mysql-/data rm /tmp/mysql.sock - Operation not permitted mysqld end Can anybody help me in this matter - What is the meaning of it ? Thanks and regards Manisha - 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 -- Ralf Narozny SPLENDID Internet GmbH Co KG Skandinaviendamm 212, 24109 Kiel, Germany fon: +49 431 660 97 0, fax: +49 431 660 97 20 mailto:[EMAIL PROTECTED], http://www.splendid.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 - 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
4.0.2 Replication problem w/ AUTO_INCREMENT columns?
Hello all, We're experiencing a bit of difficulty replicating from a 4.0.2 master on Linux to a 4.0.2 slave on Linux. Most of our tables, including the one that's giving us headaches are InnoDB. My colleague encountered the problem, his description follows: It seems to barf on auto_increment fields, at least in some cases. It thinks there's a duplicate key where there isn't one: error 'Duplicate entry '6781602' for key 1' on query 'INSERT INTO visitor(partner_id, campaign_id, referrer_id, when_firstvisit) VALUES(NULL, NULL, NULL, NOW())' [From the slave:] mysql select * from visitor where id=6781602; Empty set (0.00 sec) [From the master:] mysql select * from visitor where id=6781602; +-++-+-+-+ | id | partner_id | campaign_id | referrer_id | when_firstvisit | +-++-+-+-+ | 6781602 | 17 |NULL |NULL | 2002-07-26 00:28:12 | +-++-+-+-+ Any ideas? -JF - 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: Complex SQL assistance
Check the mySQL REPLACE syntax... that's what you need. -Message d'origine- De : Corey Wallis [mailto:[EMAIL PROTECTED]] Envoyé : vendredi 26 juillet 2002 11:17 À : [EMAIL PROTECTED] Objet : Fw: Complex SQL assistance Peoples, I'm currently trying to work out if this is possible by SQL. I have the need to use SQL and only SQL to achieve the following. If a record exists and meets a certain criteria (i.e. field X = '1234') then update the record. If the record doesn't exist then insert it. For reasons too complex to go into at this stage using anything except SQL is not possible. Any and all suggestions welcome. -Corey - 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: Mysqld crash
Diana Soares wrote: On Fri, 2002-07-26 at 18:43, Mike Wexler wrote: Diana Soares wrote: Hi, just sending a reply in case that someone else has the same problem. I solved the problem by decreasing the key-buffer from 320M to 288M. We tried that among many other things. It turns out that their is some kind of problem related to temporary tables. MySQL AB is investigating. Yes, it could be that. I use many temporary tables to generate my final reports. I'll wait... Until there, i'll keep the key-buffer as is and pray for good luck! :-) Thank you for reply, Interesting. They are actively trying to reproduce my problem. Unfortunately it isn't easily reproducible except under load and we've only managed to reproduce it on a production system. If you have a reproducible example or even some represntative queries. Maybe you can post them and the MySQL folks might have an easier time reproducing the problem. Assuming its the same one. On Wed, 2002-07-03 at 12:24, Diana Soares wrote: Hi, I have 2 machine dual-processor Pentium III, with 1G of memory. They have the same software, same architecture, with one-way replication beetween. Versions: [root@localhost tmp]# mysql -V mysql Ver 11.18 Distrib 3.23.51, for pc-linux-gnu (i686) [root@localhost tmp]# cat /etc/redhat-release Red Hat Linux release 7.3 (Valhalla) Since i've installed mysql 3.23.51 (mysql binaries) that i'm having some problems, the worst is the slave's mysqld crashes all days. What happens: Every day, a cron job in the slave starts at 3:30AM to generate some reports. The maximum load is about 2.0. Mysqld daemon crashes and restarts itself. All queries in this cron job are done in the master. The slave only replicates... I don't understand why the slave keeps crashing. The master logs are clean, with no error at all, the reports are ok. * The log error at the slave: mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked agaist is corrupt, improperly built,or misconfigured. This error can also be caused by malfunctioning hardware.We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail key_buffer_size=335540224 record_buffer=2093056 sort_buffer=2097144 max_used_connections=1 max_connections=150 threads_connected=0 It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer)*max_connections = 941474 K bytes of memory Hope that's ok, if not, decrease some variables in the equation Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Stack range sanity check OK, backtrace follows: 0x806edf4 0x811fd28 0x81050f3 0x810410f 0x8103df9 0x80b5f04 0x809524c 0x80943b7 0x80940c3 0x808cf67 0x80760ce 0x8079a8c 0x80cfb31 0x80d1249 Stack trace seems successful - bottom reached ... Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0x8287e59 = CREATE TEMPORARY TABLE IF NOT EXISTS tmp_uv SELECT campaign_id , user, count(user) as views FROM Log_Impr_all WHERE campaign_id IN (9) GROUP BY campaign_id , user HAVING views0 thd-thread_id=18 ... * Stack resolved: 0x806edf4 handle_segfault__Fi + 428 0x811fd28 pthread_sighandler + 184 0x81050f3 _hp_movelink + 11 0x810410f _hp_write_key + 595 0x8103df9 heap_write + 73 0x80b5f04 write_row__7ha_heapPc + 72 0x809524c end_update__FP4JOINP13st_join_tableb + 440 0x80943b7 sub_select__FP4JOINP13st_join_tableb + 255 0x80940c3 do_select__FP4JOINPt4List1Z4ItemP8st_tableP9Procedure + 415 0x808cf67 mysql_select__FP3THDP13st_table_listRt4List1Z4ItemP4ItemP8st_orderT4T3T4UiP13select_result + 4055 0x80760ce mysql_execute_command__Fv + 2570 0x8079a8c mysql_parse__FP3THDPcUi + 216 0x80cfb31 exec_event__FP3THDP6st_netP14st_master_infoi + 1133 0x80d1249 handle_slave__FPv + 2309 (i don't understand what this means..) Thank you for reading this, i hope someone can give me a light. - 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: 32 key max in InnoDB
In the last episode (Jul 25), [EMAIL PROTECTED] said: what sthe deal with having max 32 keys in InnoDB tables in MySQL? the is ABSOLUTELY NO documentation i can find anywhere that states anything about a 32 key max in InnoDB tables. Please, Please, Please, Please, Please, Please, Please, Please point me at some documentation about this http://www.mysql.com/doc/F/e/Features.html Scalability and Limits + Up to 32 indexes per table are allowed. Each index may consist of 1 to 16 columns or parts of columns. The maximum index width is 500 bytes (this may be changed when compiling MySQL Server). An index may use a prefix of a CHAR or VARCHAR field. -- Dan Nelson [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Data Entry for a Newbie
Thank you for all the replies to my MySQL question above. They have been most helpful. Bill. - 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 Index Question
I have just begun playing around with MySQL and I have a question about indexing on dates. Part of our system is a work flow management system and we have a table for all documents that we receive. Each document record has several dates to indicate when various processing functions have been completed. In addition to the date we also wish to know the time. In setting up my first table I set the dates up as DATETIME fields. However, indexing on these forces me to specify a date and time or a range. i.e. where ReceivedDate = '2002-07-26 08:15:05' or where ReceivedDate = '2002-07-26' and ReceivedDate '2002-07-27' Since most of the queries I would run that would take the date into consideration would be to find every document that was received on a given date am I better off making two fields, one for ReceivedDate and one for ReceivedTime or is there a way to create an index only on the Date portion of a DATETIME field? Thanks for the help. Darrell - 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
Cannot create column having ENUM() type
Description: It is impossible to create column having ENUM() type. Not sure if it is a bug as it doesn't make too much sense but at least error message is very wrong. How-To-Repeat: mysql create temporary table test ( test enum () ); ERROR 1074: Too big column length for column 'test' (max = 255). Use BLOB instead Fix: N/A Submitter-Id: submitter ID Originator:Ilya Martynov Organization: Ilya Martynov (http://martynov.org/) MySQL support: none Synopsis: Cannot create column having ENUM() type Severity: non-critical Priority: low Category: mysql Class: sw-bug Release: mysql-3.23.51 (Source distribution) Server: /usr/bin/mysqladmin Ver 8.23 Distrib 3.23.51, for pc-linux-gnu on i686 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.51-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/run/mysqld/mysqld.sock Uptime: 13 min 55 sec Threads: 2 Questions: 250 Slow queries: 0 Opens: 85 Flush tables: 1 Open tables: 6 Queries per second avg: 0.299 Environment: System: Linux abra.ru 2.4.16 #1 ðÎÄ äÅË 10 20:32:46 MSK 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs gcc version 2.95.4 20011006 (Debian prerelease) Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 ñÎ× 15 2002 /lib/libc.so.6 - libc-2.2.4.so -rwxr-xr-x1 root root 1171196 äÅË 3 2001 /lib/libc-2.2.4.so -rw-r--r--1 root root 2669312 äÅË 3 2001 /usr/lib/libc.a -rw-r--r--1 root root 178 äÅË 3 2001 /usr/lib/libc.so Configure command: ./configure --prefix=/usr --exec-prefix=/usr --libexecdir=/usr/sbin --datadir=/usr/share --sysconfdir=/etc/mysql --localstatedir=/var/lib/mysql --includedir=/usr/include --infodir=/usr/share/info --mandir=/usr/share/man --enable-shared --with-libwrap --enable-assembler --with-berkeley-db --with-innodb --enable-static --enable-shared --enable-local-infile --with-raid --enable-thread-safe-client --without-readline --with-unix-socket-path=/var/run/mysqld/mysqld.sock --with-mysqld-user=mysql --without-bench --without-docs --with-client-ldflags=-lstdc++ --with-extra-charsets=all - 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
4.0.2 libmysqlclient.so.10 not found
I am in the process of testing out the 4.0 series of MySQL and am having some problems when I try to install the php-mysql RPM. The machine is a RedHat 7.2 i386 box with all current patches. I pulled down the source RPM for 4.0.2-2 and rebuilt the RPM's with debug enabled then installed all the necessary RPM's. Everything seems to be working ok on the MySQL side except that php is asking for libmysqlclient.so.10 and the only library installed with MySQL-shared is libmysqlclient.so.11. I tried a manual symlink from libmysqlclient.so.10 to libmysqlclient.so.11 and the php-mysql still complains that the library isn't present. I installed the php-mysql RPM with --nodeps just to test it out and sure enough I get 'Call to undefined function: mysql_pconnect' which is the same message you receive if you don't install the MySQL-shared RPM in the 3.0 series. I tried adding /usr/lib /usr/lib/mysql /etc/ld.so.conf and ran ldconfig which yielded the same results. Any thoughts on how I could get this library in place with 4.0.2? Thanks, Darren Young [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re[2]: TRUNCATE TABLE
Hi. On Fri 2002-07-26 at 11:03:26 +0300, [EMAIL PROTECTED] wrote: Hello Benjamin, Why after TRUNCATE TABLE data file with indexes not freed ? BP See http://www.mysql.com/doc/A/d/Adding_and_removing.html (2nd paragraph) BP and http://www.mysql.com/documentation/mysql/bychapter/manual_Table_types.html#InnoDB_File_space BP (second link does not work in the searchable doc, whyever) and TRUNCATE TABLE is very slow ... BP See http://www.mysql.com/doc/T/R/TRUNCATE.html BP and http://www.mysql.com/doc/I/n/InnoDB_restrictions.html BP (in short: because it's InnoDB on 3.23, it's deleting all rows BP seperately) All my tables has MyISAM type, but server running with InnoDB support. Then this section still applies, because the behaviour was compiled in regarding InnoDB support, not InnoDB tables (don't know anymore where I read it, probably some release notes). Greetings, Benjamin. -- [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: inner join query don't work
Hello! gregor gede wrote: hi what's wrong with this query? is it because mysql doesn't support multiple table selection? I use mysql-3.23.49a. SELECT Buku.Judul_Buku, Buku.ISBN, Buku.Kolasi, Buku.Abstraksi, Pengarang.Pengarang, Penerbit.Penerbit, Jenis_Buku.Jenis, Subjek.Subjek FROM Buku, Pengarang_Buku, Pengarang, Penerbit, Jenis_Buku, Subjek_Buku, Subjek WHERE Buku.ID_Buku = Pengarang_Buku.ID_Buku and Pengarang_Buku.No_Pengarang = Pengarang.No_Pengarang and Buku.No_Penerbit = Penerbit.No_Penerbit and Buku.No_Jenis_Buku = Jenis_Buku.No_Jenis_Buku and Buku.ID_Buku = Subjek_Buku.ID_Buku and Subjek_Buku.No_Subjek = Subjek.No_Subjek and Buku.Judul_Buku like '%pascal%' and Pengarang.Pengarang like '%$lukito%' and Subjek.Subjek like '%$computer%' Does it raise an error or just delivers 0 rows or wrong rows? Without that information I wouldn'T even try to take a look at that query ;-) Greetings Ralf -- Ralf Narozny SPLENDID Internet GmbH Co KG Skandinaviendamm 212, 24109 Kiel, Germany fon: +49 431 660 97 0, fax: +49 431 660 97 20 mailto:[EMAIL PROTECTED], http://www.splendid.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: Re[2]: TRUNCATE TABLE
Hi. First, when you start an independend question, please start a new thread, but at least change the subject accordingly. On Fri 2002-07-26 at 11:07:17 +0300, [EMAIL PROTECTED] wrote: [...] If table recreated from table.frm why it not recreate indexes file? Because this is the documented behaviour: http://www.mysql.com/doc/C/R/CREATE_TABLE.html ;-) More seriously, it is explained in the cited section: [...] CREATE TABLE ... SELECT will not automatically create any indexes for you. This is done intentionally to make the command as flexible as possible. If you want to have indexes in the created table, you should specify these before the SELECT statement Greetings, Benjamin. -- [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: max() null bug with funny column name
Have you tried SELECT MAX(`timestamp`) FROM minutely_inbound_handovers;? -JF -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 6:48 AM To: [EMAIL PROTECTED] Subject: max() null bug with funny column name Description: You expect a little goophiness when you set up a column named timestamp. This odd behaviour I consider a bug. How-To-Repeat: show fields from minutely_inbound_handovers; +-+--+--+-+--- --++ | Field | Type | Null | Key | Default | Extra | +-+--+--+-+--- --++ | id | bigint(20) unsigned | | PRI | NULL| auto_increment | | cell| smallint(5) unsigned | | | 0 || | timestamp | datetime | | MUL | -00-00 00:00:00 || | attempted | smallint(5) unsigned | | | 0 || +-+--+--+-+--- --++ 15 rows in set (0.00 sec) select max(timestamp) from minutely_inbound_handovers; ++ | max(timestamp) | ++ | NULL | ++ 1 row in set (0.00 sec) select timestamp from minutely_inbound_handovers where timestamp is null; Empty set (2.74 sec) select max(timestamp) from minutely_inbound_handovers where timestamp is not null; +-+ | max(timestamp) | +-+ | 2002-07-25 14:00:00 | +-+ 1 row in set (3.73 sec) Fix: Submitter-Id:?? Originator: Jettero Heller Organization: MySQL support: none Synopsis:max() null bug with funny column name Severity:non-critical Priority:low Category:mysql Class: sw-bug Release: mysql-4.0.1-alpha (Official MySQL RPM) Server: /usr/bin/mysqladmin Ver 8.23 Distrib 4.0.1-alpha, for pc-linux-gnu on i686 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version4.0.1-alpha Protocol version 10 ConnectionLocalhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 55 min 52 sec Threads: 1 Questions: 604 Slow queries: 10 Opens: 23 Flush tables: 1 Open tables: 11 Queries per second avg: 0.180 Environment: System: Linux mercury.msgexp.net 2.4.18 #1 Wed Jun 19 13:34:15 EDT 2002 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-98) Compilation info: CC='gcc' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='gcc' CXXFLAGS='-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Jun 19 11:14 /lib/libc.so.6 - libc-2.2.5.so -rwxr-xr-x1 root root 1343176 Apr 15 10:02 /lib/libc-2.2.5.so -rw-r--r--1 root root 2310808 Apr 15 10:02 /usr/lib/libc.a -rw-r--r--1 root root 178 Apr 15 09:55 /usr/lib/libc.so Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --without-berkeley-db --with-innodb --enable-assembler --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/info --includedir=/usr/include --mandir=/usr/man --with-embedded-server --enable-thread-safe-client '--with-comment=Official MySQL RPM' - 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
MyODBC error - not allowing me to alter data in Access link table (to MySQL dbase)
Hi, When I open a link table in access (that is opening a table in a mySQL dbase on our server), it will not allow me to alter the data. It keeps telling me that someone else is trying to access or alter the data and that I have to Copy to Clipboard or Drop Changes. I know 100% that I am the only person accessing this database so what is wrong?? Any advice greatly appreciated. Thanks Nathon Jones. - 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 Corruption
I am just getting started with MySQL and one of the first things I was trying is converting one of my larger tables to MySQL to see what kind of performance I would get from some standard queries that I run against it. I built the table and created some indices that I thought would boost the performance for my standard queries. I setup the ODBC on a Windows NT client (the MySQL database is on Red Hat Linux 7.3 and the MySQL version is 3.23.51 that I downloaded on Wednesday.) I ran the query below about 15 times successfully using a Visual Basic program through the ODBC connection. The only queries taking place are SELECT queries. There are no update queries of any kind being run, yet after running the select query about 15 times I start getting the error message below. Is this a standard problem that has a work around? I have dropped the index and recreated it and I get the same behavior. It works fine for a few queries and then the message appears. Thanks for any help. - mysql select * from Documents where type = 1 and (medplancd = ' ' or empno =' '); ERROR 1034: Incorrect key file for table: 'Documents'. Try to repair it mysql explain select * from Documents where type = 1 and (medplancd = ' ' or empno =' '); +---+--+---+ +-+---+++ | table | type | possible_keys | key| key_len | ref | rows | Extra | +---+--+---+ +-+---+++ | Documents | ref | empno,type,TypeMedplancd,TypeEmpno,TypeMedplancdEmpno | TypeMedplancdEmpno | 3 | const | 163829 | where used | +---+--+---+ +-+---+++ 1 row in set (0.01 sec) mysql select * from Documents where type = 2 and (medplancd = ' ' or empno =' '); Empty set (1.57 sec) mysql explain select * from Documents where type = 2 and (medplancd = ' ' or empno =' '); +---+--+---+ +-+---+---++ | table | type | possible_keys | key| key_len | ref | rows | Extra | +---+--+---+ +-+---+---++ | Documents | ref | empno,type,TypeMedplancd,TypeEmpno,TypeMedplancdEmpno | TypeMedplancdEmpno | 3 | const | 49701 | where used | +---+--+---+ +-+---+---++ 1 row in set (0.01 sec) mysql show columns from Documents; +--+-+--+-+-++ | Field| Type| Null | Key | Default | Extra | +--+-+--+-+-++ | DOCID| int(11) | | PRI | NULL| auto_increment | | DOCNum | int(11) | YES | MUL | NULL|| | Received | datetime| YES | MUL | NULL|| | Type | smallint(6) | YES | MUL | NULL|| | Empno| char(9) | YES | MUL | NULL|| | Medplancd| char(10)| YES | | NULL|| | Pages| smallint(6) | YES | | NULL|| | AcctMngr | smallint(6) | YES | | NULL|| | Entered | datetime| YES | | NULL|| | Suspended| datetime| YES | | NULL|| | Adjud| datetime| YES | MUL | NULL|| | BackedUp | datetime| YES | | NULL|| | CDRef| char(12)| YES | | NULL|| | DatePrint| datetime| YES | | NULL|| | Page | double | YES | | NULL|| | LogDate | datetime| YES | | NULL|| | Logged | char(1) | YES | | NULL|| | Descript | char(40)| YES | | NULL|| | Reviewed | datetime| YES | | NULL|| | CLAIMPAGES | smallint(6) | YES | | NULL|| | Emailed | char(1) | YES | | NULL|| | EmailDate| datetime| YES | | NULL|| | RcvEmail | char(1) | YES | | NULL|| | RcvEmailDate | datetime| YES | | NULL|| | EntEmail | char(1) | YES | | NULL|| | EntEmailDate | datetime|
Re: Query problem..
Hi, If you want the last date, isn't it just: SELECT clientid,max(datedone) FROM table_name WHERE done = 'true' and x = '' GROUP BY clientid; ? Hope it helps, On Fri, 2002-07-26 at 08:27, Nixarlidis Aris wrote: Hi, I face the following situation.I have a number of clients-each with a unique clientid.I have a table with some records -one after the other in time order(datedone field) with actions checked as 'done' or not 'done', in the 'done' field which is either true or false.What I want to to, is to specify in my query the last record-date that has an action marked as done at the same time when the value x='' for every clientid.I have tried what you see but didin't help. SELECT clientid FROM table_name WHERE datedone = 'max(datedone)' and done = 'true' and x = '' group by clientid; I am new to all this, so any help would be usefull Thanks -- Diana Soares - 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 Index Question
Hi. On Fri 2002-07-26 at 08:34:51 -0400, [EMAIL PROTECTED] wrote: [...] set the dates up as DATETIME fields. However, indexing on these forces me to specify a date and time or a range. i.e. where ReceivedDate = '2002-07-26 08:15:05' or where ReceivedDate = '2002-07-26' and ReceivedDate '2002-07-27' Since most of the queries I would run that would take the date into consideration would be to find every document that was received on a given date am I better off making two fields, one for ReceivedDate and one for ReceivedTime or is there a way to create an index only on the Date portion of a DATETIME field? Your perception of the concept index seems a bit bend. Even if you could specify such an index, you would still have the same problem, as in queries you can access columns, not indexes. Indexes are only used by the query optimizer to retrieve the rows in question faster. Ideally, this is a transpararent mechanism. In your example, the index on ReceivedDate will also be used to retrieve the result for WHERE ReceivedDate = '2002-07-26' AND ReceivedDate '2002-07-27' To accomplish what you want, you could write the Date with LIKE, e.g. WHERE ReceivedDate LIKE '2002-07-26 %' but this would quite surely prevent the use of any index on this column, as would any try to extract the date part with a function (this would be an expression and expressions cannot use indexes in MySQL). You could, as you suggested, split this into two fields. And if your common usage does not use the time part, this looks like a reasonable solution. I, personally, need the time part more often and simply write my queries this way: WHERE Received BETWEEN '$date 00:00:00' AND '$date 23:59:59' where $date is a variable from my application. Not really pretty, but works fine. In short: There probably is not The One, Right Solution. Greetings, Benjamin. -- [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: inner join query don't work
Hi, Why do you think this query is wrong ? Does it give a message error ? Doesn't return what you expected ? We can't help if you don't tell us what the problem is. On Fri, 2002-07-26 at 03:23, gregor gede wrote: hi what's wrong with this query? is it because mysql doesn't support multiple table selection? I use mysql-3.23.49a. SELECT Buku.Judul_Buku, Buku.ISBN, Buku.Kolasi, Buku.Abstraksi, Pengarang.Pengarang, Penerbit.Penerbit, Jenis_Buku.Jenis, Subjek.Subjek FROM Buku, Pengarang_Buku, Pengarang, Penerbit, Jenis_Buku, Subjek_Buku, Subjek WHERE Buku.ID_Buku = Pengarang_Buku.ID_Buku and Pengarang_Buku.No_Pengarang = Pengarang.No_Pengarang and Buku.No_Penerbit = Penerbit.No_Penerbit and Buku.No_Jenis_Buku = Jenis_Buku.No_Jenis_Buku and Buku.ID_Buku = Subjek_Buku.ID_Buku and Subjek_Buku.No_Subjek = Subjek.No_Subjek and Buku.Judul_Buku like '%pascal%' and Pengarang.Pengarang like '%$lukito%' and Subjek.Subjek like '%$computer%' than's a lot. -- Diana Soares - 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: groupadd
You have posted this sevaral times, and several people have responded. If you are not at the console, and can't use the GUI tools, you will have to use terminal mode tools, or edit the user and group files yourself. This is really not a MySQL problem. You need to create a new user and group for mysql. Open your OSX manuals and start reading. David Houghton wrote: On Thu, 25 Jul 2002, Gerald Clark wrote: create a group called mysql greate a user called mysql, and make it a member of the mysql group. There is no groupadd or useradd command on MacOSX. - 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: Error updating table structure.
mysql doesn't own the table or database. Jeff Dyer wrote: I am developing a new application using MySQL instead of MS SQL Server 2000, I have just shelled out for the Microolap Delphi SQL DIrect Access Components, having successfully converted an existing SQL Server database to MySQL. HOWEVER, I have tried using MyCC, MySQL Explorer, and PremiumSoft MySQL Studio to add a new field to a simple table, and I keep getting an error message like [localhost] ERROR 7: Error on rename of '.\rocktest\companies.MYI' to '.\rocktest\#sql2-94c-21.MYI' (Errcode: 13) If I save to a new table it works, but of course the data is not copied. I am running Windows XP Professional, MySQL 4.0.1-alpha-nt. Anyone know what's wrong? What do other people use to edit table structures (and don't say SQL queries because that's not a productive option when compared to MS Access linked to SQL Server. Regards Jeff Dyer Logic Software Design www.logicsoftware.co.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 - 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 problem..
Hi, I face the following situation.I have a number of clients-each with a unique clientid.I have a table with some records -one after the other in time order(datedone field) with actions checked as 'done' or not 'done', in the 'done' field which is either true or false.What I want to to, is to specify in my query the last record-date that has an action marked as done at the same time when the value x='' for every clientid.I have tried what you see but didin't help. SELECT clientid FROM table_name WHERE datedone = 'max(datedone)' and done = 'true' and x = '' group by clientid; I am new to all this, so any help would be usefull 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
max() null bug with funny column name
Description: You expect a little goophiness when you set up a column named timestamp. This odd behaviour I consider a bug. How-To-Repeat: show fields from minutely_inbound_handovers; +-+--+--+-+-++ | Field | Type | Null | Key | Default | |Extra | +-+--+--+-+-++ | id | bigint(20) unsigned | | PRI | NULL| |auto_increment | | cell| smallint(5) unsigned | | | 0 | | | | timestamp | datetime | | MUL | -00-00 00:00:00 | | | | attempted | smallint(5) unsigned | | | 0 | | | +-+--+--+-+-++ 15 rows in set (0.00 sec) select max(timestamp) from minutely_inbound_handovers; ++ | max(timestamp) | ++ | NULL | ++ 1 row in set (0.00 sec) select timestamp from minutely_inbound_handovers where timestamp is null; Empty set (2.74 sec) select max(timestamp) from minutely_inbound_handovers where timestamp is not null; +-+ | max(timestamp) | +-+ | 2002-07-25 14:00:00 | +-+ 1 row in set (3.73 sec) Fix: Submitter-Id: ?? Originator:Jettero Heller Organization: MySQL support: none Synopsis: max() null bug with funny column name Severity: non-critical Priority: low Category: mysql Class: sw-bug Release: mysql-4.0.1-alpha (Official MySQL RPM) Server: /usr/bin/mysqladmin Ver 8.23 Distrib 4.0.1-alpha, for pc-linux-gnu on i686 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 4.0.1-alpha Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 55 min 52 sec Threads: 1 Questions: 604 Slow queries: 10 Opens: 23 Flush tables: 1 Open tables: 11 Queries per second avg: 0.180 Environment: System: Linux mercury.msgexp.net 2.4.18 #1 Wed Jun 19 13:34:15 EDT 2002 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-98) Compilation info: CC='gcc' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='gcc' CXXFLAGS='-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Jun 19 11:14 /lib/libc.so.6 - libc-2.2.5.so -rwxr-xr-x1 root root 1343176 Apr 15 10:02 /lib/libc-2.2.5.so -rw-r--r--1 root root 2310808 Apr 15 10:02 /usr/lib/libc.a -rw-r--r--1 root root 178 Apr 15 09:55 /usr/lib/libc.so Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --without-berkeley-db --with-innodb --enable-assembler --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/info --includedir=/usr/include --mandir=/usr/man --with-embedded-server --enable-thread-safe-client '--with-comment=Official MySQL RPM' - 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 sub query
Hi. On Fri 2002-07-26 at 09:46:39 -0500, [EMAIL PROTECTED] wrote: [...] Problem is that the sql version I am running does not support sub-queries. MySQL does not support sub-queries in any version yet. Is there another way of getting around the following situation to wirte a query so that Please, whenever you can provide an example, do so! You implied that you know how to write it as a sub-select, so include that, please. select * from tab_name where one item from each GRP 1, 2, and 3 - whichever is highest priced (PRC) and has CHECK set to N. This is a standard question and there is a standard answer: http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html And even a tutorial answer: http://www.mysql.com/doc/e/x/example-Maximum-column-group-row.html Greetings, Benjamin. -- [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Named Pipes in MySQL
At 9:16 -0500 7/26/02, Mike Grover wrote: -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 9:01 AM To: Mike Grover Subject: Re: Named Pipes in MySQL Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: Does anybody know if connecting with named pipes has changed in 4.02? I used to use . For the host name in 4.01 , after I switched to 4.02 I get the error Failed to open named pipe when I try to connect? Any Ideas? As of MySQL 3.23.50, named pipes are off by default (they caused certain kinds of shutdown problems on some systems). To enable them use an --enable-named-pipes option or put an enable-named-pipe line in the [mysqld] group in an option file. I don't know, but would guess that the same change was made in the 4.0.x series between 4.0.1 and 4.0.2, from what you're describing. mike - 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