MySQL Tutorial/Table/Describe Table Structure - История изменений

в 13:44, 26 мая 2010

2010-05-26T13:44:56Z

Admin: 1 версия

2010-05-26T09:49:14Z

1 версия

Новая страница

== Check the created table by issuing a "describe" command==



<source lang="sql">
DESCRIBE tableName;</source>

== To verify the table structure, use a DESCRIBE statement==



<source lang="sql">
mysql>
mysql>
mysql> CREATE TABLE myTable (
-> id int,
-> first_name VARCHAR(20),
-> last_name VARCHAR(20),
-> sex CHAR(1),
-> start_date DATE,
-> end_date DATE);
Query OK, 0 rows affected (0.05 sec)
mysql>
mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| mytable |
+----------------+
1 row in set (0.00 sec)
mysql>
mysql> describe myTable;
+------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| id | int(11) | YES | | NULL | |
| first_name | varchar(20) | YES | | NULL | |
| last_name | varchar(20) | YES | | NULL | |
| sex | char(1) | YES | | NULL | |
| start_date | date | YES | | NULL | |
| end_date | date | YES | | NULL | |
+------------+-------------+------+-----+---------+-------+
6 rows in set (0.00 sec)
mysql>
mysql> drop table myTable;
Query OK, 0 rows affected (0.00 sec)
mysql></source>