Hi,
if I try a multi table update with a Berkley DB Table, where the updated
table is bigger than the joined table, the system produces the strange "Got
error 22 from table handler" error. The attached (zipped) script should
demonstrate the problem.
Gruß,
Thomas Kathmann
[EMAIL PROTECTED]
<>
--
ajitdixit,
Wednesday, November 27, 2002, 7:44:55 PM, you wrote:
aasdcdi> I had earlier downloaded mysql-4.1.1 development branch source code and had
aasdcdi> noticed that This bug is also present in 4.1.1 development tree source code
Merge of 4.0.6 changes into 4.1 was made several days ago.
aas
Hi ,
Thanks for reply
I had earlier downloaded mysql-4.1.1 development branch source code and had
noticed that This bug is also present in 4.1.1 development tree source code
I had downloaded mysql-4.0 development source code as mentioned in mysql
documentation but could not compile it as innodb
ajitdixit,
Wednesday, November 27, 2002, 7:04:51 AM, you wrote:
aasdcdi> Result for Show Grants is as under
aasdcdi> SQL result
aasdcdi> Host: localhost
aasdcdi> SQL-query: SHOW GRANTS FOR aldixit@localhost;
aasdcdi> Grants for aldixit@localhost
aasdcdi> GRANT CREATE TEMPORARY TABLES, LOCK TAB
Hi ,
Result for Show Grants is as under
SQL result
Host: localhost
SQL-query: SHOW GRANTS FOR aldixit@localhost;
Grants for aldixit@localhost
GRANT CREATE TEMPORARY TABLES, LOCK TABLES ON *.* TO 'aldixit'@'localhost'
IDENTIFIED BY PASSWORD 'xx'
GRANT SELECT ON `mysql`.* TO 'aldixi
ajitdixit,
Tuesday, November 26, 2002, 4:18:42 PM, you wrote:
aasdcdi> I have update priviledge on all the tables mentioned in the query
aasdcdi> I am able to update one table at time with the same connection
aasdcdi> There is some more requirement or bug in mysql for multi-table update
Show me
I have update priviledge on all the tables mentioned in the query
I am able to update one table at time with the same connection
There is some more requirement or bug in mysql for multi-table update
Regards
Ajit
-
This mail sent through http://s
ajitdixit,
Tuesday, November 26, 2002, 10:33:04 AM, you wrote:
aasdcdi> I am using mysql-4.0.5a-beta on Linux Redhat 7.3 server with php-4.3.0RC1
aasdcdi> When I connect and execute my quiries as root user my query of multi-table
aasdcdi> update works fine
aasdcdi> update Stockists , areas set S
I am using mysql-4.0.5a-beta on Linux Redhat 7.3 server with php-4.3.0RC1
When I connect and execute my quiries as root user my query of multi-table
update works fine
update Stockists , areas set Stockists.a_nm = areas.aname where
Stockists.area=areas.acd
Query Executed OK , one row affected
Fraser,
Monday, October 14, 2002, 10:50:35 AM, you wrote:
FS> Does anyone have the syntax for multi-table updates?
FS> The Online Mysql manual (for version 4.0.5) only has:
FS> UPDATE [LOW_PRIORITY] [IGNORE] tbl_name
FS> SET col_name1=expr1 [, col_name2=expr2, ...]
FS
Hi All,
Does anyone have the syntax for multi-table updates?
The Online Mysql manual (for version 4.0.5) only has:
UPDATE [LOW_PRIORITY] [IGNORE] tbl_name
SET col_name1=expr1 [, col_name2=expr2, ...]
[WHERE where_definition]
[ORDER BY ...]
[LIMIT #]
Where as the other multi
to:[EMAIL PROTECTED]]
> Sent: woensdag 18 september 2002 7:36
> To: [EMAIL PROTECTED]
> Subject: Multi-table updates in MySQL
>
>
> I'm using MySQL v3.23.52.
>
> I want to update a column in one table to be based on a calculated
expression
> from a column i
I'm using MySQL v3.23.52.
I want to update a column in one table to be based on a calculated expression
from a column in another table.
Specifically I want something like this:
mysql> update a set a.f1=b.f1 where a.f2=b.f2;
mysql> update a, b set a.f1=b.f1 where a.f2=b.f2;
The first says tabl
no way to port these queries to MySQL. Let me know if you have a
> suggestion to do this.
>
> Thanks for a great product, I look forward to using it exclusively in our
> new package.
>
> Mike Frederick
> WayCool Software, Inc.
>
Hi!
Multi-table updates are commin
Hello:
I am testing a new product with MySQL, and so far have been very pleased,
especially with the performance. One enhancement that I was looking forward
to in 4.0 is described below:
Updates that run over multiple tables is harder to do in MySQL. This will,
however, be fixed in MySQL 4.0 wi
15 matches
Mail list logo
