Hello All
I am new to MYSQL
till date i am using MS Access as database for my VB Projects
but now i have some project which have MySQL as backend.

my Q. are as follows:
1. What is the method to create table in MySQL
2. can i convert Access tables into MySQL tables
3. Method to connect MySQL with VB6

Thanks in Advance

Dev

On 26 Sep, 12:42, Dev <hanu...@gmail.com> wrote:
> Hello All
> I am new to MYSQL
> till date i am using MS Access as database for my VB Projects
> but now i have some project which have MySQL as backend.
>
> my Q. are as follows:
> 1. What is the method to create table in MySQL
> 2. can i convert Access tables into MySQL tables
> 3. Method to connect MySQL with VB6
>
> Thanks in Advance
>
> Dev

What do you mean by "method"?

For (1), one uses the CREATE TABLE statement, is that what you mean?

Response from Dev <hanudev@gmail.com>:

> Hello All
> I am new to MYSQL
> till date i am using MS Access as database for my VB Projects
> but now i have some project which have MySQL as backend.
>
> my Q. are as follows:
> 1. What is the method to create table in MySQL

See the manual: 12.1.10. CREATE TABLE Syntax

> 2. can i convert Access tables into MySQL tables

http://dev.mysql.com/tech-resources/...igrating-from-
microsoft.html

> 3. Method to connect MySQL with VB6

http://dev.mysql.com/downloads/connector/odbc/3.51.html

I suspect the reason you received no answers is because it is evident
you did not search for your answers first.

Good luck.

--
-Lost
Remove the extra words to reply by e-mail. Don't e-mail me. I am
kidding. No I am not.