如何在MYSQL中查看所有的表名?或者一个表下的字段,刚接触,不懂
解决方案 »
- 怎么样批量修改mysql数据库字符集为gbk的?
- 请教如何监测mysql服务是否在正常运行
- mysql同步能不能不那么敏感?
- 求教MySQL_Front 配置出错
- 多表查询怎么写?
- MySQL正则表达式问题
- VB 如何动态创建MySQL数据库
- mysql不能启动
- mysqli_real_connect(),mysqli_init(),mysqli_errno()
- Mysql插入时报错Got a packet bigger than 'max_allowed_packet' bytes
- 请教一下C#如何写mySQL的接口?哪位给一个例子程序
- C#程序链接mysql 端口为3308 获取所有binlog日志文件
Database changed
mysql> show tables;
+-------------------------+
| Tables_in_test |
+-------------------------+
| arc |
| book |
| char_test |
...
+-------------------------+
24 rows in set (0.16 sec)mysql> show columns from arc;
+-------+---------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------+---------+------+-----+---------+----------------+
| Id | int(11) | NO | PRI | NULL | auto_increment |
| name | int(11) | NO | | 0 | |
+-------+---------+------+-----+---------+----------------+
2 rows in set (0.04 sec)
SELECT
`TABLES`.`TABLE_SCHEMA`, `TABLES`.`TABLE_NAME`
FROM
`information_schema`.`TABLES`
WHERE
`TABLES`.`TABLE_TYPE` = 'base table';SELECT *
FROM
`information_schema`.`COLUMNS` where `TABLE_SCHEMA`='test' and `TABLE_NAME`='arc' order by `ORDINAL_POSITION`;
mysql>show tables;