学步园

    SQL code   
    mysql> desc ysks;  
    +-------+---------------+-----  
    | Field | Type          | Null  
    +-------+---------------+-----  
    | 单号  | int(11)       | YES  
    | 金额  | decimal(10,2) | YES  
    | 已收  | decimal(10,2) | YES  
    | 日期  | bigint(20)    | YES  
    | 名称  | varchar(10)   | YES  
    | 余额  | decimal(10,2) | YES  
    | 备注  | varchar(10)   | YES  
    | 品名  | varchar(10)   | YES  
    +-------+---------------+-----  
    8 rows in set (0.06 sec)  
     
    mysql> select FOUND_ROWS();  
    +--------------+  
    | FOUND_ROWS() |  
    +--------------+  
    |            8 |  
    +--------------+  
    1 row in set (0.06 sec)  
     
    mysql>