Thread: tables

    #1
  1. No Profile Picture
    rbarsh
    Guest
    Devshed Newbie (0 - 499 posts)
    Can any one please help!
    I need to be able to select from my data base all records from "CA" (state)and all the data that is in each record (name, addrss, etc)
    That is the easy part
    what I cant do is:
    Display all the information from each state in it's on table.
    can some one please help . Thank you very much.
  2. #2
  3. No Profile Picture
    Imo
    Guest
    Devshed Newbie (0 - 499 posts)
    select * from records where state="CA";

    ?

Similar Threads

  1. Large tables or many small tables?
    By Tassadar356 in forum MySQL Help
    Replies: 4
    Last Post: February 8th, 2004, 02:07 PM
  2. tables get corrupted
    By 90coders in forum MySQL Help
    Replies: 1
    Last Post: December 5th, 2003, 06:23 AM
  3. Replies: 0
    Last Post: October 15th, 2003, 09:02 PM
  4. Synchronizing 2 tables with different field structure
    By nickcwj in forum Database Management
    Replies: 0
    Last Post: October 15th, 2003, 08:55 PM
  5. table with data from two other tables?
    By SuperShaz in forum MySQL Help
    Replies: 1
    Last Post: September 27th, 2002, 03:39 AM

IMN logo majestic logo threadwatch logo seochat tools logo