RE: sql join help

--- From: Michael Collins [mailto:[EMAIL PROTECTED] Sent: 11 April 2004 05:14 To: [EMAIL PROTECTED] Subject: sql join help I suppose this would be easier with subselects but I am using MySQL 4: I want all orders that are of orderStatus 2 and whose orderitems contain a product that is in a productparent

sql join help

ems AS oi ON (o.orderId=oi.orderId) LEFT JOIN products AS p ON (oi.productId=p.productId) AND (p.productParentId > 2) WHERE (oi.orderId IS NULL) AND (o.orderStatus=2); -- Michael __ ||| Michael Collins ||| Kuwago Inc mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA

join assistance

e are other order items in the order that are not that product. So Distinct does not help here. What I think I need is a subselect and the IN clause, but that is not available in MySQL 4. -- Michael __ ||| Michael Collins ||| Kuwago Inc mailto:[EMAIL PROTECTED] ||| Seatt

best-practices backups

, rotating backups, or remote storage, and I am not concerned about the size of the backup files. Replication might be the best scenario for some sites but this case is not high finance. -- Michael __ ||| Michael Collins ||| Kuwago Inc mailto:[EMAIL PROTECTED] ||| Seattl

myDomain-relay-bin file?

=16M -- Michael __ ||| Michael Collins ||| Kuwago Inc mailto:[EMAIL PROTECTED] ||| Seattle, WA, USAhttp://michaelcollins.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: AW: SQL help, search with related record in 2nd table

; GROUP BY Visitors.NameLast; Michael At 9:33 AM +0200 9/11/02, Carsten Zilch wrote: >Hello, > >the answer for: >RE: Selecting data from one table if it's NOT in another >should also answer your question > >Carsten > >-Ursprüngliche Nachricht- >Von: Michael Collins [

SQL help, search with related record in 2nd table

ly find records from Visitors if there are any records in WishListItems (I am not checking anythign in WishListItems, there just has to be at least one record). -- Michael __ ||| Michael Collins ||| Kuwago Inc mailto:[EMAIL PROTECTED] ||| Seattle, WA, USAhttp:

Primary key info in C API

er by" keyword, as follows: select * from products join units where products.productid = units.productid order by productnumber the primary key information doesn't arrive. Should it, or am I expecting too much? -- Michael __ ||| Michael Collins ||| ||| Kuwago Inc

Re: Need reversible encryption as string

ut would this be my solution if I was using MySQL 4? In conclusion, there is no reversible encryption available in MySQL 3.+ that can be stored as a text string(?) -- Michael __ ||| Michael Collins ||| ||| Kuwago Inc||| mailto:[EMAIL PROTECTED] ||

Re: Need reversible encryption as string

;of these. OK that is the answer. Thank you for the help! -- Michael __ ||| Michael Collins ||| ||| Kuwago Inc||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.com --

Need reversible encryption as string

I understanding this correctly? -- Michael __ ||| Michael Collins ||| ||| Kuwago Inc||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.com - Before posting, please check:

Re: Selecting several columns using DISTINCT

At 4:46 PM +0100 2/3/02, Joseph Bueno wrote: >Michael Collins a écrit : > > I am trying to normalize some MySQL tables and need to move a few >> columns from one table to another while maintaining the relationship > > between the two. > > SELECT DISTINCT ProductID &

Selecting several columns using DISTINCT

? -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.com - Before posting, please check: http://www.mysql.com/manual.php (the

Re: describe all tables

At 2:54 PM -0500 1/28/02, Andy Ingham wrote: >A fellow in our shop wrote a perl script to do just that. Nice but I do not think I have perl DBI library installed. Does it have to be compiled in? I am on Mac OS X -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Servi

RE: describe all tables

ard for the table as well as the column. So instead of: describe MYdb.products '%'; You could do: describe MYdb '%'; to return all tables from the datbase MYdb -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seat

RE: describe all tables

>From: Michael Collins [mailto:[EMAIL PROTECTED]] >Can "describe" be used to show columns from all tables in a database? At 9:56 AM -0800 1/28/02, Bruce Sandell wrote: >try mysqldump with the -d option. That was my first thought, but this does not give a result in th

describe all tables

Can "describe" be used to show columns from all tables in a database? All at once that is. I want to document all fields in all tables and find I need to display one table at a time. -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL

Re: MySQL 3.23.47 on MacOSX 10.1.2: Could someone help me gettingstarting

d in this is a command, MyNewPassword is what you want for your new password. (or you could use the SET Password SQL command, the old way) -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle,

Re: most appropriate data type for currency?

only have to worry about precise rounding with doubles. As I mentioned, I am only selling t-shirts, none of which exceed $30 USm quantity 2 perhaps. Do I really need to use centi-cents in this case or will the "cents" value do (I do plan to use an integer)? -- Michael

most appropriate data type for currency?

Using MySQL 3.23.47, is the best data type for small currency float(4) ? This is for prices of items in a shopping cart for example t-shirts. What is the difference in using float vs decimal? I know I don't need double. -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Ser

Re: Null vs empty string and storage

Using MySQL 3.23.47, is the best data type for small currency float(4) ? This is for prices of items in a shopping cart for example t-shirts. What is the difference in using float vs decimal? I know I don't need double. -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Ser

Re: MySQL Checkbox table field

Sorry if I spoke out of turn. So why is it that when you add a field with that type you get tinyint(1). -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA |||

Re: MySQL Checkbox table field

n the MySQL documentation (in the data type section). Question remains, can one effectively index tinyint(1)? Als, back to the original question, in light of bit being equivalent to tinyint(1), I suppose storing Y/N is better achieved through the use of CHAR(1). -- Michael __ ||| Mich

Re: MySQL Checkbox table field

IT' takes 1 char). Are you thinking MS SQL Server? I am not sure there is a bit type in MySQL? Do you mean Char(0)? Anyhow, in MS SQL Server a bit type column cannot be indexed so you are better off with CHAR(1). -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services |||

Re: MySQL Checkbox table field

At 10:58 AM -0500 1/25/02, Vernon A Webb wrote: > > database,sql,query,table > >Which field type do I use for a simply checkbox Y,N? How about CHAR(1)? -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seat

Null vs empty string and storage

allocated, and empty and NULL have the same storage requirements? I suppose it is different for CHAR, VARCHAR, TEXT and so forth.. -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.com

Count occurrence of word in a column

__ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.com - Before posting, please check: http://www.mysql.com/manual.php (the manual

Re: MySQL graphical front-end for Mac OSX

http://www.lassodev.com/pub/webminNotes02.sit The ones that stand out on the not free list include MacSQL Monitor, SQL4X Manager, and ProSQL (I haven't spent much time with JaneBUILDER). You get a lot more with these. -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| ma

MySQL table name case sensitivity

/images/icons/Zebra.gif',2); Query OK, 2 rows affected (0.00 sec) Records: 2 Duplicates: 0 Warnings: 2 mysql> select * from Menu; 8 rows in set (0.00 sec) -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA

Re: RESTORE ??? RE: NewBie Question; Backups?

At 9:51 AM -0600 11/29/01, ROGGER ALEXIS VASQUEZ MARTINEZ wrote: >Thanks and >How DO I RESTORE IT ??? IF using at least version 3.23.25, then you can use RESTORE TABLE (described just after BACKUP TABLE). -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services |||

Re: NewBie Question; Backups?

s better? BACKUP TABLE allows for an easier restore perhaps? -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.com - Befo

Re: Mac OS X and MySQL

issues with using MySQL on Mac OS X. -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.com - Before postin

BACKUP TABLE help

ng up databases? Better than mysqldump? -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.com - Before posting, please

RE: Mac OS X and MySQL

At 2:35 PM -0600 11/26/01, john wrote: >Excuse me, but I never intended on adding the world to that question, And I never invited your private flame. -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| h

RE: Mac OS X and MySQL

At 1:49 PM -0600 11/26/01, john wrote: >this is not meant to be demeaning, but your not seriousely running a server >with a Mac are you? And why not? Are you at all familiar with Mac OS X and/or Darwin? It is Unix BSD. Seems a fine choice for MySQL. -- Michael __ ||| Michael C

Mac OS X and MySQL

Now that the shutdown command has been repaired, are there other outstanding issues specific to Mac OS X that the MySQL AB team has under development for MySQL 3.x? -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA

Re: Mac OS X and MySQL 3.23.45

e default. >I use the >source and 3.23.44 has worked fine for me (except the shutdown >problem). I'm going to compile 3.23.45 now and see how it goes. On: http://www.mysql.com/doc/N/e/News-3.23.45.html It says: "shutdown should now work on Darwin (Mac OS X). " -- Mi

Mac OS X and MySQL 3.23.45

(Darwin 1.3.x)? 2) How do I find out what options are compiled into the binary? BTW, Thanks to MySQL AB for making a binary specific to Mac OS X! -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http

