RE: sql join help

count(*) FROM orders AS o LEFT JOIN members AS m USING (memberId) LEFT JOIN orderItems 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

sql join help

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

join assistance

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] ||| Seattle, WA, USA

myDomain-relay-bin file?

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

best-practices backups

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] ||| Seattle, WA, USA

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

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 [mailto:[EMAIL PROTECTED]] Gesendet: Dienstag, 10

SQL help, search with related record in 2nd table

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://michaelcollins.net

Primary key info in C API

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

Need reversible encryption as string

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

Re: Need reversible encryption as string

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

Re: Need reversible encryption as string

, 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] ||| Seattle, WA, USA ||| http://www.lassodev.com

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 (SELECT ProductID, SmImage

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

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 the nice tables wish describe

RE: describe all tables

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] ||| Seattle, WA, USA ||| http

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 Services

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 PROTECTED

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 Services

Re: most appropriate data type for currency?

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 __ ||| Michael Collins ||| ||| Kuwago

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

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] ||| Seattle, WA, USA ||| http

Re: MySQL Checkbox table field

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 ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA

Re: MySQL Checkbox table field

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 __ ||| Michael Collins

Re: MySQL Checkbox table field

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

://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 ||| mailto:[EMAIL

Re: NewBie Question; Backups?

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

MySQL table name case sensitivity

select * from Menu; snip ... etc ... 8 rows in set (0.00 sec) -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.com

Re: Mac OS X and MySQL 3.23.45

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). -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED

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

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 Collins

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

BACKUP TABLE help

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

Re: Mac OS X and MySQL

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

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

Re: GUI for OSX

/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:[EMAIL

Recursive select to produce hierarchical listing

. 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 ||| http://www.lassodev.com

Recursive select to produce hierarchical listing

. 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 ||| http://www.lassodev.com

FULLTEXT search plus additional qualifiers

in a strict sense) -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.com database,sql,query,table - Before posting, please

Re: aggressive dolphin?

, 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:[EMAIL PROTECTED] ||| Seattle, WA, USA

searching columns with lots of text

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 Services

Re: Re: MySQL GUI

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 ||| http://www.lassodev.com

Re: new installation

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

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

will not terminate with a usual kill command. -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.com - Before posting, please check

Re: MySQL GUI

. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com At 10:36 PM +0300 7/31/01, Sinisa Milivojevic wrote: Michael Collins writes: What is MySQL GUI exactly? Is it like the MySQL

Re: client/server

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 PROTECTED] ||| Seattle, WA, USA

Re: easy question, what is MUL

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

Re: setting root password in mysql

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

easy question, what is MUL

__ ||| 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: Not able to login as root

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

Re: mysql on os x 10.0.4

__ ||| 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.org

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 PROTECTED

Re: MySQL Variables

% 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 my home directory, logged out and started a new telnet session. -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL

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 standard MySQL installation. I find I will always get the standard port

Re: MySQL Variables

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 for Mac OS X. -- Michael __ ||| Michael Collins ||| ||| Kuwago

Re: Where to find help??

: 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 ||| ||| Kuwago Web Services

Re: MySQL Variables

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

Re: MySQL Variables

/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. -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services

Re: MySQL Variables

540. -- 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 for sale? (was Re[2]: mysql.org)

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

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

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

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

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

-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, please check

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 ||| ||| Kuwago Web Services

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

there be some possibility of conflict 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: BACKUP TABLE command error

not have any my.cnf file. -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.com - Before posting, please check: http

Re: mysql on OSX v. 10.0.4

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

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 Services

Re: BACKUP TABLE command error

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:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.com

my.cnf

/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 PROTECTED] ||| Seattle, WA

characters supported in MySQL fields

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 Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA

Re[2]: characters supported in MySQL fields

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 ||| http://www.lassodev.com