Or even phpMyAdmin ... it's a great web based admin tool for MySQL
Camden
----- Original Message -----
From: "Matt Southall" <[EMAIL PROTECTED]>
To: "CF-Linux" <[EMAIL PROTECTED]>
Sent: Monday, January 22, 2001 8:25 AM
Subject: Re[2]: Access to mySQL
> Monday, January 22, 2001 - Brett wrote:
>
> > to see what the columns look like. I've heard that myodbc does a pretty
> > good job of transferring the data, but you never know what could have
happened.
>
> I've found that when transferring from Access to MySQL you tend to
> lose "Autonumber" fields. You need to manually set these to the MySQL
> autoincrement type (can't remember the exact descriptor, sorry.. can
> find it if required). Some of the problems could be due to having
> records with blank autonumber fields... or maybe I'm just way off
> target :)
>
> I'd recommend getting hold of something like Calistra (a windows MySQL
> admin tool) if you havn't already.
>
> ------------------------------------
> Broadband Communications Ltd.
> +44 (0)115 924 7150
> http://www.broadband.co.uk/
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
