oosrikanth Posted June 9, 2012 Share Posted June 9, 2012 (edited) i was uploading table data through toad s/w i need sql query to get last five days. which records is uploaded Edited June 9, 2012 by oosrikanth 2 Link to comment Share on other sites More sharing options...
birbal Posted June 9, 2012 Share Posted June 9, 2012 how does your date is stored? timestamp or date object? Link to comment Share on other sites More sharing options...
oosrikanth Posted June 9, 2012 Author Share Posted June 9, 2012 (edited) how does your date is stored? timestamp or date object? no timestamp or dateobjecti want also timestamp to my table date from now onwards. how to kept Edited June 9, 2012 by oosrikanth Link to comment Share on other sites More sharing options...
niche Posted June 9, 2012 Share Posted June 9, 2012 (edited) If you have phpmyadmin go to the structure tab and at the bottom of the page there's an option to add a column. That's where you add the timestamp. If no phpmyadmin you'll have to write a little script. More importantly , without a timestamp you'll have to add an id and estimate which rows you need. Edited June 9, 2012 by niche Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now