www.kwwda.org
DEAR sir, I WANT TO connect mysql database to my web site www.kwwda.org.i read the tutorials as well still i find it difficult to understand how to get started kindly help. asif www.kwwda.org - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: www.kwwda.org
try http://www.avukatpro.com/mysql.html mysql asp section. if you use asp - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, April 15, 2001 10:01 AM Subject: www.kwwda.org DEAR sir, I WANT TO connect mysql database to my web site www.kwwda.org.i read the tutorials as well still i find it difficult to understand how to get started kindly help. asif www.kwwda.org - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Help!!
On 15-Apr-01 ªüÂ× wrote: $result=0; $query="select * from users where user_id='$user_id'"; // why fetch all the fields to test an "exists" ? $result=mysql_query($query,$link); // where's the test, in case it failed ? if(mysql_fetch_row($result)) $result=1; // ^^^ you just trashed your result set else $result=0; // ditto I use the function of "mysql_fetch_row()" in register2.php and it's output is the follow list: Warning: Supplied argument is not a valid MySQL result resource in /home/shin/public_html/register2.php on line 27 --- // assumes the $link is valid !?! function user_exists($user_id) { global $link; $query="select * from users where user_id='$user_id'"; $result=mysql_query($query,$link); if (! $result) die ('P' .mysql_errno() .'BR'.mysql_error() ."BR\n"); $cnt = mysql_numrows($result); return($cnt); } function user_exists2($user_id) { global $link; $query="select count(*) as cnt from users where user_id='$user_id'"; $result=mysql_query($query,$link); if (! $result) die ('P' .mysql_errno() .'BR'.mysql_error() ."BR\n"); $row=mysql_fetch_object($result); return($row-cnt); } Regards, -- Don Read [EMAIL PROTECTED] -- It's always darkest before the dawn. So if you are going to steal the neighbor's newspaper, that's the time to do it. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Outer and left join definition
bob... your example does not appear to work for me. maybe i'm missing something? i created two tables simply as: create table test1 values (id int); create table test2 values (id int); and populated them with some matching and non-matching data. however, when i run the query: select test1.id, test2.id from test1 left join test2 using id; i get the following error: You have an error in your SQL syntax near 'id' at line 1 any ideas? Bob Hall wrote: SELECT table_a.id, table_b.id FROM table_a LEFT JOIN table_b USING id; would return something like table_a.id table_b.id __ __ a NULL b b c c d NULL - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Can't build mysqlgui-1.7.5
Greetings, mysqlgui-1.7.5.tar.gz appears to be missing source files. Here's the output when I try to make it. [relson@osage mysqlgui-src-1.7.5]$ make make: *** No rule to make target `edfile.o', needed by `mysqlgui'. Stop. I've checked and there are source files corresponding to each of the OBJS targets, except for edfile.o 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
Re: Can't build mysqlgui-1.7.5
David Relson writes: Greetings, mysqlgui-1.7.5.tar.gz appears to be missing source files. Here's the output when I try to make it. [relson@osage mysqlgui-src-1.7.5]$ make make: *** No rule to make target `edfile.o', needed by `mysqlgui'. Stop. I've checked and there are source files corresponding to each of the OBJS targets, except for edfile.o David Hi! edfile.o is from fl_editor source distro. When you build fl_editor, just coy that object file to mysqlgui directory. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Outer and left join definition
bob... your example does not appear to work for me. maybe i'm missing something? i created two tables simply as: create table test1 values (id int); create table test2 values (id int); and populated them with some matching and non-matching data. however, when i run the query: select test1.id, test2.id from test1 left join test2 using id; i get the following error: You have an error in your SQL syntax near 'id' at line 1 Sir, it's not a good idea to trust the syntax of anything I've posted unless I specifically say that I've run it on my machine. I'm very absent-minded. In this case I was only trying to provide a more or less generic example of a LEFT JOIN, not a syntactically correct example of a MySQL SELECT statement. By pure luck, the only thing missing is a pair of parentheses. I've just run the following on my machine, and it works. select test1.id, test2.id from test1 left join test2 using (id); On the other hand, the following does not work: create table test1 values (id int); I checked the on-line manual. (Ah ha! The fine manual! We can look in the manual get answers to syntax questions! Why didn't we think of that sooner!?) I can't find anything that suggests that you can use VALUES in a CREATE TABLE statement, so I think you probably used create table test1 (id int); which is what I used. Gee, we solved both problems by using the manual. Dr. Pangloss was right; this really is the best of all possible worlds! (Sorry. It's Sunday morning and I'm feeling really silly.) any ideas? Never. I'm not allowed, according to my last date. She said "Don't get any ideas." It's not working, though. I've been idea-free for weeks, and she still isn't returning my phone calls. Bob Hall Bob Hall wrote: SELECT table_a.id, table_b.id FROM table_a LEFT JOIN table_b USING id; would return something like table_a.id table_b.id __ __ a NULL b b c c d NULL Know thyself? Absurd direction! Bubbles bear no introspection. -Khushhal Khan Khatak MySQL list magic words: sql query database - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
problems with configure
Hello, i mail you from germany, so please excuse my "special" english! I just want to compile mysql 3.23.36 under Debian Potato for use with PHP(classic LAMP). But get the following error: configure:8016: checking for tgetent in -lncurses configure:8035: gcc -o conftest -O6 -DDBUG_OFF -rdynamic conftest.c -lncurses -ldl -lz -lcrypt -lnsl -lm -lpthread 15 /usr/bin/ld: cannot find -lncurses collect2: ld returned 1 exit status configure: failed program was: #line 8024 "configure" #include "confdefs.h" /* Override any gcc2 internal prototype to avoid an error. */ /* We use char because int might match the return type of a gcc2 builtin and then its argument prototype would still apply. */ char tgetent(); int main() { tgetent() ; return 0; } configure:8054: checking for tgetent in -lcurses configure:8073: gcc -o conftest -O6 -DDBUG_OFF -rdynamic conftest.c -lcurses -ldl -lz -lcrypt -lnsl -lm -lpthread 15 /usr/bin/ld: cannot find -lcurses collect2: ld returned 1 exit status configure: failed program was: #line 8062 "configure" #include "confdefs.h" /* Override any gcc2 internal prototype to avoid an error. */ /* We use char because int might match the return type of a gcc2 builtin and then its argument prototype would still apply. */ char tgetent(); int main() { tgetent() ; return 0; } configure:8092: checking for tgetent in -ltermcap configure:8111: gcc -o conftest -O6 -DDBUG_OFF -rdynamic conftest.c -ltermcap -ldl -lz -lcrypt -lnsl -lm -lpthread 15 /usr/bin/ld: cannot find -ltermcap collect2: ld returned 1 exit status configure: failed program was: #line 8100 "configure" #include "confdefs.h" /* Override any gcc2 internal prototype to avoid an error. */ /* We use char because int might match the return type of a gcc2 builtin and then its argument prototype would still apply. */ char tgetent(); int main() { tgetent() ; return 0; } configure:8139: checking for termcap functions library But ncurses is installed, but i dont know where to get termcap! Please help and thanks a lot Andr Estel -- GMX - Die Kommunikationsplattform im Internet. http://www.gmx.net - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Bug fix for FreeBSD and other non-Linux users of InnoDB (= Innobase)
Hi! The performance problems some users reported on FreeBSD for InnoDB may have been caused the signal 14 bug already known for the Solaris port. The fix and a patch file for 3.23.36 can be found at www.innobase.fi. This is fixed also in upcoming 3.23.37 which may be out on Tuesday. Happy Easter, Heikki Tuuri Innobase Oy (Bait for the mailing list spam filter: SQL, MySQL) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Propagating a Table
Hi, I have MySQL 3.23.xx and PHP4 I am using a code to return images that puts them in a table. The search works fine. It selects an image and returns it fine. However, when more that one image is returned:. ... my problem is I want 3 images to appear in any one row in the table. Subsequent images I want to start in the next row down, subject to a limit of 3 and so forth. All I can manage to return is 1 row of x images or 1 column of x images. Can any one advise me on the correct approach? Thanks, Kindest Regards, Steve Lowe - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
how to get average value for top n records?
Hi, if I have a table with only one field A like this: record#1: 2 record#2: 3 record#3: 2 record#4: 4 record#5: 6 record#6: 8 How to write a sql statement to retrieve the average value of field A for the last 3 records? Did I make sense here? Thanks for help. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: how to get average value for top n records?
select sum(a)/3 from atable order by record_id desc limit 3; - Original Message - From: "Kevin Xin Lin" [EMAIL PROTECTED] To: "mysql" [EMAIL PROTECTED] Sent: Sunday, April 15, 2001 9:04 PM Subject: how to get average value for top n records? Hi, if I have a table with only one field A like this: record#1: 2 record#2: 3 record#3: 2 record#4: 4 record#5: 6 record#6: 8 How to write a sql statement to retrieve the average value of field A for the last 3 records? Did I make sense here? Thanks for help. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Auto_Increment
Hello, I wonder if you can help me. For a university project I've got a database with several tables using columns set up with 'auto_increment'. I've discovered that the value that the system creates for a new record is one greater than the largest one which has existed even if the records with the largest values have been deleted. I've read the docs and read the part which says that this is the way myISAM tables handles auto_increment and that ISAM tables create a value which is one greater than the largest value currently existing. From this I've presumed that I'm using myISAM tables but is there any way I can make the auto_increment feature work the way it does with the ISAM tables? And what exactly are myISAM and ISAM tables? (a quick web search gave me: -the Information centre for South African Music -the Institute for the Study of American Music -International Swimwear and Active Market) Thanks for any help you can give me, Jamie. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Propagating a Table
... my problem is I want 3 images to appear in any one row in the table. Subsequent images I want to start in the next row down, subject to a limit of 3 and so forth. Some naive and simplistic 'pseudo' code: code int current = 0, max = 3; print_table_row_start(); while (sql_row = get_sql_rows()) { if (++current max) { print_table_row_end(); print_table_row_start(); current = 0; } print_table_entry(sql_row, current); } print_table_row_end(); /code Another approach could be: code create table images ( id int not null primary key auto_increment, image sometype ); select a.image as first, b.image as second, c.image as third from images as a left join images as b on (a.id = b.id+1) left join images as c on (a.id = c.id+2); /code In this case you should skip all rows but every third when outputting. That could be mitigated with a group_id column of sorts in the images table together with a group by expression. (A sql guru can propably tell you how to do this without a group_id column) -- Aigars Bait: MySQL, SQL - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqlgui: help.
I tried mysqlgui: mysqlgui-linux-static-1.7.5]$ ./mysqlgui but it didn't works well: It can't connect to mysql. Why? How can I do to connect for example to a database called "visia" with pw "pw_visia" from an user called "rino" in "localhost"? mysqlgui ask me a password: what password it want? Tank you in advance, Mario. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Auto_Increment
On Sun, Apr 15, 2001 at 08:20:10PM +0100, Jamie S Buchanan wrote: And what exactly are myISAM and ISAM tables? http://www.mysql.com/documentation/mysql/bychapter/manual_Table_types.html#Table_types (a quick web search gave me: -the Information centre for South African Music -the Institute for the Study of American Music -International Swimwear and Active Market) LOL yeah that's a great help :-) cheers, roel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Can't build mysqlgui-1.7.5
At 11:42 AM 4/15/01, Sinisa Milivojevic wrote: David Relson writes: Greetings, mysqlgui-1.7.5.tar.gz appears to be missing source files. Here's the output when I try to make it. [relson@osage mysqlgui-src-1.7.5]$ make make: *** No rule to make target `edfile.o', needed by `mysqlgui'. Stop. I've checked and there are source files corresponding to each of the OBJS targets, except for edfile.o David Hi! edfile.o is from fl_editor source distro. When you build fl_editor, just coy that object file to mysqlgui directory. Regards, Sinisa Sinisa, I have fl_editor-0.4.1, which I downloaded, configured, and built today. There is no edfile.o. I have run command 'find . -name "edfile.*"' to locate it and found nothing. David David Relson Osage Software Systems, Inc. [EMAIL PROTECTED] Ann Arbor, MI 48103 www.osagesoftware.com tel: 734.821.8800 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
compiler problem with C++ API
Hello, When using Visual C++ or Delorie DJGPP (under windows 2000) compilers and compiling the following example: #include iostream #include winsock.h #include windows.h #include iomanip #include mysql++ int main() { Connection con("stw"); return 0; } I always get the following errors related to the mysql_com.h header file: Configuration: connect - Win32 Debug Compiling... connect.cpp c:\mysql\include\mysql_com.h(117) : error C2208: 'unsigned int' : no members defined using this type c:\mysql\include\mysql_com.h(117) : error C2501: 'fd' : missing storage-class or type specifiers c:\mysql\mysql++-1.7.1-win32-vc++\include\type_info1.hh(159) : warning C4800: 'unsigned int' : forcing value to bool 'true' or 'false' (performance warning) c:\mysql\mysql++-1.7.1-win32-vc++\include\type_info1.hh(172) : warning C4800: 'int' : forcing value to bool 'true' or 'false' (performance warning) c:\mysql\mysql++-1.7.1-win32-vc++\include\type_info1.hh(176) : warning C4800: 'int' : forcing value to bool 'true' or 'false' (performance warning) c:\mysql\mysql++-1.7.1-win32-vc++\include\type_info1.hh(180) : warning C4800: 'int' : forcing value to bool 'true' or 'false' (performance warning) c:\mysql\mysql++-1.7.1-win32-vc++\include\type_info1.hh(184) : warning C4800: 'int' : forcing value to bool 'true' or 'false' (performance warning) Error executing cl.exe. connect.obj - 2 error(s), 5 warning(s) Any ideas for a solution? Thanks, John - 20 email addresses from 15,000 domain names - free at http://www.another.com Wear a designer label -- your own! Your email or web address on a t-shirt for only 9.99: http://www.clickandbuild.com/cnb/shop/another - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Too many sleepers?
On 14 Apr 2001 23:30:51 -0400, Gary Huntress wrote: I've noticed, by doing "show processlist", that a few users end up with dozens (sometimes 50) sleeping processessome are 4 hours old. What is this typically caused by? I believe that most of my users connect using php, and I believe that if they omit mysql_close() that the connection is supposed to be closed automatically when their script ends. Are there other situations that would lead to this many ancient sleeping processes? Don't worry about them These are prorably PHP or something other persistent connections and MySQL drops them in case of inactivity in 8 hours. Tnu - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Redirecting Outfile
On 14 Apr 2001 16:55:51 -0300, Brian Cassidy wrote: Redirecting file output (for user bpc) with a command such as select * into outfile 'home/bpc/test.txt' from table gives the error ERROR 1: Can't create/write to file "/home/bpc/test.txt" (Errcode: 13). The documentation recommends setting parameter tmpdir. I have RedHat 7 with MySQL 3.23 and so I added file /home/bpc/.my.cnf with the parameter tmpdir=/home/bpc but that did not fix the problem. [tonu@x3 tonu]$ perror 13 Error code 13: Permission denied [tonu@x3 tonu]$ Something is wrong with permissions, not directory names. Tnu - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Need feedback
Hi all, Thanks for the feedback and based on what I read, I will be keeping the sites up for at least a few more months. I would like to see decent use of the site so tell people about them. That will be my determinining factor when I rethink the sites in June or July. They are free and do not require one to be a list member to read or respond to the author. You must be a list member to post to the list, though. Thanks again to those that wrote me and enjoy. David Fordham -- Original Message -- From: "mysql" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Tue, 10 Apr 2001 23:35:41 -0400 Hi all, I have had this website that captures the list email messages and placed it into a searchable db. I did this as a learning exercise and think it is pretty cool but am wondering if I should just shut em down. Take a look and if I get enough feedback, I will keep them running for at least a few more months. I have a PHP and a MYSQL list db, here are the URLs: http://www.summittech.com/mysqlmail.php3 http://www.summittech.com/phpgenmail.php3 They are free and I am not doing anything with the data. Let me know, David Fordham - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem - Possible Bug?
Every few mins (2-15min) mysqld crashes with a signal 11 (SEGV). I am running FreeBSD 4.2 with mysql 3.23.36, I used to have 3.23.32 it had the same problem, I upgraded to 3.23.36 today and it had the same problem. I have recompiled mysql in full debug and done a stack trace and it keeps on crashing in mysql_select(), here they are: trace #1: www# cd /usr/local/mysql/libexec www# gdb mysqld (gdb) run --user=mysql Starting program: /usr/local/mysql/libexec/mysqld --user=mysql 010415 19:08:47 Warning: setrlimit returned ok, but didn't change limits. Max open files is 1064 010415 19:08:47 Warning: Changed limits: max_connections: 300 table_cache: 377 /usr/local/mysql/libexec/mysqld: ready for connections Program received signal SIGSEGV, Segmentation fault. 0x80bd208 in mysql_select (thd=0x824a818, tables=0x92da1c8, fields=@0x824aa64, conds=0x92da4a0, ftfuncs=@0x824aa98, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=42505217, result=0x92da518) at sql_select.cc:799 799 DBUG_RETURN(error); ... (gdb) back #0 0x80bd208 in mysql_select (thd=0x824a818, tables=0x92da1c8, fields=@0x824aa64, conds=0x92da4a0, ftfuncs=@0x824aa98, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=42505217, result=0x92da518) at sql_select.cc:799 #1 0x808e919 in mysql_execute_command () at sql_parse.cc:1136 #2 0x809219f in mysql_parse (thd=0x824a818, inBuf=0x92da028 "select distinct pfs.shiptypeid, s.shipname from planetfleetships pfs, shiptypes s where s.shiptypeid=pfs.shiptypeid and pfs.planetid=3647", length=137) at sql_parse.cc:2298 #3 0x808d948 in do_command (thd=0x824a818) at sql_parse.cc:828 #4 0x808cba0 in handle_one_connection (arg=0x824a818) at sql_parse.cc:551 #5 0x2823a9a7 in _thread_start () from /usr/lib/libc_r.so.4 #6 0xbfadcffc in ?? () #7 0x28277fe7 in _thread_fd_unlock_debug () from /usr/lib/libc_r.so.4 #8 0x807c9e8 in THD::THD (this=0x92cb018) at sql_class.cc:78 #9 0x808889f in handle_connections_sockets (arg=0x0) at mysqld.cc:2274 #10 0x8087968 in main (argc=15, argv=0x8244140) at mysqld.cc:1890 #11 0x804b29d in _start () ... (gdb) info locals tmp_table = (TABLE *) 0x92cc018 error = 0 tmp = 0 need_tmp = true hidden_group_fields = false simple_order = false simple_group = false no_order = false cond_value = COND_OK select = (SQL_SELECT *) 0x92dab20 keyuse = {buffer = 0x0, elements = 0, max_element = 0, alloc_increment = 64, size_of_element = 20} join = {join_tab = 0x92db050, best_ref = 0xbfaba2ec, map2table = 0x92da760, table = 0x0, all_tables = 0x92da7e0, sort_by_table = 0x0, tables = 1, const_tables = 0, send_group_parts = 0, sort_and_group = false, first_record = false, full_join = true, group = false, no_field_update = 76, const_table_map = 0, outer_join = 0, send_records = 1, found_records = 2, positions = {{records_read = 14, table = 0x92da648, key = 0x0}, {records_read = 14, table = 0x92da648, key = 0x0}, { records_read = 3.497926695968519e-115, table = 0x92e0180, key = 0x92d9274}, {records_read = 8.8208146916688224e-314, table = 0xbfaba66c, key = 0x92d9274}, {records_read = 6.8236811656094081e-313, table = 0x282393b5, key = 0xbfaba6ac}, { records_read = 1.9019183611868367e-269, table = 0x92d9000, key = 0xbfaba6ac}, {records_read = 3.497926695968519e-115, table = 0x820d6ac, key = 0x92d9274}, {records_read = 1.5818070537455784e-264, table = 0xbfaba6ac, key = 0xbfaba7ec}, { records_read = 1.9019183611868367e-269, table = 0x1, key = 0xbfaba7e0}, {records_read = 3.497926695968519e-115, table = 0x820d6ac, key = 0x0}, {records_read = 1.8993304345295969e-269, table = 0xbfaba6dc, key = 0xbfaba71c}, { records_read = 3.497926695968519e-115, table = 0x822c4d4, key = 0x92d9274}, {records_read = 3.4979266959743929e-115, table = 0xbfaba6fc, key = 0x92d9274}, {records_read = 1.8993304345295969e-269, table = 0x822c4d8, key = 0xbfaba74c}, { records_read = 3.497926695968519e-115, table = 0x822c4d4, key = 0x92d9274}, {records_read = 1.8992611150717832e-269, table = 0xbfaba72c, key = 0xbfaba74c}, {records_read = 1.8993304345295969e-269, table = 0x92e0198, key = 0x92d9274}, { records_read = 3.497926695968519e-115, table = 0x822c4d4, key = 0x0}, {records_read = 3.4978027730273331e-115, table = 0xbfaba75c, key = 0x0}, {records_read = 3.497926695968519e-115, table = 0xbfaab000, key = 0x3c}, { records_read = 1.8611437758736926e-264, table = 0xbfaba77c, key = 0x43f}, {records_read = 1.8520806496858815e-264, table = 0x12e0198, key = 0xbfaba7cc}, {records_read = 1.8520805311109313e-264, table = 0xbfaba7f8, key = 0x1}, { records_read = 3.4979266959805738e-115, table = 0x820d6ac, key = 0xbfaba7dc}, {records_read = 1.901849041729023e-269, table = 0x282b11c0, key = 0xbfaba7dc}, {records_read = 3.7004632531246594e-115, table = 0x1, key = 0x92d9274}, { records_read = 3.4979266959743929e-115, table = 0x822c4d8, key = 0x92d9274},
Re: www.kwwda.org
I suggest PHP it's the easiest to learn. From: "Rolf Hopkins" [EMAIL PROTECTED] To: [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: www.kwwda.org Date: Mon, 16 Apr 2001 09:57:15 +0800 MIME-Version: 1.0 Received: from [192.58.197.162] by hotmail.com (3.2) with ESMTP id MHotMailBCA39C14002A4004375CC03AC5A20AF90; Sun Apr 15 18:55:33 2001 Received: (qmail 16753 invoked by uid 7797); 16 Apr 2001 01:48:39 - Received: (qmail 16739 invoked from network); 16 Apr 2001 01:48:38 - From mysql-return-71576-acojocaru Sun Apr 15 18:57:27 2001 Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm (http://www.ezmlm.org) List-ID: mysql.mysql.com Precedence: bulk List-Help: mailto:[EMAIL PROTECTED] List-Unsubscribe: mailto:[EMAIL PROTECTED] List-Post: mailto:[EMAIL PROTECTED] List-Subscribe: mailto:[EMAIL PROTECTED] Delivered-To: mailing list [EMAIL PROTECTED] Message-ID: 021e01c0c618$a165ec20$[EMAIL PROTECTED] References: [EMAIL PROTECTED] X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 Your first step is that you are going to have to decide what language you want to use: PHP, Perl, C, Java, ASP, etc.. The next step is to read the appropriate manual/s for that language together with the webserver's documentation. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, April 15, 2001 15:01 Subject: www.kwwda.org DEAR sir, I WANT TO connect mysql database to my web site www.kwwda.org.i read the tutorials as well still i find it difficult to understand how to get started kindly help. asif www.kwwda.org - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Query failing
MySQL is not giving expected results in queries: The table has a decimal field, 'tolong', with a 13 char size and 8 decimal places. I know from browsing that the table contains many records with 'tolong' values less than -120, as low as -124. The query select * from Tiger_main where tolong -120; results in no records being retrieved. The same query, with reference value -119.8 yeilds no records returned. The same query, with reference value -119.7 returns a large number of records, including several which should have been returned by the prior queries, with tolong values less than -120. The table is fairly large, with over 5 million records and 500 MBytes, and the tolong field is individually indexed. The server is MySQL 3.23.22-beta-log. Can anybody provide any insight into what the problem might be? David Keeney Can anybody shed any light on why MySQL - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Does MySQL support sub queries ?
Thank you Jeremy, these really help!! I can't find the manual :D -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Friday, April 13, 2001 4:00 PM To: Yen Cc: [EMAIL PROTECTED] Subject: Re: Does MySQL support sub queries ? On Fri, Apr 13, 2001 at 04:02:31PM +0800, Yen wrote: Does anyone know whether this MySQL support sub queries? Anyone who has checked the MySQL Manual does. (Hint: http://www.mysql.com/doc/M/i/Missing_Sub-selects.html) Jeremy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem with mysql++, Aborted (core dumped)
I am trying to prove a small program of test, but when trying to execute it this always it throws "Aborted (core dumped)", this happens at the time of making the connection: It is the program: #include iostream.h #include iomanip.h #include "sqlplus.hh" cchar *user="sqluser"; cchar *pass="sqluser"; cchar *host="Localhost"; cchar *db="test"; main () { cout "Conectando...\n"; Connection MySQL(db, host, user, pass); cout "Ok."; return 0; } also i have proven with "Connection MySQL(db)" and "Connection MySQL(); MySQL.connect();", this like "root" and "common user" i am using: redhat 7.0 gcc 2.96 mysql 3.23.36 mysql++ 1.7.8 Thanks for your help !!! and sorry by my english !!! -- Luis E. Cruz Campos [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: Problem with mysql++, Aborted (core dumped)
I suggest you try the mySQL C API and see if that works first. -Andrei Cojocaru From: Luis E. Cruz Campos [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Problem with mysql++, Aborted (core dumped) Date: Mon, 16 Apr 2001 12:17:40 -0400 MIME-Version: 1.0 Received: from [192.58.197.162] by hotmail.com (3.2) with ESMTP id MHotMailBCA3BCD600CA40043191C03AC5A20E370; Sun Apr 15 21:15:19 2001 Received: (qmail 19544 invoked by uid 7797); 16 Apr 2001 04:11:13 - Received: (qmail 19519 invoked from network); 16 Apr 2001 04:11:12 - From mysql-return-71581-acojocaru Sun Apr 15 21:16:36 2001 Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm (http://www.ezmlm.org) List-ID: mysql.mysql.com Precedence: bulk List-Help: mailto:[EMAIL PROTECTED] List-Unsubscribe: mailto:[EMAIL PROTECTED] List-Post: mailto:[EMAIL PROTECTED] List-Subscribe: mailto:[EMAIL PROTECTED] Delivered-To: mailing list [EMAIL PROTECTED] X-Mailer: KMail [version 1.2] Message-Id: [EMAIL PROTECTED] I am trying to prove a small program of test, but when trying to execute it this always it throws "Aborted (core dumped)", this happens at the time of making the connection: It is the program: #include iostream.h #include iomanip.h #include "sqlplus.hh" cchar *user="sqluser"; cchar *pass="sqluser"; cchar *host="Localhost"; cchar *db="test"; main () { cout "Conectando...\n"; Connection MySQL(db, host, user, pass); cout "Ok."; return 0; } also i have proven with "Connection MySQL(db)" and "Connection MySQL(); MySQL.connect();", this like "root" and "common user" i am using: redhat 7.0 gcc 2.96 mysql 3.23.36 mysql++ 1.7.8 Thanks for your help !!! and sorry by my english !!! -- Luis E. Cruz Campos [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 _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem with mysql++, Aborted (core dumped)
-Original Message- From: Luis E. Cruz Campos [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED]; [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Monday, April 16, 2001 9:37 AM Subject: Problem with mysql++, Aborted (core dumped) I am trying to prove a small program of test, but when trying to execute it this always it throws "Aborted (core dumped)", this happens at the time of making the connection: It is the program: #include iostream.h #include iomanip.h #include "sqlplus.hh" cchar *user="sqluser"; cchar *pass="sqluser"; cchar *host="Localhost"; cchar *db="test"; main () { cout "Conectando...\n"; Connection MySQL(db, host, user, pass); cout "Ok."; return 0; } also i have proven with "Connection MySQL(db)" and "Connection MySQL(); MySQL.connect();", this like "root" and "common user" i am using: redhat 7.0 gcc 2.96 mysql 3.23.36 mysql++ 1.7.8 Thanks for your help !!! and sorry by my english !!! -- Luis E. Cruz Campos [EMAIL PROTECTED] Where do you get this lib sqlplus.hh i dont know and what is cchar. YOUR SINCERELY Shivakanth - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php