I would like to add a correction.
I have been unable to remove the table lock from the linux install with
these techniques.
> -Original Message-
> From: Power, Paul C. [mailto:[EMAIL PROTECTED]
> Sent: Thursday, May 17, 2007 12:24 PM
> To: mysql@lists.mysql.com
> Subject: quirky MySQL:
Hi guys, I wonder if there is any chance to set up replication/cluster with
different tables names on the servers (maybe using aliases for tables)
eg..
box1:
db name: base1
table name: users
box2:
db name: base1
table name: users_new
Any ideas?
Thanks in advance
--
Regards,
Ezequiel L.
OnMySQL 5.1.14-beta-community (windows) 5.1.7-beta (linux)
Consider:
CREATE TABLE
Entity
(
Entity_ID char(4) NOT NULL,
Entity_Name varchar(50) NULL,
PRIMARY KEY ( Entity_ID )
) ENGINE=InnoDB ;
now create a dumb function to use this data:
DELIMITER $$
DROP FUNCTION IF EXISTS voxin
Erich,
>Is there a way to set a prefix for each table so that
>the results come out like tablename.column?
Use a scripting or application language to automate & parameterise query
generation. SQL is just a partial computing language.
PB
-
Erich C. Beyrent wrote:
I have three tables, al
I have three tables, all of which have a 'name' column.
If I do:
select table1.*, table2.*, table3.* from
I'll end up with a result set that has three 'name' fields, but no way
to distinguish which table the field belongs to.
I know I can select individual columns like:
select table1.n