Home > Database > Mysql Tutorial > mysql查表语句_MySQL

mysql查表语句_MySQL

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Release: 2016-06-01 13:35:17
Original
1402 people have browsed it

bitsCN.com

mysql查表语句

 

[sql] 

describe table_name;  

这个命令用来显示一个表格的结构  

+----------+-----------+------+-----+---------+-------+  

| Field    | Type      | Null | Key | Default | Extra |  

+----------+-----------+------+-----+---------+-------+  

| ID       | int(11)   | NO   | PRI | NULL    |       |  

| userName | char(20)  | NO   |     | NULL    |       |  

| password | char(20)  | NO   |     | NULL    |       |  

| niName   | char(20)  | NO   |     | NULL    |       |  

| sex      | char(10)  | NO   |     | NULL    |       |  

| phone    | char(20)  | YES  |     | NULL    |       |  

| address  | char(100) | YES  |     | NULL    |       |  

+----------+-----------+------+-----+---------+-------+  

  

和这个命令可以实现同样效果的是:  

show columns from table_name;  

  

show create table table_name;//显示某个表格被创建时所用的SQL语句  

  

create table user  | CREATE TABLE `user` (  

  `ID` int(11) NOT NULL,  

  `userName` char(20) NOT NULL,  

  `password` char(20) NOT NULL,  

  `niName` char(20) NOT NULL,  

  `sex` char(10) NOT NULL,  

  `phone` char(20) DEFAULT NULL,  

  `address` char(100) DEFAULT NULL,  

  PRIMARY KEY (`ID`)  

) ENGINE=InnoDB DEFAULT CHARSET=latin1   

bitsCN.com
Related labels:
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Issues
MySQL stops process
From 1970-01-01 08:00:00
0
0
0
Error when installing mysql on linux
From 1970-01-01 08:00:00
0
0
0
phpstudy cannot start mysql?
From 1970-01-01 08:00:00
0
0
0
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template