[Date Prev][Date Next][Thread Prev][Thread Next]
- Subject: Re: Can I insert into beginning of Table than end of Table
- From: Vasanta <vtanna1@...>
- Date: Fri, 5 Feb 2010 11:41:51 -0500
Thanks, this may be simple thing, may be my explanation not clear.
eventLog saved into flash file, board gets reboots, then saved file gets imported into database table, I have ROWID from 1 to 1000, because of board boot, I have new eventLog, again for this new ne, ROWID starts from 1 to 100, this new one overwrites all those first 100 which are from imported file, can I appnd instead overwrite?.
On Fri, Feb 5, 2010 at 10:43 AM, dcharno <firstname.lastname@example.org>
As several people have politely pointed out your questions have to do with SQL not Lua. Try asking people in your company who might know something about SQL, look for a friendly SQL forum or consider hiring a consultant to help you.
I found this string in sql file, does lua accepts "AFTER" instead "BEFORE"?
CREATE TRIGGER "fk_eventLog_component_ins_on_eventLog" BEFORE INSERT ON eventLog FOR EACH ROW