Re: manual on stored procedures and triggers
On Wednesday 09 August 2006 07:27 am, Vittorio Zuccalà wrote: Hello, i'm searching for a manual about stored procedures and triggers. I'm new about this arguments but i want to study them. Unfortunally, mysql online manual is not rich about examples so, can you suggest me some online manuals on stored procedures and triggers? There's actually a MySQL dev article on it. Get the PDF here: http://dev.mysql.com/tech-resources/articles/mysql-storedprocedures.pdf I found it really helpfull when starting out on stored procedures with MySQL. If you're looking for book form, I found The Definitive Guide to MySQL 5 by Michael Kofler (Apress) to be a good resource. Thank you, Vittorio -- Chris White PHP Programmer/DBarbaric Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: manual deletion of binary log files
Yes, look at the PURGE LOGS command. Rithish Saralaya wrote: Hello. Can I delete off the binary log files manually? I do not want to 'RESET MASTER', as it will clear all the binary logs, and that's not what I want to do. The database is backed up every midnight, and I wouldn't want to keep any of the bin logs except the latest one. We are on RHEL - MySQL 4.1.11 - INNoDB storage engine. Regards, Rithish. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: manual for 3.23.53 pdf?
On Mon, 30 Dec 2002, Richard Nagle wrote: looking for a pdf manual for mysql 3.23.53 anyone? You may build it yourself: texi2dvi4a2ps -p manual.texi Thomas Spahni - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Manual stuff missing
Steven, Thursday, November 21, 2002, 7:29:41 AM, you wrote: SR There seems to be nothing in the Manual about a lot of things. For SR example, the utilities mysqldumpslow, and mysqlcheck, etc. As to mysqlcheck: http://www.mysql.com/doc/en/Using_mysqlcheck.html As to others you can write comments in the online manual. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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: Manual availability
On Fri, 16 Aug 2002, Frank Shute wrote: I'm using 3.23.51 and I wondered if the manual was available as separate pages of html in a tarball. The manual as shipped is a single page and as this machine's dog slow and takes an age to jump from one part of the manual to another, I thought separate pages might improve matters. I can only find the manual for 4.0 at mysql.com in the format I desire. Frank, using the manual as a reference to lookup everyday problems I highly recommend mysql.info (one file!) together with pinfo 0.6.5 or whatever is latest. This lets you jump around in fractions of a second with a lynx style browser on the ascii screen. Regards, Thomas Spahni - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Manual availability
On Mon, Aug 19, 2002 at 10:55:32AM +0200, Thomas Spahni wrote: On Fri, 16 Aug 2002, Frank Shute wrote: I'm using 3.23.51 and I wondered if the manual was available as separate pages of html in a tarball. The manual as shipped is a single page and as this machine's dog slow and takes an age to jump from one part of the manual to another, I thought separate pages might improve matters. I can only find the manual for 4.0 at mysql.com in the format I desire. Frank, using the manual as a reference to lookup everyday problems I highly recommend mysql.info (one file!) together with pinfo 0.6.5 or whatever is latest. This lets you jump around in fractions of a second with a lynx style browser on the ascii screen. Thanks Thomas, I didn't know that mysql came with an info file. Donna was kind enough to send me a really nice framed and broken down html manual for an old version which I prefer to info. Haven't come across pinfo before but I'll check it out. Anybody else interested in a framed and broken down version of the html manual? If there's any interest I'll mark it up for the latest 3.23 release and make it available if thats OK with the mysql AB folks, they're welcome to put it on www.mysql.com if they like. -- Frank *-*-*-*-*-*-*-*-*-*-* Boroughbridge. - PGP keyID: 0xC0B341A3 *-*-*-*-*-*-*-*-*-*-* If I had to quantify Iraq's threat, I would say (it is) zero. -- Scott Ritter, former UN weapons inspector. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Manual availability
Course, you could just be v. nice to me - I made it into separate pages in 2 frames for much the same reason. :-) donna ( v. 3.23.34) On Friday 16 August 2002 9:21 pm, Frank Shute wrote: I'm using 3.23.51 and I wondered if the manual was available as separate pages of html in a tarball. The manual as shipped is a single page and as this machine's dog slow and takes an age to jump from one part of the manual to another, I thought separate pages might improve matters. I can only find the manual for 4.0 at mysql.com in the format I desire. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Manual: mis-spelled variable
Thomas, Monday, June 24, 2002, 7:05:21 PM, you wrote: TS I came across this problem: TS where the manual describes Fulltext Fine-tuning it says: TS* Minimal length of word to be indexed is defined by MySQL variable TS `ft_min_word_length'. *Note SHOW VARIABLES::. Change it to the TS value you prefer, and rebuild your `FULLTEXT' indexes. TS This does not work! It appears that the name of this variable is TS 'ft_min_word_len' instead. Thanks! Seems, it was already fixed. I checked the manual and there is a mention about 'ft_min_word_len', not about 'ft_min_word_length'. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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: Manual at mysql.com
Luc Foisy writes: the search query is broken Luc Foisy We shall notify our web team. -- 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: Manual references to safe_mysqld
Hi! (Please continue this thread only on the internals list) Ken == Ken Menzel [EMAIL PROTECTED] writes: Ken Hi Monty and Jeremy, We have been a bit reluctant to update the manual, as most of our users are still using 3.23 and could easily be confused by this. I think we should wait until 4.0 goes into beta before doing the Ken update. Ken If I may suggest, Could we have two manuals online then? One for Ken 4.x, and one for version 3. I think that this would avoid confusion. Ken Furthurmore, I will volunter some time from my web staff to help Ken maintain this (I do understand it is almost double work to have two Ken manuals online) if that would help any. I don't know if this is really necessary. As long as we are clearly marking the 4.0 features as such in the manual, we should be ok. Ken With all the great stuff (or differences) in 4.0 that is not (or Ken different) in 3.23.xx I feel it can already be confusing! IE Ken (Referential integrity, Replication, Cascadining Deletes, UNIONS, Ken FULLTEXT Features, Table to table UPDATE syntax, table details, Ken security(SSH?), etc (long list!) ). Ken MySQL 4.0.1 is running VERY well here, but I think it may be confusing Ken even during the beta stage to have only the beta manual Ken online/available for download. I think both should be there. Ken The other suggestion would be to make the online manual only Ken the -stable manual, I know how to build the manual for 4.0 from the Ken source, but I personally like the idea of both the alpha/beta and the Ken stable manual being available! You guy's are doing alot of great work Ken it would be good to have it online ASAP! As the 4.0 manual includes a lot of new stuff, that is highly relevant also for 3.23, I don't think this is a good way to go either. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland ___/ 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: Manual references to safe_mysqld
Hi! Jeremy == Jeremy Zawodny [EMAIL PROTECTED] writes: Jeremy On Tue, Jan 29, 2002 at 03:27:17PM -0500, Ken Menzel wrote: With MySQL 4.0 are we not supposed to be using mysqld_safe? Should'nt references in the manual be modified from safe_mysqld to mysqld_safe? Jeremy I think so. I just did that recently in my book. Imagine how many Jeremy times I got it backwards and ended up second-guessing myself. :-( Yes, on is suppled to use mysqld_safe on MySQL 4.0. We have been a bit reluctant to update the manual, as most of our users are still using 3.23 and could easily be confused by this. I think we should wait until 4.0 goes into beta before doing the update. I could make this change if you like. Also I am getting ready to update references to freebsd. Not being familiar with bitkeeper I assume I use: bk send -d manual.texi This would be ok. Jeremy I'm not sure how they're generated (possibly from the manual), but the Jeremy INSTALL-SOURCE and INSTALL-BINARY files in 4.x also have references to Jeremy safe_mysqld rather than mysqld_safe. These files are automaticly generated from the manual. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland ___/ 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Manual references to safe_mysqld
Hi! Ken == Ken Menzel [EMAIL PROTECTED] writes: Ken Hi Jeremey! I think so. I just did that recently in my book. Imagine how many times I got it backwards and ended up second-guessing myself. :-( Ken Yes I have that confusion all the time, but it is good to have all Ken mysql tools begin with my or mysql. Also because the installation of Ken MySQL does not remove or alter safe_mysqld, on ends up with two Ken scripts startin mysql. This may not be a problem today however if in Ken the future the mysqld_safe script is altered for (saftey/features/some Ken important reason) people may end up using the wrong startup script. Ken I know my servers use the wrong script! Ken My suggestiion would be to check if safe_mysqld exists during the 4.0 Ken install and if it does remove it, then create a link to mysqld_safe Ken named safe_mysqld. This maintains compatibility for anyone who has Ken existing scripts and uses only one! Then in 4.1 perhaps deprecate the Ken safe_mysqld completely, but I don't think it's a big problem to Ken maintain the link if it exists. Ken Thoughts anyone? Sounds like a good suggestion. We will look into fixing this for our .RPM's cut Ken One other thing, I noticed that Multi-table update is mentioned in Ken the 4.0.2 release notes, but the syntax is not yet in the manual and Ken I didn't see the commit! Did I miss the commit? I want to pull this Ken ASAP and test it. The multi-table-update is committed, but I haven't had time to review the code yet; As soon as this is done, we will update the documentation about this. Ken Thanks everyone, Ken Ken Ken P.S. to Monty have been trying to recreate the 'row 0' error with Ken mysqldump unsuccesfully. I am not sure what has changed. :( 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: Manual references to safe_mysqld
Hi Monty and Jeremy, We have been a bit reluctant to update the manual, as most of our users are still using 3.23 and could easily be confused by this. I think we should wait until 4.0 goes into beta before doing the update. If I may suggest, Could we have two manuals online then? One for 4.x, and one for version 3. I think that this would avoid confusion. Furthurmore, I will volunter some time from my web staff to help maintain this (I do understand it is almost double work to have two manuals online) if that would help any. With all the great stuff (or differences) in 4.0 that is not (or different) in 3.23.xx I feel it can already be confusing! IE (Referential integrity, Replication, Cascadining Deletes, UNIONS, FULLTEXT Features, Table to table UPDATE syntax, table details, security(SSH?), etc (long list!) ). MySQL 4.0.1 is running VERY well here, but I think it may be confusing even during the beta stage to have only the beta manual online/available for download. I think both should be there. The other suggestion would be to make the online manual only the -stable manual, I know how to build the manual for 4.0 from the source, but I personally like the idea of both the alpha/beta and the stable manual being available! You guy's are doing alot of great work it would be good to have it online ASAP! Just my two cents (and web programmers if you want them) Best wishes, Ken - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Manual references to safe_mysqld
Hi Jeremey! I think so. I just did that recently in my book. Imagine how many times I got it backwards and ended up second-guessing myself. :-( Yes I have that confusion all the time, but it is good to have all mysql tools begin with my or mysql. Also because the installation of MySQL does not remove or alter safe_mysqld, on ends up with two scripts startin mysql. This may not be a problem today however if in the future the mysqld_safe script is altered for (saftey/features/some important reason) people may end up using the wrong startup script. I know my servers use the wrong script! My suggestiion would be to check if safe_mysqld exists during the 4.0 install and if it does remove it, then create a link to mysqld_safe named safe_mysqld. This maintains compatibility for anyone who has existing scripts and uses only one! Then in 4.1 perhaps deprecate the safe_mysqld completely, but I don't think it's a big problem to maintain the link if it exists. Thoughts anyone? I'm not sure how they're generated (possibly from the manual), but the INSTALL-SOURCE and INSTALL-BINARY files in 4.x also have references to safe_mysqld rather than mysqld_safe. I have noticed someone is looking because I see changes have been made to the FreeBSD notes section. I don't know how I could have missed this as I always look at commits posted to the internals list! So, maybe I should use the comments area of document on the web site, hopefully someone looks at that and will include my other suggestions (Specifcally for BSDi and FreeBSD). Seems much easier just to make my comments on the mysql/docs web page! One other thing, I noticed that Multi-table update is mentioned in the 4.0.2 release notes, but the syntax is not yet in the manual and I didn't see the commit! Did I miss the commit? I want to pull this ASAP and test it. Thanks everyone, Ken P.S. to Monty have been trying to recreate the 'row 0' error with mysqldump unsuccesfully. I am not sure what has changed. Current stats: | Questions| 345687 | | Qcache_queries_in_cache | 5007 | | Qcache_inserts | 26136 | | Qcache_hits | 205394 | | Qcache_not_cached| 3670 | | Qcache_free_memory | 54115092 | | Qcache_free_blocks | 1038 | | Qcache_total_blocks | 11830 | Maybe related to the current great cache hit ratio I am experiencing 59%! Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 26 days, processed 588,003,868 queries (252/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: manual
I have tryed to download the mysql manual.pdf but for some reason I cant. Would anyone be able to email me the pdf version? [EMAIL PROTECTED] Hi, I think it's around 3MB.. so if say 10 persons would mail it to you you'll get about 30MB in your mailbox.. If you're using M$ IE you might need to IIRC right click on the link.. mysql, query Bye, B. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: manual
I have tryed to download the mysql manual.pdf but for some reason I cant. Would anyone be able to email me the pdf version? [EMAIL PROTECTED] Thanks Sharon - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Manual for sale? (was Re[2]: mysql.org)
Colin Faber writes: Michael, Interesting idea but I think it would problematic over all, The mysql manual changes almost everyday (anyone that syncs the bk tree's knows) I would suggest a better solution would be to provide the manual as a localized application (possibly even ported to PalmOS/WindowsCE), Anyone? ;-) I think that both yours and M. Collins ideas are fine and we shall definitely come up with something. -- 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: Manual for sale? (was Re[2]: mysql.org)
Michael, Interesting idea but I think it would problematic over all, The mysql manual changes almost everyday (anyone that syncs the bk tree's knows) I would suggest a better solution would be to provide the manual as a localized application (possibly even ported to PalmOS/WindowsCE), Anyone? ;-) Michael Collins wrote: At 8:09 PM -0400 7/13/01, Mark A. Chalkley wrote: I, for one, was considering purchase of their distribution just to get the printed manuals, but wouldn't have one from them now if they were giving them away. BTW, why doesn't MySQL AB print the manual and sell it? I would gladly pay US $ 30-40 to have a nice bound version. (Maybe O'Reilly could arrange for it.) I have Paul's book and have read it most of the way through, but it would nice to have the manual handy as well. I spend too much time reading off the computer and it is a refreshing change to read paper. Besides its hard to put sticky notes into the pages of a pdf... -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.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: Manual for sale? (was Re[2]: mysql.org)
At 9:15 PM -0600 7/13/01, Colin Faber wrote: Michael, Interesting idea but I think it would problematic over all, The mysql manual changes almost everyday (anyone that syncs the bk tree's knows) I would suggest a better solution would be to provide the manual as a localized application (possibly even ported to PalmOS/WindowsCE), Anyone? ;-) What I want to good old fashioned paper. Something I can take anywhere (I dont own a palm or laptop and even if I did would not take everywhere), take notes on, mark pages for future reference, etc. A cut at some point in time would suffice. -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.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: Manual for sale? (was Re[2]: mysql.org)
Colin Faber wrote: Michael, Interesting idea but I think it would problematic over all, The mysql manual changes almost everyday (anyone that syncs the bk tree's knows) I would suggest a better solution would be to provide the manual as a localized application (possibly even ported to PalmOS/WindowsCE), Anyone? ;-) Actually I know that Monty himself uses Palm with copy of manual in it. Meanwhile I never asked for technical details and do not know more about topic as I am not PDA owner (yet ;)). -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ 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: newbie question re: manual tutorial
Well, I loaded mySQL 3.23.32 onto my RedHat 6.2, kernel 2.2.14-5.0 box, and the installation appears to have gone well. I ran through the problem selects in the tutorial and of course it works properly. (Tutorial steps at http://www.mysql.com/documentation/mysql/bychapter/manual_Tutorial.html#Exam ples ) (yes, some newbies read the docs!) I will now have to attempt removal of mySQL from my RH 7.0 box and install this latest version. What I find terribly troubling is that the 7.0 box is a straight off the disk install of Linux w/mySQL on a clean machine and this "silent" failure occurred. What if the error had not been so significant? Thanks for the suggestions I rec'd from this group. John Wallace - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: newbie question re: manual tutorial
try; select rticle, dealer, price from shop where price = '19.95'; notice the "'" around the value? :) Hope that does it for you. Atle On Tue, 23 Jan 2001, John Wallace wrote: mysql SELECT article, dealer, price - FROM shop - WHERE price=19.95; Empty set (0.00 sec) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
