From mboxrd@z Thu Jan 1 00:00:00 1970 Received: from lists.gentoo.org ([140.105.134.102] helo=robin.gentoo.org) by nuthatch.gentoo.org with esmtp (Exim 4.43) id 1DsKEn-00042g-Ln for garchives@archives.gentoo.org; Tue, 12 Jul 2005 12:51:50 +0000 Received: from robin.gentoo.org (localhost [127.0.0.1]) by robin.gentoo.org (8.13.4/8.13.4) with SMTP id j6CCo2Q5024889; Tue, 12 Jul 2005 12:50:02 GMT Received: from tomts36-srv.bellnexxia.net (tomts36.bellnexxia.net [209.226.175.93]) by robin.gentoo.org (8.13.4/8.13.4) with ESMTP id j6CCm1Qv027589 for ; Tue, 12 Jul 2005 12:48:02 GMT Received: from sympatico.ca ([70.49.168.186]) by tomts36-srv.bellnexxia.net (InterMail vM.5.01.06.10 201-253-122-130-110-20040306) with SMTP id <20050712124851.MYSP16985.tomts36-srv.bellnexxia.net@sympatico.ca> for ; Tue, 12 Jul 2005 08:48:51 -0400 Received: by sympatico.ca (sSMTP sendmail emulation); Tue, 12 Jul 2005 08:48:50 -0400 Date: Tue, 12 Jul 2005 08:48:50 -0400 From: Philip Webb To: gentoo-dev@lists.gentoo.org Subject: Re: [gentoo-dev] MySQL doc [updated] Message-ID: <20050712124850.GA7573@sympatico.ca> Mail-Followup-To: gentoo-dev@lists.gentoo.org References: <20050712133816.74d66597@localhost> <20050713012259.36dd9dcc@localhost> Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Id: Gentoo Linux mail X-BeenThere: gentoo-dev@gentoo.org Reply-to: gentoo-dev@lists.gentoo.org Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20050713012259.36dd9dcc@localhost> User-Agent: Mutt/1.5.8i X-Archives-Salt: 8222d79e-c7ed-47d9-bda7-e0004e5aaa41 X-Archives-Hash: f0cb5e6abc4a13c8508226d8319ab0e3 050713 Chris White wrote: > I've updated the MySQL doc here: > http://dev.gentoo.org/~chriswhite/mysql.html > It contains the fixes that have been suggested to me, > as well as a note on the SELECT field FROM table form > of the SELECT statement. Thanks for the input recieved! As someone who has never used MySQL, but might want to in future, your help doc looks very useful: thanks for your efforts. It does need running thro' a spell-checker & a careful proof-reading, which is always easier for someone else than for the author himself. Someone has already pointed out that it's 'Structured', not 'Standard'. under '[code list] 1.4', why do we need a root password ? are you not setting this up as a user ? eg if I use MySQL, it will be to manage a large database of urban transit information, which I will do entirely inside my desktop machine with no access to other users or to the Internet [ok: I see Sect 4 below]; at the beginning of Sect 2 , you have 'promt'; below '2.1', you don't explain what database 'mysql' is for; below '2.3', "let's us know" sb [should be] "lets us know"; under 'Creating the tables', it looks very much like a spreadsheet: perhaps you could point out the parallels; can you import data directly from a spreadsheet like Open Calc ? below '3.2', "most simplistic" sb "simplest" or "most straightforward"; under '3.6', you should explain that you are using 'insert into' to insert a new record (if that's what it does), not arbitrary data; under '3.7', "seperated" sb "separated" (other instances below): it's a trap for anyone who missed out on Latin at school (smile); under '3.10', you need to expand your explanation: "if you paste information "; under '3.11', "comprimised" sb "compromised": 3.11-12 looks a bit out of place: perhaps move it below with a cross-ref ? under '3.14', why do the columns not line up in your examples ? is this a deficiency in MySQL or a result of your desktop set-up ? under '3.16', "priveleges" & "privleges" sb "privileges": this recurs several times below (grimace); at the beginning of Sect 4 , the point about root versus users is explained: this sb mentioned briefly right at the top in Sect 1 ; under '4.3', i would write "quitting", but perhaps US-speak is "quiting"; under '4.8', is "admin" the same as "root" ? -- this needs explanation. I've skipped over all the stuff about user privileges, as it looks as if my own usage would be as "root" in the MySQL sense (above). One final point you don't mention: is there a GUI front-end for MySQL ? I'm sure there is, so which one(s) do you recommend ? For myself, I'm happy to use CLI where it's simplest, but it looks as if a GUI would save a lot of typing injuries here. HTH : it's meant to be picky (smile). Your doc looks very helpful, but needs a bit of polishing & expansion. -- ========================,,============================================ SUPPORT ___________//___, Philip Webb : purslow@chass.utoronto.ca ELECTRIC /] [] [] [] [] []| Centre for Urban & Community Studies TRANSIT `-O----------O---' University of Toronto -- gentoo-dev@gentoo.org mailing list