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
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> [WHERE where_defin
Howdy,
Multiple table updates are not available in MySQL. I had the same
problem and it was driving me crazy...
I suggest you try combining your nice query with some PHP code, did work
for me! :)
good luck,
Maarten Roosen
>
> -Original Message-
> From: Phil Kernick [mailto:[EMAIL PR
Mike Frederick writes:
> 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
10 matches
Mail list logo
