Re: Novice / Intermediate user seeks help in structuring data / tables

[Jeff Sabarese]

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.