MySQL获取表格信息_MySQL

mysql获取表格信息

天夏淘宝客程序

天夏淘宝客 是一套基于淘宝开放平台（TOP）提供的API开发出来的淘宝客推广程序，又称淘宝客网站、淘客程序、淘客源码，目前通过这套API版淘宝客程序可以按各种排序方式获取淘宝客商品列表、商家店铺列表及商品参数信息，方便易用、轻松建立淘宝客推广网站，进行淘宝客商品及店铺的推广。

下载

mysql> use test;
Database changed
mysql> show table status;
+---------------+--------+---------+------------+------+----------------+-------
------+-----------------+--------------+-----------+----------------+-----------
----------+-------------+------------+-----------------+----------+-------------
---+---------+
| Name          | Engine | Version | Row_format | Rows | Avg_row_length | Data_l
ength | Max_data_length | Index_length | Data_free | Auto_increment | Create_tim
e         | Update_time | Check_time | Collation       | Checksum | Create_optio
ns | Comment |
+---------------+--------+---------+------------+------+----------------+-------
------+-----------------+--------------+-----------+----------------+-----------
----------+-------------+------------+-----------------+----------+-------------
---+---------+
| emp           | InnoDB |      10 | Compact    |    0 |              0 |
16384 |               0 |            0 |         0 |           NULL | 2015-09-16
 16:18:06 | NULL        | NULL       | utf8_general_ci |     NULL |
   |         |
| stu_view      | NULL   |    NULL | NULL       | NULL |           NULL |
 NULL |            NULL |         NULL |      NULL |           NULL | NULL
          | NULL        | NULL       | NULL            |     NULL | NULL
   | VIEW    |
| t_depart_info | InnoDB |      10 | Compact    |    0 |              0 |
16384 |               0 |            0 |         0 |           NULL | 2015-08-23
 22:12:02 | NULL        | NULL       | utf8_general_ci |     NULL |
   |         |
| t_stu_info    | InnoDB |      10 | Compact    |    6 |           2730 |
16384 |               0 |            0 |         0 |              9 | 2015-08-23
 21:36:02 | NULL        | NULL       | utf8_general_ci |     NULL |
   |         |
| t_tea_info    | InnoDB |      10 | Compact    |    0 |              0 |
16384 |               0 |        16384 |         0 |              1 | 2015-08-23
 21:39:53 | NULL        | NULL       | utf8_general_ci |     NULL |
   |         |
+---------------+--------+---------+------------+------+----------------+-------
------+-----------------+--------------+-----------+----------------+-----------
----------+-------------+------------+-----------------+----------+-------------
---+---------+
5 rows in set (0.00 sec)

mysql>