Recursive select to produce hierarchical listing

n item appears within a folder. Level is the level at which the folder is located, this makes it easier to indent the items in a folder. -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||

Re: GUI for OSX

cts/phpMyAdmin/ Webmin James Cameron http://www.webmin.com/webmin/index.html JaneBUILDER http://www.seejanecode.com/ ProSQL http://www.intellisw.com/prosql/ SQLBoss Reinhard R. Blumauer http://www.sqlboss.com/ -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EM

Recursive select to produce hierarchical listing

n item appears within a folder. Level is the level at which the folder is located, this makes it easier to indent the items in a folder. -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||

Re: aggressive dolphin?

y clues, are discovering that dolphins are far from the happy, peaceful >creatures that humans think they know. Are you from NuSphere? (perhaps this is how they feel about "Flipper" at this point) -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMA

FULLTEXT search plus additional qualifiers

ySQL is not able to do sub-selects in a strict sense) -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.com database,sql,query,table

searching columns with lots of text

s and risk slowing down activity to a crawl. I suppose indexing is not going to help in this case at all. But what does one do when it becomes more important that the search occur at all despite the time that it might take? -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Ser

Re: new installation

sqld, you have to shutdown in that order. A normal kill may not work. -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.com ---

Re: Re: MySQL GUI

do so are on the developers CD then I think it would be used. There would just need to be some instructions showing what and how to install what is needed. -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA

