DSNless DB connection with MySQL/ASP
Is it possible to procede to a DSNless connection to a mySQL DB in ASP ? If so could anyone send me a example script ? Thank you. Nicolas Villatte IT Manager Creative Web Rue Kessels straat, 38 1030 Brussels Office Phone: +32 2 2450110 Office Fax: +32 2 2161628 Mobile Phone : +32 477 588136 Internet Mail: mailto:[EMAIL PROTECTED] Visit us on the web: http://www.creativeweb.be - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: New ODBC
This means that the host mbtpc20.bau-verm.uni-karlsruhe.de is not allowed to connect to your server. You can set this up rather easily with the standard mysql GUI admin tool. Also have a read on creating/working with users in the on-line searchable documentation of MySQL greetings, Joris -Original Message- From: Wawan Setiawan [mailto:[EMAIL PROTECTED]] Sent: woensdag 28 maart 2001 4:35 To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]' Subject: New ODBC Hello, I'm new here ... I'm trying to use MySQL qith ASP, so I use ODBC .., but when I'm trying to connect to the server, it always respons: Microsoft OLE DB Provider for ODBC Drivers error '80004005' [TCX][MyODBC]Access denied for user: '[EMAIL PROTECTED]@mbtpc20.bau-verm.uni-karlsruhe.de' (Using password: YES) Any idea on this ..? Thank you for your reply -ws- - 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
Betr.: Hello
Dear Robert, If I'm correct you've installed a mysql server on your webserver, I hope that you used the documentation which is provided on the mysql-website. I hope that you're sure about the ability to use scripting-languages on your server and that they can interact with mysql. If you already have no clue what I'm talking about please visit www.devshed.com en start reading the excelent tutorials which are provided here. I advise you to use PHP as a scripting language, if you need to learn this language you can again start with the tutorials on www.devshed.com Fear not, PHP is an easy language to learn than perl an 100% devoted for internet use. Ditch dreamweaver for your coding because it was just not made for this! Use it only to create the graphical side of your php-pages. keep things simple and use a plain-textditor to hack your code. I'ts not easy to just build a web-app! Maarten "Robert R. Willis" [EMAIL PROTECTED] 28-03-01 09:48 I have mysql added to from my server to start a dating service. They are clueless as to tell me how to get script to query the data base. But they did direct me here. Can you help me find the right scripts to get started implementing my pages with Dreamweaver. Are there any perl script ready made pages that I can reconstruct? Please help, I've been working on this for 2 days and feel that I've got nowhere. Thanks, Robert Willis 617-337-1598 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Reserved word/ Ambiguous Column title 'Key'
Hi, I am importing an Access 97 Database into MySQL. One of tables tblSuppliers holds all the critical supplier information and has a 4 character Primary key called 'Key' This is heavily used throughout a lot of VB code in the Access GUI and can't really be changed easily. When I import the Access tables into MYSQL, they lose their indexes and primary keys. Try as I might, I can't change the properties of the Key column using Alter Table, it keeps coming back with syntax errors. I'm currently stuck on the following, ALTER TABLE tblSuppliers CHANGE Key Key CHAR(6) NOT NULL What am I doing wrong/ is there a work round? Thanks in advance for you help. Richard Harris
Auto Incrementing Numbers
Hi I am wanting to use auto incrementing numbers. Now I know that if I add an entry to the db then the number is auto assigned. Now what I want is it where I can get the next auto number and then add my entry using this number. The reason for this is that I need this number for a number of tables as it is the primary key. Now I know this is possible in Oracle and Postgress because you retrieve the next number and use it. When you retrieve the number it automatically increments so that the same number cannot be given out twice ie. concurrency issues. Is there a method in MySQl for doing this. Thanks Sean ~~~ Sean Preston [EMAIL PROTECTED] GNU/Linux, the OS of choice - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: signal 11, segmentation fault :(
I had this segmentationone but that was using java (1.3 form IBM on Red Hat 6.2) and that was an exception that stopped my Web Apps I switch both jdk (I use Sun know) and driver mm...2.0.2 to 2.0.3 and I never have this exception ever since. I hope that helps. At 18:47 27/03/2001 -0800, you wrote: Greetings Is anyone else having troubles running mysql-3.23.35 or mysql-3.23.36 on FreeBSD 4.2-Stable or 4.3-X Whether I install it via the port, or via a downloaded source-compile when I run it it gives me a signal 11, segmentation fault.. Thanks Nicole [EMAIL PROTECTED] |\ __ /| (`\ http://www.unixgirl.com/ [EMAIL PROTECTED] | o_o |__ ) ) http://www.dangermouse.org/ [EMAIL PROTECTED] // \\http://www.deviantimages.com/ ---(((---((( -- Powered by Coka-Cola and FreeBSD -- -- I don't speak for anybody but myself - That's enough trouble -- -- Back Up My Hard Drive? I Can't Find The Reverse Switch! -- - As Rocky Horror Says: Don't dream it.. Do it! - - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
pictures and MS Word graphics in an Access front end
I'm converting a MS Access database to a mySQL database. All seems to be fine. But I have problems with MS Access fields of the type (german) OLE-Objekt (probably OLE object in the English version). These fields are converted to LONGBLOBs. In Access, I can fill these fields with graphics or other OLE objects either embedded or referenced. Even with Access as a front end to a mySQL server it is possible to copy and paste data into these fields. But as soon as I leave the data set and come back, the fields seem to be empty. I receive no error message at all. It only seems to be so that Access cannot handle the information in the field in the right way. Access front end with a genuine Access database can determine the type of the OLE object in the field, Access with a mySQL server database can't. Is this true? Please give me information as concerning this problem and how to handle graphics and embedded object with a mySQL server. Thank you in advance Per Warter University of Hamburg Research Centre 538 Multilingualism e-mail: [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: MySQL 3.23.36 SIGSEGV on start
[EMAIL PROTECTED] writes: Description: MySQL 3.23.36, built on a lunix-2.4.2 system using identical configuration to the previous MySQL-3.23.35 build, dies immediately upon launch with a SIGSEGV. How-To-Repeat: All that's necessary on this system is to try to start MySQL. Fix: Unknown. Submitter-Id: submitter ID Originator: Organization: Babylon Communications MySQL support: none Synopsis: MySQL 3.23.36 dies on start Severity: critical Priority: high Category: mysql Class: sw-bug Release:mysql-3.23.36 (Source distribution) Environment: System: Linux babylon5 2.4.2 #4 Tue Mar 20 21:33:26 PST 2001 i586 unknown Architecture: i586 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i586-pc-linux-gnu/2.95.2/specs gcc version 2.95.2 19991024 (release) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Aug 25 2000 /lib/libc.so.6 - libc-2.1.3.so -rwxr-xr-x1 root root 4128413 Aug 25 2000 /lib/libc-2.1.3.so -rw-r--r--1 root root 19188538 Aug 25 2000 /usr/lib/libc.a -rw-rw-r--1 root root 178 Aug 25 2000 /usr/lib/libc.so Configure command: ./configure --prefix=/opt/mysql --with-gnu-ld --with-pthread --with-mysqld-user=mysql --with-libwrap --with-berkeley-db --with-innobase Hi! 3.23.36 has passed all our tests. So please, see what logs are saying. If nothing, build it --with-debug and start with --debug and see where it crashes. 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
MySQL and StarOffice database via ODBC
Hi, I am trying to link a MySQL database (linux) with a StarOffice client on Windows, with MyODBC installed. I created the database, tables, set up select,update,delete,insert privileges on all tables in it from the host running StarOffice. I can list tables, can insert data into them via manually created SQL statements. If I create a form for data input, the toolbar StarOffice database puts on the screen has the "Insert new record" button disabled. Can anybody help me? Am i doing something wrong ? The manual, and the commented one at www.mysql.com contains nothing about staroffice. Thank you. = ing. Andrei Boros Centrul pt. Tehnologia Informatiei Societatea Romana de Radiodifuziune __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/?.refer=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
MYSQLGui
Maybe this question is out of topic, but I'm feeling really unhappy. I'm trying to compile MysqlGui, but at the end it always says, that there are no -lrc an -lrcl libraries. And that's the point. I have no idea, what libraries I should download (I'm using RH7.0 on 200MMX). Malmo Malmo If I only got 20$ for evryone who's too lazy to configure his own comp. Bill Gates "Why not?" - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: MYSQLGui
Peter Adamka writes: Maybe this question is out of topic, but I'm feeling really unhappy. I'm trying to compile MysqlGui, but at the end it always says, that there are no -lrc an -lrcl libraries. And that's the point. I have no idea, what libraries I should download (I'm using RH7.0 on 200MMX). Malmo Hi! What you are missing are fl_editor sources, for which there are links on mysqlgui page. But you would do much better if you would just download a static binary for Linux and save yourself lot's of trouble. And follow instructions found in README that comes with it. 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
GROUP BY behaviour.. help needed..
Hello, This is the following SQL statement used in a results page for a search: SELECT icaref, id, date, payee, descript, disb, payment, receipt-payment, receipt, SUM(disb), SUM(receipt-payment) FROM data WHERE receipt-payment 0 AND date BETWEEN 'varStart' AND 'varEnd' ORDER BY date GROUP BY disb, receipt-payment why does it not work? and can someone help me understand groups better ? Thanks, James Cox - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 not install on Solaris 2.6
I'm newbie when it comes to installing pkg's on Solairs.. I've dl'd the latest version of mysql from sourceforge (2.23.36-sun-solairs2.7-sparc.tar.gz). I can install the pkg ok but when I run mysql_install_db I get the following message.. ld.so.1: /bin/mysql: fatal: libcrypt_1.so.1: open failed: No such file or directory. How do I fix this.. V/R Greg Wejrowski (wedge) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 3.23 seems slower than 3.22
Hi, I hope that someone can help me on this matter. I have a C program which uses MySQL. This program does many many (100,000) SELECT, INSERT, UPDATE, DELETE on single HEAP tables. The machine I developed it on was a P3 800 256MB Linux machine running MySQL 3.22.32 (standard version of MySQL for Woody version of Debian I think). It happily ran my program in about 20 minutes. I then moved it over to the production machine which would be running it (P3 733 256MB RAM SCSI mirrored disks) which is running MySQL 3.23.35 and I found something very confusing. On this machine it takes about 3 hours to run. The binarys for my program are identical on both machines (tried using the same binary between both, and compiling on the host machine - no improvement). The only difference we can seem to trace it to is the MySQL server. Can anyone think of a reason why it would be running slower on 3.23 than 3.22? Most of my SELECTs are either using a WHERE primary_key or have no where at all (ie. selecting everything in the table - usually 2000 rows). We've even tried re-compiling MySQL with -O3 for gcc, but that made no difference. We're connecting via a local socket (not TCP/IP). All the variable sizes for MySQL seem to be the same between the two machines. Hope someone can help. Thanks David Hearn -- David Hearn Trainee Engineer, Unix Development XO Communications Desk: 0208 957 1054Mobile: 07974 423449 Fax:0208 213 1880Email: [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
[ANS] Can not install on Solaris 2.6
Greg, I checked on all my 2.6 systems and the library libcrypt_1.so.1 appears to be a Solaris 2.7 library only. I could not find a current version of mysql for Solaris 2.6. I'm in the process of compiling the latest version on my Solaris 2.6 machine. There is a version for 2.6 but it is listed as a 'Beta' version. We have tried it, but ran into problems with it, so I have to do it the hard way. Drop me a line later on today and I will let you know how things are going. Dave From [EMAIL PROTECTED] Wed Mar 28 08:33:36 2001 Received: from otto.nawcad.navy.mil (otto-internal.nawcad.navy.mil [192.58.199.212]) by tecnet1.jcte.jcs.mil (8.9.3/8.9.3) with ESMTP id IAA19509 for [EMAIL PROTECTED]; Wed, 28 Mar 2001 08:33:36 -0500 (EST) Received: by otto.nawcad.navy.mil; id IAA25322; Wed, 28 Mar 2001 08:33:35 -0500 (EST) Received: from unknown(192.58.197.162) by otto.nawcad.navy.mil via smap (V4.2) id xma025196; Wed, 28 Mar 01 08:33:32 -0500 Received: (qmail 29956 invoked by uid 7797); 28 Mar 2001 13:28:22 - Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm (http://www.ezmlm.org) List-ID: mysql.mysql.com Precedence: bulk List-Help: mailto:[EMAIL PROTECTED] List-Unsubscribe: mailto:[EMAIL PROTECTED] List-Post: mailto:[EMAIL PROTECTED] List-Subscribe: mailto:[EMAIL PROTECTED] Delivered-To: mailing list [EMAIL PROTECTED] Received: (qmail 29933 invoked from network); 28 Mar 2001 13:28:20 - Message-Id: [EMAIL PROTECTED] From: "Greg Wejrowski" [EMAIL PROTECTED] To: "[EMAIL PROTECTED]" [EMAIL PROTECTED] Date: Wed, 28 Mar 2001 08:30:14 -0500 Reply-To: "Greg Wejrowski" [EMAIL PROTECTED] Priority: Normal X-Mailer: PMMail 98 Professional (2.01.1600) For Windows NT (4.0.1381;5) MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Subject: Can not install on Solaris 2.6 I'm newbie when it comes to installing pkg's on Solairs.. I've dl'd the latest version of mysql from sourceforge (2.23.36-sun-solairs2.7-sparc.tar.gz). I can install the pkg ok but when I run mysql_install_db I get the following message.. ld.so.1: /bin/mysql: fatal: libcrypt_1.so.1: open failed: No such file or directory. How do I fix this.. V/R Greg Wejrowski (wedge) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
SELECT returning less fields than awaited.
The following peace of code returns sometimes a result with only 1 field, whereas i'm waiting for a result with 3 fields. How can such a SELECT return less than the field count required ? Here are the query, *result and mysql just after the mysql_fetch_row() Thanks if you can help me Christophe (gdb) x/3s buf 0xbfffabc8: "SELECT ag_id,call_ref,rfgi FROM voies_ag,voies WHERE dac_id=0 AND voies_ag.voie=voies.voie \t\t\t\tAND voies_ag.etat=1 AND DATE_ADD(voies_ag.date_etat,INTERVAL 40 SECOND)NOW() \t\t\t\tAND DATE_ADD(voies.date"... 0xbfffac90: ",INTERVAL 40 SECOND)NOW() \t\t\t\tAND voies.trafic='", '0' repeats 151 times... 0xbfffad58: '0' repeats 104 times, "' AND voies_ag.renvoi=0" (gdb) print *result $2 = {row_count = 1, field_count = 1, current_field = 0, fields = 0x80c0438, data = 0x80be490, data_cursor = 0x0, field_alloc = {free = 0x80c0428, used = 0x0, min_malloc = 16, block_size = 8164, error_handler = 0}, row = 0x0, current_row = 0x80c2428, lengths = 0x80be484, handle = 0x0, eof = 1 '\001'} (gdb) print mysql $3 = {net = {nettype = NET_TYPE_TCPIP, fd = 6, fcntl = 0, buff = 0x80bbf50 "", buff_end = 0x80bdf50 "", write_pos = 0x80bbf50 "", read_pos = 0x80bbf50 "", last_error = '\000' repeats 199 times, last_errno = 0, max_packet = 8192, timeout = 30, pkt_nr = 6, error = 0 '\000', return_errno = 0 '\000', compress = 0 '\000', remain_in_buf = 0, length = 0, buf_length = 0, where_b = 0, more = 0 '\000', save_char = 0 '\000'}, host = 0x80bbe48 "dcs1", user = 0x80bbe50 "root", passwd = 0x80bbe58 "", unix_socket = 0x0, server_version = 0x80bbe68 "3.22.32-log", host_info = 0x80bbe38 "dcs1 via TCP/IP", info = 0x0, db = 0x80bbe88 "acropol", port = 3306, client_flag = 0, server_capabilities = 12, protocol_version = 10, field_count = 1, thread_id = 5360, affected_rows = 1, insert_id = 0, extra_info = 0, packet_length = 1, status = MYSQL_STATUS_READY, fields = 0x0, field_alloc = { free = 0x80c0428, used = 0x0, min_malloc = 16, block_size = 8164, error_handler = 0}, free_me = 0 '\000', reconnect = 1 '\001', options = { connect_timeout = 0, client_flag = 0, compress = 0 '\000', named_pipe = 0 '\000', port = 0, host = 0x0, init_command = 0x0, user = 0x0, password = 0x0, unix_socket = 0x0, db = 0x0, my_cnf_file = 0x0, my_cnf_group = 0x0}} char buf[1024]; MYSQL_RES *result; MYSQL_ROW row; char zero[256]; memset(zero,'0',255); zero[255]=0; snprintf(buf,sizeof(buf),"SELECT ag_id,call_ref,rfgi FROM voies_ag,voies WHERE dac_id=%d AND voies_ag.voie=voies.voie \ AND voies_ag.etat=%d AND DATE_ADD(voies_ag.date_etat,INTERVAL %d SECOND)NOW() \ AND DATE_ADD(voies.date,INTERVAL %d SECOND)NOW() \ AND voies.trafic='%s' AND voies_ag.renvoi=0", dac.id,ETAT_AG_CONF,INACTIF_TIMEOUT*2,INACTIF_TIMEOUT*2,zero); if (mysql_query(mysql,buf)) MYSQLABORT("mysql_query"); if (!(result = mysql_store_result(mysql))) MYSQLABORT("mysql_store_result"); while ((row=mysql_fetch_row(result))) { maj_etat(atoi(row[2]),ETAT_AG_FIN_CONF); dcs_default_call_withdrawal(dac.sk,atoi(row[0]),atoi(row[1])); } mysql_free_result(result); - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 and LDAP
Hello, I am looking for a difinitive answer as to whether data from LDAP and MySQL may be synchronized. What I want to know is if there's any way to automagically synchronize MySQL and LDAP? ie take selected fields from MySQL and have it update an LDAP authentication database. LDAP as a front end and MySQL as a back end database. If there is a way, and it requires the purchase of a support contract, please let me know the details on how to proceed. Adonis Andrews NTS Travel Response - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: perl API
LIBASOV IOANNIS wrote: I'm not quite sure if this question is appropriate for this mail list, so may be somebody can tell me whom to ask better. I was going to run the following code: .. if (system("mysql -u username -ppassword -h hostname -P 3606 path/to/filename 2errlog")) { return ("Something wrong - $? "); } return undef; ... It does not works under LINUX and Windows95 (it works fine under Windows NT. The command works also in command line). The code is not being executed, and it does not return any error code ($?). Please help Thanks! Yannis Livassov, [EMAIL PROTECTED] Try giving the full path to 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
Re: MySQL 3.23 seems slower than 3.22
Just thought I would explain my stupidity! One of my tables which I'd forgotten about was 100k entries but I'd dropped the primary key off earlier. Adding the primary key back again made the two machines the same speed immediately. Its amazing what indexes can do! David Hi, I hope that someone can help me on this matter. I have a C program which uses MySQL. This program does many many (100,0= 00) = SELECT, INSERT, UPDATE, DELETE on single HEAP tables. The machine I deve= loped = it on was a P3 800 256MB Linux machine running MySQL 3.22.32 (standard ve= rsion = of MySQL for Woody version of Debian I think). It happily ran my program= in = about 20 minutes. I then moved it over to the production machine which would be running it = (P3 = 733 256MB RAM SCSI mirrored disks) which is running MySQL 3.23.35 and I f= ound = something very confusing. On this machine it takes about 3 hours to run.= The binarys for my program are identical on both machines (tried using th= e = same binary between both, and compiling on the host machine - no improvem= ent). = The only difference we can seem to trace it to is the MySQL server. Can anyone think of a reason why it would be running slower on 3.23 than = 3.22? = Most of my SELECTs are either using a WHERE primary_key or have no whe= re at = all (ie. selecting everything in the table - usually 2000 rows). We've even tried re-compiling MySQL with -O3 for gcc, but that made no = difference. We're connecting via a local socket (not TCP/IP). All the = variable sizes for MySQL seem to be the same between the two machines. Hope someone can help. Thanks David Hearn -- = David Hearn Trainee Engineer, Unix Development XO Communications Desk: 0208 957 1054Mobile: 07974 423449 Fax:0208 213 1880Email: [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 -- David Hearn Trainee Engineer, Unix Development XO Communications Desk: 0208 957 1054Mobile: 07974 423449 Fax:0208 213 1880Email: [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: table output display
Bordeaux Stan wrote: Hi guru type folks, My system crashed over the weekend and I had to reinstall linux. I'm currently running Mandrake 7.2. Now that I'm up and running again I find that the output from a mysql query is not formatted properly. The tables look as though they are wrapping round so that data does not sit under column headers and that the lines are all over the place. I even installed the latest mysql stable version last night, but still have this strange looking output on screen. This happens even when there are only two columns on the select command. Is there some way to fix this problem? Any help greatly appreciated as I can't make sense of the on-screen display. Cheers Stan Bordeaux Stan Bordeaux Injury Prevention Policy Officer Public Environmental Health Service 1/34 Davey St Hobart 7000 ph: (03)6233 3774 fax: (03)6223 1163 email: [EMAIL PROTECTED] - Sounds like an stty problem. Try stty onlcr Maybe you loaded the wrong curses library. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL 3.23.36 is relased
"MW" == Michael Widenius [EMAIL PROTECTED] writes: MW* Added `SET TRANSACTION ISOLATION LEVEL ...' How about documenting this? http://www.mysql.com/doc/S/E/SET_TRANSACTION.html is quite uninformative as to what the different levels mean. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
stability documentation up to date?
Is the http://www.mysql.com/doc/S/t/Stability.html document up to date? In particular, I'm interested in the current stability level of BDB tables, since I'm in need of transactions for a particular project. Also, the MyISAM handler is still listed as gamma, not stable. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= 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/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
problem with the mysql startup
Hello, iam new to mysql and have nothing much to do with mysql itself, but i seem to have the following message whenever i start mysql it gives me the following message Starting service MySQLStarting mysqld daemon with databases from /var/lib/mysql failed. well , i checked up the mysql status and itsays it is OK, i dont seem to understand what to do for that , would be nice if somebody out ther could help me iam using mysql version 3.23.30. thanx in advance regards imdad _ 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: Unknown Database, Error 1049 problems...
Jason Guritz wrote: mysql show databases; +---+ | Database | +---+ | directory | | mysql | | phpBB | | testdb | | trial | +---+ 5 rows in set (0.00 sec) mysql use testdb; ERROR 1049: Unknown database 'testdb' Keeps happening to me too. It was working the day before :( Jason Were you moving directories around? Looks like testdb has some spaces or other unprintable characters in its directory name. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Unknown Database, Error 1049 problems...
I know you people are busy but I have seen this question a few times on the lists to no avail. *see below* It has been figured out by my admin. It appears that one or more entries in the ACL tables is corrupt, when this happens so its preventing logins. So you have to replace the ACL with a fresh copy and then replace all the domain and passwords. I am not pretending in any way to know what I am talking about compared to anyone else. You are the experts but I thought you might want to know for the future. When the exact problem pops up again. Kindest regards, Jason mysql show databases; +---+ | Database | +---+ | directory | | mysql | | phpBB | | testdb| | testdb2 | +---+ 5 rows in set (0.00 sec) mysql use testdb2; ERROR 1049: Unknown database 'testdb2' Thats the error message that can be fixed by replacing the ACL. This is of course when there is no trailing white space or anything else wrong. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Compiling
And no mention of the machine, the operating system version, the mysqlsource file downloaded, the compiler used, which version of make, or even the comand entered. gawie wrote: Hi...please help Cannot get the version of MySQL compiled..When running a configure it stops at : 'checking return type of sprintf... configure: error: cannot run test program while cross compiling checking whether gcc accepts -g... (cached) yes checking for c++... (cached) c++ checking whether the C++ compiler (c++ ) works... yes checking whether the C++ compiler (c++ ) is a cross-compiler... yes checking whether we are using GNU C++... (cached) yes checking whether c++ accepts -g... (cached) yes checking how to run the C preprocessor... (cached) gcc -E checking for ranlib... (cached) ranlib checking for ld used by GCC... (cached) /usr/ccs/bin/ld checking if the linker (/usr/ccs/bin/ld) is GNU ld... (cached) no checking for BSD-compatible nm... (cached) /usr/ccs/bin/nm -p checking whether ln -s works... (cached) yes checking for object suffix... o checking for executable suffix... no checking for gcc option to produce PIC... -fPIC checking if gcc PIC flag -fPIC works... yes checking if gcc supports -c -o file.o... yes checking if gcc supports -c -o file.lo... yes checking if gcc supports -fno-rtti -fno-exceptions ... yes checking if gcc static flag -static works... -static checking if the linker (/usr/ccs/bin/ld) is GNU ld... no checking whether the linker (/usr/ccs/bin/ld) supports shared libraries... yes checking command to parse /usr/ccs/bin/nm -p output... ok checking how to hardcode library paths into programs... immediate checking for /usr/ccs/bin/ld option to reload object files... -r checking dynamic linker characteristics... solaris2.7 ld.so checking if libtool supports shared libraries... yes checking whether to build shared libraries... no checking whether to build static libraries... yes checking for objdir... .libs creating libtool loading cache ./config.cache checking for a BSD compatible install... ./install-sh -c checking for bison... bison -y checking for pdftex... no checking return type of sprintf... configure: error: can not run test program while cross compiling And here it stops.I have downloaded the version for Solaris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 error 2002e
Forget it. That compiler is broken. Use GCC-2.95.2 root wrote: hi there o wise ones i know i should RTFM, but i am, its right here infront of me. maybe its cause i cant start working with sql till i get home from slavin for the man or whatever, but id really like to get it operational. if its possible to get some help id really appreciate it. thanks quigley SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `' and `'). SEND-PR: From: root To: [EMAIL PROTECTED] Subject: [mysql error 2002e)] Description: cannot connect to mysql server, /tmp/mysql.sock is just a blank page. How-To-Repeat: mysqltest reports all 117 tests successful, however, the server will not start) Fix: how to correct or work around the problem, if known (multiple lines) Submitter-Id: sauromanD Originator:root Organization: organization of PR author (multiple lines) MySQL support: [none | licence | email support | extended email support ] Synopsis: synopsis of the problem (one line) Severity: [ non-critical | serious | critical ] (one line) Priority: [ low | medium | high ] (one line) Category: mysql Class: [ sw-bug | doc-bug | change-request | support ] (one line) Release: mysql-3.23.35 (Source distribution) Environment: machine, os, target, libraries (multiple lines) System: Linux localhost.localdomain 2.2.16-22smp #1 SMP Tue Aug 22 16:39:21 EDT 2000 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.0) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 14 Feb 15 14:04 /lib/libc.so.6 - libc-2.1.92.so -rwxr-xr-x1 root root 4776568 Aug 30 2000 /lib/libc-2.1.92.so -rw-r--r--1 root root 22607104 Aug 30 2000 /usr/lib/libc.a -rw-r--r--1 root root 178 Aug 30 2000 /usr/lib/libc.so Configure command: ./configure SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `' and `'). SEND-PR: From: root To: [EMAIL PROTECTED] Subject: [50 character or so descriptive subject here (for reference)] Description: precise description of the problem (multiple lines) How-To-Repeat: code/input/activities to reproduce the problem (multiple lines) Fix: how to correct or work around the problem, if known (multiple lines) Submitter-Id: submitter ID Originator:root Organization: organization of PR author (multiple lines) MySQL support: [none | licence | email support | extended email support ] Synopsis: synopsis of the problem (one line) Severity: [ non-critical | serious | critical ] (one line) Priority: [ low | medium | high ] (one line) Category: mysql Class: [ sw-bug | doc-bug | change-request | support ] (one line) Release: mysql-3.23.35 (Source distribution) Environment: machine, os, target, libraries (multiple lines) System: Linux localhost.localdomain 2.2.16-22smp #1 SMP Tue Aug 22 16:39:21 EDT 2000 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.0) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 14 Feb 15 14:04 /lib/libc.so.6 - libc-2.1.92.so -rwxr-xr-x1 root root 4776568 Aug 30 2000 /lib/libc-2.1.92.so -rw-r--r--1 root root 22607104 Aug 30 2000 /usr/lib/libc.a -rw-r--r--1 root root 178 Aug 30 2000 /usr/lib/libc.so Configure command: ./configure - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
MySQLGUI 1.7.4 problems.
I can't seem to get this version of MySQLGUI 1.7.4-2 to connect to the mysql server I'm running on the computer. I get the following denial of access everytime I try to connect: Access denied for user: ' mailto:'root@localhost' root@localhost mailto:'root@localhost ' (Using password: Yes) Can you tell me what I'm doing wrong? I'm running this on a Dell 933Mhz PC with Windows 2000 as the OS. Thanks, Sean Armstrong GMP Chemist Shearwater Corporation 1112 Church St. Huntsville, AL 35801 (256)533-4201 ext.274 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
Re: myisamchk problems
Daniel Adams wrote: This is probably a really stupid error, but I'm unable to run myisamchk: [root@cssrvr1 mail2db.bad]# ls category.MYD groupcounter.MYD list.MYD message.MYD threadrequest.MYD category.MYI groupcounter.MYI list.MYI message.MYI threadrequest.MYI category.frm groupcounter.frm list.frm message.frm threadrequest.frm [root@cssrvr1 mail2db.bad]# myisamchk -c list myisamchk -c list.MYI myisamchk: error: 22 when opening MyISAM-table 'list' i am root so it can't be permissions. Can someone please help me with this? - Dan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
access denied for deleting database
Hello, iam trying to delete tables from a database, the mysql asks for the root user password which i give but it seems to be not accepting it , i have included the sequence below Erasing database tables (you will need to enter the database root password) Path of mysql tool (the default is fine if it's in your standard shell path) [mysql]: eprints You will need to enter the MySQL root user password. sh: eprints: command not found Error removing database tables; aborting thanx in advance for the help regards imdad _ 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: Converting Decimal value to Binary
BIN(intag 255) Filip Sergeys wrote: Hi, WHAT DO I WANT TO DO: I want to have the binary value of a part of a decimal value. 1)I have a decimal value in column called intag : 262204 2)From this value I'am only interested in the last two bits of the HEX value of this decimal HEX value = 4003C My interest 3C part of used SQL query: substring(HEX(intag), (length(HEX(intag))-1), 2) 3)For the last two bits(3C) I like to have the binary value HEX value = 3C Binary = 00 Final SQL query: BIN(substring(HEX(intag), (length(HEX(intag))-1), 2)) PROBLEM When running the last query, the returned value is 11 instead of 00. Probably it has something to do with the fact that I requested a substring of length 2. What do I need to do to get the complete binary value? If one you SQL geniuses knows this, please let me know. Thanks in advance FS - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [NEWBIE] safe_mysqld
The RPMs on RH CD have problems. Check teh archives for instructions on getting it working, or get new RPMs. Stephane Pinel wrote: When I attempt to launch mysql server with command safe_mysqld, the console return this: "starting mysqld daemon with databases from /var/lib/mysql" "010327 19:33:37 mysqld ended" I use RedHat 7.0 Linux on Intel -- Stphane Pinel 39, Rue du Docteur Heulin 75017 Paris (FRANCE) 33 1 53 11 05 77 33 6 08 94 63 16 [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: Perl - DBD:DBI Errors
You don't have zlib on your machine. Check your 6.2 CD. Chris Becker wrote: I'm having trouble installing the perl module DBD specifically. I found on my CPAN cd the DBD module Msql-Mysql-modules-1.2208, tried to install it and got errors, I discovered I needed DBI installed first. So I found DBI-1.13 and did the following: perl Makefile.PL make make test Made 100 connections in 0 wallclock secs... test.pl done DBI seemed to install ok. Then I found DBD Msql-Mysql-modules-1.2210 and did the following: perl Makefile.PL select 1) MySQL only n - for install perl emulation then make make test then get output from make test: ...install_driver(mysql) failed: Can't load '../blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: ../blib/arch/auto/DBD/mysql/mysql.so: undefined symbol: uncompress at /usr/lib/perl5/5.00503/i386-linux/DynaLoader.pm line 169. at (eval 1) line 3 at t/00base.t line 38 dubious Test returned status 255 (wstat 65280, 0xff00) Undefined subroutine Test::Harness::WCOREDUMP called at /usr/lib/perl5/5.00503/ Test/Harness.pm line 288. make[1]: *** [test_dynamic] Error 255 make[1]: Leaving directory '/perlmods/Msql-Mysql-modules-1.2210/mysql' make: *** [test] Error\ 2 after the above errors even i tried executing the 'make install'. Then I tried a sample perl file using the 'use DBI' function to test the perl module install w/ MySQL, and when I execute I get the same error: undefined symbol: uncompress at blah blah blah... Please Help. What am I doing wrong? Do I need to do an un-install before trying to re-install DBD? Should I blow out Perl altogether and reinstall? Has anyone seen this before? Thanks in advance, Chris Becker - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Complex mysql query
Thanks for the answer but it is a bit more complexe, i actually creates these sample table for the example. Here is an attachement of the structure dump. Hummm you got me to think more about my database structure withc is really good. The idea you bourght up seems really good. I am a junior developper, actually only been 2 month i really program soi now have more experience then i used to have spacially when people like yuo give me tricks , this really helps me out :-) CREATE TABLE produits ( My product table PID varchar(5) NOT NULL, Product ID titre tinytext NOT NULL, Title description text, product descrition artiste tinyint(3) NOT NULL, Artiste reference number see the artiste table image varchar(5) NOT NULL,Image name num_page smallint(5), Number of page if a book duree smallint(4), Lengthif video or cd, tape ... format tinyint(3) NOT NULL, Format of the product hardcover softcover, tape , cd, dvd ISBN smallint(10), ISBN number or serial number quantite tinyint(3) NOT NULL, Stock quantity fournisseur tinyint(4) NOT NULL, Provider ID number prix float NOT NULL, Our sales prices retail float NOT NULL, Retail Price UNIQUE PID (PID) UNIQUE PID (PID)); CREATE TABLE artiste ( ID smallint(5) unsigned NOT NULL auto_increment, artiste ID number nom varchar(15) NOT NULL,artiste name UNIQUE ID (ID)); CREATE TABLE fournisseurs ( My provider table ID tinyint(5) unsigned NOT NULL auto_increment,Provider ID Nom varchar(20) NOT NULL, Provider Name adresse1 varchar(50) NOT NULL, addresse1 adresse2 varchar(50), address2 ville varchar(20) NOT NULL, city province varchar(20) NOT NULL, state/province pays varchar(30) NOT NULL, country telephone varchar(20) NOT NULL,phone number fax varchar(20), fax email varchar(25), site_web varchar(30), website pers_ressources varchar(40), person to contact num_compte varchar(20) NOT NULL,account number code_postal varchar(7) NOT NULL, Postal code UNIQUE ID (ID)); I got more tables but the others are not interesting in the specific query i want to make. What do you think about this structure. If you want teh files are also attatched in txt format so you can take a look at it in TextPad. :-) Thanks for your comments i really appreciate :-) Yann - Original Message - From: "Bob Hall" [EMAIL PROTECTED] To: "Yann Larrivée" [EMAIL PROTECTED] Sent: Wednesday, March 28, 2001 6:14 AM Subject: Re: Complex mysql query Sorry i think this is my mistake the format that i gave did not get reoected by the mailing liste so my structure is provider books music video provider_id title title title provider_name provider_id provider_id provider_id I am making a smal search engine for the site. people can look up all the books, cd, video from a specific provider. So i need to out put all the title that correspond to the "keyword they entered" witch would be the providers name right ... and the providers name Yann - Original Message - From: "Bob Hall" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, March 27, 2001 8:26 AM Subject: Re: Complex mysql query Hi everybody. I got a complexe question well according to me. I am working with PHP and i am making some queries to some database. here is a description of the tables. provider book video music provider_id title title titlename provider_id provider_id provider_id I need to select all the title from book, video, music that matches a provider name and not a provider id. I know i can make 2 queries to do it but i am shure i can do a complexe join somewhere that would allow me only to connect once. I want to do it this one because to connect twince to a db could slow down the performance. This problem goes beyound my knowledge of MySQL a bit of help would be appreciated :-) Thanks Yann Larrivée www.ProtonicDesign.Com Sir, I doubt that you have a table with three columns with the same name. If I am wrong, then your copy is MySQL is broken. If your table structure is what I think it is (It's impossible to be sure from your description), it's going to cause you a lot of problems. Get a book on relational database design and learn to normalize tables. In the interim, if you post a description of what you are trying to do, there are a number of active contributors here who can make suggestions for a schema. Sir, I apologize for mis-reading your schema. The textbook way of describing a table structure is table_name(column1_name, column2_name, ...) A more common representation on the list is table_name column1_name, column2_name, ... or to give the CREATE TABLE statement. I tend to
Contracting opportunities?
Hello All, I'm recently back in the job market, and looking for PHP/MySQL contracting opportunities. Can some helpful people out there please email with good job sites and/or real headhunters that specialize in this type of work? I've already exhausted dice.com, guru.com, monster.com, headhunter.net, and a few other smaller ones. The headhunters I've dealt with seem to be pretty void on demand for these skills. I'm not asking the list for any opportunities themselves, hence I'm not posting my credentials, but I'd rather get pointers in the right direction. Thanks in advance, -Hank ([EMAIL PROTECTED]) __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/?.refer=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
MYSQL problems
I am having problems with a MySQL query. I user the following query: SELECT search_users.ID FROM search_users,users WHERE search_users.Step=4 AND users.ID=search_users.ID AND search_users.Login'' AND search_users.LookForSex="M" AND search_users.Sex="F" AND search_users.Country="US" AND search_users.State="CA" AND ( search_users.Age=30 AND search_users.Age=40 ) ORDER BY search_users.Age and I get 36 rows returned for an age range of =30 and =40 but if I use this query: SELECT search_users.ID FROM search_users,users WHERE search_users.Step=4 AND users.ID=search_users.ID AND search_users.Login'' AND search_users.LookForSex="M" AND search_users.Sex="F" AND search_users.Country="US" AND search_users.State="CA" AND ( search_users.Age=35 AND search_users.Age=35 ) ORDER BY search_users.Age and I get 45 rows returned for an age range of =35 and =35 ! The queries are exactly the same except for the age ranges!!! But it is giving me inaccurate results. Any light that you can shine on this matter will be helpful, Thanks, Jonathan Almarez [EMAIL PROTECTED]
Re: myisam upgrade problem
error 28 is "No space left on device". Hang wrote: Greetings, I am upgrading my mysql from 3.22.23b to 3.23.35 on RedHat with kernel 2.4.0. I followed the instructions on the manual for the upgrade. Every goes fine except I can't convert one table from ISAM to MYISAM. I got quite a lot of tables and all can be converted successfully but not this table. It contains 3,000,000 rows, 80MB data file and 250MB index file. I got following error message when I am converting the table format: mysql alter table mytable type=MYISAM; ERROR 3: Error writing file '/tmp/ST4kylYE' (Errcode: 28) I also found following line by running "ls -al /proc/12121/fd" (12121 is the pid of the mysqld): lrwx--1 root root 64 Mar 28 12:25 17 - /tmp/ST4kylYE (deleted) I had run isamcheck before the conversion and my /tmp got 400MB disk space. Any one have idea what's going wrong? Besides, I also have tables on other Linux machines with about 200MB data and 2.0GB index file. Will there be any problem? Pls Help. Thanks. -- CH Tsang - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Reserved word/ Ambiguous Column title 'Key'
Somebody will correct me if I am wrong, but I think cannot have a column in a table that has the same name as a MySQL reserved word. You are going to have to change it. 'Key' is simply NOT going to work for your column name. On the reasonable chance that I am wrong, the documentation that I am looking at for ALTER TABLE xxx CHANGE ... Looks like this: ALTER TABLE table CHANGE [column] new_column_name create_clause So, in your query, try ALTER TABLE tblSuppliers MODIFY Key CHAR(6) NOT NULL; Because if the syntax error is because it is trying to create a new column that shares an existing column name (even if temporarily) this could fix that. On 3/28/01 1:19 AM, "Richard Harris" [EMAIL PROTECTED] wrote: Hi, I am importing an Access 97 Database into MySQL. One of tables tblSuppliers holds all the critical supplier information and has a 4 character Primary key called 'Key' This is heavily used throughout a lot of VB code in the Access GUI and can't really be changed easily. When I import the Access tables into MYSQL, they lose their indexes and primary keys. Try as I might, I can't change the properties of the Key column using Alter Table, it keeps coming back with syntax errors. I'm currently stuck on the following, ALTER TABLE tblSuppliers CHANGE Key Key CHAR(6) NOT NULL What am I doing wrong/ is there a work round? Thanks in advance for you help. Richard Harris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Binary distribution with BDB and InnoBase?
Sorry to keep harping on this, but back when 3.23.34 was released, there was a line in the release notes that claimed that binary distributions with BDB and InnoBase would be tackled "next week". Has there been any progress on this front? I'm most interested in the Win32 binary distribution, since that seems to be built in a non-standard way (i.e. instead of using configure, etc., it uses Visual C++ project files, etc.) -- Shankar Unni[EMAIL PROTECTED] (408) 434-8311
Re: Can not install on Solaris 2.6
Greg Wejrowski wrote: I'm newbie when it comes to installing pkg's on Solairs.. I've dl'd the latest version of mysql from sourceforge (2.23.36-sun-solairs2.7-sparc.tar.gz). I can install the pkg ok but when I run mysql_install_db I get the following message.. ld.so.1: /bin/mysql: fatal: libcrypt_1.so.1: open failed: No such file or directory. How do I fix this.. V/R Greg Wejrowski (wedge) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php You are not running 2.7, so why should it work? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
PROBLEM!!
Hi! First: To this mailing list we only accept full repeatable bug reports as defined in the MySQL manual. "Ionut" == Ionut Petre [EMAIL PROTECTED] writes: Ionut HI! Ionut I have a problem, and I don't know how to resolve it: Ionut I want to migrate a database from an SQL Server 7.0 into an MySQL server Ionut under Linux RH. Ionut Does have anybody an idea how to make this?? I want to move all the database Ionut with all contents!! Ionut Thanks, Ionut Ionut Can you with SQL server produce the CREATE statements for each table and a tab-separated text file for the data. If this is the case then you can easily read in the data with 'mysqlimport'. If not (and you can a bit Perl), you can try to install Activestatperl with DBD modules for ODBC and then use the following script as a base to copy the data: Regards, Monty - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
test
just checking if im on the list still - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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-based accounting system
Hi there, I am looking for a web-based accouting system written in Mysql/Perl/Apache/Linux. I am willing to pay for the system, and it could be a simple accounting system or a complex one. Could be also just a module, for example payroll, inventory, sales. I hope someone could tell me where to find one. Thanks, Joe EchavarrĂa. http://www.webdinamico.com _ 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
Synchronization
I have two mySQL servers, one is in office, and other at home. I need to synchronize then via DialUp TCP/IP connection (not Internet DialUp). Can somebody help me ? -- Martin Jeremic - JSoft http://jsoft.webjump.com/ 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: Synchronization
On Wed, Mar 28, 2001 at 05:22:56PM +0200, Martin Jeremic wrote: I have two mySQL servers, one is in office, and other at home. I need to synchronize then via DialUp TCP/IP connection (not Internet DialUp). Can somebody help me ? Does MySQL replication suit your needs? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Deadlock found with MERGE tables
Description: Deadlock possible when LOCKing underlying tables in a MERGE table definition How-To-Repeat: mysql CREATE TABLE lock_test1 ( test CHAR(5) DEFAULT '' NOT NULL PRIMARY KEY ); mysql CREATE TABLE lock_test2 ( test CHAR(5) DEFAULT '' NOT NULL PRIMARY KEY ); mysql CREATE TABLE lock_test (test CHAR(5) DEFAULT '' NOT NULL, KEY(test)) TYPE=MERGE UNION=(lock_test1,lock_test2); mysql LOCK TABLES lock_test1 WRITE; mysql DROP TABLE lock_test; client hangs here From a different client: mysql SHOW PROCESSLIST; +---+--+---+---++--+---+-+ | Id| User | Host | db| Command| Time | State | Info| +---+--+---+---++--+---+-+ | 13154 | root | localhost | books | Query | 100 | Waiting on cond | DROP TABLE lock_test| | 13155 | root | localhost | books | Query | 108 | Locked| SELECT * FROM lock_test | | 13157 | root | localhost | books | Field List | 68 | Waiting for table | | | 13158 | root | localhost | NULL | Query | 0| NULL | SHOW PROCESSLIST| +---+--+---+---++--+---+-+ 4 rows in set (0.00 sec) Fix: Unknown Submitter-Id: submitter ID Originator:root Organization: NetCentral, Inc. MySQL support: extended email support Synopsis: Deadlock possible when working with MERGE tables Severity: serious Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.33 (Source distribution) Server: /usr/local/bin/mysqladmin Ver 8.15 Distrib 3.23.33, for pc-linux-gnu on i586 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.29a-gamma Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 75 days 6 hours 8 min 22 sec Threads: 1 Questions: 2464115 Slow queries: 4 Opens: 38 Flush tables: 1 Open tables: 7 Queries per second avg: 0.379 Environment: System: Linux neuter 2.2.14-15mdk #1 Tue Jan 4 22:24:20 CET 2000 i586 unknown Architecture: i586 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i586-mandrake-linux/2.95.2/specs gcc version 2.95.2 19991024 (release) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 13 Dec 24 1999 /lib/libc.so.6 - libc-2.1.2.so -rwxr-xr-x 1 root root 5195054 Dec 15 1999 /lib/libc-2.1.2.so -rw-r--r-- 1 root root 20508346 Dec 15 1999 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Dec 15 1999 /usr/lib/libc.so Configure command: ./configure Perl: This is perl, version 5.005_03 built for i386-linux - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
wierd problem with left joins and count
Hi! I have query from several tables - from news table, picture table and comments table. It diplays headline, news from news table, number of comments for news from comments table and picture alignment (on the web) from pictures table. As it could be many comments and also many pictures for one news (also none), I use left join. Here is my query: SELECT news.NewsID, news.headline, news.story, news.stmp, count(comment.NewsID) AS nrcomments, pics.align FROM uudised left JOIN comment ON comment.newsid=news.newsid left join picsdb.pics on news.stmp=pics.stmp GROUP BY news.newsid ORDER BY news.date DESC, news.newsid desc limit 10; So far so good. Nothing wierd happens with nrcomments as long there is one picture for news. But if I have more than one picture for news, and some comments too, nrcomments gets multipied with number of pictures. So if I have 3 pisc and 5 comments, it shows me 15 comments, 2 pics and 4 comments, and 8 shows up in nrcomments. What is wrong? Please reply to my email, I'm not currently subscribed. 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
(sin asunto)
try INSERT INTO tblDomains (field1, field2) VALUES (1, 'trlinux.com.'); ChrisB MCSE MCDBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Cesar Martinez Sent: Wednesday, March 28, 2001 12:40 PM To: [EMAIL PROTECTED] Subject: (sin asunto) that such!! an excuseme for my english,I am installing postaci 1.1.3 with mysql 3.23., and when inserting the domain in the tblDomains , accorfing to this syntax: INSERT INTO tblDomains VALUES (1,'trlinux.com.'); it marks me the following error syntax error near unexpected token '(1' could somebody help? thank 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Complex SQL Query
I have been trying for the last while to come up with a query that will do the following: Say I have table with these records: StartDate StopDate --- 2001-01-23 23:43:12 2001-01-24 04:29:12 2001-01-24 15:24:00 2001-01-26 01:15:02 2001-01-24 23:10:16 2001-01-24 23:15:59 2001-01-25 09:36:44 2001-01-27 12:11:41 The query to get the sum of all the seconds between the "StopDate" and "StartDate" is easy. What I need to do is break that down into how many seconds of that total were spent between midnight and 6am (and, conversely, how many seconds of that total were spent between 6am and midnight). I know the answer is probably very simple, but I have yet to figure it out. Aaron Clausen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Betr.: Hello
Speaking of books on MySQL are there more than one to choose from? If so is MySQL written by Paul DuBois the best one? John Jackson Direct Access Recruiters [EMAIL PROTECTED] -Original Message- From: B. van Ouwerkerk [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 5:03 AM To: [EMAIL PROTECTED] Subject: Re: Betr.: Hello ...And.. a book called MySQL written by Paul DuBois. It's a great book and will help you to get things up and running within a very short time.. It will cost you another 2-3 days (based on 8 hours per day) to work your way through the book and all the examples.. but you will know most of the basics.. 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: GROUP BY behaviour.. help needed..
What response/results are you getting? Tt would help us to determine the problem -Original Message- From: James Cox [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 7:13 AM To: [EMAIL PROTECTED] Subject: GROUP BY behaviour.. help needed.. Hello, This is the following SQL statement used in a results page for a search: SELECT icaref, id, date, payee, descript, disb, payment, receipt-payment, receipt, SUM(disb), SUM(receipt-payment) FROM data WHERE receipt-payment 0 AND date BETWEEN 'varStart' AND 'varEnd' ORDER BY date GROUP BY disb, receipt-payment why does it not work? and can someone help me understand groups better ? Thanks, James Cox - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: running Mysql client
Was a password defined when you granted permissions to the user? -Original Message- From: Hammad Nasim [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 2:43 PM To: [EMAIL PROTECTED] Subject: running Mysql client Hi I am having some problems running mysql client. I can connect mysql server from client machine by skipping password. But if I try to connect with password, message is displayed Error 1045: Access denied for user using password. Kindly help me out here. Hammad - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: web-based accounting system
I hope someone could tell me where to find one. Off-topic, take a look at www.php.net for php scripts. Otherwise checkout www.cgi-resources.com 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: GROUP BY behaviour.. help needed..
Hi Rick, I actually fixed that problem - it was due to the fact that the GROUP BY and ORDER By statement were mixed up :( still don't understand groups well, though :( Thanks, James Cox - Original Message - From: "Rick Emery" [EMAIL PROTECTED] To: "'James Cox'" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, March 28, 2001 10:33 PM Subject: RE: GROUP BY behaviour.. help needed.. What response/results are you getting? Tt would help us to determine the problem -Original Message- From: James Cox [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 7:13 AM To: [EMAIL PROTECTED] Subject: GROUP BY behaviour.. help needed.. Hello, This is the following SQL statement used in a results page for a search: SELECT icaref, id, date, payee, descript, disb, payment, receipt-payment, receipt, SUM(disb), SUM(receipt-payment) FROM data WHERE receipt-payment 0 AND date BETWEEN 'varStart' AND 'varEnd' ORDER BY date GROUP BY disb, receipt-payment why does it not work? and can someone help me understand groups better ? Thanks, James Cox - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Reg. Synchronization between MySQL DBs
Hi, The short version: Does anyone know an automated way of keeping two MySQL db's (located on different machines) in sync? A small window of non-sync could be acceptable. The long version: I'm working on a project which basically is about capturing a lot of data from different places and storing them in a central database. Once there we make a lot of interpreting of the data etc. So far we've used a proprietery distributed database/information forwarding solution. Some of the data inquires are suited to be stated in SQL. For that purpose we regularilly export subsets of the data to a MySQL db and from there extract the compiled data. The export routines take a lot of time, hence we would like to do the export routines work parallel with the rest of operations. This isn't a problem initself. While our project grows we get more and more demands on how the thing should work. One thing is redundancy. To cope with that in this specific instance we would like to have an auto-magical way of synchronizing two different db's (located on different machines). Does anyone know a way to do this? One, obvious, way would be to have a gathering point previous to the MySQL db. From there we could make sure all data is inserted in both db's. Since we have our own solution of how to get the data that far this isn't a problem initself. The problem is that so far we've managed to let different applications change things in the db directly. Those changes would have to be auto-magically reflected to the other db's as well. This part is what we like to auto-magically automate. (It wouldn't be acceptable to require all 'analyzing' apps to update all db's by themselves.) One way would of course be to build a through'n'through multi-tier solution where the db is simply the local db for each 'node'. This has two down-sides. One is the development cost of such a system (_big_). The other is performance. The extra (real-time) abstraction layer would most propably have a performance hit on the system. And we're really short on resources (the data amount in from time to time enormous). So once again, has anyone done something like this? Any experiences to share? Any pointers to where to start and look? Should I forward this message to somewhere else? -- Aigars Grins - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Locks !!! Help !!!
Hello All !!! I've 2 tables in a Shopping Cart Servlet TransactionTable is having a one to many relation with OrderTable create table TransactionTable ( TransId Integer Not Null Auto_Increment Primary Key, OrderDate TimeStamp, Not Null , GrandTotal Double Not Null , FullName VarChar(40) Not Null , Address VarChar(100) Not Null , Pincode VarChar(10) Not Null , Phone VarChar(20) Not Null , Email VarChar(40) Not Null , city VarChar(20) Not Null , State VarChar(20) Not Null , Country VarChar(25) Not Null , Comments VarChar(240) ) ; create table OrderTable ( OrderId Integer Not Null Auto_Increment Primary Key, TransId Integer Not Null, TotalPrice Double Not Null , Code VarChar(20) Not Null , Quantity Integer Not Null ) ; My problem is how to enforce integrity between the updates ? That is there will be 1 or more enteries in the "OrderTable" againest every update in the "TransactionTable " table. The transId in Ordertable will be the same as the TransactionTable. So i'll have to read the transID by the function " Last_Insert_ID () "; But in the Event the database gets reset/ etc... etc... just after the Insert in the Transaction table it will leave the corresponding enteries orphaned in the OrdeTable . In that case what precautions should i take to avoid such scenarios? How should i impose a lock on the tables ?? THe manual says To avoid using ROLLBACK, you can use the following strategy: 1.. Use LOCK TABLES ... to lock all the tables you want to access. 2.. Test conditions. 3.. Update if everything is okay. 4.. Use UNLOCK TABLES to release your locks. I didn't quite understasnd the meaning of Test Conditions Any help will be deeply appreciated Best Regards Sajan
Re: Reg. Synchronization between MySQL DBs
Did you look at doing something with replication? Mat Your mouse has moved. Windows must be restarted for the change to take effect. Reboot now? [ OK ] - Original Message - From: "Aigars Grins" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 28, 2001 3:27 PM Subject: Reg. Synchronization between MySQL DBs Hi, The short version: Does anyone know an automated way of keeping two MySQL db's (located on different machines) in sync? A small window of non-sync could be acceptable. The long version: I'm working on a project which basically is about capturing a lot of data from different places and storing them in a central database. Once there we make a lot of interpreting of the data etc. So far we've used a proprietery distributed database/information forwarding solution. Some of the data inquires are suited to be stated in SQL. For that purpose we regularilly export subsets of the data to a MySQL db and from there extract the compiled data. The export routines take a lot of time, hence we would like to do the export routines work parallel with the rest of operations. This isn't a problem initself. While our project grows we get more and more demands on how the thing should work. One thing is redundancy. To cope with that in this specific instance we would like to have an auto-magical way of synchronizing two different db's (located on different machines). Does anyone know a way to do this? One, obvious, way would be to have a gathering point previous to the MySQL db. From there we could make sure all data is inserted in both db's. Since we have our own solution of how to get the data that far this isn't a problem initself. The problem is that so far we've managed to let different applications change things in the db directly. Those changes would have to be auto-magically reflected to the other db's as well. This part is what we like to auto-magically automate. (It wouldn't be acceptable to require all 'analyzing' apps to update all db's by themselves.) One way would of course be to build a through'n'through multi-tier solution where the db is simply the local db for each 'node'. This has two down-sides. One is the development cost of such a system (_big_). The other is performance. The extra (real-time) abstraction layer would most propably have a performance hit on the system. And we're really short on resources (the data amount in from time to time enormous). So once again, has anyone done something like this? Any experiences to share? Any pointers to where to start and look? Should I forward this message to somewhere else? -- Aigars Grins - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Reg. Synchronization between MySQL DBs
Hi, Does anyone know an automated way of keeping two MySQL db's (located on different machines) in sync? A small window of non-sync could be acceptable. Read about "replication" in the corresponding chapters in the online manual of mySQL (http://www.mysql.com/) - Documentation. Regards ... Ralph ... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Coldfusion/MySQL - Connection Failed
Hi! Let me try to restate my question and provide more information. Running: Linux 2.2.16-3, Coldfusion 4.5, MySQL 3.23.33 Problem: "The connection to the data source failed. Check the following to resolve this problem: ..." Now, I get this error on one database called xprojects while I can get the datasource to verify on the test database that came with mysql. i connect to the test with no user and no password. I tried to set up the permissions on the xprojects database like the test database.. but it still didnt work. I am assuming based upon what I have read about MySQL and Coldfusion that this is a permissions issue. For those that have this working what should the permissions be like and could this be anything else? Thanks, -Tanya - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Is it possible to use an optional field?
Hi, I have two joined tables (three actually, but for an example, 2 is OK)... example: Names / Function Then in names I have NameID, Name, and FunctionID, and in Function table, I havce FunctionID, and FunctionName... therefore, I need to find the Function Name of a Person, through their name... - simple engouh until this point... SELECT Names.NameID, Names.Name, Names.FunctionID, Functions.FunctionName WHERE (Functions.FunctionID = Names.FunctionID)... However, in some cases, Names.FunctionID might be empty, or not match anything in Functions table, and in this case I want the Functions.FunctionName to show up as null, or empty... I have been told that in MS Sql, the query would be something like the above, with the where like this: WHERE (Names.FunctionID=*Functions.FunctionID) This did not work in MySQL 3.23.30... Can you help? Thanks! PS: Please reply directly to me... (Reply All)... Thanks! :) Roy Nasser CTO Vem C Servicos de Internet S/C Ltda. Av. Paulista 2421 14* Andar So Paulo SP Brasil 55 11 3347 3456 / 9953 8853 - cel www.jarbas.com.br [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
error in unzip
I have Solaris 2.6 on a SUN E450 I downloaded the mysql-3.23.36.tar.gz from some site and now when i unzip it using gunzip mysql-3.23.36.tar.gz | tar xvf - it gives me tar: directory checksum error please help I have downloaded the file mysql-3.23.36.tar.gz twice and unzipped it twice, i get the same error - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Reg. Synchronization between MySQL DBs
On Wed, 28 Mar 2001, Aigars Grins wrote: Hi, The short version: Does anyone know an automated way of keeping two MySQL db's (located on different machines) in sync? A small window of non-sync could be acceptable. The long version: snip The important question is how much availability ( the ability to survive network partitions) your looking for: 1) Is simple master -- slave replication good enough for your application ? all inserts updates going onto the Master the slave being read only at all times ? MySQL has in built support for this (Gamma). 2) Are the queries your performing on the data you capturing 'transactional' i.e. dependent on the presence/state of the rest of the data set all the time? If not MySQL + some scripting can be made to re-sync two 'peer' databases on a regular basis providing you design your insert update queries carefully particually incrementing keys. This can be done with the plain text update log or with timestamped fields. Several people who frequent the list have made similar applications to this. Here we run two copies of a critical database in this manner both operating read/write suviving each other in the event of failure. Both of these are documented in the manual, if your application needs fully distributed transactions, MySQL is not the system your looking for. Nigel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Is it possible to use an optional field?
I took a look at the manual, but I am a bit unsure of how this would be done in a multi-table wuery, such as the one below... if anyone can help, greatly appreciated! :) SELECT DISTINCT Questions.QuestionID, Questions.Question, Experts.ExpertFullName, Category.CategoryName, Questions.Shows, Questions.Views FROM Questions, Experts, Category WHERE (Questions.ClientID='15') AND (Questions.ExpertID = Experts.ExpertID) AND (Questions.CategoryID = Category.CategoryID) AND Questions.OnHold=2 GROUP BY Questions.QuestionID; Thank you for all help! As usual, please Reply All! :) -Original Message- From: nigel wood [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 8:16 PM To: Roy Nasser Subject: Re: Is it possible to use an "optional field"? On Wed, 28 Mar 2001, you wrote: Hi, I have two joined tables (three actually, but for an example, 2 is OK)... example: Names / Function Then in names I have NameID, Name, and FunctionID, and in Function table, I havce FunctionID, and FunctionName... therefore, I need to find the Function Name of a Person, through their name... - simple engouh until this point... SELECT Names.NameID, Names.Name, Names.FunctionID, Functions.FunctionName WHERE (Functions.FunctionID = Names.FunctionID)... However, in some cases, Names.FunctionID might be empty, or not match anything in Functions table, and in this case I want the Functions.FunctionName to show up as null, or empty... I have been told that in MS Sql, the query would be something like the above, with the where like this: WHERE (Names.FunctionID=*Functions.FunctionID) This did not work in MySQL 3.23.30... Can you help? Thanks! PS: Please reply directly to me... (Reply All)... Thanks! :) Look up LEFT JOIN in the manual get a copy of PaulBois's 'MySQL' book Nigel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Is it possible to use an optional field?
Assuming that there is a one-to-one relationship between the tables on the FunctionID (meaning there is only one entry in Functions for each FunctionID), then... SELECT Names.NameID, Names.Name, Names.FunctionID, Functions.FunctionName FROM Names LEFT JOIN Functions ON (Names.FunctionID=Functions.FunctionID); The resulting FunctionName will be NULL if a match is not found. Roy Nasser [EMAIL PROTECTED] wrote: Hi, I have two joined tables (three actually, but for an example, 2 is OK)... example: Names / Function Then in names I have NameID, Name, and FunctionID, and in Function table, I havce FunctionID, and FunctionName... therefore, I need to find the Function Name of a Person, through their name... - simple engouh until this point... SELECT Names.NameID, Names.Name, Names.FunctionID, Functions.FunctionName WHERE (Functions.FunctionID = Names.FunctionID)... However, in some cases, Names.FunctionID might be empty, or not match anything in Functions table, and in this case I want the Functions.FunctionName to show up as null, or empty... I have been told that in MS Sql, the query would be something like the above, with the where like this: WHERE (Names.FunctionID=*Functions.FunctionID) This did not work in MySQL 3.23.30... Can you help? Thanks! PS: Please reply directly to me... (Reply All)... Thanks! :) Roy Nasser CTO Vem C Servicos de Internet S/C Ltda. Av. Paulista 2421 14* Andar So Paulo SP Brasil 55 11 3347 3456 / 9953 8853 - cel www.jarbas.com.br [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: Reg. Synchronization between MySQL DBs
From: "Ralph Graulich" [EMAIL PROTECTED] Read about "replication" in the corresponding chapters in the online manual of mySQL (http://www.mysql.com/) - Documentation. From: "Mat Murdock" [EMAIL PROTECTED] Did you look at doing something with replication? Thanks for the quick reply. I hadn't looked at replication previously. I've read the text about it now, and might have missed something. But.. In the setup I'm looking for there is no clear master-slave relationsship. With this in mind I could setup numerous servers to all act master to all others. This would be way of keeping all in sync. There are problems with this setup (as stated in the manual), ie. things are not allowed to go wrong if updates are done in slightly different choronological order. I understand why this is so. This would be a problem for all but very simplistic informations. In our setup the different db's aren't backups (slaves), but all are used as masters (they're located differently geographicaly). I guess I'm looking for a 'clustered' service where all db's act as if there we a single one. I didn't expect MySQL to handle this out of the box but was hoping there was a 3rd party add-on/sub system/super system through which it could be 'easely' done. -- Aigars - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Reg. Synchronization between MySQL DBs
Tnx for the answer. From: "nigel wood" [EMAIL PROTECTED] The important question is how much availability ( the ability to survive network partitions) your looking for: 1) Is simple master -- slave replication good enough for your application ? all inserts updates going onto the Master the slave being read only at all times ? MySQL has in built support for this (Gamma). This would not be enough. 2) Are the queries your performing on the data you capturing 'transactional' i.e. dependent on the presence/state of the rest of the data set all the time? If not MySQL + some scripting can be made to re-sync two 'peer' databases on a regular basis providing you design your insert update queries carefully particually incrementing keys. This can be done with the plain text update log or with timestamped fields. Several people who frequent the list have made similar applications to this. Here we run two copies of a critical database in this manner both operating read/write suviving each other in the event of failure. Both of these are documented in the manual, if your application needs fully distributed transactions, MySQL is not the system your looking for. Sigh. Maybe it isn't. That would be too bad. I like MySQL. I'll look over the replication descriptions once more.. -- Aigars Grins - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Coldfusion/MySQL
Nevermind about my previous posts I got it to work! -Tanya - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Is it possible to use an optional field?
Your query converted to using left joins: SELECT DISTINCT Questions.QuestionID, Questions.Question, Experts.ExpertFullName, Category.CategoryName, Questions.Shows, Questions.Views FROM Questions LEFT JOIN Experts ON (Questions.ExpertID = Experts.ExpertID) LEFT JOIN Category ON (Questions.CategoryID = Category.CategoryID) WHERE Questions.OnHold = 2 GROUP BY Questions.QuestionID That will grab each record in the Questions table, and return data in Experts and Categories *IF* it exists, otherwise nulls. - Original Message - From: "Roy Nasser" [EMAIL PROTECTED] To: "'nigel wood'" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, March 28, 2001 3:18 PM Subject: RE: Is it possible to use an "optional field"? I took a look at the manual, but I am a bit unsure of how this would be done in a multi-table wuery, such as the one below... if anyone can help, greatly appreciated! :) SELECT DISTINCT Questions.QuestionID, Questions.Question, Experts.ExpertFullName, Category.CategoryName, Questions.Shows, Questions.Views FROM Questions, Experts, Category WHERE (Questions.ClientID='15') AND (Questions.ExpertID = Experts.ExpertID) AND (Questions.CategoryID = Category.CategoryID) AND Questions.OnHold=2 GROUP BY Questions.QuestionID; Thank you for all help! As usual, please Reply All! :) -Original Message- From: nigel wood [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 8:16 PM To: Roy Nasser Subject: Re: Is it possible to use an "optional field"? On Wed, 28 Mar 2001, you wrote: Hi, I have two joined tables (three actually, but for an example, 2 is OK)... example: Names / Function Then in names I have NameID, Name, and FunctionID, and in Function table, I havce FunctionID, and FunctionName... therefore, I need to find the Function Name of a Person, through their name... - simple engouh until this point... SELECT Names.NameID, Names.Name, Names.FunctionID, Functions.FunctionName WHERE (Functions.FunctionID = Names.FunctionID)... However, in some cases, Names.FunctionID might be empty, or not match anything in Functions table, and in this case I want the Functions.FunctionName to show up as null, or empty... I have been told that in MS Sql, the query would be something like the above, with the where like this: WHERE (Names.FunctionID=*Functions.FunctionID) This did not work in MySQL 3.23.30... Can you help? Thanks! PS: Please reply directly to me... (Reply All)... Thanks! :) Look up LEFT JOIN in the manual get a copy of PaulBois's 'MySQL' book Nigel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 in unzip
try to use gtar from www.mysql.com there is some known problem in solaris tar file... -Original Message- From: Shahid Iqbal [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 3:04 PM To: [EMAIL PROTECTED] Subject: error in unzip I have Solaris 2.6 on a SUN E450 I downloaded the mysql-3.23.36.tar.gz from some site and now when i unzip it using gunzip mysql-3.23.36.tar.gz | tar xvf - it gives me tar: directory checksum error please help I have downloaded the file mysql-3.23.36.tar.gz twice and unzipped it twice, i get the same error - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Is it possible to use an optional field?
I think I got it working... thanks! I had a few pretty complex queries, so it took a little while to understand, and then convert all of them! :) -Original Message- From: Eric Fitzgerald [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 8:56 PM To: Roy Nasser; 'nigel wood'; [EMAIL PROTECTED] Subject: Re: Is it possible to use an "optional field"? Your query converted to using left joins: SELECT DISTINCT Questions.QuestionID, Questions.Question, Experts.ExpertFullName, Category.CategoryName, Questions.Shows, Questions.Views FROM Questions LEFT JOIN Experts ON (Questions.ExpertID = Experts.ExpertID) LEFT JOIN Category ON (Questions.CategoryID = Category.CategoryID) WHERE Questions.OnHold = 2 GROUP BY Questions.QuestionID That will grab each record in the Questions table, and return data in Experts and Categories *IF* it exists, otherwise nulls. - Original Message - From: "Roy Nasser" [EMAIL PROTECTED] To: "'nigel wood'" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, March 28, 2001 3:18 PM Subject: RE: Is it possible to use an "optional field"? I took a look at the manual, but I am a bit unsure of how this would be done in a multi-table wuery, such as the one below... if anyone can help, greatly appreciated! :) SELECT DISTINCT Questions.QuestionID, Questions.Question, Experts.ExpertFullName, Category.CategoryName, Questions.Shows, Questions.Views FROM Questions, Experts, Category WHERE (Questions.ClientID='15') AND (Questions.ExpertID = Experts.ExpertID) AND (Questions.CategoryID = Category.CategoryID) AND Questions.OnHold=2 GROUP BY Questions.QuestionID; Thank you for all help! As usual, please Reply All! :) -Original Message- From: nigel wood [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 8:16 PM To: Roy Nasser Subject: Re: Is it possible to use an "optional field"? On Wed, 28 Mar 2001, you wrote: Hi, I have two joined tables (three actually, but for an example, 2 is OK)... example: Names / Function Then in names I have NameID, Name, and FunctionID, and in Function table, I havce FunctionID, and FunctionName... therefore, I need to find the Function Name of a Person, through their name... - simple engouh until this point... SELECT Names.NameID, Names.Name, Names.FunctionID, Functions.FunctionName WHERE (Functions.FunctionID = Names.FunctionID)... However, in some cases, Names.FunctionID might be empty, or not match anything in Functions table, and in this case I want the Functions.FunctionName to show up as null, or empty... I have been told that in MS Sql, the query would be something like the above, with the where like this: WHERE (Names.FunctionID=*Functions.FunctionID) This did not work in MySQL 3.23.30... Can you help? Thanks! PS: Please reply directly to me... (Reply All)... Thanks! :) Look up LEFT JOIN in the manual get a copy of PaulBois's 'MySQL' book Nigel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Complex SQL Query
Actually, these are a portion of a table that's contents are generated by Radius records imported into a MySQL table, so both values are generated simultaneously (or, at least as far as MySQL as concerned). -Original Message- From: Oson, Chris M. [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 15:53 To: Alberni-dot-Net Cc: [EMAIL PROTECTED] Subject: RE: Complex SQL Query Aaron, Are you inserting both values at once? Or inserting the startdate first, then updating the stopdate later. You may or may not be able to do this in one query. To determine how much time is being spent between Midnight and 6am... select if ( time_to_sec(time_format(dateModified, "%H:%I:%s")) 21600, time_to_sec(time_format(dateModified, "%H:%I:%s")) - (time_to_sec(time_format(dateModified, "%H:%I:%s")) - 21600), time_to_sec(time_format(dateModified, "%H:%I:%s")) ) as '12AM-6AM' from newsStories where storyID = 1105; ** You'll need to make changes to the last line (the from clause to meet your needs) 21600 is the number of seconds between 00:00:00 and 06:00:00 The documentation on IF (expr1, expr2, expr3) goes something like this: expr1 evaluates to T/F IF (expr1 = T) THEN expr2 ELSE expr3 The select statment basically says... compute the number of seconds and see if it's greater than 21600.. If so, subtract the EXCESS number of seconds AFTER 6am from the total else keep the total number of seconds Now, I belive that in order to solve your problem you'll need to compare the dates between the first two columns. If the *days* are different, then the stopdate occurred sometime after midnight. In which case, you now have the means to determine what the number of seconds between 12am-6am. You'll then take the TOTAL number of seconds (between startdate/stopdate) and subtract the number of seconds from the query above and that will give you the number of seconds between 6am-12am. You'll definitely need to lookinto IF(expr1, expr2, expr3) AND maybe CASE something THEN something ELSE something else END to meet your needs, but I believe I've given you enough information to get you on your way one more thing make sure you're syntax is correct with the previous query or you WILL return a null value. I found that out the hard way. one more thing part II this solution doesn't take into account if the startdate/stopdate spans more than two days HTH, and good luck, and if you're in a good mood, can you send me your final solution;) christopher oson -Original Message- From: Alberni-dot-Net [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 1:04 PM To: [EMAIL PROTECTED] Subject: Complex SQL Query I have been trying for the last while to come up with a query that will do the following: Say I have table with these records: StartDate StopDate --- 2001-01-23 23:43:12 2001-01-24 04:29:12 2001-01-24 15:24:00 2001-01-26 01:15:02 2001-01-24 23:10:16 2001-01-24 23:15:59 2001-01-25 09:36:44 2001-01-27 12:11:41 The query to get the sum of all the seconds between the "StopDate" and "StartDate" is easy. What I need to do is break that down into how many seconds of that total were spent between midnight and 6am (and, conversely, how many seconds of that total were spent between 6am and midnight). I know the answer is probably very simple, but I have yet to figure it out. Aaron Clausen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Counting distinct rows
Hi, I am trying to count all the distinct id numbers in a column but I just can't figure it out... What would be the appropriate select statement for this, 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: Counting distinct rows
At 8:32 AM +0800 3/29/01, [EMAIL PROTECTED] wrote: Hi, I am trying to count all the distinct id numbers in a column but I just can't figure it out... What would be the appropriate select statement for this, thanks, SELECT COUNT(DISTINCT id) FROM tbl_name -- Paul DuBois, [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: Counting distinct rows
I'd try: Select distinct count(id) from myTable; Regards, Gary "SuperID" Huntress === FreeSQL.org offering free database hosting to developers Visit http://superid.dyndns.org:8080/freesql/index.php "Currently 100% Slogan Free" - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 28, 2001 7:32 PM Subject: Counting distinct rows Hi, I am trying to count all the distinct id numbers in a column but I just can't figure it out... What would be the appropriate select statement for this, 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: MySQL books
The O'Reilly MySQL msql book is not bad, but then I bought Paul DuBois' book, and now I only use the command reference at the back of the O'Reilly book for quick lookups. I like the way it is layed out. Every other question relating to MySQL has been answered by Paul's book. On 3/28/01 1:28 PM, "[EMAIL PROTECTED]" [EMAIL PROTECTED] wrote: Speaking of books on MySQL are there more than one to choose from? If so is MySQL written by Paul DuBois the best one? John Jackson Direct Access Recruiters [EMAIL PROTECTED] -Original Message- From: B. van Ouwerkerk [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 5:03 AM To: [EMAIL PROTECTED] Subject: Re: Betr.: Hello ...And.. a book called MySQL written by Paul DuBois. It's a great book and will help you to get things up and running within a very short time.. It will cost you another 2-3 days (based on 8 hours per day) to work your way through the book and all the examples.. but you will know most of the basics.. 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Counting distinct rows
SELECT COUNT(DISTINCT ID) FROM my_table; Note: NULL values will be omitted from the count. regards, thalis p.s. would be a good idea to read an SQL tutorial before your next post On Thu, 29 Mar 2001 [EMAIL PROTECTED] wrote: Hi, I am trying to count all the distinct id numbers in a column but I just can't figure it out... What would be the appropriate select statement for this, 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: running Mysql client
If the user was defined using a password, then you must use the password. If the user was defined without a password, then you must NOT use a password. Since the userid is unique key in the grant tables, you can't have it both ways. Pick one and go with it (best to use the password) If you really don't want to have to use a password, at least add the additional restriction of only connecting from a certain host. Ie: GRANT privileges ON dbs.tables(*.*?) TO user@host; (don;t forget to flush privileges immediately after to make it take affect) On 3/28/01 12:43 PM, "Hammad Nasim" [EMAIL PROTECTED] wrote: Hi I am having some problems running mysql client. I can connect mysql server from client machine by skipping password. But if I try to connect with password, message is displayed Error 1045: Access denied for user using password. Kindly help me out here. Hammad - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Is this a normal behaviour?
Thanks. Just needed a confirmation. :-) Cal Evans wrote: Yes and I believe it's explained in the manual better than I can explain it here. Roughly speaking, if the field contains: foobar then LIKE 'foo%' says match anything starting with foo. Since it's STARTING with foo then the index can be used. Just like the Index of a book would be useless if you wanted to find references in a book for all words ending in bar. LIKE '%foo%' won't use and index either for the same reason. LIKE '%bar' is right out. HTH, Cal http://www.calevans.com -Original Message- From: --==[bMan]==-- [mailto:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 7:40 PM To: MySQL List Subject: Is this a normal behaviour? O.K. I use MySQL version 3.23 (RedHat 7.0 release) and have a question about this query: 1.) [...] LIKE '%pattern' 2.) [...] LIKE 'pattern%' The first query does not use an index while the second does. Is there any explenation for this? Thanks. -- Bolek, URL: http://www.bolek.com URL: http://slash.bolek.com e-mail: [EMAIL PROTECTED] ICQ: 4086197, Address: 402905326 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Bolek, URL: http://www.bolek.com URL: http://slash.bolek.com e-mail: [EMAIL PROTECTED] ICQ: 4086197, Address: 402905326 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-t option in mysqladmin
Hello All, I see a -t or a --timeout= option listed for mysqladmin, but I can't seem to get mysqladmin to recognize it. Is this an oversight in documentation or a case of my misunderstanding? My objective is to be able to ping each of our mysql servers with a script and report on their health. It seems that if the server is hung up, the ping command doesn't return and I was hoping to remedy that with the -t switch. Thanks! -- john === John Cartwright Professional Research Assistant / Associate Scientist CIRES, SEG/NGDC/NOAA (303) 497-6284 [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: Perl - DBD:DBI Errors
Is the zlib on CPAN? like module Compress::Zlib ? Many Thanks Gerald! ChrisB MCSE MCDBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Gerald Clark Sent: Wednesday, March 28, 2001 9:26 AM To: Chris Becker Cc: [EMAIL PROTECTED] Subject: Re: Perl - DBD:DBI Errors You don't have zlib on your machine. Check your 6.2 CD. Chris Becker wrote: I'm having trouble installing the perl module DBD specifically. I found on my CPAN cd the DBD module Msql-Mysql-modules-1.2208, tried to install it and got errors, I discovered I needed DBI installed first. So I found DBI-1.13 and did the following: perl Makefile.PL make make test Made 100 connections in 0 wallclock secs... test.pl done DBI seemed to install ok. Then I found DBD Msql-Mysql-modules-1.2210 and did the following: perl Makefile.PL select 1) MySQL only n - for install perl emulation then make make test then get output from make test: ...install_driver(mysql) failed: Can't load '../blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: ../blib/arch/auto/DBD/mysql/mysql.so: undefined symbol: uncompress at /usr/lib/perl5/5.00503/i386-linux/DynaLoader.pm line 169. at (eval 1) line 3 at t/00base.t line 38 dubious Test returned status 255 (wstat 65280, 0xff00) Undefined subroutine Test::Harness::WCOREDUMP called at /usr/lib/perl5/5.00503/ Test/Harness.pm line 288. make[1]: *** [test_dynamic] Error 255 make[1]: Leaving directory '/perlmods/Msql-Mysql-modules-1.2210/mysql' make: *** [test] Error\ 2 after the above errors even i tried executing the 'make install'. Then I tried a sample perl file using the 'use DBI' function to test the perl module install w/ MySQL, and when I execute I get the same error: undefined symbol: uncompress at blah blah blah... Please Help. What am I doing wrong? Do I need to do an un-install before trying to re-install DBD? Should I blow out Perl altogether and reinstall? Has anyone seen this before? Thanks in advance, Chris Becker - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
mysql_info() returns an empty string
Description: mysql_info() returns an empty string as the return value for a successful insert/load data. Furthermore, mysqlimport does not give the same information: peter@ulisse ~/develop/seler $ mysqlimport --local -u seler seler foo seler.foo: ^^^ Here is where we used to have some information (at least in 3.23.32). How-To-Repeat: trivial Fix: Submitter-Id: submitter ID Originator:Peter Radig Organization: MySQL support: none Synopsis: mysql_info() returns empty string Severity: non-critical Priority: medium 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 sun-solaris2.8 on sparc 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: 7 days 3 hours 7 min 45 sec Threads: 1 Questions: 3106179 Slow queries: 342 Opens: 1078 Flush tables: 1 Open tables: 12 Queries per second avg: 5.042 Environment: System: SunOS ulisse 5.8 Generic_108528-06 sun4u sparc SUNW,Ultra-2 Architecture: sun4 Some paths: /usr/local/bin/perl /usr/local/bin/make /usr/local/bin/gcc /opt/SUNWspro/bin/cc GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.8/2.95.2/specs gcc version 2.95.2 19991024 (release) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: -rw-r--r-- 1 root bin 1754016 Nov 23 13:29 /lib/libc.a lrwxrwxrwx 1 root root 11 Jan 6 00:15 /lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 1129948 Nov 23 13:29 /lib/libc.so.1 -rw-r--r-- 1 root bin 1754016 Nov 23 13:29 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Jan 6 00:15 /usr/lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 1129948 Nov 23 13:29 /usr/lib/libc.so.1 Configure command: ./configure --prefix=/usr/local --with-mysqld-user=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
Re: myisam upgrade problem
Thanks! So, is there any way to calculate the approximate disk space required for the transformation from ISAM to MYISAM? Gerald Clark wrote: error 28 is "No space left on device". Hang wrote: Greetings, I am upgrading my mysql from 3.22.23b to 3.23.35 on RedHat with kernel 2.4.0. I followed the instructions on the manual for the upgrade. Every goes fine except I can't convert one table from ISAM to MYISAM. I got quite a lot of tables and all can be converted successfully but not this table. It contains 3,000,000 rows, 80MB data file and 250MB index file. I got following error message when I am converting the table format: mysql alter table mytable type=MYISAM; ERROR 3: Error writing file '/tmp/ST4kylYE' (Errcode: 28) I also found following line by running "ls -al /proc/12121/fd" (12121 is the pid of the mysqld): lrwx--1 root root 64 Mar 28 12:25 17 - /tmp/ST4kylYE (deleted) I had run isamcheck before the conversion and my /tmp got 400MB disk space. Any one have idea what's going wrong? Besides, I also have tables on other Linux machines with about 200MB data and 2.0GB index file. Will there be any problem? Pls Help. Thanks. -- CH Tsang - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 -- CH Tsang Outblaze Ltd. Em@il: [EMAIL PROTECTED]
Re: myisam upgrade problem
Hi. On Thu, Mar 29, 2001 at 10:47:54AM +0800, [EMAIL PROTECTED] wrote: Thanks! So, is there any way to calculate the approximate disk space required for the transformation from ISAM to MYISAM? I would have assumed 330MB and don't see the reason why it should use more. Obviously I am wrong about that. I think a solution should be to tell the MySQL daemon to store temporary files in a different directory, where you have enough space left (e.g. via the TMPDIR environment variable or the --tmpdir command line option). As a side note, your index/data size ratios seem a bit big. There are usually ways to keep indexes smaller. YMMV, of course. Bye, Benjamin. Gerald Clark wrote: error 28 is "No space left on device". Hang wrote: [...] I got quite a lot of tables and all can be converted successfully but not this table. It contains 3,000,000 rows, 80MB data file and 250MB index file. I got following error message when I am converting the table format: mysql alter table mytable type=MYISAM; ERROR 3: Error writing file '/tmp/ST4kylYE' (Errcode: 28) [...] I had run isamcheck before the conversion and my /tmp got 400MB disk space. Any one have idea what's going wrong? Besides, I also have tables on other Linux machines with about 200MB data and 2.0GB index file. Will there be any problem? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: myisam upgrade problem
Alternate solution, mysqldump --add-droptable db_name table_name path/with/a/lot/of/room/table_name.sql Edit your file and change the table create clause to include TYPE = MYISAM after the column defs. Ie: CREATE TABLE table_name (column1 def, column2 def,...) TYPE = MYISAM Then: mysql dbname table_name.sql Why? This will drop your table, and completely rebuild the index from scratch, without taking the server down entirely. You also have a handy backup file that you can continue to work with later if necessary. Converting table type on the fly may be faster, I don't know, but if I can afford the down time, I would prefer to create a backup of the data before altering table structure. Know what I mean? Lindsay Adams On 3/28/01 7:11 PM, "Benjamin Pflugmann" [EMAIL PROTECTED] wrote: Hi. On Thu, Mar 29, 2001 at 10:47:54AM +0800, [EMAIL PROTECTED] wrote: Thanks! So, is there any way to calculate the approximate disk space required for the transformation from ISAM to MYISAM? I would have assumed 330MB and don't see the reason why it should use more. Obviously I am wrong about that. I think a solution should be to tell the MySQL daemon to store temporary files in a different directory, where you have enough space left (e.g. via the TMPDIR environment variable or the --tmpdir command line option). As a side note, your index/data size ratios seem a bit big. There are usually ways to keep indexes smaller. YMMV, of course. Bye, Benjamin. Gerald Clark wrote: error 28 is "No space left on device". Hang wrote: [...] I got quite a lot of tables and all can be converted successfully but not this table. It contains 3,000,000 rows, 80MB data file and 250MB index file. I got following error message when I am converting the table format: mysql alter table mytable type=MYISAM; ERROR 3: Error writing file '/tmp/ST4kylYE' (Errcode: 28) [...] I had run isamcheck before the conversion and my /tmp got 400MB disk space. Any one have idea what's going wrong? Besides, I also have tables on other Linux machines with about 200MB data and 2.0GB index file. Will there be any problem? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 books
I was at the store tonight. Did not see an O'Reilly book but believe I saw the book by Paul DuBois. There was also a book, one of the Teach Yourself (MySQL) in 21 Days, series. Anybody familiar with that one? John Jackson [EMAIL PROTECTED] -Original Message- From: Lindsay Adams [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 7:29 PM To: [EMAIL PROTECTED] Subject: Re: MySQL books The O'Reilly MySQL msql book is not bad, but then I bought Paul DuBois' book, and now I only use the command reference at the back of the O'Reilly book for quick lookups. I like the way it is layed out. Every other question relating to MySQL has been answered by Paul's book. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 books
I got the PaulDubois book , but i made a mistake i bought the transaltion in french. An advice to all others who are thinking of buying it in french if you can buy it in englis , Yann - Original Message - From: [EMAIL PROTECTED] To: "Lindsay Adams" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, March 28, 2001 11:22 PM Subject: RE: MySQL books I was at the store tonight. Did not see an O'Reilly book but believe I saw the book by Paul DuBois. There was also a book, one of the Teach Yourself (MySQL) in 21 Days, series. Anybody familiar with that one? John Jackson [EMAIL PROTECTED] -Original Message- From: Lindsay Adams [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 7:29 PM To: [EMAIL PROTECTED] Subject: Re: MySQL books The O'Reilly MySQL msql book is not bad, but then I bought Paul DuBois' book, and now I only use the command reference at the back of the O'Reilly book for quick lookups. I like the way it is layed out. Every other question relating to MySQL has been answered by Paul's book. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Freeing Pointer outof range
"Freeing pointer out of range at line 102" this is the message generated in the error file of the Apache Web Server logs directory. The line 102 in the program refers to the connectivity command for my sql through 32-bit ODBC driver. We are working on windows NT and MySql 3.23 . The error file with the message above is occupying upto 4 GB which is the remaining memory of the harddisk. This is also keeping the CPU 100% busy and the system almost gets hanged. Please suggest any solutions or guide us regarding. Please respond me at [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: got EJB error
Hi I have not used EJB app server with MySQL w/ BDB support. Indeed I used Jrun with Sybase for feasibility test. But for setting AutoCommit, I suggest u'd check MySQL JDBC whether it supports to disable auto commit. If it can, try to run your JDBC code to disable instead of running in .setEntityContext. For setting default value to MySQL server, u'd better search in manual. I haven't noticed that yet. Tony -Original Message- From: muhammed najmi [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 29, 2001 2:51 PM To: [EMAIL PROTECTED] Subject:got EJB error hi am usimg EJB with Mysql.(also Berkeley DB).But while running client application am getting a Remote exception.Am using J2ee application server.From the error log file i got the error description as javax.ejb.EJBException:Unable to connect to database.Cannot disable AUTOCOMMIT at AccountEJB.setEntityContext(AccountEJB.java:146) ... ... like that Is it possible to start mysql with autocommit 0 by default. Expecting a speedy reply thanking u najmi Get free email and a permanent address at http://www.netaddress.com/?N=1 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Fulltext problem
Hi I'am new to sql and I have a problem with a full text dokument in my database. Is there any way to edit a full text dokument in mysql ? ** Regards Morgan Norell System Administrator Euro Business Link www.ebl.se
Mysql + Staroffice
Dear reader, Maybe this question is slightly off-topic, but what the hell ;) I'm the sysadming for a little firm which use a few Windoze computer and a lot of linux/BSD-servers. The windoze computers are used by the accounting staff and use Staroffice 5.2 as their Office application. There is alot of information stored on linux systems using Mysql as the databaseserver (because it rocks!), the only thing is that I don't have a clue how to setup Windows/Staroffice in such a way that some of the mysql-databases can be used in Staroffice. Also i would like to know how to do the same with my Linux-workstation running Staroffice for Linux. Anybody a clue, some wisedom, tips or links to resources? Best Regards, Maarten Verheijen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 books
I was at the store tonight. Did not see an O'Reilly book but believe I saw the book by Paul DuBois. There was also a book, one of the Teach Yourself (MySQL) in 21 Days, series. Anybody familiar with that one? I would go for Paul's book (he should pay me for everytime I refer to his book :)) If you're starting with MySQL his book is great, explains how to connect with MySQL from C, Perl and PHP. Wouldn't miss the O'Reilly book though. I'm not familiar with the Teach Yourself MySQL book. Paul's book took me 2 days.. 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