Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql>
- mysql> use vehicles;
- Reading table information for completion of table and column names
- You can turn off this feature to get a quicker startup with -A
- Database changed
- mysql>
- mysql> show tables;
- +--------------------+
- | Tables_in_vehicles |
- +--------------------+
- | vehicles |
- +--------------------+
- 1 row in set (0.00 sec)
- mysql>
- mysql> describe vehicles;
- +-------+-------------+------+-----+---------+-------+
- | Field | Type | Null | Key | Default | Extra |
- +-------+-------------+------+-----+---------+-------+
- | make | varchar(45) | YES | | NULL | |
- | model | varchar(45) | YES | | NULL | |
- | year | int(11) | YES | | NULL | |
- | phone | varchar(45) | YES | | NULL | |
- | title | varchar(45) | YES | | NULL | |
- +-------+-------------+------+-----+---------+-------+
- 5 rows in set (0.00 sec)
- mysql>
- mysql> describe vehicles.vehicles;
- +-------+-------------+------+-----+---------+-------+
- | Field | Type | Null | Key | Default | Extra |
- +-------+-------------+------+-----+---------+-------+
- | make | varchar(45) | YES | | NULL | |
- | model | varchar(45) | YES | | NULL | |
- | year | int(11) | YES | | NULL | |
- | phone | varchar(45) | YES | | NULL | |
- | title | varchar(45) | YES | | NULL | |
- +-------+-------------+------+-----+---------+-------+
- 5 rows in set (0.00 sec)
- mysql>
Advertisement
Add Comment
Please, Sign In to add comment