sub-table-query - Related information

  • User amount flow table, how to sub-table?

    every amount change of the user is recorded in this table. website users about 100W, now the table is too big, thought of sub-table, how to divide it? Table structure! user id is a 32-bit guid ...

  • How to query the horizontal table?

    to query the data after horizontal split, suppose the data of a business is split horizontally, and the monthly records are stored in a table. The data of each table is about 1000w. There are already more than 20 tables, such as table_201606,.,table_201...

  • 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-1b35220-2bf87.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-1b35220-2bf87.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
    Need Help?