Re: Select: JOIN magic?

-- 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

Re: ado , blob reading problem

__ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- John Ragan [EMAIL PROTECTED] http://www.CoreReader.com/ - Before posting, please check

Re: hello to new guy

yourself. Say on your home computer. Then, update the web pages by hand as needed. I may be missing what you need, so let me know. Hey, everybody else. Any input? --- Rodney Broom President, R.Broom Consulting http://www.rbroom.com/ sql -- John Ragan [EMAIL

Re: [MySQL v3.23.53a] BLOB Data and Table Size

, Pae P.S.: MySQL, SQL, and Query(to clarify that it's not spam nor OT). -- John Ragan [EMAIL PROTECTED] http://www.CoreReader.com/ - Before posting, please check: http

Re: Is it possible to export data from access to MySQL?

? Steve Jackson Web Developer Viola Systems Ltd. http://www.violasystems.com [EMAIL PROTECTED] Mobile +358 50 343 5159 -- John Ragan [EMAIL PROTECTED] http://www.CoreReader.com/ - Before

Re: hello to new guy

://www.lawrencehouse.ca - Good computer website - http://www.techtv.com Looking for Star Wars and View Masters ! Also any U.S. state quarters. -- John Ragan [EMAIL PROTECTED] http://www.CoreReader.com

Re: join with OR and LIMIT fails to return result

: -- 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

Re: MySQL subquery that works

subqueries on MySQL via MyODBC driver since it is obvious that they work? What can I do, but I do not want to use access database as a layer between my application and mysql server? I use Visual Basic for accessing mysql server. Thank You very much Bruno -- John Ragan

Re: help for image into database

_ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail -- John Ragan [EMAIL PROTECTED] http://www.CoreReader.com

Re: why so slow?

compared with the former MS Access ODBC connection. COULD U TELL ME HOW TO FIX THIS? thanks a million!! weiwei -- John Ragan [EMAIL PROTECTED] http://www.CoreReader.com/ - Before posting

RE: The dreaded move from Oracle to MySQL

tables it doesn't slow down to below 5 or 6k. Cheers, Wes -- John Ragan [EMAIL PROTECTED] http://www.CoreReader.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual

Re: Help me optimize my query

://corereader.com it will let you quickly do and re-do join queries just by clicking on your database objects, so you can concentrate on developing logic without worrying about syntax. when you get the query that you like, copy the sql code into your app. -- John Ragan [EMAIL

Re: The dreaded move from Oracle to MySQL

of migration please point me in the right direction. I would really hate to stay with Oracle for the only reason that we can't get the data off of it and on to another box :) Thanks, Wes -- John Ragan [EMAIL PROTECTED] http://www.CoreReader.com

Re: SELECT Statement Question

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

Re: MySQL on windows

for 3/4 years, but never on Windows. How does MySQL compare on Linux and Windows for stability and performance ? Simon -- Simon Windsor mail: [EMAIL PROTECTED] Regards Mike -- John Ragan [EMAIL PROTECTED] http://www.CoreReader.com

Re: MySQL Left Join Query

recordsh in the decplacement table but I will only be interested in a specific one. I hope this makes some sort of sense!! -- John Ragan [EMAIL PROTECTED] http://www.CoreReader.com/ - Before

Re: MySQl LEFT JOIN Syntax

(Snum,name,email,address) T2(Bnum, notes, time) I wnat ot get the result(name, email, notes). Any suggestion, comments? Thanks Yan -- John Ragan [EMAIL PROTECTED] http://www.CoreReader.com/ - Before

Re: Re[2]: delete where column = null

into t(id) values(null); select * from t; delete from t where id = 1; select * from t; AB I get the same behaviour with mysql 3.23.47 (not max) and with mysql v AB 4.0.4-beta AB Without the index it works fine. Must be a bug AB Cheers, AB Andrew -- John Ragan [EMAIL

Re: Newbie: interfacing to MySQL?

. Regards Brynley -- John Ragan [EMAIL PROTECTED] http://www.CoreReader.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Re: Mysql SELECT question (LEFT JOIN?)

it's some sort of left join, and I was never very good at those. :-/ -- John Ragan [EMAIL PROTECTED] http://www.CoreReader.com/ - Before posting, please check: http://www.mysql.com

Re: Fw: SCHEMA, ARCHITECTURE ???

? Do I create multiple databases or do I create only one database with multiple tables? (Any general rules of thumb?) How do I know if I need to use Keys, Indexes or other features in order to optimize the database? -- John Ragan [EMAIL PROTECTED] http

Re: limited queries to one returned row

(10 records) table cannot issue commands to grab *all* of the data. Thanks ahead of time for any info! --Raj -- John Ragan [EMAIL PROTECTED] http://www.CoreReader.com/ - Before posting

Re: How to link tables in MySQL

__ Do you Yahoo!? U2 on LAUNCH - Exclusive greatest hits videos http://launch.yahoo.com/u2 -- John Ragan [EMAIL PROTECTED] http://www.CoreReader.com/ - Before posting

Re: RE: MySql 4.1 Sub Selects and not stored procedures

/unsubscribe.php -- John Ragan [EMAIL PROTECTED] http://www.CoreReader.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Re: Problems with simple(?) query

, find for yourself the logic errors such as has been pointed out in your query. have fun. -- John Ragan [EMAIL PROTECTED] http://www.CoreReader.com/ - Before posting, please check: http

Re: I: How to port MS Access to MySQL ??

://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 -- John Ragan [EMAIL PROTECTED] http

Re: Question regarding nested select

BY department -- 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

RE: Newbie: Intersecting entities

. Thanks, Rik Forgo JIST3 Army Test, Training and Technology Integration Office (T3I) Diverse Technologies Corp. (c) 443.463.8571 (h) 410.859.8474 -Original Message- From: John Ragan [mailto:jragan;arkansas.net] Sent: Wednesday, November 06, 2002 6:55 PM To: [EMAIL

Re: Access replacement...

C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock -- John Ragan [EMAIL PROTECTED] http://www.CoreReader.com/ - Before posting, please check: http://www.mysql.com/manual.php

Re: Newbie: Intersecting entities

JIST3 Army Test, Training and Technology Integration Office (T3I) Diverse Technologies Corp. (c) 443.463.8571 (h) 410.859.8474 -- John Ragan [EMAIL PROTECTED] http://www.CoreReader.com

Re: Problem importing data from Access

| | data | +--+ My guess is that there is a problem with the end of line character being exported to the text file from Access. I chose \n as the end of line character to separate records, but maybe it is something else. Any ideas? Thanks, Brad -- John

Re: MySQL - Windows vs MySQL Linux

but not on Linux. Can anybody point me at anything obvious that I have missed. Thanks in advance. Kevin Passey -- John Ragan [EMAIL PROTECTED] http://www.CoreReader.com/ - Before posting, please

RE: MySQL - Windows vs MySQL Linux

2. Beware of special keywords (I called a field in my database date - that was also wrong -) Since I've checked the case and prefixed my field names it works fine on both platforms Thanks for your help Regards Kevin -Original Message- From: John Ragan [mailto:jragan

Re: Difficult query

as 123.123.123.2 or even can be truncated to 123.123.123 The table is stored on a 3.23.43 mySQL Server. The table type is varchar(15) but this can be changed. Thanks, Alexander Newald -- John Ragan [EMAIL PROTECTED] http://www.CoreReader.com

Re: Total newbie asking for guidance

for the MySQL newbie? I've perused the book list at www.mysql.com, but don't have a feel for the experience level that these books are oriented toward. Any pointers that you could provide to this beginner would be very appreciated. Thank you. -- John Ragan

Re: Alternative for NOT EXISTS

ok. At 10:10 -0400 10/11/02, Michael T. Babcock wrote: John Ragan wrote: try corereader. it will run queries against your mysql, oracle, and ms sql server (and anything else laying around). you can switch between your servers with a click. Am I the only one getting tired

Re: Help with Sum(), newbie

doing wrong? Thanks! --kevin -- John Ragan [EMAIL PROTECTED] http://www.CoreReader.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Re: Alternative for NOT EXISTS

by anybody else is not authorised. If you are not the intended recipient, please contact the sender as soon as possible. The views expressed in this communication may not necessarily be the views held by Serco Integrated Transport. -- John Ragan [EMAIL PROTECTED] http

Re: Alternative for NOT EXISTS

are not the intended recipient, please contact the sender as soon as possible. The views expressed in this communication may not necessarily be the views held by Serco Integrated Transport. -- John Ragan [EMAIL PROTECTED] http://www.CoreReader.com

Re: query help

) | | | || | spec_value | varchar(255) | | | || ++--+--+-+-++ 4 rows in set (0.00 sec) Man is this sql, query stuff fun ;-) Michael -- John Ragan

Re: mysql: multiple SELECTs with INSERT or UPDATE??

Mirza -- 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

Re: Is there Examples and Documents on joining tables?

/JOIN.html but they do not cover joining more than two tables. Thanks for any suggestions. -- John Ragan [EMAIL PROTECTED] http://www.CoreReader.com/ - Before posting, please

Re: Is there Examples and Documents on joining tables?

a few on http://www.mysql.com/doc/en/JOIN.html but they do not cover joining more than two tables. Thanks for any suggestions. -- John Ragan [EMAIL PROTECTED] http://www.CoreReader.com

Re: Select Query

= 25 - Chris Kay Techex Communications Website: www.techex.com.au Email: [EMAIL PROTECTED] Telephone: 1300 88 111 2 - Fax: (02) 9970 5788 - -- John Ragan

RE: Select Query

Broadband, Systems Admin | | Website - www.airewaves.com | | Atlanta, Ga - 678.522.3923 | | Beaufort, SC - 843.379.AIRE(2473)| +--+ -Original Message- From: John Ragan [mailto:[EMAIL PROTECTED]] Sent

Re: Is there Examples and Documents on joining tables?

://www.mysql.com/doc/en/JOIN.html but they do not cover joining more than two tables. Thanks for any suggestions. -- John Ragan [EMAIL PROTECTED] http://www.CoreReader.com/ - Before posting, please

Re: Mixing Linux and Windows and paying for it

ip address in the myodbc dialog, and be amazed at how well it works? Bjarki -- John Ragan [EMAIL PROTECTED] 501-228-0317 http://www.CoreReader.com/ - Before posting, please check

Re: SHAPE command for Hierarchical Recordset

: - ++ To build such an invoice using ADO, VB, DataReport you need that Hierarchical recordset because DataReport won't accept if it is not a hierarchical recordset. How do I achieve this? Thanks Emery -- John Ragan [EMAIL PROTECTED] 501-228

RE: Win32::ODBC Question (Oracle)

-Users mailing list [EMAIL PROTECTED] To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs -- John Ragan [EMAIL PROTECTED] 501-228-0317 http://www.CoreReader.com/ - Before posting

Re: MySQL as a desktop DB

. Lentz [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer, Trainer /_/ /_/\_, /___/\___\_\___/ Brisbane, QLD Australia ___/ www.mysql.com -- John Ragan [EMAIL PROTECTED] 501-228-0317 http://www.CoreReader.com

RE: Basic SQL join question

. The reason I am not storing the keywords in the projects table is that it would be quite a chore in changing the keywords in the system if I did that (modify one keyword, modify all the projects, etc). Anyone have any words of advice for me? Adam. -- John Ragan [EMAIL

CoreReader

that there are no problems involved? -- John Ragan [EMAIL PROTECTED] 501-228-0317 http://www.CoreReader.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http