Creating tables and fields in a database

[CatPlus]

Hello all:

I have just installed MySQL on my W2K server. When I open
WinMySQL Admin 1.4, under the Environment/MyODBC, I get
the following message

MyODBC
Not found

Driver Version 03.51
Driver c:\winnt\system32\myodbc3.dll
API level 2
Setup c:\winnt\system32\myodbc3.dll
SQL level 1

In Databases there are two lisitings, mysql and test

How do I create a database, say CatPlus and add tables and
fields to that table?

Please suggest a link to where I can review the setup
process

Thank you
Mickey Shekdar

 

[QatQat]

just an idea

Create database CatPlus
;
use CatPlus
;
create table table_name (
Field1 smallint not null primary key auto_increment,
Field2 data_type(length),
Field3 data_type(length)
;

and so on....




I think this will help you a lot

http://www.mysql.com/Downloads/Manual/manual.pdf-2002-07-26.zip

A better GUI, if you really want to use it, would be
MySQLCC available at

http://www.mysql.com/downloads/mysqlcc.html

Finally, if you don't know exactly what you are doing I suggest you use the production driver and not the development.

The latest stable version of MyODBC is 2.50 available at

http://www.mysql.com/products/myodbc/index.html

Enjoy and good luck with your MySQL

Bye


Qatqat

 

[CatPlus]

Thanks QatQat!

I have browsed through quite a few threads and got my
answer....!!

To load MySQL in the NT world, at c:\MySQL\BIN type:
mysqld-nt --install

This gets the MySQL service started

Then you can either use the DOS prompt commands to
create database, add tables and fields or use
MySQL-Front which I found extremely powerful

Good luck to all beginners!
Mickey

 

[QatQat]

Technically that command installs MySQL as a service on NT systems.

Good luck to you CatPlus and carry on with open source software. Next month we want to hear from you using MySQL on Linux.


Bye

Qatqat The reason why my girlfriend can read my thoughts is because mine are properly written! (G.Lepore)