Re: MySQL query on 4 tables

How large is the status table? I would recommend trying to reduce the inital recordset of your largest table with a subquery and then joining the subquery to the other tables. Could you please show me the full query with the table sizes? Jake Johnson [EMAIL PROTECTED] http://www.plutoid.com

Re: SQL question

This is one quick way to get the newest records of a group if you are grouping by the sku and stock. select stock, sku, qty from table where concat(dt_tm,stock,sku) IN ( select concat(max(dt_tm), stock, sku) from table group by stock, sku ) Regards, Jake Johnson [EMAIL PROTECTED

Re: Delete orphan records

Hello Greg, You are much better off using a not exists clause... delete from child c where not exists ( select 1 from parent p where p.id = c.id) Regards, Jake Johnson [EMAIL PROTECTED] -- Plutoid - http

Re: SQL question

Nice approach Bruce, but I too won't have any problems with your case because I am grouping by sku and stock in the sub-query. Regards, Jake Johnson [EMAIL PROTECTED] -- Plutoid - http://www.plutoid.com Shop Plutoid for the

Re: sum() problems - I don't understand

What is the purpose of the join? I think I know what you are trying to do so make the first query a sub query and join the subquery to the carello table. Regards, Jake Johnson [EMAIL PROTECTED] -- Plutoid - http://www.plutoid.com

Re: Best Pratices for mySQL Backups in Enterprise

Is this better than using mysqldump? Regards, Jake Johnson [EMAIL PROTECTED] -- Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on Rims, Car Audio, and Performance Parts. On Thu, 26 Jun 2003, SAQIB wrote

Re: Best Pratices for mySQL Backups in Enterprise

Cool, Thanks a ton. I think I will stick with mysqldump for a while until my tables get too large. Currently my backups only take a few seconds. Regards, Jake Johnson [EMAIL PROTECTED] -- Plutoid - http://www.plutoid.com - Shop

Re: can you insert null?

Yes, that works for Teradata and Oracle as well. Regards, Jake Johnson [EMAIL PROTECTED] -- Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on Rims, Car Audio, and Performance Parts. On Thu, 26 Jun 2003 [EMAIL

Re: Insert problem

Have you tried single quotes (ie. registry_program='EA')? Regards, Jake Johnson [EMAIL PROTECTED] -- Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on Rims, Car Audio, and Performance Parts. On M

Re: More tables or more joins

_name Contract table user_id Cont_id col_id qty This should be a good start... Regards, Jake Johnson [EMAIL PROTECTED] __ Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on Rims, Car Audio

RE: More tables or more joins

If you want to add another column name, just insert a new record into Contract Column Lookup -- col_id col_name Regards, Jake Johnson [EMAIL PROTECTED] __ Plutoid - http://www.plutoid.com - Shop

Re: SELECT TOP

Be careful! Phil wanted the top 20 and the limit 20 will only return a random 20 records. Regards, Jake Johnson [EMAIL PROTECTED] __ Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on Rims, Car Audio, and

Re: SELECT TOP

No kidding. I didn't know that. Thanks a lot! Regards, Jake Johnson [EMAIL PROTECTED] __ Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on Rims, Car Audio, and Performance Parts. On Mon, 14 Jul

Re: Select Limit question

my table is small but I can't tell what is faster.. a max or a limit mysql> select max(counter) from web; mysql> select counter from web order by counter desc; They seem to be the same in performance. Regards, Jake Johnson [EMAI

mysqldump isn't working anymore

ydb - -- Server version 3.23.49-log Does anyone have any ideas why this doesn't work anymore? Regards, Jake Johnson [EMAIL PROTECTED] __ Plutoid - http://www.plutoid.com - Shop Plutoid for

How do I show column names in php?

I am using php and mysql and I want to show the column names. How do I go about doing this without hardcoding the headers in my php? Regards, Jake Johnson [EMAIL PROTECTED] __ Plutoid - http://www.plutoid.com - Shop Plutoid

What is a good benchmark?

ENCODE("hello","goodbye")) | +--+ |0 | +--+ 1 row in set (2.59 sec) Regards, Jake Johnson [EMAIL PROTECTED] __ Plutoid - http://www.plu

Re: mysqldump isn't working anymore

Still the same problem, but I am still able to select from the DB using mysql. Regards, Jake Johnson [EMAIL PROTECTED] __ Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on Rims, Car Audio, and Performance

Didn't find any fields in table 't_table'???

How do I fix this error? My tables have data. Regards, Jake Johnson [EMAIL PROTECTED] __ Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on Rims, Car Audio, and Performance Parts. -- MySQL General Mailing

Re: Didn't find any fields in table 't_table'???

Thanks for your help. I found that the permissions to the files were wrong and I had to restart mysql. I also needed to repair t_table to get things back to normal. I was scared I lost my data, but only for a second :-). Regards, Jake Johnson [EMAIL PROTECTED

How can I select the column names?

I am trying to select the column names from a table to be displayed in a web page. Is there anyway to select column names without desc? Thanks, Jake Johnson [EMAIL PROTECTED] __ Plutoid - http://www.plutoid.com - Shop Plutoid

Are Views Supported?

Hello, I was wondering when or will views be supported? -- Jake Johnson http://www.plutoid.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]