Query - Related information

  • The problem of making api list Interface by thinkphp

    use thinkphp5.1x for api interface development when doing the list query interface: you want to use parameters to control the returned data of the query, roughly as follows null what exactly is my problem and is there a security risk in my wa...

    Jun.26,2021
  • The problem of mysql Multi-table continuous query

    id name relation 1 n1 r1 2 n2 r2 3 n4 r1 4 n5 r1 5 n6 r2 6 n6 r1 the relation relationship of the table is shown above where the relation field indicates the relationship between the cur...

    Mar.28,2021
  • How does the sql statement query the list of private messages?

    my need is to be able to make a list of private messages and take the last private message record. For example, the structure of the data table: id pid from_userid to_userid content time 10 a b hi 01 21 b a hello 02 3 1 a b hihi 04 40 a c test 09 5...

    Mar.04,2021
  • Mysql parallel query problem

    the business table has too much data to design 4 sub-tables, and then the requirement is to export the full data of the 4 tables. Test machine 4 cores. Start 4 threads to query at the same time, and summarize the final results. if it takes 2s for a ...

    Mar.02,2021
  • How do elasticsearch nested objects split query results?

    there are multiple items under an order. The order object is stored in the form of nested, and an order is a piece of data. order 1-> Commodity A, Commodity B, Commodity C, Commodity D order 2-> Commodity A, Commodity B, Commodity C, Commodity D. or...

  • MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
    MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1b35668-2b7e2.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
    MySQL Errno : 1021
    Message : Disk full (/tmp/#sql-temptable-64f5-1b35668-2b7e2.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
    Need Help?