Current location - Plastic Surgery and Aesthetics Network - Plastic surgery and medical aesthetics - MYSQL randomly queries 10 records from 100-W data table, and the primary key ID is a discontinuous long integer. Is there an efficient query SQL statement?
MYSQL randomly queries 10 records from 100-W data table, and the primary key ID is a discontinuous long integer. Is there an efficient query SQL statement?
First, the program generates a random number, and then the number greater than this value is 10.

Choice? *? From where? tablename？ Where is it? id & gtxxxLIMIT？ 10 If we want to separate them, how many random numbers x 1 x2 x3 can we generate?

Choice? *? From where? tablename？ Where is it? Id>x 1 limit? 10?

Choice? *? From where? tablename？ Where is it? id & gtx2LIMIT？ 10 If there are other indexes, you can randomly choose one larger or smaller than this.

Choice? *? From where? tablename？ Where is it? uid & gtx 1？ And then what? id & gtxxx？ Limit? 10

Related articles
  • The beautiful face of girlhood is the most beautiful in the eyes of girls.
  • I have no social experience and want to learn another technology. I want to know what is the major of auto repair?
  • Character experience, Chen Huanran.
  • There are several construction companies with special qualifications in Nantong.
  • How to repair the broken motor stator?
  • A disabled woman in Shangqiu, Henan, embroidered eight horses with her feet for seven years. How do you evaluate this lady's work?
  • How to go to the pouch is the best?
  • The clown played by Jiang, the young artists who lost to reality, come on, you're not Wang Cailing.
  • What are the symptoms of herpangina?
  • Ultra-detailed and super-powerful medical beauty operation promotion plan, absolutely collected.

    • copyright 2024 Plastic Surgery and Aesthetics Network All rights reserved