Loading ...
Sorry, an error occurred while loading the content.

Re: get/compare data from another table

Expand Messages
  • Mahfuz-ur Rahman
    use the type of sql INSERT INTO [smaller personalized table name] (name, location, gid) SELECT name, location, 1 FROM [master table name] WHERE cid = 2
    Message 1 of 3 , Dec 22, 2012
    • 0 Attachment
      use the type of sql

      INSERT INTO [smaller personalized table name] (name, location, gid)
      SELECT name, location, 1
      FROM [master table name]
      WHERE cid = 2

      --- In phpexperts@yahoogroups.com, "Bryan Schulz" <b.schulz@...> wrote:
      >
      > hi,
      >
      > perhaps this deals more with mysql but i want to know how to get values from
      > a master table and store some of those values in smaller personalized
      > tables.
      > Bryan Schulz
      >
    Your message has been successfully submitted and would be delivered to recipients shortly.