Re: problem with a LEFT JOIN
At 09:02 16.07.01 -0700, John Hawkins wrote: >I'm having a bit of trouble doing a LEFT JOIN. Any input would be greatly >appreciated. > >table 1 (sites, has approx 30 records) has a list of sites with the >following fields: >ID, sitename, url > >table 2 has (ratings, has approx 2020 records) has a list of member >ratings for the different sites with the following fields: >ID, siteID, memID, rating > >- sites.ID matches up with ratings.memID >- memID is the ID of the member who performed this rating Is this really so?? it should be sites.ID matches ratings.siteID? >I want to show the member who is logged in a list of all the sites that he >has not yet rated. > >here is the select statement I have created, but isn't quite working: > >SELECT sites.* FROM sites LEFT JOIN ratings ON sites.ID = ratings.siteID >WHERE ratings.memID != '1' then the select looks like that: SELECT sites.* FROM sites LEFT JOIN ratings ON sites.ID = ratings.siteID WHERE sites.ID = ratings.siteID and ratings.memID!=1 Or have I understand something wrong?? Regards Gerlinde >I am getting approx 2020 results (which, oddly enough, matches the amount >of records I have in the "ratings" table). > >Like I said, any help would be greatly appreciated. > >Best, > >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 BLITZ Internet Service GmbH Kronacher Strasse 41 D-96052 Bamberg, Germany Tel. +49/951/9685160, Fax +49/951/9685164 http://www.blitz.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
Install MySQL GUI
Sir, I'm using Linux Mandrake 8.0. This is the first time I'm using Linux OS. My question is: how to install MySQL GUI to Linux. Please help me. Thank you very much. My email : [EMAIL PROTECTED] Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: locking problem!
I have got an example with a simple and very often used select here also... | 28 | DELAYED | localhost| dbSmurfa | Delayed_insert | 1| Waiting on cond | GuestBook | 479 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 1| Locked | SELECT Users.ID, Users.Alias | 480 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 1| Locked | SELECT Users.ID, Users.Alias | 496 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 1| Locked | UPDATE Users SET Logons=Logons+1 | 494 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 0| Locked | UPDATE Users SET Logons=Logons+1 | 511 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 1| Locked | SELECT Users.ID, Users.Alias | 517 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 1| Locked | SELECT Users.ID, Users.Alias | 518 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 1| Locked | SELECT Users.ID, Users.Alias | 528 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 1| Locked | SELECT Hits FROM UserCounters | 525 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 1| Locked | SELECT Hits FROM UserCounters | 523 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 1| Locked | SELECT Hits FROM UserCounters | 531 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 1| Locked | SELECT Users.Alias, Users.ID | 536 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 1| Locked | SELECT ID, Alias, Name, Email | 539 | smurfa | smurfa-www.inets.net | dbSmurfa | Sleep | 0| | NULL | 538 | smurfa | smurfa-www.inets.net | dbSmurfa | Sleep | 0| | NULL | 537 | smurfa | smurfa-www.inets.net | dbSmurfa | Sleep | 0| | NULL | 546 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 1| Locked | SELECT Users.ID, Users.Alias | 549 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 1| Locked | SELECT Users.ID, Users.Alias | 533 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 1| Locked | SELECT ID, Alias, Name, Email | 532 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 1| Locked | UPDATE UserCounters SET Hits=Hits+1 | 530 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 1| Locked | UPDATE UserCounters SET Hits=Hits+1 | 550 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 1| Locked | SELECT MezzIndex.ID, MezzIndex.Title | 553 | root| localhost| NULL | Query | 0| NULL| show processlist | 555 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 1| Sending data| SELECT ID, Alias, Password | 556 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 0| Locked | SELECT Users.ID, Users.Alias | 558 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 1| Locked | UPDATE UserCounters SET Hits=Hits+1 | 557 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 1| Locked | UPDATE Users SET LastAccess= | 559 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 1| Locked | SELECT ID, Alias, Password | 560 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 0| Locked | SELECT Users.ID, Users.Alias | 561 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 0| Locked | UPDATE Users SET LastAccess= | 562 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 0| Locked | SELECT MezzIndex.ID, MezzIndex.Title | 563 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 0| Locked | SELECT MezzIndex.ID, MezzIndex.Title - Original Message - From: "Andrius Armonas" <[EMAIL PROTECTED]> To: "Johan Wahlström" <[EMAIL PROTECTED]> Sent: Tuesday, July 17, 2001 6:19 AM Subject: Re: locking problem! > if you're using write lock and do not unlock tables for a longer time, it is > normal. > > .:: Andrius Armonas ::. > .:: [EMAIL PROTECTED] ::. > .:: http://baubas.andrius.org ::. > - Original Message - > From: "Johan Wahlström" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Monday, July 16, 2001 10:12 PM > Subject: locking problem! > > > I have problem with table lockings scince i upgraded the MySQL version, and > i have tried with > both RedHat 7.1 rpm version 2.23.36 and compile myself with 2.23.39. The > result is the same. > > As can be seen in the "screenshot" below there is one process running, and a > lot sleeping. In > this example it happens to be an update running, but it might as well be an > INSERT or SELECT. > > When the lock is released the server starts working on all locked querries > at the same time, the > result is a slow server with a load averag
Re: .org
Dear Paul, I have a high respect and esteem for you, your book and your valuable and effective answers to questions made by dozens of MySQL users. I am really sorry if I have offended you with my previous e-mail. I think, we are very busy at work, and it is better to leave for the lawyers the solution of the MySQL-NuSphere conflict. However, just as a simple MySQL/PHP/Java/Apache user, I still thinking that MySQL is doing the right thing. Best regards, Santi Paul DuBois wrote: > At 9:34 AM +0100 7/16/01, Santi Chumbe wrote: > >Interesting position. The NuSpheres people are really very clever. > > If I'm reading your statement correctly, you appear to be using > "clever" > as an innuendo for "mendacious." If that is so, I must respectfully > disagree, and point out that statements of that nature are not helpful > > to the discussion. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
REPAIR TABLE question...
The manual http://www.mysql.com/doc/R/E/REPAIR_TABLE.html mentions the QUICK and EXTENDED options for REPAIR TABLE. But it does not say which is the default. Anyone know? Thanks, Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 <-- NEW MySQL 3.23.29: up 30 days, processed 233,041,009 queries (87/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Core dump under solaris
Hi All: I finally got mysql compiled and installed. The daemon started but when I try to use the client or any of the admin scripts I get a core dump. I ran the sql tests and it installed the test db and it managed to run the test ... I am running under soalris 2.5.1. Any help would be greatly appreciated. regards Imran.
segfaults in mysql_free_result
Hi there I'm having trouble in a multi-threaded client with segfaults in mysql_free_result(). After trawling the archives, I've found other people reporting the same problem, but the fix in each case has been to make sure that the pointer returned from mysql_store_result() is non-null. This is not useful in my case, unfortunately, because I've done that. I humbly request the assistance of the gathered ladies and gentlemen. - Running on FreeBSD 4.3-STABLE. - The library was compiled --without-server --enable-thread-safe-client, and because my own code is compiled with -pthread, I've changed libtool to cause libmysqlclient_r to be linked to libc_r. (Removes the ugly compile-time warnings.) - The client has a separate connection for each thread. If anybody is able to suggest where I'm going wrong, I'd be most grateful. allen A sample backtrace from gdb: Program received signal SIGSEGV, Segmentation fault. 0x481496fd in _thread_leave_cancellation_point () from /usr/lib/libc_r.so.4 (gdb) backtrace #0 0x481496fd in _thread_leave_cancellation_point () from /usr/lib/libc_r.so.4 #1 0x48149b41 in free () from /usr/lib/libc_r.so.4 #2 0x480a0d23 in my_no_flags_free () from /usr/home/allen/mysql//lib/mysql/libmysqlclient_r.so.10 #3 0x480a38bc in free_root () from /usr/home/allen/mysql//lib/mysql/libmysqlclient_r.so.10 #4 0x4809ad5d in free_rows (cur=0x8090380) at libmysql.c:414 #5 0x4809b4bf in mysql_free_result (result=0x811f580) at libmysql.c:661 #6 0x80599ab in adm_cleanup (result=0x811f580) at admlayer.c:3115 #7 0x8050607 in do_setstatus (m=0xbfadcf84, mcon=0xbfadcd54, r=0xbfadcf60) at messagehandling.c:2257 #8 0x8049990 in comms_handler (thing=0x8082000) at comms.c:230 #9 0x480d7ab3 in _thread_start () from /usr/lib/libc_r.so.4 #10 0x0 in ?? () The equivalent situation recorded in the mysql log (options: d:t:O,./trace/mysql.trace ) (excerpt) >mysql_real_query | enter: handle: bfadcd54 | query: Query = "UPDATE users SET status = '11' WHERE userid = '1'" | >net_flush | | >net_real_write | | mysql_read_query_result | >free_old_query | mysql_real_query | enter: handle: bfadcd54 | query: Query = "UPDATE contact SET changed = 1 WHERE child_id = '1'" | >net_flush | | >net_real_write | | mysql_read_query_result | >free_old_query | mysql_real_query | enter: handle: bfadcd54 | query: Query = "SELECT parent_id FROM contact WHERE child_id = '1'" | >net_flush | | >net_real_write | | mysql_read_query_result | >free_old_query | read_rows | | exit: Got 1 rows | unpack_fields | mysql_store_result | >read_rows | | exit: Got 2 rows | mysql_fetch_row mysql_fetch_row mysql_fetch_row | info: end of data mysql_free_result | enter: mysql_res: 811f580 # file stops here The code that created the above traces (left out adm_retrievecontact() because all it does is call mysql_fetch_row() until running out of rows; has no bearing on the situation as far as I can see): int do_setstatus( struct message *m, MYSQL *mcon, struct response *r ) { unsigned int id; char query[QUERYLENGTH]; struct setstatus *a = (struct setstatus *)m->attr; void *result; r->key = get_user_key( m->userid ); r->userid = m->userid; if (! user_logged_in( m->userid )) { return make_naksetstatus( IM_ERR_LGGDOUT, r->buffer ); } if (a->newstatus == 0) { return make_naksetstatus( IM_ERR_MSGATTR, r->buffer ); } result = adm_setstatus( mcon, m->userid, a->newstatus, 1 ); if (! result) { return make_naksetstatus( IM_ERR_SRVRERR, r->buffer ); } while (adm_retrievecontact( result, &id ) == ADM_MORE_ROWS) { record_contact( id ); } adm_cleanup( result ); return make_acksetstatus( r->buffer ); } ### int adm_cleanup( void *result ) { mysql_free_result( (MYSQL_RES *)result ); return 0; } ### void *adm_setstatus( MYSQL *mcon, unsigned int userid, short newstatus, short count ) { int i; char query[QUERYLENGTH]; MYSQL_RES *res; if (count > ADM_MAXRECURS) { return NULL; } sprintf( query, "UPDATE users SET status = '%d' WHERE userid = '%u'", newstatus, userid ); mysql_query( mcon, query ); i = mysql_errno( mcon ); switch (i) { case CR_SERVER_GONE_ERROR: /* reconnect (recurse) */ case CR_SERVER_LOST: /* recurse, try again */ return adm_setstatus( mcon, userid, newstatus, count + 1 ); break; case 0: /* success */ break; default: /* fail */ { char logentr
Re: MySQL Query .......
At 9:05 AM +0545 7/17/01, Deependra B. Tandukar wrote: >Greetings! > >I have two talbes in MySQL, Table1 and Table2. > >Table1 >iditem >1 apple >2 banana >3 orange > >Table2 >iditem >1 shoes >2 suit >3 mango > >If I want to add a row/column from Table1 to Table2, is it possible? May be >something like: >insert into Table1 (item) values ((Table2.item) where Table2.id=3); You want to use the INSERT INTO ... SELECT form of the INSERT statement. http://www.mysql.com/doc/I/N/INSERT_SELECT.html > >Looking forward to hearing from you all. > >Warm Regards, >DT -- Paul DuBois, [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Strange problem in installation
Hi, there is somethng strange in installing mysql using my own made charset. Configuration and compilation is going ok. But after that I can't use mysql not as root not as aother user... When I do safe_mysqld --skip-grant & all is Ok (logical) I can change privileges make drop databases, tables. When these changes is made I flushh all and try to start mysqld as normal, but there is the same problen i cant login an do anything with mysql database, it allows all users login without pass (strange) but when do use mysql (as root) permissio denied for root@localhost to database mysql... After more times installation I try to configure and compile with default character set (latin1). All is going OK all grants is working ok. The quiestion is in what measera character set affect mysql databases and tables -- Best regards, dodge 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: I got it hanged !
I've been experiencing a simmilar problem only with MyISAM tables. This is under 3.23.35 and 3.23.36 on Sparc/Solaris 2.7. For me the problem occurs when doing an ALTER TABLE or a simmilar operation (eg OPTIMIZE) on relatively large tables (>4 millon rows) with one or two indeces. The table in question is occasionally accessed by other queries; these access could occur during the ALTER TABLE. In this case, the application running the other queries would not mind seeing the old structure (for read) or wating until the ALTER is complete (for write). The symptom is the same as described below; with ALL threads (not just those touching the ALTERed table) getting stuck in "opening tables" or "closing tables". To recover it is necessary to terminate mysqld a SIGKILL; though data loss can usually be avoided by doing a FLUSH TABLES first (which also hangs) and also sending a SIGTERM and waiting a minute before sending the KILL. Would upgrading to 3.23.39 fix this problem? Or is it still a live bug in the current version? Heikki Tuuri wrote: > Hi! > > This may be a bug in the MySQL part of the code. > It looks like in sql_base.cc the pthread mutex LOCK_open > has been locked but not released by some thread. > Is it so that the ALTER TABLE went through without > hanging? > > It is crucial to know if all interesting threads are stuck waiting > for the LOCK_open mutex, or if some thread is stuck inside InnoDB > code. Did you look carefully through all the threads printing bt? > > In the processlist one thread is 'copying to tmp table'. What does bt say > for that thread? > > Anyway, to find out who failed to release the mutex we should > compile in debug code which would tell who locked LOCK_open, > and in which query. You could add a global char* variable in sql_base.cc > and store about on line 781 table_name to it when it reserves LOCK_open. > Now, if mysqld hangs, you can with gdb print the value of the global > variable > and you see what table was accessed when the pthread mutex was > locked. I think thd (user session object) does not contain the query > text as a string. It would be nice if it contained it and one could store > the > query text to the global variable. > > Monty, can you advise Peter about this? > > By the way, why do you need to ALTER a table which is simultaneously > used in queries? Why do you use LOCK TABLES when you dump a table? > In InnoDB you can just SELECT INTO OUTFILE, since InnoDB does a > consistent read by default. If you do several SELECT INTO OUTFILEs in the > same transaction you can dump several tables seen at the same snapshot > of the database. > > Regards, > Heikki > > -Original Message- > From: Peter Zaitsev <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> > Cc: [EMAIL PROTECTED] <[EMAIL PROTECTED]> > Date: Monday, July 16, 2001 6:08 PM > Subject: I got it hanged ! > > >Hello Heikki, > > > > mysql 3.23.39 Linux Innodb. > > > > I've got INNODB to hang quite simple way - I just run an alter table > > on a table which was used in many queries. > > I run "alter table table_groups add version int unsigned not null" > > > > I got mysql to be completely stock with the following result: > > > > 1) PROCESSLIST: > > > > As you see all queries got stuck it "opening tables" or "closing > > tables" > > > >+-+--++-+-+---+ > --+- > -+ > >| Id | User | Host | db | Command | Time | > State| Info > | > >+-+--++-+-+---+ > --+- > -+ > >| 1 | root | localhost | counter | Query | 295 | > Opening tables | lock tables heap.gstats write > | > >| 7 | root | localhost | | Sleep | 5747 | > | > | > >| 14 | titan| topaz.local| counter | Sleep | 469 | > | > | > >| 24 | titan| php.local | news| Sleep | 887 | > | > | > >| 290 | titan| saturn.local | counter | Query | 296 | > Opening table| UPDATE quickstat SET visitors=16421, hosts=16983, > hits=81173, reloads=3713, sessions=18826, jumps=63 | > >| 336 | titan| opal.local | counter | Sleep | 3387 | > | > | > >| 506 | titan| coral.local| counter | Sleep | 407 | > | > | > >| 534 | titan| suse.local | mlists | Sleep | 1110 | > | > | > >| 544 | titan| ruby.local | counter | Query | 302 | > Copying to tmp table | select > >cp.counter_id > >from > > counterproperty cp,table_groups tg, counterlayers cl, quickstat | > >| 565 | titan| php.local | counter | Sleep | 1715 | > | > | > >| 628 | ti
Re: Help! Installation MySQL-Max Failed
Date |Tue, 17 Jul 2001 10:27:59 +0800 >From |"tpchan" <[EMAIL PROTECTED]> Hello! T> Hi, T> Recently, I had downloaded a copy of Standard binary RPMs for T> MySQL-Max-3.23.39-1.i386.rpm and I try to installed it on Linux Red Hat 6.2. T> The command for installation as below: T> rpm -ivh MySQL-Max-3.23.39-1.i386.rpm. T> Here is the error I get after the installation. T> Giving mysqld a couple of seconds to restart T> var/tmp/rpm-tmp.45183: /etc/rc.d/init.d/mysql: No such file or directory T> I try looking mysql start script file but couldn't find it. I couldn't start T> the mysql server. I had a question here, do I need to install T> MySQL-3.23.39-1.i386.rpm and MySQL-client-3.23.39-1.i386.rpm, before I T> proceed to install MySQL-Max-3.23.39-1.i386.rpm? However in Windows version T> of Mysql, I just installed the MySQL-Max-3.23.39 and it's run fine. That's T> confusing me. T> Please assist me on this matter urgently. In short words you need to read Installing MYSQL chapter http://www.mysql.com/doc/I/n/Installing.html And especially http://www.mysql.com/doc/L/i/Linux-RPM.html ___ For technical support contracts, visit https://order.mysql.com/ This email is sponsored by SWSoft, http://www.asplinux.ru/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Grigory Bakunov <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft /_/ /_/\_, /___/\___\_\___/ <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL Query .......
Greetings! I have two talbes in MySQL, Table1 and Table2. Table1 iditem 1 apple 2 banana 3 orange Table2 iditem 1 shoes 2 suit 3 mango If I want to add a row/column from Table1 to Table2, is it possible? May be something like: insert into Table1 (item) values ((Table2.item) where Table2.id=3); Looking forward to hearing from you all. Warm Regards, DT - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: configure problem
> I have problem to run configure on my unix box. > > My OS is solaris 5.8. > gcc version is 2.95.2 > > I use gzip and gtar to extract the package with version mysql-3.23.39 > > See the below. I don't know what's the problem. http://home.earthlink.net/~jaymzh666/solaris.html Phil -- Insanity Palace of Metallica http://www.ipom.com [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
Help! Installation MySQL-Max Failed
Hi, Recently, I had downloaded a copy of Standard binary RPMs for MySQL-Max-3.23.39-1.i386.rpm and I try to installed it on Linux Red Hat 6.2. The command for installation as below: rpm -ivh MySQL-Max-3.23.39-1.i386.rpm. Here is the error I get after the installation. Giving mysqld a couple of seconds to restart var/tmp/rpm-tmp.45183: /etc/rc.d/init.d/mysql: No such file or directory I try looking mysql start script file but couldn't find it. I couldn't start the mysql server. I had a question here, do I need to install MySQL-3.23.39-1.i386.rpm and MySQL-client-3.23.39-1.i386.rpm, before I proceed to install MySQL-Max-3.23.39-1.i386.rpm? However in Windows version of Mysql, I just installed the MySQL-Max-3.23.39 and it's run fine. That's confusing me. Please assist me on this matter urgently. Thank you in advance. Emanduel Chan Tain Por System Engineer DotCom Consulting Sdn Bhd DID : 603-62763230 ext. 112 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 connection erroe
The problem is just as it states, "Access denied" ... You can also find the information that the username is 'root' and a password was supplied.. so the first thing to check out would be the password the script is using to connect with. Once that is corrected it should work fine. Hope that helps. ryan - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, July 16, 2001 2:53 AM Subject: help connection erroe > When am trying to connect to mysql am getting this error > > > "Warning: MySQL Connection Failed: Access denied for user: '[EMAIL PROTECTED]' > (Using password: YES) in /var/www/html/accounts/include/useradmin.php on line > 144 Unable to select database" > > What is the problem, Please do assist thanks > > Regards > > > Martin W. Kuria > Web Programmer > Bsc. Computer Science > Kenyaweb.com Ltd > www.kenyaweb.com > mail.kenyaweb.com > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: DELETING items
but before you issue this command and possibly trash your database, use select * from a_table where status='flag_value'; to look at the records which will be deleted. you may find some surprises. At 08:19 AM 7/16/01 -0400, you wrote: >Why not: > >delete from a_table where status='flag_value'; > >Please read the manual, this is one of the most basic operations you >can do, and is obvious the minute you look at > >http://www.mysql.com/doc > > >-- Original Message -- >From: "rob anderson" <[EMAIL PROTECTED]> >Date: Mon, 16 Jul 2001 13:14:20 +0100 > > >I am trying to delete records from a table, where the 'id' to be >deleted >should only happen if a certain flag (status) exists. > > > >The table contains one or more records for the same id, only the flag > >changes. > > > >I have tried > > > > > >create temporary table temp (id int not null); > > > >select id from tracking where tracking.status = 5; > > > >delete from tracking > >where id = select temp.id from temp; > > > >drop table temp; > > > > > > > >But this fails. > > > > > > > > > >I am not a SQL guru, and would appreciate any help > > > > > >Rob > > > > > > >-- >\\|// >(@ @) >---oOO---(_)---OOo >|| >| Mike Baranski | >| Security Managment Consulting | >| http://www.secmgmt.com | >|| >|| >-- > |__|__| >|| || > ooO Ooo >-- > > >- >Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail ><[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- tom marlin [EMAIL PROTECTED] fax / voice mail: 714 507 3802 ext 4881 Never be afraid to try something new. Remember that - amateurs built the ark. - professionals built the Titanic.
mysql.org (comments to old messages)
Hi! I am now finally back from Australia after a 36 hour, which involved 4 hours waiting for a airplane to be repaired, 3 plane changes and one missed airplane. Finally back in Finland, we got the message that our baggage had been lost on the way :( Australia was great, but it's real nice to be back home. I am in this email trying to shortly comment on the questions that have been left unanswered, in an attempt to ensure that everyone understands my standpoint in this case. Those that are already fed up with this discussion, please go back to your usual business of tuning MySQL, filing bug reports or helping other users on the MySQL email lists. Those that want a little more background information are free to continue. From: Thomas J Keller <[EMAIL PROTECTED]> forwarded email from Britt Johnson: Britt> Your comments about us not participating in any meaninful fashion Britt> in the open source community are disappointing because it means Britt> NuSphere has not done a good job communicating its work, I believe Britt> we provide a significant service and have allowed many people who Britt> otherwise could not use open source software to use it because of Britt> our work on improving windows ports, integration of components, Britt> and major features. We contribute back fixes and improvements to Britt> many open source communities including apache, perl, php and mysql. Britt> Much of that work is available at no cost through downloads at our Britt> website. I'd invite you to download and try NuSphere MySQL and Britt> see an example of what we have done. I found the above statement by Britt confusing. It's hard to say what NuSphere has been doing and not done. Apart from the crypt function, which I couldn't include in MySQL, and some small changes required to get Gemini to work within MySQL, I can't just now remember any patches or changes that NuSphere has contributed to the MySQL server. If there has been any other code contributions, they have been minor and infrequent. Britt> The importance of our investment is reflected in Monty's own words: Britt> "NuSphere has identified a very important technical enhancement Britt> needed to transform MySQL into an enterprise-enabled database capable Britt> of competing with commercial heavyweights," said Michael "Monty" Britt> Widenius, chief technology officer of MySQL AB. "In MySQL's five-year Britt> history, this is the most significant contribution from a source Britt> outside MySQL AB that has ever occurred." This is an interesting item (at least for me). The background was that NuSphere said they would release Gemini in January 2001 and wanted to get some publicity out of this. NuSphere emailed me the above text and asked if I could put approve the above text for their press release where they would announce Gemini. We at MySQL wanted (at that time) to support them, so we said they could go ahead with the press release, but they had to some changes, which involved changing 'THE most' to 'one of the most' or 'a most significant'. Another thing is also that while NuSphere delayed the release of Gemini because of their own reasons, Heikki Tuuri at Innobase got interested in MySQL. His table handler, InnoDB, which has been included in the MySQL source releases since 3.23.34, is an as important contribution as Gemini. Britt> As we said last January, we planned on Gemini being released Britt> under an open source license as part of the launch of MySQL 4.0, Britt> but that release has not shipped so we have decided to release Britt> the source through mysql.org instead soon after its launch (the Britt> community needs to setup CVS to support that effort). Note that Britt> Gemini has both commercial and open source licenses just like Britt> MySQL itself and the products we are currently shipping are Britt> provided with a commercial license of Gemini. We absolutely Britt> believe we have the right to do this. We offered NuSphere to be included into the MySQL 3.23 release, just like BDB and InnoDB, but NuSphere was not interested. Britt seams to have missed to inform you here about one basic flaw in the above argument. The reason we at MySQL can provide MySQL under an open source and a commercial license is that the we have the copyright to all the GPL MySQL server code except Berkeley DB (which is not really GPL, but has a strict copyright), Gemini and InnoDB. This gives us the right to release the code under a standard commercial license, as long as we don't include any of the above components, without an approval from the copyright holders, into this release. We do have such agreements with InnoDB and and understanding of how to do this with the Berkeley DB people. NuSphere has the same benefit. They can release Gemini without MySQL under a commercial license. They can't not release Gemini with MySQL under any not GPL compatible license. The above statement by Britt is a clear violation of the GPL license. http://www.gnu.org/
Re: help connection erroe
Try connecting to 'localhost' instead unless your web server is different from your mysql server in which case, you'll need to give root permission to connect from 209.198.250.5. If not, try posting some code to the list. It'll make it easier for us to solve your problem. - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, July 16, 2001 15:53 Subject: help connection erroe > When am trying to connect to mysql am getting this error > > > "Warning: MySQL Connection Failed: Access denied for user: '[EMAIL PROTECTED]' > (Using password: YES) in /var/www/html/accounts/include/useradmin.php on line > 144 Unable to select database" > > What is the problem, Please do assist thanks > > Regards > > > Martin W. Kuria > Web Programmer > Bsc. Computer Science > Kenyaweb.com Ltd > www.kenyaweb.com > mail.kenyaweb.com > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Beginner help with selecting
Ok so SELECT * FROM Events, Djs, EventDjs WHERE Events.eventID = EventDjs.eventID AND Djs.DJID = EventDjs.DJID; should give you a list with the event and the dj etc, if you only want one event then add something like AND Events.Events.eventID = 'x' or whatever. cheers, noel On Tuesday, July 17, 2001 8:06 AM, Technodium.net [SMTP:[EMAIL PROTECTED]] wrote: > Well, let me give the complete details > > Let's say I have one table called events > with fields eventID and eventName > > Then one table called djs > with fields djID and djName > > And finally a table linking them all called eventdjs > with fields called eventID and djID > this table links one event with all the appropriate djs. > > I use the same linking tables for outlets and other infos.. those are many > to many relations. > > Now I want to select all djs from one event, this means taking info from > events and djs table, but using the 3rd table for the link.. that's what I'm > not able to do. > > There is a way to do it with a script that takes the list of djID from the > link table and then makes a new select.. but I'm sure there is a way to do > it at once.. > > I looked in the MySQL book from paul dubois and somewhere it states how to > change subselects into selects for mysql, but I can't acheive my goal. > > Any help appreciated > > Etienne > > > - Original Message - > > From: "Simon Green" <[EMAIL PROTECTED]> > > To: "'Technodium.net'" <[EMAIL PROTECTED]>; > <[EMAIL PROTECTED]> > > Sent: Monday, July 16, 2001 8:56 AM > > Subject: RE: Beginner help with selecting > > > > > > > Ok > > > So you give the event an ID and the DJ and Id > > > > > > Select dj.djid > > > from dj, event > > > where event.eventid = 'x'; > > > > > > I think this should work? > > > Long weekend so if this is not right it should be close! > > > > > > Simon > > > > > > -Original Message- > > > From: Technodium.net [mailto:[EMAIL PROTECTED]] > > > Sent: 16 July 2001 13:41 > > > To: [EMAIL PROTECTED] > > > Subject: Beginner help with selecting > > > > > > > > > Hello there, I would need some help with a select statement for my > > > databases. > > > > > > I've done all the design of the database and I think it's all good, but > I > > > can't make a select as I want to do it. > > > There is the problem: > > > I have one table for the list of events and one for the list of djs for > > this > > > event. > > > I have also one linking table with the list of events keys with their > > > according djs > > > > > > I would like to do a select so that for one event it gives me all the > > djs.. > > > But I'm not able to do it. > > > > > > And after that I'd like to dothe same to be able to get the djs, the > > > outlets, etc in less queries than getting the djs ID from the linking > > table > > > and then doing a new query in the dj table to get the info > > > > > > If you'd like more info please don't hesitate.. > > > > > > This bug is stopping my progress in the DB design and I can't get help > > > anywhere for this > > > > > > Etienne > > > > > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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
Shutting down Mysql
Hi Guys, What im looking at doing is working out the best way to safely shut down mysql so I can do a full backup of the system, then restart it back. (im running on a FreeBSD box) I know I can kill the PID and other drastic measures but I dont want to do anything that might corrupt the data. Which is the best method for stopping mysql and then restarting it ? mysqladmin shutdown ? and whats the best way to start it back up again just running the .sh file(s) from /usr/local/etc/rc.d ? Thanks Chris -- Chris Aitken - Administration/Database Designer - IDEAL Internet email: [EMAIL PROTECTED] phone: +61 2 4628 fax: +61 2 4628 8890 __-__ *** Big Brother *** It just shows that the dull will rule the world. And we will be watching 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: Next Newbie Question
> mysql> select vend_city+', '+vend_state+' '+vend_zip > -> from Vendors > -> order by vend_name > -> ; ... > 4 rows in set (0.01 sec) > > How do I do this in MySQL? SELECT CONCAT(vend_city, ', ', vend_state, ' ', vend_zip) FROM Vendors ORDER BY vend_name; - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Load data from text file/Excel worksheet
At 8:19 AM +0800 7/17/01, Erymuzuan Mustapa wrote: > I have an Excel worksheet saved as text file(tab delimited), >Load data works fine on my Win2k(MySQL 3.23.38) for bulk loading but on >MacOS X , MySQL 3.23.39 the same same file doesn't seem to work right, all I >got was malformed data. Using either LOAD DATA or mysqlimport. The file may not be the same on both systems. Perhaps the line endings have changed, for example. What does your LOAD DATA statement look like? If you're using LINES TERMINATED BY '\r\n' try LINES TERMINATED BY '\r' instead and see if that works. > > >If there's a better way for me to accomplish this? If not then could someone >help me out with this instead. > >Thanks in advance >Erymuzuan > >BespokeWorld -- Paul DuBois, [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Next Newbie Question
At 5:54 PM -0700 7/16/01, Bob Rea wrote: >Still reading SQL in 10 Minutes, and here is the next problem, string >concatenation in SELECT queries. The book has this query and this >result. The other data is there in the table. > >mysql> select vend_city+', '+vend_state+' '+vend_zip > -> from Vendors > -> order by vend_name > -> ; >++ >| vend_city+', '+vend_state+' '+vend_zip | >++ >| 44333 | >| 4 | >| 9 | >| 1 | >++ >4 rows in set (0.01 sec) > >How do I do this in MySQL? If + means concatenation, then try: CONCAT(vend_city, ', ', vend_state, ' ', vend_zip) > >Alternatively, can anyone suggest a good tutorial for MySQL online >that covers the topics the book does? The book's web site is at >http://www.forta.com/books/0672316641/ I'd suggest reading chapter 5 of the MySQL Reference Manual to get an idea of the differences between MySQL's SQL and other SQLs. That'll give you some information about converting queries for MySQL. > >-- >Bob Rea -- Paul DuBois, [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL for digital UNIX 4.0d
Hi, I'm appologise in advance if I've sent this to an inappropriate mailing list. I'm trying to find pre-compiled binaries for mySQL (any stable version) for Digital unix 4.0d. I'm no whiz on Unix and so would prefer not to have the headache of trying to compile from scratch. Are these binaries available, and if so from where? Any help much appreciated, Thanks, Steve Ford. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 connection erroe
When am trying to connect to mysql am getting this error "Warning: MySQL Connection Failed: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) in /var/www/html/accounts/include/useradmin.php on line 144 Unable to select database" What is the problem, Please do assist thanks Regards Martin W. Kuria Web Programmer Bsc. Computer Science Kenyaweb.com Ltd www.kenyaweb.com mail.kenyaweb.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
help connection erroe
When am trying to connect to mysql am getting this error "Warning: MySQL Connection Failed: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) in /var/www/html/accounts/include/useradmin.php on line 144 Unable to select database" What is the problem, Please do assist thanks Regards Martin W. Kuria Web Programmer Bsc. Computer Science Kenyaweb.com Ltd www.kenyaweb.com mail.kenyaweb.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: Next Newbie Question
Good tutorial http://www.mysql.com/articles/ddws/index.html enjoy Ken - Original Message - From: "Bob Rea" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, July 16, 2001 5:54 PM Subject: Next Newbie Question > Still reading SQL in 10 Minutes, and here is the next problem, string > concatenation in SELECT queries. The book has this query and this > result. The other data is there in the table. > > mysql> select vend_city+', '+vend_state+' '+vend_zip > -> from Vendors > -> order by vend_name > -> ; > ++ > | vend_city+', '+vend_state+' '+vend_zip | > ++ > | 44333 | > | 4 | > | 9 | > | 1 | > ++ > 4 rows in set (0.01 sec) > > How do I do this in MySQL? > > Alternatively, can anyone suggest a good tutorial for MySQL online > that covers the topics the book does? The book's web site is at > http://www.forta.com/books/0672316641/ > > -- > Bob Rea > > Fear of Hell is pernicious; > So is fear of Heaven. > > [EMAIL PROTECTED] http://www.sirius.com/~rear > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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
selecting the newest/oldest record...
Question: given data in a table such as id, value, date 0, value1, 1999-01-25 1, value2, 1999-01-02 2, value2, 1999-01-04 3, value1, 1999-01-22 4, value2, 2000-01-01 how can i select the latest 'id' for a given same set of 'value' based on 'date'? ie: i would like to be able to get records id's 0 and 4 from above, since id "0" has the latest date for value1 (1999-01-25) and id "4" has the least date for value2 (2000-01-01). i was thinking of using a least function on it, but my problem is I don't know how exactly it can be done without some (outside) processing. Am I missing something? thanks, --jim -- And then there was one... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Different logs for different databases?
> > I was wondering, is it possible to have different log files for > > different databases somehow? > >RedBack? You're just down the street... Sort of. Ya, but for how long (for either of us). ahem. >difficult to do (add the necessary code to MySQL), provided that the >logging code is as straightforward as the binary logging code. i figured something like that, though i don't know the internals. it seems it knows what's being connected to, so to make seperate logfiles can't be too hard. i keep running into this issue, but oh well. thanks for the input. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Next Newbie Question
Still reading SQL in 10 Minutes, and here is the next problem, string concatenation in SELECT queries. The book has this query and this result. The other data is there in the table. mysql> select vend_city+', '+vend_state+' '+vend_zip -> from Vendors -> order by vend_name -> ; ++ | vend_city+', '+vend_state+' '+vend_zip | ++ | 44333 | | 4 | | 9 | | 1 | ++ 4 rows in set (0.01 sec) How do I do this in MySQL? Alternatively, can anyone suggest a good tutorial for MySQL online that covers the topics the book does? The book's web site is at http://www.forta.com/books/0672316641/ -- Bob Rea Fear of Hell is pernicious; So is fear of Heaven. [EMAIL PROTECTED] http://www.sirius.com/~rear - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Load data from text file/Excel worksheet
I have an Excel worksheet saved as text file(tab delimited), Load data works fine on my Win2k(MySQL 3.23.38) for bulk loading but on MacOS X , MySQL 3.23.39 the same same file doesn't seem to work right, all I got was malformed data. Using either LOAD DATA or mysqlimport. If there's a better way for me to accomplish this? If not then could someone help me out with this instead. Thanks in advance Erymuzuan BespokeWorld - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
FreeBSD issues
Hello, I am working with MySQL (Ver 9.38 Distrib 3.22.32, for -freebsd4.1.1 (i386)) on FreeBSD 4.2-STABLE running (I believe) on a dual 233 Intel box. We have been having some problems as of recently where system swap becomes flooded and the system is brought to a halt. We believe we have isolated the problem to MySQLd. In searching through the mysql discussion list, I noticed several people raising similar issues on FreeBSD systems. I did not however come across any solutions. Perhaps I missed something. What are the current install recommendations for the above mentioned system, and has the above mentioned problem been resolved? Regards, Michael Caplan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: transactions
hi! > "Pete" == Pete Kuczynski <[EMAIL PROTECTED]> writes: Pete> Hi, Pete> I updated my tables to BDB, but it still shows MYISAM. Pete> Do I need to remove mysql and reinstall it compiled for BDB like the Pete> manual suggests? I'm using nusphere's mysql on NT4 server, so I'm not Pete> shure that's even possible. Pete> http://www.mysql.com/doc/B/D/BDB_install.html Pete> Pete I don't think NuSphere MySQL version supports BDB tables. If you want to try these out, you should download MySQL-Max from http://www.mysql.com/downloads/mysql-max-3.23.html With NuSphere's distribution, you should be able to use GEMINI tables instead of BDB tables. Have you tried this? 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: Problems installing under solaris 2.5.1 ... Fixed
Not a problem, glad I could assist you. Yeah I've ended up running into major problems with the packages my self on older versions of solaris running on newer hardware. Hopefully the maintainer will upgrade his/her hardware at some point. Anyone want to donate? ;-) "[EMAIL PROTECTED]" wrote: > > Hi Colin: > > I once again want to thank you for the info. I had indeed installed a > 'package' gcc compiler from sunfreeware. I followed your advice and I > downloaded gcc 2.95.3 source and compiled it on the machine that I was > trying to install mysql and sure enough I got it compiled. This would surely > add weight to your argument as to why it failed ... perhaps the people who > used the packaged compilers and got it to work was indeed using the same > machine that sunfreeware used to create the package. > > You certainly pointed me in the right direction and saved me a LOT of > frustration. > > Best regards > Imran. > > - Original Message - > From: "Colin Faber" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Cc: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Sunday, July 15, 2001 10:01 PM > Subject: Re: Problems installing under solaris 2.5.1 > > > You need to make sure that the gcc on your box is build on that box, > > Using a package won't do it, most of them where compiled on greater or > > lesser hardware versions than you might be running, This in turn causes > > the compiler it self to think that its running in cross-compile mode > > and mysql won't allow a cross compile(er) build. > > > > > > > > Martin Cameron wrote: > > > > > > Shouldn't it be ./configure --prefix=/usr/local/mysql > > > > > > On Mon, 16 Jul 2001 12:44, you wrote: > > > > I am trying to compile mysql by it is failing in the ./configure step. > I am > > > > running solaris 2.5.1 , gcc 2.95, binutils 2.11.2. It fails with the > > > > following error > > > > > > > > ./configure -prefix=/usr/local/mysql > > > > . > > > > . > > > > > > > > loading cache ./config.cache > > > > checking for a BSD compatible install... ./install-sh -c > > > > checking for bison... no > > > > checking for byacc... no > > > > checking for pdftex... no > > > > checking return type of sprintf... configure: error: can not run test > > > > program while cross compiling > > > > > > > > any help would be greatly appreciated. > > > > > > > > regards > > > > Imran. > > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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
Problems installing under solaris 2.5.1 ... Fixed
Hi Colin: I once again want to thank you for the info. I had indeed installed a 'package' gcc compiler from sunfreeware. I followed your advice and I downloaded gcc 2.95.3 source and compiled it on the machine that I was trying to install mysql and sure enough I got it compiled. This would surely add weight to your argument as to why it failed ... perhaps the people who used the packaged compilers and got it to work was indeed using the same machine that sunfreeware used to create the package. You certainly pointed me in the right direction and saved me a LOT of frustration. Best regards Imran. - Original Message - From: "Colin Faber" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, July 15, 2001 10:01 PM Subject: Re: Problems installing under solaris 2.5.1 > You need to make sure that the gcc on your box is build on that box, > Using a package won't do it, most of them where compiled on greater or > lesser hardware versions than you might be running, This in turn causes > the compiler it self to think that its running in cross-compile mode > and mysql won't allow a cross compile(er) build. > > > > Martin Cameron wrote: > > > > Shouldn't it be ./configure --prefix=/usr/local/mysql > > > > On Mon, 16 Jul 2001 12:44, you wrote: > > > I am trying to compile mysql by it is failing in the ./configure step. I am > > > running solaris 2.5.1 , gcc 2.95, binutils 2.11.2. It fails with the > > > following error > > > > > > ./configure -prefix=/usr/local/mysql > > > . > > > . > > > > > > loading cache ./config.cache > > > checking for a BSD compatible install... ./install-sh -c > > > checking for bison... no > > > checking for byacc... no > > > checking for pdftex... no > > > checking return type of sprintf... configure: error: can not run test > > > program while cross compiling > > > > > > any help would be greatly appreciated. > > > > > > regards > > > Imran. > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 simple SQL SELECT
[This is an email copy of a Usenet post to "mailing.database.mysql"] Martin, Here is how you can do what you want using a temporary table. Note that using this method, if you have two guys who play the same position, and they have an equal number of points, it'll select both records. mysql> CREATE TABLE Player (id INT NOT NULL, name CHAR(24) NOT NULL, pos CHAR(2) NOT NULL, pts INT NOT NULL, PRIMARY KEY (id)); Query OK, 0 rows affected (0.02 sec) mysql> INSERT INTO Player VALUES (1, "John", "LW", 12), (2, "Jim", "RW", 18), (3, "Pete", "LW", 30), (4, "Sam", "C", 14), (5, "Larry", "RW", 25), (6, "Harry", "RW", 43), (7, "Mike", "C", 4), (8, "Louise", "LW", 76); Query OK, 8 rows affected (0.03 sec) Records: 8 Duplicates: 0 Warnings: 0 mysql> CREATE TEMPORARY TABLE t1 SELECT pos,MAX(pts) AS pts FROM Player GROUP BY pos; Query OK, 3 rows affected (0.03 sec) Records: 3 Duplicates: 0 Warnings: 0 mysql> SELECT Player.* FROM Player,t1 WHERE Player.pos=t1.pos AND Player.pts = t1.pts; +++-+-+ | id | name | pos | pts | +++-+-+ | 4 | Sam| C | 14 | | 8 | Louise | LW | 76 | | 6 | Harry | RW | 43 | +++-+-+ 3 rows in set (0.03 sec) -- Jeff S Wheeler [EMAIL PROTECTED] Software DevelopmentFive Elements, Inc http://www.five-elements.com/~jsw/ database sql query table In article <[EMAIL PROTECTED]>, "Martin Boudreau" <[EMAIL PROTECTED]> wrote: > Hello there, > > I have a problem making a simple SQL query > > Let's say I have a table of hockey players. -- > |ID|NAME |POS|PTS| > -- > |01|John Do | LW| 12| > |02|Jim Do | RW| 18| > |03|Pete Do | LW| 30| > |04|Sam Do | C| 14| > |05|Larry Do | RW| 25| > |06|Harry Do | RW| 43| > |07|Mike Do | C| 4| > |08|Louise Do| LW| 76| > -- > > And I would like to select the player witch has the mose PTS in each > POS. Something that would return > > -- > |ID|NAME |POS|PTS| > -- > |04|Sam Do | C| 14| > |06|Harry Do | RW| 43| > |08|Louise Do| LW| 76| > -- > > TIA > > Martin Boudreau - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 mysql.users table props be modified?
Hello All, I have need to modify users table in mysql database. I wish to expand the user column from 16 chars to 128 chars. Will this cause problems with MySQL server engine and will it recognize and use my changes? What is maximum size allowed and also can I safely expand width of database name field? Can I make these changes just to the databse tables or must I recompile MySQL for new sizes? Thanks, Jose - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Strange behaviour (bug ?) when closing MySQL.
Hi, I just experienced a strange bug in MySQL 3.23.39 I couldn't explain (and couldn't reproduce, it's why I post it on this list ;)) I misconfigured my my.cnf, so MySQL didn't found the host.frm. The strange behaviour is just after the normal shutdown of mysql : 010717 00:01:19 mysqld started 010717 0:01:19 /var/lib/mysql/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 010717 0:01:19 /var/lib/mysql/libexec/mysqld: Normal shutdown mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked agaist is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail key_buffer_size=268431360 record_buffer=8384512 sort_buffer=8388600 max_used_connections=0 max_connections=1000 threads_connected=0 It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer)*max_connections = 4059220 K bytes of memory Hope that's ok, if not, decrease some variables in the equation Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Cannot determine thread, fp=0xbf5ff638, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x806add4 0x810fdd8 0x806a2b7 0x806de2b 0x810d70e 0x8143b5a New value of fp=(nil) failed sanity check, terminating stack trace! Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it The manual page at http://www.mysql.com/doc/C/r/Crashing.html contains information that should help you find out what is causing the crash Fatal signal 11 while backtracing 010717 00:01:19 mysqld ended I retried several times to reproduce the bug, no way :( The server is perfectly stable and was running for days MySQL without a glitch, it's why I don't think the hardware could be involved in this issue. Do you have any idea of how it could have been happened ? Thank you, Jocelyn Fournier Presence-PC
Re: MYSQL on RedHat 7.1.
On Monday 16 July 2001 15:03, Kalpesh Modha wrote: > Hello. > > I am trying to get mysql working on RedHat 7.1 and it works fine however, > when I try to make a local connection from either Java or PHP. I get a > connection refused message. Whats missing ? > > Thanks for your help in advance. You need to grant the user you are connecting as the appropriate rights from the appropriate host. The jdbc driver uses the default mysql port when connecting(check that mysql are listening to the default port), and if you also connect from the same machine as you run the server, the client will be connecting from 'localhost', or the hostname of your computer, the stacktrace from your javaprogram, or a mysql logfile should tell you which host. So you need to grant the user in question the right to connect to the server from 'localhost'. MySQL manual will tell you how to fo that. -- Nils O. Selåsdal - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 do I do this?
[This is an email copy of a Usenet post to "mailing.database.mysql"] Just insert a row with the initial value you want minus one, and then delete it. That will make the table do what you want. mysql> INSERT INTO Orders VALUES (-1, "", NOW(), -1, 125478); Query OK, 1 row affected (0.03 sec) mysql> DELETE FROM Orders WHERE OrderNumber=125478; Query OK, 1 row affected (0.02 sec) mysql> INSERT INTO Orders VALUES (-1, "", NOW(), -1, 0); Query OK, 1 row affected (0.02 sec) mysql> SELECT LAST_INSERT_ID(); +--+ | last_insert_id() | +--+ | 125479 | +--+ 1 row in set (0.02 sec) -- Jeff S Wheeler [EMAIL PROTECTED] Software DevelopmentFive Elements, Inc http://www.five-elements.com/~jsw/ database sql query table In article <9iqcs7$5n6$[EMAIL PROTECTED]>, "Bob" <[EMAIL PROTECTED]> wrote: > Hi, > I'm a newbie to databases so please excuse my ignorance. How do I change > the value of the OrderNumber column in this table? It currently starts > at one (obviously). How do I get it so that it starts at 125478 or > something? > > CREATE TABLE Orders ( > BuyerID BIGINT NOT NULL, > UserID VARCHAR(100) NOT NULL, > Date VARCHAR(100) NOT NULL, > OrderTotal DECIMAL(8,2) NOT NULL, > OrderNumber BIGINT NOT NULL AUTO_INCREMENT, PRIMARY KEY (OrderNumber) > ); > > thanks, > BOB. > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Beginner help with selecting
Well, let me give the complete details Let's say I have one table called events with fields eventID and eventName Then one table called djs with fields djID and djName And finally a table linking them all called eventdjs with fields called eventID and djID this table links one event with all the appropriate djs. I use the same linking tables for outlets and other infos.. those are many to many relations. Now I want to select all djs from one event, this means taking info from events and djs table, but using the 3rd table for the link.. that's what I'm not able to do. There is a way to do it with a script that takes the list of djID from the link table and then makes a new select.. but I'm sure there is a way to do it at once.. I looked in the MySQL book from paul dubois and somewhere it states how to change subselects into selects for mysql, but I can't acheive my goal. Any help appreciated Etienne > - Original Message - > From: "Simon Green" <[EMAIL PROTECTED]> > To: "'Technodium.net'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Monday, July 16, 2001 8:56 AM > Subject: RE: Beginner help with selecting > > > > Ok > > So you give the event an ID and the DJ and Id > > > > Select dj.djid > > from dj, event > > where event.eventid = 'x'; > > > > I think this should work? > > Long weekend so if this is not right it should be close! > > > > Simon > > > > -Original Message- > > From: Technodium.net [mailto:[EMAIL PROTECTED]] > > Sent: 16 July 2001 13:41 > > To: [EMAIL PROTECTED] > > Subject: Beginner help with selecting > > > > > > Hello there, I would need some help with a select statement for my > > databases. > > > > I've done all the design of the database and I think it's all good, but I > > can't make a select as I want to do it. > > There is the problem: > > I have one table for the list of events and one for the list of djs for > this > > event. > > I have also one linking table with the list of events keys with their > > according djs > > > > I would like to do a select so that for one event it gives me all the > djs.. > > But I'm not able to do it. > > > > And after that I'd like to dothe same to be able to get the djs, the > > outlets, etc in less queries than getting the djs ID from the linking > table > > and then doing a new query in the dj table to get the info > > > > If you'd like more info please don't hesitate.. > > > > This bug is stopping my progress in the DB design and I can't get help > > anywhere for this > > > > Etienne > > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Beginner help with selecting
Well, let me give the complete details Let's say I have one table called events with fields eventID and eventName Then one table called djs with fields djID and djName And finally a table linking them all called eventdjs with fields called eventID and djID this table links one event with all the appropriate djs. I use the same linking tables for outlets and other infos.. those are many to many relations. Now I want to select all djs from one event, this means taking info from events and djs table, but using the 3rd table for the link.. that's what I'm not able to do. There is a way to do it with a script that takes the list of djID from the link table and then makes a new select.. but I'm sure there is a way to do it at once.. I looked in the MySQL book from paul dubois and somewhere it states how to change subselects into selects for mysql, but I can't acheive my goal. Any help appreciated Etienne - Original Message - From: "Simon Green" <[EMAIL PROTECTED]> To: "'Technodium.net'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, July 16, 2001 8:56 AM Subject: RE: Beginner help with selecting > Ok > So you give the event an ID and the DJ and Id > > Select dj.djid > from dj, event > where event.eventid = 'x'; > > I think this should work? > Long weekend so if this is not right it should be close! > > Simon > > -Original Message- > From: Technodium.net [mailto:[EMAIL PROTECTED]] > Sent: 16 July 2001 13:41 > To: [EMAIL PROTECTED] > Subject: Beginner help with selecting > > > Hello there, I would need some help with a select statement for my > databases. > > I've done all the design of the database and I think it's all good, but I > can't make a select as I want to do it. > There is the problem: > I have one table for the list of events and one for the list of djs for this > event. > I have also one linking table with the list of events keys with their > according djs > > I would like to do a select so that for one event it gives me all the djs.. > But I'm not able to do it. > > And after that I'd like to dothe same to be able to get the djs, the > outlets, etc in less queries than getting the djs ID from the linking table > and then doing a new query in the dj table to get the info > > If you'd like more info please don't hesitate.. > > This bug is stopping my progress in the DB design and I can't get help > anywhere for this > > Etienne > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: FW: What commands to "insert" to the table from data inprocess memory, not a file?
At 5:39 PM -0400 7/16/01, Simon Lee wrote: >Hi: > >I have a process that will be receiving a bulk of data, say, every 5 >minutes. > >In the program, I can: > >1. Use the "Insert into" command to put the data into the table one at a >time, >(Drawback: it would be very slow for each query to put in the data). Or > >2. Save the whole data into a file, then use "load data infile". >(Drawback: put the data in a file, then "load", is one step extra too.) > >Is there a way (or a command) that I can just put the data into the table, >from the process memory? You have to use a SQL statement of some kind. You might want to use approach 1, but write a single INSERT statement that loads multiple rows. INSERT INTO tbl_name (col_names VALUES (values for row 1), (values for row 2), (values for row 3), etc. This is much more efficient than a set of single-row INSERTs. More information: http://www.mysql.com/doc/I/N/INSERT.html > >You help is appreciated. > >Simon Lee >Wide Area Network Design Lab >732-868-0100 ext 267 -- Paul DuBois, [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
WARNING!!! DON'T READ THIS IF YOU DON'T LIKE MONEY
WOW THIS REALLY WORKS!!! Dear Friend & Future Millionaire: AS SEEN ON NATIONAL TV: Making over half a million dollars every 4-5 months from your home for an investment of only $25 U.S. Dollars expense one time. THANKS TO THE COMPUTER AGE AND THE INTERNET!! BE A MILLIONAIRE LIKE THE OTHERS WITH IN A YEAR!!! Before you say "BULL" please read the following. This is the letter you have beeen hearing about on the news lately. Due to the populartity of this letter on the inernet , A national weekly news program recently devoted an entire show to the investigation of this program described below, to see if it really can make people money. The show also investigated wheather or not the program was legal. Their findings proved once and for all that there are absolutely NO LAWS prohibiting the participation in the program and if people can follow the simple instrucyions, they are bound to make some mega bucks with only $25 out of pocket cost". DUE TO THE RECENT INCREASE OF POPULARITY & RESPECT THIS PROGRAM HAS ATTANED, IT IS CURRENTLY WORKING BETTER THAN EVER. This is what one had to say:"Thanks to this profitable opportunity, I was approached many times before but each time I pased on it. I am so glad I finally joined to see what one could expect in return for the minimal effort and money required. To my astonishment, I recieved total $610,470.00 in 21 weeks, with money still comming in." Pam Hedland, Fort Lee New Jersey. Here is another testimonial: "This program has been around for a long time but I never believed in it. But one day when I recieved this again in the mail I decided to gamble my $25 on it. I followed the simple instructions and walaa.3 weeks later the money started to come in. First month I only made $240.00 but the next two months I made a total of $290,000.00. So far in the past 8 months by re-entering the program, I have made over $710,000.00 and I am playing it again. The key to success in this program is to follow the the simple steps and NOT change anything." More testimonials later but first. =PRINT THIS NOW FOR YOUR FUTURE REFERANCE= $$$ If you would like to make at least $500,000 every 4 to 5 months easily and comfortably, please read the following...THEN READ IT AGAIN and AGAIN!!! $$$ FOLLOW THE SIMPLE INSTRUCTIONS BELOW AND YOUR FINANCIAL DREAMS WILL COME TRUE, GUARANTEED! INSTRUCTIONS =Order all 5 reports shown on the list below= For each report, send $5 CASH ,THE NAME & NUMBER OF THE REPORTYOU ARE ORDERINGand YOUR E-MAIL ADDRESS to the person whose name appears ON THAT LIST next to the report. MAKE SURE YOUR RETURN ADDRESS IS ON THE ENVELOPE TOP LEFT CORNER in case of any mail problems. ===When you place your order, make sure you order each of the 5 reports. You will need all 5 reports so that you can save them on your computer and resell them. YOUR TOTAL COST $5 X 5=$25.00. Within a few days you will recieve, via e-mail, each of the five reports from these 5 different individuals. Save them on your computer so they will be accessible for you to send to the 1000's of people who will order them from you. Also make a floppy of these reports and keep it on your desk in case something happens to your computer. IMPORTANT-DO NOT alter the names of the peple who are listed next to each report, or their sequence on the list, in any way, other than what is instructed below in step "1 through 6" or you will lose out on the majority of your porfits, Once you understand the way this works you will also see how it does not work if you change it. Remember, this method has been tested, and if you alter it, it will NOT work!!! People have tried to put there friends/relatives names on all five thinking they could get all the money. But it does not work this way. Believe us, we have all tried to be greedy and then nothing happened. So DO NOT try to change anything other than what is instructed. Because if you do it will not work for you. Remember, honesty reaps the reward 1After you have ordered all 5 reports , take this advertisement and REMOVE the name & address of the person in REPORT # 5. This person has made it through the cycle and is no doubt counting there fortunes. 2 Move the name & address in REPORT #4 down To REPORT #5. 3 MOVE the name & address in REPORT #3 down To REPORT #4. 4 MOVE the name & address in REPORT #2 down To REPORT #3. 5 MOVE the name & address in REPORT #1 down To REPORT #2. 6 Insert YOUR name & address in the REPORT #1 Position. PLEASE MAKE SURE you copy every name & address ACCURATELY! == Take this entire letter ,with the modified list of names, and save it on your computer. DO NOT MAKE ANY OTHER CHANGES. Save this on a disk as well just in c
FW: What commands to "insert" to the table from data in process memory, not a file?
Hi: I have a process that will be receiving a bulk of data, say, every 5 minutes. In the program, I can: 1. Use the "Insert into" command to put the data into the table one at a time, (Drawback: it would be very slow for each query to put in the data). Or 2. Save the whole data into a file, then use "load data infile". (Drawback: put the data in a file, then "load", is one step extra too.) Is there a way (or a command) that I can just put the data into the table, from the process memory? You help is appreciated. Simon Lee Wide Area Network Design Lab 732-868-0100 ext 267 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Compiling in BSD
First off, what BSD? There are a few of them... and what version? Sometimes --with-low-memory doesnt seem to work... What I have done in the past to get it to compile is edit the Makefile in that directory, find the line that compiled sql_yacc.cc, and add the compiler flag -O0 ... Sure that turns optimizations off, but atleast the file will compile. Another solution is to allow the compiler to use > 256megs of ram but that isnt an option on every server. Hope that helps. ryan > Hello All. > I try compile in BSD from source. > I have an account but NOT root access. > > 1-At myisam subdir says 'don't know how create mi_test_all' > erasing proper lines at Makefile, solves the problem, but > why says this message? > > 2-the infamous file sql_yacc.cc says 'virtual memory exhausted'... >..and YES, I use the --with-low memory (-fno-inline) option... > any solution?3.21 compiles fine. 3.22 have same problem... > some 3.22.XX compiles OK but currently are not offered in FTP... > > James A. Puig > [EMAIL PROTECTED] > > - Original Message - > From: "Rabia MEDDOURI - SERMA/LEPP" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Monday, July 16, 2001 10:54 AM > Subject: > > > > >Description: > > > > Hello > > I want to installe MySQL, but i'm not root (my user is: meddouri). > > I have only change the location where 'mysqlacess' script expect to find > the 'mysql' client. > > I have create grant tables with the scripts mysql-install_db. > > But i can't set a password for the mysql root user. > > I try to do this with : > > ./bin/mysqladmin -u meddouri -h protee -P 23 -p password 'new-password' > > then > > Enter password: ** > > > > The script have finished white the follow message : > > > > ./bin/mysqladmin: connect to server at 'protee' failed > > error: 'Lost connection to MySQL server during query' > > > > thanks for your help > > > > >How-To-Repeat: > > > > >Fix: > > > > > > >Submitter-Id: > > >Originator: > > >Organization: > > > > >MySQL support: [none | licence | email support | extended email support ] > > >Synopsis: > > >Severity: > > >Priority: > > >Category: mysql > > >Class: > > >Release: mysql-3.23.39 (Official MySQL binary) > > >Server: ./mysqladmin Ver 8.21 Distrib 3.23.39, for sun-solaris2.7 on > sparc > > Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB > > This software comes with ABSOLUTELY NO WARRANTY. This is free software, > > and you are welcome to modify and redistribute it under the GPL license > > > > Server version 3.23.39 > > Protocol version 10 > > Connection Localhost via UNIX socket > > UNIX socket /tmp/mysql.sock > > Uptime: 1 hour 52 sec > > > > Threads: 1 Questions: 14 Slow queries: 0 Opens: 0 Flush tables: 2 > Open tables: 0 Queries per second avg: 0.004 > > >Environment: > > > > System: SunOS protee 5.7 Generic_106541-12 sun4u sparc SUNW,Ultra-5_10 > > Architecture: sun4 > > > > Some paths: /usr/local/bin/perl /usr/xpg4/bin/make /usr/local/bin/gmake > /usr/local/bin/gcc /product/SUNWspro/bin/cc > > GCC: Reading specs from > /usr/local/lib/gcc-lib/sparc-sun-solaris2.7/2.95.2/specs > > gcc version 2.95.2 19991024 (release) > > Compilation info: CC='gcc' CFLAGS='-O3 -fno-omit-frame-pointer' > CXX='gcc' > > CXXFLAGS='-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions - > fno-rtti' LDFLAGS='' > > LIBC: > > -rw-r--r-- 1 bin bin 1694308 Jul 25 2000 /lib/libc.a > > lrwxrwxrwx 1 root root 11 Oct 22 1999 /lib/libc.so -> > ./libc.so.1 > > -rwxr-xr-x 1 bin bin 1115940 Jul 25 2000 /lib/libc.so.1 > > -rw-r--r-- 1 bin bin 1694308 Jul 25 2000 /usr/lib/libc.a > > lrwxrwxrwx 1 root root 11 Oct 22 1999 /usr/lib/libc.so -> > ./libc.so.1 > > -rwxr-xr-x 1 bin bin 1115940 Jul 25 2000 /usr/lib/libc.so.1 > > Configure command: ./configure --prefix=/usr/local/mysql > '--with-comment=Official MySQL > binary' --with-extra-charsets=complex --with-server-suffix= --enable-assembl > er --disable-shared > > 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 > > > > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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
Using IF to select table (from part of SELECT)?
Hi! Is it possible to use IF in the FROM part of a SELECT statement? I've got three tables: Profiles: ID: int CityID: int Cities1: ID: int Name: VarChar 255 Cities2: ID: int Name: VarChar 255 Now I'd like to use Cities2 if the CityID in the table Profiles is bigger than 7. Would this work? SELECT Cities.Name FROM Profiles, IF(Profiles.CityID > 7, Cities1, Cities2) AS Cities WHERE Profiles.ID = Cities.ID AND Profiles.ID = 4711; Thanks, Alexander Skwar filter: sql -- How to quote: http://learn.to/quote (german) http://quote.6x.to (english) Homepage: http://www.digitalprojects.com | http://www.iso-top.de iso-top.de - Die günstige Art an Linux Distributionen zu kommen Uptime: 5 hours 40 minutes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SQL Parser woes
>Description: I try to run mysql in conjunction with Apple WebObjects5 (the EnterpriseObjects Framework). This framework generates certain SQL Statements which fail (see How-To-Repeat). >How-To-Repeat: Ok first the "positive test": create table test ( name varchar(255), test_id varchar(255)); insert into test(name, test_id) values ('1','2'); The above works without flaws.. The "negative test": mysql> create table user ( address int not null, email varchar(255) not null, first_name varchar(255) not null, last_name varchar(255) not null, login varchar(255) not null, pwd varchar(255) not null, state int not null, user_id int not null primary key); insert into user(address, email, first_name, last_name, login, pwd, state, user_id) values (1,'a','a','a','a','a',1,1); The above statement returns: ERROR 1064: You have an error in your SQL syntax near 'user(address, email, first_name, last_name, login, pwd, state, user_id) values (' at line 1 When I insert a whitespace between the tablename and the "(" everything works fine. In the "positive test" it works without whitespace... >Fix: >Submitter-Id: >Originator: >Organization: >MySQL support: none >Synopsis: SQL Parser woes >Severity: non-critical >Priority: medium >Category: mysql >Class: sw-bug >Release: mysql-3.23.39 (Source distribution) >Server: /usr/local/bin/mysqladmin Ver 8.21 Distrib 3.23.39, for apple-darwin1.3.3 on >powerpc Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.39 Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 1 day 3 hours 12 min 32 sec Threads: 1 Questions: 95 Slow queries: 0 Opens: 26 Flush tables: 1 Open tables: 4 Queries per second avg: 0.001 >Environment: System: Darwin localhost 1.3.7 Darwin Kernel Version 1.3.7: Sat Jun 9 11:12:48 PDT 2001; root:xnu/xnu-124.13.obj~1/RELEASE_PPC Power Macintosh powerpc Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/libexec/gcc/darwin/ppc/2.95.2/specs Apple Computer, Inc. version gcc-926, based on gcc version 2.95.2 19991024 (release) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxr-xr-x 1 root wheel 15 Jul 14 00:11 /usr/lib/libc.dylib -> libSystem.dylib Configure command: ./configure --mandir=/usr/local/share/man/ --with-innodb - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
table types
Hi, I understand mysql supported InnoDB and BDB table types for the purposes of transaction logging, which I need to use. Which is recommended by you folks for NT4 boxes. Pete ___ Pete Kuczynski Sr. Field Engineer DHL Airways Inc. Infrastructure Technology & Services (773)-462-9758 24/7 Helpdesk 1-800-434-5767 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Dump SQL editor thats cross-compatWin/Linux
Oh no you don't. Now be quiet! All of you! We don't want another of those (*shudders*) holy wars. And Fred Dinkler: Don't you never ever ask that again :-) Go find your own truth without disturbing the peace (or is it only a ceasefire?) =|8-) - Carsten - Original Message - From: "Mike Baranski" <[EMAIL PROTECTED]> To: "Steve Brazill" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, July 16, 2001 10:06 PM Subject: Re: Dump SQL editor thats cross-compatWin/Linux > -- Original Message -- > From: "Steve Brazill" <[EMAIL PROTECTED]> > Reply-To: "Steve Brazill" <[EMAIL PROTECTED]> > Date: Mon, 16 Jul 2001 11:32:24 -0700 > > >EMACS !! ick, yuck, blah !!! > > I'm always amazed how it's infiltrated the 'database' group (type) of > people > > Vi is 'bester' (you wanna talk about learning curves ?) > > Actually, I'm more of a programmer, and when I'm editing a 10K line > program in 20 different files, I sure do like etags, highgliting, and > the macro features. It'll compile for you, jump between error > messages, auto save files, all without leaving the keyboard. I > realize that vi does some of the same stuff, but emacs is to vi what > an RV is to a bicycle... > > MWB. > > - Original Message - > From: "Mike Baranski" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Monday, July 16, 2001 11:10 AM > Subject: Re: Dump SQL editor thats cross-compatWin/Linux > > > > Also, if you want the real deal, go get emacs, either at > > http://xemacs.org > > or http://www.gnu.org > > > > It's the best (no flames here), but has a pretty steep learning > curve. > > > > -- Original Message -- > > From: "Steve Brazill" <[EMAIL PROTECTED]> > > Reply-To: "Steve Brazill" <[EMAIL PROTECTED]> > > Date: Mon, 16 Jul 2001 10:48:08 -0700 > > > > >Don't forget that "WinVI" exists and can be found (and > > downloaded) at: > > > > http://www.winvi.de/en/ > > > > And for those who like the 'code warrior' or 'slickedit' type of > stuff > > (where different types of 'statements' are highlighted in different > > colors), > > there's "Code Genie" available at: > > > > http://www.code-genie.com/ > > > > > > - Original Message - > > From: "Carsten Gehling" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Monday, July 16, 2001 6:04 AM > > Subject: Re: Slightly off-topic... Dump SQL editor thats > > cross-compatWin/Linux > > > > > > > You could use VIM (cross-platform) or UltraEdit (Win32), the latter > > is > > > capable of reading and writing *nix compatible files even though > > it's only > > a > > > Win32 program. > > > > > > - Carsten > > > > > > - Original Message - > > > From: "Mike Cermak" <[EMAIL PROTECTED]> > > > To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > > > Sent: Monday, July 16, 2001 2:17 PM > > > Subject: Re: Slightly off-topic... Dump SQL editor thats > > > cross-compatWin/Linux > > > > > > > > > Fred- > > > > > > Try Jext, a Java-based editor available at www.jext.org. I've been > > using > > it > > > for a couple of weeks now to edit .php and .js source files, and > > it's done > > > fine by me (the source syntax color-coding has been a lifesaver on > a > > couple > > > of occasions), I imagine it would be fine for general text editing. > > > > > > Notepad? We don' need no STNKING Notepad... :-) > > > > > > > > > > > > Mike Cermak > > > Webmaster/Web Server Administrator > > > Buffalo Niagara Partnership, Inc. > > > [EMAIL PROTECTED] > > > [EMAIL PROTECTED] > > > 716/852-7100 x112 > > > > > > >>> "Fred Dinkler" <[EMAIL PROTECTED]> 07/14/01 01:34PM >>> > > > Creating and editing dbdump SQL files from local dev in Win2k, > > moving to > > > Linux for QA and production. > > > > > > Text files edited using Wordpad and Notepad have extraneous > line-end > > chars > > > (bold M). > > > > > > Any suggestions on configuration of any Win editor to save text > > without > > > garbage chars showing up on Liux side? > > > > > > Thanks, > > > Fred > > > Atlanta > > > > > > > > > > > > > - > > > Before posting, please check: > > >http://www.mysql.com/manual.php (the manual) > > >http://lists.mysql.com/ (the list archive) > > > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > > To unsubscribe, e-mail > > <[EMAIL PROTECTED]> > > > Trouble unsubscribing? Try: > > http://lists.mysql.com/php/unsubscribe.php > > > > > > > > > > > > > > > > > > > - > > > Before posting, please check: > > >http://www.mysql.com/manual.php (the manual) > > >http://lists.mysql.com/ (the list archive) > > > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > > To unsubscribe, e-mail > > <[EMAIL PROTECTED]> > > > Trouble unsubscribing? Try: > > http://lists.mysql.com/php/unsubscribe.php > > > > > > > >
RE: mysql.org
Open Invitation to NuSphere and Progress The people at MySQL AB would like to invite you, NuSphere Corporation and Progress Software Corporation, to talks on neutral soil for the purpose of resolving our disputes. We propose to meet on Wednesday 18 July 2001 and continue for as long as we need, possibly with a break for visiting the Open Source Convention in San Diego on 23 July onwards. We believe London represents neutral soil. It would require both parties to travel, but would provide you with an English-speaking forum. Also, airfares should be at about the same price level from Boston and from Stockholm and Helsinki, and neither of us has an office in England. We believe it makes sense to have 3 representatives from each side to cover at least the following: historic insight in the events in year 2000, top management responsibility today, ownership mandate. Therefore we would like to see Lorne Cooper, President, Britt Johnston, CTO and Joseph Alsop, CEO of Progress Software Corporation from your side. We would be represented by Marten Mickos, CEO, David Axmark, Co-founder, and Michael "Monty" Widenius, CTO. We propose the following agenda for the talks, and we welcome your suggestions on additions and changes: 1. Listing the disputes or disagreements at hand 2. Each party presenting its ideal outcome of the talks 3. Preliminary discussions on scenarios and alternatives 4. (Time for each party to contemplate the talks so far and communicate with its offices) 5. Each party presenting first suggestions on how to resolve the disputes 6. Detailed talks about the various alternatives 7. Final suggestions on models for resolving the disputes and working together 8. Final talks, with the aim to reach a conclusion We do not believe that lawyers would add value in this discussion, and we are not suggesting the presence of secretaries or other assistants. But frequent communication by each party with its home office would be appropriate. To enable both sides to focus on resolving all disputes, we would be prepared to agree to a mutual deferral of all legal proceedings, filings, deadlines and the like between today and the scheduled end of our talks (the lawyers could figure out that part). If you accept this invitation, please ether respond in this forum or privately to MySQL AB. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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.org
I hate to differ with you here, John... but please check the following URL and notice the price tag on it -- http://www.redhat.com/products/software/linux/7-1_standard.html RedHat is betting on, correctly so, that users in general will not spend the time and effort to download over 100 meg of data, burn their own CD and then install the OS from it. This particular package also sells for $49.95 at my local Office Depot. It's perfectly legal to make CD collections of GPL'd software, which is why RedHat does it. What I was pointing out is that they are using the income from this to further increase the distribution network. If RedHat was only available from one website, wasn't advertised on major internet sites, wasn't in my local office supply store -- do you really think it would have taken the market share it has? I think it best for both parties involved that agreements get made and made quickly. All of the correspondence I've seen from NuSphere indicates they are more than willing to release the Gemini code GPL. They are simply stating that the mySQL side of the world will have to establish the resources to distribute it. Of course they will continue to sell their commercially supported version of the software, and mySQL AB should be happy for that. Does mySQL AB not do the same? Each installation of their $495 package is one more user not using Oracle or MSSQL. It's time to stop the name-calling and work out a way for both companies to profit from mySQL's success. John Dean <[EMAIL PROTECTED]> wrote: >>Linux has gotten itself out of the "hackers" domain into the mainstream due >>to the commercial investments of companies like RedHat and Caldera, both of >>which sell the GPL product at a profit, including their own enhancements to >>it. >Sorry, you are wrong again. Their profits come from Training and >Certification, Support and Consulting. Even so the source code is available >for download which is not the case with Gemini <___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL on MacOS X Server 10.0.4
Basic instructions to enable mysql in MacOSX Server 10.0.4: http://patricklarkin.com/macosxserver/ -- Patrick - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
AW: Outer join syntax..
MySQL uses the LEFT JOIN, RIGHT JOIN Syntax ... RTFM: http://www.mysql.com/doc/J/O/JOIN.html > -Ursprüngliche Nachricht- > Von: Bruce Stewart [mailto:[EMAIL PROTECTED]] > Gesendet: Montag, 16. Juli 2001 11:54 > An: Mysql-Help (E-mail) > Betreff: Outer join syntax.. > > > Hi all, > > MySQL doesn't support nested subqueries, I know, and I also > understand that > the same results can be achieved through outer joins (Left join, > Right join > and WHERE IS [NOT] NULL). > > Also, inner joins can be expressed either in the FROM clause or the WHERE > clause. > > My question is: Can outer joins be expressed in the FROM clause > as they can > in Oracle (using (+)) and MSSQL (using '*=' or '=*')? What is the syntax? > > I think I have looked through the documentation thoroughly > enough, that this > question is not a waste of anyone's time. If this is dealt with in the > manual, I apologise humbly, but where is it?!? > > Thanks, > Bruce. > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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: Dump SQL editor thats cross-compatWin/Linux
-- Original Message -- From: "Steve Brazill" <[EMAIL PROTECTED]> Reply-To: "Steve Brazill" <[EMAIL PROTECTED]> Date: Mon, 16 Jul 2001 11:32:24 -0700 >EMACS !! ick, yuck, blah !!! I'm always amazed how it's infiltrated the 'database' group (type) of people Vi is 'bester' (you wanna talk about learning curves ?) Actually, I'm more of a programmer, and when I'm editing a 10K line program in 20 different files, I sure do like etags, highgliting, and the macro features. It'll compile for you, jump between error messages, auto save files, all without leaving the keyboard. I realize that vi does some of the same stuff, but emacs is to vi what an RV is to a bicycle... MWB. - Original Message - From: "Mike Baranski" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, July 16, 2001 11:10 AM Subject: Re: Dump SQL editor thats cross-compatWin/Linux > Also, if you want the real deal, go get emacs, either at > http://xemacs.org > or http://www.gnu.org > > It's the best (no flames here), but has a pretty steep learning curve. > > -- Original Message -- > From: "Steve Brazill" <[EMAIL PROTECTED]> > Reply-To: "Steve Brazill" <[EMAIL PROTECTED]> > Date: Mon, 16 Jul 2001 10:48:08 -0700 > > >Don't forget that "WinVI" exists and can be found (and > downloaded) at: > > http://www.winvi.de/en/ > > And for those who like the 'code warrior' or 'slickedit' type of stuff > (where different types of 'statements' are highlighted in different > colors), > there's "Code Genie" available at: > > http://www.code-genie.com/ > > > - Original Message - > From: "Carsten Gehling" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Monday, July 16, 2001 6:04 AM > Subject: Re: Slightly off-topic... Dump SQL editor thats > cross-compatWin/Linux > > > > You could use VIM (cross-platform) or UltraEdit (Win32), the latter > is > > capable of reading and writing *nix compatible files even though > it's only > a > > Win32 program. > > > > - Carsten > > > > - Original Message - > > From: "Mike Cermak" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > > Sent: Monday, July 16, 2001 2:17 PM > > Subject: Re: Slightly off-topic... Dump SQL editor thats > > cross-compatWin/Linux > > > > > > Fred- > > > > Try Jext, a Java-based editor available at www.jext.org. I've been > using > it > > for a couple of weeks now to edit .php and .js source files, and > it's done > > fine by me (the source syntax color-coding has been a lifesaver on a > couple > > of occasions), I imagine it would be fine for general text editing. > > > > Notepad? We don' need no STNKING Notepad... :-) > > > > > > > > Mike Cermak > > Webmaster/Web Server Administrator > > Buffalo Niagara Partnership, Inc. > > [EMAIL PROTECTED] > > [EMAIL PROTECTED] > > 716/852-7100 x112 > > > > >>> "Fred Dinkler" <[EMAIL PROTECTED]> 07/14/01 01:34PM >>> > > Creating and editing dbdump SQL files from local dev in Win2k, > moving to > > Linux for QA and production. > > > > Text files edited using Wordpad and Notepad have extraneous line-end > chars > > (bold M). > > > > Any suggestions on configuration of any Win editor to save text > without > > garbage chars showing up on Liux side? > > > > Thanks, > > Fred > > Atlanta > > > > > > > > - > > Before posting, please check: > >http://www.mysql.com/manual.php (the manual) > >http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > > > > > > > > > > > > - > > Before posting, please check: > >http://www.mysql.com/manual.php (the manual) > >http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --
Re: Dump SQL editor thats cross-compatWin/Linux
-- Original Message -- From: "Steve Brazill" <[EMAIL PROTECTED]> Reply-To: "Steve Brazill" <[EMAIL PROTECTED]> Date: Mon, 16 Jul 2001 11:32:24 -0700 >EMACS !! ick, yuck, blah !!! I'm always amazed how it's infiltrated the 'database' group (type) of people Vi is 'bester' (you wanna talk about learning curves ?) Actually, I'm more of a programmer, and when I'm editing a 10K line program in 20 different files, I sure do like etags, highgliting, and the macro features. It'll compile for you, jump between error messages, auto save files, all without leaving the keyboard. I realize that vi does some of the same stuff, but emacs is to vi what an RV is to a bicycle... MWB. - Original Message - From: "Mike Baranski" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, July 16, 2001 11:10 AM Subject: Re: Dump SQL editor thats cross-compatWin/Linux > Also, if you want the real deal, go get emacs, either at > http://xemacs.org > or http://www.gnu.org > > It's the best (no flames here), but has a pretty steep learning curve. > > -- Original Message -- > From: "Steve Brazill" <[EMAIL PROTECTED]> > Reply-To: "Steve Brazill" <[EMAIL PROTECTED]> > Date: Mon, 16 Jul 2001 10:48:08 -0700 > > >Don't forget that "WinVI" exists and can be found (and > downloaded) at: > > http://www.winvi.de/en/ > > And for those who like the 'code warrior' or 'slickedit' type of stuff > (where different types of 'statements' are highlighted in different > colors), > there's "Code Genie" available at: > > http://www.code-genie.com/ > > > - Original Message - > From: "Carsten Gehling" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Monday, July 16, 2001 6:04 AM > Subject: Re: Slightly off-topic... Dump SQL editor thats > cross-compatWin/Linux > > > > You could use VIM (cross-platform) or UltraEdit (Win32), the latter > is > > capable of reading and writing *nix compatible files even though > it's only > a > > Win32 program. > > > > - Carsten > > > > - Original Message - > > From: "Mike Cermak" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > > Sent: Monday, July 16, 2001 2:17 PM > > Subject: Re: Slightly off-topic... Dump SQL editor thats > > cross-compatWin/Linux > > > > > > Fred- > > > > Try Jext, a Java-based editor available at www.jext.org. I've been > using > it > > for a couple of weeks now to edit .php and .js source files, and > it's done > > fine by me (the source syntax color-coding has been a lifesaver on a > couple > > of occasions), I imagine it would be fine for general text editing. > > > > Notepad? We don' need no STNKING Notepad... :-) > > > > > > > > Mike Cermak > > Webmaster/Web Server Administrator > > Buffalo Niagara Partnership, Inc. > > [EMAIL PROTECTED] > > [EMAIL PROTECTED] > > 716/852-7100 x112 > > > > >>> "Fred Dinkler" <[EMAIL PROTECTED]> 07/14/01 01:34PM >>> > > Creating and editing dbdump SQL files from local dev in Win2k, > moving to > > Linux for QA and production. > > > > Text files edited using Wordpad and Notepad have extraneous line-end > chars > > (bold M). > > > > Any suggestions on configuration of any Win editor to save text > without > > garbage chars showing up on Liux side? > > > > Thanks, > > Fred > > Atlanta > > > > > > > > - > > Before posting, please check: > >http://www.mysql.com/manual.php (the manual) > >http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > > > > > > > > > > > > - > > Before posting, please check: > >http://www.mysql.com/manual.php (the manual) > >http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --
locking problem!
I have problem with table lockings scince i upgraded the MySQL version, and i have tried with both RedHat 7.1 rpm version 2.23.36 and compile myself with 2.23.39. The result is the same. As can be seen in the "screenshot" below there is one process running, and a lot sleeping. In this example it happens to be an update running, but it might as well be an INSERT or SELECT. When the lock is released the server starts working on all locked querries at the same time, the result is a slow server with a load average around 60 where it can be run for long times with load between 1.00 and 2.00 on a dual cpu machine. Any ideas on how to solve this? Is this standard behaivour? I hope not... | 6899 | root| localhost | NULL | Query | 0| NULL| |show processlist | 7697 | smurfa | smurfa-www | dbSmurfa | Sleep | 788 | | |NULL | 15079 | smurfa | smurfa-www | dbSmurfa | Query | 2| Locked | |SELECT Users.ID, Users.Alias | 15083 | smurfa | smurfa-www | dbSmurfa | Sleep | 1| | |NULL | 15090 | smurfa | smurfa-www | dbSmurfa | Query | 2| Locked | |SELECT Users.ID, Users.Alias | 15091 | smurfa | smurfa-www | dbSmurfa | Query | 2| Locked | |SELECT Users.ID, Users.Alias | 15094 | smurfa | smurfa-www | dbSmurfa | Query | 1| end | |UPDATE Users SET Logons=Logons+1, | 15095 | smurfa | smurfa-www | dbSmurfa | Sleep | 1| | |NULL | 15096 | smurfa | smurfa-www | dbSmurfa | Query | 2| Locked | |SELECT Users.ID, Users.Alias | 15097 | smurfa | smurfa-www | dbSmurfa | Query | 2| Locked | |SELECT Users.ID, Users.Alias | 15098 | smurfa | smurfa-www | dbSmurfa | Query | 2| Locked | |SELECT Users.ID, Users.Alias | 15100 | smurfa | smurfa-www | dbSmurfa | Query | 1| Locked | |SELECT Users.ID, Users.Alias | 15101 | smurfa | smurfa-www | dbSmurfa | Query | 2| Locked | |SELECT Alias FROM Users WHERE | 15102 | smurfa | smurfa-www | dbSmurfa | Query | 2| Locked | |SELECT ID, Alias, Name, Email, | 15103 | smurfa | smurfa-www | dbSmurfa | Query | 2| Locked | |SELECT ID, Alias, Password, | 15104 | smurfa | smurfa-www | dbSmurfa | Query | 2| Locked | |SELECT ID, Alias, Name, Email, | 15105 | smurfa | smurfa-www | dbSmurfa | Query | 2| Locked | |SELECT ID, Alias, Name, Email, | 15106 | smurfa | smurfa-www | dbSmurfa | Query | 1| Locked | |SELECT Users.ID, Users.Alias, | 15107 | smurfa | smurfa-www | dbSmurfa | Query | 2| Locked | |SELECT MezzIndex.ID, MezzIndex. | 15108 | smurfa | smurfa-www | dbSmurfa | Query | 1| Locked | |SELECT Users.ID, Users.Alias, | 15109 | smurfa | smurfa-www | dbSmurfa | Query | 1| Locked | |SELECT Users.ID, Users.Alias, | 15111 | smurfa | smurfa-www | dbSmurfa | Query | 2| Locked | |SELECT MezzIndex.ID, MezzIndex. | 15114 | smurfa | smurfa-www | dbSmurfa | Query | 1| Locked | |SELECT Alias FROM Users WHERE | 15113 | smurfa | smurfa-www | dbSmurfa | Query | 1| Locked | |SELECT ID, Alias, Name, Email, | 15115 | smurfa | smurfa-www | dbSmurfa | Query | 1| Locked | |SELECT Alias FROM Users WHERE | 15118 | smurfa | smurfa-www | dbSmurfa | Query | 1| Locked | |SELECT MezzIndex.ID, MezzIndex | 15117 | smurfa | smurfa-www | dbSmurfa | Query | 1| Locked | |SELECT MezzIndex.ID, MezzIndex | 15124 | smurfa | smurfa-www | dbSmurfa | Query | 1| Locked | |SELECT ID, Alias, Name, Email
Re: Bug report: FULLTEXT index corrupts the index with too many TEXT fields
Hi! On Jul 16, Carsten Gehling wrote: > Description: > A specific table (see "How-To-Repeat) with a FULLTEXT index causes errors in > the MYI file when inserting new rows. > > 1) Create the following table: > CREATE TABLE `visitkort` ( [skip] > ) TYPE=MyISAM; > > 2) Insert a row with the following statement: > > 3) Run myisamchk with the option --extend-check and you get the following > myisamchk: warning: 1 clients is using or hasn't closed the table properly > The error does not occur, if you drop the FULLTEXT index Ok, I was able to repeat this, still I do not think it's a bug. Message given by myisamchk is perfectly legal - you should not expect MySQL to close the table immidiately when the client closes the connection. MySQL can keep the table open to speedup access to it from, e.g., next connection. MySQL will close the table on "FLUSH TABLE", or when the pool of opened tables is exceeded. if you will add "2.5) flush table" the error message will dissapear. if you will shutdown MySQL instead, you'll get no error, either. if you will issue "CHECK TABLE visitkort EXTENDED" instead of using external program myisamchk, again there will be no error message. So, looks like everything is ok. In you first message (without test case) you've also added > The result of this is, that if anyone is trying to update the same record > afterwards, the index is corrupted. I wasn't able to reproduce that. If you have a test case for this, please, let me know. Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany <___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: transactions
> From: Pete Kuczynski [mailto:[EMAIL PROTECTED]] > > Can anyone tell me for shure if my version of mysql supports > transactions. Version: 3.23.37 > > The bitbybit web site states that is does not, but someone told me that > it does, help! > > > MySQL doesn't support transactions. If you don't know what > > transactions are, chances are you'll never need them. > > Transactions are most > > widely used in systems where complex updates of many tables > > concurrently is important and you must be absolutely sure that all things > > either go right or don't happen at all. That's why banking > > systems are heavily dependent on transactions. The rest of us, > > however, can > > usually live without 'em. Just for the record: If Pete had bothered to read the very next paragraph of the FAQ, he would have read: November 2000 update: MySQL has now for some time been supporting transactions by incorporating the Berkeley DB into MySQL (v. 3.23.6 and upwards). The latest word on this project is that BDB tables are now considered "very stable". BDB support is officially still considered to be at an "alpha/beta" state. - and this is still true, according to my copy of the MySQL manual, (v. 3.23.39). / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: ERROR 1060: Duplicate column name
Thanks for the clarification. Is it a MySQL bug then that the CREATE query converts all the VARCHAR fields into CHAR fields so the query 'CREATE TEMPORARY TABLE User2 SELECT * FROM User' creates a temporary table much larger than the User table? -Original Message- From: Michael Widenius [mailto:[EMAIL PROTECTED]] Sent: Monday, July 16, 2001 9:32 AM To: Lance Lovette Cc: MySQL Subject: ERROR 1060: Duplicate column name Hi! > "Lance" == Lance Lovette <[EMAIL PROTECTED]> writes: Lance> The following CREATE TABLE statements seem straight forward but they all Lance> fail. Can someone explain why they fail and what I can do to get rid of the Lance> "Duplicate column name" errors? mysql> CREATE TEMPORARY TABLE User2 (UserID int(11)) SELECT UserID FROM Lance> User; Lance> ERROR 1060: Duplicate column name 'UserID' The above is an correct error message. What you are trying to do is the following: CREATE TEMPORARY TABLE User2 (UserID int(11) not null, UserID int(11)) SELECT UserID FROM User; This is because all columns from the SELECT is automaticly insert into the table with the given column and type taken from the corresponding column in the select statement. This makes it trivial to quickly do things like: CREATE TEMPORARY TABLE test (primary key (id)) SELECT ...many-fields Which will create a temporary table with all columns and have a primary key on the column named 'id'. 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Query
Date |Mon, 16 Jul 2001 16:38:14 +0530 >From |"Ganesh Krishnan" <[EMAIL PROTECTED]> Hello! GK> Hi, GK> I am developing a Java application which uses MySQL database on Linux GK> platform. Mark Mattews' MySQL driver is being used. GK> I am able to connect to the database from the application if I login as GK> root. But if I login as any user, I get an exception saying that the driver GK> was not found. GK> Being a newbie in Linux, I am not sure if this is a problem with the GK> permission. I tried several different things, but couldn't get it rectified. GK> Any help in this regard will be highly appreciated. GK> Regards, GK> Ganesh May be its not linux specific problem. Do you create a user with GRANT ? look at this http://www.mysql.com/doc/A/d/Adding_users.html and this http://www.mysql.com/doc/G/R/GRANT.html ___ For technical support contracts, visit https://order.mysql.com/ This email is sponsored by SWSoft, http://www.asplinux.ru/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Grigory Bakunov <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft /_/ /_/\_, /___/\___\_\___/ <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: different charset
Date |Mon, 16 Jul 2001 12:32:01 +0300 >From |Jurgis <[EMAIL PROTECTED]> Hello! J> Hi, J> is it possible to use differenet character sets on one mysqld, couse i need to sort data in tables using my character set but not only i want to do this stuff in for example latin1 character set... You need to use two charset at the same time ? If you need just to swap charsets - look here http://www.mysql.com/doc/C/h/Character_sets.html ___ For technical support contracts, visit https://order.mysql.com/ This email is sponsored by SWSoft, http://www.asplinux.ru/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Grigory Bakunov <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft /_/ /_/\_, /___/\___\_\___/ <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: 2003 Connection error
I'm surprised that there hasn't been any reply to this posting. I've continued to put up with the error 2003 but after several hours I get error 2013 - "Lost connection to MySQL server during query". May I note that the code works 100% when using local UNIX socket. It's only when using TCP/IIP that the problem occurs. Aidan - Original Message - From: "Aidan" <[EMAIL PROTECTED]> To: "Mqsl Mailing List" <[EMAIL PROTECTED]> Sent: Friday, July 13, 2001 12:38 PM Subject: 2003 Connection error > I have coded my own client that uses mysql_real_connect(). The client code > runs on another machine and there can be up to 120 clients connecting to the > database. Each client connects and then disconnects sucessfully for anything > up to 5 minutes before the clients start to receive 2003 host connection > errors. The machine that runs the clients uses SuSE 7.1 (with the latest > Mysql client patches from the SuSE site). The server machine runs SuSE 7.0 > and the version of Mysql is Ver 11.15 Distrib 3.23.39. > To solve the problem I make the clients loop round the mysql_real_connect() > call until the 2003 error goes away, but this is a waste of resources. > Does the client throw this kind of error when the server is overloaded or is > there a TCP/IP issue that needs fixing with Mysql or my Linux distributon? > > Aidan > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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: Dump SQL editor thats cross-compatWin/Linux
TextPad ( http://www.textpad.com ) also handles Unix/Win (for table/db dumps, etc) without a problem and is my own personal choice. Includes syntax highlighting if you want that kind of thing. Emacs on Windows is also good, but it can be a bear to configure and get running the way you might want it. c - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Dump SQL editor thats cross-compatWin/Linux
EMACS !! ick, yuck, blah !!! I'm always amazed how it's infiltrated the 'database' group (type) of people Vi is 'bester' (you wanna talk about learning curves ?) - Original Message - From: "Mike Baranski" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, July 16, 2001 11:10 AM Subject: Re: Dump SQL editor thats cross-compatWin/Linux > Also, if you want the real deal, go get emacs, either at > http://xemacs.org > or http://www.gnu.org > > It's the best (no flames here), but has a pretty steep learning curve. > > -- Original Message -- > From: "Steve Brazill" <[EMAIL PROTECTED]> > Reply-To: "Steve Brazill" <[EMAIL PROTECTED]> > Date: Mon, 16 Jul 2001 10:48:08 -0700 > > >Don't forget that "WinVI" exists and can be found (and > downloaded) at: > > http://www.winvi.de/en/ > > And for those who like the 'code warrior' or 'slickedit' type of stuff > (where different types of 'statements' are highlighted in different > colors), > there's "Code Genie" available at: > > http://www.code-genie.com/ > > > - Original Message - > From: "Carsten Gehling" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Monday, July 16, 2001 6:04 AM > Subject: Re: Slightly off-topic... Dump SQL editor thats > cross-compatWin/Linux > > > > You could use VIM (cross-platform) or UltraEdit (Win32), the latter > is > > capable of reading and writing *nix compatible files even though > it's only > a > > Win32 program. > > > > - Carsten > > > > - Original Message - > > From: "Mike Cermak" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > > Sent: Monday, July 16, 2001 2:17 PM > > Subject: Re: Slightly off-topic... Dump SQL editor thats > > cross-compatWin/Linux > > > > > > Fred- > > > > Try Jext, a Java-based editor available at www.jext.org. I've been > using > it > > for a couple of weeks now to edit .php and .js source files, and > it's done > > fine by me (the source syntax color-coding has been a lifesaver on a > couple > > of occasions), I imagine it would be fine for general text editing. > > > > Notepad? We don' need no STNKING Notepad... :-) > > > > > > > > Mike Cermak > > Webmaster/Web Server Administrator > > Buffalo Niagara Partnership, Inc. > > [EMAIL PROTECTED] > > [EMAIL PROTECTED] > > 716/852-7100 x112 > > > > >>> "Fred Dinkler" <[EMAIL PROTECTED]> 07/14/01 01:34PM >>> > > Creating and editing dbdump SQL files from local dev in Win2k, > moving to > > Linux for QA and production. > > > > Text files edited using Wordpad and Notepad have extraneous line-end > chars > > (bold M). > > > > Any suggestions on configuration of any Win editor to save text > without > > garbage chars showing up on Liux side? > > > > Thanks, > > Fred > > Atlanta > > > > > > > > - > > Before posting, please check: > >http://www.mysql.com/manual.php (the manual) > >http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > > > > > > > > > > > > - > > Before posting, please check: > >http://www.mysql.com/manual.php (the manual) > >http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re[4]: Mysql++ and Gcc 3.0 compile problems
Date |Sun, 15 Jul 2001 21:14:43 +0200 >From |Alexandre BAUMEISTER <[EMAIL PROTECTED]> Hello! >>> Do someone see improvements compiling Mysql with Gcc 3.0 ? SM>> What improvements would you like to see in the compiled library ?? AB> In fact I just wanted to know if there is any advantage to use Gcc AB> 3.0 for compiling Mysql. AB> Regards, AB> Alex. I build mysql with gcc3.0 yesterday evening. it's work fine but you need also to recompile with gcc3.0 all C++ programs and libs what work with mysql. include libstdc++. ___ For technical support contracts, visit https://order.mysql.com/ This email is sponsored by SWSoft, http://www.asplinux.ru/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Grigory Bakunov <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft /_/ /_/\_, /___/\___\_\___/ <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Dump SQL editor thats cross-compatWin/Linux
Also, if you want the real deal, go get emacs, either at http://xemacs.org or http://www.gnu.org It's the best (no flames here), but has a pretty steep learning curve. -- Original Message -- From: "Steve Brazill" <[EMAIL PROTECTED]> Reply-To: "Steve Brazill" <[EMAIL PROTECTED]> Date: Mon, 16 Jul 2001 10:48:08 -0700 >Don't forget that "WinVI" exists and can be found (and downloaded) at: http://www.winvi.de/en/ And for those who like the 'code warrior' or 'slickedit' type of stuff (where different types of 'statements' are highlighted in different colors), there's "Code Genie" available at: http://www.code-genie.com/ - Original Message - From: "Carsten Gehling" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, July 16, 2001 6:04 AM Subject: Re: Slightly off-topic... Dump SQL editor thats cross-compatWin/Linux > You could use VIM (cross-platform) or UltraEdit (Win32), the latter is > capable of reading and writing *nix compatible files even though it's only a > Win32 program. > > - Carsten > > - Original Message - > From: "Mike Cermak" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Monday, July 16, 2001 2:17 PM > Subject: Re: Slightly off-topic... Dump SQL editor thats > cross-compatWin/Linux > > > Fred- > > Try Jext, a Java-based editor available at www.jext.org. I've been using it > for a couple of weeks now to edit .php and .js source files, and it's done > fine by me (the source syntax color-coding has been a lifesaver on a couple > of occasions), I imagine it would be fine for general text editing. > > Notepad? We don' need no STNKING Notepad... :-) > > > > Mike Cermak > Webmaster/Web Server Administrator > Buffalo Niagara Partnership, Inc. > [EMAIL PROTECTED] > [EMAIL PROTECTED] > 716/852-7100 x112 > > >>> "Fred Dinkler" <[EMAIL PROTECTED]> 07/14/01 01:34PM >>> > Creating and editing dbdump SQL files from local dev in Win2k, moving to > Linux for QA and production. > > Text files edited using Wordpad and Notepad have extraneous line-end chars > (bold M). > > Any suggestions on configuration of any Win editor to save text without > garbage chars showing up on Liux side? > > Thanks, > Fred > Atlanta > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Dump SQL editor thats cross-compatWin/Linux
Don't forget that "WinVI" exists and can be found (and downloaded) at: http://www.winvi.de/en/ And for those who like the 'code warrior' or 'slickedit' type of stuff (where different types of 'statements' are highlighted in different colors), there's "Code Genie" available at: http://www.code-genie.com/ - Original Message - From: "Carsten Gehling" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, July 16, 2001 6:04 AM Subject: Re: Slightly off-topic... Dump SQL editor thats cross-compatWin/Linux > You could use VIM (cross-platform) or UltraEdit (Win32), the latter is > capable of reading and writing *nix compatible files even though it's only a > Win32 program. > > - Carsten > > - Original Message - > From: "Mike Cermak" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Monday, July 16, 2001 2:17 PM > Subject: Re: Slightly off-topic... Dump SQL editor thats > cross-compatWin/Linux > > > Fred- > > Try Jext, a Java-based editor available at www.jext.org. I've been using it > for a couple of weeks now to edit .php and .js source files, and it's done > fine by me (the source syntax color-coding has been a lifesaver on a couple > of occasions), I imagine it would be fine for general text editing. > > Notepad? We don' need no STNKING Notepad... :-) > > > > Mike Cermak > Webmaster/Web Server Administrator > Buffalo Niagara Partnership, Inc. > [EMAIL PROTECTED] > [EMAIL PROTECTED] > 716/852-7100 x112 > > >>> "Fred Dinkler" <[EMAIL PROTECTED]> 07/14/01 01:34PM >>> > Creating and editing dbdump SQL files from local dev in Win2k, moving to > Linux for QA and production. > > Text files edited using Wordpad and Notepad have extraneous line-end chars > (bold M). > > Any suggestions on configuration of any Win editor to save text without > garbage chars showing up on Liux side? > > Thanks, > Fred > Atlanta > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: problem with a LEFT JOIN
SELECT ratings.memid, sites.* FROM ratings LEFT JOIN sites ON ratings.ID = sites.ID WHERE ratings.memID = '1' and sites.ID IS NULL; John Hawkins wrote: > I'm having a bit of trouble doing a LEFT JOIN. Any input would be > greatly appreciated. > > table 1 (sites, has approx 30 records) has a list of sites with the > following fields: > ID, sitename, url > > table 2 has (ratings, has approx 2020 records) has a list of member > ratings for the different sites with the following fields: > ID, siteID, memID, rating > > - sites.ID matches up with ratings.memID > - memID is the ID of the member who performed this rating > > I want to show the member who is logged in a list of all the sites that > he has not yet rated. > > here is the select statement I have created, but isn't quite working: > > SELECT sites.* FROM sites LEFT JOIN ratings ON sites.ID = ratings.siteID > WHERE ratings.memID != '1' > > I am getting approx 2020 results (which, oddly enough, matches the > amount of records I have in the "ratings" table). > > Like I said, any help would be greatly appreciated. > > Best, > > 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 -- Gerald L. Clark [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: transactions
Hi, I updated my tables to BDB, but it still shows MYISAM. Do I need to remove mysql and reinstall it compiled for BDB like the manual suggests? I'm using nusphere's mysql on NT4 server, so I'm not shure that's even possible. http://www.mysql.com/doc/B/D/BDB_install.html Pete > To compile MySQL with Berkeley DB support, download MySQL Version 3.23.34 or newer >and configure MySQL with the --with-berkeley-db > option. See section 4.7 Installing a MySQL Source Distribution. > > cd /path/to/source/of/mysql-3.23.34 > ./configure --with-berkeley-db Don Read wrote: > > On 16-Jul-01 Pete Kuczynski wrote: > > I'm fairly new to this, so pardon this ignorant question. > > My tabletype shows as MYISAM, mysql version 3.23.37, will transactions > > still work? > > > > No. > > alter table da_table type=BDB; > > Check the manual > http://www.mysql.com/doc/A/L/ALTER_TABLE.html > > > Pete > > > > 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 -- ___ Pete Kuczynski Sr. Field Engineer DHL Airways Inc. Infrastructure Technology & Services (773)-462-9758 24/7 Helpdesk 1-800-434-5767 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Enable BDB table handler
I have a client using MySQL 3.23.37. We wanted to use the Berkeley tables but for some reason they are disabled. when I do a show variables I get: have_bdb NO What is the best way to permanently enable the BDB type tables?? THX's 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
MySQL Connection Timing out in PHP?
I have an include file that includes my mysql connect information. Its sole purpose is to login to mysql. Strangely on my Win9x development system with apache, sometimes, almost randomly, the connection will time out. Then if I press refresh it works prefectly. I am only connecting once per page and am closing my connections when done. Does this sound like a MySQL or Apache onfiguration problem? Or is there something I'm missing. Thanks
PROPOUSE
Hello mysql, I meet in share ver. of MySQL different lang. driver but no where UKRAINIAN. AND now I ask - I wont translete "errmsg.txt" and "errmsg.sys" for UKRAINIAN lang? Waiting for ansver! -- Best regards, suh 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: .org
At 9:34 AM +0100 7/16/01, Santi Chumbe wrote: >Interesting position. The NuSpheres people are really very clever. If I'm reading your statement correctly, you appear to be using "clever" as an innuendo for "mendacious." If that is so, I must respectfully disagree, and point out that statements of that nature are not helpful to the discussion. > >Interesante posicion. Sabiendo el respeto que tenemos por Paul, este >mensaje juega a >favor de NuSphere. > > >Paul DuBois wrote: > >> In the interests of stemming some of the flood of invective being >> directed against NuSphere... >> >> I am an employee of NuSphere. >> >> Those of you who feel it necessary immediately to jump up and denounce >> NuSphere for their sins, please ask yourself: Do you think I'd work for >> them if I thought they were a bunch of scumbags? They're not. NuSphere >> is interested in promoting MySQL, not in destroying it. For example, >> they pay me a salary to support my writing about MySQL full time, and >> they make no demands that I mention NuSphere in my books (though they're >> of course happy if I do). You'll see some of the fruit of this support >> next month when the MySQL/Perl book comes out - a book that I hope will >> be of some service to the MySQL community. >> >> The dispute will be worked out by the parties involved. Nobody's happy >> about it, but resolving it is difficult because both sides feel they >> have a reasonable position. You can see this from the messages being >> posted by the directors of MySQL AB and NuSphere. And of course once >> the lawyers get involved, things don't get any easier. >> >> Make your opinions known, certainly. You're all part of the MySQL >> community and your views are valuable. But please, leave the flames out >> of it. They're not constructive. >> >> Please be clear what I'm saying. I am an employee of (not an apologist >> for) NuSphere, and I'm not saying "don't criticize NuSphere." I'm saying >> that flames aren't helping anything, particularly if you are not in >> possession of all the facts behind the dispute. >> >> No one at NuSphere has asked that I write this. They've asked me for >> feedback, but no one has suggested that I take a "side". I am reluctant >> to do so anyway because it's not clear that there's any merit in doing >> so, and I don't think I have all the facts, either. >> >> Paul DuBois >> Author, "MySQL" (the book, not the server!) >> >> -- > > Paul DuBois, [EMAIL PROTECTED] -- Paul DuBois, [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Installation on Sol8-x86
Does anyone know why the mysql_install_db file in the scripts directory is blank with the sol8-x86 distribution? I hit a snafu when I try to start the db and I assume it's because this file isn't doing something it is supposed to. Thanks, Oliver - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 a LEFT JOIN
I'm having a bit of trouble doing a LEFT JOIN. Any input would be greatly appreciated. table 1 (sites, has approx 30 records) has a list of sites with the following fields: ID, sitename, url table 2 has (ratings, has approx 2020 records) has a list of member ratings for the different sites with the following fields: ID, siteID, memID, rating - sites.ID matches up with ratings.memID - memID is the ID of the member who performed this rating I want to show the member who is logged in a list of all the sites that he has not yet rated. here is the select statement I have created, but isn't quite working: SELECT sites.* FROM sites LEFT JOIN ratings ON sites.ID = ratings.siteID WHERE ratings.memID != '1' I am getting approx 2020 results (which, oddly enough, matches the amount of records I have in the "ratings" table). Like I said, any help would be greatly appreciated. Best, 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: .org
I've followed the NuSphere vs MySQL AB conflict/debate with great interest and I really hope that the conflict will be resolved to the satisfaction of both parties and most of all MySQL users. I was excited when NuSphere (Progress) joined the MySQL community. Progress knows a lot about databases and I thought that they could make MySQL even better. Unfortunately, Progress has not demonstrated, so far, that they understand "Open Source" and its principles. Why didn't Progress "Open Source" their own database server instead of taking a part of its database technology and "plugging" it into the MySQL server? Maybe Oracle would take a note and pay attention to what Progress is doing. Where are other Progress contributions to the "Open Source" such as direct db drivers for php, perl, python, etc? -Igor On Mon, 16 Jul 2001, Santi Chumbe wrote: > Interesting position. The NuSpheres people are really very clever. > > Interesante posicion. Sabiendo el respeto que tenemos por Paul, este mensaje juega a > favor de NuSphere. > > > Paul DuBois wrote: > > > In the interests of stemming some of the flood of invective being > > directed against NuSphere... > > > > I am an employee of NuSphere. > > > > Those of you who feel it necessary immediately to jump up and denounce > > NuSphere for their sins, please ask yourself: Do you think I'd work for > > them if I thought they were a bunch of scumbags? They're not. NuSphere > > is interested in promoting MySQL, not in destroying it. For example, > > they pay me a salary to support my writing about MySQL full time, and > > they make no demands that I mention NuSphere in my books (though they're > > of course happy if I do). You'll see some of the fruit of this support > > next month when the MySQL/Perl book comes out - a book that I hope will > > be of some service to the MySQL community. > > > > The dispute will be worked out by the parties involved. Nobody's happy > > about it, but resolving it is difficult because both sides feel they > > have a reasonable position. You can see this from the messages being > > posted by the directors of MySQL AB and NuSphere. And of course once > > the lawyers get involved, things don't get any easier. > > > > Make your opinions known, certainly. You're all part of the MySQL > > community and your views are valuable. But please, leave the flames out > > of it. They're not constructive. > > > > Please be clear what I'm saying. I am an employee of (not an apologist > > for) NuSphere, and I'm not saying "don't criticize NuSphere." I'm saying > > that flames aren't helping anything, particularly if you are not in > > possession of all the facts behind the dispute. > > > > No one at NuSphere has asked that I write this. They've asked me for > > feedback, but no one has suggested that I take a "side". I am reluctant > > to do so anyway because it's not clear that there's any merit in doing > > so, and I don't think I have all the facts, either. > > > > Paul DuBois > > Author, "MySQL" (the book, not the server!) > > > > -- > > Paul DuBois, [EMAIL PROTECTED] > > > > - > > Before posting, please check: > >http://www.mysql.com/manual.php (the manual) > >http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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
Error while trying to compile MySQL 4.0
Hi, Compilation fail with the following error message : makeinfo -I . --no-headers --no-split --output manual.txt manual.texi Fabrication du fichier text «manual.txt» à partir de «manual.texi». manual.texi:56: Commande inconnue «setcontentsaftertitlepage».. manual.texi:5157: itemize exige un argument: le formateur pour @item. manual.texi:20066: «.» ou «,» doit suivre une référence croisée, non pas a. manual.texi:30568: itemize exige un argument: le formateur pour @item. manual.texi:30980: itemize exige un argument: le formateur pour @item. manual.texi:44531: itemize exige un argument: le formateur pour @item. makeinfo: Enlèvement du fichier de sortie «manual.txt» à cause d'erreurs; utiliser l'option --force pour préserver. make[2]: *** [manual.txt] Erreur 2 make[2]: Quitte le répertoire `/usr/local/mysql-4.0/Docs' make[1]: *** [all-recursive] Erreur 1 make[1]: Quitte le répertoire `/usr/local/mysql-4.0' make: *** [all-recursive-am] Erreur 2 What should I do to fix the error ? Thank you, Jocelyn Fournier Presence-PC
Re: Re: NOT IN
Hi, "eingebaut" is a german word and means something like "build in" or = integrated. Best Regards Bernhard p.S. This message contains words like: database,sql,query,table - Original Message -=20 From: "Gerlinde Fischer" <[EMAIL PROTECTED]> To: "Beatriz Lapaz" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, July 16, 2001 10:57 AM Subject: Re: NOT IN > > here the script in php in eine classe eingebaut. > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 a LEFT JOIN
I'm having a bit of trouble doing a LEFT JOIN. Any input would be greatly appreciated. table 1 (sites, has approx 30 records) has a list of sites with the following fields: ID, sitename, url table 2 has (ratings, has approx 2020 records) has a list of member ratings for the different sites with the following fields: ID, siteID, memID, rating - sites.ID matches up with ratings.memID - memID is the ID of the member who performed this rating I want to show the member who is logged in a list of all the sites that he has not yet rated. here is the select statement I have created, but isn't quite working: SELECT sites.* FROM sites LEFT JOIN ratings ON sites.ID = ratings.siteID WHERE ratings.memID != '1' I am getting approx 2020 results (which, oddly enough, matches the amount of records I have in the "ratings" table). Like I said, any help would be greatly appreciated. Best, 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: transactions
On 16-Jul-01 Pete Kuczynski wrote: > I'm fairly new to this, so pardon this ignorant question. > My tabletype shows as MYISAM, mysql version 3.23.37, will transactions > still work? > No. alter table da_table type=BDB; Check the manual http://www.mysql.com/doc/A/L/ALTER_TABLE.html > Pete > 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
Nusphere - mySQL dispute
Hi All - I dont have a say in a lot of things but want to just give my support to mySQL and in whatever it decides to do with this ugly sutiation. MySQL was the first Linux app that I have setup and runned sucessfully when I started working on linux and it was always a dream of mine to make a product that could equal or live to the LEGEND that mySQL has made for iteself. Monty and his crew has and will always be one of my GREATES insperation's . And I will always strive to follow in there footprints. In this I mean that thanks for all that you have done for us as a community and I hope and believe that all will turn to your favour for hours of hardwork and dedication is not allowed to be stolen because you have a BIG HEART that is not fear and not right. I just wanted to get this off my chess for as another programmer. I know how it feals if people steals your hardwork and take the credit for it. So I hope you the best of luck .. Good luck and thanks for all that you have done to all us mySQL peeps out here. Thanks Johannes Pretorius (Development Department - Promed) Tel : +27 11 263-5920 website : http://www.promed.co.za - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: transactions
I'm fairly new to this, so pardon this ignorant question. My tabletype shows as MYISAM, mysql version 3.23.37, will transactions still work? Pete Don Read wrote: > > On 16-Jul-01 Simon Green wrote: > > MySQL > > Will not do transactions till V4... > > But there are ways to get around this.. > > > > If you use BDB or Innobase table types, then transactions _are_ supported. > Since ~ 3.23.26 IIR; no idea if the code is considered "stable" ... > > http://www.mysql.com/doc/C/O/COMMIT.html > http://www.mysql.com/doc/S/E/SET_TRANSACTION.html > > 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. -- ___ Pete Kuczynski Sr. Field Engineer DHL Airways Inc. Infrastructure Technology & Services (773)-462-9758 24/7 Helpdesk 1-800-434-5767 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: transactions
yes...yes, I believe we are. Mea Culpa, BDB fans please to forgive. :) Cal * * Cal Evans * Senior Internet Dreamer * http://www.calevans.com * - Original Message - From: "Sander Pilon" <[EMAIL PROTECTED]> To: "'Cal Evans'" <[EMAIL PROTECTED]>; "'Pete Kuczynski'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; "'Carsten H. Pedersen'" <[EMAIL PROTECTED]> Sent: Monday, July 16, 2001 10:22 Subject: RE: transactions > > > MySQL supports transactions if you are using either InnoDB or > > Gemini table types. > > > > Cal > > Are we forgetting BDB tables? Yes.. yes.. I believe we are! > > http://www.mysql.com/doc/B/D/BDB_characteristic.html > > > > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: transactions
On 16-Jul-01 Simon Green wrote: > MySQL > Will not do transactions till V4... > But there are ways to get around this.. > If you use BDB or Innobase table types, then transactions _are_ supported. Since ~ 3.23.26 IIR; no idea if the code is considered "stable" ... http://www.mysql.com/doc/C/O/COMMIT.html http://www.mysql.com/doc/S/E/SET_TRANSACTION.html 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: transactions
SG> MySQL SG> Will not do transactions till V4... Wrong. InnoDB table type supports transactions. -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- | Ilya Martynov (http://martynov.org/)| | GnuPG 1024D/323BDEE6 D7F7 561E 4C1D 8A15 8E80 E4AE BE1A 53EB 323B DEE6 | | AGAVA Software Company (http://www.agava.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: transactions
> MySQL supports transactions if you are using either InnoDB or > Gemini table types. > > Cal Are we forgetting BDB tables? Yes.. yes.. I believe we are! http://www.mysql.com/doc/B/D/BDB_characteristic.html - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: transactions
Simon Green writes: > MySQL > Will not do transactions till V4... > But there are ways to get around this.. > > Simon > Sorry, but the above is not true. You can use transactions with 3.23 if you use BDB or InnoDB tables.> -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: transactions
And Berkeley BDB tables! >>On Mon, 16 Jul 2001 10:04:41 -0500, "Cal Evans" <[EMAIL PROTECTED]> wrote: >>MySQL supports transactions if you are using either InnoDB or Gemini table >>types. >> >>Cal >>* >>* Cal Evans >>* Senior Internet Dreamer >>* http://www.calevans.com >>* >>- Original Message - >>From: "Pete Kuczynski" <[EMAIL PROTECTED]> >>To: <[EMAIL PROTECTED]>; "Carsten H. Pedersen" >><[EMAIL PROTECTED]> >>Sent: Monday, July 16, 2001 09:57 >>Subject: transactions >> >> >>> Can anyone tell me for shure if my version of mysql supports >>> transactions. Version: 3.23.37 >>> >>> The bitbybit web site states that is does not, but someone told me that >>> it does, help! >>> >>> >>> > MySQL doesn't support transactions. If you don't know what transactions >>are, chances are you'll never need them. Transactions are most >>> > widely used in systems where complex updates of many tables concurrently >>is important and you must be absolutely sure that all things >>> > either go right or don't happen at all. That's why banking systems are >>heavily dependent on transactions. The rest of us, however, can >>> > usually live without 'em. >>> >>> -- >>> > Hi Pete >>> > To emable logging use the --log option eg --log-update when stating the >>> > server... >>> > >>> > Simon >>> >>> ___ >>> Pete Kuczynski >>> Sr. Field Engineer >>> DHL Airways Inc. >>> Infrastructure Technology & Services >>> (773)-462-9758 >>> 24/7 Helpdesk 1-800-434-5767 >>> >> >> >> >> >> >> >>> - >>> Before posting, please check: >>>http://www.mysql.com/manual.php (the manual) >>>http://lists.mysql.com/ (the list archive) >>> >>> 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 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: transactions
On Mon, 16 Jul 2001 09:57:26 -0500, Pete Kuczynski <[EMAIL PROTECTED]> wrote: >>Can anyone tell me for shure if my version of mysql supports >>transactions. Version: 3.23.37 >> >>The bitbybit web site states that is does not, but someone told me that >>it does, help! We use, on a shared MySQL server for another account, 3.23.32 w/BDB tables which supports Transaction and has worked with no problems. As far using transactions with InnoDB, not sure about that one. but it does come with the lastest release I believe. 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: transactions
MySQL Will not do transactions till V4... But there are ways to get around this.. Simon -Original Message- From: Pete Kuczynski [mailto:[EMAIL PROTECTED]] Sent: 16 July 2001 15:57 To: [EMAIL PROTECTED]; Carsten H. Pedersen Subject: transactions Can anyone tell me for shure if my version of mysql supports transactions. Version: 3.23.37 The bitbybit web site states that is does not, but someone told me that it does, help! > MySQL doesn't support transactions. If you don't know what transactions are, chances are you'll never need them. Transactions are most > widely used in systems where complex updates of many tables concurrently is important and you must be absolutely sure that all things > either go right or don't happen at all. That's why banking systems are heavily dependent on transactions. The rest of us, however, can > usually live without 'em. -- > Hi Pete > To emable logging use the --log option eg --log-update when stating the > server... > > Simon ___ Pete Kuczynski Sr. Field Engineer DHL Airways Inc. Infrastructure Technology & Services (773)-462-9758 24/7 Helpdesk 1-800-434-5767 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: transactions
MySQL supports transactions if you are using either InnoDB or Gemini table types. Cal * * Cal Evans * Senior Internet Dreamer * http://www.calevans.com * - Original Message - From: "Pete Kuczynski" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; "Carsten H. Pedersen" <[EMAIL PROTECTED]> Sent: Monday, July 16, 2001 09:57 Subject: transactions > Can anyone tell me for shure if my version of mysql supports > transactions. Version: 3.23.37 > > The bitbybit web site states that is does not, but someone told me that > it does, help! > > > > MySQL doesn't support transactions. If you don't know what transactions are, chances are you'll never need them. Transactions are most > > widely used in systems where complex updates of many tables concurrently is important and you must be absolutely sure that all things > > either go right or don't happen at all. That's why banking systems are heavily dependent on transactions. The rest of us, however, can > > usually live without 'em. > > -- > > Hi Pete > > To emable logging use the --log option eg --log-update when stating the > > server... > > > > Simon > > ___ > Pete Kuczynski > Sr. Field Engineer > DHL Airways Inc. > Infrastructure Technology & Services > (773)-462-9758 > 24/7 Helpdesk 1-800-434-5767 > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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
Bug report: FULLTEXT index corrupts the index with too many TEXT fields
Description: A specific table (see "How-To-Repeat) with a FULLTEXT index causes errors in the MYI file when inserting new rows. The error only occurs when the FULLTEXT index is in the table. I've tried to recreate the table completely, and it still occurs. The bug is found on the following platforms/versions: Win2k server SP2, MySQL 3.23.32 Win2k server SP2, MySQL 3.23.39 Linux, MySQL 3.23.39 How-To-Repeat: 1) Create the following table: CREATE TABLE `visitkort` ( `id` int(10) unsigned NOT NULL auto_increment, `kategori_id` int(10) unsigned NOT NULL default '0', `aktiv` tinyint(3) unsigned NOT NULL default '0', `navn` varchar(60) NOT NULL default '', `adresse` varchar(150) NOT NULL default '', `postnr` varchar(5) NOT NULL default '', `tlf` varchar(20) NOT NULL default '', `fax` varchar(20) NOT NULL default '', `email` varchar(60) NOT NULL default '', `password` varchar(20) NOT NULL default '', `url` varchar(150) NOT NULL default '', `beskrivelse` varchar(200) NOT NULL default '', `visitkort` tinyint(3) unsigned NOT NULL default '0', `skabelon` tinyint(3) unsigned NOT NULL default '0', `logo` tinyint(3) unsigned NOT NULL default '0', `billede` tinyint(3) unsigned NOT NULL default '0', `tekst1` text NOT NULL, `tekst2` text NOT NULL, `tekst3` text NOT NULL, `tekst4` text NOT NULL, PRIMARY KEY (`id`), KEY `kategori_id` (`kategori_id`), KEY `bruger_id` (`visitkort`), KEY `postnr` (`postnr`), KEY `email` (`email`), FULLTEXT KEY `ft` (`navn`,`beskrivelse`,`tekst1`,`tekst2`,`tekst3`,`tekst4`) ) TYPE=MyISAM; 2) Insert a row with the following statement: insert into visitkort (navn, kategori_id) values ('test7', 106); 3) Run myisamchk with the option --extend-check and you get the following result C:\mysql\data\midtfyn>myisamchk --extend-check visitkort Checking MyISAM file: visitkort Data records:339 Deleted blocks: 0 myisamchk: warning: 1 clients is using or hasn't closed the table properly - check file-size - check key delete-chain - check record delete-chain - check index reference - check data record references index: 1 - check data record references index: 2 - check data record references index: 3 - check data record references index: 4 - check data record references index: 5 - check records and index references MyISAM-table 'visitkort' is usable but should be fixed 4) To repair the table, you need to do a "flush table" and then the myisamchk --safe-recover C:\mysql\data\midtfyn>myisamchk --safe-recover -force visitkort - recovering (with sort) MyISAM-table 'visitkort.MYI' Data records: 339 - Fixing index 1 Found block with too small length at 22812; Skipped - Fixing index 2 - Fixing index 3 - Fixing index 4 - Fixing index 5 Fix: The error does not occur, if you drop the FULLTEXT index Synopsis: FULLTEXT index corrupts the index with too many TEXT fields Submitter-Id: Originator: Carsten Gehling Organization: Sarum MySQL support: [none] Severity: [serious] Priority: [low | medium | high ] Category: [mysqld] Class: [sw-bug] Release: mysql-3.23.39 Exectutable: [mysqld] Environment: MySQL console System: Compiler: Binary distribution Architecture: i - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
transactions
Can anyone tell me for shure if my version of mysql supports transactions. Version: 3.23.37 The bitbybit web site states that is does not, but someone told me that it does, help! > MySQL doesn't support transactions. If you don't know what transactions are, chances >are you'll never need them. Transactions are most > widely used in systems where complex updates of many tables concurrently is >important and you must be absolutely sure that all things > either go right or don't happen at all. That's why banking systems are heavily >dependent on transactions. The rest of us, however, can > usually live without 'em. -- > Hi Pete > To emable logging use the --log option eg --log-update when stating the > server... > > Simon ___ Pete Kuczynski Sr. Field Engineer DHL Airways Inc. Infrastructure Technology & Services (773)-462-9758 24/7 Helpdesk 1-800-434-5767 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MYSQL on RedHat 7.1.
Most likely that there is a problem with where PHP and Java are looking for the socket. One more possibility (I don't know for Java, but for PHP) - you need to install a php-mysql (or mysql-php) package. Regards, Milos Rackov > From: Kalpesh Modha [mailto:[EMAIL PROTECTED]] > Sent: Monday, July 16, 2001 4:04 PM > To: [EMAIL PROTECTED] > Subject: MYSQL on RedHat 7.1. > > > Hello. > > I am trying to get mysql working on RedHat 7.1 and it works fine however, > when I try to make a local connection from either Java or PHP. I get a > connection refused message. Whats missing ? > > Thanks for your help in advance. > > Regards > Kal. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MYSQL on RedHat 7.1.
Hi, try check your permission in your MySQL and in scripts. S pozdravem Michal Dvoracek [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
MYSQL on RedHat 7.1.
Hello. I am trying to get mysql working on RedHat 7.1 and it works fine however, when I try to make a local connection from either Java or PHP. I get a connection refused message. Whats missing ? Thanks for your help in advance. Regards Kal. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: many to many join on 2 tables.
These two statements say the same thing. They shouldn't cause a problem but the probably don't do what you want. Try using the first table multiple times and use an alias. Don't have my book handy but it seems to me that : Select table1.*, table2.* from table1 as t1, table1 as t11, table 2 as t2 where t1.blah = t11.blah and t1.blah = t2.blah; Or something to that effect. Cal * * Cal Evans * Senior Internet Dreamer * http://www.calevans.com * - Original Message - From: "Nick Davies" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, July 16, 2001 08:02 Subject: many to many join on 2 tables. > > Hi, > > I'm have a bit of difficulty with a many to many join on two > tables. (Where an item is directly related to another item of the same > type in the same table). > > I'm trying to use the same method as a join between 2 tables with > a 3rd but having no joy. Help :) > > eg. > > table1.attb1 = table2.attb1 AND > table1.attb2 = table2.attb1; > > Thanks. > > Nick. > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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: InnoDB behaviour with multiple clients
Hi! Is it so that your test inserts, updates, and deletes rows at random? Can these rows overlap? Do you have big transactions? If the above are true, you will inevitably get a lot of deadlocks and rollbacks. Real-world applications should be written in a way that deadlocks cannot occur, or they are rare. One method is to access tables and rows in a fixed order. In MyISAM you cannot get deadlocks because there every SQL statement is a single transaction and MyISAM locks all the tables involved in the statement before starting the processing (this kind of all-at-once locking is called 'conservative locking' in literature). Regards, Heikki http://www.innodb.com At 03:01 PM 7/10/01 +0300, you wrote: >Content-Type: message/rfc822 >Content-Description: forwarded message >Content-Transfer-Encoding: 7bit > >Subject: InnoDB behaviour with multiple clients >From: Denis Pithon <[EMAIL PROTECTED]> >To: [EMAIL PROTECTED] >Date: 10 Jul 2001 10:51:40 +0200 > >Hi all, > >I begin to validate MySQL with InnoDB on our platform. I use a DBI perl >test which manages a data pool reflecting exactly the rows stored in DB. >This test internally builds some new data to insert and chooses rows to >delete and update (the tables are chosen randomly). Then all these >operations are executed in one transaction. If it fails, a rollback is >executed in DB and in client memory. Client also check that all data in >its pool are in the DB. That's my test... > >It works very well with one client, but with two... things become >harder! clients received many 'Table handler error 100' and slow >down terrifically. > >I try the same test with 3 clients on MyISAM tables and there is no >noticeable problems. > >I have reduced number of queries per transaction. I have changed >innodb_unix_file_flush_method to O_DSYNC. I have increased buffer pool >size and log buffer size but I noticed onlky small improvements. I'm >sure I forgot something, but I don't see what ! does somebody know ?? > >Denis > >-- >Denis Pithon phone +33 (0) 1 41 40 02 13 >Software Engineerfax+33 (0) 1 41 40 02 01 >Lineo High Availability Groupmail [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 > > >Content-Type: text/plain; charset=us-ascii >Content-Description: .signature >Content-Transfer-Encoding: 7bit > > >-- >Regards, > __ ___ ___ __ > / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> > / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer >/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus > <___/ www.mysql.com > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Joins.
Yes. No problem with that. Cal * * Cal Evans * Senior Internet Dreamer * http://www.calevans.com * - Original Message - From: "Nick Davies" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, July 16, 2001 07:59 Subject: Joins. > > Hi, > > I'm just needing a bit of help with Joins. > > I have a many-to-many relationship to join can this be done with > any of mysql join operators or do i just have to use > > WHERE table1.blah = table2.blah AND > table1.blah1 = table3.blah1; > > as normal. > > Thanks. > > Nick. > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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