Get The Last Record from a Table


While using dbase database system we use “GO BOTTOM” to move the pointer to the last record. But how to do it when using mysql? This is how I do it:

SELECT * FROM table ORDER BY id DESC LIMIT 1;

Do you get the point?



1 comment

1 Comment Already

mygif
Shermie Said,
August 30th, 2009 @10:57 pm  

Man, you´re a genius, thanks so much for sharing!!

Related Post

Leave Your Comments Below

Please Note: All comments will be hand modified by our authors so any over offensive comments will be removed and your submitted comments will be appreared after approved

«
»
  • netino in Remove Mybrowserbar From My Browser…
  • ankara nakliye in Call to Undefined Function curl_ini…
  • chris in Remove Mybrowserbar From My Browser…
  • thisstrangegirl… in Remove Mybrowserbar From My Browser…
  • movie6 in Determine A Number Is Odd or Even
  • sjmac in Remove Mybrowserbar From My Browser…
  • Neal in Remove Mybrowserbar From My Browser…
  • clarksparts.com… in Remove Mybrowserbar From My Browser…
  • m_ologin in Extjs PHP MySQL Simple Tutorial
  • pmo in Remove Mybrowserbar From My Browser…
javascript method settimeout - * php - dompdf php - com_extcalendar php"targaradmin_events phpcpg phpcomponentscom_extcalendaradmin_events php - index php - componentscom_extcalendaradmin_events php - planning new niche site - guerra con china falun gong dompdf php - link harvester free deep access to link information seo book com - login php - disable javascript - zboardzboard php><scrisk_passex phpzeroboardzboard php - config inc phperrors php adminlogin php config php - ask_password php" targehpplaying phpcommondb phpskinzero_voteerror php - browser disable javascript - log php - countdown timer - adminlogin phpforumadminlogin php - mantislogin_page phplibadodb_liteadodbperfmodule inc php - web analytics search engine - wpomatic campaign error - parseparser php" targetparser p show_image_in_imgtag php - kathaigal pundai kathaigal pundai - mantislogin_page php - scdl assignments scdl online assignments scdl exam paper my - alphabet only - agenda php3 - product php - errors php - anonymizer proxy list free https online proxy anonymous socks - error php - docs php - proxy security suite 1 0 free trial proxy list free socks and - phphtml php phphtml phpphphtml phpphphtml php site net - weight loss wp signup php edublogs org grhyme netwpsignup php - new nimbuzz webchat 2 5 - config inc phperrors php adminlogin php docs php - skin_shopstandard3_plugin_twindowtwindow_cart php - lalitha sahasranamam lyrics lalitha sahasranamam bombay sisters - includeadmin lib inc php - 30 best magazine style blogspot blogger templates of 2010 - stphpform php - body_default phpindex php - forumindex php - ask_password php" targezero_voteask_password php - indek php*index2 phpindex php - adminincludelib module php - myevent php - mail inc phpbbs lib inc php toplist php - spidlanglang php spidlanglang php

7 Keys To Living Life Successfully
Discover the Keys that Open Doors to Living Life to the Fullest

PHP Link Cloaker: Hide Affiliate Links and Track Visitor Clicks
Hides Affiliate Links, Tracks Clicks & Clean up URLs. Easy, installer can be setup within 5 minutes on any PHP/MySQL Linux host. The secure web-based admin area centralizes management, converts links from all associate programs. Unlimited Site License.

Maternity Acupressure Guide: Easier, Shorter And Safer Birth
Best Selling Guide since 2005! Praised by Real Customers! Natural and Safe Maternity Acupressure Method for Pregnancy, Inducing Labor at Home & Getting Effective Relief from Labor Pains.

Categories

Archives