I've inherited a SQLAnywhere database that somebody else created. I'm more used to MySQL. I'm able to connect and query both databases. Example of a working query for the MySQL database: { $query = DB::query('SELECT * FROM `Users`'); } Example of a working query for the SQLAnywhere database: { $query = DB::query('SELECT * FROM "EM"."Users"'); } My question is about what the 'EM.' prefix is:
|
The EM is the name of the table owner, if your user is not EM or in the group of EM you need the right to access the table and also need to address the table with the owner. From the docs:
Thanks. This helped me establish that if I log in as the user 'EM' I can now run the query like this: { $query = DB::query('SELECT * FROM "Users"'); } Which is what I wanted.
(06 Dec '12, 09:24)
MMacdonald
|