itzumar
Posts: 88
|
Posted: 05/27/2014, 11:16 PM |
|
How I can insert data from one table of MySQL to another. at the same time when base table update, it should also update 2nd table. am using code chrage studio with php mysql.
_________________
Umar |
|
|
eratech
Posts: 513
|
Posted: 05/28/2014, 3:40 AM |
|
Umar -
A couple of options - you can write and execute your own custom SQL after the main record Insert;
You could also create MySQL triggers to copy the data within the database (no extra code in CCS)
Eric
_________________
CCS 3/4/5 ASP Classic, VB.NET, PHP
Melbourne, Victoria, Australia |
|
|
|