on 2012 Dec 06 8:30 AM
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:
Request clarification before answering.
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:
"Tables owned by a different user can be qualified by specifying the user ID. Tables owned by groups to which the current user belongs are found by default without specifying the user ID."
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
9 | |
8 | |
6 | |
6 | |
6 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.