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.
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 TABLES
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,
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
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
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
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
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
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
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 will,
10 matches
Mail list logo