Open and Closing MySQL

[Mark Schonewille]

Hi Jim,

It won't hurt to open and immediately close a database after using  
it, but if you keep it open, you are able to refer to queries made  
earlier. My advise would be to keep the database open until you have  
finished working with it.

Best,

Mark

--

Economy-x-Talk
Consultancy and Software Engineering
http://economy-x-talk.com
http://www.salery.biz

Get your store on-line within minutes with Salery Web Store software.  
Download at http://www.salery.biz

Op 20-jan-2007, om 16:17 heeft Jim Schaubeck het volgende geschreven:

>
>
> Found the answer...open an closing db in mysql after each script is  
> fine...sorry for the newbie question.  The learning is going just  
> fine!
>
> Jim...
>
>
> On Friday, January 19, 2007, at 01:51PM, "Jim Schaubeck"  
> <schaubeck at mac.com> wrote:
>> Folks,
>> Is it good practice to close a connection to a database right  
>> after you use it (MySQL)?  I don't have a problem writing the SQL  
>> every time, I just want to make sure it doesn't hurt anything if I  
>> did it that way.
>>
>> Also, is there any more documentation somewhere on the rev  
>> commands for SQL?
>>
>> Thanks for the help,
>> Jim...