Geeks Talk

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.

Default MySQL table for storing data maniplation on Tables.

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 ...

Go Back   Geeks Talk > Databases > MY SQL
Register Blogs FAQ Tag Cloud Calendar Mark Forums Read
  #1 (permalink)  
Old 05-20-2009
Junior Member
 
Join Date: May 2009
Location: India
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
amit_27 is on a distinguished road
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
Reply With Quote
Sponsored Links
Reply

  Geeks Talk > Databases > MY SQL

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are On
Pingbacks are On
Refbacks are Off


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


All times are GMT -4. The time now is 03:29 PM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.3.1
Copyright © 2009 GeekInterview.com. All Rights Reserved