MSQL Database

[Ayato]

When modifying/creating mysql's databases in commands prompt does it saves automaticly? Thanks

[bradgrafelman]

In "commands prompt" ? You mean using the MySQL CLI?

If so, then I would say yes, it "saves automatically". (Okay, so InnoDB tables can have "AUTOCOMMIT" switched off, but I doubt this is true in your case.)

[cbz789]

in commands prompt

yes,it save automaticly.

but it is better if you save the modify command in *.sql

[bradgrafelman]

cbz798 wrote:

in commands prompt

That's what I'm confused about - MS-DOS, aka the "command prompt" - can not access SQL in any way... you need a CLI client for that.

cbz789 wrote:

but it is better if you save the modify command in *.sql

Really? Why's that?

[cbz789]

I'm not this mean.
Do you understand the database after some months later.
but all command in a file you can review.