Re: mySQLd won't die under Darwin (Mac OS X 10.0.4)

The -9 option is the signal number to use when a process will not terminate with a usual kill command. -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.com --

Re: client/server

eck out these: phpMyAdmin Phpwizard.net Current Version: 2.1.0 http://www.phpwizard.net/projects/phpMyAdmin/ Webmin James Cameron Current Version: 0.87 http://www.webmin.com/webmin/index.html -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTE

Re: MySQL GUI

e doable. > >-- >Regards, >__ ___ ___ __ > / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> > / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer >/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ><___/ www.mysql.com At 10:36 PM +0300 7/31/01, Sinisa Milivojevic wrot

Re: MySQL GUI

ru.de/ SQLBoss (beta 1) http://www.sqlboss.com/ Anyone know others? -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassode

Re: easy question, what is "MUL

key since I created an index on that field. -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.com - Before posting, pleas

Re: Not able to login as root

you forgot it then use the --skip-grant-tables option to start the server -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.com -

easy question, what is "MUL

tName) ) -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.com - Before posting, please check: http://www.mysql.com/manu

Re: setting root password in mysql

l77 BTW, if you get an error then there is not point continuing. -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.com ---

Re: mysql on os x 10.0.4

you are not required to indicate the path to the file to execute the contents of the file as a script. -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.com ---

Re: mysql.org

ed. If you want to make money on MySQL, follow the guidelines of GPL to the letter and to the approval of MySQL or pay the per-copy license. I guess the solution seems so simple for an outsider. -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL

Re: Where to find help??

ook: SQL in a Nutshell Author: Kevin Kline with Daniel Kline, Ph.D. ISBN: 1-56592-744-3 Published: December 2000, O'Reilly & Associates 224 pages http://www.oreilly.com/catalog/sqlnut/ http://www.bookpool.com/.x/SSCOLL/sm/1565927443 -- Michael __ ||| Michael Collins ||| ||

Re: MySQL Variables

ecognize the author. This book has a 1995 release date on it which in internet time makes it an antique, but in the case of Unix probably not a whole lot has changed I imagine. Nevertheless, it would be a dream if you could write the version of "Using tcsh" specifically fo

Re: MySQL Variables

