Connecting via ODBC to a MySQL database
Douglass, Saturday, February 23, 2002, 9:02:05 AM, you wrote: DP I am brand new to MySQL, and trying to get up to speed as fast as possible. DP I have successfully installed both MySQL 3.23.47 and MyODBC 2.50.39. I am DP using VB6 and ADO in combination with MyODBC to connect to a database I have DP already created. However, I keep getting the following message: DP [TCX][MyODBC]Access denied for user: 'IDSIUser@localhost' (Using password: ^^^ DP YES). [skip] DP I created the User IDSIUser with the following command: DP GRANT ALL ON FECData.* TO IDSIUser@'%' INDENTIFIED BY 'excalibur' ^^ You created user for connection via TCP/IP ('%'), but you tried to connect via Unix socket ('localhost') - because connecting to localhost is done via Unix sockets.. DP Can anyone possibly tell me what I have left out or what I am doing wrong, DP or just point me to some documentation that will help me sort out the DP problem? Look at: http://www.mysql.com/doc/G/R/GRANT.html DP Thanks for the help. -- For technical support contracts, goto https://order.mysql.com/ 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
off-line development tool?
Marco, Saturday, February 23, 2002, 3:59:20 AM, you wrote: MB Hello, I am a beginning MySQL and PHP user. I will run a MySQL database on a MB remote hosting server, and I have only limited access to the database at MB that server. I want to populate my database off-line at my home machine, and MB then upload the whole thing (100s of lengthy entries) to the server. But I MB don't have direct access there. So I suppose I'll have to do something like MB exporting my data to a text file, upload the text file to the root of my MB domain at the server and re-create the database from there. I don't think I MB can run any tool on the server; I work with .php files there. MB So my question is: how would people normally go about this task. Would I MB need to write a script for in- and export of data, or would there perhaps be MB a handy tool that takes this out of my hands? mysqldump will help you, see at: http://www.mysql.com/doc/m/y/mysqldump.html Look at SELECT ... INTO OUTFILE info in the manual: http://www.mysql.com/doc/S/E/SELECT.html MB Thanks, Marco Bleeker, Amsterdam -- For technical support contracts, goto https://order.mysql.com/ 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
mysql upgrade problem
Marek, Friday, February 22, 2002, 7:11:06 PM, you wrote: MW Hello all. MW I'm using Debian 2.4.x MW I was trying to upgrade mysql.3.22 to 23 by removing default packages and MW after debianizeing rpm's with alien I installed them with dpkg. MW After I did upgrade (as I assume ;-))) somewhere my.cnf file disappeared You can find examples of *.cnf in /usr/doc/MySQL-X.XX. Find the configuration that fits you best. Copy the file under the name my.cnf in /etc or in /usr/local/mysql/var. MW Do someone know how to properly upgrade 22 to 23 ? MW (http://www.mysql.com/doc/U/p/Upgrade.html - there MW is no information enough) MW Marek Wysmulek -- For technical support contracts, goto https://order.mysql.com/ 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: multiple character sets in one database
Chris, Friday, February 22, 2002, 5:40:18 PM, you wrote: CG Thank you for your very detailed reply. This was my understanding of it too. CG I guess I was hoping that I had missed something! CG Do you know when will this happen? (I hate to ask but since I know I will be CG asked this, I feel I should ask you. My crystal ball is broken!) CG Is it going to be in 4.x? Or is there another timeframe? It should be in MySQL 4.1. Look at: http://www.mysql.com/doc/T/O/TODO_MySQL_4.1.html CG Thanks again. CG Chris [skip] CG Chris, CG Friday, February 22, 2002, 3:51:39 PM, you wrote: CG Hello CG I would like to know how to use different languages in different tables CG (one language/character set per table). The idea being users can view web CG page data in their own language. Some of this content will need to be CG sortable. VR MySQL doesn't support it now, but it is in plans to do full support to VR the table and query level. -- For technical support contracts, goto https://order.mysql.com/ 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
Hello! Is there a way to find out bad queries? Also a way for verifing tables? Tnank you
Konstantin, Saturday, February 23, 2002, 11:49:35 AM, you wrote: KY Hello! KY Is there a way to find out bad query? You can read info about EXPLAIN statement (give you info about each table used in SELECT statement): http://www.mysql.com/doc/E/X/EXPLAIN.html Please, read about how MySQL uses indexes in the manual: http://www.mysql.com/doc/M/y/MySQL_indexes.html KY Also a way for verifing tables? Get some more info at: http://www.mysql.com/doc/O/P/OPTIMIZE_TABLE.html KY Tnank you -- For technical support contracts, goto https://order.mysql.com/ 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: Is there a limit on the email size for this list?
George, Saturday, February 23, 2002, 1:07:38 AM, you wrote: GL Yip somebody pointed me towards the address from the returned mail ;-p. Now GL for the answers to your questions: GL 1. I did create a user and a group for mysql by using: GL shell chown -R root /usr/local/mysql GL shell chown -R mysql /usr/local/mysql/data GL shell chgrp -R mysql /usr/local/mysql GL shell chown -R root /usr/local/mysql/bin Why should you make those dirs by hands? mysql's sources make install will make the dirs for you, the same will do the RPM packages.. GL George -- For technical support contracts, goto https://order.mysql.com/ 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: Is there a limit on the email size for this list?
Hi Egor, I created them according to the INSTALL-BINARY file included in the package downloadable from www.mysql.com I qoute this from the file: // 1. Pick the directory under which you want to unpack the distribution, and move into it. In the example below, we unpack the distribution under `/usr/local' and create a directory `/usr/local/mysql' into which MySQL is installed. (The following instructions therefore assume you have permission to create files in `/usr/local'. If that directory is protected, you will need to perform the installation as `root'.) // Should I not create the directory mysql in /usr/local/ and let gunzip create it for me? Sorry but my knowledge of Linux is desperatly low, I only recently started using the OS and needed a db and mysql seemed like an excellent choice. George On Saturday 23 February 2002 12:42, you wrote: George, Saturday, February 23, 2002, 1:07:38 AM, you wrote: GL Yip somebody pointed me towards the address from the returned mail ;-p. Now GL for the answers to your questions: GL 1. I did create a user and a group for mysql by using: GL shell chown -R root /usr/local/mysql GL shell chown -R mysql /usr/local/mysql/data GL shell chgrp -R mysql /usr/local/mysql GL shell chown -R root /usr/local/mysql/bin Why should you make those dirs by hands? mysql's sources make install will make the dirs for you, the same will do the RPM packages.. GL George - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Is there a limit on the email size for this list?
George, Saturday, February 23, 2002, 12:58:11 PM, you wrote: GL I created them according to the INSTALL-BINARY file included in the package GL downloadable from www.mysql.com GL I qoute this from the file: GL // GL 1. Pick the directory under which you want to unpack the GL distribution, and move into it. In the example below, we unpack GL the distribution under `/usr/local' and create a directory GL `/usr/local/mysql' into which MySQL is installed. (The following GL instructions therefore assume you have permission to create files GL in `/usr/local'. If that directory is protected, you will need to GL perform the installation as `root'.) GL // GL Should I not create the directory mysql in /usr/local/ and let gunzip create GL it for me? Sorry but my knowledge of Linux is desperatly low, I only recently GL started using the OS and needed a db and mysql seemed like an excellent GL choice. What is the Linux distribution that you use? Take the appropriate package from MySQL and the installation will go automatically. GL George -- For technical support contracts, goto https://order.mysql.com/ 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
Help needed in configuring the server
Hello every one... We are going into making the final changes to our production MySQL server. production server configuration is Free BSD PIII dual processor 800 mhz, 750 MB RAM. back_log = 20 DEFAULT back_log = 200 CHANGED flush_time = 1800 sec DEFAULT flush_time = 3600 sec CHANGED key_buffer_size = 16 MB DEFAULT key_buffer_size = 30 MB CHANGED max_allowed_packet = 10MB DEFAULT max_allowed_packet = 20MB CHANGED max_connections = 100 DEFAULT max_connections = 250 CHANGED Apache ,Tomcat, MySQL is running on the same machine.Kindly give us your expert opinion is it wise to run the three servers with the given server hardware configuration on the same machine...? Is it safe to alter the above mentioned server variables...? If safe..what is the syntax to set these parameters on Free BSD shell An example would be more help full. Thanx. Vijay Khanna System Analyst www.spsoftware.com Ph: 09120 - 4006154 INDIA FOR THOSE WHO CAME LATE : Hiya forum.. I have my site powered by MySQL server running on FreeBSD. The site is facing problems when the traffic increases.Database connectivity is through JDBC.My poolman is managing the database connections with 30 connections set, and is growable.People have started getting error when the rush increases... Error : Communication failure : Bad Handshake. Is there a MySQL server running on the port connectivity error. I suspect the max_connection variable which is default set to 100 reaches and the server refuses further connection.We have probed for any unused database connections hold by the Java.But we have religiously returned the connection back to the poolmanager after its used... I am running my development MySQL server on windows NT. Having gone thru the MySQL manual..for performance tuning the server,we came across many variables which can affect the server performance. So i issue the following commands: c:\ cd mysql\bin start the serverc:\mysqld set the variablec:\mysqld -O back_log=200 --help Looks like it updates the server..but when i see it thru the WinMySQLAdmin ,after restarting the server again ,it does not reflect there and displays the default settings. We have a production server runningCan any experienced people guide me how to update this server variable onto my remote server. Thanx. Vijay Khanna System Analyst www.spsoftware.com Ph: 09120 - 4006154 INDIA --- -- __ Do You Yahoo!? Yahoo! Sports - Coverage of the 2002 Olympic Games http://sports.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
Re: mysql 3.23.49 porting problem on POSIX 1003.1-2001 hosts
Paul Eggert writes: Description: The new POSIX standard is now official (IEEE Std 1003.1-2001), and it has removed support for some obsolete utility options that mysql uses in a few places. Basically, the new POSIX has removed digit-string options (e.g., tail -1) and options beginning with + (e.g., sort +1). I'm using an experimental environment that insists on the new standard, so I tend to run into these problems before other people do. How-To-Repeat: Build and run Mysql on a host that insists on POSIX 1003.1-2001 semantics. Fix: 2002-02-22 Paul Eggert [EMAIL PROTECTED] * bdb/dist/s_recover: Use the standard -k option if it works; otherwise fall back on the traditional notation. * bdb/dist/s_recover, mysql-test/mysql-test-run.sh, sql-bench/server-cfg.sh: Don't use head -1. * scripts/safe_mysqld.sh: Don't use tail -1. Hi! We shall definitely pay attention to the new standard ! -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: Script (Linux 7.1)
One way is to include it in your mysql start command: mysql -u user -ppassword scriptfilename You may have to include the path with the scriptfilename. regards, det On Sat, 23 Feb 2002 13:21:27 +0530, Chetan Lavti wrote: hi, I have written a script for database creation and table creation. Now I want to run this script from the MySQL prompt. How can I do this..? Please , anybody know about this , so that I can create my database by simply running that script. Thanks and regards, Chetan Lavti - 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 3.23.49-1 rpm fails with redhat 7 thu 7.2
On Sat, Feb 23, 2002 at 01:32:11PM +1300, [EMAIL PROTECTED] wrote: Hi all, The latest rpms for mysql 3.23.49 produce a signal 4 error when attempting to run the installed mysql server. on all our servers running redhat 7 thru 7.2. Obviously this can't be a kernel 2.2.x issue, since 7.2 is on 2.4.x. I've tried multiple installs now with no success on any of our servers running the above O/S. This effects new installs of redhat, as well as existing ones while upgrading over a previous version of mysql. Join the club. I posted re: this problem several days ago and have not received any solutions thus far. I'm on 7.2, btw. ss - 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
Comments in Documentation
Has anyone noticed that the comments in the Mysql on-line docs are almost entirely always off-topic? Compare, for example, to the PHP docs www.php.net What's strange is not the number of moronic posts (minimal), but the number of useful and often insightful posts that appear to have been entered under a totally random heading in the manual. (almost all!) Because those posts are obviously intelligent, it's making me wonder if perhaps the posters tried to post to a relevant heading and the software is perhaps broken and misclassifying them... If so, this is a bug report I suppose... Steve - 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: Comments in Documentation
Also there is not LIKE at all at SELECT command on MySQL manual! I found manual very-very amateur work. I was trying about half hour to use WHERE FIELD1= mpla-mpla% Also binary at field creation or WHERE should be ON by default. And WHERE works erroneously with Greek chars (without the binary option). I think it is comfused by other languages chars so it should be an option to declare the language character set at runtime (not at server cnf). Makis -Original Message- From: Steve Rapaport [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 23, 2002 4:46 PM To: [EMAIL PROTECTED] Subject: Comments in Documentation Has anyone noticed that the comments in the Mysql on-line docs are almost entirely always off-topic? Compare, for example, to the PHP docs www.php.net What's strange is not the number of moronic posts (minimal), but the number of useful and often insightful posts that appear to have been entered under a totally random heading in the manual. (almost all!) Because those posts are obviously intelligent, it's making me wonder if perhaps the posters tried to post to a relevant heading and the software is perhaps broken and misclassifying them... If so, this is a bug report I suppose... Steve - 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
Couple of Performance tweaking questions.
hi everyone, I've got a mysql server, a quad xeon 700MHz, with 8 gigs of ram, and a raid 50 disk array running as two 50 GB partitions, shared over 8 15,000 RPM disks, on a hardware raid card, with 128Mb Cache. Running RedHat Linux 7.2, with Ext3 FS, and Kernel 2.4.9-21 Enterprise (SMP) I'm trying to tweak out the performance to the maximum usage of this hardware, and I found the following on the docs: This can be done by adding renice -20 $$ command to safe_mysqld. In our testing on a 4-CPU machine, increasing the priority gave 60% increase in throughput with 400 clients. So I added the renice -20 $$ line to safe_mysqld, and I get the following: (tailing the .err log while running safe_mysqld. [root@ac mysql]# ./bin/safe_mysqld 18249: old priority 0, new priority -20 Starting mysqld daemon with databases from /usr/local/mysql/data 020223 09:16:25 mysqld ended [root@ac mysql]# 020223 09:16:25 mysqld started nice: unrecognized option `---15' Try `nice --help' for more information. 020223 09:16:25 mysqld ended [root@ac mysql]# pico bin/safe_mysqld Here I removed the renice line and: [root@ac mysql]# ./bin/safe_mysqld Starting mysqld daemon with databases from /usr/local/mysql/data 020223 09:16:48 mysqld started /usr/local/mysql/bin/mysqld: ready for connections Any Ideas? Also, I am experiencing another strange problem, I have created: ./data/my.cnf and placed the following into it: [safe_mysqld] open-files-limit=8192 max_connections=1024 but when I run: [root@ac mysql]# ./bin/mysqladmin -p variables Enter password: | max_connections | 100 I am using: | | version | 3.23.46 of Mysql Any assistance would be greatly appreciated. I am not sure if I placed my.cnf in the wrong directory. Reading safe_mysqld seems to point that I placed it in the right place. -- Lloyd Duhon Founder Open Space Initiative http://openspaceinitiative.org/ The Exploration of the Universe is our responsibility! - 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: Comments in Documentation
At 16:01 +0200 2/23/02, savaidis wrote: Also there is not LIKE at all at SELECT command on MySQL manual! http://www.mysql.com/doc/S/t/String_comparison_functions.html http://www.mysql.com/doc/P/a/Pattern_matching.html I found manual very-very amateur work. I was trying about half hour to use WHERE FIELD1= mpla-mpla% I'm surprised that if you wanted to use LIKE, that you didn't just try it. Also binary at field creation or WHERE should be ON by default. What would the syntax be for turning it off? And WHERE works erroneously with Greek chars (without the binary option). I think it is comfused by other languages chars so it should be an option to declare the language character set at runtime (not at server cnf). Makis - 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: Comments in Documentation
I don't think the manual is very amateur like. I find it very large, somewhat imformative. I find it like hell to understand if you are a novice -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 23, 2002 10:29 AM To: savaidis; [EMAIL PROTECTED] Subject: RE: Comments in Documentation At 16:01 +0200 2/23/02, savaidis wrote: Also there is not LIKE at all at SELECT command on MySQL manual! http://www.mysql.com/doc/S/t/String_comparison_functions.html http://www.mysql.com/doc/P/a/Pattern_matching.html I found manual very-very amateur work. I was trying about half hour to use WHERE FIELD1= mpla-mpla% I'm surprised that if you wanted to use LIKE, that you didn't just try it. Also binary at field creation or WHERE should be ON by default. What would the syntax be for turning it off? And WHERE works erroneously with Greek chars (without the binary option). I think it is comfused by other languages chars so it should be an option to declare the language character set at runtime (not at server cnf). Makis - 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
can i use mysql functions to sort an alpha-numeric description alphabetically?
Hi, I have looked at the online documentation and the mysql books that I have but can find no answer. I have a field that looks like this: (8+2) Landscape I want to sort on the alphabetic characters. My mysql query does an order by this field and that returns a numeric order (which for me is not terribly useful.) So - is there a function or way I can sort this array alphabetically rather than numerically? Thanks, Nicole -- Nicole Lallande [EMAIL PROTECTED] 760.753.6766 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Naming a Provider?
Guys, I'm very new to ODBC, so please bear with, okay? I'm looking at example code in a particular windows binding package, and see the following: ... -- Open Database Open (DB_Control.Database, Provider=Microsoft.Jet.OLEDB.4.0; Data Source=..\..\tutorials\adotest.mdb); ... That statement succeeds in opening that mdb (Access) file for further manipulation. I have no idea where they came up with the information that the way you connect with an access database is to use the incantation Microsoft.Jet.OLEDB.4.0. Likewise, I have no idea what comparable magic string would specify a mysql database. 1) What string would I substitute into that code sample to connect with a mysql database instead of an access database? 2) What document should I have been looking at to discover that for myself? Thanks! --D Nyberg - 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 3.23.49-1 rpm fails with redhat 7 thu 7.2
This matter was addressed this morning by Sasha Pachev in 3.23.49 Linux binary issues To paraphrase Yogi Berra, you can learn an awful lot just by reading; in this case postings to the list in general from the development team. det On Sat, 23 Feb 2002 08:22:15 -0500, S. William Schulz wrote: On Sat, Feb 23, 2002 at 01:32:11PM +1300, [EMAIL PROTECTED] wrote: Hi all, The latest rpms for mysql 3.23.49 produce a signal 4 error when attempting to run the installed mysql server. on all our servers running redhat 7 thru 7.2. Obviously this can't be a kernel 2.2.x issue, since 7.2 is on 2.4.x. I've tried multiple installs now with no success on any of our servers running the above O/S. This effects new installs of redhat, as well as existing ones while upgrading over a previous version of mysql. Join the club. I posted re: this problem several days ago and have not received any solutions thus far. I'm on 7.2, btw. ss - 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 3.51 build for Mac OSX
Sorry, Im new here and Im sure this has been discussed ad naseum, but does anyone have information on where to get an installer for the Mac OSX version of the MyODBC drivers? The latest build I could find on the web is 2.5. (mySQL, sql, query, etc.) TIA Brian - 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
Signal 4 crashes on some x86 Linux machines
Simon and others: Signal 4 means illegal instruction. This happens when the binary users an instruction that is not compatible with your architecture. In theory, this should not happen - to our knowledge, the binary should work just fine on any architecture. However, if it does not, this means we've messed up, and we would like to know where. Anybody who gets signal 4 - please send me the output of cat /proc/cpuinfo and the stack trace. I need as much evidence as possible to track this down. -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - 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
Alter Table with InnoDB table type having foreign keys
A humble suggestion for the development team I went through and looked at some of the postings regarding using ALTER TABLE with InnoDB tables and the resulting loss of foreign key constrains. I was disappointed to learn about the need to use the create/drop workaround. The main reason I considered using InnoDB tables was to have a MySQL database that could ensure referential integrity. The thought that a command (ALTER TABLE) would silently break RI makes me very uneasy, and lessens the value I see in using MySQL. (OK, MySQL-Max) I understand that in MySQL the alter table command may in fact transparently do a create, drop and/or rename of tables, regardless of table type. But it still makes no sense to me that the ALTER TABLE command does not maintain foreign key constraints for the InnoDB table type. If MySQL does an internal create and drop to execute an alter table statement, and the table in question has a primary key, isn't the primary key transparently recreated? Isn't the same true for all other constraints?? (If not, please let me know!!) Why then shouldn't MySQL recreate the foreign key constraints too? If the reason is because the file is temporarily copied to a non InnoDB table type, couldn't the foreign key information be held temporarily in another object of some sort and applied after conversion back to InnoDB? Of course, I understand that there are priorities in development, and one should not expect to have all the bells an whistles the right away. That said, I shudder every time I open myPHPAdmin and see how easy it would be for any developer or administrator to break foreign key constraints. Therefore, I was hoping that you could consider adding foreign key support to the ALTER TABLE command, or at least consider adding an option such as innodb_fail_alter_table_with_fk that would warn or fail the alter table statement if the table type was InnoDB and foreign keys were going to be dropped. If this latter option was implemented, it would prevent RI from being quietly lost. Thanks much, -Bob - 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: Comments in Documentation
Instead of binary it sould be better to use a case conversion flag with reverse function - NOT set by default. Binary doesn't make sence to me. As for LIKE I think most WHERE commands use it so it is obvious it should be there. Makis -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 23, 2002 6:29 PM To: savaidis; [EMAIL PROTECTED] Subject: RE: Comments in Documentation At 16:01 +0200 2/23/02, savaidis wrote: Also there is not LIKE at all at SELECT command on MySQL manual! http://www.mysql.com/doc/S/t/String_comparison_functions.html http://www.mysql.com/doc/P/a/Pattern_matching.html I found manual very-very amateur work. I was trying about half hour to use WHERE FIELD1= mpla-mpla% I'm surprised that if you wanted to use LIKE, that you didn't just try it. Also binary at field creation or WHERE should be ON by default. What would the syntax be for turning it off? And WHERE works erroneously with Greek chars (without the binary option). I think it is comfused by other languages chars so it should be an option to declare the language character set at runtime (not at server cnf). Makis - 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 Help
Hi, I've got item table as follwoing: itemno|item_name 1 item one 2 item two 3 item three 4 item four 2 item two 3 item three I want to right a query so I get three rows of each item I specify in WHERE for example SELECT itemname from item WHERE itemno IN (1,2,3); Results should return first three rows of each itemno How do I write such query? Thanx - 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: Naming a Provider?
Hi, -Original Message- From: D Nyberg [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 23, 2002 9:30 AM To: [EMAIL PROTECTED] Subject: Naming a Provider? Guys, I'm very new to ODBC, so please bear with, okay? I'm looking at example code in a particular windows binding package, and see the following: ... -- Open Database Open (DB_Control.Database, Provider=Microsoft.Jet.OLEDB.4.0; Data Source=..\..\tutorials\adotest.mdb); ... That statement succeeds in opening that mdb (Access) file for further manipulation. I have no idea where they came up with the information that the way you connect with an access database is to use the incantation Microsoft.Jet.OLEDB.4.0. Likewise, I have no idea what comparable magic string would specify a mysql database. 1) What string would I substitute into that code sample to connect with a mysql database instead of an access database? It depends up on which provider and programming language you are trying to use. To know what connection string(s) can be used to access MySQL through (My)ODBC, refer to the following samples: http://www.mysql.com/products/myodbc/faq.html#SAMPLE_-_VB 2) What document should I have been looking at to discover that for myself? MyODBC : http://www.mysql.com/products/myodbc/ ODBC : http://www.microsoft.com/data Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ 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: MyODBC 3.51 build for Mac OSX
Hi, -Original Message- From: Brian Reed [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 23, 2002 9:52 AM To: [EMAIL PROTECTED] Subject: MyODBC 3.51 build for Mac OSX Sorry, Im new here and Im sure this has been discussed ad naseum, but does anyone have information on where to get an installer for the Mac OSX version of the MyODBC drivers? The latest build I could find on the web is 2.5. The 3.51 Mac build is not available for downloads. Possibly will add from 3.51.02 versions onwards. The alternative is to download the source and build the driver yourself. Here is a mail which describes how to build 3.51 driver on Mac. http://lists.mysql.com/cgi-ez/ezmlm-cgi?5:mss:4816:200202:kikmibdplecdpppfcd jm Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ 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-post] MySQL on OpenBSD/sparc64?
[I didn't get a response from openbsd-sparc, so I'm trying here. Any help would be appreciated!] I'm trying to get a MySQL server running under a recent OpenBSD 3.0 snapshot on an Ultra 5, but I'm not having much luck. I tried installing the binary mysql-server package (from 3.0/packages/sparc64/), but it looks like the mysqld in that package is linked against libwrap1.2, whereas 2.0 is included in that snapshot (and 3.0 itself, too?). I've also tried compiling the mysql packages from the ports collection, but gen_lex_hash complains that it can't find an ideal hash and prompts me to run it with --search. gen_lex_hash --search yields: # ./gen_lex_hash --search lex_hash.h Fatal error when generating hash for symbols Didn't find suitable values for perfect hashing: You have to edit gen_lex_hash.cc to generate a new hashing function. You can try running gen_lex_hash with --search to find a suitable value Symbol array size = 8000 Symbols: 311 Functions: 123; Total: 434 Shifts per char: 3, Array size: 5303 Error: Got duplicate value for symbol 'FUNCTION' I've tried running it a few times (at a couple hours' runtime a shot), but get the same thing every time, just with a different symbol. Has anyone else gotten mysql-server built and installed on OpenBSD 3.0/sparc64? thanks, john -- John Morrissey _o/\ __o [EMAIL PROTECTED]_- \_ / \ \, www.horde.net/__(_)/_(_)/\___(_) /_(_)__ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Comments in Documentation
At 19:28 +0200 2/23/02, savaidis wrote: Instead of binary it sould be better to use a case conversion flag with reverse function - NOT set by default. You have to have *something* on by default. I guess I don't understand what you're getting at. I'd say BINARY is reasonably concise. Perhaps you have an alternative, but you haven't actually specified any syntax, so it's difficult to say whether or not it might be better. Binary doesn't make sence to me. BINARY is nothing more than a synonym for case sensitive. As for LIKE I think most WHERE commands use it so it is obvious it should be there. I disagree. It is not obvious in the slightest that the section on WHERE should be turned into a list of possible functions that can be used there. Most such functions can also be used in the output column list, ORDER BY, GROUP BY, etc. Functions should be documented in the section on functions. As, in fact, they are. Makis -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 23, 2002 6:29 PM To: savaidis; [EMAIL PROTECTED] Subject: RE: Comments in Documentation At 16:01 +0200 2/23/02, savaidis wrote: Also there is not LIKE at all at SELECT command on MySQL manual! http://www.mysql.com/doc/S/t/String_comparison_functions.html http://www.mysql.com/doc/P/a/Pattern_matching.html I found manual very-very amateur work. I was trying about half hour to use WHERE FIELD1= mpla-mpla% I'm surprised that if you wanted to use LIKE, that you didn't just try it. Also binary at field creation or WHERE should be ON by default. What would the syntax be for turning it off? And WHERE works erroneously with Greek chars (without the binary option). I think it is comfused by other languages chars so it should be an option to declare the language character set at runtime (not at server cnf). Makis - 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
benchmarks?
I'm using still a very small MySQL database -just testing yet- but I read many people talking about some Gigas of data. I wonder where can I find some benchmarks about MySQL with various O.S. I work with MySQLFront and: Is there a way not to loose data when I change a field i.e from INT to FLOAT? (not only data of INT field but all fields before)It works if I save to txt first? And I declare in 2 INT fields but it creates one field INT(3) and another INT(5) as I see at SQL window. Why? Thanks Makis QUERY - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Comments in Documentation
I say by default means to do nothing, not to do the upercase conversion as I suppose it does to the fields. I haven't met since now the binary as an alternative to case sensitive and I'm quite old in programming and age believe me :) Also if I knew SQL already, then I didn't have to read the MySQL manual. If you don't know there is a LIKE function then how to go and look for it? Makis -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 23, 2002 10:21 PM To: savaidis; [EMAIL PROTECTED] Subject: RE: Comments in Documentation At 19:28 +0200 2/23/02, savaidis wrote: Instead of binary it sould be better to use a case conversion flag with reverse function - NOT set by default. You have to have *something* on by default. I guess I don't understand what you're getting at. I'd say BINARY is reasonably concise. Perhaps you have an alternative, but you haven't actually specified any syntax, so it's difficult to say whether or not it might be better. Binary doesn't make sence to me. BINARY is nothing more than a synonym for case sensitive. As for LIKE I think most WHERE commands use it so it is obvious it should be there. I disagree. It is not obvious in the slightest that the section on WHERE should be turned into a list of possible functions that can be used there. Most such functions can also be used in the output column list, ORDER BY, GROUP BY, etc. Functions should be documented in the section on functions. As, in fact, they are. Makis -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 23, 2002 6:29 PM To: savaidis; [EMAIL PROTECTED] Subject: RE: Comments in Documentation At 16:01 +0200 2/23/02, savaidis wrote: Also there is not LIKE at all at SELECT command on MySQL manual! http://www.mysql.com/doc/S/t/String_comparison_functions.html http://www.mysql.com/doc/P/a/Pattern_matching.html I found manual very-very amateur work. I was trying about half hour to use WHERE FIELD1= mpla-mpla% I'm surprised that if you wanted to use LIKE, that you didn't just try it. Also binary at field creation or WHERE should be ON by default. What would the syntax be for turning it off? And WHERE works erroneously with Greek chars (without the binary option). I think it is comfused by other languages chars so it should be an option to declare the language character set at runtime (not at server cnf). Makis - 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
Doc Bug: Comments in Documentation
Um, hello? I wasn't trying to turn this into a general bitch session on the manual, and I really don't think that's appropriate. Worse, it obscures and devalues the value of the bug report. I'm just trying to draw attention to a possible software malfunction in the commentary section of the online docs. If you are a tech writer or other employee with mysql.com, please skip the following bracketed paragraphs, they're for others: [[ Please, if you wish to argue about the use of WHERE or case-sensitive searches, do it on some other Subject line, okay? The focus here is specifically on the COMMENTS in the ON-LINE DOCUMENTATION of MYSQL. Those COMMENTS are usually totally irrelevant to the topic being discussed, which makes them USELESS. ]] I will offer an example: Looking for commentary and useful tips on INSERT...SELECT syntax: http://www.mysql.com/doc/I/N/INSERT_SELECT.html What I find begins thus: yval : Note that the input to INET_NTOA, and the output from INET_ATON are in host byte order. Michael Babcock [EMAIL PROTECTED]: As opposed to left.id = right.id, a LEFT join means that all of the left table's IDs are displayed, and only those rows in the right table with the same IDs are joined in. Vice versa for a RIGHT join. Ari Ukkonen [EMAIL PROTECTED]: I think Boolean or logical type is badly needed in Mysql. You can use an Enum and IS NOT NULL/IS NULL in your statements to simulate this to test for the existence or absence of NULL values but this is not an elegant solution. Daniel Scherly [EMAIL PROTECTED]: Example how to use the DATE_FORMAT function to reformat a DATETIME (-MM-DD hh:mm:ss) column and output the newly formated date with PHP: . . . etc., etc. All valuable and appropriate comments, no doubt. FOR SOME OTHER PART OF THE MANUAL. I hope some tech writer at Mysql AB is reading this. Steve Rapaport - 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: Comments in Documentation
At 19:54 +0200 2/23/02, savaidis wrote: I say by default means to do nothing, not to do the upercase conversion as I suppose it does to the fields. As it happens, the standard SQL behavior for LIKE is to not be case sensitive. Which is roughly equivalent to doing an uppercase conversion. You appear to be saying that it's a bad thing for MySQL to use the standard behavior. I haven't met since now the binary as an alternative to case sensitive and I'm quite old in programming and age believe me :) Also if I knew SQL already, then I didn't have to read the MySQL manual. If you don't know there is a LIKE function then how to go and look for it? Your original question appeared to imply that you already knew about LIKE, and that you were wondering where it was in the manual. Not that you were wondering whether there was any such thing in SQL itself. Makis -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 23, 2002 10:21 PM To: savaidis; [EMAIL PROTECTED] Subject: RE: Comments in Documentation At 19:28 +0200 2/23/02, savaidis wrote: Instead of binary it sould be better to use a case conversion flag with reverse function - NOT set by default. You have to have *something* on by default. I guess I don't understand what you're getting at. I'd say BINARY is reasonably concise. Perhaps you have an alternative, but you haven't actually specified any syntax, so it's difficult to say whether or not it might be better. Binary doesn't make sence to me. BINARY is nothing more than a synonym for case sensitive. As for LIKE I think most WHERE commands use it so it is obvious it should be there. I disagree. It is not obvious in the slightest that the section on WHERE should be turned into a list of possible functions that can be used there. Most such functions can also be used in the output column list, ORDER BY, GROUP BY, etc. Functions should be documented in the section on functions. As, in fact, they are. Makis -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 23, 2002 6:29 PM To: savaidis; [EMAIL PROTECTED] Subject: RE: Comments in Documentation At 16:01 +0200 2/23/02, savaidis wrote: Also there is not LIKE at all at SELECT command on MySQL manual! http://www.mysql.com/doc/S/t/String_comparison_functions.html http://www.mysql.com/doc/P/a/Pattern_matching.html I found manual very-very amateur work. I was trying about half hour to use WHERE FIELD1= mpla-mpla% I'm surprised that if you wanted to use LIKE, that you didn't just try it. Also binary at field creation or WHERE should be ON by default. What would the syntax be for turning it off? And WHERE works erroneously with Greek chars (without the binary option). I think it is comfused by other languages chars so it should be an option to declare the language character set at runtime (not at server cnf). Makis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Query Help
Hi Pinkesh, I've got item table as follwoing: itemno|item_name 1 item one 2 item two 3 item three 4 item four 2 item two 3 item three I want to right a query so I get three rows of each item I specify in WHERE for example SELECT itemname from item WHERE itemno IN (1,2,3); Results should return first three rows of each itemno How do I write such query? Your question is slightly ambiguous, but I assume that you want a resultset containing a maximum of three rows WHERE itemno = 1, a maximum of three rows WHERE itemno = 2, and a maximum of three rows WHERE itemno = 3. In which case the answer is: I don't think you can. Unfortunately the (above) query realises the entire sample tbl excepting the single row itemno=4 and item_name=item four, and there are not more than three rows which share any particularly itemno value. (so in abstracting your real problem, you have left no 'hints' for us to be able to offer more than a clinical observation!?) RTFM 6.4.1 SELECT Syntax [LIMIT [offset,] rows] The LIMIT clause allows the control of output to be limited to a range of row numbers out of the complete resultset table. Thus you could limit to nine rows (for example), but there's no guarantee that the resultset would contain an equal number of 1s, 2s, and 3s (assuming that they are available in the original table). At this time, there is no facility to combine (say) the GROUP BY and LIMIT clauses - which might be the answer you seek. Beyond that, what you appear to be asking is not part of the relational model/the design of SQL. Your only other approach would be to post-process the resultset using a scripting/programming language/application. Regards, =dn - 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
Connection from java
I am using mysql 4.0 on linux and mm.mysql 2.0.11, however I can't access mysql from java application. try { Class.forName( org.gjt.mm.mysql.Driver ).newInstance(); Connection connection = DriverManager.getConnection (jdbc:mysql://localhost/test?user=xxxpassword=yyy ); //or connection = DriverManager.getConnection (jdbc:mysql://localhost/test, xxx, yyy ); The error shows SQLException: Invalid authorization spectification. Access denied... Then I tried connection = DriverManager.getConnection (jdbc:mysql:test, xxx, yyy ); Now it shows SQLException: no suitable driver.. Does anybody know how to solve it? Thanks! I have no such problem on win platform, but it acts strange on linux. yp _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - 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: can i use mysql functions to sort an alpha-numeric description alphabetically?
Hi Nicole, Perhaps it's me, but I'm having trouble following you - as I did with the question I've just finished responding to... I have looked at the online documentation and the mysql books that I have but can find no answer. I have a field that looks like this: (8+2) Landscape I take it that this is the data value stored in the field. What does the schema look like? I want to sort on the alphabetic characters. My mysql query does an order by this field and that returns a numeric order (which for me is not terribly useful.) What do you mean by numeric order? If there was another row containing: (72+18) Landscape Then it would likely appear before the row you mentioned - and not in a numeric sequence at all. Do you mean that you want the parentheses, the digits, the plus sign, AND the space character ignored for the purposes od the sequence, and thereafter that the values should be treated as alpha? Is there any possibility of numerics appearing after the first alpha character? Would that matter or would they have to be ignored as well? So - is there a function or way I can sort this array alphabetically rather than numerically? Yes there are various ways and means, right up to the 'expensive' regular expression function. I think we can solve this one quickly enough - given a good understanding so we don't end up chasing red herrings! Please post the query you are using currently, together with a few rows of output. Then highlight the problem by showing the sequence that you would prefer to see. Please advise, =dn - 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: can i use mysql functions to sort an alpha-numeric description alphabetically?
Sorry Dan, I had actually replied to Steve who had asked the same question but I forgot to reply to the list with this: here is the query: select catval,catdescr from embiteccat where catzid=$zid and catlid=$lid and catunder=$cat order by catdescr; Here is a some data: 36,1,1,,0,0,2(12+1) Long,,,0,0,prodsku,,6,:6:36:,0,0,1,10 38,1,1,,0,0,24+1 Landscape,,,0,0,prodsku,,6,:6:38:,0,0,1,10 41,1,1,,0,0,6 Portrait,,,0,0,prodsku,,6,:6:41:,0,0,1,10 43,1,1,,0,0,24+1 Long,,,0,0,prodsku,,6,:6:43:,0,0,1,10 44,1,1,,0,0,2(24+1) X-Long,,,0,0,prodsku,,6,:6:44:,0,0,1,10 where catdesc is the 7th field (ie, 2(12+1) Long etc. So far all I can think of is that I have to load it into an array, sort the array with some php function or grep and then spit it out... So - yes you are correct - I want everything before the alphabetic characters, (number, parenthesis, + sign) to be ignored and then to sort by the alpha. TIA, Nicole DL Neil wrote: Hi Nicole, Perhaps it's me, but I'm having trouble following you - as I did with the question I've just finished responding to... I have looked at the online documentation and the mysql books that I have but can find no answer. I have a field that looks like this: (8+2) Landscape I take it that this is the data value stored in the field. What does the schema look like? I want to sort on the alphabetic characters. My mysql query does an order by this field and that returns a numeric order (which for me is not terribly useful.) What do you mean by numeric order? If there was another row containing: (72+18) Landscape Then it would likely appear before the row you mentioned - and not in a numeric sequence at all. Do you mean that you want the parentheses, the digits, the plus sign, AND the space character ignored for the purposes od the sequence, and thereafter that the values should be treated as alpha? Is there any possibility of numerics appearing after the first alpha character? Would that matter or would they have to be ignored as well? So - is there a function or way I can sort this array alphabetically rather than numerically? Yes there are various ways and means, right up to the 'expensive' regular expression function. I think we can solve this one quickly enough - given a good understanding so we don't end up chasing red herrings! Please post the query you are using currently, together with a few rows of output. Then highlight the problem by showing the sequence that you would prefer to see. Please advise, =dn - 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 -- Nicole Lallande [EMAIL PROTECTED] 760.753.6766 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
C API, MySql ver 3.23.49 and Apache ver 1.3.23
I've got this problem that now since I updated mysql to ver 3.23.49 and recompiled some of my working cgi scripts Apache is complaining about a server error. Premature end of header scripts. If I use the cgi that I compiled before the upgrade everything is fine. It's the exact same code. I've narrowed it down to the function mysql_real_connect(). I can use mysql_init() to inizalize the mysql variable and mysql_options() and the cgi script runs without crashing on the apache server. Of course the script isn't doing what I want it to because I have to comment everything out because I can't make a connection to the database. everything works great when I run it in debug mode giving the cgi all the env variables but not running the script through the server. The html code that is produced can be loaded into a page and looks and works fine. I've tried installing 3.23.46 which was the version of mysql that I had before over top of ver 49 and recompiled the cgi script but that didn't fix anything. Does anyone have any answers as to why this happened. Does anyone know how to rip all of mysql out and start from scratch instead of reloading the os. Any suggestions please. :) 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
Re: mysql under FreeBSD 4.5
On Fri, Feb 22, 2002 at 12:10:52AM -0700, [EMAIL PROTECTED] wrote: Just recently installed FreeBSD 4.5-RELEASE and cvsup'd to latest 4-STABLE. Updated ports tree and did a make install in /usr/ports/databases/mysql323-server and received the following on the mysql_install_db part: I have not tried to install MySQL under 4.5-RELEASE yet, but, in the past, I've never failed to build MySQL from source under FreeBSD. What is the port accomplishing? Maybe you could trying installing MySQL from source. Merely a suggestion; I realize this doesn't answer your question, though... /usr/local/bin/mysql_install_db Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables Fatal error 'Can't create gc thread' at line ? in file /usr/src/lib/libc_r/uthread/uthread _create.c (errno = ?) Abort trap - core dumped Installation of grant tables failed! Hmm, one problem I _did_ have, way back when: MySQL's makefiles try to use '-O6' as a compiler flag. Try setting that to something sane like '-O2'. From source, I was doing this (to prevent segfaults under 4.1-RELEASE): env CC=gcc CFLAGS=-O2 CXX=gcc \ CXXFLAGS=-O2 -felide-constructors -fno-exceptions -fno-rtti \ ./configure \ --disable-shared \ --enable-assembler \ --enable-large-files \ --without-debug Good luck... -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - 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: off-line development tool?
If I rember well MySQLdump is a utility. I can run that at my local machine, but how to do the reverse thing at the remote machine. I can't run much more than HTML and PHP scripts there. Is there a tool that can convert the MySQLdump export file into something that looks like a PHP script and that I could unleash a CREATE command on? Thanks, Marco From: Eric Mayers [EMAIL PROTECTED] To: Marco Bleeker [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: RE: off-line development tool? Date: Fri, 22 Feb 2002 18:27:23 -0800 I suggest you install a MySQL Database on a local machine and do development there. When you want to push this stuff to the remote machine use mysqldump to pull the contents out of the local database. I don't think it would be appropriate for this but you might consider database replication if you want it to be a more automatic process. Eric Mayers Software Engineer I Captus Networks -Original Message- From: Marco Bleeker [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 5:59 PM To: [EMAIL PROTECTED] Subject: off-line development tool? Hello, I am a beginning MySQL and PHP user. I will run a MySQL database on a remote hosting server, and I have only limited access to the database at that server. I want to populate my database off-line at my home machine, and then upload the whole thing (100s of lengthy entries) to the server. But I don't have direct access there. So I suppose I'll have to do something like exporting my data to a text file, upload the text file to the root of my domain at the server and re-create the database from there. I don't think I can run any tool on the server; I work with .php files there. So my question is: how would people normally go about this task. Would I need to write a script for in- and export of data, or would there perhaps be a handy tool that takes this out of my hands? Thanks, Marco Bleeker, Amsterdam _ MSN Foto's is de eenvoudigste manier om je foto's te delen en af te drukken: http://photos.msn.nl/Support/WorldWide.aspx - 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 Marco Bleeker, Amsterdam _ Download MSN Explorer gratis van http://explorer.msn.nl/intl.asp. - 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: can i use mysql functions to sort an alpha-numeric description alphabetically?
Nicole, RTFM: 6.3 Functions for Use in SELECT and WHERE Clauses in particular the String Functions If the first space (in every row) can be taken as the 'marker' of what to remove (including the space itself), then take a look at the following: SELECT catval, RIGHT( strcatdescr, POSITION( ' ' IN strcatdescr ) + 1 ) AS cd FROM embiteccat WHERE catzid=$zid AND catlid=$lid AND catunder=$cat ORDER BY cd; If however there may be more than one space prior to the commencement of the alpha data, then can we search for the last space (ie the first from the right-hand end of the field)? In which case substitute: SUBSTRING_INDEX( strcatdescr, ' ', -1 ) AS cd It's kind of fun to play games like this, but it isn't very 'relational'. Both of the assumptions (above) are not 'good form'. Even if one is acceptable to you, and of course 'in spades' if neither is, should be the consideration of adding another column to the table for sequencing purposes. How are we doing? =dn (David) Sorry Dan, I had actually replied to Steve who had asked the same question but I forgot to reply to the list with this: here is the query: select catval,catdescr from embiteccat where catzid=$zid and catlid=$lid and catunder=$cat order by catdescr; Here is a some data: 36,1,1,,0,0,2(12+1) Long,,,0,0,prodsku,,6,:6:36:,0,0,1,10 38,1,1,,0,0,24+1 Landscape,,,0,0,prodsku,,6,:6:38:,0,0,1,10 41,1,1,,0,0,6 Portrait,,,0,0,prodsku,,6,:6:41:,0,0,1,10 43,1,1,,0,0,24+1 Long,,,0,0,prodsku,,6,:6:43:,0,0,1,10 44,1,1,,0,0,2(24+1) X-Long,,,0,0,prodsku,,6,:6:44:,0,0,1,10 where catdesc is the 7th field (ie, 2(12+1) Long etc. So far all I can think of is that I have to load it into an array, sort the array with some php function or grep and then spit it out... So - yes you are correct - I want everything before the alphabetic characters, (number, parenthesis, + sign) to be ignored and then to sort by the alpha. TIA, Nicole DL Neil wrote: Hi Nicole, Perhaps it's me, but I'm having trouble following you - as I did with the question I've just finished responding to... I have looked at the online documentation and the mysql books that I have but can find no answer. I have a field that looks like this: (8+2) Landscape I take it that this is the data value stored in the field. What does the schema look like? I want to sort on the alphabetic characters. My mysql query does an order by this field and that returns a numeric order (which for me is not terribly useful.) What do you mean by numeric order? If there was another row containing: (72+18) Landscape Then it would likely appear before the row you mentioned - and not in a numeric sequence at all. Do you mean that you want the parentheses, the digits, the plus sign, AND the space character ignored for the purposes od the sequence, and thereafter that the values should be treated as alpha? Is there any possibility of numerics appearing after the first alpha character? Would that matter or would they have to be ignored as well? So - is there a function or way I can sort this array alphabetically rather than numerically? Yes there are various ways and means, right up to the 'expensive' regular expression function. I think we can solve this one quickly enough - given a good understanding so we don't end up chasing red herrings! Please post the query you are using currently, together with a few rows of output. Then highlight the problem by showing the sequence that you would prefer to see. Please advise, =dn - 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 -- Nicole Lallande [EMAIL PROTECTED] 760.753.6766 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mysql dies with Signal 11
Hi, I seem to be getting intermittant crashes of mysql. The error log prints the following, 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 against 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=268431360 record_buffer=1044480 sort_buffer=1048568 max_used_connections=5 max_connections=100 threads_connected=5 It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer)*max_connections = 466539 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. 020223 13:00:01 mysqld restarted InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 82 1555315003 etc... Can some please suggest what steps I can take to discovering what is wrong. I have attached server info and gdb output to bottom of email. This is a very active server processing 150 apache hits a second. A seperate looped process takes cgi data inserted into an IPC MSGQ and sticks it in the db and another seperate looped process takes data from this db and dumps to a db on a remote machine. Richard p.s. Your MySQL connection id is 7 to server version: 4.0.0-alpha-log I'm running a dual 1ghz FreeBSD box with 1gig of ram. (gdb) run -u mysql Starting program: /usr/local/mysql/libexec/mysqld -u mysql 020223 14:09:16 InnoDB: Started /usr/local/mysql/libexec/mysqld: ready for connections (after about 8hrs.) Program received signal SIGSEGV, Segmentation fault. 0x82011ce in memcpy () (gdb) info threads 14 process 31905, thread 14 0x81df52d in _thread_kern_sched () 13 process 31905, thread 13 0x81df52d in _thread_kern_sched () 12 process 31905, thread 12 0x81df52d in _thread_kern_sched () 11 process 31905, thread 11 0x81df52d in _thread_kern_sched () 10 process 31905, thread 10 0x81df52d in _thread_kern_sched () 9 process 31905, thread 9 0x81df52d in _thread_kern_sched () 8 process 31905, thread 8 0x81df52d in _thread_kern_sched () 7 process 31905, thread 7 0x81df52d in _thread_kern_sched () 6 process 31905, thread 6 0x81df52d in _thread_kern_sched () 5 process 31905, thread 5 0x81df52d in _thread_kern_sched () 4 process 31905, thread 4 0x81df52d in _thread_kern_sched () 3 process 31905, thread 3 0x82013dc in _thread_sys_close () 2 process 31905, thread 2 0x81df52d in _thread_kern_sched () * 1 process 31905, thread 1 0x82011ce in memcpy () (gdb) thread 1 [Switching to thread 1 (process 31905, thread 1)] #0 0x82011ce in memcpy () (gdb) bt #0 0x82011ce in memcpy () #1 0x82a33c0 in mysql_bin_log () #2 0x80b7cd8 in ha_commit_trans () #3 0x8076e24 in mysql_execute_command () #4 0x80788c8 in mysql_parse () #5 0x8073454 in dispatch_command () #6 0x80784c5 in do_command () #7 0x80728f4 in handle_one_connection () #8 0x81d446d in _thread_start () #9 0x0 in ?? () (gdb) thread 2 [Switching to thread 2 (process 31905, thread 2)] #0 0x81df52d in _thread_kern_sched () (gdb) bt #0 0x81df52d in _thread_kern_sched () #1 0x81dfdb7 in _thread_kern_sched_state () #2 0x81dd4fc in _read () #3 0x81dd56a in read () #4 0x81ad019 in vio_read () #5 0x806945b in my_real_read () #6 0x806973e in my_net_read () #7 0x80784a8 in do_command () #8 0x80728f4 in handle_one_connection () #9 0x81d446d in _thread_start () #10 0x0 in ?? () (gdb) thread 3 [Switching to thread 3 (process 31905, thread 3)] #0 0x82013dc in _thread_sys_close () (gdb) bt #0 0x82013dc in _thread_sys_close () Error accessing memory address 0xe2fa6fd4: Bad address. (gdb) thread 4 [Switching to thread 4 (process 31905, thread 4)] #0 0x81df52d in _thread_kern_sched () (gdb) bt #0 0x81df52d in _thread_kern_sched () #1 0x81dfdb7 in _thread_kern_sched_state () #2 0x81dd4fc in _read () #3 0x81dd56a in read () #4 0x81ad019 in vio_read () #5 0x806945b in my_real_read () #6 0x806973e in my_net_read () #7 0x80784a8 in do_command () #8 0x80728f4 in handle_one_connection () #9 0x81d446d in _thread_start () #10 0x0 in ?? () (gdb) thread 5 [Switching to thread 5 (process 31905, thread 5)] #0 0x81df52d in _thread_kern_sched () (gdb) bt #0 0x81df52d in _thread_kern_sched () #1 0x81dfdb7 in _thread_kern_sched_state () #2 0x81d3802 in sigwait () #3 0x806dc25 in signal_hand () #4 0x81d446d in _thread_start () #5 0x0 in ?? () (gdb) thread 6 [Switching to thread 6 (process 31905, thread 6)] #0 0x81df52d in _thread_kern_sched () (gdb) bt #0 0x81df52d in _thread_kern_sched () #1 0x81dfdb7 in _thread_kern_sched_state () #2 0x81dd29f in select () #3 0x817ab38 in os_thread_sleep () #4 0x80de4f6 in srv_master_thread () #5 0x81d446d in
Re: Comments in Documentation
On Sat, Feb 23, 2002 at 07:28:04PM +0200, savaidis wrote: Instead of binary it sould be better to use a case conversion flag with reverse function - NOT set by default. Binary doesn't make sence to me. As for LIKE I think most WHERE commands use it so it is obvious it should be there. Sir, I'm a database developer. I write a lot of SQL statements, 99% of which have WHERE clauses. I doubt that I've used LIKE as much as three times in the last year. I also like the comparison settings the way they are. The manual is not intended to teach you to use MySQL. It's intended as a comprehensive reference document. If you want a primer, buy Paul's book. If you want something free and online for beginners, cruise to the MySQL FAQ. I learned my first programming language from the vendor's reference manual. I don't recommend it. Bob Hall -- Database, table, query, eggs, milk, bagels, cheese, cabbage, salt. Now what did I do with my shopping list? - 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