The following SQL select 5 random rows from database tables in MySQL.
SELECT myColumns FROM mytable ORDER BY RAND() LIMIT 5
Originally posted 2007-11-18 14:41:34.
005: MySQL – Selecting a set of random rows from a table
Login With Facebook
-
Categories
- Agile Development (12)
- Android (2)
- Apple and Mac (1)
- Charts In Java (7)
- Coding Standards and Practices (1)
- Continuous Integration (2)
- Cron Expressions (1)
- Dynamic Web Project (1)
- Eclipse (6)
- Extra News and Resources (4)
- Grails (1)
- Hibernate (1)
- J2EE (9)
- Java – Date Time Calendar (5)
- Java – Encryption (4)
- Java – External Commands (1)
- JAVA – Graphics 2D (6)
- Java – Performance Issues (1)
- Java Algorithms (3)
- Java And Database (2)
- Java And Office Document (1)
- Java And Unicode (1)
- Java And XML (5)
- Java Data Structure (7)
- Java Data Transfer (1)
- Java Design Patterns (1)
- Java Email (2)
- Java Excel & Spreadsheet (2)
- Java File (14)
- Java General (14)
- Java Graphics (3)
- Java GUI And Swing (3)
- Java Internationalization (2)
- Java Jokes (3)
- Java Logging (1)
- Java Network (1)
- Java Object Serialization (4)
- Java ORM (1)
- Java PDF (3)
- Java Printing (1)
- Java Reflections (3)
- Java Regular Expressions (11)
- Java Runtime (1)
- Java Scheduling (2)
- Java Security (1)
- Java Springs Framework (1)
- Java String (1)
- Java Technology (5)
- Java Thread (1)
- Java Tips (2)
- Java Unit Testing and JUnit (7)
- Java Utilities (25)
- Java Zip/Unzip (2)
- JBoss (4)
- Out Of Box (9)
- Sample SCJP Questions And Answers (1)
- Software Engineering Jokes (2)
- SQL Code (9)
- SVN (2)
- Webservice (1)
- WebSphere (3)
-
Recent Posts
- Java Tool To Compare Two Lists and Spit Out The Differences – Working Example
- Few Java Jokes
- 10 Differences Between JUnit 3.x and JUnit 4.x and why you should move to JUnit 4.x platform.
- Java Reflection Tutorial – List Methods Of A Class
- Java Thread Lifecycle
- Java 2D Graphics Example Tutorial On Paint, Gradient and Stroke
- Creating Time Series Chart With JFree Chart
- How big can a computer memory be? Here is a list of memory units from Bit to Coperbyte.
- How to increase the number of recent workspaces in the eclipse based IBM RAD (Rational Application Developer) IDE?
- How To Rename A File In Java
Most Viewed Articles
- Reading Excel File Using Java And Apache POI - 48,902 views
- Tutorial – Encryption And Decryption Using DESede (Triple DES) In Java - 24,962 views
- Writing To Excel File Using Apache POI - 23,897 views
- Java Thread Lifecycle - 16,428 views
- How To Unzip File Using Java — Simple Tutorial - 16,080 views
- List of Sample Cron Expressions To Define Simple And Complex Scheduling - 14,930 views
- Tutorial: Java DES Encryption And Decryption - 14,095 views
- How To Read DOC file Using Java and Apache POI - 12,358 views
- Read XML File In JAVA using DOM – A Simple Tutorial - 11,908 views
- Creating Dynamic Web Project With Eclipse And JBoss - 11,475 views
- Creating Gantt Chart In Java Using JFreeChart API [Example/Tutorial] - 11,198 views
- Cropping An Image In Java [Sample/Tutorial With Source Code] - 10,864 views
- Java – How To Overlay One Image Over Another Using Graphics2D [Tutorial] - 9,161 views
- Alphanumeric String Sorting In Java (Implementation) - 9,005 views
- How To Print A Text File In Java - 8,393 views
- How To Set And Get System Clipboard Contents In Java - 8,017 views
- JUnit – A Complete Java Unit Testing Example With Advance Features, Source Code and Diagram - 6,664 views
- Converting An Colored Image To A Gray Scale Using Java Graphics 2D [Example Code] - 6,151 views
- Converting Java Object To SOAP Request And Response XML - 5,975 views
- Java Joke – Chuck Norris Jokes On Java - 5,762 views