At 11:09 AM -0700 7/15/01, Michael Collins wrote: >At 1:47 PM -0500 7/14/01, Paul DuBois wrote: >>>>>Any solution I've tried using the LassoMySQL/var/my.cnf or >>>>>~/.my.cnf files affect both the special installation as well as >>>>>the stan

Re: MySQL Variables

se of the command for the standard install. The question though is will parameters be passed in? Will it then work, for example, to import a file using: root% mysql MCExample < /Import_MCExample.mysql I cannot test it since so far the alias file idea does not work, I put the .cshrc file into

Re: MySQL Variables

ironment variables], page 540. -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.com - Before posting, please check: ht

Re: MySQL Variables

ck Then, invoking the client from within /Path/specialMySQL/bin/mysql would use the different port and socket?> And, using /usr/local/mysql would then use the default datadirectory and port? BTW, this is on Mac OS X, I wouldn't think it would matter but I thought to mention it. -- Michae

Re: MySQL Variables

n. I find I will always get the standard port. Help? -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.com - Before posti

Re: mysql.org

the actions of NuSphere. -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.com database,sql,query,table - Before posting

RE: mysql.org

gt; >- >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]> >

Re: Manual for sale? (was Re[2]: mysql.org)

n time would suffice. -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.com - Before posting, please check: http://www.

Manual for sale? (was Re[2]: mysql.org)

to read paper. Besides its hard to put sticky notes into the pages of a pdf... -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.com

MySQL.org

mentions that the Web site will confuse new users, but I think this one will confuse them even more: http://mysql.net/ (for non-Japanese users that is). -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http

SQL-99

f worms to discuss all the details, all I am looking for is a general answer. -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.la

Re: Easiest way to create a duplicate of a db?

if some request was being made while the copy was occurring? -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.com -

Re[2]: Where to find options / my.cnf documentation?

At 5:10 PM +0200 7/9/01, Werner Stuerenburg wrote: >It's so easy, you won't think of it: start mysqld with parameter >-h (=help): > >mysqld -h > >shows all parameters and current settings Isn't that: mysqladmin variables -- Michael __ ||| Michael Collins

Re: Re[2]: Where to find options / my.cnf documentation?

my-huge.cnf, my-medium.cnf, my-large.cnf -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.com - Before posting, ple

Re: BACKUP TABLE command error

abase Error code 132: Unknown error: 132 I realize it is simpler if I know how may there are: #!/usr/bin/perl for ($inc = 1; $inc< 90; $inc++) { system "(/usr/local/bin/perror -v $inc;)"; } -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAI

Re: Book recommendation

At 11:15 AM -0700 7/8/01, tj marlin wrote: >MySQL, Paul DuBois, New Riders publishing, 2000, $40 better price here: http://www.bookpool.com/.x/SSCOLL/sm/0735709211 I have no association with this book dealer -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Servi

Re: mysql on OSX v. 10.0.4

MacOSX/ http://miltonshole.thespacemonkey.com/osx/mysql.html Here is an article on it: http://www.stepwise.com/Articles/Workbench/2001-03-24.01.html -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA |||

Re[3]: characters supported in MySQL fields

as recently added direct MySQL support that has not fully matured. -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.com --

Re: BACKUP TABLE command error

an I can log in to administer MySQL with that username? BTW I do not have any my.cnf file. -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.com

BACKUP TABLE command error

ailed copying .frm file: errno = 13 | | Example.Import_Web | backup | status | Operation failed | +++--+--+ 2 rows in set (0.02 sec) Anyone recognize the error? -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Ser

Re[2]: characters supported in MySQL fields

I thought that the way the data was stored you could not use certain characters. If this is the case, then thanks for your help in clarifying the issue. -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA |||

characters supported in MySQL fields

r literal instances of `_' in contexts where `_' would otherwise be interpreted as a wild-card character) In other words, am I correct that none of these characters can be stored in a MySQL string field (such as CHAR, VARCHAR, or TEXT)? -- Michael __ ||| Michael Collins ||| ||| Kuwago

my.cnf

n or `/usr/local/var' for a source installation). Note that this is the directory that was specified at configuration time." Can I change this after installation and initial configuration? -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTEC