-- Forwarded message --
From: GH <[EMAIL PROTECTED]>
Date: Sun, 12 Sep 2004 02:49:02 -0400
Subject: Re: Best way to get Access DB structures into MySQL ??
To: Chris Martin <[EMAIL PROTECTED]>
Does this also allow for the importation of the data as well?
On Sat, 11 Sep 2004 21:3
[EMAIL PROTECTED] wrote:
What is the best way to take the structure of multiple tables in Access
and get them re-created in MySQL without doing that all by hand?
Is there a way to do the equivalent of a Show Create Table in Access, that
I could then use in MySQL ??
Chris Hood
Investigator
Terry A. Haimann wrote:
Lets say I have a Database defined as
create table Photos (
PhotoIdxVarchar(20),
PhotograherIdx varchar(20),
PhotoTypeIdxvarchar(20),
CameraIdx varchar(20)
PhotoDate DateTime );
Create table Photographer (
Please disregard. Attempting to verify that I can send and receive messages
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
In the query below, I want to obtain all options_totals table records(500 or so),
except for those
users_options records where the userID=3.
i.e. Not retrieve options the user has already selected.
Have tried many combinations of joins, but get either just the records which are in
the users_op
Lets say I have a Database defined as
create table Photos (
PhotoIdxVarchar(20),
PhotograherIdx varchar(20),
PhotoTypeIdxvarchar(20),
CameraIdx varchar(20)
PhotoDate DateTime );
Create table Photographer (
PhotographerIdx va
Sorry to insist with this, but still can't find the reason.
Any ideas?
-Forwarded Message-
Hi,
I'm using MySql 4.1.4 Gamma and the following query returns
values containing N and Ñ instead of only those containing Ñ.
The query is as follows
Select Lastname from table1 where loc
Hello everybody,
MySQL was working perfectly and soudenly i get an error whan i start it
ns31129:/usr/local/mysql/bin# ./safe_mysqld --user=sql&
[1] 3115
ns31129:/usr/local/mysql/bin# Starting mysqld daemon with databases from
/usr/local/mysql/var
040911 16:11:20 mysqld ended
I cant see in the .
On Fri, 10 Sep 2004 17:49:21 -0700, Andrew Kreps wrote:
> You have a pretty good handle on what's happening there, I hope I can
> add some clarity.
>
> The Resource Id you're trying to echo is a pointer to a MySQL result
> set, you aren't actually working with the data yet. That's where the
> my
Egor Egorov <[EMAIL PROTECTED]> wrote:
>>> Then temporary give a+rw on /root/tmp (don't forget to +x /root)
>>> and see what's mysqld_safe gonna write there. Maybe it's a bug in the
>>> script.
>>> Also please check the environment for TMPDIR.
>>
>> After this mysql started successfully but it di
Andrew Wheeler <[EMAIL PROTECTED]> wrote:
> I am not sure that this is the correct list. I did not
> see any list that seemed more appropriate.
Private email answered here.
> Well if it compiling is not a "configure, make, make
> install" job perhaps you could point me in the
> direction to lea
Download yourself the trial version of Database Workbench
at www.upscene.com and try the Schema Migration tool.
Connect to Access via ADO and migrate the existing structure
to MySQL.
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
U
Christopher,
>What is the best way to take the structure of multiple tables in Access
>and get them re-created in MySQL without doing that all by hand?
>Is there a way to do the equivalent of a Show Create Table in Access, that
>I could then use in MySQL ??
The only way I know is to use a tool l
Hi all,
I have still problem with MyODBC. When I want to connect to my Database server which
is a Linux machine, it returns an error:
Client does not support authentication protocol requested by server; consider
upgrading MySQL client
I visited MySQL documents but the suggestions were about wh
Hi!
InnoDB is a MySQL table type that provides FOREIGN KEY constraints, 'ACID'
transactions, row-level locking, a non-locking consistent read (MVCC), and a
commercial online backup tool.
Release 4.0.21 is a bugfix release of the stable MySQL-4.0 branch. It is
recommended for production use. You c
15 matches
Mail list logo
