1

Topic: Prompt where the interrogation code is stored

Probably, foolish question, but I only started to study MySQL. Before worked only in MS Access.
Explain, please, after the request to any table will be written where the code of this request will be stored? It will be stored on the server or its storage is possible only on a client part?
In Access requests are separate essence which can be stored both together with tables and in a client part and how it happens in MySQL?

2

Re: Prompt where the interrogation code is stored

ant_sol wrote:

after the request to any table will be written where the code of this request will be stored?

request? In application which will cause it on execution.

ant_sol wrote:

in Access requests are separate essence which can be stored both together with tables and in a client part

Are not present. That in this case in MS Access "request" is called, in all DBMS is called "representation" (view). In MySQL too there are representations. See CREATE VIEW.
And the present requests in Access - they "are stored" in VBA-code composition in the unit, it is stupid  the text.

3

Re: Prompt where the interrogation code is stored

Akina wrote:

it is passed...
Request? In application which will cause it on execution.

Well so that request is possible in  , and the procedure text is stored in basis mysql, the table I will not recall to unwinding.

4

Re: Prompt where the interrogation code is stored

vkle , and procedures yes tables here generally what side?

5

Re: Prompt where the interrogation code is stored

Akina, only as a possible variant of storage of the text of request.

6

Re: Prompt where the interrogation code is stored

Well it is possible  more many that - up to stupid storage of the text of request in the table. Yes only speech at the author is conducted about strictly certain type of a construction - statically saved request ready to application. And it .

7

Re: Prompt where the interrogation code is stored

Akina, in this sense yes, it agree.