Flux rss
Search : in
By : Relevance Date Username
Statut : Not resolved

Delete SQL Table data automatically

sharonstone, on Wednesday 9 April 2008 à 16:18:45
Hello,


I am building an online job app where managers of a store can post job listings. I would like to give them the options when they post the job to have the posting up for a specified amount of time (they will be able to choose the end date, and the job will be deleted from the database). Is there a way to tell sql to delete table entries on a certain date? I was also thinking just making this a server function (create and run a bash script), but this doesn't seem like the best way. Any input would be greatly appreciated.
Configuration: Windows XP
Internet Explorer 6.0
Reply to sharonstone  Report this message to moderators Go to last message

1


  • 1    This message seems useful, vote!
  • Ce message ne vous semble pas utile, votez !
  • Report this message to moderators
kaka_2, on Wednesday 9 April 2008 à 17:29:14
Hai

It would depend on the database. MySQL has its own cron job equivalent, for example.

Outside of some sort of scheduling system, I think you'd have to owrite a stored procedure, or modify your SELECTs to include something like WHERE exp_date> SYSDATE.

Or modify your SELECTs and set up a scheduled purbe. That' probably what I'd do.
   
Reply to kaka_2

2


  • This message seems useful, vote!
  • Report this message to moderators
 Jignesh, on Monday 30 June 2008 à 08:07:46
Hello sir,

I have a one automobile project my project is forntend vb 6 and database is sql 2000. when i save all data in sql table but after some days when i checked past record then there is no record found there. data automatically deleted when new records are saved in sql table. Sir, Please give me solution as soon as possible.

Regards
Jignesh
   
Reply to Jignesh
Ask your question Reply

Résultats pour Delete SQL Table data automatically

Sqlite database always locked Hello, I'm trying to create and update a sqlite (v3.5.8) database in a c++ program. I open the database using sqlite3 *db; sqlite3_open("database.db", &db); But any time I try to access the database after the call to open, sqlite returns... en.kioskea.net/forum/affich-8371-sqlite-database-always-locked
Move Data From One Tab To Another Hello, I am not familiar with how to write macros so I am hoping someone can help me. I have data on one tab in numerous columns, the number of rows will vary. Each row of data on this tab will be categorized into Class A and Class B based on the... en.kioskea.net/forum/affich-25735-move-data-from-one-tab-to-another
Replacing data from one column to another Hello, Is anybody help me please? I need to move data from second column to first column only if there is any data in second column. More clearly speaking in column D I have integer data almost in all row, in column G there are some integer data in... en.kioskea.net/forum/affich-28961-replacing-data-from-one-column-to-another

Résultats pour Delete SQL Table data automatically

Hibernation - hiberfile.sysHibernation - hiberfile.sys The hiberfil.sys is a file running under os windows xp and windows vista. This file has been created for storing data of in the memory of hiberfil.sys located in the local disk of your computer. This is a main... en.kioskea.net/faq/sujet-582-hibernation-hiberfile-sys
Graphical interfaces for SQLiteGraphical interfaces for SQLite SQLite is a powerful database management engine found in a relatively small C programming library; it requires no monitoring and can be used with most programming languages (C, C++, Java, Python). Unlike... en.kioskea.net/faq/sujet-629-graphical-interfaces-for-sqlite
How to know who blocked/deleted you on MSNHow to know who blocked/deleted you on MSN There are many websites that claim to be able to confirm if a contact on your list has blocked you or not. These so-called block checkers do this by detecting the public status of the user who... en.kioskea.net/faq/sujet-149-how-to-know-who-blocked-deleted-you-on-msn
1 2 3 Next

Résultats pour Delete SQL Table data automatically

Need help in Excel Macro (Solved)Hello Ivan, Ive' been reading a lot of your answers and i'm quite facinated of your skill. I need to create a macro for one of my project and it involves tranferring data (row) to specific range in another work sheet. I tried to produce a... en.kioskea.net/forum/affich-17266-need-help-in-excel-macro
Simple If else Loop with hide rowHello, I'm making a spreadsheet where in I want to hide those rows when the cell in column d is not equal to the value in cell b1. I just do not know what the statements for the macro should be, since i do not know anything in VB but I think here... en.kioskea.net/forum/affich-26206-simple-if-else-loop-with-hide-row
MacroHello, Sir ,i have different table in my SQL data base.and Each Contain some feilds.I want that some field from table should be common and rest feild should be randomly generated.please tell me the way for writing the macro in exceel and SQL .so that... en.kioskea.net/forum/affich-27477-macro
1 2 3 Next

Résultats pour Delete SQL Table data automatically

Download PC Inspector File RecoveryPC INSPECTORâ„¢ File Recovery is a data recovery program that supports the FAT 12/16/32 and NTFS file systems. Finds partitions automatically, even if the boot sector or FAT has been erased or damaged Recovers files with the original time and... en.kioskea.net/telecharger/telecharger-72-pc-inspector-file-recovery
Download AutoTask 2000Why to waste time for repeating the same tasks every day on your computer. AutoTask on 2000 can carry them out automatically.When you use your PC in the home or in job, probably that you must carry out routines notably the maintenance of data,... en.kioskea.net/telecharger/telecharger-604-autotask-2000
Download TrueSafeThe loss of data or the power cut, even before you have the time to record! From frequent cases that almost everybody has already experimented. Then for not more fluently confronted with these problems, use tools of automatic maintenance. TrueSafe is... en.kioskea.net/telecharger/telecharger-750-truesafe
1 2 3 Next

Résultats pour Delete SQL Table data automatically

Spreadsheets - Introduction A spreadsheet (or spreadsheet program) is software that permits numerical data to be used and to perform automatic calculations on numbers contained in a table. It is also possible to automate complex calculations by using a large number of... en.kioskea.net/tableur/tablintro.php3
Attacks - SQL command injection SQL injection attacks are attacks against websites that rely on relational databases. In this type of site, parameters are passed to the database in the form of an SQL query. As such, if the designer does not verify the parameters passed in the SQL... en.kioskea.net/attaques/injection-commandes-sql.php3
Office Automation - Introduction The term office automation refers to all tools and methods that are applied to office activities which make it possible to process written, visual, and sound data in a computer-aided manner. Office automation is intended to provide elements which... en.kioskea.net/bureautique/burintro.php3
1 2 3 Next