Re: Select query
On 6/7/01 5:33 PM, Gary Huntress [EMAIL PROTECTED] wrote: I'll bet it's a roundoff problemtry select * from sequence_protein where mol_wt 53211.62 and mol_wt 53211.63 Regards, Gary SuperID Huntress === FreeSQL.org offering free database hosting to developers Visit http://www.freesql.org - Original Message - From: Hannes Niedner [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 07, 2001 5:48 PM Subject: Select query What do I do wrong? The query result is not supposed to be an empty set (please cc your response to [EMAIL PROTECTED]) mysql select sequence_id, mol_wt from sequence_protein limit 1; +-+--+ | sequence_id | mol_wt | +-+--+ | 100368 | 53211.62 | +-+--+ 1 row in set (0.02 sec) mysql select distinct sequence_id from sequence_protein - where mol_wt=53211.62; Empty set (0.12 sec) mysql describe sequence_protein; +-+--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +-+--+--+-+-+---+ | sequence_id | int(10) unsigned | | PRI | 0 | | | length | int(10) unsigned | | | 0 | | | mol_wt | float(10,2) | YES | | 0.00| | +-+--+--+-+-+---+ Thank you Hannes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 guys are great and solved my case mysql select sequence_id from sequence_protein - where truncate(mol_wt,2) =53211.62; +-+ | sequence_id | +-+ | 100368 | +-+ 1 row in set (0.18 sec) I do apologize, I was following the wrong thread in the manual. Thanx Hannes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: JOIN to the same table multiple times
Ok, I've answered my own question but now have another. How do I reference the sitename for the 3 sites? sitename returns the last sitename for all 3 I tried S1.sitename etc. but it doesn't work. $query = SELECT * FROM department LEFT JOIN sites S1 ON deptsite1=S1.sitekey LEFT JOIN sites S2 ON deptsite2=S2.sitekey ORDER BY $order $dir; $result = mysql_db_query($dbName,$query); while ($r=mysql_fetch_array($result)) { echo tr bgcolor=$colorvalues tdfont size=\-1\$r[deptdesc]/td /tr tr bgcolor=$colorvalues tdfont size=\-1\$r[sitename]/td tdfont size=\-1\$r[deptphone1]/td tdfont size=\-1\$r[deptfax1]/td tdfont size=\-1\$r[deptemail1]/td tdfont size=\-1\$r[deptmobile1]/td/tr tdfont size=\-1\$r[sitename]/td tdfont size=\-1\$r[deptphone2]/td tdfont size=\-1\$r[deptfax2]/td tdfont size=\-1\$r[deptemail2]/td tdfont size=\-1\$r[deptmobile2]/td/tr tdfont size=\-1\$r[sitename]/td tdfont size=\-1\$r[deptphone3]/td tdfont size=\-1\$r[deptfax3]/td tdfont size=\-1\$r[deptemail3]/td tdfont size=\-1\$r[deptmobile3]/td; -Original Message- From: Ross Goonan [mailto:[EMAIL PROTECTED]] Sent: Friday, 8 June 2001 11:47 To: [EMAIL PROTECTED] Subject: JOIN to the same table multiple times ### Creating a Telephone / Information Directory with MySQL / PHP3 People belong to a department a site. Need to be able to: List all people List all people within a Department List all people within a site List all people within a Department Site Have set up Department table with site1, site2 site3 as the same department exists in multiple sites. When listing a site, I need to JOIN the site table multiple times to get the site name. SELECT * FROM Department LEFT JOIN Site ON Site1=Sitekey - Works no worries SELECT * FROM Department LEFT JOIN Site ON Site1=Sitekey LEFT JOIN Site ON Site2=Sitekey - Error 1066: Not unique table/alias 'Site' SELECT * FROM Department LEFT JOIN Site ON Site1=Sitekey LEFT JOIN Site AS Sitetable ON Site2=Sitekey - Error 1052: Column 'Sitekey' in on clause is ambiguos ### rpm -qa | grep SQL MySQL-3.23.33-1 MySQL-client-3.23.33-1 MySQL-devel-3.23.33-1 rpm -qa | grep sql php-mysql-3.0.16-2bc perl-Msql-Mysql-modules-1.2210-2 ### People Table Surname Firstname Department site Department Table Name Site1 site2 site3 Site Table Sitekey Sitename ### - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: dealing with datetime
You might want to first find lastlength before running the update query. - Original Message - From: Siim Einfeldt aka Itpunk [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, June 08, 2001 2:25 AM Subject: dealing with datetime Hi, Just working here on a php-mysql project and came to a weird problem, See this: mysql_query(UPDATE trackvisits SET hitcount=hitcount+1,refreshtime=now(),lastlength=now()-arrivetime WHERE username='$visitor'); Especially notice the lastlength=now()-arrivetime . Both lastlength and arrivetime are datetime fields, so at least in theory this query should update the lastlength field and set it to the right value (=now()-arrivetime), but it actually just sets the lastlength value to -00-00 00:00:00 . The arrivetime does have just a bit smaller value than now(), at least some minutes. Any idea why this might not work? Thanks Siim EInfeldt Itpunk music Web www.itmusicweb.co.uk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Pound (£) Symbol and MySQL
is the column an int? if this is the case why not you strip the pound sign before inserting. with PHP you can always add the sign when retrieving. Hasan - Original Message - From: technical Support [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, June 08, 2001 1:52 AM Subject: Pound (£) Symbol and MySQL Hello All, When I insert data submitted via a web page into mySQL, the pound (£) symbol gets converted to something like 8916. I am using PHP and Apache on the Server side. Has anyone else encountered this strange problem? * * Visit http://www.computerstaff.net - Computer Jobs at all LEVELS * * - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: parse error in config.inc.php3 on line 1 in phpMyAdmin
Hmmm.. could be something as simple as a line break - but that is often hard to diagnose via email Please send me the relevant files (off-list) - I should be able to find the error quickly. --zak Barry C. Hawkins wrote: on 6/7/01 17:58, Zak Greant at [EMAIL PROTECTED] wrote: Barry C. Hawkins wrote: Esteemed colleagues, The php list is down, and I am sure someone knows what to do about this in this list. The issue is that I receive the error Parse error: parse error in config.inc.php3 on line 1 upon trying to access phpMyAdmin 2.1.0 from the web. MySQL 3.22.23 is on the same Linux box running Apache 1.36. Line 1 reads as follows: $cfgServers[1]['host'] = 'localhost'; // MySQL hostname I have tried 'localhost', '127.0.0.1', and 'hostname.com' (name provided by ISP who seems fairly clueless). What painfully obvious thing am I overlooking? The name of the server is not the issue. Chances are good that there is a syntax error in a line above the spot where config.inc.php3 is included. Try including a different file and seeing if you get the same error. --zak - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Including (they actually use require() ) a different file caused a timeout, but the syntax is so straightforward I am having trouble spotting the error. Take a look: *** Top of index.php3: ?php // Process config file to determine default server (if any) require(lib.inc.php3); ? *** Top of lib.inc.php3: ?php /* $Id: lib.inc.php3,v 1.62 2000/07/20 11:15:11 tobias Exp $ */ require(config.inc.php3); function show_table_navigation($pos_next, $pos_prev, $dt_result) { global $pos, $cfgMaxRows, $server, $db, $table, $sql_query, $sql_order, $sessionMaxRows, $SelectNumRows, $goto; global $strPos1, $strPrevious, $strShow, $strRowsFrom, $strEnd; ? *** Top of config.inc.php3: ?php /* $Id: config.inc.php3,v 1.28 2000/07/13 13:52:48 tobias Exp $ */ /* * phpMyAdmin Configuration File * All directives are explained in Documentation.html */ // The $cfgServers array starts with $cfgServers[1]. Do not use $cfgServers[0]. // You can disable a server config entry by setting host to ''. $cfgServers[1]['host'] = 'localhost'; // MySQL hostname etc. ... ? All the require() functions are at the tops of the pages, with almost nothing but comments in front of them. The only thing I find odd is that the ISP has both PHP3 and PHP4 active, and you get one or the other depending on the extension you use. However, this should still work. Any insight -- Barry C. Hawkins Systems Consultant, MCSE 4.0 [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: Rookie admin needs install help
Strange. I've never had any problems with the RPMs - Original Message - From: Duane Douglas [EMAIL PROTECTED] To: Rolf Hopkins [EMAIL PROTECTED] Cc: Patrick Malone [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, June 07, 2001 21:59 Subject: Re: Rookie admin needs install help At 02:10 PM 6/7/2001 +0800, Rolf Hopkins wrote: Unix rookie as well? 0 | 0 \__/ Off the top of my head, rpm -i file_name should do it. I usually use redhat's gui. man rpm will give you more details. evidently, there's something wrong with the rpm package for linux. the binary at mysql.com installs fine. also, the binary at sourceforge doesn't install properly either. if (duane.douglas) { coder = asp * cold fusion * xml * xsl * sql server * javascript } - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: libwrap problems (compiling) and config questions
On 07-Jun-01, Jason Bradley Nance said something totally profound about libwrap problems (compiling) and config questions that made me ponder... JBN Hello everyone. JBN I have hit a snag trying to compile mysql 3.23.38. After running JBN this configure command: [snip] JBN If I don't include the --with-libwrap config, then the build completes JBN just fine. I don't know if this will help, but I've successfully compiled MySQL .38 on Solaris 2.x machines using tcp-wrappers v7.6, using the configure option like this: --with-libwrap=/local/home/users/forager/tcpwrapper7.6/ I'm not sure what kind of wrappers RedHat comes with, so this may only be academic for you. -- Alan W. Rateliff, II: YourVillage.com Assistant Systems Administrator : 2700 Apalachee Pkwy [EMAIL PROTECTED] : Tallahassee, FL 32301 (850) 942-7021--- [EMAIL PROTECTED] http://support.yourvillage.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: installation problem
/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' Ciao Michela, unless you changed the 'user' table contents, you could easily connect to every db as root without providing any password. What's the command line you typed? Can you connect with 'mysql'? As root, type this: mysql mysql select * from user; and give a look at the host, user and password fields. Hope this helps! Ciao -Gabriele - Gabriele Bartolini - Computer Programmer U.O. Rete Civica - Comune di Prato Prato - Italia - Europa e-mail: [EMAIL PROTECTED] http://www.po-net.prato.it - A Supernova is the celestial equivalent of rm -rf /* with root permissions. - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Too many PIDs
On Thu, Jun 07, 2001 at 07:36:54PM -0400, R Talbot wrote: Jeremy So what your pointing out is I am seeing several threads generated by mysqld... Yes. But that does not answer as to why the rpm installation start with one thread?? Both installations which I compiled from source start with multiple threads.. ( diffrent machines Caldera 2.3) Hmm. Same version of mysql both rpm and source..?? What are your thoughts as to why is one broken and not the other. I think they should all start with the same # of threads. Are they using the same config file? Does SHOW PROCESSLIST on both show no active processes? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 13 days, processed 84,025,473 queries (71/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: php/mysql question
- Original Message - From: Adrian D'Costa [EMAIL PROTECTED] To: Mysql Mailing List [EMAIL PROTECTED] Sent: Friday, June 08, 2001 13:59 Subject: php/mysql question Hi, I am not sure whether this relates to this list or the (not working) php list. For simplicity: I have a form that displays data from a table. I will take just one field that displays a name input type=text name=name value=? echo $row[name];? This allow a user to update the changes when the submit button is pressed. On the next php file I do the following: $tname =urldecode($name); $tname1 = stripslashes($tname1); $updtStmt = update vusers set orgname='$tname1' where id=$tid; This works fine, but suppose in by table I have a name Adrian D'Costa This starts all the problems. I copy the sql statement from the php file and try: update vusers set name='Adrian D'Costa' where id=3; What you wrote here and what you wrote below are not the same update vusers set name=Adrian D'Costa where id=3; update vusers set name='Adrian D\'Costa' where id=3; will both work. Look up the section on escaping special characters in the mysql manual. ' I get the ' prompt that is waiting for me the close the '. If I try the same statement in mysql command line: update vusers set name=Adrian D'Costa where id=3; Query OK, 0 rows affected (0.01 sec) Rows matched: 1 Changed: 0 Warnings: 0 It works. How do I do the same in php? TIA Adrian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Pound (£) Symbol and MySQL
Hello All, When I insert data submitted via a web page into mySQL, the pound (£) symbol gets converted to something like 8916. I am using PHP and Apache on the Server side. Has anyone else encountered this strange problem? * * Visit http://www.computerstaff.net - Computer Jobs at all LEVELS * * - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: errcode 13
At 7:16 PM +0200 6/7/01, Sean O'Keeffe wrote: hi there, i've got a problem which someone might be able to help me with. i'm importing text files into a database in mysql using mysqlimport : /users/mysql/bin/mysqlimport -u * databasename *.txt however i'm getting the following error all the time: Can't get stat of '/datenbank/ensembl/ensembl/Xref.txt.table' (Errcode: 13), when using table: Xref can anyone throw some light on the problem? thanks, Sean. % perror 13 Error code 13: Permission denied Looks like the server can't access the file. If the server is running on the local host, try using mysqlimport --local and you probably won't have this problem. -- 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: encrypt wierdness
Ok, so you can obtain a random result (thought that was what random() was for), but still cannot understand how this could be usefull. I use encrypt to store password info in a database, but how do you compare the user entered password with the one in the database if the results vary the whole time? Please give me an application for this behaviour and I will be happy :-) Tonu Samuel wrote: On Thu, 7 Jun 2001, Richard Ellerbrock wrote: Looking at the encrypt function, it optionally takes a salt parameter. Using encrypt without specifying a salt yields random results: mysql select encrypt('qwerty'); +---+ | encrypt('qwerty') | +---+ | V/3Wzqmp93fts | +---+ 1 row in set (0.00 sec) mysql select encrypt('qwerty'); +---+ | encrypt('qwerty') | +---+ | W/55RyU1LdYN6 | +---+ 1 row in set (0.00 sec) How is this useful? Looking at the C crypt manpage, you MUST specify a salt: char *crypt(const char *key, const char *salt); So where does mysql get its salt from? Is it a random salt? This confused the hell our of me for around an hour! You should look MySQL manual not C crypt manpage ;). And yes, thisis random salt and makes life little bit more secure. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 an PHP 4.0 module with MySQL
./configure --with-mysql=/usr/bin --with-apxs --enable-track-vars Ciao, sorry but I just joined this mailing list, so I am not aware of any previous messages. /usr/bin ? Why in that directory? Can I please get to know how did you install MySQL? By RPM? Please try these 2 find commands? find / -name mysql.h(in my system it's under /usr/include/mysql/) find / -name libmysqlclient.*(in my system it's under /usr/lib/mysql/lib/) The latest RPM version comes with this prefix: /usr (so just put --with-mysql=/usr ) Let me know! Hope this helps! -Gabriele - Gabriele Bartolini - Computer Programmer U.O. Rete Civica - Comune di Prato Prato - Italia - Europa e-mail: [EMAIL PROTECTED] http://www.po-net.prato.it - A Supernova is the celestial equivalent of rm -rf /* with root permissions. - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: errcode 13
Sounds like you have a problem with the .frm file. Try checking the permission of xref.txt.frm or some part of that. Try making sure it is set to the proper owner with read and write permissions (usually mysql or mysqladmin is the owner). Best of luck Ken - Ken Menzel ICQ# 9325188 www.icarz.com [EMAIL PROTECTED] - Original Message - From: Sean O'Keeffe [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 07, 2001 1:16 PM Subject: errcode 13 hi there, i've got a problem which someone might be able to help me with. i'm importing text files into a database in mysql using mysqlimport : /users/mysql/bin/mysqlimport -u * databasename *.txt however i'm getting the following error all the time: Can't get stat of '/datenbank/ensembl/ensembl/Xref.txt.table' (Errcode: 13), when using table: Xref can anyone throw some light on the problem? thanks, Sean. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
.ISD files takes up too much space
hi, We have a mysql database called database1. It has a table called table1 this table has no records. But due to this table we are losing the 16 MB of space in our quota. I think its due to these files : Files Space 1)table1.frm 8 KB 2)table1.ISD 16,200 KB 3)table1.ISM120 KB Since there are no records in this table why does it accquire 16MB space due to ISD file. Can we minimise the space accquired by table1.ISD by any means? What is the significance of all the 3 files? This is not only the case with that particular table but there are others also that have no data but .ISD files are taking too many bytes. regards, Shailesh _ 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: MySQL too slow....
If you use Delphi or VB, VC, there are some API program that let you access MySQL direct. Not worry about ODBC. Sommai Fongnamthip At 01:00 7/6/2001 -0700, Van wrote: Muhammad Asif wrote: i have a table with 1 records in MS Access and MySQL with no index in either database. I query both tables from ColdFusion using ODBC datasources and Data from Access took 13sec to display while Date from MySQL took 23sec to come up MySQL seems to be half way slow should i use index etc comments??? Muhammad: ODBC is slow in MySQL. Make sure you're using a current MyODBC driver. If that doesn't help, don't know what to tell you. Many people use straight network queries which avoid this overhead. Keep in mind, ODBC was a standard M$ put in place because their desktop OS is ubiquitous. Oracle wouldn't need an ODBC layer if M$ didn't have a monopoly on the desktop. There would be better db communications interfaces, instead. Indexing fields you query often is a given. But, you know this, I'm sure... Regards, Van -- = Linux rocks!!! http://www.dedserius.com = - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: INSERT.
On Fri, Jun 08, 2001 at 12:43:16AM +0100, Jorge Oliveira wrote: Hi, I have two tables in my database: #TB1 ID_tb1 (auto-incremented) ID_tb2 name address #TB2 ID_tb2 (auto-incremented) method status I need to run a query that inserts values into #TB1 and #TB2, having #TB1.ID_tb2 equal to #TB2.ID_tb2. Since #TB2.ID_tb2 is auto incremented, I don't know how to get the same value inserted at #TB1.ID_tb2... Sounds like you need to insert into TB2 first. Then retrieve the value of ID_tb2. If you're using the perl DBI, I believe it's in $sth-{'mysql_insertid'} (see perldoc DBD::mysql). Finally, do your insert into TB1. -- Maurice Aubrey [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: Making SQL request from a Mac
Thanks Ansgar for your answer. What I missed concerning my question, is that I need to be able to get informations from MySQL and integrate them into a Mac App Quark XPress, using a specific plugin for Photo Composition, If I really understood what I was as to do. I wonder how phpMyAdmin would let me make the link into this environnement. Regards Pascal Miquet - Original Message - From: Ansgar Becker [EMAIL PROTECTED] To: Pascal MiQUET [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, June 07, 2001 6:00 PM Subject: Re: Making SQL request from a Mac I'd like to get informations from my MySQL Server on LiNUX, and the query must be made from a Mac (Not an Os X)! Is there a good solution ? If it's not possible, How can I get access to a PC With windows ? If you run windows, have a look at MySQL-front 1.18: http://www.mysqlfront.de on a mac I would prefer the browser-based phpMyAdmin: www.phpwizard.net Ansgar - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
How many Mysql PIDs ?
Please explain why I get multiple Daemon process when I start mysql.server..Such as 1075 pts/0S 0:00 sh /usr/local/mysql/bin/safe_mysqld --user=root --pid 1093 pts/0SN 0:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/ 1095 pts/0SN 0:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/ 1096 pts/0SN 0:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/ This occurs when starting as suggested through Link /etc/rc5.d/S99mysql or if I start from command line mysql.server start. If I kill one process all processes die.. Caldera 2.3 edesktop mysql 3.22.32 compiled from source. This does not occur on the Caldera 2.4 edesktop which the mysql 3.22.32 was installed from RPM.. The rpm would not install (dependencies) on 2.3 edesktop. So I compiled for 2.3 edesktop and RPM for 2.4 edesktop. Are the above processes normal ?? But not on the RPM install ??? Bob T. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
php/mysql question
Hi, I am not sure whether this relates to this list or the (not working) php list. For simplicity: I have a form that displays data from a table. I will take just one field that displays a name input type=text name=name value=? echo $row[name];? This allow a user to update the changes when the submit button is pressed. On the next php file I do the following: $tname =urldecode($name); $tname1 = stripslashes($tname1); $updtStmt = update vusers set orgname='$tname1' where id=$tid; This works fine, but suppose in by table I have a name Adrian D'Costa This starts all the problems. I copy the sql statement from the php file and try: update vusers set name='Adrian D'Costa' where id=3; ' I get the ' prompt that is waiting for me the close the '. If I try the same statement in mysql command line: update vusers set name=Adrian D'Costa where id=3; Query OK, 0 rows affected (0.01 sec) Rows matched: 1 Changed: 0 Warnings: 0 It works. How do I do the same in php? TIA Adrian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 an PHP 4.0 module with MySQL
The Linux kernel is 2.2.13 and has been installed from a Mandrake distribution. This is also the source of Apache, PHP 3 and MySQL. The distribution puts files in non-standard places so I am wondering if the solution to my problem is to find the right base directory to use in the --with-mysql=/path/ syntax, and/or the header files are in the wrong place. I have searched and tried many option but with no success. Bonjour, I have a Mandrake 7.1 (2.2.15 kernel)distribution too and get problems compiling php with gd and pdf because it seems that the linker searches header files in very particular directories. So I had to mkdir /usr/local/lib/gd (and same thing with pdf) putting in .so and .h files and compilation works fine. Could it be something similar in your case? Can't you try with-mysql=/usr/local/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: php/mysql question
Did you try the following code $updtStmt = update vusers set orgname=\$tname1\ where id=$tid; Should do the job. Regards P. Miquet - Original Message - From: Adrian D'Costa [EMAIL PROTECTED] To: Mysql Mailing List [EMAIL PROTECTED] Sent: Friday, June 08, 2001 7:59 AM Subject: php/mysql question Hi, I am not sure whether this relates to this list or the (not working) php list. For simplicity: I have a form that displays data from a table. I will take just one field that displays a name input type=text name=name value=? echo $row[name];? This allow a user to update the changes when the submit button is pressed. On the next php file I do the following: $tname =urldecode($name); $tname1 = stripslashes($tname1); $updtStmt = update vusers set orgname='$tname1' where id=$tid; This works fine, but suppose in by table I have a name Adrian D'Costa This starts all the problems. I copy the sql statement from the php file and try: update vusers set name='Adrian D'Costa' where id=3; ' I get the ' prompt that is waiting for me the close the '. If I try the same statement in mysql command line: update vusers set name=Adrian D'Costa where id=3; Query OK, 0 rows affected (0.01 sec) Rows matched: 1 Changed: 0 Warnings: 0 It works. How do I do the same in php? TIA Adrian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Slow Query... Good indexes...
On Thu, Jun 07, 2001 at 06:43:01PM +, [EMAIL PROTECTED] wrote: Dear Sirs, We have a very large database (badge_history has 4,000,000 rows) and the explain for our query looks like this: Like what? By using indexes for a query, the product of the row estimates from an explain statement are less than 200,000. The problem is that this query times out. There is only one table being scanned, the primary keys are being used on the rest of the tables. This is running on a machine with 2 8XX processors and almost a gigibyte of ram. Can anyone explain why this query is not working? How big is your key_buffer? Can we see the output of SHOW VARIABLES and SHOW STATUS? Have you tweaked your my.cnf file to make use of that RAM you've got? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 13 days, processed 82,076,999 queries (71/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problems installing on Solaris 2.6
On Thu, Jun 07, 2001 at 02:05:57PM -0500, Aaron Williamson wrote: I'm sure this has been beat into the ground here, but I've nowhere else to turn. Whenever you're sure that a question has been asked many times before, it's best to check the documentation and the mailing list archives. We're human, and will eventually tire of answering the same questions on a daily or weekly basis. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 13 days, processed 82,082,824 queries (71/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: How many Mysql PIDs ?
On Thu, Jun 07, 2001 at 08:23:03AM -0400, R Talbot wrote: Please explain why I get multiple Daemon process when I start mysql.server..Such as 1075 pts/0S 0:00 sh /usr/local/mysql/bin/safe_mysqld --user=root --pid 1093 pts/0SN 0:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/ 1095 pts/0SN 0:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/ 1096 pts/0SN 0:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/ This occurs when starting as suggested through Link /etc/rc5.d/S99mysql or if I start from command line mysql.server start. If I kill one process all processes die.. Caldera 2.3 edesktop mysql 3.22.32 compiled from source. Because that's how the Linux kernel implements threads. They're all part of the same process, actually. It just looks a bit funny. If you kill the right one, they'll all die. There is more on this topic in the mail archives, of course. It's a fairly common question. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 13 days, processed 82,085,883 queries (71/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Too many PIDs
Jeremy So what your pointing out is I am seeing several threads generated by mysqld... But that does not answer as to why the rpm installation start with one thread?? Both installations which I compiled from source start with multiple threads.. ( diffrent machines Caldera 2.3) Same version of mysql both rpm and source..?? What are your thoughts as to why is one broken and not the other. I think they should all start with the same # of threads. BOb T - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: .ISD files takes up too much space
On Fri, 8 Jun 2001, Udayavani Udayavani wrote: It has a table called table1 this table has no records. But due to this table we are losing the 16 MB of space in our quota. I think its due to these files : Can we minimise the space accquired by table1.ISD by any means? What is the significance of all the 3 files? Issue command OPTIMIZE TABLE table1. About files: ISD is datafile, ISM is indexfile and frm is place where table format is kept. Also I suggest you to use newer MyISAM table format instead of ISAM. You can do this with command ALTER TABLE table1 TYPE=MYISAM. This worksonly if MySQL is 3.23.x.MyISAM is faster and smaller in many circumstances. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Cant connect
Did you add user to your database with the SQL GRANT statement? Neil On Thu, 7 Jun 2001, Martin wrote: Warning: MySQL Connection Failed: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) in setup.php on line 92 I am sure that all information is correct as far DB name user name and password any ideals - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
synopsis of the problem (one line)
Description: I receive the following error when running scripts/mysql_install_db Error is :- Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables 010608 16:04:38 Warning: setrlimit couldn't increase number of open files to more than 200 010608 16:04:38 Warning: Changed limits: max_connections: 100 table_cache: 64 scripts/mysql_install_db[292]: 1949 Memory fault(coredump) Installation of grant tables failed! Examine the logs in ./data for more information. You can also try to start the mysqld daemon with: ./bin/mysqld --skip-grant You can use the command line tool ./bin/mysql to connect to the mysql database and look at the grant tables: Errror End: How do I resolve this error and what is this error all about? How-To-Repeat: scripts/mysql_install_db Fix: Submitter-Id: Saiful Originator: Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category: mysql Class: Release: mysql-3.23.38 (Official MySQL binary) Environment: System: HP-UX hpsgcdqg B.10.20 A 9000/755 2009932209 two-user license Some paths: /usr/bin/perl /usr/bin/make /usr/bin/cc Compilation info: CC='gcc' CFLAGS='-DHPUX -I/opt/dce/include -O3 -fpic' CXX='gcc' CXXFLAGS='-DHPUX -I/opt/dce/include -felide-constructors -fno-exceptions -fno-rtti -O3 ' LDFLAGS='' LIBC: -r-xr-xr-x 1 binbin1859584 Jul 16 1999 /lib/libc.1 -r--r--r-- 1 binbin2453308 Jul 16 1999 /lib/libc.a lrwxr-xr-x 1 root sys 15 May 13 10:57 /lib/libc.sl - /usr/lib/libc.1 -r-xr-xr-x 1 binbin1859584 Jul 16 1999 /usr/lib/libc.1 -r--r--r-- 1 binbin2453308 Jul 16 1999 /usr/lib/libc.a lrwxr-xr-x 1 root sys 15 May 13 10:57 /usr/lib/libc.sl - /usr/lib/libc.1 Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --with-server-suffix= --with-pthread --with-named-thread-libs=-ldce --disable-shared - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Error
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: I receive the following error when running scripts/mysql_install_db Error is :- Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables 010608 16:04:38 Warning: setrlimit couldn't increase number of open files to more than 200 010608 16:04:38 Warning: Changed limits: max_connections: 100 table_cache: 64 scripts/mysql_install_db[292]: 1949 Memory fault(coredump) Installation of grant tables failed! Examine the logs in ./data for more information. You can also try to start the mysqld daemon with: ./bin/mysqld --skip-grant You can use the command line tool ./bin/mysql to connect to the mysql database and look at the grant tables: Errror End: How do I resolve this error and what is this error all about? How-To-Repeat: scripts/mysql_install_db Fix: how to correct or work around the problem, if known (multiple lines) Submitter-Id: Saiful Originator: 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.38 (Official MySQL binary) Environment: machine, os, target, libraries (multiple lines) System: HP-UX hpsgcdqg B.10.20 A 9000/755 2009932209 two-user license Some paths: /usr/bin/perl /usr/bin/make /usr/bin/cc Compilation info: CC='gcc' CFLAGS='-DHPUX -I/opt/dce/include -O3 -fpic' CXX='gcc' CXXFLAGS='-DHPUX -I/opt/dce/include -felide-constructors -fno-exceptions -fno-rtti -O3 ' LDFLAGS='' LIBC: -r-xr-xr-x 1 binbin1859584 Jul 16 1999 /lib/libc.1 -r--r--r-- 1 binbin2453308 Jul 16 1999 /lib/libc.a lrwxr-xr-x 1 root sys 15 May 13 10:57 /lib/libc.sl - /usr/lib/libc.1 -r-xr-xr-x 1 binbin1859584 Jul 16 1999 /usr/lib/libc.1 -r--r--r-- 1 binbin2453308 Jul 16 1999 /usr/lib/libc.a lrwxr-xr-x 1 root sys 15 May 13 10:57 /usr/lib/libc.sl - /usr/lib/libc.1 Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --with-server-suffix= --with-pthread --with-named-thread-libs=-ldce --disable-shared - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Fail to compile on Solaris 8 Intel
Hi, I keep running into the following error trying to compile (running ./configure) mysql -3.23.38 on Solaris 8 x86: checking return type of sprintf... configure: error: can not run test program while cross compiling I'm using gcc 2.95.3. Has anyone compiled succesfully on sol8 x86 and is willing to give me some tips? Thanks up front. John - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: encrypt wierdness
Just use the password() function, which will return a nice 16-byte 1-way encrypted string. On Fri, 08 Jun 2001 00:04:18 -0700 Richard Ellerbrock [EMAIL PROTECTED] wrote: Ok, so you can obtain a random result (thought that was what random() was for), but still cannot understand how this could be usefull. I use encrypt to store password info in a database, but how do you compare the user entered password with the one in the database if the results vary the whole time? Please give me an application for this behaviour and I will be happy :-) Tonu Samuel wrote: On Thu, 7 Jun 2001, Richard Ellerbrock wrote: Looking at the encrypt function, it optionally takes a salt parameter. Using encrypt without specifying a salt yields random results: mysql select encrypt('qwerty'); +---+ | encrypt('qwerty') | +---+ | V/3Wzqmp93fts | +---+ 1 row in set (0.00 sec) mysql select encrypt('qwerty'); +---+ | encrypt('qwerty') | +---+ | W/55RyU1LdYN6 | +---+ 1 row in set (0.00 sec) How is this useful? Looking at the C crypt manpage, you MUST specify a salt: char *crypt(const char *key, const char *salt); So where does mysql get its salt from? Is it a random salt? This confused the hell our of me for around an hour! You should look MySQL manual not C crypt manpage ;). And yes, thisis random salt and makes life little bit more secure. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: download for intel solaris 7
Hi , I downloaded the mentioned tarball and when I ran configure on my machine, these were the messages which were shown on screen and it failed. --- #./configure loading cache ./config.cache checking host system type... i386-pc-solaris2.7 checking target system type... i386-pc-solaris2.7 checking build system type... i386-pc-solaris2.7 checking for a BSD compatible install... ./install-sh -c checking whether build environment is sane... yes checking whether make sets ${MAKE}... (cached) no checking for working aclocal... missing checking for working autoconf... found checking for working automake... missing checking for working autoheader... found checking for working makeinfo... missing checking whether to enable maintainer-specific portions of Makefiles... no checking whether build environment is sane... yes checking whether make sets ${MAKE}... (cached) no checking for gawk... (cached) nawk checking for gcc... (cached) gcc checking whether the C compiler (gcc ) works... yes checking whether the C compiler (gcc ) is a cross-compiler... no checking whether we are using GNU C... (cached) yes 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) : 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... yes 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... no checking for byacc... no checking for pdftex... no checking return type of sprintf... configure: error: can not run test program while cross compiling -- Can you help me .. Sujeet - Original Message - From: Van [EMAIL PROTECTED] To: Sujeet Kulkarni [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, June 07, 2001 2:04 PM Subject: Re: download for intel solaris 7 Sujeet Kulkarni wrote: Hi , Which source code should I download to install mysql on Intel Solaris 7. Thanks and regards Sujeet Sujeet: The same tarball that anyone rolling from source code uses: http://www.mysql.com/Downloads/MySQL-3.23/mysql-3.23.38.tar.gz Regards, Van -- = Linux rocks!!! http://www.dedserius.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: php/mysql question
On Fri, 8 Jun 2001, Gabriele Bartolini wrote: $tname =urldecode($name); $tname1 = stripslashes($tname1); $updtStmt = update vusers set orgname='$tname1' where id=$tid; It all depends on these 2 variables settings: magic_quotes_gpc= On magic_quotes_runtime= Off I grep'ed php.ini, here it is magic_quotes_gpc= On ; magic quotes for incoming GET/POST/Cookie data In this case, the urldecode is in *surplus*. You should remove it, and just use stripslashes. If I remove urldecode my name returns as 'Adrian+D\'Costa' which mysql balks at. If I remove the stripslashes my name is without the slash but mysql complains that it need another single quote ' to terminate the command. Regards Adrian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: php/mysql question
On Fri, 8 Jun 2001, Rolf Hopkins wrote: - Original Message - From: Adrian D'Costa [EMAIL PROTECTED] To: Mysql Mailing List [EMAIL PROTECTED] Sent: Friday, June 08, 2001 13:59 Subject: php/mysql question Hi, I am not sure whether this relates to this list or the (not working) php list. For simplicity: I have a form that displays data from a table. I will take just one field that displays a name input type=text name=name value=? echo $row[name];? This allow a user to update the changes when the submit button is pressed. On the next php file I do the following: $tname =urldecode($name); $tname1 = stripslashes($tname1); $updtStmt = update vusers set orgname='$tname1' where id=$tid; This works fine, but suppose in by table I have a name Adrian D'Costa This starts all the problems. I copy the sql statement from the php file and try: update vusers set name='Adrian D'Costa' where id=3; What you wrote here and what you wrote below are not the same True. update vusers set name=Adrian D'Costa where id=3; This is at the mysql prompt update vusers set name='Adrian D\'Costa' where id=3; and this is thru the script. Both work at the mysql prompt. But this will not work thru the script. Don't know why. will both work. Look up the section on escaping special characters in the mysql manual. Mysql Manual, hmmm I remember seeing that when I was with rh6.0 when I installed rh7.0 no manual. Give me a link to download it. TIA Adrian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: php/mysql question
- Original Message - From: Adrian D'Costa [EMAIL PROTECTED] To: Rolf Hopkins [EMAIL PROTECTED] Cc: Mysql Mailing List [EMAIL PROTECTED] Sent: Friday, June 08, 2001 17:47 Subject: Re: php/mysql question On Fri, 8 Jun 2001, Rolf Hopkins wrote: - Original Message - From: Adrian D'Costa [EMAIL PROTECTED] To: Mysql Mailing List [EMAIL PROTECTED] Sent: Friday, June 08, 2001 13:59 Subject: php/mysql question Hi, I am not sure whether this relates to this list or the (not working) php list. For simplicity: I have a form that displays data from a table. I will take just one field that displays a name input type=text name=name value=? echo $row[name];? This allow a user to update the changes when the submit button is pressed. On the next php file I do the following: $tname =urldecode($name); $tname1 = stripslashes($tname1); $updtStmt = update vusers set orgname='$tname1' where id=$tid; This works fine, but suppose in by table I have a name Adrian D'Costa This starts all the problems. I copy the sql statement from the php file and try: update vusers set name='Adrian D'Costa' where id=3; What you wrote here and what you wrote below are not the same True. update vusers set name=Adrian D'Costa where id=3; This is at the mysql prompt update vusers set name='Adrian D\'Costa' where id=3; and this is thru the script. Both work at the mysql prompt. But this will not work thru the script. Don't know why. Both should work through the script. What's the exact script and what's the error? will both work. Look up the section on escaping special characters in the mysql manual. Mysql Manual, hmmm I remember seeing that when I was with rh6.0 when I installed rh7.0 no manual. Give me a link to download it. www.mysql.com Don't tell me! You used RH's mysql RPM to install?!?! Ouuccc!!! The bane of many people's problems. If you ever find problems with mysql, get the RPMs from Mysql's website instead. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Speed
Thierry Coopman writes: At 16:10 +0300 07-06-2001, Sinisa Milivojevic wrote: Is there a way to tune MySQL for a lot of updates? most performance tunings consider selects not updates. Since the table is in memory, I guess HDD speed is not a factor (on a SunFire280R those are FCAL disks). My guess is that the Cache Memory on the processor speeds things up a lot (UltraSparc III has 8MB), but I'm not sure how 2 CPU's will perform. Also having splitting the updates over multiple treads seems to improve speed a little. -- Thierry Coopman - [EMAIL PROTECTED] My opinions are personal, and have really nothing or nothing to do with Keytrade! #RandomTag Hi! Yes, there is. If you have enough memory, you can use write-through HEAP tables to speed up things. -- Regards, For technical support contracts, go to https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Symbol not found error when installing mySQL on Solaris 2.5.1
I am trying to install mySQL on my Solaris 2.5.1 system. I have downloaded the latest binary and followed the instructions as best I understand them (not being very familiar with UNIX systems). I have not used the default directory (/usr/local/mysql). I have not found a solution for the following error message; ld.so.1: ./bin/mysqld: fatal: relocation error: symbol not found: fopen64: referenced in ./bin/mysqld This is generated when I run ./scripts/mysql_install_db. My searching has found many instances of others experiencing the same problem, but so far no fix! Any suggestions most gratefully received. RJS Robert J Sedman. Nimbus Technology Engineering Limited - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: configure error on Cobalt OS
Road Runner writes: i am unable to execute the configure command as part of the mysql installation. if i execute this statement using 'configure found in /usr/doc/libtool-1.3.5/demo/: [root /mysql-3.21.33c-pc-linux-gnu-i686]# /usr/doc/libtool-1.3.5/demo/configure --prefix=/usr/local/mysql here is the message from this execution: creating cache ./config.cache configure: error: can not find install-sh or install.sh in /usr/doc/libtool-1.3. 5/demo /usr/doc/libtool-1.3.5/demo/.. /usr/doc/libtool-1.3.5/demo/../.. if i use this other configure program found in /usr/share/libtool/libltdl/: [root /mysql-3.21.33c-pc-linux-gnu-i686]# /usr/share/libtool/libltdl/configure - -prefix=/usr/local/mysql then i get this message upon execution: loading cache ./config.cache configure: warning: *** The top-level configure must select either configure: warning: *** AC_LIBLTDL_INSTALLABLE or AC_LIBLTDL_CONVENIENCE. configure: error: *** Maybe you want to --enable-ltdl-install? all steps were completed successfully up until this statement. apparently it cannot find the the configuration file. this appears to be a path problem. the cobalt OS is a derivation of linux with some minor changes. thanks in advance ! Hi! Go to www.mysql.com and download latest MySQL source or binary for your OS. The above version is too old. -- Regardss, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem starting Mysql
Hello, I need some help to solve a problem starting mysql . I have installed all the files in a specific directory, and modify basedir, datadir et pid_file in the file : support-files/mysql.server. Running the daemon is OK but when i try to start mysql i have the following message : error 2002 : can't connect to local mysql server through socket '/tmp/mysql.sock'. What is wrong? Thank you for your help. Nicole Paleirac Technical Documentation - Soft ware Trainee Philips Semiconductors - BUTT Sophia - Mktg BLCE 505, route des Lucioles - 06560 Sophia Antipolis, FRANCE # (33)4.92.96.11.53 or 23.88 Fax: (+33) 4 92 96 11 02 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: Symbol not found error when installing mySQL on Solaris 2.5.1
Rob Sedman writes: I am trying to install mySQL on my Solaris 2.5.1 system. I have downloaded the latest binary and followed the instructions as best I understand them (not being very familiar with UNIX systems). I have not used the default directory (/usr/local/mysql). I have not found a solution for the following error message; ld.so.1: ./bin/mysqld: fatal: relocation error: symbol not found: fopen64: referenced in ./bin/mysqld This is generated when I run ./scripts/mysql_install_db. My searching has found many instances of others experiencing the same problem, but so far no fix! Any suggestions most gratefully received. RJS Robert J Sedman. Nimbus Technology Engineering Limited Hi! We do not build anymore 2.5 binaries, so you are probably using 2.6 or 2.7 binaries which will not work on 2.5. So, either build it from source, or upgrade your Solaris. -- Regards, For technical support contracts, go to https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: encrypt wierdness
Hi, So where does mysql get its salt from? Is it a random salt? This confused the hell our of me for around an hour! You should look MySQL manual not C crypt manpage ;). And yes, this is random salt and makes life little bit more secure. Ok, so you can obtain a random result (thought that was what random() was for), but still cannot understand how this could be usefull. If you take another look at the man page for the crypt() system call, you'll notice that it says that the first two characters represent the salt itself when mentioning what constitutes the returned value. So, given this, you can consistently re-encrypt a string to compare against the original by taking the first two characters and using them as the salt. The example below demonstrates this. mysql select encrypt('blahblah'); +-+ | encrypt('blahblah') | +-+ | IIRggo.uD7.Xk | +-+ 1 row in set (0.00 sec) mysql select encrypt('blahblah', 'II'); +---+ | encrypt('blahblah', 'II') | +---+ | IIRggo.uD7.Xk | +---+ 1 row in set (0.00 sec) I use encrypt to store password info in a database, but how do you compare the user entered password with the one in the database if the results vary the whole time? Please give me an application for this behaviour and I will be happy :-) In your case, when comparing the password the user has entered against what is in the database (an encrypted value) you first need to get the first two characters of what is already in the database for that user. Something along the lines of this should do the trick: SELECT * FROM users_table WHERE username = 'johndoe' AND passwd = ENCRYPT('secretpasswd', LEFT(passwd, 2)); Regards, Basil Hussain --- Internet Developer, Kodak Weddings 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: Fail to compile on Solaris 8 Intel
On 08-Jun-01, Super-User said something totally profound about Fail to compile on Solaris 8 Intel that made me ponder... S Hi, S S I keep running into the following error trying to compile (running S ./configure) mysql -3.23.38 on Solaris 8 x86: S S checking return type of sprintf... configure: error: can not run test S program while cross compiling S S I'm using gcc 2.95.3. S S Has anyone compiled succesfully on sol8 x86 and is willing to give me S some tips? S S Thanks up front. http://users.talstar.com/forager/MySQL-HOWTO.html The most important part is your PATH (not listed, but your C compiler and make should be in your path) and the variable settings before you execute ./configure. Works like a charm everytime on Solaris 2.4, 2.5.1, 2.6, 7, and 8/i86. :) -- Alan W. Rateliff, II: YourVillage.com Assistant Systems Administrator : 2700 Apalachee Pkwy [EMAIL PROTECTED] : Tallahassee, FL 32301 (850) 942-7021--- [EMAIL PROTECTED] http://support.yourvillage.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: synopsis of the problem (one line)
[EMAIL PROTECTED] writes: Description: I receive the following error when running scripts/mysql_install_db Error is :- Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables 010608 16:04:38 Warning: setrlimit couldn't increase number of open files to more than 200 010608 16:04:38 Warning: Changed limits: max_connections: 100 table_cache: 64 scripts/mysql_install_db[292]: 1949 Memory fault(coredump) Installation of grant tables failed! Examine the logs in ./data for more information. You can also try to start the mysqld daemon with: ./bin/mysqld --skip-grant You can use the command line tool ./bin/mysql to connect to the mysql database and look at the grant tables: Errror End: How do I resolve this error and what is this error all about? How-To-Repeat: scripts/mysql_install_db Fix: Submitter-Id:Saiful Originator: Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category:mysql Class: Release: mysql-3.23.38 (Official MySQL binary) Environment: System: HP-UX hpsgcdqg B.10.20 A 9000/755 2009932209 two-user license Some paths: /usr/bin/perl /usr/bin/make /usr/bin/cc Compilation info: CC='gcc' CFLAGS='-DHPUX -I/opt/dce/include -O3 -fpic' CXX='gcc' CXXFLAGS='-DHPUX -I/opt/dce/include -felide-constructors -fno-exceptions -fno-rtti -O3 ' LDFLAGS='' LIBC: -r-xr-xr-x 1 binbin1859584 Jul 16 1999 /lib/libc.1 -r--r--r-- 1 binbin2453308 Jul 16 1999 /lib/libc.a lrwxr-xr-x 1 root sys 15 May 13 10:57 /lib/libc.sl - /usr/lib/libc.1 -r-xr-xr-x 1 binbin1859584 Jul 16 1999 /usr/lib/libc.1 -r--r--r-- 1 binbin2453308 Jul 16 1999 /usr/lib/libc.a lrwxr-xr-x 1 root sys 15 May 13 10:57 /usr/lib/libc.sl - /usr/lib/libc.1 Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --with-server-suffix= --with-pthread --with-named-thread-libs=-ldce --disable-shared Hi! The above problem could be caused by two factors : - You do not have all patches applied to your HP-UX, as described in our manual - The user under whose uid is mysql daemon running has very low ulimit values. This can be allevieated at the boot time of HP-UX -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem starting Mysql
[EMAIL PROTECTED] writes: Hello, I need some help to solve a problem starting mysql . I have installed all the files in a specific directory, and modify basedir, datadir et pid_file in the file : support-files/mysql.server. Running the daemon is OK but when i try to start mysql i have the following message : error 2002 : can't connect to local mysql server through socket '/tmp/mysql.sock'. What is wrong? Thank you for your help. Nicole Paleirac Technical Documentation - Soft ware Trainee Philips Semiconductors - BUTT Sophia - Mktg BLCE 505, route des Lucioles - 06560 Sophia Antipolis, FRANCE # (33)4.92.96.11.53 or 23.88 Fax: (+33) 4 92 96 11 02 E:mail: [EMAIL PROTECTED] Hi! Please do not meddle with scripts directly. Instead, you should use /etc/my.cnf file to set options. e.g. to solve the above problem, make the following entries in /etc/my.cnf file: [client] socket=.. Instead of set a full path name to your socket file. BTW, what do you use MySQL for in Philips , Sofia ?? -- Regards, For technical support contracts, go to https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
binary distribution mysql.server hassles (minor)
Hey there. I got it working quickly but there were a few issues I wanted to mention about using a binary distribution. First off: The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable The binary distribution puts mysqld into bin/ not libexec/, so you'd think mysql.server from the binary dist would know that. :) Next, if you don't set basedir in mysql.server manually, this code: if test -z $basedir then basedir=/usr/local/mysql bindir=./bin else bindir=$basedir/bin fi will be unable to find my_print_defaults. I'd like to suggest the bindir=./bin be changed to bindir=/usr/local/mysql/bin, since if you are changing the basedir to /usr/local/mysql, then $basedir/bin is where it should be, more likely than a bin directory local to where the script is (/etc/init.d/ in this case). Finally, pid_file=$datadir/`@HOSTNAME@`.pid doesn't work, since I assume that is set during install of the source version. I replaced @HOSTNAME@ with /bin/hostname. I don't know if /bin/hostname is reliable enough to use as a default, but someplace in the binary dist install docs it could mention setting that in mysql.server as well as setting the basedir. Thanks, -Jonathan --- Jonathan Roy - [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: Slow Query... Good indexes...
Dear Sir, AFAICS your query does a FULL join of tables badge_history, badge, badgests, department, area AND an additional LEFT JOIN. Even with indexes the product may be too big for large tables. What says EXPLAIN SELECT? Thomas Spahni On Thu, 7 Jun 2001 [EMAIL PROTECTED] wrote: Dear Sirs, We have a very large database (badge_history has 4,000,000 rows) and the explain for our query looks like this: By using indexes for a query, the product of the row estimates from an explain statement are less than 200,000. The problem is that this query times out. There is only one table being scanned, the primary keys are being used on the rest of the tables. This is running on a machine with 2 8XX processors and almost a gigibyte of ram. Can anyone explain why this query is not working? The Query: SELECT DISTINCT badge_history.xact_date AS xact_date, badge_history.xact_time AS xact_time, badge_history.last_name AS last_name, badge_history.bid AS bid, badgests.cond_desc AS status, department.description AS department, badge_history.reader_desc AS reader_desc, area.description AS area, badge.expired_date AS expired, badge_history.xact_type AS xact_type, badge_history.tzcorr AS tzcorr FROM badge_history, badge, badgests, department, area LEFT JOIN smccm_user_vs_permitted_department ON badge_history.dept = smccm_user_vs_permitted_department.permitted_department WHERE smccm_user_vs_permitted_department.smccm_user = '1' AND badge_history.dept = department.id AND badge_history.area = area.id AND badge_history.status = badgests.id AND badge_history.source_host = area.source_host AND badge_history.bid = badge.bid This should not take 20 minutes to run, any ideas on how to speed it up? The indexes are about optimal (I think) Mysql version: 3.23.36 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Pound (£) Symbol and MySQL
Hello All, I have tried the settings as suggested in this FORUM like using htmlentities etc... however, my pound sign in the database is displayed as: ú Any more tips help etc... -Original Message- From: technical Support [mailto:[EMAIL PROTECTED]] Sent: 07 June 2001 21:53 To: [EMAIL PROTECTED] Subject: Pound (£) Symbol and MySQL Hello All, When I insert data submitted via a web page into mySQL, the pound (£) symbol gets converted to something like 8916. I am using PHP and Apache on the Server side. Has anyone else encountered this strange problem? * * Visit http://www.computerstaff.net - Computer Jobs at all LEVELS * * - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Speed of query
Hello all, does anyone have any feedback whether there is any difference in the efficiency of the following query on a fairly large dataset 1. select * from tbl 2 select count(*) from tbl 3. select field1,field2,field3 from tbl TIA Chris Penning CSM Systems Inc. Edmonton, AB T5J 3S9, Canada - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Slow Query... Good indexes...
The explain result (product of rows) is less than 200,000. I'll include it here, but I don't know if it's readable or not: ++++---+-+--+---+---+ | table | type | possible_keys || key | key_len | ref | rows | Extra | ++++---+-+--+---+---+ | badgests | ALL| PRIMARY || NULL |NULL | NULL | 4 | Using temporary | | badge_history | ref| ixStatus,ixArea,ixDept,ixBid,ixSeveral || ixSeveral | 4 | badgests.id | 41946 | | | badge | eq_ref | PRIMARY,ixBid || ixBid | 18 | badge_history.bid | 1 | | | department | eq_ref | PRIMARY || PRIMARY | 4 | badge_history.dept | 1 | | | area | eq_ref | PRIMARY || PRIMARY | 20 | badge_history.area,badge_history.source_host | 1 | where |used| | smccm_user_vs_permitted_department | ref| PRIMARY || PRIMARY | 4 | badge_history.dept | 1 | where used; Using index; Distinct | ++++---+-+--+---+---+ 6 rows in set (0.05 sec) -- Original Message -- From: Thomas Spahni [EMAIL PROTECTED] Date: Fri, 8 Jun 2001 16:36:18 +0200 (CEST) Dear Sir, AFAICS your query does a FULL join of tables badge_history, badge, badgests, department, area AND an additional LEFT JOIN. Even with indexes the product may be too big for large tables. What says EXPLAIN SELECT? Thomas Spahni On Thu, 7 Jun 2001 [EMAIL PROTECTED] wrote: Dear Sirs, We have a very large database (badge_history has 4,000,000 rows) and the explain for our query looks like this: By using indexes for a query, the product of the row estimates from an explain statement are less than 200,000. The problem is that this query times out. There is only one table being scanned, the primary keys are being used on the rest of the tables. This is running on a machine with 2 8XX processors and almost a gigibyte of ram. Can anyone explain why this query is not working? The Query: SELECT DISTINCT badge_history.xact_date AS xact_date, badge_history.xact_time AS xact_time, badge_history.last_name AS last_name, badge_history.bid AS bid, badgests.cond_desc AS status, department.description AS department, badge_history.reader_desc AS reader_desc, area.description AS area, badge.expired_date AS expired, badge_history.xact_type AS xact_type, badge_history.tzcorr AS tzcorr FROM badge_history, badge, badgests, department, area LEFT JOIN smccm_user_vs_permitted_department ON badge_history.dept = smccm_user_vs_permitted_department.permitted_department WHERE smccm_user_vs_permitted_department.smccm_user = '1' AND badge_history.dept = department.id AND badge_history.area = area.id AND badge_history.status = badgests.id AND badge_history.source_host = area.source_host AND badge_history.bid = badge.bid This should not take 20 minutes to run, any ideas on how to speed it up? The indexes are about optimal (I think) Mysql version: 3.23.36 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
SLOW query - WHY???
Hi, I DESPERATELY need help! This motor does't seem to have a gas pedal.. It takes a full 4+ seconds to run! Only ~500 rows in table. I chopped a lot of group by ordering, etc off. SELECT d.DigIDsKey,d.Title,d.ValueEnglish,d.URL FROM DigIDs AS d WHERE d.DigIDsKey IN(22, 27, 84, 164, 272, 289, 533) I have indexed DigIDsKey Setup: MySQL 3.23.33 Paul - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: What am I missing?
Perl is already installed installed on the server. Mike -Original Message- From: Rolf Hopkins [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 07, 2001 7:17 PM To: Mike Jimenez; Mysql Subject: Re: What am I missing? You don't need MySQL-bench-3.23.38-1.i386.rpm to run mysql but if you still want to use it, you need to install perl first. - Original Message - From: Mike Jimenez [EMAIL PROTECTED] To: Mysql [EMAIL PROTECTED] Sent: Friday, June 08, 2001 1:35 Subject: What am I missing? rpm -i MySQL-3.23.38-1.i386.rpm MySQL-client-3.23.38-1.i386.rpm MySQL-bench-3.23.38-1.i386.rpm error: failed dependencies: MySQL-DBI-perl-bin is needed by MySQL-bench-3.23.38-1 Thanks Mike - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: User variables
Hi, Are there any issues with user variables ( SET @variable:=) overflowing memory on the server? At any one time I wouldn't need most of them, but I don't see any way of removing them once set. Might this be an issue, or is there some garbage collection and/or memory limit on the variables. Should I clear them after using them by setting them to NULL? No, you don't need to clean up your variables after use. To quote from the manual: All variables for a thread are automatically freed when the thread exits. So, when you close the connection to the MySQL server, your variables are unset automatically - but not for other connections, just your own (bear in mind that user variables set in one thread are not available server-wide). As for memory limits on variables, this may be one question for the developers to answer, is it mentions nothing about limits in the manual. Regards, Basil Hussain --- Internet Developer, Kodak Weddings 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
Mysqld crashes immediately
I have installed mysql-3.23.38-hp-hpux10.20-hppa1.1 on an hpux10.20 Unix machine. However, I cannot get the mysqld executable to run. I get an error that looks like this: # ./bin/safe_mysqld --skip-grant --user=mysql Starting mysqld daemon with databases from /usr/local/mysql/data ./bin/safe_mysqld[238]: 14423 Memory fault 010608 11:55:52 mysqld ended None of the other executables in the bin/ directory will run because I either get a mysql.sock error or an error telling me to start the mysqld daemon. Please reply to [EMAIL PROTECTED] if you can help 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
Problem starting mysql server
I donwloaded the mysql 3.23.38 binary for AIX 4.3.3 and installed an IBM rs6000 workstation. When I try to start mysql server with safe_mysqld, I got following error message: Start MySQL server deamon exec(): 0509-036 Cannot load program /usr/local/mysql/bin/my_print_defaults because of the following errors: 0509-150 Dependent module /usr/local/lib/libz.a(shr.o) could not be loaded. 0509-152 Member shr.o is not found in archive 010608 10:54:45 mysqld ended The zlib is version 1.1.3. Can anyone tell me what wrong here? what is this shr.o? Thanks. Weining Zhao - TNRCC 512-239-2593 [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: php/mysql question
On Fri, 8 Jun 2001, Rolf Hopkins wrote: What you wrote here and what you wrote below are not the same update vusers set name=Adrian D'Costa where id=3; update vusers set name='Adrian D\'Costa' where id=3; will both work. Look up the section on escaping special characters in the mysql manual. If you want to safeguard yourself in future PHP scripts use te PHP htmlentities() command with the special flag to translate quotes. The outcome of this is effectively what is described above. Neil - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Quota?
Hi, is there a way I can assign quota to database users, so they want be able to use all of my disk size? Ideally I would like to assign quota to each user individually. Is it possible at all? Rafal -- _/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] - _/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl _/_/_/_/ _/_/_/ul. Uphagena 2, 80-237 Gdansk, tel/fax. (58) 5215625 _/ _/ _/ ==* http://szukaj.wp.pl *==-- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Pound (£) Symbol and MySQL
On Fri, 8 Jun 2001, technical Support wrote: Hello All, I have tried the settings as suggested in this FORUM like using htmlentities etc... however, my pound sign in the database is displayed as: ú Are you seeing this stuff from the standard Windows telnet client? If so get yourself a better terminal emulator such as the free version of QVT/Term or the cygwin stuff. The standard Windows telnet perform pathetically with ISO 8859 rendition. Any more tips help etc... -Original Message- From: technical Support [mailto:[EMAIL PROTECTED]] Sent: 07 June 2001 21:53 To: [EMAIL PROTECTED] Subject: Pound (£) Symbol and MySQL Hello All, When I insert data submitted via a web page into mySQL, the pound (£) symbol gets converted to something like 8916. I am using PHP and Apache on the Server side. Has anyone else encountered this strange problem? * * Visit http://www.computerstaff.net - Computer Jobs at all LEVELS * * - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: What am I missing?
Perhaps you need the MySQL-DBI-perl-bin RPM (?). Is there such a thing? On Fri, 8 Jun 2001, Mike Jimenez wrote: Perl is already installed installed on the server. Mike You don't need MySQL-bench-3.23.38-1.i386.rpm to run mysql but if you still want to use it, you need to install perl first. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL database files access
Can anyone describe me the architecture of mysql operation ?? I know it starts with a script, that manages the child process, and if child dies, it's replaced by a new one. I have several mysqld processes working simultaneously. How do they comunicate with each other ? Do they read concurrently from database files (only) ? Can I start two mysql instances (with several processes each) working on the same database files ? How is file access managed ? thanks Nelson Gomes - Dep. Internet a|cj Grupo Abril/Controljornal/Edipresse *: 21 415 21 60 *: [EMAIL PROTECTED]
RE: What am I missing?
Yeah I tried to install that to but it would not compile. It wanted lib files that were not there? It seems as though the RPM version does not install them? But on another server I have that has MYSQL compiled from source the lib files were present? These are the files I'm talking about /usr/local/lib/mysql/lib libdbug.a libmyisam.a libmysqlclient.la libmysqlclient.so.10.0.0 libnisam.a libheap.a libmyisammrg.alibmysqlclient.so libmystrings.a libmerge.alibmysqlclient.a libmysqlclient.so.10 libmysys.a And on the server That was installed from RPM does not have these files? What do I do how would I get them on to my new server? -Original Message- From: Larry Hotchkiss [mailto:[EMAIL PROTECTED]] Sent: Friday, June 08, 2001 9:38 AM To: 'Mike Jimenez' Subject: RE: What am I missing? While perl is required, I believe MySQL-DBI-perl-bin pointed to by your error is the dabase interface portions of perl, which may not be installed on your system. On Friday, June 08, 2001 11:31 AM, Mike Jimenez [SMTP:[EMAIL PROTECTED]] wrote: Perl is already installed installed on the server. Mike -Original Message- From: Rolf Hopkins [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 07, 2001 7:17 PM To: Mike Jimenez; Mysql Subject: Re: What am I missing? You don't need MySQL-bench-3.23.38-1.i386.rpm to run mysql but if you still want to use it, you need to install perl first. - Original Message - From: Mike Jimenez [EMAIL PROTECTED] To: Mysql [EMAIL PROTECTED] Sent: Friday, June 08, 2001 1:35 Subject: What am I missing? rpm -i MySQL-3.23.38-1.i386.rpm MySQL-client-3.23.38-1.i386.rpm MySQL-bench-3.23.38-1.i386.rpm error: failed dependencies: MySQL-DBI-perl-bin is needed by MySQL-bench-3.23.38-1 Thanks Mike - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Argg.. help me get off the SQL list, please!!!
Ok, I've emailed [EMAIL PROTECTED] three times, and I'm still not off the SQL database list. What's going on? Am I doing something wrong? How do I get off this list? If there's a moderator out there, could (s)he please take me off the list? 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
Help Please!
This is what it says now when I run mysqld_multi start 2: perl: warning: Setting locale failed. perl: warning: Please check that your locale settings: LANGUAGE = (unset), LC_ALL = (unset), LANG = en_US are supported and installed on your system. perl: warning: Falling back to the standard locale (C). Nothing is seen in the log file. ...Rohit TransLogic Systems 5th Floor, Amogh Plaza, Greenlands, Hyderabad, AP - 500 016, INDIA Ph: 91.40.3401795, Fax: 91.40.3407943 www.translogicsys.com
connect MYSQL via java
Hi all , I got a critical situation to solve and I wonder if you can help me on that. I promise to be very specific on my questions once I know what need to be done, except that instead of Oracle I got to connect mySQL via java. The first questions are: 1) Do I need to download a driver, and include it to my class path ??? 2) Wich driver is the best ??? Where can I get it??? Many thanks Siomara _ 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
query in different DB
Can I do query like this: Select Database1.table1.field1, database2.table1.field1, database2.table2.field2 FROM database1.table1, database2.table1, database2.table2 François Boucher [EMAIL PROTECTED]
ISAMCHK error
I can't believe MySQL is behaviouring that way and giving that kind of errors. I've tried MySQL versions 3.23.33 and 3.22.27 both in Solaris and RedHat linux, all with the same results. Can anyone please help? Thx in advance, Joan The tests consists in: * creating a table, * to insert 2 registers, * to erase 1 register, * and... in this point of it annoys everything. TO PASS a ISAMCHK with option - r (to repair). Once I throw this, the table is in a error state. When I passed a SELECT count(*) gives 1 registry us, and if we happened a SELECT * says that this vacia to us. (To see results down) TEST: DROP TABLE prueba; CREATE TABLE prueba (id bigint not null,nom varchar(100)); INSERT INTO prueba VALUES (1,'ONE'); INSERT INTO prueba VALUES (2,'TWO'); DELETE FROM prueba WHERE id2; select * from prueba; select count(*) from prueba; Exit MySQL and run : isamchk -r /D3/mysql.tables/joan/prueba Mysql: select * from prueba; select count(*) from prueba; [root]# mysql test mysql DROP TABLE prueba; Query OK, 0 rows affected (0.03 sec) mysql CREATE TABLE prueba (id bigint not null,nom varchar(100)); Query OK, 0 rows affected (0.03 sec) mysql INSERT INTO prueba VALUES (1,'ONE'); Query OK, 1 row affected (0.00 sec) mysql INSERT INTO prueba VALUES (2,'TWO'); Query OK, 1 row affected (0.00 sec) mysql DELETE FROM prueba WHERE id2; Query OK, 1 row affected (0.01 sec) mysql select * from prueba; ++--+ | id | nom | ++--+ | 2 | TWO | ++--+ 1 row in set (0.00 sec) mysql select count(*) from prueba; +--+ | count(*) | +--+ |1 | +--+ 1 row in set (0.00 sec) [root]# isamchk -r prueba - recovering ISAM-table 'prueba.ISM' Data records: 1 ANY RECORDS IN DATABASE, BUT count(*) is 1. [root]# mysql test mysql select * from prueba; Empty set (0.00 sec) mysql select count(*) from prueba; +--+ | count(*) | +--+ |1 | +--+ 1 row in set (0.00 sec) 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
Ideas?: ERROR 1030: Got error 127 from table handler
Is there a common cause to the following problem?: mysql select parent_referral from referral; ERROR 1030: Got error 127 from table handler I can run a describe on the table and I can sucessfully run: select count(*) from referral but if I try to actually query the data in the table I get the above problem. Our system is running 3.22.23b and we're only having the problem with the largest table in our database (it's got about 75k records in it with 13 fields total file size of the ISD is about 65 megs) -Chris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: SLOW query - WHY???
Did you try EXPLAIN query? That might give you some hints as to why it is taking so long. That might point you in the right direction. j- k- On Friday 08 June 2001 08:28, Paul Wilkinson wrote: Hi, I DESPERATELY need help! This motor does't seem to have a gas pedal.. It takes a full 4+ seconds to run! Only ~500 rows in table. I chopped a lot of group by ordering, etc off. SELECT d.DigIDsKey,d.Title,d.ValueEnglish,d.URL FROM DigIDs AS d WHERE d.DigIDsKey IN(22, 27, 84, 164, 272, 289, 533) I have indexed DigIDsKey Setup: MySQL 3.23.33 Paul -- Joshua Kugler, Information Services Director Associated Students of the University of Alaska Fairbanks [EMAIL PROTECTED], 907-474-7601 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Search returns -1
I am trying to use a fulltext search to searh a database of varchars and text objects on version 3.23.23. my query is select id, price, manufacturer, shortdesc, partnumber, MATCH (shortdesc) AGAINST ('digital') AS score from product LIMIT 0,15 . all of my fields return corret values, but score is -1. What am I doing wrong... THank you, -- Edward Riede [EMAIL PROTECTED] Embedded Systems Software Engineer Western Reserve Controls, Inc. 1485 Exeter Road, Akron OH 44306 phone: 330-733-6662 fax: 330-733-6663 email: [EMAIL PROTECTED] www: http://www.wrcakron.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
Password encryption
Hello all, I have some questions about password encryption. I want to make some sort of encryption method that disables a human to read the password, but does allow my (php) script to convert the encoded password to a human-readable password, the member originally entered and the member enters in the form (if he or she has the password right) . In other words, I want a string to be encrypted and decrypted, if it's possible in the query. An example: insert into table values (encrypt(secret)); select decrypt(passfield) as pass from table; and here, pass will contain the value of secret. Thanks in advance, Leon Mergen [EMAIL PROTECTED] BlazeBox, Inc. ICQ: 55677353
RE: What am I missing?
Yes Im running RegHat 6.2 I downloaded the RPM's off the mysql website. Mike -Original Message- From: Larry Hotchkiss [mailto:[EMAIL PROTECTED]] Sent: Friday, June 08, 2001 11:22 AM To: 'Mike Jimenez' Subject: RE: What am I missing? what OS ya running? RH? Are the RPM's ya used from the OS supplier or mysql? On Friday, June 08, 2001 12:58 PM, Mike Jimenez [SMTP:[EMAIL PROTECTED]] wrote: Yeah I tried to install that to but it would not compile. It wanted lib files that were not there? It seems as though the RPM version does not install them? But on another server I have that has MYSQL compiled from source the lib files were present? These are the files I'm talking about /usr/local/lib/mysql/lib libdbug.a libmyisam.a libmysqlclient.la libmysqlclient.so.10.0.0 libnisam.a libheap.a libmyisammrg.alibmysqlclient.so libmystrings.a libmerge.alibmysqlclient.a libmysqlclient.so.10 libmysys.a And on the server That was installed from RPM does not have these files? What do I do how would I get them on to my new server? -Original Message- From: Larry Hotchkiss [mailto:[EMAIL PROTECTED]] Sent: Friday, June 08, 2001 9:38 AM To: 'Mike Jimenez' Subject: RE: What am I missing? While perl is required, I believe MySQL-DBI-perl-bin pointed to by your error is the dabase interface portions of perl, which may not be installed on your system. On Friday, June 08, 2001 11:31 AM, Mike Jimenez [SMTP:[EMAIL PROTECTED]] wrote: Perl is already installed installed on the server. Mike -Original Message- From: Rolf Hopkins [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 07, 2001 7:17 PM To: Mike Jimenez; Mysql Subject: Re: What am I missing? You don't need MySQL-bench-3.23.38-1.i386.rpm to run mysql but if you still want to use it, you need to install perl first. - Original Message - From: Mike Jimenez [EMAIL PROTECTED] To: Mysql [EMAIL PROTECTED] Sent: Friday, June 08, 2001 1:35 Subject: What am I missing? rpm -i MySQL-3.23.38-1.i386.rpm MySQL-client-3.23.38-1.i386.rpm MySQL-bench-3.23.38-1.i386.rpm error: failed dependencies: MySQL-DBI-perl-bin is needed by MySQL-bench-3.23.38-1 Thanks Mike - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: connect MYSQL via java
I got it working Thanks anyway Siomara From: Siomara Pantarotto [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: connect MYSQL via java Date: Fri, 08 Jun 2001 14:31:26 -0300 Hi all , I got a critical situation to solve and I wonder if you can help me on that. I promise to be very specific on my questions once I know what need to be done, except that instead of Oracle I got to connect mySQL via java. The first questions are: 1) Do I need to download a driver, and include it to my class path ??? 2) Wich driver is the best ??? Where can I get it??? Many thanks Siomara _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
install problems
Hi, Mysql guys: I have problem to install mysql into my DEC-AlphaServer 800 which run DEC-osf4.0d. I downloaded mysql source file: mysql-3.22.30-dec-osf4.0f- alphaev6.tar.gz, after run #./configure, then #make, it show the problems, although I try command #make install, the error message is showed below: + rm -f ./thr_mutex.c + /bin/ln -s ../libmysql/thr_mutex.c ./thr_mutex.c + rm -f ./typelib.c + /bin/ln -s ../libmysql/typelib.c ./typelib.c + rm -f ./violite.c + /bin/ln -s ../libmysql/violite.c ./violite.c echo timestamp linked_libmysql_r_sources make all-recursive No suffix list. Making all in include No suffix list. Make: % rule can only use a single ':'. Stop. *** Exit 1 Stop. *** Exit 1 Stop. root 01:52:13 mysql-3.23.38 make install No suffix list. Making install in include No suffix list. Make: % rule can only use a single ':'. Stop. *** Exit 1 Stop. Could you tell me what is the problem? is my DEC-osf4.0D can not use mysql for DEC-osf4.0F ? How can I install mysql? I also try tarball version of Mysql, mysql-3.22.25-beta-dec-osf4.0f- alphaev6, after run the command #scripts/mysql_install_db, I get error message: Unresolved symbol in ./bin/mysqld: pthread_rwlock_rdlock Unresolved symbol in ./bin/mysqld: pthread_rwlock_unlock pthread_rwlock_init pthread_rwlock_destroy pthread_rwlock_wrlock I appreciate for your help. Jim Yang - This message was sent using RICS Webmail http://webmail.bwh.harvard.edu - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Update phone inner join tmpphone....
I tried this query: Update phone inner join tmpphone on phone.empno = tmpphone.empno set phone.lname = tmpphone.lname, phone.fname = tmpphone.fname and it didn't work. This works in MSAccess. Is this syntax (or something like it) supported by 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
Exporting Access database to Mysql database
Hi all, I got my java connection working but now I need to export a MS Access database to mysql database. Does anyone knows the fastest way to do it My main question is: Is there a way to export the table structures and data at same time? Or do I have to create the tables structures and just export the data. I noticed some diffreneces in the datatypes when comparing mySQL to Oracle and I bet there must be some differences related to MSAccess too. Thanks Siomara _ 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: Password encryption
Look in the manual about the ENCODE/DECODE functions. j- k- On Friday 08 June 2001 10:28, you wrote: Hello all, I have some questions about password encryption. I want to make some sort of encryption method that disables a human to read the password, but does allow my (php) script to convert the encoded password to a human-readable password, the member originally entered and the member enters in the form (if he or she has the password right) . In other words, I want a string to be encrypted and decrypted, if it's possible in the query. An example: insert into table values (encrypt(secret)); select decrypt(passfield) as pass from table; and here, pass will contain the value of secret. -- Joshua Kugler, Information Services Director Associated Students of the University of Alaska Fairbanks [EMAIL PROTECTED], 907-474-7601 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: ISAMCHK error
Never run isamchk with the server running. Joan Vidal wrote: I can't believe MySQL is behaviouring that way and giving that kind of errors. I've tried MySQL versions 3.23.33 and 3.22.27 both in Solaris and RedHat linux, all with the same results. Can anyone please help? Thx in advance, Joan The tests consists in: * creating a table, * to insert 2 registers, * to erase 1 register, * and... in this point of it annoys everything. TO PASS a ISAMCHK with option - r (to repair). Once I throw this, the table is in a error state. When I passed a SELECT count(*) gives 1 registry us, and if we happened a SELECT * says that this vacia to us. (To see results down) TEST: DROP TABLE prueba; CREATE TABLE prueba (id bigint not null,nom varchar(100)); INSERT INTO prueba VALUES (1,'ONE'); INSERT INTO prueba VALUES (2,'TWO'); DELETE FROM prueba WHERE id2; select * from prueba; select count(*) from prueba; Exit MySQL and run : isamchk -r /D3/mysql.tables/joan/prueba Mysql: select * from prueba; select count(*) from prueba; [root]# mysql test mysql DROP TABLE prueba; Query OK, 0 rows affected (0.03 sec) mysql CREATE TABLE prueba (id bigint not null,nom varchar(100)); Query OK, 0 rows affected (0.03 sec) mysql INSERT INTO prueba VALUES (1,'ONE'); Query OK, 1 row affected (0.00 sec) mysql INSERT INTO prueba VALUES (2,'TWO'); Query OK, 1 row affected (0.00 sec) mysql DELETE FROM prueba WHERE id2; Query OK, 1 row affected (0.01 sec) mysql select * from prueba; ++--+ | id | nom | ++--+ | 2 | TWO | ++--+ 1 row in set (0.00 sec) mysql select count(*) from prueba; +--+ | count(*) | +--+ |1 | +--+ 1 row in set (0.00 sec) [root]# isamchk -r prueba - recovering ISAM-table 'prueba.ISM' Data records: 1 ANY RECORDS IN DATABASE, BUT count(*) is 1. [root]# mysql test mysql select * from prueba; Empty set (0.00 sec) mysql select count(*) from prueba; +--+ | count(*) | +--+ |1 | +--+ 1 row in set (0.00 sec) 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 -- Gerald L. Clark [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: JOIN to the same table multiple times
You really shouldn't be using SELECT *. Try SELECT S1.sitename AS FirstSiteName, S2.sitename AS SecondSiteName, etc etc etc. Ok, I've answered my own question but now have another. How do I reference the sitename for the 3 sites? sitename returns the last sitename for all 3 I tried S1.sitename etc. but it doesn't work. $query = SELECT * FROM department LEFT JOIN sites S1 ON deptsite1=S1.sitekey LEFT JOIN sites S2 ON deptsite2=S2.sitekey ORDER BY $order $dir; ... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How I can run a script in MySQLManager
Hi, All. I have a problem to run a script in mysqlmanager. I have file generated with mysqldump with the data definition of my database, but the error show is (You have an error in your SQL syntax near ';). Has anyone encountered this problem . Thanks. Mario Espinoza Ll. Consultares STI, S.C. [EMAIL PROTECTED] Av. Guadalupe # 618, Col. Chapalita. Guadalajara, Jal. México. +52 3121-0411 Ext. 213 +52 3121-0548 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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.38: libmysqlclient.so.9 cannot load shared...
I've installed mysql 3.23.38 from source on redhat 7.0 (apache 1.3.39 and PHP 4.0.5 also installed from source). The PHP and the apache are running fine, and I can view database tables using MysqlAdmin from a web browser, but if I run mysql from the command line, I get the following error mysql: error while loading shared libraries: libmysqlclient.so.9: cannot open shared object file: no such file or directory Indeed, if I do a locate, I see that there is a libmysqlclient.so.10 but not a 9. also, If I do a ps -ax I can see the mysql processes running. Any idea how to fix this? If not, any idea on a better place to look for the answer? Thanks scott
RE: Ideas?: ERROR 1030: Got error 127 from table handler
Is there a common cause to the following problem?: mysql select parent_referral from referral; ERROR 1030: Got error 127 from table handler chris@mirage:~$ perror 127 Error code 127: Unknown error: 127 127 = Record-file is crashed chris@mirage:~$ Our system is running 3.22.23b and we're only having the problem with the largest table in our database (it's got about 75k records in it with 13 fields total file size of the ISD is about 65 megs) Since you're using 3.22, you can use isamchk to repair the table. Check http://www.mysql.com/doc/R/e/Repair.html, most of the information there is the same except you can't use REPAIR TABLE with 3.22, and you have to replace myisamchk with isamchk. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: query in different DB
Try it =P (just don't forget the WHERE clause) If you want to make your query easier to write, use aliases: SELECT d1t1.field1, d2t1.field1, d2t2.field2 FROM database1.table1 AS d1t1, database2.table1 AS d2t1, database2.table2 AS d2t2 WHERE d1t1.id = d2t1.id AND d2t1.id = d2t2.id Can I do query like this: Select Database1.table1.field1, database2.table1.field1, database2.table2.field2 FROM database1.table1, database2.table1, database2.table2 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Speed of query
Hello all, does anyone have any feedback whether there is any difference in the efficiency of the following query on a fairly large dataset 1. select * from tbl This will be the slowest. 2 select count(*) from tbl This will be very fast since MySQL is optimized for it (the number is updated when a row is inserted, so the query doesn't actually count all the rows). 3. select field1,field2,field3 from tbl This will be faster than select * since it doesn't have to fetch as much data. See http://www.mysql.com/doc/Q/u/Query_Speed.html for more information. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Speed of query - And Indexes
I've used a rule of thumb that I was told ages ago when working on other databases that inserting records into a non-indexed table is faster generally than inserting records into an identical but indexed table. I realize that this statement is probably an antiquated guideline.and I'd like to know if its still true (or if in fact it was ever true!) Regards, Gary SuperID Huntress === FreeSQL.org offering free database hosting to developers Visit http://www.freesql.org - Original Message - From: Chris Bolt [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, June 08, 2001 7:26 PM Subject: RE: Speed of query Hello all, does anyone have any feedback whether there is any difference in the efficiency of the following query on a fairly large dataset 1. select * from tbl This will be the slowest. 2 select count(*) from tbl This will be very fast since MySQL is optimized for it (the number is updated when a row is inserted, so the query doesn't actually count all the rows). 3. select field1,field2,field3 from tbl This will be faster than select * since it doesn't have to fetch as much data. See http://www.mysql.com/doc/Q/u/Query_Speed.html for more information. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Question About Compiling
I am using VC++ 6 on Win2K. What is the exact process I need to go through to set this up to use it? I compiled the original project in the root directory. I then setup one of my programs to include the mysql.h as the example had. I also have the lib file included to link in the project settings. But when I compile I get several errors... c:\my documents\my c++\mysqlapi\mysql\include\mysql_com.h(114) : error C2146: syntax error : missing ';' before identifier 'fd' c:\my documents\my c++\mysqlapi\mysql\include\mysql_com.h(114) : error C2501: 'SOCKET' : missing storage-class or type specifiers c:\my documents\my c++\mysqlapi\mysql\include\mysql_com.h(114) : error C2501: 'fd' : missing storage-class or type specifiers What do I need to do? Adam [EMAIL PROTECTED]
Adding ENV VARS with execvp Without Losing a Functional Shell {Was Re: Chroot problems}
Jeremy: Looks like I might have to eat my words a little. Not entirely on the running of MySQL in a jail, but, perhaps that too, in time. The application started as a knowledge-base, billing application. The piece I'm concerned with now involves an implementation using .profile/.bash_profile mechanisms and shell scripts that grab some environment variables and set a few and inserts a record into a table that records the fact that a particular user has logged into a remote workstation somewhere along with version information, username, location, etc. This environment remains until they logout/exit/crash, or someone kills them. I've found the implementation trap ~/.logout 0 has been pretty reliable in ensuring an additional brother record with the same unique identifier gets created, but, haven't researched how this mechanism has worked when terminals crash/get killed. This piece of the application is designed for auditing and tracking of technician/end-user activities. It records how long technicians work on particular client sites, also for billing and accountability purposes. The goal is to get away from a cumbersome shell script/rc file implementation and do the processing within a c binary. The problem is the parent processes environment. With what you've done in your chroot environment, have you found it possible to replace the current environment with execvp, adding to it what you need, and, having it work within that sub-process in a way that works without noticeable differences to a shell without such enhancements? When it exits, are you able to do any additional processing that might allow you to provide state and exit status information from the exiting execvp? If so, do you have some code examples I could examine? TIA, Van -- = Linux rocks!!! http://www.dedserius.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
Can not install
Description: I was installing MySQL on my Red Hat 7.1 server; I tried both the RPM and the tar.gz format. No matter what, though, I don't have mysqladmin or safe_mysqld files anywhere. I imagine that there are several other things missing as well. Note that when I try to run make with the tar source it gives me the following error message: make: *** No targets specified and no makefile found. Stop. I have no errors whatsoever with the RPM format. It just doesn't work. The daemon appears to be running, but I can't set passwords or anything like that. Any idea how I can fix this? How-To-Repeat: For the RPM, MySQL-3.23.38-1.i386.rpm: rpm -i MySQL-3.23.38-1.i386.rpm For the tar: tar zxvf mysql-3.23.32.tar.gz groupadd mysql useradd -g mysql mysql ./configure --prefix=/usr/local/mysql make Fix: Submitter-Id: [EMAIL PROTECTED] Originator:root Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Can not install Severity: critical Priority: high Category: mysql Class: support Release: mysql-3.23.38 (Official MySQL RPM) Environment: Intel Pentium III 450MHz, 256MB RAM, Red Hat Linux 7.1, fully up2date System: Linux darkchapter 2.4.2-2 #1 Sun Apr 8 20:41:30 EDT 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-81) Compilation info: CC='egcs' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='egcs' CXXFLAGS='-O6 -fno-omit-frame-pointer-felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 May 6 17:51 /lib/libc.so.6 - libc-2.2.2.so -rwxr-xr-x1 root root 1236396 Apr 6 17:58 /lib/libc-2.2.2.so -rw-r--r--1 root root 26350254 Apr 6 15:27 /usr/lib/libc.a -rw-r--r--1 root root 178 Apr 6 15:27 /usr/lib/libc.so Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --without-berkeley-db --without-innodb --enable-assembler --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/info --includedir=/usr/include --mandir=/usr/man '--with-comment=Official MySQL RPM' - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
help with select
Hi How do I perform this query using one operation? SELECT * FROM tablename WHERE account = (select account from tablename where name='BILL'); What I want is to lists all entries who's account is the same with 'BILL'. Thus far, what I know is to extract the account of 'BILL' and then perform another select of entries with the same account. I already tried: select * from user u, user r where r.account=u.account and r.name='BILL'; i got no result but no error. jaime database,sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: help with select
Let me see if I understood your question: select * from tablename a, tablename2 b where a.account='BILL' and a.account=b.account It's tow tables or just one table? because if it's just one table just do select * from tablename where account='BILL' see you, Augusto On Sat, 9 Jun 2001, Jaime Teng wrote: Hi How do I perform this query using one operation? SELECT * FROM tablename WHERE account = (select account from tablename where name='BILL'); What I want is to lists all entries who's account is the same with 'BILL'. Thus far, what I know is to extract the account of 'BILL' and then perform another select of entries with the same account. I already tried: select * from user u, user r where r.account=u.account and r.name='BILL'; i got no result but no error. jaime database,sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 specific to Darwin involving perl DBD::mysql
This was a problem originally submitted on msql-mysql-modules: Under Darwin 1.3.3/PPC G4, using mysql built from mysql-3.23.36+, the perl module DBD-mysql-2.0901 (and previous versions of DBD::mysql do this as well) returns 0 for $dbh-{'mysql_insertid'} (return LAST_INSERT_ID from a database handle), but returns a correct value for $sth-{'mysql_insertid'} (return LAST_INSERT_ID from a statement handle). The same module compiles and operates correctly under Linux/i686, which is the only environment I have to test against. I am not a C programmer, but from what I can tell by looking at the C code in the module (written by Jochen Wiedmann [EMAIL PROTECTED]) the calls which fail seem to refer to functions defined in the mysql.h file in the mysql source tree. JW suggested I post this problem to this list to see if anyone can shed any light on the problem. Not knowing enough C to be able to find the source of the problem, the best hint I can provide as to what's going on is something to do with the size of some of the data structures. I say this because compiling the module also produces the error: dbdimp.c: In function `mysql_db_reconnect': dbdimp.c:1694: warning: assignment from incompatible pointer type while all definitions of the pointer type declared at this point in the code are a SV object, no exceptions that I can find, and JW's code calls the built-in mysql functions directly via two structures, one of which is very clearly defined, being the statement handle structure, and also the structure associated with the working function, not the broken one. The only plausible (to me) explanation I can come up with (and I repeat, I am NOT BY ANY MEANS a C programmer or a chip guru) is that the data type/size for some of the standard definitions may be strange on the G4 because of the Altivec functions built into the chip. Perhaps the datatype is not being properly measured, and the 0 results from some bit-offset incompatibility. Or, possibly, I'm just blowing out my a$$. In particular, the last_insert_id datatype in the perl module is set at my_ulonglong which has variable definitions under different architectures. I see that the configure script uses a measurement of what size a typedef longlong is on the resident architecture, but my attempts at trying to compile with and without the conditional definition of the longlong datatype only produce compiler errors in DBD::mysql (because I don't know what I'm doing! I'm probably just defining a longlong as a long in some places and not others, like between general.h and mysql.h). I hope someone else out there has a better idea of the source of the problem, because I'm just about to give up and rewrite a lot of perl code which depends on the $dbh-{'mysql_insertid'} call, and I REALLY don't want to do that. Regards, BK - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Help Please!
I don't have source for glibc, so i executed this statement 'localedef -i en_US -f ISO-8859-1 en_US' But it still gives me that error! ...Rohit - Original Message - From: James Barwick [EMAIL PROTECTED] To: Rohit Peyyeti [EMAIL PROTECTED] Sent: Saturday, June 09, 2001 12:29 AM Subject: Re: Help Please! Rohit Peyyeti wrote: This is what it says now when I run mysqld_multi start 2: perl: warning: Setting locale failed. perl: warning: Please check that your locale settings: LANGUAGE = (unset), LC_ALL = (unset), LANG = en_US are supported and installed on your system. perl: warning: Falling back to the standard locale (C). Nothing is seen in the log file. ...Rohit TransLogic Systems 5th Floor, Amogh Plaza, Greenlands, Hyderabad, AP - 500 016, INDIA Ph: 91.40.3401795, Fax: 91.40.3407943 www.translogicsys.com if you have the source for glibc (and have compiled it), then do the following: cd /usr/src/glibc/build make localedata/install-locales if you don't have the source, execute the following command: localedef -i en_US -f ISO-8859-1 en_US last, I see your example is LANG=en_US. This should work. but, I use the 'libc' default (for me it is en_US) To use the libc default, use LANG=C. Best of luck! James - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Question About Compiling
At 21:38 08/06/2001 -0500, Adam Clauss wrote: Hi, If you are compiling a console application without the support of MFC add the #include windows.h line, otherwise when using MFC during the wizard process, check the support for sockets. Regards, Miguel I am using VC++ 6 on Win2K. What is the exact process I need to go through to set this up to use it? I compiled the original project in the root directory. I then setup one of my programs to include the mysql.h as the example had. I also have the lib file included to link in the project settings. But when I compile I get several errors... c:\my documents\my c++\mysqlapi\mysql\include\mysql_com.h(114) : error C2146: syntax error : missing ';' before identifier 'fd' c:\my documents\my c++\mysqlapi\mysql\include\mysql_com.h(114) : error C2501: 'SOCKET' : missing storage-class or type specifiers c:\my documents\my c++\mysqlapi\mysql\include\mysql_com.h(114) : error C2501: 'fd' : missing storage-class or type specifiers What do I need to do? Adam [EMAIL PROTECTED] -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
running multiple mysqld's
Hello All: I have two mysqld runnning in ports: 3307 3308 respectively. I started the second one by using 'mysqld_multi start 2'. whereas mysqld running on port 3307 is the default mysqld started at the boot time. when i issue command such as: mysql -u root -p (it connects to my new mysqld running on 3307). Why is that it won't connect to mysqld running on port 3308. I also tried giving in port / socket options to mysql but to no luck! I cannot connect to mysqld running on port 3307 (default mysqld which is started at boot time) Can any one help here? ...Rohit
Re: Re: php/mysql question (fwd)
database,sql,query On Fri, 8 Jun 2001, Gabriele Bartolini wrote: magic_quotes_gpc = On ; magic quotes for incoming GET/POST/Cookie data And, what about: magic_quotes_runtime ? Off. Adrian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 multiple mysqld's
Sorry about this questions but why would you want to run two copies of mysqld when it is capable of hosting as many different databases as you need? Even if you needed two databases with the same name you could still just create two different MySQL users for it. Thanks, Neil On Sat, 9 Jun 2001, Rohit Peyyeti wrote: Hello All: I have two mysqld runnning in ports: 3307 3308 respectively. I started the second one by using 'mysqld_multi start 2'. whereas mysqld running on port 3307 is the default mysqld started at the boot time. when i issue command such as: mysql -u root -p (it connects to my new mysqld running on 3307). Why is that it won't connect to mysqld running on port 3308. I also tried giving in port / socket options to mysql but to no luck! I cannot connect to mysqld running on port 3307 (default mysqld which is started at boot time) Can any one help here? ...Rohit - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
beginner question
I'm a new user, working through the tutorial provided in the MySQL documentation (chapter 9). I'm trying to load the data from the pet.txt file into the pet table using the specified command: mysql load data local infile pet.txt into table pet; I get the following: ERROR: File 'pet.txt' not found (Errcode: 2) I assumed that the text file was in the wrong directory, and reviewed the section describing the load data local command. Just to be safe, I put copies of the text file in several locations, including the menagerie directory (which should be the only one required), the bin directory, and the mysql directory. I still get the error message. What might I be doing wrong? Also, is there a FAQ that might hold the answer to newbie questions like this? Thanks for the help.
Re: beginner question
Not sure what the load data local infile thing is, but I always load text files from the command line like this (on Red Hat linux): % mysql -u some_guy -p some_db /full/path/to/file.txt I'm a new user, working through the tutorial provided in the MySQL documentation (chapter 9). I'm trying to load the data from the pet.txt file into the pet table using the specified command: mysql load data local infile pet.txt into table pet; I get the following: ERROR: File 'pet.txt' not found (Errcode: 2) I assumed that the text file was in the wrong directory, and reviewed the section describing the load data local command. Just to be safe, I put copies of the text file in several locations, including the menagerie directory (which should be the only one required), the bin directory, and the mysql directory. I still get the error message. What might I be doing wrong? Also, is there a FAQ that might hold the answer to newbie questions like this? Thanks for the help. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php