Re: A newbie question
To add:Table db.user does not exist. means you need to read 4.16 of the manual "Post Installation". You need to install the grant tables using mysql_install_db. - Original Message - From: "Seung-woo Nam" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, March 03, 2001 23:54 Subject: Re: A newbie question Hi By saying "mysql -u root mysql" you are telling mysql that you are going to use the database mysql which you have to use to add new users. Another way of doing it is type "mysql -u root" to log in and type "use mysql" in mysql command line. "test" is a database created by mysql by default when you install it so that you can test creating tables and running quieries on it. Seung-woo Nam anil kumar wrote: hello All, I am new to mysql database. I downloaded mysql and running on my system. For adminiatrative purpose the command i run as written in manual is "mysql -u root mysql" I am unable to understand why i have to write mysql after "-u root" why not any other database name "test". I tried to run the command like this "mysql -u root test" and when i tried to add a user i ghot Error Table db.user does not exist. I am unable to understand the meaning of above Error. Please help me to understand the problem. Thanks in advance anil - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
having problems getting a distinct listing
Hi! I have a tests database that has questions (one table is "questions" and a field in this table is "uid" and another field is "question") there is also a Testerator table in my tests database, which organizes questions by section and keeps track of test number (as field "Quid") SO I would like to obtain a list (with no repeats) of questions that are found in the questions database, but which are NOT used in a particular test. I therefore set up $GlobalUsed which finds all questions which are used somwhere in a particular test and shoves these into a temporary table, as such: $GlobalUsed=MYSQL_QUERY("CREATE TEMPORARY TABLE usedGlobal Select a.Quid, b.question, b.uid from testerator a, questions b where (a.TestID='$uid') and (a.Quid=b.uid)"); Next, $Global Unused is established, which finds all questions in the questions table which are not found in the testerator table for the particular test in which I am interested. $GlobalUnused=MYSQL_QUERY("select * from questions, usedGlobal where questions.uid != usedGlobal.uid "); HOWEVER, when I use $row = mysql_fetch_array($GlobalUnused) in a while loop to display all the unused questions, I get numerous repeats. I have TWO questions for any gurus willing to share their guru-ness: 1. Can I do this in such a way as to get a DISTINCT unused question list (I tried select * DISTINCT in both above statements, to no avail, and I tried it with DISTINCT and then finished with and ORDER BY clause, but again these didn't work for me -- I ended up getting no results ). 2. If I have to use the temporary table (because without sub-selects I'm not sure how to get the same results) that is fine. But is there a way to amalgamate both commands as one select statement and dispense entirely with the temporary table? Thanks so much! -Warren - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 client run out of memory strend bug in C API
Description: There is a bug (or undocumented feature?) in libmysqlclient - if function "strend()" is defined in client code, client will fail to connect to database with "MySQL client run out of memory" message. How-To-Repeat: #include mysql/mysql.h #include stdio.h void strend(){} /* Little nifty bug :-) */ int main() { MYSQL mysql; if (mysql_init(mysql)==NULL) return 1; if (!mysql_real_connect(mysql,"localhost","root","","mysql",0,NULL,0)) { fprintf(stderr, "Failed to connect: %s\n",mysql_error(mysql)); return 2; } return 0; } Fix: Don't know, maybe wrong external declaration... Submitter-Id: submitter ID Originator:Rastislav Rihak Organization: LoneStar Software [EMAIL PROTECTED] MySQL support: none Synopsis: strend() problem in mysqlclient API Severity: non-critical Priority: low Category: mysql Class: sw-bug Release: mysql-3.23.33 (Source distribution) Environment: Slackware Linux 7.1, AMD Duron 750MHz 128MB RAM System: Linux agnetha 2.2.16 #5 Ut jan 2 20:14:03 CET 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-slackware-linux/egcs- 2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 13 Feb 16 2000 /lib/libc.so.6 - libc- 2.1.2.so -rwxr-xr-x 1 root root 1008844 Sep 10 1999 /lib/libc-2.1.2.so -rw-r--r-- 1 root root 20019674 Sep 16 1999 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Sep 16 1999 /usr/lib/libc.so Configure command: ./configure --with-debug Perl: This is perl, version 5.005_03 built for i386-linux - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problems building mysql++
Hi! As we have underlined so many times on all our mailing lists, 2.96 can not be used for the building of MySQL++. It is a very buggy compiler. Use 2.95.2. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql access
Dear sir, I installed mysql on my apache server. However when I want to access the mysql database through my perl scripts. Following error occurs while running the scripts : install_driver (failed) : perhaps a module that DBD::mysql requires has not been fully installed. Could you please provide what are the modules reuired to be installed with mysql. so that it can work properly. Looking for you appreciation. Regards Kamlakar Patil Software Programmer Homeindia.com
How_many_variables_?
Hi,sir. I use Mysql 3.23.25 on linux-kernel 2.2.16-3,Pentium III 651 MHz,Memory 516M. I have many table and many client connect. And I have error "Too many connection"(edit max_connections) Now I use default value of server variables. I want maximun performance.How I must set variables?What variables ? from mr_mong
Re: Select from dual?
Hi, MySQL lets you do a select without any tables, i.e., without the from-clause. So, select 3; returns one row, one column, value 3. To put a value into a variable (you mean the @a -style variables?), you can either select @a := 3; or set @a := 3; And yes, if you want to do it the Oracle way, why not just define a table called DUAL and put one row in it? create table DUAL ( ID tinyint unsigned not null primary key ) max_rows=1; insert into DUAL values ( 1 ); Hope this helps. Jan "M. A. Ould-Beddi" wrote: I know that in Oracle it is possible to select a number from DUAL and put it in a variable. Is it possible In mysql? and how? Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
count on three variables group by fourth
Hi, let supose that I have next columns in Mysql database q1a, q1b, q1c and Gender with next values (5 rows) q1a (1,3,5,7,9) q1b (1,2,3,4,5) q1c (1,6,7,8,9) Gender (1,1,2,2,1) which gives the table id q1a q1b q1c Gender 1 1 1 1 1 2 3 2 6 1 3 5 3 7 2 4 7 4 8 2 5 9 5 9 1 I would like to make a single query wich will return me how many (count?) 1,2,3,4,5,6,7,8,9 from all thre variables (q1a, q1b and q1c) are in Gender 1 or 2. I'd like to have table with count to look something like this: q1a OR q1b OR q1c=1 AND Gender=1 count is 3, which means that code 1 show up in column q1a,q1b,q1c 3 times when Gender is 3 q1a OR q1b OR q1c=1 AND Gender=2 count is 0 q1a OR q1b OR q1c=2 AND Gender=1 count is 1 q1a OR q1b OR q1c=2 AND Gender=2 count is 0 q1a OR q1b OR q1c=3 AND Gender=1 count is 1 q1a OR q1b OR q1c=3 AND Gender=2 count is 1 etc... please help, thank you Borut
problems with with configure
Description: checking whether struct tm is in sys/time.h or time.h... time.h checking size of char... 0 configure: error: No size for char type. A likely cause for this could be that there isn't any static libraries installed. You can verify this by checking if you have libm.a in /lib, /usr/lib or some other standard place. If this is the problem, install the static libraries and try again. If this isn't the problem, examine config.log for possible errors. If you want to report this, use 'scripts/mysqlbug' and include at least the last 20 rows from config.log! okieland# find / -name libm.a -print /usr/lib/libp/libm.a /usr/lib/libm.a How-To-Repeat: Fix: Submitter-Id: Phillip Bruce Originator: [EMAIL PROTECTED] Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category: mysql Class: Release: mysql-3.23.33 (Source distribution) Environment: System: SunOS okieland 5.8 Generic_108529-04 i86pc i386 i86pc Architecture: i86pc Some paths: /usr/bin/perl /usr/local/bin/make /usr/local/bin/gmake /usr/local/bin/gcc /usr/ucb/cc GCC: Reading specs from /usr/local/lib/gcc-lib/i386-pc-solaris2.7/2.95.2/specs gcc version 2.95.2 19991024 (release) Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='' LDFLAGS='' LIBC: -rw-r--r-- 1 root bin 1555316 Jan 5 2000 /lib/libc.a lrwxrwxrwx 1 root root 11 Apr 11 2000 /lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 918640 Jan 5 2000 /lib/libc.so.1 -rw-r--r-- 1 root bin 1555316 Jan 5 2000 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Apr 11 2000 /usr/lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 918640 Jan 5 2000 /usr/lib/libc.so.1 Configure command: ./configure --with-unix-socket-path=/var/tmp/mysql.sock --with-low-memory --with-mit-threads=yes --without-perl --enable-thread-safe-client --without-berkeley-db Perl: This is perl, version 5.005_03 built for i86pc-solaris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Replication won't start under mysql-3.23.33
I have a master and slave server, both running mysql-3.23.29-gamma. When I set up a second slave running mysql-3.23.33, it logged these errors: 010304 10:18:50 mysqld started /opt/local/mysql/libexec/mysqld: ready for connections 010304 10:18:51 Slave: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'FIRST' at position 0 010304 10:18:51 Error reading packet from server: Could not open log file (read_errno 0,server_errno=2) I notice that the file name is missing in the status display: mysql show slave status; ++-+-+---+--+-+---+-+-+++--+ | Master_Host| Master_User | Master_Port | Connect_retry | Log_File | Pos || Slave_Running | Replicate_do_db | Replicate_ignore_db | Last_errno | Last_error | |Skip_counter | ++-+-+---+--+-+---+-+-+++--+ | master.cc.umanitoba.ca | replic | 3306| 60| | 4 || Yes | | | 0 || 0 | | ++-+-+---+--+-+---+-+-+++--+ 1 row in set (0.00 sec) I had to do this to fix it: mysql change master to master_log_file='master-bin.197'; Query OK, 0 rows affected (0.01 sec) The error log now said: 010304 10:39:48 Slave: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'master-bin.197' at position 0 Should this be necessary? Is there a bug someplace? -- -Gary Mills--Unix Support--U of M Academic Computing and Networking- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Why MySQL?
On Friday 02 March 2001 18:22, Boulat Khakimov wrote: Hi guys, I'm wondering why you prefered mySQL overe Postgres , they are both open source, and accorting to many people Postgres is more powerful and stable than mySQL. Trivial installation and update on my Linux Redhat box thanks to the provided rpms. Fast, user friendly. Great working replication feature. A most user friendly an efficient mailling list. Most of all, great support. Those guys are incredible! You usually get an answer or even a fix in less than 1 hour! I've been using mySQL for awhile myself, but recently, I've been extremely frustrated by mySQLs bugginess ... the BDB transaction support for example is extremely unstable. I do not think it has been released as stable at this time. I have had no problems with MyISAM tables. -- Jean-Luc Fontaine - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Do I have to use MyODBC to connect linux server and linux client?
I am tring to connect remote Mysql DB from local machine. Do I have to use MyODBC to connect linux server and linux client? Before 3 days, I used "mysql_connect("..","host ip",...)". I failed, the error msg is "host ' ' is not allowed to connect". From manuals, I read that I must use ODBC to contact Mysql DB from windows client. If in Linux, is it same? Then please help me how to obtain MyODBC manager program. I have MyODBC
TXT file to mysql DB
Do you know how to import TXT file into mysql DB? Because of big size txt file, I cannot input data into DB manually. Is there easy way to solve that problem? Thanks a lot.
Cannot connect to local mySQL server through socket error (111)
I have the exact problem. I wonder why the file size is 0 of the file mysql.sock? I Hi! Socket file specified is : /var/lib/mysql/mysql.sock which on my system%2
TXT file to mysql DB
Do you know how to import TXT file into mysql DB? Because of big size txt file, I cannot input data into DB manually. Is there easy way to solve that problem? Thanks a lot.
About licence
Hi I am a 5th year student of University of Technology in Poznan (Poland). I would like to use MySQL in commerce project (Internet Auction). I will develope my Auction in Linux. Have I buy a licence from you ??? How many it cost. Pleace answer me, it is very important for me. Thank you. Piotrek -- Codzienne streszczenie prasy podatkowej, wzory formularzy a takze aktualne wskazniki i stawki. Odwiedzajac http://podatek.getin.pl/ jestes zawsze dobrze poinformowany! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
trying to install on RedHat 7.0 and need help
I cannot seem to get this database program to work correctly. I am asking for any help I can get. I need to start this asap. Charles Hagen [EMAIL PROTECTED]
IGNORE previous temporary table problem posting
Hi All! I just posted a note about having problems creating temporary tables. However, I JUST realized (and empirically verified) that my problem of not being able to create temporary tables is that I didn't use an ID with the CREATE permission enabled. I am a bonehead. Thanks again! Cheers! -Warren - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 building mysql++
- Original Message - From: "Sinisa Milivojevic" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Sunday, March 04, 2001 7:32 AM Subject: Re: Problems building mysql++ Quinn Wilson writes: I am trying to build mysql++, I am doing something wrong but I don't know what. I have downloaded and untar'd ungzipped mysql++-1.7.8.tar.gz into mysql++-1.7.8, run configure and then make, make install. I set my LD_LIBRARY_PATH to include the new library and then I try to run the resetdb program in the examples directory and it dies w/ Segmentation fault (core dumped). It seemed to "make" correctly. The version of mysql I am running is 3.23.33, freshly built and installed. This is a Redhat 7.0 i386, I have not had any problems building other applications so I don't think my compiler installation is to blame. Here's what I tried. I found the lt-resetdb program and ran gdb lt-resetdb core and got: GDB is free software, covered by the GNU General Public License, and you are welcome to change it and/or distribute copies of it under certain conditions. Type "show copying" to see the conditions. There is absolutely no warranty for GDB. Type "show warranty" for details. This GDB was configured as "i386-redhat-linux"... Core was generated by `./lt-resetdb'. Program terminated with signal 11, Segmentation fault. Reading symbols from /home/quinn/decomp/mysql++-1.7.8/sqlplusint/.libs/libsqlplus.so.1...done. Loaded symbols for /home/quinn/decomp/mysql++-1.7.8/sqlplusint/.libs/libsqlplus.so.1 Reading symbols from /usr/lib/libz.so.1...done. Loaded symbols for /usr/lib/libz.so.1 Reading symbols from /usr/local/mysql/lib/mysql/libmysqlclient.so.10...done. Loaded symbols for /usr/local/mysql/lib/mysql/libmysqlclient.so.10 Reading symbols from /usr/lib/libstdc++-libc6.2-2.so.3...done. Loaded symbols for /usr/lib/libstdc++-libc6.2-2.so.3 Reading symbols from /lib/libm.so.6...done. Loaded symbols for /lib/libm.so.6 Reading symbols from /lib/libc.so.6...done. Loaded symbols for /lib/libc.so.6 Reading symbols from /lib/libcrypt.so.1...done. Loaded symbols for /lib/libcrypt.so.1 Reading symbols from /lib/libnsl.so.1...done. Loaded symbols for /lib/libnsl.so.1 Reading symbols from /lib/ld-linux.so.2...done. Loaded symbols for /lib/ld-linux.so.2 Reading symbols from /lib/libnss_files.so.2...done. Loaded symbols for /lib/libnss_files.so.2 #0 chunk_free (ar_ptr=0x464c457f, p=0x40057198) at malloc.c:3071 3071malloc.c: No such file or directory. I stepped through untill I got a SIGSEGV : 90 if (mysql_real_connect(mysql,host,user,passwd,db, 3306,NULL,0)) { (gdb) Program received signal SIGSEGV, Segmentation fault. chunk_free (ar_ptr=0x464c457f, p=0x40057198) at malloc.c:3071 3071malloc.c: No such file or directory. Current language: auto; currently c I don't know what to make of this output, does anyone on this list recognize what's going on? I don't know what to make of this output. Quinn Wilson - [EMAIL PROTECTED] - Lunkee cc Lunky do{;} - "For a list of the ways which technology has failed to improve our quality of life, press 3." Hi! I need more info in order to be able to help you : - What OS it is and which version it is Linux - Redhat - 7.0 - 2.2.16-22 kernel - What is a version of C Library libc6.2-2 - What compiler it is and what version of compiler gcc - 2.96 - What version of STL libraries and MySQL client libraries did you use libstdc++-libc6.2-2 mysql version = 3.23.33, mysql++ version = 1.7.8 Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL 3.23.33 Query Problems
Lets see if anyone can help me out: I have these 3 tables in a MySQL 3.22.27 Database and i'm running this query: SELECT supplier.id,supplier.company_name,supplier.contact_name,supplier.address_street, supplier.address_city,supplier.address_state,supplier.address_zip,supplier.phone_business, supplier.url,supplier.miniweb_live,supplier.miniweb_name,supplier.special_live,subcatsicbond. sub_catid,subcatsicbond.siccode FROM subcatsicbond LEFT JOIN suppliersiclink ON subcatsicbond.siccode=suppliersiclink.sic_code LEFT JOIN supplier ON suppliersiclink.sup_id=supplier.id WHERE ((subcatsicbond.sub_catid=37) AND (supplier.max_latitude=32.99) AND (supplier.min_latitude=31.55) AND (supplier.min_longitude=89.25) AND (supplier.max_longitude=90.97)) ORDER BY supplier.company_name ASC LIMIT 0,10; Which works fine, but takes forever, I've upgrade a test machine to MySQL 3.23.33 and did a mysqldump on the 3.22.27 server of the database. I imported the DB into MySQL 3.23.33 to run the query to test time diffrences, however, I got unexpcted resutls. In MySQL 3.22.27 when I run the above query, I get the proper results. However, In MySQL 3.23.33 (using SAME database) I get NO results. So, I changed the query around to this: SELECT supplier.id,supplier.company_name,supplier.contact_name,supplier.address_street,supplier.address_city, supplier.address_state,supplier.address_zip,supplier.phone_business,supplier.url,supplier.miniweb_live, supplier.miniweb_name,supplier.special_live,subcatsicbond.sub_catid,subcatsicbond.siccode FROM supplier,subcatsicbond,suppliersiclink WHERE ((suppliersiclink.sic_code=subcatsicbond.siccode) AND (subcatsicbond.sub_catid=37) AND (supplier.id=suppliersiclink.sup_id) AND (supplier.max_latitude=32.99) AND (supplier.min_latitude=31.55) AND (supplier.min_longitude=89.25) AND (supplier.max_longitude=90.97)) ORDER BY supplier.company_name ASC LIMIT 0,10; This query works fine in MySQL 3.22.27 (and faster too [by 2secs]) to get the same results as first query. However, it does not work in MySQL 3.23.33. Here's what I'm trying to do (for those if you that feel you can help): I have: 'supplier' table (~105,000 rows) 'subcatsicbond' table (~354 rows) 'suppliersiclink' table (~135,000 rows) I need to JOIN all these tables, by: 1) pull list of siccodes from subcatsicbond 2) join those siccodes with table suppliersiclink to get supplier id 3) join suppler on suppliersiclink to get list of suppliers in that sic area Thanks for the help. - Johnny Withers [EMAIL PROTECTED] p. 601.853.0211 c. 601.954.9133 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: AARGGGgg your documentation is simply wrong. NONE OF THE USER PERMISSION materal makes sense. I am read ing here http://www.mysql.com/doc/D/e/Default_privileges.html and http://www.mysql.com/doc/A/d/Adding_users.html and I follow what is says: shell mysql -u root mysql ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) whatever. any suggestions please send them to dugan@bowser I'm running Linux 2.2.17 rpm version of MySQL: MySQL-3.22.25-1.i386.rpm MySQL-client-3.22.25-1.i386.rpm Thanks in advance. How-To-Repeat: Fix: Submitter-Id: submitter ID Originator:Jonathan Dugan Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category: mysql Class: Release: mysql-3.22.25 (Source distribution) Server: /usr/bin/mysqladmin Ver 7.11 Distrib 3.22.25, for pc-linux-gnu on i686 TCX Datakonsult AB, by Monty Server version 3.22.25 Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 8 min 35 sec Threads: 1 Questions: 9 Slow queries: 0 Opens: 6 Flush tables: 1 Open tables: 2 Environment: System: Linux iscb.stanford.edu 2.2.16-3smp #1 SMP Mon Jun 19 19:00:35 EDT 2000 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) Compilation info: CC='egcs' CFLAGS='-O6 -fomit-frame-pointer' CXX='egcs' CXXFLAGS='-O6 -fomit-frame-pointer-felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' Configure command: ./configure --enable-shared --enable-assembler --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/info --includedir=/usr/include --mandir=/usr/man Perl: This is perl, version 5.005_03 built for i386-linux - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
synopsis of the problem (one line)
Description: Unclear documentation on how user permissions work. I've been using databases for about a year and have experience with Postgres and Oracle. How do I add a new user?? How do permission work?? I've spent an hour now and I still get: ERROR 1044: Access denied for user: '@localhost' to database 'mysql' How-To-Repeat: Install MySQL. Fix: Better documentation. Submitter-Id: submitter ID Originator:Jonathan Dugan Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category: mysql Class: Release: mysql-3.22.25 (Source distribution) Server: /usr/bin/mysqladmin Ver 7.11 Distrib 3.22.25, for pc-linux-gnu on i686 TCX Datakonsult AB, by Monty Server version 3.22.25 Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 16 sec Threads: 1 Questions: 1 Slow queries: 0 Opens: 6 Flush tables: 1 Open tables: 2 Environment: System: Linux iscb.stanford.edu 2.2.16-3smp #1 SMP Mon Jun 19 19:00:35 EDT 2000 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) Compilation info: CC='egcs' CFLAGS='-O6 -fomit-frame-pointer' CXX='egcs' CXXFLAGS='-O6 -fomit-frame-pointer-felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' Configure command: ./configure --enable-shared --enable-assembler --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/info --includedir=/usr/include --mandir=/usr/man Perl: This is perl, version 5.005_03 built for i386-linux - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Recursive queries
Quick searches of Google and the MySQL page didn't turn up anything, so I'll ask here.. Here's what I have: I have a table that among others, have fields called 'section_id' and 'parent_id'. The section_id is the id of the "self" section, and the parent_id is the id of the section that "owns" the self section. (It's sort of like a filesystem where one directory has subdirectories, and so on) Here's what I'm trying to do: I want to start with one section, and go down the tree of sub-sections, picking up information about them on the way. Example: I want to start at the "root" section, and follow down one of it's sub-sections. (Root) | |--- Sports Products || ||--- Golf :: Item1, Item2, Item3, Item4 || ||--- Fishing :: Item5, Item6, Item7, Item8 So it will start at Root, find that Sports Products is attached to Root, get the information I want from Sports Products, then it will find that Golf and Fishing are attached to Sports Products, and get the information from them respectively. (And so on) As it stands, it won't go any further than 2 levels deep from the root section, so I won't need to find a more effecient way to organize the relationships for now. What do you all feel would be the best way to do this? -- Isaac Force [EMAIL PROTECTED] (503)656-2489 http://gorgonous.dhs.org Real Users find the one combination of bizarre input values that shuts down the system for days. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 anyone help with this please?
Hi there... Very new to Databases I have been learning ASP over the last few months and have no come to start using databases My web host is WebFusion, who use a MySQL system for their database, where as I at home use MS Access2000... I've got it all set up so that I can export from home to the server and it updates the database, and also I've got a test page that allows you to enter some info and it updates the database from the web - so that side of things is kinda working... I've added a table this evening, as I wanted to set up a special one for people who register on my site, I've come across a couple of problems, and I'm not sure what to do... 1) Once I've exported the table, I dont seem to be able to change the structure of it, ie add more fields, or remove some, or what ever, I just get an error if I try... 2) Fields set to 'autonumber' and 'yes/no - true/false etc' are changed to 'number'... 3) I dont seem to be able to remove a table from the databaseso now I'm getting loads as I'm testing stuff, and i want to remove them... If anyone can help me at all I'd be very greatful, I appreciate this is probably not quite the usual sort of question you get here... Oh, and as I'm kinda new to this, if you could explain things kinda 'newbie' clearly, that would be great :) Thanks in advance for any help Respectfully Robb Meade - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
substring and a join?
Hello, I have the following query: "SELECT thara_plane.id,thara_plane.nam e,thara_plane.nick,thara_plane.bodytext,thara_category.category " ."FROM thara_plane,thara_category,substring(thara_plane.bodytext,225) as bodytext " ."WHERE ((thara_plane.category = thara_category.id)) " ."ORDER BY thara_plane.time_last DESC"; I need to select the first 255 chars from the field "thara_plane.bodytext". The previous query, however, doesn't work. I have tried it several ways, changine one row and another but I haven't yet found a solution that works. Any ideas? Yours, Lauri - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Unique ID's Alphanumeric to save digits ?
Hi. On Tue, Feb 27, 2001 at 04:49:33PM -0800, [EMAIL PROTECTED] wrote: Can MySQL help with generation of ALPHANUMERIC unique identifiers ? ID's that use the full ASCII char range create more possible combinations with the same # of characters which can be important when squeezing into cookie storage space. 4 character numeric ID has 10,000 combinations. 4 character (6 bits per char) alphanumeric id has 16,777,216 combinations If MySQL can't help then I can do it with Perl/PHP I suppose but just curious. You cannot store the ids that why (neither would it make sense to waste space this way), but can use a conversion function on retrievel. I don't know the name from my head, but MySQL has several functions to convert numbers from one base (e.g. decimal) to another base (e.g. octal), and also one to convert to abitrary bases. You can use this latter one to convert the ids the way you want by specifying a base of 36. Have a look at the sections about string functions, arithmetic functions and misc functions. In one of these you should find the answer. Bye, Benjamin. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Synopsis: Unable to compile from sources
Description: Unable to compile on a 64bit Solaris 7 machine with gcc. How-To-Repeat: ./configure configure output snipped checking size of char... 0 configure: error: No size for char type. A likely cause for this could be that there isn't any static libraries installed. You can verify this by checking if you have libm.a in /lib, /usr/lib or some other standard place. If this is the problem, install the static libraries and try again. If this isn't the problem, examine config.log for possible errors. If you want to report this, use 'scripts/mysqlbug' and include at least the last 20 rows from config.log! config.log's last entries were: configure:6444: checking size of char configure:6463: gcc -o conftest -O6 -DDBUG_OFF -DHAVE_CURSES_H -I/export/home/ staff/mark/Apachetoolbox-1.5.12/src/mysql-3.23.33/include -DHAVE_RWLOCK_T conf test.c -ldl -lz -lcrypt -lgen -lsocket -lnsl -lm -lpthread -lthread 15 configure: failed program was: #line 6452 "configure" #include "confdefs.h" #include stdio.h main() { FILE *f=fopen("conftestval", "w"); if (!f) exit(1); fprintf(f, "%d\n", sizeof(char)); exit(0); } Fix: compiled conftest.c (from the config.log output), and noticed the program conftest died upon running due to the libz library not being in the libraries search path. Fix: move libz to /usr/lib or /lib, OR add it's path into LD_LIBRARY_PATH (Libz was in /usr/local/lib, which under Solaris is not searched for .so libraries. The static library for libz was installed, too. Submitter-Id: [EMAIL PROTECTED] Originator: Mark Godfrey Organization: Cyber Ware Ltd Synopsis: Unable to compile from sources Severity: critical Priority: low Category: mysql Class: sw-bug Release:mysql-3.23.33 (Source distribution) Environment: System: SunOS speakno.cyberware.co.uk 5.7 Generic_106541-12 sun4u sparc SUNW,Ultra-2 Architecture: sun4 Some paths: /usr/bin/perl /usr/local/bin/make /usr/local/bin/gmake /usr/local/bin/gcc GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.7/2.7.2.3/specs gcc version 2.7.2.3 Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='' LDFLAGS='' LIBC: -rw-r--r-- 1 root bin 1694308 Nov 3 06:06 /lib/libc.a lrwxrwxrwx 1 root root 11 Jul 1 1999 /lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 1115940 Nov 3 06:06 /lib/libc.so.1 -rw-r--r-- 1 root bin 1694308 Nov 3 06:06 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Jul 1 1999 /usr/lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 1115940 Nov 3 06:06 /usr/lib/libc.so.1 Configure command: ./configure --with-unix-socket-path=/var/tmp/mysql.sock --with-low-memory --with-mit-threads=yes --without-perl --enable-thread-safe-client --without-berkeley-db Perl: This is perl, version 5.004_04 built for sun4-solaris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Do index in MySQL is case insensitive?
Hi, Do you mean case insensitive when you do a like? a like is case insensitive, to make it sensitive do a LIKE BINARY 'abc', or use CLIKE (from memory, might be wrong). Robin -Original Message- From: Carfield Yim [mailto:[EMAIL PROTECTED]] Sent: 02 March 2001 10:42 To: '[EMAIL PROTECTED]' Subject: Do index in MySQL is case insensitive? I have heard from somebody that MySQL index is case insensitive. If this is true, how can I set it to case sensitive? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Index / Rank in table
You'd probably be better off having rank and votes fields in the actual album_detail table. Whether you choose to maintain the individual votes in the album_ranks is another story. Let's say you rank an album from 1 to 10 - the rank would then be calculated like this: $uservote = 8.5 // this is what the user voted on the web form set rank=(votes*rank+$uservote)/(votes+1), votes=votes+1 Say your first vote was 8.5. The rank would be 8.5. Here's how three more votes would work (user ranks 3.5): rank=(8.5*1+3.5)/2 = 6, votes=2 (user ranks 6) rank = (6*2 + 6)/3 = 6 (user ranks 10) rank=(6*3+10)/4 = 7 That way your queries would be very fast, but you wouldn't be able to let people change their votes unless you maitain the votes table and reverse the above math. I'd probably drop the album_ranks table entirely. - Original Message - From: "Adam W" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, March 03, 2001 11:17 AM Subject: Index / Rank in table Hi I'm designing a site where people can vote for their favourite albums using PHP3 to query the database. It's the first database I've 'designed', and I'm sure that there are improvements I could make to the way I have organised the data. For example, I'm looking for a way to make the 'album_ranks' table superfluous... e.g. when I query the database and return the 'album_id', 'artist', 'title' and 'year' fields from the 'album_details' table, I would like to be able to automatically return a 'rank' based on the 'album_id' position in the 'album_votes' table. Is it possible to do this? Currently, everytime an album is voted for, and the 'votes' column is updated in 'album_votes', I am repopulating the whole of the 'album_ranks' table on the basis of the updated vote... considering that this table contains in excess of 20,000 elements, this seems to me to be extremely inefficient. I have read what I can on 'indexes' (I'm sure that the solution lies there somewhere), but I'm still in a fog of ignorance on the subject. Could anyone point me in the right direction Yours gratefully Adam [ example structure below... ] SELECT * FROM album_details --- album_id | artist| title | year --- 5 | the beatles | revolver| 1966 17 | nirvana| nevermind | 1991 etc etc... SELECT * FROM album_votes --- album_id| votes --- 5| 16382 17 | 4732 etc etc... SELECT * FROM album_ranks --- album_id| rank --- 5| 1 17 | 2 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
more help with SELECT statement
Hi, A few days ago, I asked the list about a SELECT statement. I received 2 replies that didn't really work but helped me think about the problem some more. In my database I have 4 tables. For this one query, I am matching up data from 3 of these tables and then displaying them on a website. Here is the query: SELECT request.id, request.date, request.type, request.status, faculty.f_name, faculty.l_name, action.id, faculty.id FROM faculty, request LEFT JOIN action ON request.id=action.request_id WHERE request.requested_by=faculty.id; and here is the output created by a php script with data from the above query: http://www.geology.ohio-state.edu/test/rfatest/rfadisplay.php I know it looks ok, but I am not quite sure the SELECT statement is doing what I want it to. I want the query to match up all the requests(request) with the person who requested them(faculty) and then match up all the requests to any actions that our staff might have performed on them (action). However, if no actions were performed yet, I still need those requests displayed. So basically I am matching up one table with two other tables. So if any one can examine the above SELECT statement, and let me know if it does/doesn't look ok, then that would be great. Thanks, 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
A Strange Configure Problem
DOn't ask me to explain this, I am not that smart. But here is what I have found out. I was trying to configure mysql using gcc as the C compiler and C++ compiler. Configure kept failing when it got to checking gcc as the C++ compiler. When I checked the config.log it failed trying to excecute /usr/local/gcc. /usr/local/gcc was my directory where I unpacked the gcc tar files. When I renamed the directory to gnu_gcc then my configure worked using gcc for both C and C++. Why would configure find the gcc executable in /usr/local/bin for the C compiler but not for the C++ compiler? Confused as always. But at least now I am confused on a higher level! Terry -- __ Terry Babbey Technical Support Specialist Lambton College, Sarnia, Ontario, 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
mysql can't start
(sorry for my english, I am from Russia) I have a problem this MySQL on my linux (2.2.14) server. In some pretty day after reboot MySQL-server (3.22.25) stopped to answer on any exposure. I tried to do something and after all remove it completely and install again - nothing happens. I install MySQL on another server - it's work so funny. I upgrade MySQL to 3.23.33 - nothing happens. So, what I can see. I can't connect to MySQL though telnet or socket (locally). Then i start debug, MySQL say this: T@1024 : fn_format T@1024 : | enter: name: / dsk: form: flag: 16 T@1024 : | dirname_part T@1024 : | | enter: '/' T@1024 : | dirname_part [] T@1024 : my_malloc T@1024 : init_signals T@1026 : signal_hand T@1026 : | init_thr_alarm T@1026 : | | init_queue T@1026 : | | | my_malloc T@1026 : | | | | my: Size: 488 MyFlags: 16 T@1026 : | | | | exit: ptr: 823d5d8 T@1026 : | | | my_malloc T@1026 : | | init_queue T@1026 : | init_thr_alarm T@1026 : | my_create T@1026 : | | my: Name: '/var/lib/mysql/pres.pid' CreateFlags: 436 AccessFlags: 1 MyFlags: 16 T@1026 : | my_create T@1026 : | my_malloc T@1026 : | | my: Size: 24 MyFlags: 16 T@1026 : | | exit: ptr: 823d7c8 T@1026 : | my_malloc T@1026 : | exit: fd: 10 T@1026 : | my_write T@1026 : | | my: Fd: 10 Buffer: 7f7ffcb0 Count: 5 MyFlags: 16 T@1026 : | my_write T@1026 : | my_close T@1026 : | | my: fd: 10 MyFlags: 0 T@1026 : | | my_free T@1026 : | | | my: ptr: 823d7c8 T@1026 : | | my_free T@1026 : | my_close Now server going to sleep and then I try to stop process, it write to trace-log this, but don't want to dead. T@1024 : | end_thread_signal T@1024 : | end_thread_signal T@1026 : | end_thread_signal T@1026 : | end_thread_signal Then I use strace, i get this: execve("/usr/sbin/mysqld", ["/usr/sbin/mysqld"], [/* 18 vars */]) = 0 personality(PER_LINUX) = 0 geteuid() = 100 getuid()= 100 getegid() = 234 getgid()= 234 getrlimit(RLIMIT_STACK, {rlim_cur=8192*1024, rlim_max=RLIM_INFINITY}) = 0 setrlimit(RLIMIT_STACK, {rlim_cur=2040*1024, rlim_max=RLIM_INFINITY}) = 0 getpid()= 13859 [..] /* 17 entries */, 3391) = 340 lseek(5, 0, SEEK_CUR) = 1024 getdents(5, /* 0 entries */, 3391) = 0 close(5)= 0 SYS_174(0x2, 0x7764, 0x76d8, 0x8, 0x2) = 0 SYS_174(0xe, 0x7780, 0x76f4, 0x8, 0xe) = 0 SYS_175(0x2, 0x7a14, 0, 0x8, 0x2) = 0 SYS_174(0xb, 0x7868, 0, 0x8, 0xb) = 0 SYS_174(0x7, 0x7880, 0, 0x8, 0x7) = 0 SYS_174(0x4, 0x7874, 0, 0x8, 0x4) = 0 SYS_174(0xd, 0x77e4, 0x7758, 0x8, 0xd) = 0 SYS_174(0xf, 0x77f8, 0x776c, 0x8, 0xf) = 0 SYS_174(0x1, 0x77f0, 0x7764, 0x8, 0x1) = 0 SYS_175(0x2, 0x7940, 0, 0x8, 0x2) = 0 sched_get_priority_max(0, 0, 0x79d8, 0x7a9c, 0x7a9c) = 0 sched_get_priority_min(0, 0, 0x79d8, 0x7a9c, 0) = 0 pipe([5, 6])= 0 clone() = 13860 write(6, "\0\0\0\0\5\0\0\0\0\0\0\0\0\0\0\0"..., 148) = 148 SYS_175(0x2, 0, 0x7940, 0x8, 0x2) = 0 write(6, "\300\220\37\10\0\0\0\0\234\372\377"..., 148) = 148 SYS_175(0x2, 0, 0x78ac, 0x8, 0x2) = 0 SYS_179(0x78ac, 0x8, 0, 0, 0x78ac On another computer I cant see continue of this data: SYS_179(0xb7b8, 0x8, 0, 0, 0xb7b8 unfinished ... --- (null) (Real-time signal 0) --- ... SYS_179 resumed ) = -1 EINTR (Interrupted system call) sigreturn() = ? (mask now [HUP QUIT TERM TSTP]) SYS_175(0x2, 0, 0xb854, 0x8, 0x2) = 0 SYS_179(0xb854, 0x8, 0, 0x4, 0xb854 unfinished ... --- (null) (Real-time signal 0) --- ... SYS_179 resumed ) = -1 EINTR (Interrupted system call) sigreturn() = ? (mask now [HUP QUIT TERM TSTP]) SYS_175(0x2, 0, 0xb70c, 0x8, 0x2) = 0 SYS_179(0xb70c, 0x8, 0, 0x4, 0xb70c unfinished ... --- (null) (Real-time signal 0) --- ... SYS_179 resumed ) = -1 EINTR (Interrupted system call) sigreturn() = ? (mask now [HUP QUIT TERM TSTP]) [.] Then I want to stop MySQL, I can do it only by 'kill -9'. I mean, MySQL can't do something in function init_signals. Maybe, somebody can to talk to me, that is trouble? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
insert + AUTO_INCREMENT
hi, i have a problem i have a database table created with the statement: CREATE TABLE chatmessages (id tinyint(6) DEFAULT '0' NOT NULL AUTO_INCREMENT, message text, username varchar(100), UNIQUE id (id); I insert records with: INSERT INTO chatmessages (message, username) VALUES ('this is my message', 'joris'); this works fine (for a while), i can insert messages and retreive them with php. But after some time i get the error: ERROR 1062: Duplicate entry '127' for key 1 but how can this be because i've set it to AUTO_INCREMENT. can someone help me? thanks in advance Joris Kluivers
Re: TXT to MySQL DB
On Mon, 5 Mar 2001 16:28:56 +0900, "Cho Bum Rae" [EMAIL PROTECTED] wrote: check into the LOAD DATA, this should handle it for you. Manual: http://www.mysql.com/doc/L/O/LOAD_DATA.html Do you know how to import TXT file into mysql DB? Because of big size txt file, I cannot input data into DB manually. Is there easy way to solve that problem? Thanks a lot. Mike(mickalo)Blezien Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225) 686-2002 = - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL for my application?
Hello all, I am brand new to MySQL. I have very limited experience with SQL type databases. MySQL appears to be a very elaborate product capable of many things. I've glanced at the documentation before writing this. I have 2 very general question to all you 'experienced' MySQL users. Question #1)... My application is in definite need of an SQL database manager. That much I know. But what I'm looking for is a db manager that can handle backward compatibility (ie: database version independence) of my application's data. Putting it in laymen's terms... I have an application that creates and uses a database of data that it uses now (say with version 1.0 of my software). Next year I come out with version 2.0 of my software but I want my software to be capable of running with previous versions of data (stored in the database) as well as new versions. In other words, I want to develop my software to be backward compatible with previous versions of data. I know the application is my responsibility, BUT will MySQL be capable of managing concurrent versions of data inbetween software versions? Sir, I can't figure out what you're asking. The DBMS handles the data, and your application interfaces with the DBMS. If your app changes but the DBMS doesn't, then the way the data is handled doesn't change. The only thing that changes is the way your app interfaces with the DBMS. MySQL is very good about backward compatibility with older versions of itself; if you upgrade to a new version of MySQL, there shouldn't be any need to rewrite your app. Questions #2)... I've used INFORMIX E/SQL in the past but only a little. So I am vaguely familiar with the 'style' of commands one must embed into the code to retrieve data from the database manager. Is there a 'standard' to SQL query command syntax? If I commit to MySQL today and decide to use ORACLE, INFORMIX, GNUSQL, etc. down the road (for whatever reason) will I have to rewrite my db interface handlers? SQL is a standard maintained by a standards organization. No DBMS vendor limits itself to this standard completely. MySQL is no better or worse than any other RDBMS in this regard. You can avoid having to rewrite your db interface by using ODBC or some other database abstraction software. This limits you to the functionality supported by ODBC, and makes your app run a little slower. You can also try to limit your SQL statements to the basic SQL syntax shared by most RDBMSs. This also limits your functionality, but speeds things up a bit. Depending on the developement language you're using, there may be database abstraction software that allows more functionality and runs faster than ODBC. For example, there are a number of abstraction layers available for PHP. - - - Sorry about the simplicity of these questions but you can tell I am exploring what are my best options for introducing a db manager to my application without making costly mistakes from the start. Thank you Attila Bob Hall Know thyself? Absurd direction! Bubbles bear no introspection. -Khushhal Khan Khatak - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Join Question
What am I doing wrong? The goal is to count the number of entries which match the account preferences. The results are correct, but the times are so far off... mysql select count(*) from STLOUIS left join ClientSTL - on STLOUIS.Dwell=ClientSTL.Dwell where ClientSTL.account='pruitt'; +--+ | count(*) | +--+ | 63 | +--+ 1 row in set (33.28 sec) mysql select count(*) from STLOUIS where Dwell='Con'; +--+ | count(*) | +--+ | 63 | +--+ 1 row in set (0.01 sec) Sir, the left join returns all rows from the left table, which means that it doesn't use any indices on that table. The WHERE condition ensures that rows that don't match on the right table aren't returned, so the left join is unnecessary. Change it to an INNER JOIN, and make sure you have proper indices on both tables. Bob Hall Know thyself? Absurd direction! Bubbles bear no introspection. -Khushhal Khan Khatak - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: C API problem
dear Sir, It's so exiting receive your mail. For months it's the first and perhaps the only mail I receive. Thank you. There are quetions remain: Isn't it the complete 3.22 package I installed ? I've read several text books about Mysql, that they don't mention the Mysql-devel package, and the authors encourage compile and link directly. What do you think ? But at the end I would follow your way. Where is the Mysql-devel package I can get(download) ? In Mysql and tcx website I can't find the package. please send message to [EMAIL PROTECTED] Solute. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
C API problem
dear Sir : MySQL 3.22 on my linux 486 PC seems work so good. when I compile a simple C API program which catched from the MySQL tutorial, it chokes at the end of compile process . the program is as follows: #include stdio.h #include mysql.h #define def_host_name NULL #define def_user_name NULL #define def_password NULL #define def_db_name NULL MYSQL *conn; int main(int argc,char *argv[]) { conn=mysql_init(NULL); mysql_real_connect( conn, def_host_name, def_user_name, def_password, def_db_name, 0, /*port defaut*/ NULL, /*socket default*/ 0);/*flag*/ mysql_close(conn); exit(0); } I compile as follows: gcc -o client my_simplest_prog -I/home/MySQL/MySQL/include \ -L/home/MySQL/MySQL/lib \ -lmysqlclient then I get : /home/MySQL/MySQL/lib/libmysqlclient.a(my_open.o)In function 'my_open': my_open.o(.text+0x14):undefined reference to 'open64' /home/MySQL/MySQL/lib/libmysqlclient.a(mf_format.o)In function 'fn_format': mf_format.o(.text+0x201):undefined reference to '__lxstat64' /home/MySQL/MySQL/lib/libmysqlclient.a(my_open.o)In function 'my_open': my_open.o(.text+0x21):undefined reference to 'fopen64' nothing left to do with the situation, I beg your help. anyway I'm a newcomer. thank you very much. please send message to [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: TXT to MySQL DB
on 3/5/01 12:28 AM, Cho Bum Rae at [EMAIL PROTECTED] wrote: Do you know how to import TXT file into mysql DB? Because of big size txt file, I cannot input data into DB manually. Is there easy way to solve that problem? Cho: Look at mysqlimport, which comes with mysql. It is well documented in the manual or via: mysqlimport --help Thanks, Geoff - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: trying to install on RedHat 7.0 and need help
At the moment all anyone can do is point you to the manual at http://www.mysql.com/doc/I/n/Installing.html. Given how easy this is to find from www.mysql.com, we must assume you have already read it and therefore are having some sort of problem not covered by it - perhaps you could explain what is happening? Cheers Jon -Original Message- From: Charles L. Hagen [mailto:[EMAIL PROTECTED]] Sent: 04 March 2001 04:12 To: [EMAIL PROTECTED] Subject: trying to install on RedHat 7.0 and need help Importance: High I cannot seem to get this database program to work correctly. I am asking for any help I can get. I need to start this asap. Charles Hagen [EMAIL PROTECTED] ** 'The information included in this Email is of a confidential nature and is intended only for the addressee. If you are not the intended addressee, any disclosure, copying or distribution by you is prohibited and may be unlawful. Disclosure to any party other than the addressee, whether inadvertent or otherwise is not intended to waive privilege or confidentiality' ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
multiple inserts
Hello mysql, Hi, I have a table "Invoices", and i want to do something like this.. every 15 of every month, i need to open every registry of invoices.. take the price of each record and crete a new record with that price * 1.21 (I'm from argentina, and we pay some taxez :) How can i do this? i think set @variables wiil be a good idea.. but how can i use set with 190 records? i dont know how to do it... Thanks -- Best regards, fano mailto:[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: TXT file to mysql DB
Have a look at mysqlimport and 'LOAD DATA INFILE' in the manual. Your question doesn't provide the format of the text file, so it's hard to pinpoint an exact solution... http://www.mysql.com/doc/L/O/LOAD_DATA.html http://www.mysql.com/doc/m/y/mysqlimport.html On Sun, 4 Mar 2001, Cho Bum Rae wrote: Do you know how to import TXT file into mysql DB? Because of big size txt file, I cannot input data into DB manually. Is there easy way to solve that problem? Thanks a lot. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Bug in MySQL 3.22 ?
the following is quite odd, maybe i'm doing something wrong.. mysql drop database planhouse-broke; ERROR 1064: You have an error in your SQL syntax near '-broke' at line 1 mysql show databases; +-+ | Database| +-+ | jeffdavis | | kermit | | kite| | mediabankDEMO | | mysql | | planhouse | | planhouse-broke | | portal | | rivoaks | | test| +-+ 10 rows in set (0.00 sec) mysql use planhouse-broke; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Didn't find any fields in table 'accentorderdetail' Didn't find any fields in table 'accentordermain' Didn't find any fields in table 'accents' Didn't find any fields in table 'articlecats' Didn't find any fields in table 'articles' Didn't find any fields in table 'articletypes' Didn't find any fields in table 'artisans' Didn't find any fields in table 'bannercats' Didn't find any fields in table 'banners' Didn't find any fields in table 'bannertypes' Didn't find any fields in table 'cart' Didn't find any fields in table 'companylist' Didn't find any fields in table 'designers' Didn't find any fields in table 'layout' Didn't find any fields in table 'maincats' Didn't find any fields in table 'mainminiweb' Didn't find any fields in table 'mainsubcats' Didn't find any fields in table 'members' Didn't find any fields in table 'planner' Didn't find any fields in table 'plans' Didn't find any fields in table 'planstyles' Didn't find any fields in table 'pricegroup' Didn't find any fields in table 'siccodes' Didn't find any fields in table 'specials' Didn't find any fields in table 'subcatsicbond' Didn't find any fields in table 'supplier' Didn't find any fields in table 'suppliersiclink' Didn't find any fields in table 'users' Didn't find any fields in table 'webstyle' Didn't find any fields in table 'zipcodeplans' Didn't find any fields in table 'zipcodes' Database changed mysql show tables; +---+ | Tables in planhouse-broke | +---+ --- table list --- mysqlexit; [root@host:mysql]# mysqladmin -u root -p drop planhouse-broke Enter password: Dropping the database is potentially a very bad thing to do. Any data stored in the database will be destroyed. Do you really want to drop the 'planhouse-broke' database [y/N] y mysqladmin: drop of 'planhouse-broke' failed; error: 'Error dropping database (can't rmdir './planhouse-broke', errno: 39)' [root@host:mysql]# perror 39 Directory not empty -- It seems I can not drop the database using the MySQL commands (neither from the client or from an external MySQL program). However, I can simply bring mySQL down and rm -rf the 'planhouse-broke' dir and restart MySQL. Seems to me there is something wrong though. - Johnny Withers [EMAIL PROTECTED] p. 601.853.0211 c. 601.954.9133 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Starting MySQL
Hi, I'm fairly new to MySQL and unix. I have installed mysql on redhat 6.2 without too many problems. I am changing my o/s to FreeBSD 4.2 and have installed mysql after many hours of grief. I have mysql set to start at boot time and this seems to work well. The problem I have is that I can't access the server from the command prompt without using the full path to mysql (ie /usr/local/mysql/bin/mysql). Any help would be greatly appreciated. Dwayne [EMAIL PROTECTED]
SQL query problem with mysql.
hi, i'm writing a book (wrox publishers) which uses mysql for the sample database. i seem to have encountered a problem with an SQL query. its a simple voting application, with a candidate table, and a vote table: create table candidate ( candidatenumber integer not null auto_increment, firstname varchar(32) not null, lastname varchar(32) not null, politicalparty varchar(32) not null, primary key(candidatenumber)); create table votes ( votenumber integer not null auto_increment, candidatenumber integer, countynumber integer, primary key(votenumber), foreign key(candidatenumber) references candidate, foreign key(countynumber) references county); i want to do a query that shows firstname, lastname, the number of votes for that guy, and the total number of votes cast as illustrated: George, Bush, 2, 10 Al, Gore, 2, 10 Pat, Buchannan, 1, 10 Ralph, Nader, 5, 10 for example ralph nader received 5 votes out of a total of 10 cast. Al gore received 2 votes out of 10 ... you get the idea. here is my query: SELECT Candidate.FIRSTNAME, Candidate.LASTNAME, count(Votes.VoteNumber) , count(select * from Votes) FROM Candidate LEFT OUTER JOIN Votes ON Candidate.CANDIDATENUMBER = Votes.CANDIDATENUMBER GROUP BY Candidate.FIRSTNAME, Candidate.LASTNAME everything works except for the nasty count(select (*) from votes) which seems to work on other db's. if i take it away then it works fine. any ideas on how i could obtain a count of the number of votes cast? thank you for your consideration. Larry Kim [EMAIL PROTECTED] [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: synopsis of the problem (one line)
Jonathan Dugan wrote: your documentation is simply wrong. NONE OF THE USER PERMISSION materal makes sense. I am read ing here http://www.mysql.com/doc/D/e/Default_privileges.html and http://www.mysql.com/doc/A/d/Adding_users.html and I follow what is says: shell mysql -u root mysql ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) whatever. any suggestions please send them to dugan@bowser I'm running Linux 2.2.17 rpm version of MySQL: MySQL-3.22.25-1.i386.rpm MySQL-client-3.22.25-1.i386.rpm The Online documentation represents the most current version of mysql as you are trying to use an old version you should look at the documentation distributed with the version you have... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: trying to install on RedHat 7.0 and need help
Charles, you need to be more descriptive about exactly what problem you're having. Spell out your hardware, OS, MySQL version, etc., and describe what isn't working. Charles L. Hagen [[EMAIL PROTECTED]] wrote: I cannot seem to get this database program to work correctly. I am asking for any help I can get. I need to start this asap. Charles Hagen [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
Feature Request: replicate-ignore-table for Master *before* killing updatelog!
Hi, it would be nice to have a replicate-ignore-table for the Master also! It works fine, but if one has to replicate only certain tables of a db it would be good to have this. It is not enough to have this on slave only, because we do not want to send the data of whole databases across the network for security reasons! If you follow this thought you might get the idea that it would be in general useful to set up as many binlogs as one needs! We are doing "manual" replication using update-log this way: Read update-log - extract only needed data - send data to second server. Of course this would not work with binlog, because we do not know how to extract the lines we want from binlog. Is there a closer documentation of the binlog-format? What do you think about? Please ask if it something was not clear. Thanks for your attention. Have a nice thread, Peter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
phpMyAdmin equivalent
Hello All, Was wonder if any knows of a Perl equivalent to the PHP's version of phpMyAdmin?? We use phpMyAdmin but have a project that server doesn't have PHP installed, and frankly, to lazy to do all the typing thru telnet session! :) TIA, Mickalo Mike(mickalo)Blezien Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225) 686-2002 = - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
encrypting a column
I have a column in my maildb table that I need to encrypt using the Password feature. The users and the passwords are stored in another table in the database, I would like to just rip them out of the non-encrypted fields (radcheck.UserName, and radcheck.Value) and place them into the maildb.Username, and (encrypted) into maildb.passwd. I have a text file that contains the user and passes but I have had no success in getting a bash script to work either. Any suggestions would be appreciated. David - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
C API problem
dear Sir : MySQL 3.22 on my linux 486 PC seems work so good. when I compile a simple C API program which catched from the MySQL tutorial, it chokes at the end of compile process . the program is as follows: #include stdio.h #include mysql.h #define def_host_name NULL #define def_user_name NULL #define def_password NULL #define def_db_name NULL MYSQL *conn; int main(int argc,char *argv[]) { conn=mysql_init(NULL); mysql_real_connect( conn, def_host_name, def_user_name, def_password, def_db_name, 0, /*port defaut*/ NULL, /*socket default*/ 0);/*flag*/ mysql_close(conn); exit(0); } I compile as follows: gcc -o client my_simplest_prog -I/home/MySQL/MySQL/include \ -L/home/MySQL/MySQL/lib \ -lmysqlclient then I get : /home/MySQL/MySQL/lib/libmysqlclient.a(my_open.o)In function 'my_open': my_open.o(.text+0x14):undefined reference to 'open64' /home/MySQL/MySQL/lib/libmysqlclient.a(mf_format.o)In function 'fn_format': mf_format.o(.text+0x201):undefined reference to '__lxstat64' /home/MySQL/MySQL/lib/libmysqlclient.a(my_open.o)In function 'my_open': my_open.o(.text+0x21):undefined reference to 'fopen64' nothing left to do with the situation, I beg your help. anyway I'm a newcomer. thank you very much. please send message to [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
Match Records
I`m trying to find the best method to match records between two tables in a MySQL database. But it must match atleast once, so here is a scenario for you to think about. Member - Job, Salary, Location Jobs - Job, Salary, Location All values will be enum sets in both tables as follows Job = enum 'developer','designer','none' Salary = enum '10K','15K','none' Location = enum 'usa','uk','none' Ok so the user has come to the site and I have his Job Salary and Location stored, he clicks a link which then performs the search. His values are as follows.. Job = developer, Salary = 10K, Location = uk I want to search the Jobs table and match it with the above, this part I can do. The next stage is if it doesn`t find any matches it then finds the nearest. So if the only record I have in the Jobs table is as follows Job = developer, Salary = none, Location = uk How do I go about making it pick up the nearest. At the moment I am using SELECT * FROM Jobs where Job='$Job' and Salary='$Salary' and Location='$Location' So obviously it won`t match them, anyone wake me up from my slumber and help me out with this? Cheers Ade - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
African American History Minute
February 1, 2001 marks the start of the African American History Minute Webcast tour. The tour will visit more than 150 historically significant African American locations across the country and make them available to you via streaming video. Absolutely Free In addition to providing video clips, the site features an index of African American Newspapers other interesting links across the country. Chat with other African Americans who are interested in their heritage Every night at 9 Eastern we have a live chat with like-minded African Americans who share their ideas and oppinions with the group. Tell a friend about the site! To join click the link below: A HREF="http://africanamericanminute.com/"http://africanamericanminute.com//A It's a great educational resource! ~ We never intend to spam - To be removed from our mailing list respond entering Delete in the subject box. ~~
RE: Just Checking
ping! -Original Message- From: Quentin Bennett [mailto:[EMAIL PROTECTED]] Sent: 05 March 2001 03:04 To: MySQL (E-mail) Subject: Just Checking Hi, I someone sees this, can they respond, because I have received nothing from the list for 30 hours +. It's now 16:00 NZ Time, 03:00 GMT on Monday 5th March Thanks Quentin Bennett Transport Systems Division Infinity Solutions web http:\\www.infinity.co.nz mailto:[EMAIL PROTECTED] Phone : +64 9 358 9720 Fax : +64 9 309 4142 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php ** 'The information included in this Email is of a confidential nature and is intended only for the addressee. If you are not the intended addressee, any disclosure, copying or distribution by you is prohibited and may be unlawful. Disclosure to any party other than the addressee, whether inadvertent or otherwise is not intended to waive privilege or confidentiality' ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Recursive queries
Well, if you have everything setup right.. this is easy to do in SQL. Lets say you have your root table: create table root( id integer unsigned not null auto_increment, description varchar(50), key root_key (id) ); and your sub categories: create table subcats( id integer unsigned not null auto_increment, root_id integer unsigned not null, description varchar(50), key subcat_key (id) ); and your final category: create table subsections( id integer unsigned not null auto_incremnt, parent_id integer unsigned not null, description varchar(50), key subsec_key (id) ); now you can simply join all these tables.. SELECT subsection.description,subcats.description,root.description FROM subsection,subcats,root WHERE ( (subcats.root_id=root.id) AND (subsections.parent_id=subcats.id) AND (root.id=N) ); (where N is the root.id number you are looking for) that way, in root you could have 'Sports' In subcats you would have 'Sports Equipment', 'Sports Stories', etc.. in subsection, you could have 'Golf Clubs' etc.. and so on or you could divide it up more and go from Sports Equipment, to Golf to Golf Equipment.. hope this helps.. - Johnny Withers [EMAIL PROTECTED] p. 601.853.0211 c. 601.954.9133 -Original Message- From: Isaac Force [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 04, 2001 5:03 PM To: [EMAIL PROTECTED] Subject: Recursive queries Quick searches of Google and the MySQL page didn't turn up anything, so I'll ask here.. Here's what I have: I have a table that among others, have fields called 'section_id' and 'parent_id'. The section_id is the id of the "self" section, and the parent_id is the id of the section that "owns" the self section. (It's sort of like a filesystem where one directory has subdirectories, and so on) Here's what I'm trying to do: I want to start with one section, and go down the tree of sub-sections, picking up information about them on the way. Example: I want to start at the "root" section, and follow down one of it's sub-sections. (Root) | |--- Sports Products || ||--- Golf :: Item1, Item2, Item3, Item4 || ||--- Fishing :: Item5, Item6, Item7, Item8 So it will start at Root, find that Sports Products is attached to Root, get the information I want from Sports Products, then it will find that Golf and Fishing are attached to Sports Products, and get the information from them respectively. (And so on) As it stands, it won't go any further than 2 levels deep from the root section, so I won't need to find a more effecient way to organize the relationships for now. What do you all feel would be the best way to do this? -- Isaac Force [EMAIL PROTECTED] (503)656-2489 http://gorgonous.dhs.org Real Users find the one combination of bizarre input values that shuts down the system for days. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Can anyone help with this please?
Robb Exact error messages would be good at this point and it may be possible that their version of MySQL may not fully support the command you are trying to perform although with an UPDATE TABLE I would hope this unlikely. I think you probably need to provide:- SQL statement you are trying to execute that you think is causing the problem URL to the script trying to do the job Exact error that you are getting My first guess is something about the export of the Access DB is screwing up or set to read only or somehow the grant permissions are screwing up, but that really is just crystal ball gazing without some more info. If you have any possibility at all of using personal web server of better still NT/2000 to test on your own box then I think that would be ideal, but lets see what we can do with some more detail. Andy - Original Message - From: "Robb Meade" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, March 03, 2001 6:23 PM Subject: Can anyone help with this please? Hi there... Very new to Databases I have been learning ASP over the last few months and have no come to start using databases My web host is WebFusion, who use a MySQL system for their database, where as I at home use MS Access2000... I've got it all set up so that I can export from home to the server and it updates the database, and also I've got a test page that allows you to enter some info and it updates the database from the web - so that side of things is kinda working... I've added a table this evening, as I wanted to set up a special one for people who register on my site, I've come across a couple of problems, and I'm not sure what to do... 1) Once I've exported the table, I dont seem to be able to change the structure of it, ie add more fields, or remove some, or what ever, I just get an error if I try... 2) Fields set to 'autonumber' and 'yes/no - true/false etc' are changed to 'number'... 3) I dont seem to be able to remove a table from the databaseso now I'm getting loads as I'm testing stuff, and i want to remove them... If anyone can help me at all I'd be very greatful, I appreciate this is probably not quite the usual sort of question you get here... Oh, and as I'm kinda new to this, if you could explain things kinda 'newbie' clearly, that would be great :) Thanks in advance for any help Respectfully Robb Meade - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: new to Linux release of MySQL
An RPM installation indicates that you might be installing on some version of Linux. Could you specify the platform, the operating system, the Mysql release Number so that people with the experiece that you need will able to respond. My experiece is with SusE Linux 7.0 and release Mysql-3.23.32-1 but I do not know if that matches your requirements. "Charles L. Hagen" wrote: Can anyone email who knows how to set up MySQL? I attempted an RPM install and am having troubles. E-mail me at [EMAIL PROTECTED] if you can help. Charles Hagen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: trying to install on RedHat 7.0 and need help
OK, here is the story. I have a PII Linux RedHat 7.0 server. I installed the Mysql package that comes with it and also the dependent applications as specified. I try to start the mysqld and it gives me an OK and then I status it and it says mysqld dead but subsys locked I am asking for two things First, after the RPM installation what am I supposed to do? Second, how do I get it to run and build my first database? The error message log file is printed out below: 010302 14:05:32 mysqld started 010302 14:05:32 Can't start server: Bind on TCP/IP port: Address already in use 010302 14:05:32 Do you already have another mysqld server running on port: 3306 ? 010302 14:05:32 Aborting 010302 14:05:32 mysqld ended 010302 14:21:51 mysqld started 010302 14:21:51 Can't start server: Bind on TCP/IP port: Address already in use 010302 14:21:51 Do you already have another mysqld server running on port: 3306 ? 010302 14:21:51 Aborting 010302 14:21:51 mysqld ended 010302 14:25:39 mysqld started 010302 14:25:39 Can't start server: Bind on TCP/IP port: Address already in use 010302 14:25:39 Do you already have another mysqld server running on port: 3306 ? 010302 14:25:39 Aborting 010302 16:43:15 mysqld started 010302 16:43:15 Can't start server: Bind on TCP/IP port: Address already in use 010302 16:43:15 Do you already have another mysqld server running on port: 3306 ? 010302 16:43:15 Aborting 010302 16:43:15 mysqld ended 010302 16:43:26 mysqld started 010302 16:43:26 Can't start server: Bind on TCP/IP port: Address already in use 010302 16:43:26 Do you already have another mysqld server running on port: 3306 ? 010302 16:43:26 Aborting 010302 16:43:26 mysqld ended 010302 16:49:19 mysqld started 010302 16:49:19 Can't start server: Bind on TCP/IP port: Address already in use 010302 16:49:19 Do you already have another mysqld server running on port: 3306? 010302 16:49:19 Aborting 010302 16:49:19 mysqld ended 010302 16:51:22 mysqld started 010302 16:51:22 Can't start server: Bind on TCP/IP port: Address already in use 010302 16:51:22 Do you already have another mysqld server running on port: 3306 ? 010302 16:51:22 Aborting 010302 16:51:22 mysqld ended 010302 16:59:38 mysqld started 010302 16:59:38 Can't start server: Bind on TCP/IP port: Address already in use 010302 16:59:38 Do you already have another mysqld server running on port: 3306 ? 010302 16:59:38 Aborting 010302 16:59:38 mysqld ended 010302 16:59:51 mysqld started 010302 16:59:51 Can't start server: Bind on TCP/IP port: Address already in use 010302 16:59:51 Do you already have another mysqld server running on port: 3306 ? 010302 16:59:51 mysqld ended 010302 17:00:06 mysqld started 010302 17:00:07 Can't start server: Bind on TCP/IP port: Address already in use 010302 17:00:07 Do you already have another mysqld server running on port: 3306 ? 010302 17:00:07 Aborting 010302 17:00:07 mysqld ended 010302 17:00:08 mysqld started 010302 17:00:08 Can't start server: Bind on TCP/IP port: Address already in use 010302 17:00:08 Do you already have another mysqld server running on port: 3306 ? 010302 17:00:08 Aborting 010302 17:00:08 mysqld ended 010302 17:00:47 mysqld started 010302 17:00:47 Can't start server: Bind on TCP/IP port: Address already in use 010302 17:00:47 Do you already have another mysqld server running on port: 3306? 010302 17:00:47 Aborting 010302 17:00:47 mysqld ended 010303 20:36:33 mysqld started 010303 20:36:34 /usr/libexec/mysqld: Can't create/write to file '/var/run/mysql d.pid' (Errcode: 13) 010303 20:36:34 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno : 13) 010303 20:36:34 /usr/libexec/mysqld: Error on delete of '/var/run/mysqld.pid' ( Errcode: 2) 010303 20:36:34 mysqld ended 010303 20:36:41 mysqld started 010303 20:36:41 /usr/libexec/mysqld: Can't create/write to file '/var/run/mysql d.pid' (Errcode: 13) 010303 20:36:41 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno : 13) 010303 20:36:41 /usr/libexec/mysqld: Error on delete of '/var/run/mysqld.pid' ( Errcode: 2) 010303 20:36:41 mysqld ended Fatal error: Can't change to run as user 'mysqld' ; Please check that the user exists! 010303 21:33:51 Aborting 010303 21:33:51 mysqld ended 010303 21:52:46 mysqld started 010303 21:52:46 /usr/libexec/mysqld: Can't create/write to file '/var/run/mysql d.pid' (Errcode: 13) 010303 21:52:46 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno : 13) 010303 21:52:46 /usr/libexec/mysqld: Error on delete of '/var/run/mysqld.pid' ( Errcode: 2) 010303 21:52:46 mysqld ended 010303 21:59:54 mysqld started Warning: One can only use the --user switch if running as root 010303 21:59:54 /usr/libexec/mysqld: Can't create/write to file '/var/run/mysql d.pid' (Errcode: 13) 010303 21:59:54 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno : 13) 010303 21:59:54 /usr/libexec/mysqld: Error on
Re: synopsis of the problem (one line)
on 3/3/01 4:54 PM, Jonathan Dugan at [EMAIL PROTECTED] wrote: and I follow what is says: shell mysql -u root mysql ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) It sounds like you've _already_ set a root password, so you need to specify it: mysql -u root -p With the -p parameter it will prompt you for a password on stdin. Supply the root password and you should be in. If you don't specify -p on the command line, it assumes you are attempting to gain access without a password, and your security isn't set up to allow this. This is a bit confusing at first... But the security model in mysql is really very elegant once you understand what's going on... Hope this helps, Geoff - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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)
Greetings Jonathan, There are a couple of ways that you can add a user. the best way is to grant that user permissions on an existing database. If the user does not exist then it will be created. That's the way I do it because then I don't have to beg my ISP for insert/update permissions on the mysql database. I'm not sure how to delete a user this way, maybe someone can chime in and help us both out. If you have CrUD permissions on the mysql database then you can add the users manually by inserting them into the user table in the mysql database. Since I've not delved into the complexities of the host table and the db table, I don't usually do it this way. But you can do it, just remember to FLUSH PRIVILEGES when done or the changes won't take effect. (Which usually has the effect of driving you insane until you remember to do it.) I've worked with MS SQL and Oracle (just a little bit, not much) and I can say that once I understood how to do it, I really like it. Have you looked at one of the GUIs, Webmin or phpMyAdmin? HTH, Cal http://www.calevans.com -Original Message- From: Jonathan Dugan [mailto:[EMAIL PROTECTED]] Sent: Saturday, March 03, 2001 5:33 PM To: [EMAIL PROTECTED] Subject: synopsis of the problem (one line) Description: Unclear documentation on how user permissions work. I've been using databases for about a year and have experience with Postgres and Oracle. How do I add a new user?? How do permission work?? I've spent an hour now and I still get: ERROR 1044: Access denied for user: '@localhost' to database 'mysql' How-To-Repeat: Install MySQL. Fix: Better documentation. Submitter-Id: submitter ID Originator:Jonathan Dugan Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category: mysql Class: Release: mysql-3.22.25 (Source distribution) Server: /usr/bin/mysqladmin Ver 7.11 Distrib 3.22.25, for pc-linux-gnu on i686 TCX Datakonsult AB, by Monty Server version 3.22.25 Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 16 sec Threads: 1 Questions: 1 Slow queries: 0 Opens: 6 Flush tables: 1 Open tables: 2 Environment: System: Linux iscb.stanford.edu 2.2.16-3smp #1 SMP Mon Jun 19 19:00:35 EDT 2000 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) Compilation info: CC='egcs' CFLAGS='-O6 -fomit-frame-pointer' CXX='egcs' CXXFLAGS='-O6 -fomit-frame-pointer-felide-constructors -fno-exce ptions -fno-rtti' LDFLAGS='' Configure command: ./configure --enable-shared --enable-assembler --with-mysqld-user=mysql --w ith-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstated ir=/var/lib/mysql --infodir=/usr/info --includedir=/usr/include --mandir=/us r/man Perl: This is perl, version 5.005_03 built for i386-linux - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Limiting to specific field value of type float
Alec Exact matches on float values are notoriously unreliable - the problem with the math is that it can often turn out the value at something like :- 123.539 which won't produce an equality match. For this you would probably better use a DECIMAL field. Andy - Original Message - From: "Alec Solway" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, March 03, 2001 6:51 PM Subject: Limiting to specific field value of type float Hi, I'm having some trouble with the following: I have a sample table that has one record where price == 123.54, however select * from gpl where price=123.54 returns an empty set. If I set price to an integer value that's also in the table, it works. e.g. select * from gpl where price=500 returns the proper results. price is a column of type float. TIA. Alec Solway - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Limiting to specific field value of type float
On Sat, 03 Mar 2001 19:51:04 -0500, Alec Solway [EMAIL PROTECTED] wrote: Try using DECIMAL, this works best for monetary values in my experience. I'm having some trouble with the following: I have a sample table that has one record where price == 123.54, however select * from gpl where price=123.54 returns an empty set. If I set price to an integer value that's also in the table, it works. e.g. select * from gpl where price=500 returns the proper results. price is a column of type float. TIA. Alec Solway - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Mike(mickalo)Blezien Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225) 686-2002 = - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
BDB tables on Linux
I've installed 3.23.33 on both Solaris and Linux RH 6.2 using the tarball for Solaris and the RPM for Linux. The BDB tables work as expected on Solaris, but they did not not work under Linux. What I'm seeing is that I can create a BDB just fine. However, attempting a rollback results in: ERROR 1196: Warning: Some non-transactional changed tables couldn't be rolled back When I do a mysqldump, the ddl for the table shows a type of MyISAM. I've seen posts in the mail-list that people have used BDB tables under Linux, so I know they should work. I read the installation notes and did not see anything special about post-installation for Linux and BDB support. I found in the documentation that the binary version for Windows does not have BDB tables pre-compiled in, but did not find a similar note regarding Linux. Is there something I need to do (short of building from source) to get BDB tables to work under Linux? Thanks Stephen L. Faustino Senior Software Engineer SecureLogix Corporation Direct/Vmail (210)402-9669x949 mailto:[EMAIL PROTECTED] This email is intended for the named recipient(s) only and may contain information that is privileged and/or confidential. Nothing in this email is intended to constitute a waiver of any privilege or the confidentiality of this message. If you have received this email in error, please notify me immediately by reply and delete this message. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 + AUTO_INCREMENT
check the archive, someone answered that one this weekend. Cal http://www.calevans.com -Original Message- From: Joris Kluivers [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 04, 2001 5:56 AM To: [EMAIL PROTECTED] Subject: insert + AUTO_INCREMENT hi, i have a problem i have a database table created with the statement: CREATE TABLE chatmessages (id tinyint(6) DEFAULT '0' NOT NULL AUTO_INCREMENT, message text, username varchar(100), UNIQUE id (id); I insert records with: INSERT INTO chatmessages (message, username) VALUES ('this is my message', 'joris'); this works fine (for a while), i can insert messages and retreive them with php. But after some time i get the error: ERROR 1062: Duplicate entry '127' for key 1 but how can this be because i've set it to AUTO_INCREMENT. can someone help me? thanks in advance Joris Kluivers - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 + AUTO_INCREMENT
Joris Kluivers wrote: hi, i have a problem i have a database table created with the statement: CREATE TABLE chatmessages (id tinyint(6) DEFAULT '0' NOT NULL AUTO_INCREMENT, message text, username varchar(100), UNIQUE id (id); I insert records with: INSERT INTO chatmessages (message, username) VALUES ('this is my message', 'joris'); this works fine (for a while), i can insert messages and retreive them with php. But after some time i get the error: ERROR 1062: Duplicate entry '127' for key 1 but how can this be because i've set it to AUTO_INCREMENT. Using field type TINYINT for the id isn't a good idea, because the value range for this field type is -128 to 127. So is you have more than 128 records, there are no ids left. AUTO_INCREMNT starts at 0. Robert - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 + AUTO_INCREMENT
Because TINYINT has a MAX VALUES of 127 pre the mysql docs: TINYINT[(M)] [UNSIGNED] [ZEROFILL] A very small integer. The signed range is -128 to 127. The unsigned range is 0 to 255. if you unsign the column, you can get to 255 I would use something larger, because you will have more than 255 messages (hopefully). use an unsigned integer CREATE TABLE chatmessages (id INT UNSIGNED DEFAULT '0' NOT NULL AUTO_INCREMENT, message text, username varchar(100), UNIQUE id (id); this will allow for 4,294,967,295 messages. -Original Message- From: Joris Kluivers [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 04, 2001 5:56 AM To: [EMAIL PROTECTED] Subject: insert + AUTO_INCREMENT hi, i have a problem i have a database table created with the statement: CREATE TABLE chatmessages (id tinyint(6) DEFAULT '0' NOT NULL AUTO_INCREMENT, message text, username varchar(100), UNIQUE id (id); I insert records with: INSERT INTO chatmessages (message, username) VALUES ('this is my message', 'joris'); this works fine (for a while), i can insert messages and retreive them with php. But after some time i get the error: ERROR 1062: Duplicate entry '127' for key 1 but how can this be because i've set it to AUTO_INCREMENT. can someone help me? thanks in advance Joris Kluivers - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: C API problem
john1 wrote: dear Sir : MySQL 3.22 on my linux 486 PC seems work so good. when I compile a simple C API program which catched from the MySQL tutorial, it chokes at the end of compile process . the program is as follows: #include stdio.h #include mysql.h #define def_host_name NULL #define def_user_name NULL #define def_password NULL #define def_db_name NULL MYSQL *conn; int main(int argc,char *argv[]) { conn=mysql_init(NULL); mysql_real_connect( conn, def_host_name, def_user_name, def_password, def_db_name, 0, /*port defaut*/ NULL, /*socket default*/ 0);/*flag*/ mysql_close(conn); exit(0); } I compile as follows: gcc -o client my_simplest_prog -I/home/MySQL/MySQL/include \ -L/home/MySQL/MySQL/lib \ -lmysqlclient then I get : /home/MySQL/MySQL/lib/libmysqlclient.a(my_open.o)In function 'my_open': my_open.o(.text+0x14):undefined reference to 'open64' /home/MySQL/MySQL/lib/libmysqlclient.a(mf_format.o)In function 'fn_format': mf_format.o(.text+0x201):undefined reference to '__lxstat64' /home/MySQL/MySQL/lib/libmysqlclient.a(my_open.o)In function 'my_open': my_open.o(.text+0x21):undefined reference to 'fopen64' nothing left to do with the situation, I beg your help. anyway I'm a newcomer. thank you very much. please send message to [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 You missing -lz in the list of gcc options. Regards, Boulat -- Nothing Like the Sun - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: SQL query problem with mysql.
I would make the select statement look like this SELECT Candidate.FIRSTNAME, Candidate.LASTNAME, count(Votes.VoteNumber) , count(select votenumber from Votes) FROM Candidate LEFT OUTER JOIN Votes ON Candidate.CANDIDATENUMBER = Votes.CANDIDATENUMBER GROUP BY Candidate.FIRSTNAME, Candidate.LASTNAME By doing this you are using less resources the SQL server. Usually whenever you do any select statement the sql engine will go retrieve all of the rows you specify, even in a count. This will cause the SQL enginge to get every row in this table. I also remember hearing someone mention that with MySQL it is generally not a good idea to do a query with an (*) in it because it could produce speratic data. So by doing a count on a particular column this would alleviate that problem. Aaron Weiker Programmer CISP - Changing Internet Speed Performance Phone: 419.724.5351 [EMAIL PROTECTED] Pager: 419.218.0013 http://www.cisp.cc Cell:419.304.0323 web search: http://www.allthesites.com -Original Message- From: Larry Kim [mailto:[EMAIL PROTECTED]] Sent: Monday, March 05, 2001 4:55 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: SQL query problem with mysql. hi, i'm writing a book (wrox publishers) which uses mysql for the sample database. i seem to have encountered a problem with an SQL query. its a simple voting application, with a candidate table, and a vote table: create table candidate ( candidatenumber integer not null auto_increment, firstname varchar(32) not null, lastname varchar(32) not null, politicalparty varchar(32) not null, primary key(candidatenumber)); create table votes ( votenumber integer not null auto_increment, candidatenumber integer, countynumber integer, primary key(votenumber), foreign key(candidatenumber) references candidate, foreign key(countynumber) references county); i want to do a query that shows firstname, lastname, the number of votes for that guy, and the total number of votes cast as illustrated: George, Bush, 2, 10 Al, Gore, 2, 10 Pat, Buchannan, 1, 10 Ralph, Nader, 5, 10 for example ralph nader received 5 votes out of a total of 10 cast. Al gore received 2 votes out of 10 ... you get the idea. here is my query: SELECT Candidate.FIRSTNAME, Candidate.LASTNAME, count(Votes.VoteNumber) , count(select * from Votes) FROM Candidate LEFT OUTER JOIN Votes ON Candidate.CANDIDATENUMBER = Votes.CANDIDATENUMBER GROUP BY Candidate.FIRSTNAME, Candidate.LASTNAME everything works except for the nasty count(select (*) from votes) which seems to work on other db's. if i take it away then it works fine. any ideas on how i could obtain a count of the number of votes cast? thank you for your consideration. Larry Kim [EMAIL PROTECTED] [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: SQL query problem with mysql.
I think you really need another couple tables, even though your just writing a sample. You probably need a table named 'election' and one named 'electionparticipants' Your election table would contain things like the date of the election, the total number of votes cast, etc. The electionparticipants table would be a simple join table between candidate and election. Without those two tables, you're going to have some issues trying to do what you want. - Original Message - From: "Larry Kim" [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, March 05, 2001 3:54 AM Subject: SQL query problem with mysql. hi, i'm writing a book (wrox publishers) which uses mysql for the sample database. i seem to have encountered a problem with an SQL query. its a simple voting application, with a candidate table, and a vote table: create table candidate ( candidatenumber integer not null auto_increment, firstname varchar(32) not null, lastname varchar(32) not null, politicalparty varchar(32) not null, primary key(candidatenumber)); create table votes ( votenumber integer not null auto_increment, candidatenumber integer, countynumber integer, primary key(votenumber), foreign key(candidatenumber) references candidate, foreign key(countynumber) references county); i want to do a query that shows firstname, lastname, the number of votes for that guy, and the total number of votes cast as illustrated: George, Bush, 2, 10 Al, Gore, 2, 10 Pat, Buchannan, 1, 10 Ralph, Nader, 5, 10 for example ralph nader received 5 votes out of a total of 10 cast. Al gore received 2 votes out of 10 ... you get the idea. here is my query: SELECT Candidate.FIRSTNAME, Candidate.LASTNAME, count(Votes.VoteNumber) , count(select * from Votes) FROM Candidate LEFT OUTER JOIN Votes ON Candidate.CANDIDATENUMBER = Votes.CANDIDATENUMBER GROUP BY Candidate.FIRSTNAME, Candidate.LASTNAME everything works except for the nasty count(select (*) from votes) which seems to work on other db's. if i take it away then it works fine. any ideas on how i could obtain a count of the number of votes cast? thank you for your consideration. Larry Kim [EMAIL PROTECTED] [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Some questions on indexes.
Hello Is there a place or book where a newbie can gather information on indexes? Section 12.4 of the manual is your friend. "EXPLAIN SELECT foo" will tell you what indexes are used in doing your "foo" query. cheers -- TS - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 needs help
Hello Please excuse my ignorance, I am very, very new to databases and escpecially MySql. I have a couple of questions that I would be most grateful if someone could answer for me. 1. I have a Cobalt Raq4 with mysql 3.22.32 installed. I also have a Win98 machine with 3.23.33 installed. I have managed to set up a simple test db on my windows machine and pull out data with ASP, using PWS. I have also managed to set up a simple db on the Raq but have noticed that the database file extensions are different. The raq has .ISD, .ISM and .FRM where as the windows box has .MYD, .MYI and .FRM. Does this mean that I can't design the DB on my windows box and upload it to work on the Raq? If it can be done can someone please advise me on how to do this. 2. I don't seem to be able to make a connection using the ASP admin pages on the Raq. I keep getting "can't open connection". Can someone enlighten me please, I have followed the instructions very closely. It seems that everything on the Raq is different to what is stated in the MySql manual? i.e running mysqld gives me command not found but it will run with safe_mysqld, the data is stored in a different dir etc. I am sorry if I am being simple but all I want to do is set up a basic site that will get info from a db using chilisoft ASP. I thank you in advance and once again please excuse my ignorance. Best Regards Lee - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Starting MySQL
Please add /usr/local/mysql/bin in your PATH. dwayne I'm fairly new to MySQL and unix. I have installed mysql on redhat 6.2 without too many problems. I am changing my o/s to FreeBSD 4.2 and have installed mysql after many hours of grief. I have mysql set to start at boot time and this seems to work well. The problem I have is that I can't access the server from the command prompt without using the full path to mysql (ie /usr/local/mysql/bin/mysql). Any help would be greatly appreciated. dwayne dwayne Dwayne dwayne dwayne [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: phpMyAdmin equivalent
"MikeBlezien" wrote: Hello All, Was wonder if any knows of a Perl equivalent to the PHP's version of phpMyAdmin?? We use phpMyAdmin but have a project that server doesn't have PHP installed, and frankly, to lazy to do all the typing thru telnet session! :) MysqlTool Looks pretty good http://dajoba.com/projects/mysqltool/ Greg TIA, Mickalo Mike(mickalo)Blezien Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225) 686-2002 = - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: C API problem
Hi, Check for open64 in the archives for the last month, and you will find your answer (which is to upgrade your gcc). Regards Quentin -Original Message- From: john1 [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 6 March 2001 4:47 a.m. To: [EMAIL PROTECTED] Subject: C API problem dear Sir : MySQL 3.22 on my linux 486 PC seems work so good. when I compile a simple C API program which catched from the MySQL tutorial, it chokes at the end of compile process . the program is as follows: #include stdio.h #include mysql.h #define def_host_name NULL #define def_user_name NULL #define def_password NULL #define def_db_name NULL MYSQL *conn; int main(int argc,char *argv[]) { conn=mysql_init(NULL); mysql_real_connect( conn, def_host_name, def_user_name, def_password, def_db_name, 0, /*port defaut*/ NULL, /*socket default*/ 0);/*flag*/ mysql_close(conn); exit(0); } I compile as follows: gcc -o client my_simplest_prog -I/home/MySQL/MySQL/include \ -L/home/MySQL/MySQL/lib \ -lmysqlclient then I get : /home/MySQL/MySQL/lib/libmysqlclient.a(my_open.o)In function 'my_open': my_open.o(.text+0x14):undefined reference to 'open64' /home/MySQL/MySQL/lib/libmysqlclient.a(mf_format.o)In function 'fn_format': mf_format.o(.text+0x201):undefined reference to '__lxstat64' /home/MySQL/MySQL/lib/libmysqlclient.a(my_open.o)In function 'my_open': my_open.o(.text+0x21):undefined reference to 'fopen64' nothing left to do with the situation, I beg your help. anyway I'm a newcomer. thank you very much. please send message to [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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Date/Time difference
Hello, I'm reading this list for some time and checked the FAQ, archive but i haven't found any hints ... I have an own written app which is using a 'kind of database' to calculate the difference between two (or more) events which can happen between tens or hundreds of seconds. Now i want to switch to a real database but i'm unable to find a database function to calculate the difference between (for example '2001-03-05- 20:09:10.54' and '2001-03-05 20:11:34.36') of two events with a 'factional' time. I've tried something like INSERT INTO t_start, t_stop VALUES (UNIX_TIMESTAP(now() + 0.54) , UNIX_TIMESTAMP(now() + 0.38) but this is not working for a 'DATETIME' field, a 'FLOAT' field returns 0. The difference between the two times is very critical because the app is written for sports events ... Maybe someone uses MySQL within such an application and has can provide some hints Andreas Karl Wittwer Phone: +49-7052-92206 FAX: +49-7052-92208 Mobil: +49-172-542 541 4 [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: Just Checking
Hello -Original Message- From: Jon Haworth [mailto:[EMAIL PROTECTED]] Sent: Monday, March 05, 2001 11:09 AM To: 'Quentin Bennett'; MySQL (E-mail) Subject: RE: Just Checking ping! -Original Message- From: Quentin Bennett [mailto:[EMAIL PROTECTED]] Sent: 05 March 2001 03:04 To: MySQL (E-mail) Subject: Just Checking Hi, I someone sees this, can they respond, because I have received nothing from the list for 30 hours +. It's now 16:00 NZ Time, 03:00 GMT on Monday 5th March Thanks Quentin Bennett Transport Systems Division Infinity Solutions web http:\\www.infinity.co.nz mailto:[EMAIL PROTECTED] Phone : +64 9 358 9720 Fax : +64 9 309 4142 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php ** 'The information included in this Email is of a confidential nature and is intended only for the addressee. If you are not the intended addressee, any disclosure, copying or distribution by you is prohibited and may be unlawful. Disclosure to any party other than the addressee, whether inadvertent or otherwise is not intended to waive privilege or confidentiality' ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Summer of 2001
March 5, 2001 Dear Prospective Colleague, I will be deeply in debt to anyone who helps me find an internship in Chemical Engineering for the summer of 2001. I am a Chemical Engineering student at the Cooper Union in NYC, and I can successfully perform the following scientific assays: Light Microscopy, Spectroscopy (IR/UV/VIS/FT-IR), Gas Chromatography, Mass Spectroscopy, Polarography, HPLC, electrophoresis, ELIZA, and I am familiar with the standard methods of keeping laboratory notebooks and data. I am dedicated to my work, ambitious, and responsible. After doing research for a while in an academic setting, I decided I would like to work for a company this summer. Some of my character traits that will benefit you and your company: Self-motivated - Participating in research from high school, under my own initiative, I have the drive to succeed at my job. My enthusiasm and energy enable me to obtain excellent results. I was offered a full-tuition scholarship and a stipend to continue studying at m y first college - but my commitment to getting the best Chemical Engineering education possible led me to transfer to the Cooper Union. Strong Work Ethic - I work hard to get project done on time, and my professors/supervisors appreciate it. I am detail oriented and thorough, so an assignment is done right the first time. I am accustomed to being focused and prioritizing study and work. I have much more than average scientific work experience for a current undergraduate student. Communication and Interpersonal Skills - Working with different teams of students, and at times with foreign researchers I understand the importance of clear and effective communication, while keeping people involved and willing to help. I am computer literate and familiar with AutoCAD. You will find my completely dedicated to serving your lab and completely dedicated to my work. I am successful at prioritizing and know the value of planning time in order to succeed. Accountable conscientious, loyal and punctual. Can ma ke decision and approach problems creatively and with initiative - based on facts, experience, and research. Details of education, experience and references available, "official" resume available at: http://members.aol.com/vadim0/resume1.htm . I want to learn more about being a chemical engineer and how I can be of help to your company or institution. Please email me at [EMAIL PROTECTED] - even if you would just like to give me advice or share what is on your mind. With the Greatest Appreciation, Vadim Knobel 545 West 8th Ave. #402 New York, NY 10018 (646) 279-4821 [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: Match Records
SELECT with two (or one) of the three fields - probably with loads of OR's after the intial search returns 0 rows. Messy maybe but I don't see any other way. You can't use a SELECT like you are currently using with fields of the same name in different tables - I'm surprised you are not throwing an error at this point unless you are using a web interface that is not error checking. Andy - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, March 05, 2001 10:04 AM Subject: Match Records I`m trying to find the best method to match records between two tables in a MySQL database. But it must match atleast once, so here is a scenario for you to think about. Member - Job, Salary, Location Jobs - Job, Salary, Location All values will be enum sets in both tables as follows Job = enum 'developer','designer','none' Salary = enum '10K','15K','none' Location = enum 'usa','uk','none' Ok so the user has come to the site and I have his Job Salary and Location stored, he clicks a link which then performs the search. His values are as follows.. Job = developer, Salary = 10K, Location = uk I want to search the Jobs table and match it with the above, this part I can do. The next stage is if it doesn`t find any matches it then finds the nearest. So if the only record I have in the Jobs table is as follows Job = developer, Salary = none, Location = uk How do I go about making it pick up the nearest. At the moment I am using SELECT * FROM Jobs where Job='$Job' and Salary='$Salary' and Location='$Location' So obviously it won`t match them, anyone wake me up from my slumber and help me out with this? Cheers Ade - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Sorting and Optimization
I'm working on the following select statement and have a few problems: select if(contact.comp_name, contact.comp_name, concat(contact.first_name, ' ', contact.last_name)) as name, if(substring(radacct.username,1,4) = 'brow', lcase(trim(leading concat(substring_index(radacct.username,'-',1), '-') from radacct.username)), lcase(radacct.username)) as login, account.activated, radacct.acctstarttime from users, contact, account, radius.radacct where radacct.acctstarttime and radacct.acctstoptime and if(substring(radacct.username,1,4) = 'brow', lcase(trim(leading concat(substring_index(radacct.username,'-',1), '-') from radacct.username)), lcase(radacct.username)) = users.username and account.id = users.id and users.owner_id = contact.id group by login order by login, acctstarttime desc; First, the query takes almost a minute to run. Explain shows this: | radacct | ALL| NULL | NULL |NULL | NULL | 470127 | where |used; Using temporary; Using filesort | | users | ref| PRIMARY,username | username | 30 | func | 10 | where |used | | account | eq_ref | PRIMARY | PRIMARY | 3 | users.id | 1 | || | contact | eq_ref | PRIMARY | PRIMARY | 3 | users.owner_id | 1 | || Second, the acctstarttime needs to be the most recent time, and the query returns the oldest. In case it's simpler to start from scratch instead of patching my attempt, here's what I'm working with: contact table: if the comp_name field holds data (Company name), return that. Otherwise, return "first_name last_name". radacct table: username may start with a prefix (always 8 characters in this brow***- format). Return just the portion after the prefix if it exists. return the lastest dial-up start time. account table: return the activation date for the account. My attempts with the various join methods have failed miserably. Any ideas on what I can do to optimize this? If not, I definitely need to have the latest dial-in times (acctstarttime). I remember seeing something on list about sorting on 2 columns, but can't remember enough of the details to find it in the archives. Thanks for any assistance you can offer. -- === Kip Turkphone: 915.234.5678 Systems Administrator or 800.695.9016 Killer of Spam/Writer of Code/Penguin Proponent West Central Net fax: 915.656.0071 === - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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.33 Solaris x86 Problem
Hello, I'm new to mySQL, and I need a binary release for Solaris x86. Unless somebody knows why I can't compile the source. I'm using the GCC compiler version 2.95.2. Here is my configure script: CC=gcc CFLAGS="-O6 -fomit-frame-pointer -DHAVE_CURSES_H" \ CXX=gcc \ CXXFLAGS="-O6 -fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -DHAVE_CURSES_H" \ ../configure --prefix=/usr/local/mysql Here is the error I am getting in the make: In file included from mysql.cc:53: /opt/sfw/include/curses.h:96: declaration does not declare anything *** Error code 1 make: Fatal error: Command failed for target `mysql.o' Current working directory /u3/software/unix/install/mysql-3.23.33/client *** Error code 1 make: Fatal error: Command failed for target `all-recursive' Current working directory /u3/software/unix/install/mysql-3.23.33 *** Error code 1 make: Fatal error: Command failed for target `all-recursive-am' Any help either way would be greatly appreciated. Thanks, Rob - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
scsi vs ide performance on fsync's
Hi! "Jeremy" == Jeremy Hansen [EMAIL PROTECTED] writes: Jeremy We're doing some mysql benchmarking. For some reason it seems that ide Jeremy drives are currently beating a scsi raid array and it seems to be related Jeremy to fsync's. Bonnie stats show the scsi array to blow away ide as Jeremy expected, but mysql tests still have the idea beating on plain insert Jeremy speeds. Can anyone explain how this is possible, or perhaps explain how Jeremy our testing may be flawed? Jeremy Here's the bonnie stats: Jeremy IDE Drive: Jeremy Version 1.00g --Sequential Output-- --Sequential Input- --Random- Jeremy -Per Chr- --Block-- -Rewrite- -Per Chr- --Block-- --Seeks-- Jeremy MachineSize K/sec %CP K/sec %CP K/sec %CP K/sec %CP K/sec %CP /sec %CP Jeremy jeremy 300M 9026 94 17524 12 8173 9 7269 83 23678 7 102.9 0 Jeremy --Sequential Create-- Random Create Jeremy -Create-- --Read--- -Delete-- -Create-- --Read--- -Delete-- Jeremy files /sec %CP /sec %CP /sec %CP /sec %CP /sec %CP /sec %CP Jeremy 16 469 98 1476 98 16855 89 459 98 7132 99 688 25 Jeremy SCSI Array: Jeremy Version 1.00g --Sequential Output-- --Sequential Input- --Random- Jeremy -Per Chr- --Block-- -Rewrite- -Per Chr- --Block-- --Seeks-- Jeremy MachineSize K/sec %CP K/sec %CP K/sec %CP K/sec %CP K/sec %CP /sec %CP Jeremy orville300M 8433 100 134143 99 127982 99 8016 100 374457 99 1583.4 6 Jeremy --Sequential Create-- Random Create Jeremy -Create-- --Read--- -Delete-- -Create-- --Read--- -Delete-- Jeremy files /sec %CP /sec %CP /sec %CP /sec %CP /sec %CP /sec %CP Jeremy 16 503 13 + +++ 538 13 490 13 + +++ 428 11 Jeremy So...obviously from bonnie stats, the scsi array blows away the ide...but Jeremy using the attached c program, here's what we get for fsync stats using the Jeremy little c program I've attached: Jeremy IDE Drive: Jeremy jeremy:~# time ./xlog file.out fsync Jeremy real0m1.850s Jeremy user0m0.000s Jeremy sys 0m0.220s Jeremy SCSI Array: Jeremy [root@orville mysql_data]# time /root/xlog file.out fsync Jeremy real0m23.586s Jeremy user0m0.010s Jeremy sys 0m0.110s cut Couldn't the problem simply be that the SCSI array is caching things in RAM before writing to disk while the IDE disk isn't but is flushing things down to disk at once. The behaveour of the above would be that when you do a lot of read/write the SCSI would be much faster, as there is less read/writes involved, but flush would be slower as there is always unflushed data in the RAM. Regards, Monty - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: scsi vs ide performance on fsync's
Hi! "Mike" == Mike Black [EMAIL PROTECTED] writes: Mike Here's a strace -r on IDE: Mike 0.001488 write(3, "\214\1\0\0Blah Blah Blah Blah Blah Bla"..., 56) = 56 Mike 0.000516 fdatasync(0x3)= 0 Mike 0.001530 write(3, "\215\1\0\0Blah Blah Blah Blah Blah Bla"..., 56) = 56 Mike 0.000513 fdatasync(0x3)= 0 Mike 0.001555 write(3, "\216\1\0\0Blah Blah Blah Blah Blah Bla"..., 56) = 56 Mike 0.000517 fdatasync(0x3)= 0 Mike 0.001494 write(3, "\217\1\0\0Blah Blah Blah Blah Blah Bla"..., 56) = 56 Mike 0.000515 fdatasync(0x3)= 0 Mike 0.001495 write(3, "\220\1\0\0Blah Blah Blah Blah Blah Bla"..., 56) = 56 Mike 0.000522 fdatasync(0x3)= 0 Mike Here it is on SCSI: Mike 0.049285 write(3, "\3\0\0\0Blah Blah Blah Blah Blah Bla"..., 56) = 56 Mike 0.000689 fdatasync(0x3)= 0 Mike 0.049148 write(3, "\4\0\0\0Blah Blah Blah Blah Blah Bla"..., 56) = 56 Mike 0.000516 fdatasync(0x3)= 0 Mike 0.049318 write(3, "\5\0\0\0Blah Blah Blah Blah Blah Bla"..., 56) = 56 Mike 0.000516 fdatasync(0x3)= 0 Mike 0.049343 write(3, "\6\0\0\0Blah Blah Blah Blah Blah Bla"..., 56) = 56 Mike Looks like a constant 50ms delay on each fdatasync() on SCSI vs .5ms for Mike IDE. Maybe IDE isn't really doing a sync?? I find .5ms to be a little too Mike good. I wonder from where the fdatasync() is comming; MySQL is not doing those (if you are not running mysqld with --flush) Mike I did this on 4 different machines with different SCSI cards (include RAID5 Mike and non-RAID), disks, and IDE drives with the same behavior. Regards, Monty - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Recursive queries
create table root( create table subcats( create table subsections( And now I need 230 levels, huh :). How about a simple tree structure ? hth pa - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: phpMyAdmin equivalent
Gossamer Threads (http://www.gossamer-threads.com) has an near identical knockoff written in perl calles mysqlman - Original Message - From: "MikemickaloBlezien" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, March 05, 2001 10:53 AM Subject: phpMyAdmin equivalent Hello All, Was wonder if any knows of a Perl equivalent to the PHP's version of phpMyAdmin?? We use phpMyAdmin but have a project that server doesn't have PHP installed, and frankly, to lazy to do all the typing thru telnet session! :) TIA, Mickalo Mike(mickalo)Blezien Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225) 686-2002 = - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Recursive queries
On Mon, 5 Mar 2001 10:13:29 -0600 "Johnny Withers" [EMAIL PROTECTED] wrote: Well, if you have everything setup right.. this is easy to do in SQL. Lets say you have your root table: [...] and your sub categories: [...] and your final category: [...] now you can simply join all these tables.. I have a single table that contains all the sections, so I would not have a limit to how many sections and subsections that I can create. Yes, it would be easy to do a join on those three tables, but that doesn't scale very well since I would have to add a table if I wanted the ability to go deeper than two subsections. Here is the current structure of the table: ++-+--+-+-++ | Field | Type| Null | Key | Default | Extra | ++-+--+-+-++ | section_id | tinyint(3) unsigned | | PRI | NULL| auto_increment | | parent_id | tinyint(3) unsigned | | | 0 || | name | varchar(100)| | | || | descript | mediumtext | YES | | NULL|| | is_hidden | tinyint(4) | | | 0 || | modified | timestamp(14) | YES | | NULL|| ++-+--+-+-++ They link together by section_id's and parent_id's. With what I described below, the section record would contain: (Root) | |== section_id: 0 | |== parent_id: 0 | | | +Sports Products| || | ||== section_id: 2 ---|| ||== parent_id: 0 || || | |+Golf | ||| | |||== section_id: 3 | |||== parent_id: 2 | || | |+Fishing Products | ||| | |||== section_id: 4 | |||== parent_id: 2 | Here's what I have: I have a table that among others, have fields called 'section_id' and 'parent_id'. The section_id is the id of the "self" section, and the parent_id is the id of the section that "owns" the self section. (It's sort of like a filesystem where one directory has subdirectories, and so on) Here's what I'm trying to do: I want to start with one section, and go down the tree of sub-sections, picking up information about them on the way. Example: I want to start at the "root" section, and follow down one of it's sub-sections. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
buglet in my.cnf parsing/handling
I consider this a bug... other might not. I have: .my.cnf: --- [client] password host = mysql.rollanet.org [mysql] verbose --- If I type "mysql" by itself, everything works fine. But if I try to use "-ppassword" on any tool, it fails. I think that "password" in the config shouldn't trigger if the password is specified on the command line. The problem is that if you have "password" in the config to make interactive use convenient, any non-interactive use with a different wired password will never work. -- Nathan Nathan Neulinger EMail: [EMAIL PROTECTED] University of Missouri - Rolla Phone: (573) 341-4841 Computing Services Fax: (573) 341-4216 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 install ? on tru64 system with Compaq c++
Would like to install this with cxx not gcc! Made the following adaptation to website documentation for section 4.12.6: CC="cc -pthread" CFLAGS="-O4 -ansi_alias -ansi_args -fast -inline speed -speculate all -arch host" CXX="cxx -pthread" CXXFLAGS="-O4 -ansi_alias -ansi_args -fast -inline speed -speculate all -arch host" export CC CFLAGS CXX CXXFLAGS ./configure \ --prefix=/usr/local/mysql --enable-large-files --enable-shared=yes --with-named-thread-libs="-lpthread -lmach -lexc -lc" The configure appeared to work, however make exits on the following message: cxx -pthread -O -D_LARGEFILE_SOURCE -D_LARGEFILE64_SOURCE -D_FILE_OFFSET_BITS=64 -O3 -DDBUG_OFF -O4 -ansi_alias -ansi_args -fast -inline speed -speculate all -a rch host -o .libs/mysql mysql.o readline.o sql_string.o completion_hash.o ../rea dline/libreadline.a -lcurses .libs/libmysqlclient.so -lm -lm -Wl,-rpath -Wl,/usr /local/mysql/lib/mysql ld (prelink): Can't open: /usr/local/mysql/lib/mysql (No such file or directory) ld: Can't open: /usr/local/mysql/lib/mysql (No such file or directory) *** Exit 1 Stop. *** Exit 1 Stop. *** Exit 1 Stop. last line of config.log shows the following: configure:8017: cc -pthread -std1 -c -D_LARGEFILE_SOURCE -D_LARGEFILE64_SOURCE - D_FILE_OFFSET_BITS=64 -O -DDBUG_OFF -O4 -ansi_alias -ansi_args -fast -inline spe configure:8121: checking character sett.c 15 We're running Tru64 Unix 4.0d with patch kit 6. cxx is version 5.7 Upgrading the OS is not an option right now. I'm totally new to the world of mysql so any assistance would be greatly appreciated. Best Regards, Renee Vasel DynCorp IS, LLC - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: BDB tables on Linux
On Mon, Mar 05, 2001 at 11:27:54AM -0600, Stephen Faustino wrote: I've installed 3.23.33 on both Solaris and Linux RH 6.2 using the tarball for Solaris and the RPM for Linux. The BDB tables work as expected on Solaris, but they did not not work under Linux. What I'm seeing is that I can create a BDB just fine. However, attempting a rollback results in: ERROR 1196: Warning: Some non-transactional changed tables couldn't be rolled back When I do a mysqldump, the ddl for the table shows a type of MyISAM. This suggestst that they weren't created as BDB tables. Can you verify that they're created properly? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
DBD::mysql
I am trying to install DBD::mysql on a server which does not have mysql on it. ( The script will be accessing a mysql database on another server). The problem is, when I try to install dbd::mysql I am asked several questions.. one of which being: what is the path to mysql? I don't have a path to mysql as it is not installed and I don't want to install it. Is there a way to install DBD::mysql without having to install mysql? 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: BDB tables on Linux
Yes, I specified that the table should use the BDB table handler, but it does not appear that the table was created as a BDB table. The following are the results of my sessions on Solaris and Linux: Solaris: mysql create table test (x int) type = BDB; Query OK, 0 rows affected (0.46 sec) mysql set autocommit=0; Query OK, 0 rows affected (0.00 sec) mysql insert into test values (1); Query OK, 1 row affected (0.00 sec) mysql rollback; Query OK, 0 rows affected (0.00 sec) mysql select * from test; Empty set (0.06 sec) mysql Linux: mysql create table test (x int) type = BDB; Query OK, 0 rows affected (0.01 sec) mysql set autocommit=0; Query OK, 0 rows affected (0.00 sec) mysql insert into test values (1); Query OK, 1 row affected (0.00 sec) mysql rollback; ERROR 1196: Warning: Some non-transactional changed tables couldn't be rolled b ack mysql select * from test; +--+ | x| +--+ |1 | +--+ 1 row in set (0.00 sec) mysql Stephen L. Faustino Senior Software Engineer SecureLogix Corporation Direct/Vmail (210)402-9669x949 mailto:[EMAIL PROTECTED] -Original Message- From: Jeremy D. Zawodny [mailto:[EMAIL PROTECTED]] Sent: Monday, March 05, 2001 3:29 PM To: Stephen Faustino Cc: '[EMAIL PROTECTED]' Subject: Re: BDB tables on Linux On Mon, Mar 05, 2001 at 11:27:54AM -0600, Stephen Faustino wrote: I've installed 3.23.33 on both Solaris and Linux RH 6.2 using the tarball for Solaris and the RPM for Linux. The BDB tables work as expected on Solaris, but they did not not work under Linux. What I'm seeing is that I can create a BDB just fine. However, attempting a rollback results in: ERROR 1196: Warning: Some non-transactional changed tables couldn't be rolled back When I do a mysqldump, the ddl for the table shows a type of MyISAM. This suggestst that they weren't created as BDB tables. Can you verify that they're created properly? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: scsi vs ide performance on fsync's
Hello, Michael Widenius wrote on Monday, March 05, 2001: I wonder from where the fdatasync() is comming; MySQL is not doing those (if you are not running mysqld with --flush) The call is either a fsync or an fdatasync that is done by Berkley DB on the transaction log. Regards, Chris Delaney - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: About licence
On Mon, Mar 05, 2001 at 10:34:38AM +0100, Piotr Szybiak wrote: I am a 5th year student of University of Technology in Poznan (Poland). I would like to use MySQL in commerce project (Internet Auction). I will develope my Auction in Linux. Have I buy a licence from you ??? How many it cost. Pleace answer me, it is very important for me. Thank you. Piotrek MySQL is now under the GPL. So if you want to spend the money, you can purchase a support contract from mysql.com. There are details on their site. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: delete
In some RDBMS there is something called ROLLBACK. However, I am not sure if MySQL does support features such as ROLLBACK, If mySQL doesnt support ROLLBACK then you need to do a recovery from your previous backups. On Sat, 03 Mar 2001, Pål Wester wrote: When you delete somthing... is there any way to recover the data?? mvh: Pål Wester, programmerer never.no as, stortingsgt 30, 0161 Oslo direkte: 22 01 66 34, 906 900 62 tlf: 22 01 66 34, fax: 22 01 66 21 http://never.no - icq:103476059 ~ innhold for internett ~ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: BDB tables on Linux
show variables showed that have_bdb is no, and none of the bdb variables are there. So does this mean that BDB is NOT compiled into the binary included in the Linux RPM, or does it mean that I need to add the necesary BDB-related variables to /etc/my.cnf? Stephen L. Faustino Senior Software Engineer SecureLogix Corporation Direct/Vmail (210)402-9669x949 mailto:[EMAIL PROTECTED] This email is intended for the named recipient(s) only and may contain information that is privileged and/or confidential. Nothing in this email is intended to constitute a waiver of any privilege or the confidentiality of this message. If you have received this email in error, please notify me immediately by reply and delete this message. -Original Message- From: Jeremy D. Zawodny [mailto:[EMAIL PROTECTED]] Sent: Monday, March 05, 2001 3:51 PM To: Stephen Faustino Cc: '[EMAIL PROTECTED]' Subject: Re: BDB tables on Linux On Mon, Mar 05, 2001 at 03:44:20PM -0600, Stephen Faustino wrote: Yes, I specified that the table should use the BDB table handler, but it does not appear that the table was created as a BDB table. Are you *sure* you're running a version with BDB support compiled in? The output of SHOW VARIBLES will probably tell you. Having not used them, though, it's hard to say... Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Date/Time difference
Hi, Your main problem will be in storage - datetime fields are only down to the second, so you will have to store the times as integers, and then do your own arithmetic on them. If you stored the time as ('unix time' * 100) + hundreths, then you could probably still do some arithmetic using the standard functions and 'col_name/100', but that will only be accurate to a second. Regards Quentin -Original Message- From: Andreas Karl Wittwer [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 6 March 2001 2:54 p.m. To: [EMAIL PROTECTED] Subject: Date/Time difference Hello, I'm reading this list for some time and checked the FAQ, archive but i haven't found any hints ... I have an own written app which is using a 'kind of database' to calculate the difference between two (or more) events which can happen between tens or hundreds of seconds. Now i want to switch to a real database but i'm unable to find a database function to calculate the difference between (for example '2001-03-05- 20:09:10.54' and '2001-03-05 20:11:34.36') of two events with a 'factional' time. I've tried something like INSERT INTO t_start, t_stop VALUES (UNIX_TIMESTAP(now() + 0.54) , UNIX_TIMESTAMP(now() + 0.38) but this is not working for a 'DATETIME' field, a 'FLOAT' field returns 0. The difference between the two times is very critical because the app is written for sports events ... Maybe someone uses MySQL within such an application and has can provide some hints Andreas Karl Wittwer Phone: +49-7052-92206 FAX: +49-7052-92208 Mobil: +49-172-542 541 4 [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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Raid de Himalaya
To all adventure motorcyclists First I know that a lot of you didn't request information from me and if you would prefer not to hear from me again please reply to this mail with unsubscribe in the subject field and you will be removed from this list. For those of you who are interested in taking part in a fantastic competition or a motorcycle expedition read on. Raid de Himalaya is a unique event. Organized by The Himalayan Motor sport Association the "Raid" was first run in 1999. This is a world-class international competition run in the "raid format", providing competitors with the opportunity of taking part in the longest, toughest and biggest motor sport event in India. The term international describes the status that the event enjoys with the FIA FEDERATION INTERNATIONALE DE L'AUTOMOBILE and FIM on their calendar. It means the event has to have a very high level of safety and organisation and also expects people not only from the state or country to take part but also from all over the world. Eventually the raid will become a round of the World Rally / Off Road Rallying Championship. This event has full government of India support. The FMSCI (The Federation of Motor Sports Clubs in India) is the body sanctioned to grant permits for events on behalf of the FIM in India for motorcycle events and the MAI (Motor sport Association of India) will provide the permits on behalf of the FIA for the car events. The event this year will be the 3rd running of Raid de Himalaya. The raid takes place in the North Indian state Himachal Pradesh and is open to both 4 wheeled vehicles and motorcycles. The coarse uses the highest motorable road in the world at 5500m as one of the competitive stages as well as the other parts of the Tibetan plateau. There are several different classes, which can be entered with motorcycles. Group A/B: Indian and Non-Indian machines modified up to 750cc Group C: Indian machines modified with Indian components Group D: Standard Indian machine. Initially we can provide a standard Enfield 500cc machine and also supply parts to modify it if required. All bikes provided will be prepared and maintained by us before each stage. The second event Thunder in the mountains is a high altitude expedition into the upper reaches of Himachal Pradesh in North India. Get ready for 12 days of biking adventure up high on the Tibetan Plateau. Any one interested in taking part or sponsoring the event please have a look at the web site www.event-horizon.org/tour/index.htm Or contact John-Mark James by email [EMAIL PROTECTED] Telephone +44 (0) 20 8891 6680 +44 (0) 7976 150773 Thank you for your time reading this I hope that we will have a chance to talk more on the subject in the future. Regards John-Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 !!I had to install a new mysal version and I cannot compile my programs !
Hello, I was using C API under mysql-3.22.32. and I was forced to reinstall the mysql servr. Unfotunately I found only the version 3.23.23. Thw big problem is that the same sources give me under Mysql C API 3.33.23 the following message link error: In function my_compres_alloc my_compress. o (text +0x120) undefuned reference to 'compress'. And I'm completely stuck ! Anyhelp would be greatly appreciated ! Daniel
error 10065
After install a new proxy (wingate) here I couldn't connect to mysql server remote in any client machine, only in the machine were is the proxy. Mysql returns error 10065. I tryed to find the error description at the manual and at the site, but I didnt find. What is error 10065? The person who takes care of the server also dontt know. Sorry about the english. Thank you, Clarissa Castella Porto Alegre - Brasil.
turn of column headings
hello there, i am a novice, so bear with this rather trivial question. how do i turn off the column-headers for select statements in mysql?? couldn't find any help with the online manual. waiting. praveen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Error Out of Nowhere?
I was looking through my website and everything was fine and then all of a sudden I got this error: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) It was working fine, and now for some reason won't connect? Any suggestions how to fix this and why it would happen? Any help appreciated. Thanks in advance. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php