How to create database

[jusan]

Hi, I am new to MySQL. I am using visual basic 6.0 ado connection(through myodbc) to access mysql on window xp.
I would like to know:
1. Is there a way I can create a new mysql database in my program?

2. How to change data directory?
Originally, I have data for each year under different subdirectories. Does mysql only allows one data directory?

Appreicate any input!

 

[sleipnir214]

1. I'd use a "CREATE DATABASE" query. (

http://www.mysql.com/doc/en/CREATE_DATABASE.html)

2. You can only set one directory for the data store. However, every database in MySQL is stored in its own directory.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[jusan]

Thank you very much for your feedback.

I have another question concerning locking in mysql. We are in a banking scenario. We need row-level locking. Therefore I was trying to use Innodb table type. I have the following question:

1.Is record locking issued at "Select" command or "Update" command?

2.when is record locking been released?

3. If an update is not successful because other process has changed the row data, how can I resynchronize the data? I tried resync or requery and either works.


I was testing with a simple program to see how the locking works. If you can give my some help, it is greatly appreciated.

 

[sleipnir214]

Take a look here:

http://www.mysql.com/doc/en/Table_locking.html

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!