Styjun

Is the infant mortality rate among African-American babies in Youngstown, Ohio greater than that of babies in Iran?

The instant an accelerating object has zero speed, is it speeding up, slowing down, or neither?

What does a/.b[c][[1]] mean?

Does anyone recognize these rockets, and their location?

How would Japanese people react to someone refusing to say “itadakimasu” for religious reasons?

Can "Es tut mir leid" be used to express empathy rather than remorse?

Converting 3x7 to a 1x7. Is it possible with only existing parts?

Why are almost all the people in this orchestra recording wearing headphones with one ear on and one ear off?

How Linux command "mount -a" works

Fill the maze with a wall-following Snake until it gets stuck

What do I put on my resume to make the company i'm applying to think i'm mature enough to handle a job?

Is there any effect in D&D 5e that cannot be undone?

How useful is the GRE Exam?

How do I run a script as sudo at boot time on Ubuntu 18.04 Server?

How do I gain the trust of other PCs?

How to prevent cables getting intertwined

How could I create a situation in which a PC has to make a saving throw or be forced to pet a dog?

Why should the equality of mixed partials be "intuitively obvious"?

Basic power tool set for Home repair and simple projects

Can I drive in EU states and Switzerland with German proof of a surrendered U.S. license?

How to sort human readable size

At what temperature should the earth be cooked to prevent human infection?

On George Box, Galit Shmueli and the scientific method?

Can you cover a cube with copies of this shape?

Replication of mysql table at runtime

Compare two MySQL databasesWhich MySQL data type to use for storing boolean valuesShould I use the datetime or timestamp data type in MySQL?MySQL - UPDATE query based on SELECT QueryHow to 'insert if not exists' in MySQL?How to import CSV file to MySQL tableSQL select only rows with max value on a columnGet table names using SELECT statement in MySQLBest data type to store money values in MySQLHow to import an SQL file using the command line in MySQL?

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

0

I have a table in my MySQL for which I want to create a replica in some other database on the same MySQL instance with a different table name.

For eg
I have two database X and Y.

X contains a table by the name of A. Direct insertions takes place in this table only.

Y database will contain a table by the name of B which will contain the same data as of A.

MySQL version - 5.6

I have explored the options for copy of data. But this will not happen at runtime. I want a structure something like as soon as an insertion or updation takes place in table A, same data gets copied/updated to table B.

I also explored the option for the master-slave concept, in which it provides the copy to some other server. However, for this, a separate DB is needed but I want to be in the same DB instance.

I have no idea as to such a feature exists or not, or do I need to create such thing manually via code, or I have missed something in the above two ways which they can be modified and get the required result.

Can anyone please guide/help me with this problem? Thank you in advance.

mysql

share|improve this question

asked Mar 25 at 4:00

Tushar GandhiTushar Gandhi

10911

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Can 'Triggers' help?
  
  – Priyank Panchal
  Mar 25 at 4:10
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I think these can help. I'll explore this section too.
  
  – Tushar Gandhi
  Mar 25 at 4:16
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Triggers are a set of queries which are triggered upon some event on the table, Create, Update, Delete, etc... Check MySQL reference for more details
  
  – Priyank Panchal
  Mar 25 at 4:17
  

  
  
  
  

add a comment | 

0

I have a table in my MySQL for which I want to create a replica in some other database on the same MySQL instance with a different table name.

For eg
I have two database X and Y.

X contains a table by the name of A. Direct insertions takes place in this table only.

Y database will contain a table by the name of B which will contain the same data as of A.

MySQL version - 5.6

I have explored the options for copy of data. But this will not happen at runtime. I want a structure something like as soon as an insertion or updation takes place in table A, same data gets copied/updated to table B.

I also explored the option for the master-slave concept, in which it provides the copy to some other server. However, for this, a separate DB is needed but I want to be in the same DB instance.

I have no idea as to such a feature exists or not, or do I need to create such thing manually via code, or I have missed something in the above two ways which they can be modified and get the required result.

Can anyone please guide/help me with this problem? Thank you in advance.

mysql

share|improve this question

asked Mar 25 at 4:00

Tushar GandhiTushar Gandhi

10911

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Can 'Triggers' help?
  
  – Priyank Panchal
  Mar 25 at 4:10
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I think these can help. I'll explore this section too.
  
  – Tushar Gandhi
  Mar 25 at 4:16
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Triggers are a set of queries which are triggered upon some event on the table, Create, Update, Delete, etc... Check MySQL reference for more details
  
  – Priyank Panchal
  Mar 25 at 4:17
  

  
  
  
  

add a comment | 

I have a table in my MySQL for which I want to create a replica in some other database on the same MySQL instance with a different table name.

For eg
I have two database X and Y.

X contains a table by the name of A. Direct insertions takes place in this table only.

Y database will contain a table by the name of B which will contain the same data as of A.

MySQL version - 5.6

I have explored the options for copy of data. But this will not happen at runtime. I want a structure something like as soon as an insertion or updation takes place in table A, same data gets copied/updated to table B.

I also explored the option for the master-slave concept, in which it provides the copy to some other server. However, for this, a separate DB is needed but I want to be in the same DB instance.

I have no idea as to such a feature exists or not, or do I need to create such thing manually via code, or I have missed something in the above two ways which they can be modified and get the required result.

Can anyone please guide/help me with this problem? Thank you in advance.

mysql

share|improve this question

asked Mar 25 at 4:00

Tushar GandhiTushar Gandhi

10911

share|improve this question

asked Mar 25 at 4:00

Tushar GandhiTushar Gandhi

10911

share|improve this question

asked Mar 25 at 4:00

Tushar GandhiTushar Gandhi

10911

asked Mar 25 at 4:00

Tushar GandhiTushar Gandhi

10911

asked Mar 25 at 4:00

Tushar GandhiTushar Gandhi

10911