Professional Web Applications Themes

Using table from one database in another... - MySQL

Hi I wonder if there's a posibility to use table from one database that's alredy made in another database? (without copying it ) Ho can I do it? Thanks for help Leszek...

  1. #1

    Default Using table from one database in another...

    Hi

    I wonder if there's a posibility to use table from one database that's
    alredy made in another database? (without copying it )
    Ho can I do it?

    Thanks for help
    Leszek


    Leszek Guest

  2. #2

    Default Re: Using table from one database in another...

    Hi,

    you can access a table in another database by fully qualifying it, that is
    e.g.

    select * from [databasename].[tablename];

    This way, you can also join two (or more) tables from different databases.

    Markus


    Markus Popp Guest

Similar Threads

  1. #39657 [NEW]: The extended table-specification "database.table" creates errors
    By w dot kaiser at fortune dot de in forum PHP Bugs
    Replies: 5
    Last Post: November 28th, 09:53 AM
  2. #39657 [Opn]: The extended table-specification "database.table" creates errors
    By w dot kaiser at fortune dot de in forum PHP Bugs
    Replies: 0
    Last Post: November 28th, 06:29 AM
  3. Add a database as a table of information
    By fateman@hotmail.com in forum Macromedia Dreamweaver
    Replies: 3
    Last Post: July 13th, 10:07 PM
  4. Using a table from seperate database?
    By Jason Reljac in forum Microsoft SQL / MS SQL Server
    Replies: 1
    Last Post: July 9th, 07:03 PM
  5. Replies: 4
    Last Post: July 1st, 06:01 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139