Help with MySQL Please.

[yanjchan]

Hi!

I'm one of those people who learn by example, so could one of you please make an annotate a small MySQL script that would create a database, create a table, then read and insert into it?

 

All the tutorials I've seen serve to confuse me.

 

Though, if you knew of a good one, that would be nice too.

 

Thanks!

[AdRock]

go from here http://www.tizag.com/mysqlTutorial/mysqlconnection.php onwards.  They do some really easy to follow tutorials

 

you'll never learn if you don't try

 

 

[Maq]

All the tutorials I've seen serve to confuse me.

 

Hard to believe, but may be so.  Tizag certainly won't confuse, it's one of the most basic references known to man.

 

There's also plenty of examples on these forums.

 

Good luck!

[yanjchan]

I guess I didn't search well enough. 

Well, thanks for the tizag tutorial! It's very helpful.

 

However, don't I need to close the mysql connection? That's one of the only other things I remember, because it put it in bold.

[phil88]

From www.php.net/mysql_close :

 

Using mysql_close() isn't usually necessary, as non-persistent open links are automatically closed at the end of the script's execution. See also freeing resources.

 

 

So no, generally speaking, you don't need to explicitly close a mysql connection.

[Maq]

It's good practice.