Central Indiana Linux Users Group
User: Guest Log in |  Join
MySQL Presentation
First page Back Continue Last page Overview Graphics

Command-line MySQL Client (cont.)

  • mysql> describe Photos;

  • +-----------+---------------+------+-----+------------+----------------+

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

  • +-----------+---------------+------+-----+------------+----------------+

  • | photos_id | int(11) | | PRI | NULL | auto_increment |

  • | caption | varchar(255) | YES | | no caption | |

  • | date | date | YES | | NULL | |

  • | file | varchar(255) | YES | | NULL | |

  • | MD5 | varchar(255) | YES | | NULL | |

  • | user_name | varchar(20) | YES | | unknown | |

  • | latest | timestamp(14) | YES | | NULL | |

  • +-----------+---------------+------+-----+------------+----------------+

  • 7 rows in set (0.01 sec)


Notes:

Apr. 1, 2004 2:54 pm US/Eastern