MySQL Forums
Forum List  »  MyISAM

Re: Novice / Intermediate user seeks help in structuring data / tables
Posted by: Jeff Sabarese
Date: December 07, 2005 06:41PM

it's embarrassing to say, but i'm not sure what you mean by "use the \G output option". i looked around in the manual, but couldn't find anything other that what looked to me to be an alternative line ending to ";", however, when i ended my query w/ "\G", i received an error. could you please show me an example?

here is my "stops" table:
http://adesigninteractive.com/fileshare/mysql/stops.htm

and my "timetable" table:
http://adesigninteractive.com/fileshare/mysql/timetable.htm

note the field-names of the latter are the same as that which populates the rows of the second field "stop_code" in the "stops" table-- what i was attempting to explain above. let me know if you still need the other info, and how to provide that for you, please.

NOTE: the name variations are ARBITRARY, as i've renamed them to protect privacy of the info owner.

thank you very much!!
:)

-- -- -- --
Use CSS [ content:" ?? " ] for Unicode + Control Chars (e.g. newline, etc)... Gain understanding of Codepage, Charset, Encoding, Keymapping... Generate CSS and JavaScript on-the-fly with PHP... Tales from the Communications Dept @ NoviceNotes.Net



Edited 2 time(s). Last edit at 12/07/2005 07:43PM by Jeff Sabarese.

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.