thanks for the chuckle. we've all been beginners and i still do dumb things with sql.
download corereader from http://corereader.com it will let you click on the database objects to build your queries. when you click on your table name and your field name, it will return the data to you and, if you care to look at it, it will show you the correct query of select * from table_name instead of your select * from postcode > Hi > > I am a beginner in using mysql on Windows platform, and I have a question regarding > the use of "SELECT * from TABLE_NAME" statement within the mysql prompt. > > I have a table of consisting of three columns POSTCODE, SUBURB, STATE where > the primary key is a composite of all three fields. > > When I run SELECT * FROM POSTCODE; in mysql prompt I get garbled display of > data and some of my data is not shown. > However when viewed from within a tool like PHP MYADMIN all the data is displayed > correctly. > > Is this a bug or a limitation of mysql? Or am I doing something wrong? > > Any advice/help would be most appreciated. > > Thanks > > Best regards > > Boris > -- John Ragan [EMAIL PROTECTED] http://www.CoreReader.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