When I use Sybase database I get to do this: select * from DatabaseCars.. TableKindOfCar it is the same to
select * from TableKindOfCar however you must be into that Database else does not work
Hi André.
I'm trying to understand what you are doing, and what doesn't work. But I don't get it yet.
What is the difference between what happens in Sybase and what happens in MySQL?
When I am using Sybase the query "select * from DatabaseCars.. TableKindOfCar " works differently when I use Mysql because the same query does not work... got it?
André Asantos wrote:When I am using Sybase the query "select * from DatabaseCars.. TableKindOfCar " works differently when I use Mysql because the same query does not work... got it?
Is DatabaseCars the name of your schema?
Is TableKindOfCar the name of your table?
Why are there two dots and a blank between DatabaseCars and TableKindOfCar?
You are right. The DatabaseCars is the name of Database that we are using right now and TableKindOfCar is the name of Table tha we are using.
So, about the dots I think that comes from Sybase syntax because it does not work in MySql... It is an interesting way to work because you can declare your database together during the select, got it?