Prepare for your Next Interview
|
Welcome to the Geeks Talk forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
This is a discussion on Default MySQL table for storing data maniplation on Tables. within the MY SQL forums, part of the Databases category; IS there any default table mysql server automatically creates and manages these tables like INSERTED, DELETED table in MSSQL, DUAL table in ORACLE. I have used in mssql a query ...
|
|||||||
|
|||
|
Default MySQL table for storing data maniplation on Tables.
IS there any default table mysql server automatically creates and manages these tables like INSERTED, DELETED table in MSSQL, DUAL table in ORACLE.
I have used in mssql a query in trigger for insert operation declare trg_cursor cursor for select fname from inserted; In oracle a query in trigger for insert operation select system.clsyncseq.nextval into synchpointnumber from dual; like this i need default tables for mysql to fire a same query. I have written a trigger on table t1 for insert. When inserted a row to t1 my trigger will read the information from INSERTED, DUAL tables in case of MSSQL, ORACLE instead of table t1. The same thing I need to write for MySQL for INSERT, UPDATE, DELETE operation. Can you please direct me to achieve this? Thanks Last edited by amit_27; 05-20-2009 at 04:59 AM. Reason: Detail explanation |
| Sponsored Links |
![]() |
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Data Transfer: from Access and Excel to MySQL database | tomrust | Data Warehousing | 4 | 08-10-2009 07:41 AM |
| Restore data from MySQL Binary Log | pmsudha | MY SQL | 1 | 02-23-2009 09:18 AM |
| Move columns from different tables to one table | ajit99 | SQL | 6 | 05-16-2008 07:38 AM |
| Exforsys.com Using Oracle Database for Storing, Modifying, and Retrieving XML Data | admin | Web Design | 0 | 04-24-2008 10:21 PM |
| Storing data in db without iterating | Samudyatha | C# | 1 | 07-31-2007 10:25 AM |