Re: [gentoo-dev] MySQL doc [updated]

[Philip Webb <purslow@sympatico.ca>]

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 <into your infile>";
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