Re: [cobalt-users] Changing to MySQL

["Steve Werby" <steve-lists@xxxxxxxxxxxx>]

"Todd Kirk" <tkirk@xxxxxxxxxxxxxx> wrote:
> Have made a decision here, we are dropping Interbase. A few questions on
> MySQL for the group.

I hope you have researched this move well.  I am not very familiar with
Interbase, but it's my understanding that it has functionality and features
more consistent with PostgreSQL, which is a DB I use.

> 1. What version of MySQL are you running?

3.23.37.  3.23.28 was just released, no reason to use anything but the
latest.

> 2. What windows client GUI are you using to create table & datatypes?

I create all my SQL by hand.  A lot of people use phpMyAdmin
(http://www.phpwizards.net/) which is a PHP based web management tool.
MYSQLGUI is also pretty popular and can be run on Windows.  See
http://mysql.com/downloads/gui-clients.html.

> 3. And a quick one if anyone knows, how to make and autoincrement
datatype?

CREATE TABLE tablename (
    quiz_id INT UNSIGNED AUTO_INCREMENT NOT NULL,
    PRIMARY KEY (quiz_id)
)
AUTO_INCREMENT = 1001
;

--
Steve Werby
President, Befriend Internet Services LLC
http://www.befriend.com/