Home > database >  Code database table SQL operations of dream inside, prompt table and tried to invalid or does not ex
Code database table SQL operations of dream inside, prompt table and tried to invalid or does not ex

Time:09-27

, in front of the table name and model name, code can execute successfully, is there a familiar to dream of the great god help have a look

CodePudding user response:

Can specify a default database, the connection library, or the shema,
If you only have a library or a schema, then no problem,
If you have more, you can't make sure that your current default connection must be your want,
So in the library, schema, or you didn't specify a default connection, is the safest method in SQL, explicitly specify library or schema,

CodePudding user response:

reference 1/f, old zizhu reply:
database, the connection can be specified when the default library, or the shema,
If you only have a library or a schema, then no problem,
If you have more, you can't make sure that your current default connection must be your want,
So in the library, schema, or you didn't specify a default connection, is the safest method in SQL, explicitly specify the library or schema,

To dream database, no library, specify
  • Related