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> select photos_id, caption from Photos where date = '2001-08-18';

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

  • | photos_id | caption |

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

  • | 77 | Drew & Tom |

  • | 78 | Berkeley campus |

  • | 79 | Successors |

  • | 80 | Tao of Pooh Tattoo |

  • | 81 | Mad House |

  • | 86 | Mad House |

  • | 91 | Mad House |

  • | 96 | Drew & Tom |

  • | 97 | Successors |

  • | 98 | Berkeley campus |

  • | 99 | Berkeley campus |

  • | 100 | Drew &Tom's bday |

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

  • 12 rows in set (0.00 sec)


Notes:

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