to [table].InnoDB, but now this
does not show up on the table list.
I tried the described method as I have done this before with MyISAM tables
successfully.
What am I missing? Or is a completely invalid way to move the database?
Would a server restart fix it?
Thanks
Andy Hall.
--
MySQL General Ma
oot_table INNER JOIN table_one
ON root_table.table_one_id = table_one.table_one_id)
UNION
(SELECT root_table.col2, date
FROM root_table INNER JOIN table_two
ON root_table.table_two_id = table_two.table_two_id)
ORDER BY date
But I cant do UNION's in MySQL, so how can I do this?
Any hel
e_two.table_two_id
> where which=1 and col1 is not null
> or which=2 and col2 is not null
> order by date, which;
>
>
> From: "Andy Hall" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> > Subject: UNION equivilent required for 3.23.37
>
his query would work in MS-SQL)
There must be a way to do this, but I dont seem to be able to put my finger
on it and I would appreciate any help!
Thanks
Andy Hall.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Thanks for the query suggestions, but unfortunately none of them seem to do
the trick.
Not possible to upgrade to 4.x at the moment, so I am going to have to do it
in 2 queries; one to get the list of ID's, then create a list in PHP and
drop it into the second query.
Thanks for the help!
> >
> You need to get the conditions for the LEFT JOIN out of the WHERE clause:
>
> SELECT product_id, name, description, sales.sale_id
> FROM products
> LEFT JOIN sales ON
> products.product_id = sales.product_id WHERE
> sales.sale_id IS NULL AND
> sales.customer_id = 10
>
I lied
to set the database back (which would be messy IMO).
This project is being developed on MySQL 3.23.37.
Any help is appreciated, thanks.
Andy Hall.
want to
get it wrong, so *any* help is greatly appreciated.
Andy Hall.
> > Hi,
> >
> > I have recently had a system crash that required the
> > installation of a new hard drive. I have access to the
> > files on the old hard drive, on which is a database I
> > need to recover.
> >
> > I am running MySql 3.23.37 and all the tables in the
> > database to be recovered
MySQL.
>
> How do I restart the service manually? Would it be:
>
> /etc/rc.d/init.d/mysql restart
>
> I am using Apache web server on a Cobalt RAQ.
>
> Thanks
>
No matter, its all done. Thank you very much for your help.
Regards
Andy Hall.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
return:
idbuddy_id
1 1,3,5
2 2,3
I cant see why this wouldnt be possible but I havent found anything yet.
Thanks for any help
Andy Hall.
Never mind, I found the GROUP_CONCAT function but I am still using v. 3.23.37 so thats
that.
Looks like I'll be using PHP, unless anyone has a workaround of some kind?
Thanks
Hi,
I have a situation where, within a PHP loop, I am creating over one hundred SQL
statement (INSERTS and UPDATES).
Would it cut any overhead to send 20 ";" seperated queries in one mysql_query()
statement, and therefore only execute mysql_query() 5 times for 100 statements, as
opposed to sen
Hi,
I have a situation where, within a PHP loop, I am creating over one hundred SQL
statement (INSERTS and UPDATES).
Would it cut any overhead to send 20 ";" seperated queries in one mysql_query()
statement, and therefore only execute mysql_query() 5 times for 100 statements, as
opposed to sen
14 matches
Mail list logo
