mysqld freezing/hanging every some day, by now every some minutes
Description: sig 11 every now and then, mysqld freezes. we have exim + courier authenticating against mysql, also some customer databases (php) How-To-Repeat: well, no idea, it just happens... fivefold /tmp # resolve_stack_dump -s /tmp/mysqld.sym -n mysqld.stack 0x80cf3d4 handle_segfault__Fi + 428 0x4002e5cb _end + 935451919 0x4018900e _end + 936871762 0x40019911 _end + 935366741 0x8454120 _end + 276580 -- previously with .43 or .45 or even .48 (not overly sure about it mysql was crashing daily. then with .52 it was working better, but now it starts to crash again. This is a Debian box. Fix: stopping all services using mysql, killing mysqld hard (-9) and then safe_mysql does its job, restart all other services Submitter-Id: submitter ID Originator:[EMAIL PROTECTED] (Alexander Koch) Organization: cid.net, Germany MySQL support: none Synopsis: mysqld dying every some minutes Severity: serious Priority: high Category: mysql Class: Release: mysql-3.23.52 (Source distribution) Server: /usr/bin/mysqladmin Ver 8.23 Distrib 3.23.52, 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.52-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/run/mysqld/mysqld.sock Uptime: 7 sec Threads: 1 Questions: 1 Slow queries: 0 Opens: 6 Flush tables: 1 Open tables: 0 Queries per second avg: 0.143 Environment: System: Linux fivefold 2.4.17 #1 SMP Tue Feb 5 14:40:34 CET 2002 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 20010827 (Debian prerelease) Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Nov 15 08:58 /lib/libc.so.6 - libc-2.3.1.so -rwxr-xr-x1 root root 1109900 Oct 21 16:41 /lib/libc-2.3.1.so -rw-r--r--1 root root 2344742 Oct 21 16:41 /usr/lib/libc.a -rw-r--r--1 root root 178 Oct 21 16:41 /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
access denied 1045
I'm completely new to mysql. I've been hunting all over the web and mysql help/documentation but could not find a working solution to my problem. I installed mysql on a RAQ4 from the standard package that came from Cobalt. I was able to set the root@host password, but unable to set the root@localhost password and I beleive this is the source of my proble. When trying to do anything password related mysql I get errors ERROR 1045: Access denied for user: 'root@localhost' The errors start at the basic basis: shell mysql -u root test Having looked at the help pages it seems (thanks to Joerg Prante for his comment on the relevant mysql documentation page otherwise I would not have known) that there would be an issue regarding acquiring additional privileges from the mysql administrator. However, it is my raq and I do have (should have) all the privileges. I must be doing something wrong, but don't know what. Anyone had the same poblem? Anyone knowing the solution? Thanks. Using mysql version Cobalt MySQL Release 3.23.37-1 The quote from Joerg: One case not mentioned here and you get an 1045 Access denied error is when you don't have the privilege to alter system tables using LOCK TABLES. The connect succeeds, but a LOCK TABLES query fails. Then you should ask the MySQL administrator to extend your privileges. The LOCK TABLES command is writing to the system tables. If the MySQL administrator decided to grant you all privileges only on your database, say foo.*, this won't be sufficient. You will need write access to 'mysql' database. If you don't have that, you will get a MySQL error #1045 access denied at the LOCK TABLES query. So, the case of LOCK TABLE privilege in MySQL breaks a privilege system where administrators decided to grant privileges ordered by database hierarchy. __ Do you Yahoo!? Yahoo! Web Hosting - Let the expert host your site http://webhosting.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
question for research (OT)
Hi! I saw Czech people posting here. Im doing research for a local computer magazine and I'm looking for online fees in Czech Republic. The article deals with chances for international companies after Czech EU accedence. Nothing to find in Google database. Could you please feed me some data or point me to (english/german language) websites? I'm looking for providers, costs per minute, flat rates, leased lines, technical differences (modem, isdn, xdsl, powerline, cable) etc. Plz answer to my private mail address. Thanx in advance and sorry for any inconvenience by this post. Your help is highly appreciated! sql query STIBS - 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: access denied 1045
Hi Cobalt uses 'cobalt-mysql' as the default mysql root password. I spent hours trying to sort this one out, reinstalled the whole thing, manually recreated Mysql database all sorts Stupid to use non standard setup really. If that doesn't work come back to me. Peter --- Excellence in internet and open source software --- Sunmaia Birmingham UK www.sunmaia.net tel. 0121-242-1473 International +44-121-242-1473 --- -Original Message- From: Zinneken [mailto:[EMAIL PROTECTED]] Sent: 16 November 2002 10:31 To: [EMAIL PROTECTED] Subject: access denied 1045 I'm completely new to mysql. I've been hunting all over the web and mysql help/documentation but could not find a working solution to my problem. I installed mysql on a RAQ4 from the standard package that came from Cobalt. I was able to set the root@host password, but unable to set the root@localhost password and I beleive this is the source of my proble. When trying to do anything password related mysql I get errors ERROR 1045: Access denied for user: 'root@localhost' The errors start at the basic basis: shell mysql -u root test Having looked at the help pages it seems (thanks to Joerg Prante for his comment on the relevant mysql documentation page otherwise I would not have known) that there would be an issue regarding acquiring additional privileges from the mysql administrator. However, it is my raq and I do have (should have) all the privileges. I must be doing something wrong, but don't know what. Anyone had the same poblem? Anyone knowing the solution? Thanks. Using mysql version Cobalt MySQL Release 3.23.37-1 The quote from Joerg: One case not mentioned here and you get an 1045 Access denied error is when you don't have the privilege to alter system tables using LOCK TABLES. The connect succeeds, but a LOCK TABLES query fails. Then you should ask the MySQL administrator to extend your privileges. The LOCK TABLES command is writing to the system tables. If the MySQL administrator decided to grant you all privileges only on your database, say foo.*, this won't be sufficient. You will need write access to 'mysql' database. If you don't have that, you will get a MySQL error #1045 access denied at the LOCK TABLES query. So, the case of LOCK TABLE privilege in MySQL breaks a privilege system where administrators decided to grant privileges ordered by database hierarchy. __ Do you Yahoo!? Yahoo! Web Hosting - Let the expert host your site http://webhosting.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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: /usr/bin/mysqladmin missing from Linux/x86 RPM
scott, Saturday, November 16, 2002, 12:08:52 AM, you wrote: sdaaado I downloaded and installed the RPM from mysql.org (the uu.net mirror sdaaado in the USA). The transcript told me to set a root password using sdaaado /usr/bin/mysqladmin, but that program doesn't exist. I also am missing sdaaado other programs referred to in the documentation, such as /usr/bin/mysql sdaaado (the client). The documentation refers to /usr/local/mysql, but that sdaaado directory wasn't created. I simply can't find much correspondence between sdaaado the documentation and what I have. sdaaado Wait! Never mind. I installed the -client RPM and that contains sdaaado the /usr/bin/mysqladmin and other programs. All is well, now. However, sdaaado can I humbly suggest that your documentation should tell people to sdaaado install both before running any programs. It is odd to me that the sdaaado mysqladmin program is with the client RPM and not the server RPM , sdaaado but as long as I know to install both, it doesn't matter. How-To-Repeat: sdaaado # rpm -ivh MySQL-3.23.53a-1.i386.rpm You installed only MySQL server, to use mysqladmin you must install also client package. -- 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: installing mySQLGUI
Craig, Friday, November 15, 2002, 10:45:08 PM, you wrote: CM How do I go about installing mysqlGUI? I have downloaded all of the CM files. What about reading README and install.txt files? -- 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
SQL Query
Hi, I have a colum with this values : ,1,4,5,66,247,7, ,1,3,5,62,767,6, ,1,5,5,11 ,1,9,5,36,7677,9, ,1,40,55,66,444,3, I want to get whis values : (second field) 4 3 5 9 40 I have tried this : REPLACE(SUBSTRING_INDEX(value, ',', 3), ',','') But the following is returned : 14 13 15 19 140 I have alse tried the following query : select mid(path,locate(2,path,,)+1,(locate(locate(2,path,,)+1,path,,)-loc ate(2,path,,)-1)) from path_table Regards, 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: SQL Query
Why not just split that field up into multiple fields. Seems ridiculous to have multiple values in a single field in a RDMS -Peter -Original Message- From: Paul van Brouwershaven [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 16, 2002 14:46 To: [EMAIL PROTECTED] Subject: SQL Query Hi, I have a colum with this values : ,1,4,5,66,247,7, ,1,3,5,62,767,6, ,1,5,5,11 ,1,9,5,36,7677,9, ,1,40,55,66,444,3, I want to get whis values : (second field) 4 3 5 9 40 I have tried this : REPLACE(SUBSTRING_INDEX(value, ',', 3), ',','') But the following is returned : 14 13 15 19 140 I have alse tried the following query : select mid(path,locate(2,path,,)+1,(locate(locate(2,path,,)+1,pat h,,)-loc ate(2,path,,)-1)) from path_table Regards, 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 mysql-unsubscribe-peter.thoenen=bondsteel2.areur.army.mil@lis ts.mysql.com 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: SQL Query
I'ts a dump of an other database with more than 4 million records -Original Message- From: Thoenen, Peter Mr. EPS [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 16, 2002 2:54 PM To: 'Paul van Brouwershaven'; [EMAIL PROTECTED] Subject: RE: SQL Query Why not just split that field up into multiple fields. Seems ridiculous to have multiple values in a single field in a RDMS -Peter -Original Message- From: Paul van Brouwershaven [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 16, 2002 14:46 To: [EMAIL PROTECTED] Subject: SQL Query Hi, I have a colum with this values : ,1,4,5,66,247,7, ,1,3,5,62,767,6, ,1,5,5,11 ,1,9,5,36,7677,9, ,1,40,55,66,444,3, I want to get whis values : (second field) 4 3 5 9 40 I have tried this : REPLACE(SUBSTRING_INDEX(value, ',', 3), ',','') But the following is returned : 14 13 15 19 140 I have alse tried the following query : select mid(path,locate(2,path,,)+1,(locate(locate(2,path,,)+1,pat h,,)-loc ate(2,path,,)-1)) from path_table Regards, 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 mysql-unsubscribe-peter.thoenen=bondsteel2.areur.army.mil@lis ts.mysql.com 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
Help: Problem creating db's in winMySQLAdmin
Hi everyone I have a problem: I installed mySQL yesterday on a WinXP Pro system and have used winMySQLAdmin.exe for most administrative purposes. According to the website and the documentation, I can create a new db from within the program by going to the Databases tab and right-clicking, then choosing Create Database. When I do that, however, my menu only includes four options: Flush Hosts, Flush Logs, Flush Tables, Flush Threads. Does anybody have any insight into this? Is this a problem with my install/configuration, a bug, a misreported feature, or what? I have been able to create and modify databases using the command line (mysql and mysqladmin), but this is, obviously, less convenient. Any help is greatly appreciated! -Ed Cottrell Ed Cottrell President Topsail Consulting, Inc. [EMAIL PROTECTED] http://www.topsailconsulting.com Phone/Fax: 770-719-3332 155 Shamrock Drive Fayetteville, GA 30215-2810 - 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: SQL Query
- Original Message - From: Paul van Brouwershaven [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, November 16, 2002 8:58 AM Subject: RE: SQL Query I'ts a dump of an other database with more than 4 million records Yeah, but that still doesn't mean that you can't use the earlier suggestion. You should pull the records, split the data based on the comma and then insert them individually into new fields and then run your query on the new table. Good Luck! Dennis - 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: SQL Query
The number of values is also not the same, this can be 1 till +/-30 values -Original Message- From: Dennis Salguero [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 16, 2002 1:46 PM To: Paul van Brouwershaven; [EMAIL PROTECTED] Subject: Re: SQL Query - Original Message - From: Paul van Brouwershaven [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, November 16, 2002 8:58 AM Subject: RE: SQL Query I'ts a dump of an other database with more than 4 million records Yeah, but that still doesn't mean that you can't use the earlier suggestion. You should pull the records, split the data based on the comma and then insert them individually into new fields and then run your query on the new table. Good Luck! Dennis - 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: SQL Query
Sorry it's default -Original Message- From: Peter Brawley [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 16, 2002 5:23 PM To: Paul van Brouwershaven Subject: Re: SQL Query Please do NOT mark posted messages 'request reply'. - - Original Message - From: Paul van Brouwershaven [EMAIL PROTECTED] To: 'Dennis Salguero' [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, November 16, 2002 8:17 AM Subject: RE: SQL Query The number of values is also not the same, this can be 1 till +/-30 values -Original Message- From: Dennis Salguero [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 16, 2002 1:46 PM To: Paul van Brouwershaven; [EMAIL PROTECTED] Subject: Re: SQL Query - Original Message - From: Paul van Brouwershaven [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, November 16, 2002 8:58 AM Subject: RE: SQL Query I'ts a dump of an other database with more than 4 million records Yeah, but that still doesn't mean that you can't use the earlier suggestion. You should pull the records, split the data based on the comma and then insert them individually into new fields and then run your query on the new table. Good Luck! Dennis - 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: SQL Query
First of all, don't do this in mysql . If you got a dump of the database, using cut utility u can easily extract the second field in the delimited by the comma.. and then split them into different columns in the table when you want to insert them into the mysql database. If you are still looking for something to do in mysql, you can do it with a little work around.. You will have to create a different table with my solution, and you can create it as temporary table.. CREATE TABLE your_new_table SELECT SUBSTRING_INDEX(a1,',',3) AS cut_value FROM your_original_table; This will create a new table and if you do a select * on it you will see: +---+ | cut_value | +---+ | ,1,4 | | ,1,3 | | ,1,5 | | ,1,9 | | ,1,40 | +---+ 5 rows in set (0.23 sec) and in this table, you can do: SELECT SUBSTRING_INDEX(cut_value,',',-1) AS value_i_want FROM your_new_table; And it will give you: +--+ | value_i_want | +--+ | 4| | 3| | 5| | 9| | 40 | +--+ 5 rows in set (0.00 sec) Hope this helps.. Gurhan On Sat, 2002-11-16 at 08:45, Paul van Brouwershaven wrote: Hi, I have a colum with this values : ,1,4,5,66,247,7, ,1,3,5,62,767,6, ,1,5,5,11 ,1,9,5,36,7677,9, ,1,40,55,66,444,3, I want to get whis values : (second field) 4 3 5 9 40 I have tried this : REPLACE(SUBSTRING_INDEX(value, ',', 3), ',','') But the following is returned : 14 13 15 19 140 I have alse tried the following query : select mid(path,locate(2,path,,)+1,(locate(locate(2,path,,)+1,path,,)-loc ate(2,path,,)-1)) from path_table Regards, 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 - 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
Problems with reserved words
Howdy, Recently I was working with a contractor on a schema for a project. I'm terribly embarrassed to admit that one of the tables we came up with got named order since it keeps track of an order number assigned to a shipment by a vendor. I bet you know what's coming next. Somehow, mysql didn't complain when he created the table, but I quickly realized our mistake when every query, including RENAME and DROP queries came up as invalid because of the reserved word ORDER. I figure that I'll have to dump all of the other tables, create a new db, reload all the tables into the new db and drop the old db to get rid of that order table, then re-create it under a new name (ship_order, maybe). I was just hoping someone on the list might have another idea or some way to delimit the name. To be honest, I'm mostly curious at this point. It's not really that much work to fix this (unless dropping the db proves to not work). Here's a thought: Would renaming the MYD, MYI, and frm files do the job? I'll try that now. Thanks, Matt Kenigson - 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: SQL Query
Hi, If the lenght of what wish to retrieve is fixed to 2 length,you can try something like this: select MID(YOUR_FIELD,3,IF(RIGHT(LPAD(YOUR_FIELD,4,','),1)=',',1,2)) from YOUR_TABLE; Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Paul van Brouwershaven [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, November 16, 2002 3:45 PM Subject: SQL Query Hi, I have a colum with this values : ,1,4,5,66,247,7, ,1,3,5,62,767,6, ,1,5,5,11 ,1,9,5,36,7677,9, ,1,40,55,66,444,3, I want to get whis values : (second field) 4 3 5 9 40 I have tried this : REPLACE(SUBSTRING_INDEX(value, ',', 3), ',','') But the following is returned : 14 13 15 19 140 I have alse tried the following query : select mid(path,locate(2,path,,)+1,(locate(locate(2,path,,)+1,path,,)-loc ate(2,path,,)-1)) from path_table Regards, 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 - 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: Problems with reserved words
Never mind. Renaming the files worked the trick. :) Matt - Original Message - From: Matt Kenigson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, November 16, 2002 11:35 AM Subject: Problems with reserved words Howdy, Recently I was working with a contractor on a schema for a project. I'm terribly embarrassed to admit that one of the tables we came up with got named order since it keeps track of an order number assigned to a shipment by a vendor. I bet you know what's coming next. Somehow, mysql didn't complain when he created the table, but I quickly realized our mistake when every query, including RENAME and DROP queries came up as invalid because of the reserved word ORDER. I figure that I'll have to dump all of the other tables, create a new db, reload all the tables into the new db and drop the old db to get rid of that order table, then re-create it under a new name (ship_order, maybe). I was just hoping someone on the list might have another idea or some way to delimit the name. To be honest, I'm mostly curious at this point. It's not really that much work to fix this (unless dropping the db proves to not work). Here's a thought: Would renaming the MYD, MYI, and frm files do the job? I'll try that now. Thanks, Matt Kenigson - 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: Problems with reserved words
Oh, FYI, I did stop mysql first, change the file names, then restart it. Matt - Original Message - From: Matt Kenigson [EMAIL PROTECTED] To: Matt Kenigson [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, November 16, 2002 11:39 AM Subject: Re: Problems with reserved words Never mind. Renaming the files worked the trick. :) Matt - Original Message - From: Matt Kenigson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, November 16, 2002 11:35 AM Subject: Problems with reserved words Howdy, Recently I was working with a contractor on a schema for a project. I'm terribly embarrassed to admit that one of the tables we came up with got named order since it keeps track of an order number assigned to a shipment by a vendor. I bet you know what's coming next. Somehow, mysql didn't complain when he created the table, but I quickly realized our mistake when every query, including RENAME and DROP queries came up as invalid because of the reserved word ORDER. I figure that I'll have to dump all of the other tables, create a new db, reload all the tables into the new db and drop the old db to get rid of that order table, then re-create it under a new name (ship_order, maybe). I was just hoping someone on the list might have another idea or some way to delimit the name. To be honest, I'm mostly curious at this point. It's not really that much work to fix this (unless dropping the db proves to not work). Here's a thought: Would renaming the MYD, MYI, and frm files do the job? I'll try that now. Thanks, Matt Kenigson - 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
