SQL Query Help

= 3) I can get multiple tax amounts where an order has multiple matching records in orderdetail. I know that I can group by order.id, but what I eventually need to do is pull sum(tax) and not just tax. Is this making sense? David McInnis

RE: Query help

help David McInnis wrote: select tax from orders, orderdetail where orders.id = orderdetail.orderid and (productid = 1 or productid = 2 or productid = 3) I can get multiple tax amounts where an order has multiple matching records in orderdetail. I know that I can group by order.id, but what I

RE: Query help

[mailto:[EMAIL PROTECTED]] Sent: Friday, October 04, 2002 2:19 PM To: David McInnis Cc: [EMAIL PROTECTED] Subject: Re: Query help So you want something like: SELECT ORDERDETAIL.id as detailid, qty, unitcost, unitcost * qty as extended from ORDERDETAIL LEFT JOIN ORDERS ON orderid = ORDERS.id

Mysql Replication

and copying them to the slave server. Then I restarted the slave and now my slave database is not working. Is there something that I need to do in order to resync the slave with the new master? David McInnis Not really an SQL or query question

Getting difference between two datatime values

The following code does not work because time_to_sec() works on the 24 hour clock and cannot work between 2 days. For example a session started at 11:59 PM will not carry forward until 12:01 AM based on this logic. Does anyone have a better solution for me? David McInnis $sql

Too Many Connections

MySQL keeps locking up (I get a Too many connections error.) Is there a way that I can increase the number of connections that MySQL will take? SQL and Query David McInnis - Before posting, please check: http

RE: backup databases

Could you share your script for doing the date thing with the rest of us? That sounds useful. David McInnis -Original Message- From: Jonathan Hilgeman [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 02, 2002 10:40 AM To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED] Subject: RE: backup

Insert from select

I think that I saw a similar query last week some time but I cannot remember the sql syntax. Is it possible to insert from a select. Something like insert into table_a from select * from table_b where blah=somevalue Thanks, David McInnis

RE: MYSQL HELP

How would you use a temporary table? Is that the most efficient way? David -Original Message- From: DL Neil [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 20, 2002 11:03 AM To: Shade, Richard; [EMAIL PROTECTED] Subject: Re: MYSQL HELP Richard, Does anyone know what is wrong

RE: urgent problem with mysql and phpmyadmin

David McInnis -Original Message- From: Andrew Bunkell [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 20, 2002 5:31 PM To: [EMAIL PROTECTED] Subject: urgent problem with mysql and phpmyadmin I have created a table in the mysql db, using phpmyadmin with the following statement

InnoDM or ISAM??

I have run MySQL for the last 2 years using the default database tables. Has anyone made the migration to InnoDB? Is it stable? What are the drawbacks of using InnoDB? David McInnis sql - Before posting, please check

RE: ignoring in ORDER

You may be able to sort using a regex expression. David -Original Message- From: DL Neil [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 13, 2002 1:39 AM To: 'abdul - ÚÈÏ ÇáÑÍãä' [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: ignoring in ORDER Hi Abdul, Can Mysql ignore

RE: download MySQLdump?

It is part of the standard distributions. If you installed from any of the packaged distributions, you probably already have it. I know that it installed for me when I installed on both Linux and WindowsXP. David A McInnis Managing Editor, PRWEB -- PRWeb.com - The Free Newswire.