On Fri, Jan 31, 2003 at 02:07:11PM -, Kevin Smith wrote:
Hi All,
Can anyone help me get this query working in MySQL, this was created using
Access, but it doesn't port well for MySQL syntax:
SELECT b.id, p.part_code, p.product_type, p.description, po1.options,
b.price, b.quantity,
Hi All,
Can anyone help me get this query working in MySQL, this was created using
Access, but it doesn't port well for MySQL syntax:
SELECT b.id, p.part_code, p.product_type, p.description, po1.options,
b.price, b.quantity, b.price*b.quantity AS total
FROM (products AS p LEFT JOIN
I don't know if i understood you very well, but here's a try..
mysql select * from Classes;
++-+
| ID | Name|
++-+
| 1 | XO-312 |
| 2 | PA-211a |
| 3 | XUL-001 |
++-+
3 rows in set (0.00 sec)
mysql select * from Workshops order by ClassID,Date;
First of, thanks to all who replied to my questions earlier!
Now I have another problem. I have a table of Classes and Workshops. Each
Class has a number of workshops. Each workshop has a date.
I have a query that gives me the date range of a class - the min and max
dates of its workshops.
You almost got it. Your syntax will be something like this:
UPDATE Table SET address=REPLACE(address,'#','Number') WHERE column
like%#%
When I am trying to figure out the syntax for something, I always add a
LIMIT 1 at the end so that only one record gets changed.
On Saturday, October 5,
Scott,
Saturday, October 05, 2002, 7:45:16 AM, you wrote:
SJ I have a db with slightly over 614,000 records of names and addresses. In
SJ the address column, there are quite a few records like
SJ 123 any rd # 2
SJ 319 w. 1st st # B
SJ 4321 test blvd # 42
SJ etc
SJ I want to replace all the
I have a db with slightly over 614,000 records of names and addresses. In
the address column, there are quite a few records like
123 any rd # 2
319 w. 1st st # B
4321 test blvd # 42
etc
I want to replace all the number signs with the actual word 'number'.
Is there a SQL command I can use for
Hi.
On Mon 2002-07-08 at 22:54:09 -0700, [EMAIL PROTECTED] wrote:
I'm trying to get the name of a booth or tradeshow depending on the
customer_link_type (which is an ENUM) combined with the
customer_link_table_id which tells me the index/id of the correct table
to look in. I've tried this
I'm trying to get the name of a booth or tradeshow depending on the
customer_link_type (which is an ENUM) combined with the
customer_link_table_id which tells me the index/id of the correct table
to look in. I've tried this SQL command, but it doesn't work right. I
get multiple permutations